0
Undo
Votes
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
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
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
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.
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!
Can you post a copy of the ical file here so I can take a quick look?
Many thanks
Tony
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!
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"
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
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!
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
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
- Page :
- 1
There are no replies made for this post yet.