[duffbeer]

ritesh wrote:

@duffbeer: What are the Create Table… stmts. of nuke_topics and cms_topics?

======

ritesh – i don't see any Create Table… stmts. of nuke_topics and cms_topics.

again, i see no errors … when i try to import, there is simply no action, no error, nothing. it's as if the action is totally ignored.

— duffbeer

[duffbeer]

ok .. here's a couple pics:

the first is what i see after i “successfully” export the table from the source db/table.

image 1:

the second is what i see after i “import” the data from the .csv to the target db/table – in this example, i see no error, but nothing was actually written to the target db/table.

image 2:

please note that the “special character” settings are identical in both the export and import operations.

note also that i “terminated” the field in this example with , and not just , because there are , in many of the actual fields of the topicname, and if i Terminate the Fields with just , this causes a false “field end” wherever there is a ,

i have tried using , and , and even ;,; for the character to Terminate a Field. none of these yield a successful import.

cheers,

duffbeer

[duffbeer]

ok i played with the “Fields” and “Lines” character definitions, and finally got an error! (errors are so much better than having no clue!) 🙂

i got:

Error No. 1064: You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'rn' ( 'topicid' ; 'topicimage' ; 'topictext' ; 'counter' ) at li

and that's all it shows!!! arrrrrgh! a partial error explanation is waaaaay worse than a whole error! 🙂

any help will be appreciated muchly. 🙂

cheers,

duffbeer

[duffbeer]

hi 🙂

i exported a table from my source db to a .csv file (i exported both with and without the column names at the top).

when i tried to “import from a .csv file” i selected the file to import, and executed the command, but nothing happened. it did not add the rows of data from the .csv file to the target table. this same result happened when trying to import both the .csv without the column names, and the .csv with the column names.

i did not select any options like overwrite, ignore, etc… all i wanted to do is append the source data to the target table.

what am i doing wrong?

i am using the enterprise trial version, to see if this app can do what i need.

so far it looks pretty but i still need to get the mission accomplished.

cheers,

duffbeer

[Author]

Posts