Page 1 of 1
[SOLVED] Errors importing a CSV file into CGCalendar
Posted: Sat Jan 11, 2014 11:55 am
by 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.
Re: Errors importing a CSV file into CGCalendar
Posted: Sat Jan 11, 2014 6:08 pm
by Dr.CSS
Did you set up a few events etc. then export them to see the format it uses..?
Re: Errors importing a CSV file into CGCalendar
Posted: Sat Jan 11, 2014 6:17 pm
by Rolf
Latest release works for me.
Re: Errors importing a CSV file into CGCalendar
Posted: Sat Jan 11, 2014 6:52 pm
by CapereSpiritum
Where is the export CSV located. Can't see it.
Re: Errors importing a CSV file into CGCalendar
Posted: Sat Jan 11, 2014 7:50 pm
by 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.
Re: Errors importing a CSV file into CGCalendar
Posted: Sun Jan 12, 2014 11:14 am
by 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
Re: Errors importing a CSV file into CGCalendar
Posted: Sun Jan 12, 2014 11:30 am
by 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.
Re: Errors importing a CSV file into CGCalendar
Posted: Sun Jan 12, 2014 12:44 pm
by 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...
Re: Errors importing a CSV file into CGCalendar
Posted: Sun Jan 12, 2014 2:09 pm
by 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.
Re: Errors importing a CSV file into CGCalendar
Posted: Sun Jan 12, 2014 7:04 pm
by 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...
Re: Errors importing a CSV file into CGCalendar
Posted: Thu Feb 06, 2014 10:52 am
by paulbaker
staartmees wrote: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