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 371 to 380 of 382 (Total: 233)

First | Prev | Next | Last

Subject

Author

Date

Re:How do you get this thing to work

[email protected]

12:09 20 Oct 2006

Re:How do you get this thing to work

gianluigi

13:40 20 Oct 2006

Re:How do you get this thing to work

[email protected]

16:05 20 Oct 2006

Re:How do you get this thing to work

gianluigi

16:40 20 Oct 2006

Object doesn't support ... 'SetEncloseField'

[email protected]

11:59 3 Oct 2006

Re:Object doesn't support ... 'SetEncloseField'

gianluigi

13:30 3 Oct 2006

CSV with " surrounding text, how to remove "

[email protected]

10:27 13 Sep 2006

Most csv's have " around every field or at the very least around the text fields, your extension should remove those, but it does not. The " are used normally to specify the start and end of the column of data in the csv, that way if a column of data has one of the column delimiters within the data it will not trigger the import to move to the next column.

Example data to import:

1,234,567,"Bob","Smith","123 Airport Road, Newland, Oregon 55000"

in that above row the whole address would still get put in one column, your import would attempt to put "123 airport road in a column, newland in the next column, and oregon 55000" in the next column, but if I was working with a 6 column table I am guessing the import would fail or error out.

also in the database I get data in a column like "bob" instead of just bob in the column. You need to add an option for field enclosure kinda like what you have for date, that will get stripped out during import.

I have a similiar extension to yours from InterAkt (but it is no longer developed since they were acquired by adobe and it was not very fast) when you set up the csv settings in theres they have a drop down with label "Fields enclosed by:" then the drop down has options for " and ' I hope this makes sense. If you need more info email me and I can send you some examples.

This is a great extension but it will not work for me this way as I can not use it on the csv I need to import and I have no control over the csv.

Thanks
Paul