Event Importer Mod Support (Modzzz)

This is the Support forum for the Event Importer mod.

Version 2.0.1 released. (See patches/version_2.0.1 folder in zip file)

Added the ability to automatically delete imported Events when batch is deleted from Admin Panel.

There are date string and time stamp options during upload.

The date string works like:

If only d/m/Y was given to 16/05/2014, its uploading as expected

But the time is taking server time. What should be used for to get 00:00 time (day start)

Could u give example of time stamp.

Thanks

Please see http://php.net/manual/en/function.date.php

Tried selecting timestamp,

giving format d/m/Y H:i:s in batch importer

16/05/2014 00:00:00 in .csv

Its not working.

Any suggestion?

@sureandhraindia - In your configuration, the Date Format should be "Date String", instead of "Timestamp".

 Thanks, working.

How to Increase "event title " max number of characters. Currently, it looks 100.

May be because of that, some events are not getting imported from .csv file during import.

Run the following query in your phpmyadmin :

ALTER TABLE `bx_events_main` CHANGE `Title` `Title` VARCHAR( 255 ) NOT NULL DEFAULT;

Thank you.

I got this error after running:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 Email me the file you are trying to import.

Sorry, I did not read properly to see that the error was actually with running the SQL. Did you copy and paste the code above or did you type it ?

I copy pasted 

PM me your CPanel or phpmyadmin login so I can run the sql statement. I cannot see how it could give such an error if copy and pasted.

Pls suggest changes to fix this

 My solution is posted above. I asked you for phpmyadmin access to run the statement myself to see why you cannot get it to work but you have not provided. I have no other suggestions.

 Sent access details.

@sureandhraindia - The issue should be resolved now.

 Thank you