DSXchange

Thanks Guys,

All working now,
David

Thanks guys, I didn't know about the before / after job routines so that helps me a lot. re the "biggest question" - Could I write a before script to rename any files 'processingFILENAME.xml' then run the DS job, then run the after job routine to move any files like 'processing*.xml' ? Tha...

Thanks for your reply.

Sorry but I'm going to have to ask what you mean by "mv" / after job area / ExecSH? Are these stages within the DS palette?

Thanks,

Hi, I have a parallel job created that looks in a folder (using 'external source' stage) for any files like ".xml". The job then uses the XML stage to parse the XML and import the data into an SQL database. That's all working, but after that how can I move the processed XML file out of the...

Thanks Ernie, got it sorted now,
David

Thanks Ernie, i've joined the premium account so that I can now read the thread, but it's taking an age to process my upgrade.

Hi Ernie,

Sorry but I don't know if that helps me. Can you comment on how I can pass parent/child keys on to the two separate database tables?

Can you provide any instruction on how to do so?

Hi Ernie, No I'm definitely using the XML stage, it's reading an XML file (correctly) and importing two database tables...below is an example of the XML (it has an associated xsd also) <batch PO> --<PO Header> ------<PO number>...</PO number> ------<Customer>...</Customer> ------<Address>...</Addres...

Thanks, but that's not what I see when I have imported the PO Header and PO Line information into two tables. e.g. the xml is presenting this (but in xml format) PO1, Customer1, Address1 POline-a, Qty-a, Product-a, Cost-a POline-b, Qty-b, Product-b, Cost-b PO2, Customer2, Address2 POline-c, Qty-c, P...

Sure sorry, The XML file is roughly in the format of: <Purchase Order 1> <PO Line 1> <PO Line 2> <Purchase Order 2> <PO Line 1> <etc> I am bringing all the <Purchase Order> information into one dB table (i.e. date, customer, store, etc), and all the 'PO Line' information into a seperate dB table (i....

Hi, I have an XML file with records that have a header, then multiple lines (repeated). I am creating a job to push this into two seperate database tables, header and detail. However, the data in the XML does not have any keys to link the detail lines to the header lines. Is there a way that Datasta...