I am developing an application and require to be able to export all of the of the data from a selected BO (Clients). There is a reference attribute which refers to another BO (Contacts).
I export the two BO's using a Process which runs :
EXPORT 'Client_ExportAll' TO '../DataExports/Client.csv'
EXPORT 'Client_Contacts_ExportAll' TO '../DataExports/Contacts.csv'
These Exports create four csv files: Clients.csv, Contacts.csv, Client_refs.csv and Contact_refs.csv.
I then require to import this data into another version of the same application.
I import to the two BO's using a Process which runs :
IMPORT Client FROM '../DataExports/Client.csv'
IMPORT RELATIONSHIPS OF Client FROM '../DataExports/Client_refs.csv'
IMPORT Client_Contacts FROM '../DataExports/Contacts.csv'
IMPORT RELATIONSHIPS OF Client_Contacts FROM '../DataExports/Contacts_refs.csv'
When the import is complete, the Clien.csv and contact.csv files have been deleted as expected but the two 'ref' files are still present.
When I open the application, the Client has been created but no reference to the Contact is present. I am using MYSQL and when I look at the tables, both tables have the data present.
Can anyone advise if I am doing this correctly.
Thansk
