So I've been working on getting Integration Manager setup to import into Project Accounting Misc Logs for a couple weeks now (I've never used Integration Manager or GP before this). I've finally got something up and working but I cannot seem to get the integration to pull all of the detail records into the detail table.
I've got a custom destination adapter setup with pa10200 as the main table and pa10201 as a child table. I've got two sources, both CSV files, a header file and a detail file. For testing purposes the header file only has the doctype, docno, padocdt, payr, bachnumb, and psmiscid fields. The detail file only has docno and pacostcatid fields. I've setup the query relationships by mapping the docno field in the header to the docno field in the detail, I've tested using relationship types 3 and 4 with the same results. The header file has 2 records, the detail file has 4 records (2 for each of the header records).
The integration runs fine but only inserts 2 records into pa10200 and 2 records into pa10201. It always inserts the pacostcatid for the last record matching the header record in the detail file.
I've recreated the integration several times, recreated the destination adapter, tried different configurations of the source adapter including: single CSV file, two CSV files, ODBC to the txt files, and ODBC to a table in a DB but always get the same result. I've tried doing this in 2 integrations - one to pa10200 and one to pa10201 but if I only integrate into one of the two tables the integration does not work and I get a "multi-step operation" error message.
Any thoughts would be greatly appreciated!
Almost forgot, this is in Integration Manager 9 (latest service pack) with GP 9.
