bronxjester
Technical User
Hi everyone,
I have started working on a project to import data into quark (version 6.1 Windows) via XML.
The XML data is generated from an Access 2003 database (see sample below)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dataroot SYSTEM "prices III rev6.dtd">
<dataroot>
<prices>
<number>AL2910 </number>
<unit_price>1.21</unit_price>
</prices>
<prices>
<number>AL2911 </number>
<unit_price>2.41</unit_price>
</prices>
In addition I created a DTD that appears to work (see below)
<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT dataroot (prices+)>
<!ELEMENT prices (number,unit_price)>
<!ELEMENT number (#PCDATA)>
<!ELEMENT unit_price (#PCDATA)>
My goal is to update sku prices in my catalog. The layout basically follows this format:
One picture per sku
Under each picture is a text box (or two)that shows sku
number and cost.
When I use the placeholders to populate the text boxes, I get a list of every sku and unit price. I need to have each box return one specific sku and its corresponding unit price for each picture.
Can anyone point me in the right direction?? Thank you in advace for your time.
I have started working on a project to import data into quark (version 6.1 Windows) via XML.
The XML data is generated from an Access 2003 database (see sample below)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dataroot SYSTEM "prices III rev6.dtd">
<dataroot>
<prices>
<number>AL2910 </number>
<unit_price>1.21</unit_price>
</prices>
<prices>
<number>AL2911 </number>
<unit_price>2.41</unit_price>
</prices>
In addition I created a DTD that appears to work (see below)
<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT dataroot (prices+)>
<!ELEMENT prices (number,unit_price)>
<!ELEMENT number (#PCDATA)>
<!ELEMENT unit_price (#PCDATA)>
My goal is to update sku prices in my catalog. The layout basically follows this format:
One picture per sku
Under each picture is a text box (or two)that shows sku
number and cost.
When I use the placeholders to populate the text boxes, I get a list of every sku and unit price. I need to have each box return one specific sku and its corresponding unit price for each picture.
Can anyone point me in the right direction?? Thank you in advace for your time.