This content has been marked as final. Show 2 replies
There is no need of using two separate DB adapter for achieving it.
You can achieve it by using only one DB adapter. All you need to do is to Import two tables, i.e. headers & line and define the relation between them. These functionality you will find while configuring DB adapter.
Thanks for that Abhi.
I actually tried that, but I'd find that I would only get the header record added properly; the multiple invoice lines would not get written to the invoice line table properly.
I found that I would either get the same invoice line added many times, or I would get null values.
I played around with the for-each statement, and I even tried creating my own xsd for the data file (instead of using the native format tool).
Any ideas what the issue might be?