Hi P
Root/Record/VendorData certainly seems to work at this end, as long as you use the XPATH parameter format. I have generated a sample document from your schema, and sent this to a file receive location that routes it to a database send port containing your query, and the tokens do get replaced correctly (and multiple records are inserted).
Note that in your build, if you change the repeating element, you’ll also need to re-insert the tokens (or delete the leading /Record). We have made some tweaks to avoid having to fix up the tokens if the repeating element is changed and allow the design-time Test function to work with these tokens, and an updated assembly is attached (as before please restart the services). However this should also work with your build.
Please try :
- Setting the repeated item with Root/Record/VendorData
- Fixing up the tokens to remove the leading /Record (or re-inserting them)
i.e. the query will be
INSERT INTO VENDORDATA_REPORT (VendorData, ScaleID, DumpDate) VALUES('LOCALXPATH(/VendorData/Data)','LOCALXPATH(/VendorData/ScaleID)','LOCALXPATH(/VendorData/DumpDate)')
(or if you reinsert the tokens with the attached component the format will be slightly different)
- Testing with the attached file (a2.xml)
Please let me know how you get on.
Thanks,
Ben.
Ben Jackson
SmartsIntegrator Technical Support