Forums :: Import/Export Tools

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Import/Export Tools

DwZone Forum Index -> Import/Export Tools

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 171 to 180 of 382 (Total: 233)

First | Prev | Next | Last

Subject

Author

Date

Re: csv Import

Victor

13:52 12 Dec 2010

Import Excel File

EnricLizondo

6:41 12 Nov 2010

Re: Import Excel File

EnricLizondo

7:06 12 Nov 2010

Importing custom DATETIME from CSV

Ryan Dunphy

15:51 6 Sep 2010

I have a CSV file that features a DATETIME field that appears as the following when opened in Excel:

09/06/2010 13:26

When I open this file in notepad, it appears as this

09/06/2010 1:26:49 PM

If I set the DB Format Date to YYYY-MM-DD, it allows me to import the data into a MYSQL database however the time is always cut off and left as this

2010-09-06 00:00:00

I'm thinking that manually adjusting the following line should fix the issue but I can't seem to figure it out:

dwzXml_CsvImport_1.SetExtraData "YYYY-MM-DD@_@true/false@_@''@_@'@_@0@_@'@_@''"

Any attempts to adjust this line just gives me this error

Incorrect datetime value: '09/06/2010 1:26:49 PM' for column 'createDate' at row 1

Is this possible or am I limited to only importing the date and not the time?

Any help would be greatly appreciated.

Cheers,

Ryan