[SOLVED] Errors importing a CSV file into CGCalendar

[CapereSpiritum]

Hi

I have a golf club site that's using CGCalendar 1.10.4 to display Golf Competitions.

The club will form a list of events for next year. I want them to do this in a CSV file that I will import later.

I've tested the sample CSV found in the CGCalendar root folder.

The test entries get entered but without Categories or Details.
The categories I'm using are:

Competitions
Competitions_Juniors
Competitions_Ladies
Competitions_Mens
Competitions_Seniors
Competitions_Singles
Competitions_Regional_Opens
Competitions_Opens

The Custom Fields work fine.

Also, I couldn't get anything to populate the 'Details' field.

My Test Import looks like this:

Code: Select all

Start time,end time,Title,summary,Description,category,Closing Date,Fees,Sponsor
2014-01-15,,Valentines Day,St Valentines Day,A description here,Competitions_Juniors,test1val,test 2 val,
2014-01-25,,April Fools,April Fools Day,A description here,Competitions_Ladies,test1vala,test 2 val,Spons 

Incase entry headers are case sensitive, I tried various options without success.

[Dr.CSS]

Did you set up a few events etc. then export them to see the format it uses..?

[Rolf]

Latest release works for me.

[CapereSpiritum]

Where is the export CSV located. Can't see it.

[staartmees]

You must update to the latest version of CGCalender. 1.10.4 and following versions have an issue with importing csv-files. This problem was solved in the latest version.

[CapereSpiritum]

Hi staartmees

Didn't realise there was a later version as I was using CMSMS 1.11.7

All upgraded now.

One thing... in the admin panel for CGCalendar, there is now a Period: selector to the right. How can I switch that off so that I can see a whole year or even ALL events entered for a particular category?

BTW... I'm just about to try the csv import now

[staartmees]

you can't turn off the period selector. To see the events for a certain category, turn show filter on; you find it at the left.

[CapereSpiritum]

Hi Guys

I've reverted back to the version without Period selector as it's totally impractical for the Golf Club committee. They MUST be able to see ALL events for a specific category for event planning purposes.

They'll have top just add the events in one at a time...

[staartmees]

In the bugtracker of CGCalendar - http://dev.cmsmadesimple.org/bug/list/623 - you can find the solutions for the importproblems of the 1.10.x-versions.

[CapereSpiritum]

Can any of you guys tell me how to display a selected category in the details display?

Tried {$category} & {$entry->category_name} & {$entry->category} which only displays a category I've deleted??? 'Competitions'

What I want to do is display the selected category such as 'Regional_Opens'...

My knowledge of php, although growing, is limited...

[paulbaker]

To see the events for a certain category, turn show filter on; you find it at the left.

That should work, but sadly there appears to be an issue with it:
http://forum.cmsmadesimple.org/viewtopi ... =7&t=69323