Update via csv file

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

Thank's for your answer.
I will try it quickly.
Regards
Roland

You are very welcome.

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

Can you post a copy of the ical file here so I can take a quick look?

Many thanks
Tony

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"

The problem could be an issue double quotes inside. Do you control how the html is added into the ical file?

Many thanks
Tony

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