cfunn

That was exactly what I needed. Thank You Craig

I will try an simplify my question. I am importing into FM6 via XML. I have a XSL sheet working. I want to set all these orders imported to a specific name, C12345. This info is not in my xml data. I want all the records I import to have this data. Can I put some instructions in my XSL so every order will have C12345. This is not coming from the source. If I can how do I write it in my XSL? Thanks for any imput. Craig

I am importing sales data into my FM6 Invoices DB I have a .XSL stylesheet and I have one small problem I need to import "C12345" into each record Something like C12345 I need this line imported into each record but it is not present in my xml that I am importing. Here is my current .XSL <?xml version='1.0' encoding='UTF-8' ?> 0 Where or how can I add the info I need? Thanks, Craig

Am I getting close?? <?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" version="1.0" encoding="iso-8859-1" indent="yes"/> <BVC2004> <Products> <xsl:for-each select="fm:ROW"> <Product> <ID>xsl:value-of select="./fm:COL[1]/fm:DATA /></ID> <InventoryAvailableQty>xsl:value-of select="./fm:COL[2]/fm:DATA /></InventoryAvailableQty> </Product> </xsl:for-each select="fm:ROW"> </Products> </BVC2004> </xsl:stylesheet>

I need to export some data from my FMP7 database. It needs to be in an XML format so I can upload it to a web based data base(my E-Commerce web Site) The only data I need is the Product ID, and the on hand count. The XML need to look like this: <BVC2004> <Products> <Product> <ID>99-1V</ID> <InventoryAvailableQty>0</InventoryAvailableQty> </Product> </Products> </BVC2004> The only data is the <id>= my produnt part number and <InventoryAvailableQty> = my on hand count. I will need to export many records at once. Thanks, cfunn