×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: How to avoid weird date format after CSV import

How to avoid weird date format after CSV import 9 years 8 months ago #27014

  • ken hussey
  • ken hussey's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
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. :(

How to avoid weird date format after CSV import 9 years 8 months ago #27019

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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

How to avoid weird date format after CSV import 9 years 8 months ago #27029

  • ken hussey
  • ken hussey's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
yep that did it. thanks.

How to avoid weird date format after CSV import 9 years 3 months ago #29196

  • Mike John
  • Mike John's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
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

How to avoid weird date format after CSV import 9 years 3 months ago #29213

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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
  • Page:
  • 1
Time to create page: 0.133 seconds