I test still various data imports. I do I create a supplier and export these. When I try to import it again I get the error:
null value in column "state" violates not-null constraint in Line 2
In the export-file exists in the the column:
with the value:
So there is the field "state" in the parter contact. They are in the table:
searched data set has the id 58.
How can I import this relation?
with best regards Sven
Did you try to import it into another database? If you did, it will tell you just that because you have not created the state_id in the new database. To import into a new database, you will need to export the state name, state_id and the state state_id/id from the first database separately and import it into the new database then when you try again to import the supplier it will not give you this error because the state_id/id would have been added to the database
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/21/13, 3:20 AM|
|Seen: 1601 times|
|Last updated: 3/16/15, 8:10 AM|