help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

[SOLVED] Import events csv function not working

[SOLVED] Import events csv function not working

7 years 5 months ago - 7 years 5 months ago
#23802
JEM 2.0

Import events csv function not working for me.
I have a events.csv file with all possible column names but fields are delimited with semicolons.
Immediately after importing I can see the events in administration area but next time I check the events are not there anymore.
In phpMyAdmin jem_events table does show the imported events but I do not see any category column in the table.
UPDATE:
Events after import get archived status
I unarchive all events
Now I think I need to set the events category because no category was imported.
I get characters encoding issues when importing with the component so I import with phpMyAdmin and the encoding issue was fixed.
Then I do manually set events categories.

How can I fix this ?
Thanks
Database Version 5.5.52-MariaDB
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_unicode_ci
PHP Version 7.0.19 FPM/FastCGI
Web Server Apache
WebServer to PHP Interface fpm-fcgi
Joomla! Version Joomla! 3.6.5 Stable
JEM 2.2.0
Last edit: 7 years 5 months ago by designt.

Please Log in or Create an account to join the conversation.

Re: [SOLVED] Import events csv function not working

7 years 5 months ago
#23804
Hi,
one problem can be importing events, that the users have other IDs. Then events don't have a proprietor.

Please Log in or Create an account to join the conversation.

Re: [SOLVED] Import events csv function not working

7 years 5 months ago - 7 years 5 months ago
#23808
Hi,

That´s not the case, every row in events table get the correct user ID.
What happens is imported events get status archived so not listed in the normal list settings.
Now I´ve update to JEM 2.1 and I thing there is a BUG with schedule events, every time I change an event I need to set the schedule again and more annoying is that all the other events get archived status.

Thanks
Database Version 5.5.52-MariaDB
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_unicode_ci
PHP Version 7.0.19 FPM/FastCGI
Web Server Apache
WebServer to PHP Interface fpm-fcgi
Joomla! Version Joomla! 3.6.5 Stable
JEM 2.2.0
Last edit: 7 years 5 months ago by designt.

Please Log in or Create an account to join the conversation.

Time to create page: 0.408 seconds