antp.be forum

I try to import database from SQL base, but find few problems.
As someone suggest import from SQL file is impossible, so only solution is export database to csv file, but it isn't so good.
That's differences in SQL i CSV files:
1) In SQL format AMC can export linebreaks, but can't import it back (insert '|').
2) In SQL AMC export " as /", but in csv breaks reading after " without checking that is end of field or not (end is "; )
3) In export file picturename is in "" as this is textfield. AMC can't read this: wants filename without ".

When in second and third i may made some replaces in any editor , in first i have no idea how i can import it.
Any chances for solution?

Try the version 3.5.1 beta of AMC (see "comments" section), as CSV import was completely rewritten, and some options were added to export.
In that version it should work correctly.

Thanks.
Works perfectly. Especially thanks for autoassing fields with headers. That really helps reimport from SQL.
I had only problem with /", but easy solve it by change it to ˝.

Can you give me an example of line with such "error"? Maybe it is something that I forgot to handle?

Line in AMC:

or the purpose of placating us while our life essence is "farmed" to fuel the Matrix's campaign

Line after export from SQL (normal CSV mode - used by me)

"or the purpose of placating us while our life essence is \"farmed\" to fuel the Matrix's campaign";

Line after export from SQL (MSExcell CSV)

"or the purpose of placating us while our life essence is ""farmed"" to fuel the Matrix's campaign";

Thanks.
I will try to handle that automatically, or add an option to chose between \" and ""