CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Drupal doesn't recognize CiviEvent date as valid argument for calendar
Pages: 1 2 [3]

Author Topic: Drupal doesn't recognize CiviEvent date as valid argument for calendar  (Read 24178 times)

mschlicting

  • Guest
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
June 08, 2009, 01:45:03 pm
Thanks for the fast response.  

Yes a regular calendar works no problem.  Additionally I cleared the cache, reinstalled date, calendar and views, then cleared the drupal cache.  Same issue.  The only other thing is Drupal and Civicrm are in seperate mySQL databases.  Synchronization is working fine.
« Last Edit: June 08, 2009, 03:10:10 pm by mschlicting »

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 05:19:19 am
I too am trying to get this to work and can't get anywhere. I did not apply any patches because i have:

Drupal 6.13
Civi 2.2.7
Date & Calendar 6.x-2.x-dev from June 20 2009 and KarenS apparently put the patch into the June 8 dev version according to http://drupal.org/node/453688?mode=2&sort=2

I create a view for CiviEvents where default display has title, start date, end date of events:
i see my events perfectly in list form

Add page view, change it to calendar and add argument of CiviEvent Start Date -- leave all defaults when adding the argument (am I supposed to change anything?)

Then I get no results and 2 errors:

    * The calendar_style style requires a Date argument.
    * The date argument date fields must be added to this query. You can exclude them if you do not want them displayed in the calendar.

OK, I'm confused: I have a date argument and it's CiviEvent Start Date, and that is also a field....what am I doing wrong?

I have read all the topics I can on this system, and most of them seem to point to using Feed API way of doing this, but in that too I am having issues. So I wanted to try and get it working this way. Suggestions appreciated!!!

jalama

  • I post frequently
  • ***
  • Posts: 176
  • Karma: 22
    • Rooty Hollow LLC
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6 and 7
  • MySQL version: 5.1
  • PHP version: 5.2.5 and 5.3
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 06:30:41 am
emilyf

can you export your view and post it here?
jim
http://www.rootyhollow.com

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 07:50:40 am
to clarify:

- should this in fact work WITHOUT setting up FeedAPI integration?

If I use feedapi integration, then the event start date in my node type that is getting populated by feedapi mapper does work as a calendar argument. all is well.

but if i just try to use views to build a civicrm_event view, then using  CiviCRM Events: Start Date  does not work as an argument...is this because it's in form of CCYYMMDD? Seems like calendar wants it in YYYY-MM format...

Clarify the above with me and then if this should still be possible without feed api, can you also verify that you are using:
CiviCRM Event Start Date
as both the field and the argument -- and for the field should I be using a custom date format?

if it still sounds like I'm doing it all right, i will export my view...thanks so much!

jalama

  • I post frequently
  • ***
  • Posts: 176
  • Karma: 22
    • Rooty Hollow LLC
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6 and 7
  • MySQL version: 5.1
  • PHP version: 5.2.5 and 5.3
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 08:07:11 am
emilyf

I should context my request.  I'm the one that developed this integration.  I've been chasing this bug for a bit to no avail.  Hence seeing your specific view (which will not export any data bout you, your seb site, or your set-up) will help me id what is causing this.

This is totally separate from Feed API, that system works to bring in the ical fee, this taps the CiviCRM database directly. 

Though now that you ask I think you have something set up wrong in your set up.

This comment leads me to believe you have the arguments set up wrong.

Clarify the above with me and then if this should still be possible without feed api, can you also verify that you are using:
CiviCRM Event Start Date
as both the field and the argument -- and for the field should I be using a custom date format?


The argument field should simply read Date:Date, not CiviCRM Start Date.

Did you copy the one that shipped with civicrm or start from scratch? 
http://www.rootyhollow.com

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 08:20:22 am
jalama,

got it! sorry about the confusion -- there are so many threads on this that it has been extremely confusing to figure out. i missed that it was an included default view, so i was trying to build from scratch and yes, was not setting the date arg correctly. after your last comment this became very clear to me. so:

- the default view is awesome and i love it; i wish i had realized that was there because i spent about 3 hours trying to do this with feed api and this is SO easy....thank you
- if i build one from scratch using just date as the arg it also works fine

thanks again!

also, i have vowed to do step-by-step instructions on civi wiki about this. i will likely do it today, and my instructions will include BOTH ways of setting this up (just using the view and using feedapi). but after seeing your view, i don't know why anyone would even want to take the trouble to set up feedapi :)

jalama

  • I post frequently
  • ***
  • Posts: 176
  • Karma: 22
    • Rooty Hollow LLC
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6 and 7
  • MySQL version: 5.1
  • PHP version: 5.2.5 and 5.3
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 08:25:14 am
I think you saw this but here's my blog post on it for inspiration

http://civicrm.org/node/557

And I agree the Feed API thing is a pain in the a**.  Tough it doe shave one advantage it is the only way you can show both CiviCRM based and Non-CiviCRM events in the same calendar.

Enjoy
http://www.rootyhollow.com

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
July 16, 2009, 09:19:44 am
Documentation started: http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Drupal+Calendar+with+CiviEvent

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
December 15, 2010, 04:22:39 pm
Hi,

I realise this is an old topic, but if I want to do the same thing for civiactivity is this the way to go?

Malks.

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Drupal doesn't recognize CiviEvent date as valid argument for calendar
December 15, 2010, 04:36:07 pm
Sorry about the noise, but just realised that there is a Date: Date (civicrm_activity) field that you can add as an argument right down the bottom of the argument list which works just fine.

Pages: 1 2 [3]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Drupal doesn't recognize CiviEvent date as valid argument for calendar

This forum was archived on 2017-11-26.