Jump to content
Sign in to follow this  
rogermax

Matching Fields for import

Recommended Posts

I am trying to import some data returned in XML format from QuickBooks qbXML. I have no trouble getting the data from the rows to import, but I really need to match up a bit of data as an identifier. The data is contained in the attributes line in the "InvoiceAddRs requestID="xxxxxxx"..." where the xx's represent the number.

Can someone tell me how to extract that item to use for a matching records import?

Attached is the actual return.

I am building this aspart of an FMP6 application Thanks

DflyReturn.zip

Share this post


Link to post
Share on other sites

You may get more response from the "Importing/Exporting" forum. This is more Online XML/XSL browser-based applications oriented.

All the best.

Garry

Share this post


Link to post
Share on other sites

ok. But I don't dare double post.

For what it is worth, I have found that extracting the attribute needed is accomplished by using the correct xpath syntax. In this case getting the right location syntax for getting up the tree to the right node then using @requestID or attribute::requestID will do the trick. Took me some time but found the answer.

For those using XML for more than import, this would be useful when an attribute might carry an ID of some sort and the user could filter the results by that data.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.