Creating an xslt for QuickBooks Pro xml data

February 7, 200322 yr

Hi,

I'm quite new to xml, so this may be a silly question, but here goes....

I'm creating a FM solution that will import data from QuickBooks, an accounting package from Intuit that has about 90% of the market for small business accounting software. I'm using the FileBooks Link plug-in (Happy Software) to exchange xml data between FM and QB.

I'm sending a query to QB that results in the creation of an xml document. I'm then importing this xml document into FM via an xslt that I've created. So far, so good.

In QuickBooks, users can make deposits into their bank account. There is data for the total amount of the deposit, as well as data for each check that makes up the deposit. For example....

[DepositRet]

[TransactionID] 1000 [/TransactionID]

[Amount] 2000.00 [/Amount]

[DepositLineRet]

[TransactionLineID] 1001 [/TransactionLineID]

[Entity]

[ListID] 12345 [/ListID]

[FullName]Doe, John[/FullName]

[/Entity]

[Amount] 1500.00 [/Amount]

[/DepositLineRet]

[DepositLineRet]

[TransactionLineID] 1002 [/TransactionLineID]

[Entity]

[ListID] 67890 [/ListID]

[FullName] Smith, Bill [/FullName]

[/Entity]

[Amount] 500 [/Amount]

[/DepositLineRet]

[/DepositRet]

(I'm using square brackets to post this message because I have a feeling that the bulletin board will get angry if I try to post the angle brackets...)

I've created an xslt file that brings this into FM as a simpe database. The problem is, I'm only getting the detail for the first item in the deposit. I'd get a record for John Doe's check, but Bill Smith's would be lost.

I need some way so that the xslt loops through each [DepositLineRet] that is nested within the [DepositRet] so that each [DepostiLineRet] becomes its own record in my FM database.

How can I do this? What resources should I look at?

I'm attaching the xslt so you can see what I'm up to. I basically just adapted this from something else, so I can't claim that I'm entirely sure what each command is doing.

Thanks for any insight,

Dan

Deposit.xslt.txt