0
Undo
Votes
Hi,
I try to import data into Jevents which I have made in an Excel sheet. I export all data to a CVS-file according to the information and scheme on your website:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
Somehow nothing happens. I tried all kind of possibilities and even copied the export data in Notepad and save this as a CSV-file. I attached my Excel files and I hope somebody can advise.
Mike
I try to import data into Jevents which I have made in an Excel sheet. I export all data to a CVS-file according to the information and scheme on your website:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
Somehow nothing happens. I tried all kind of possibilities and even copied the export data in Notepad and save this as a CSV-file. I attached my Excel files and I hope somebody can advise.
Mike
Hello,
You are missing the header rule:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
But add that and it should work.
Thanks
Tony
You are missing the header rule:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
But add that and it should work.
Thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hello,
That's an excel spreadsheet? Can you please post the .csv file you are trying to import to JEvents. What error do you get with JEvents?
Many thanks
Tony
That's an excel spreadsheet? Can you please post the .csv file you are trying to import to JEvents. What error do you get with JEvents?
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
0
Undo
Votes
Hi Tony,
The only thing I see is that no events are imported. I tried different methodes even overide all categories with a standard category. The Excel file merged all necessary fields into a sheet for the CSV-export with the format and quotes as descibed on your side. (Maybe here is a mistake?)
Anyway, you can find the CSV file attached.
The only thing I see is that no events are imported. I tried different methodes even overide all categories with a standard category. The Excel file merged all necessary fields into a sheet for the CSV-export with the format and quotes as descibed on your side. (Maybe here is a mistake?)
Anyway, you can find the CSV file attached.
Hi Mike,
That file is completely wrong. It looks nothing like the suggested:
Your file has double quotes and looks like:
Which as you can see is very very wrong. I'd suggest using Open Office since this gives you easier control on export for the enclosures and delimiters.
Many thanks
Tony
That file is completely wrong. It looks nothing like the suggested:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
"Sport","Football Match","Football Stadium","This event is just for fun","Contact Name","Whatever extra-info","20100915T150000","20100915T191500","Europe/London","FREQ=DAILY;COUNT=10;INTERVAL=3"
Your file has double quotes and looks like:
"""SCOM/De Zeehondí73 (SG) DG 2"",""SCOM/De Zeehondí73 (SG) DG 2"",""DE VEUR"",""WZC (SG) WZC DG*3 (Gemengd-D <13) - SCOM/De Zeehondí73 (SG) DG2 (Gemengd-D <13)"","""","""",""20160911T140000"",""20160911T150000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) 2"",""SCOM/De Zeehondí73 (SG) 2"",""DE VEUR"",""WZC (SG) H3 (Heren) - SCOM/De Zeehondí73 (SG) H2 (Heren)"","""","""",""20160911T153000"",""20160911T163000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) BJ1"",""SCOM/De Zeehondí73 (SG) BJ1"",""SPORTBOULEVARD"",""MNC Dordrecht BJ3 (Jongens-B <17) - SCOM/De Zeehondí73 (SG) BJ1 (Jongens-B <17)"","""","""",""20160911T163000"",""20160911T173000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) EG1"",""SCOM/De Zeehondí73 (SG) EG1"",""HOOGVLIET"",""SCOM/De Zeehondí73 (SG) EG1 (Gemengd-E <11) - De Kempvis de Kempvis EG*2 (Gemengd-E <11)"","""","""",""20160917T150000"",""20160917T160000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) DG 3"",""SCOM/De Zeehondí73 (SG) DG 3"",""HOOGVLIET"",""SCOM/De Zeehondí73 (SG) DG3 (Gemengd-D <13) - ZPB H&L Productions DG3 (Gemengd-D <13)"","""","""",""20160917T154000"",""20160917T164000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) DG 1"",""SCOM/De Zeehondí73 (SG) DG 1"",""HOOGVLIET"",""SCOM/De Zeehondí73 (SG) DG1 (Gemengd-D <13) - Katwijk DG1 (Gemengd-D <13)"","""","""",""20160917T162500"",""20160917T172500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) EG2"",""SCOM/De Zeehondí73 (SG) EG2"",""DE ROZENBURCHT"",""SCOM/De Zeehondí73 (SG) EG2 (Gemengd-E <11) - De Kempvis EG1 (Gemengd-E <11)"","""","""",""20160917T170000"",""20160917T180000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) BJ1"",""SCOM/De Zeehondí73 (SG) BJ1"",""DE ROZENBURCHT"",""SCOM/De Zeehondí73 (SG) BJ1 (Jongens-B <17) - DWF DWF BJ*1 (Jongens-B <17)"","""","""",""20160917T174000"",""20160917T184000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) EG2"",""SCOM/De Zeehondí73 (SG) EG2"",""DE HOFSTEE"",""BZC BZC EG*1 (Gemengd-E <11) - SCOM/De Zeehondí73 (SG) EG2 (Gemengd-E <11)"","""","""",""20160924T144000"",""20160924T154000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) DG 3"",""SCOM/De Zeehondí73 (SG) DG 3"",""DE HOFSTEE"",""BZC DG1 (Gemengd-D <13) - SCOM/De Zeehondí73 (SG) DG3 (Gemengd-D <13)"","""","""",""20160924T152500"",""20160924T162500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) BJ1"",""SCOM/De Zeehondí73 (SG) BJ1"",""SPORTCENTRUM BLOKWEER"",""Wiekslag BJ1 (Jongens-B <17) - SCOM/De Zeehondí73 (SG) BJ1 (Jongens-B <17)"","""","""",""20160924T164500"",""20160924T174500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) 4"",""SCOM/De Zeehondí73 (SG) 4"",""H2O"",""OZV H3 (Heren) - SCOM/De Zeehondí73 (SG) H4 (Heren)"","""","""",""20160924T174500"",""20160924T184500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) AJ1"",""SCOM/De Zeehondí73 (SG) AJ1"",""DE HOFSTEE"",""BZC AJ1 (Jongens-A <19) - SCOM/De Zeehondí73 (SG) AJ1 (Jongens-A <19)"","""","""",""20160924T174500"",""20160924T184500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) 2"",""SCOM/De Zeehondí73 (SG) 2"",""DE HOFSTEE"",""BZC H2 (Heren) - SCOM/De Zeehondí73 (SG) H2 (Heren)"","""","""",""20160924T183000"",""20160924T193000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) Dames 1"",""SCOM/De Zeehondí73 (SG) Dames 1"",""DE SNIEP"",""Z&PC De Gouwe Da3 (Dames) - SCOM/De Zeehondí73 (SG) Da1 (Dames)"","""","""",""20160924T190000"",""20160924T200000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) CM1"",""SCOM/De Zeehondí73 (SG) CM1"",""DE LANSINGH"",""BZC BZC/de Lansingh CM1 (Meisjes-C <15) - SCOM/De Zeehondí73 (SG) CM*1 (Meisjes-C <15)"","""","""",""20160924T190000"",""20160924T200000"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) 1"",""SCOM/De Zeehondí73 (SG) 1"",""SPORTCENTRUM BLOKWEER"",""Wiekslag H2 (Heren) - SCOM/De Zeehondí73 (SG) H1 (Heren)"","""","""",""20160924T190500"",""20160924T200500"",""Europe/Amsterdam"","""""
"""SCOM/De Zeehondí73 (SG) 3"",""SCOM/De Zeehondí73 (SG) 3"",""DE HOFSTEE"",""BZC H3 (Heren) - SCOM/De Zeehondí73 (SG) H3 (Heren)"","""","""",""20160924T200000"",""20160924T210000"",""Europe/Amsterdam"","""""
Which as you can see is very very wrong. I'd suggest using Open Office since this gives you easier control on export for the enclosures and delimiters.
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
0
Undo
Votes
Hi Tony,
Understood that my Excel-csv might be wrong but maybe not so very wrong as you describe, I hope
. If I copy the cells from Excel into Notepad and save them as CSV-file, all items are with quotes. The only difference is that I do not use "FREQ=DAILY;COUNT=10;INTERVAL=3" this is only for repeating events if I understood correctly.
Could you please check the attached file once more to see if it is really my data?
Understood that my Excel-csv might be wrong but maybe not so very wrong as you describe, I hope
. If I copy the cells from Excel into Notepad and save them as CSV-file, all items are with quotes. The only difference is that I do not use "FREQ=DAILY;COUNT=10;INTERVAL=3" this is only for repeating events if I understood correctly.Could you please check the attached file once more to see if it is really my data?
Hello,
You are missing the header rule:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
But add that and it should work.
Thanks
Tony
You are missing the header rule:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
But add that and it should work.
Thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
You are very welcome Mike!
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.
Members Area
Show your support
Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons
Your membership will ensure that JEvents continues to be the best events calendar for Joomla.