Data Merge Issue

[4Dcreativegroup]

I have a document that the Data Merge Feature would be perfect for. Right now I manage the pricelist (InDesign CS2), and the website XML for aclient. What I would like to do is take the XML file and export as a tab seperated file. Then use the data merge to display the data.

How do I force the data to repeat in a column like so

<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
<<Item#>> <<ItemName>> <<Price>> <<CaseCount>>
etc. etc.

Is there another plugin I should be using for this or no?

Any help would really be appreciated. This would just save a lot of time.

--
Thank You,
Frank D'Elia

[PersonasBinar]

InventoryItems
Item#
ItemName
Price
CaseCount
end

My exact wording is wrong but the XML idea is sound, I think.
You reference the same data for your pricelist as well as the web site?
Can't the site interpret the XML file and display the data how you would like in say, a table? I'm getting my head around XML, wondering why you would need a tab delimited file? Sorry if I've confused the issue.

[4Dcreativegroup]

Maybe I worded it wrong, what I have is a tab delimited file containing price info. What I want to do is use the same data so I could update the website as well as update the price list.

My problem is using the data merge feature in InDesign. How can I display the data like I described above?

--
Thanks,
Frank

[PersonasBinar]

In a text line wouldn't it be ?
<<Item#>>^t<<ItemName>>^t<<Price>>^t<<CaseCount>>hard return
'^t'=tab character
The data needs to be converted to an XML format, then the tags imported to Indesign so you can do the layout. import the XML document and you should be good to go.
As for how you do it for the web site......you got me, I'm trying to do XML in Flash and it's melting my brain.