I have create a process to export all of my Bo to a csv file. An example for each rule is:
FIND ALL Address
EXPORT Address TO 'C:/Exports/Address.csv' FOR UPDATE
The file(s) are created, example of a few lines in this case is:
Address.ID,Address.Type,Address.Postcode,Address.Contact.ID,Address.Department,Address.PurchaseOrderNumber,Address.Line3,Address.Line2,Address.Line1,Address.ContactID,Address.CountryName,Address.Country.ID
333,Office,,Contact#332,,,North Point,"Unit 705 - 06, No. 338 King's Road",Two Chinachem Exchange Square,332,Hong Kong,Countries#115
335,Office,44263,Contact#334,Order Desk,,Dortmund,Phonenix West,Konrad-Adenauer-Allee 8,334,Germany,Countries#101
Now I wish to import the data into my test db, I create a process to do this. An example of one rule is:
FIND ALL Address
IMPORT Address FROM 'c:/exports/address.csv'
IMPORT RELATIONSHIPS OF Address FROM 'c:/exports/address_refs.csv'
In the case of this BO, there are no _refs file created during the export.
When I execute the process I get the following error:
Invalid description of data column Address.PurchaseOrderNumber. Attribute PurchaseOrderNumber is defined as a shortcut. Please check object definition
In the case of this data set, the shortcut does not reference to any information - it is currently empty.
How to to solve this or work around so the export/import works correctly?
AwareIM 5.8 (1810)
