Csv import problems
By slide on Tuesday, 23 August 2016
Posted in JEvents (Free Access)
Replies 8
Likes 0
Views 2.1K
Votes 0
Hi,
I've tried to import a simple Csv file prepared as explained in your topic.
As I understand, the first row must contain the header:
"CATEGORIES","SUMMARY","LOCATION","DESCRIPTION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"


and than the lines with this data:
"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"

I created some categories, one of which was Lifestyle
When I upload the file with the exact copy of the exaple data sting and with "Lifestyle" instead of "Sport" it says:
Importing events from ical file /tmp/php0TwTza
create temp CSV conversion file in /home/myfolder/public_html/tmp
failed to auto create category "Lifestyle"

and no calendar is created. What's wrong?
Thanks!
Hello,

Can you please zip a copy of your CSV and attach it for us to look at?

Many thanks
Tony
tonyp
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Does the user doing the import have permissions to create categories within Joomla?
geraint
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Does the user doing the import have permissions to create categories within Joomla?

Yes, I have all the permissions.
slide
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Can you please zip a copy of your CSV and attach it for us to look at?

Many thanks
Tony


I attached a sample file in xls because it is not possibile to upload csv files. The xls file is the exact copy of the csv file.
slide
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
An update: this error appears when in the file is inserted a category that already exist, if I write a new category it uploads with no error BUT...
all the data of the file is uploaded as category... and not as event as would be the sense of this work.
I'm sure I'm doing something wrong, I red carefully all the info given but I don't understand what I've missed...
Thank you for your advice and help.
slide
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
we need the CSV file - you can upload it if you zip it up.

Are you saying the category is created or not? I'm a bit confused.
geraint
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Attached my CVS file for events upload.
With the sample file I'm trying to upload some event linked to a category already created in Jevent, that is Lifestyle. Uploading with this category, appears the error message
Importing events from ical file /tmp/php0TwTza
create temp CSV conversion file in /home/myfolder/public_html/tmp
failed to auto create category "Lifestyle"

If in the file, in the filed category, is inserted a category not created in Jevent, that is a new category, the upload apparently works, but it does not upload an event, but uploads all the data of the CVS file as categories....
slide
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I'm afraid that file is a mess. You have it double enclosed see:

"""Lifestyle"",""Football Match"",""Football Stadium"",""This event is just for fun"",""Contact Name"",""Whatever extra-info"",""20160915T150000"",""20160915T191500"",""Europe/London"",""FREQ=DAILY;COUNT=10;INTERVAL=3"""


So it's exiting before it can find any value. it should be:

"Lifestyle","Football Match","Football Stadium","This event is just for fun","Contact Name","Whatever extra-info","20160915T150000","20160915T191500","Europe/London","FREQ=DAILY;COUNT=10;INTERVAL=3"
tonyp
·
8 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post