By more1970 on Monday, 30 March 2015
Replies 9
Likes 0
Views 1.8K
Votes 0
I have imported my Calendar with a csv-file. After changing details in an event some event are displaying double. But when using the search the event is match once.
You can see some double events at radclub-walding.at/index.php/kalender/year.listevents/2014/11/22/- (for example So 06.04.2014).

I’m sorry for my bad English. Many thanks for any support!
Monika


PHP Version : 5.4.42-servage17
MySQL Version : 5.5.35-MariaDB-1~squeeze
Joomla : 3.4.1
component_com_jevents : 3.2.5
component_com_jce : 2.4.6
module_mod_jevents_cal : 3.2.5
module_mod_jevents_custom : 3.2.5
module_mod_jevents_filter : 3.2.5
module_mod_jevents_latest : 3.2.5
module_mod_jevents_legend : 3.2.5
module_mod_jevents_switchview : 3.2.5
plugin_content_jevents : 3.2.5
plugin_finder_jevents : 3.2.5 (not enabled)
plugin_search_eventsearch : 3.2.5
Hello,

Does the event occur over more than 1 day?

Thanks
Tony
·
Monday, 30 March 2015 23:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,
no, the are all just for one day. When the events occur over more than 1 day they should displayed not at the same day.
Any other Suggestion?
Best regards,
Monika
·
Tuesday, 31 March 2015 06:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Monika,

Can you please send me super user login details via PM to take a look at this? It seems very interesting.

Many thanks
Tony
·
Tuesday, 31 March 2015 09:15
·
0 Likes
·
0 Votes
·
0 Comments
·
I think I found the cause of your issue and have fixed it on your site - can you try re-importing the data please.
·
Wednesday, 01 April 2015 10:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Geraint,
I do not prefer to re-import the data, because I have changed in the meentime more than 400 events per hand. Do you have another idea how I can fix it? Can you please tell me what the issue is/was?
Many thanks!
Monika
·
Wednesday, 01 April 2015 11:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Changing the event data in the database will not be possible - the problem was that your imported events didn't include any end dates and the code we had for converting CSV files to iCal files (which we then import into JEvents) added a timestamp 00:00:00 to these events and the events.

What did you change by hand in the 400 events?
·
Wednesday, 01 April 2015 11:17
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Geraint,
I put the description in, because I was not able to import this. Maybe because of the tags. For exemple
<p><a title="Ergebnislisten" href="images/stories/news/2013/1103Querfeldein_StadlPaura.pdf">Ergebnislisten</a></p><p><a title="Nennliste" href="images/stories/news/2013/1102Nennung_Quer_StadlPaura_2013.pdf">Nennliste</a></p><p><a title="Ausschreibung" href="images/stories/news/2013/1103AS_Quer_Stadl_Paura.pdf">Ausschreibung</a></p>


...
Monika
·
Wednesday, 01 April 2015 11:25
·
0 Likes
·
0 Votes
·
0 Comments
·
The issue is that you have double quotes in your descriptions. Replace these with single quotes and the import should work fine.
    <p><a title='Ergebnislisten' href='images/stories/news/2013/1103Querfeldein_StadlPaura.pdf'>Ergebnislisten</a></p><p><a title='Nennliste' href='images/stories/news/2013/1102Nennung_Quer_StadlPaura_2013.pdf'>Nennliste</a></p><p><a title='Ausschreibung' href='images/stories/news/2013/1103AS_Quer_Stadl_Paura.pdf'>Ausschreibung</a></p>

a global search and replace allow you to make this change OR set your spreadsheet package to escape double quotes when saving as a CSV file.
·
Wednesday, 01 April 2015 11:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Geraint,
have many thank for your support - I will try this out at evening.
It would have been better if I asked before importing. So I have unnecessary employed two people. Sorry for this.
Monika
·
Wednesday, 01 April 2015 11:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post