Export With Problems

[Rodrigo S]

When i export data with version 5.x and choice the fixed field, the export put the fields in the same order that i type in table. When i export with the 6.x version, the sqlyog put in my csv file any format.

Atte.

Rodrigo S.

e-mail: [email protected]

[peterlaursen]

I do not understand what is the 'any format'

… press any key ….. eehhhh where is the 'any key' ? 🙂

(I know this was an old and bad joke!)

Please provide a more detailed example.  Attach screenshot of the export dialogue and resulting CSV files.  And be careful to tell exactly what matches what and what 

rogram version is used!

… but before that also please upgrade to 6.04 if you did not allready .  I think I recall such issue in 6.0 and possibly 6.01 …

[Rodrigo S]

in the attached picture, the first print screen is when i export to csv format with sqlyog version 5.23 this is ok, is the structure of the table.

in the below image is when i export to csv format with sqlyog 6.04 this is not ok. Is not structure of the table.-

in the export picture, you can see the screen that i use to export.-

[peterlaursen]

First screenshot .. what program is that?

[Rodrigo S]

The first screen is the csv file open with ultraedit.

In the top is version 5.32 this is OK, in the low part of screen is the version 6.04 this is not ok.

[peterlaursen]

I still do not understand!

“Is not structure of the table”  CSV conatins only data, no structure (except that column names can be in first line)!

Please provide a 'reproducable test case':

1) Create a small table, DUMP it, zip and attach here.

2) Also attach two CSV-files for every SQLyog version we are talking about

3) attach a screenshot of your export settings.

[Author]

Posts