TOPIC: How to avoid weird date format after CSV import

I have Hotspot pro version. 3.62. I imported about 500 hotspots and when it publishes I get a weird date "created by on 30-11--0001" which wouldn't be so bad if the date existed in the current century. this problem for me shows up in the info window as well as recent hotspots module. since im a newbie and cant really do much MySQL. is there a way I can avoid this during the import of another csv file I want to import or is this just a matter of an annoying default in phpmyadmin? it would seem logical to just edit the date in the column label: publish or modify or created and hit go. thanks for your help.
also it interesting to note that when I browse the hot spot markers at the database I see a 0000-00-00 date format throughout which makes me think I imported wrong.

Hey Ken,
The date in the CSV file should have a mysql compatible format:
2014-03-27 09:50:40

If the csv has this format, then the date should be shown as expected.

Regards,
Daniel

yep that did it. thanks.

Hi folks,
I have read the topic about importing via CSV file, but that referre to an old version.
I have Hotspots Professional 4.2.4 .

Would it be possible for someont to post a sample CSV file, and maybe some basic instructions for the import?
I am reasonably familiar with myphpadmin.

thanks.
Mike

Hey Mike,
It's the same for hotspots 4.2.4. Just make sure that you match the columns to the csv fields correctly.

Regards,
Daniel