Re: [web2py] mysql import from csv problem

2019-02-20 Thread Ben Duncan
I Can't speak for MySql, only for Postgres. In our MAJOR conversion from Informix to Postgres, we simple put a place holder. Since we used pipes as delimiters, it looked something like this: NAME|ADDRESS1||CITY|STATE|ZIP|PHONE1||AGE|BIRTHDATE| (etc...) where there was nothing for address 2 , or

[web2py] mysql import from csv problem

2019-02-19 Thread Andrea Fae'
Hello, when I import with this procedure https://www.pythonanywhere.com/forums/topic/1288/ from csv to mysql, it alter the ids of some related tables and I have data not corresponding to the original exported csv. What can I do? What is my error? is it depending on charset or something related?