Additional issues:
Importing a CSV with recursive relationship to same table:
- Consider a (simplified) parts manifest, where one part may contain another part the BO would look like:
PartsManifest.PartNo
PartsManifest.Name
PartsManifest.psContainedIn
PartsManifest.pmContain
If you tried to import the full chain by CSV you will experience unexpected NULL values for a part that is not contained in anything eg.
Code: Select all
PartsManifest.PartNo, PartsManfest.Name, PartManifest.psContainedIn.Code
0001, Car, NULL,
3000, Engine, 0001,
3100, Gearbox, 3000,
This does not produce a table like this:
Code: Select all
PartNo, Name, Code
0001, Car,
3000, Engine, 0001
But instead creates another NULL record and tries to associate the 0001 with it like this:
Code: Select all
PartNo, Name, Code
NULL, NULL, NULL
0001, Car, NULL
3000, Engine, 0001
Load records without a relationship first and without the psContainedIn relationship at all, AIM will not understand NULL for this attribute type