Primary reference to the header record being overwritten.

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1


Posts: 1
Joined: Wed Sep 23, 2015 2:13 pm

Post by jg123 » Wed Oct 07, 2015 1:50 pm
I have a project set to read the xml and insert the data values into database table.
xml file is somewhat like this :

<?xml version="1.0" encoding="UTF-8"?>
<CHARGE_TYPE>weighing station</CHARGE_TYPE>
i have to read the values of header and details and insert it into the respective tables.
I generate a primary key for header and detail and the header_id is the foreign key in the details table.
if there is only one charge, it works like a charm , but if there are multiple charges reported , then I am loosing the header_id craeted if the first rowset.

not sure how to proceed.

but if there are multiple charges, then

so in the above scenario,
i should expect to see data like this :
hdrid partner , col1, col2
10 abc charge1 somethign
11 abc charge2 somethignelse

details_charge_table should have :
id hdrid charge_type charge_amount
1 10 xyz 2
2 10 hij 3
3 11 rst 10
4 11 klm 6

whereas what is happening is :
header table reflects the correct records, but details table gets the foreign key as 11 for all of the rows.

any help will be appreciated.


Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Wed Oct 07, 2015 5:55 pm

To further help you ... we need to see the Project XML, the Job Log run in Debug Mode and if possible, a working XML Example that we can test with.

We also need to know what company you're with so that we can tag this as a support call for them.

Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1