By Guest on Tuesday, 10 April 2018
Replies 8
Likes 0
Views 1.3K
Votes 0
Hi dears,
I use, for the moment, the free version of jevent.
What I would like to do is to import a csv file and use scripted update via cron table, to create or modify a event (at least calendar, other informations work with sql update).
I guess if it exist it is a paid feature, but witch extension make my dream possible ?
Thank's
Hello,

This is completely possible out of the box you will be happy to know!

Follow this:
https://www.jevents.net/news/item/simple-exporting-and-importing-of-events-new-video

Ignore the ical references and instead think of it as CSV.

For the Export part, you need to create a JEvents List Of Events menu item and set to .csv export as its option.

Many thanks
Tony
·
Tuesday, 10 April 2018 14:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank's for your answer.
I will try it quickly.
Regards
Roland
·
Tuesday, 10 April 2018 14:48
·
0 Likes
·
0 Votes
·
0 Comments
·
You are very welcome.
·
Tuesday, 10 April 2018 16:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,
I did it, it work fine
The only problem I have is with html field id description. it truncate the imported field after un line feed
Any idea ?
Thank's
Roland
·
Thursday, 12 April 2018 00:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Can you post a copy of the ical file here so I can take a quick look?

Many thanks
Tony
·
Thursday, 12 April 2018 07:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank's a lot for your help
here is the first line of the csv file and what it result in joined image

"CATEGORIES","SUMMARY","DESCRIPTION","LOCATION","CONTACT","X-EXTRAINFO","DTSTART","DTEND","TIMEZONE","RRULE"
"Autres rendez-vous","ACCUEIL","<div><font color=""#0072BC""><strong>Club de l’Âge d’Or</strong></font></div>

<div><font color=""#0072BC""><strong>Permanence lundi et jeudi, de 14h00 à 17h00</strong></font></div>

<div>Salle municipale « le Sextant »</div>

<div>1413 avenue de Proven","SEXTANT","PALERMO Ange","{4110} / {4100}","20180101T140000","20180101T170000","Europe/Paris","FREQ=WEEKLY;COUNT=999;INTERVAL=1;BYDAY=MO"
"Autres rendez-vous","ACCUEIL","<div><font color=""#0072BC""><strong>Club de l’Âge d’Or</strong></font></div>

<div><font color=""#0072BC""><strong>Permanence lundi et jeudi, de 14h00 à 17h00</strong></font></div>

<div>Salle municipale « le Sextant »</div>

<div>1413 avenue de Proven","SEXTANT","NOM Prenom","{4140} / {4100}","20180101T140000","20180101T170000","Europe/Paris","FREQ=WEEKLY;COUNT=999;INTERVAL=1;BYDAY=TH"
·
Thursday, 12 April 2018 17:21
·
0 Likes
·
0 Votes
·
0 Comments
·
The problem could be an issue double quotes inside. Do you control how the html is added into the ical file?

Many thanks
Tony
·
Monday, 16 April 2018 22:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,
it's an export from Ms-Access throw a request.
I think the problem has no solution like that.
In fact, the field is memo type (no size limit) but the request export the field like the first lines are.
If first line is empty or less that 255 signs, the line containing more than 255 signs will be truncated at 255 signs.
So, if not truncated here, it will be at 255 signs.

I will do another way, having a content with the description text, and just export a link in the jevent description field.
Like that no problem it work fine (I have two other type of event that work like that)

Thank's a lot for your help
Regards
Roland
·
Tuesday, 17 April 2018 21:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post