Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

basic xml - add rowdata problem

Status
Not open for further replies.
mparrett

mparrett

Technical User
Feb 22, 2007
1
ES
i have an xml file exported from a program im using, i simply want to add new articles by adding additional rowdata.

what program can i use to view this in table form / add rowdata / and export in exactly the same format so the program understads.

code of the xml file:

<?xml version="1.0" encoding="UTF-8" ?>
- <DATAPACKET Version="2.0">
- <METADATA>
- <FIELDS>
<FIELD attrname="APLICAR_RETENCION" fieldtype="i2" required="true" />
<FIELD attrname="AUTO_ENSAMBLAJE_KIT" fieldtype="i2" required="true" />
<FIELD attrname="CANTIDAD1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CANTIDAD2" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CANTIDAD3" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CANTIDAD4" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CANTIDAD5" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CANTIDAD6" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="CODIGO_DE_BARRAS" fieldtype="string" WIDTH="30" />
<FIELD attrname="CUENTA_CONTABLE3_COMPRAS" fieldtype="string" WIDTH="3" />
<FIELD attrname="CUENTA_CONTABLE3_VENTAS" fieldtype="string" WIDTH="3" />
<FIELD attrname="CUENTA_CONTABLE4_COMPRAS" fieldtype="string" WIDTH="30" />
<FIELD attrname="CUENTA_CONTABLE4_VENTAS" fieldtype="string" WIDTH="30" />
<FIELD attrname="CUENTA_CONTABLE5_COMPRAS" fieldtype="string" WIDTH="30" />
<FIELD attrname="CUENTA_CONTABLE5_VENTAS" fieldtype="string" WIDTH="30" />
<FIELD attrname="DESCUENTO1_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="DESCUENTO2_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="DESCUENTO3_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="DESCUENTO4_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="DESCUENTO5_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="DESCUENTO6_1" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="GESTIONA_CAJAS" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_MEDIDAS_UNIDADES" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_MEDIDAS_VOLUMEN" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_MEDIDAS" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_PROPIEDADES" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_STOCKS" fieldtype="i2" required="true" />
<FIELD attrname="GESTIONA_TARA" fieldtype="i2" required="true" />
<FIELD attrname="GRAFICOS" fieldtype="bin.hex" SUBTYPE="Binary" WIDTH="1" />
<FIELD attrname="MEDIDAS_ALTO" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="MEDIDAS_ANCHO" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="MEDIDAS_LARGO" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="MEDIDAS_UNIDADES" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="NOMBRE" fieldtype="string" required="true" WIDTH="200" />
<FIELD attrname="NOTAS" fieldtype="bin.hex" SUBTYPE="Text" WIDTH="1" />
<FIELD attrname="PRECIO1_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO1" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO2_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO2" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO3_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO3" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO4_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO4" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO5_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO5" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO6_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PRECIO6" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP1_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP1" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP2_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP2" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP3_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP3" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP4_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP4" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP5_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP5" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP6_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP6" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP7_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP7" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP8_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP8" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP9_IVA" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="PVP9" fieldtype="fixedFMT" required="true" DECIMALS="6" WIDTH="15" />
<FIELD attrname="REFERENCIA" fieldtype="string" required="true" WIDTH="30" />
<FIELD attrname="STOCK_ACTUAL" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCK_CAJAS" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCK_PDTE_FABRICAR" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCK_PDTE_RECIBIR" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCK_PDTE_SERVIR" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCK_TOTAL" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="STOCKS_AVISAR" fieldtype="i2" required="true" />
<FIELD attrname="TARA" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="TIENE_COMPONENTES" fieldtype="i2" required="true" />
<FIELD attrname="TIPO_IVA" fieldtype="fixedFMT" required="true" DECIMALS="2" WIDTH="15" />
<FIELD attrname="UNIDADES_POR_CAJA" fieldtype="fixedFMT" required="true" DECIMALS="4" WIDTH="15" />
<FIELD attrname="ID_ARTICULO" fieldtype="string" WIDTH="90" />
<FIELD attrname="ID_ARTICULO_FAMILIA" fieldtype="string" WIDTH="90" />
<FIELD attrname="ID_ARTICULO_GAMA" fieldtype="string" WIDTH="90" />
<FIELD attrname="ID_ARTICULO_GRUPO" fieldtype="string" WIDTH="90" />
</FIELDS>
<PARAMS />
</METADATA>
- <ROWDATA>
<ROW APLICAR_RETENCION="0" AUTO_ENSAMBLAJE_KIT="0" CANTIDAD1="0.0000" CANTIDAD2="0.0000" CANTIDAD3="0.0000" CANTIDAD4="0.0000" CANTIDAD5="0.0000" CANTIDAD6="0.0000" DESCUENTO1_1="0.0000" DESCUENTO2_1="0.0000" DESCUENTO3_1="0.0000" DESCUENTO4_1="0.0000" DESCUENTO5_1="0.0000" DESCUENTO6_1="0.0000" GESTIONA_CAJAS="0" GESTIONA_MEDIDAS_UNIDADES="0" GESTIONA_MEDIDAS_VOLUMEN="0" GESTIONA_MEDIDAS="0" GESTIONA_PROPIEDADES="1" GESTIONA_STOCKS="1" GESTIONA_TARA="0" MEDIDAS_ALTO="0.0000" MEDIDAS_ANCHO="0.0000" MEDIDAS_LARGO="0.0000" MEDIDAS_UNIDADES="0.0000" NOMBRE="ARTICULO1" PRECIO1_IVA="0.000000" PRECIO1="0.000000" PRECIO2_IVA="0.000000" PRECIO2="0.000000" PRECIO3_IVA="0.000000" PRECIO3="0.000000" PRECIO4_IVA="0.000000" PRECIO4="0.000000" PRECIO5_IVA="0.000000" PRECIO5="0.000000" PRECIO6_IVA="0.000000" PRECIO6="0.000000" PVP1_IVA="11.000000" PVP1="9.482759" PVP2_IVA="22.000000" PVP2="18.965517" PVP3_IVA="33.000000" PVP3="28.448276" PVP4_IVA="44.000000" PVP4="37.931034" PVP5_IVA="55.000000" PVP5="47.413793" PVP6_IVA="66.000000" PVP6="56.896552" PVP7_IVA="77.000000" PVP7="66.379310" PVP8_IVA="88.000000" PVP8="75.862069" PVP9_IVA="99.000000" PVP9="85.344828" REFERENCIA="ARTICULO1" STOCK_ACTUAL="0.0000" STOCK_CAJAS="0.0000" STOCK_PDTE_FABRICAR="0.0000" STOCK_PDTE_RECIBIR="0.0000" STOCK_PDTE_SERVIR="0.0000" STOCK_TOTAL="0.0000" STOCKS_AVISAR="0" TARA="0.0000" TIENE_COMPONENTES="0" TIPO_IVA="16.00" UNIDADES_POR_CAJA="0.0000" ID_ARTICULO="ARTICULO1" ID_ARTICULO_FAMILIA="TSHIRT" ID_ARTICULO_GAMA="CLASSIC" ID_ARTICULO_GRUPO="SUMMER" />
<ROW APLICAR_RETENCION="0" AUTO_ENSAMBLAJE_KIT="0" CANTIDAD1="0.0000" CANTIDAD2="0.0000" CANTIDAD3="0.0000" CANTIDAD4="0.0000" CANTIDAD5="0.0000" CANTIDAD6="0.0000" DESCUENTO1_1="0.0000" DESCUENTO2_1="0.0000" DESCUENTO3_1="0.0000" DESCUENTO4_1="0.0000" DESCUENTO5_1="0.0000" DESCUENTO6_1="0.0000" GESTIONA_CAJAS="0" GESTIONA_MEDIDAS_UNIDADES="0" GESTIONA_MEDIDAS_VOLUMEN="0" GESTIONA_MEDIDAS="0" GESTIONA_PROPIEDADES="1" GESTIONA_STOCKS="1" GESTIONA_TARA="0" MEDIDAS_ALTO="0.0000" MEDIDAS_ANCHO="0.0000" MEDIDAS_LARGO="0.0000" MEDIDAS_UNIDADES="0.0000" NOMBRE="ARTICULO2" PRECIO1_IVA="0.000000" PRECIO1="0.000000" PRECIO2_IVA="0.000000" PRECIO2="0.000000" PRECIO3_IVA="0.000000" PRECIO3="0.000000" PRECIO4_IVA="0.000000" PRECIO4="0.000000" PRECIO5_IVA="0.000000" PRECIO5="0.000000" PRECIO6_IVA="0.000000" PRECIO6="0.000000" PVP1_IVA="11.000000" PVP1="9.482759" PVP2_IVA="22.000000" PVP2="18.965517" PVP3_IVA="33.000000" PVP3="28.448276" PVP4_IVA="43.999999" PVP4="37.931034" PVP5_IVA="55.000000" PVP5="47.413793" PVP6_IVA="66.000000" PVP6="56.896552" PVP7_IVA="77.000000" PVP7="66.379310" PVP8_IVA="88.000000" PVP8="75.862069" PVP9_IVA="99.000000" PVP9="85.344828" REFERENCIA="ARTICULO2" STOCK_ACTUAL="0.0000" STOCK_CAJAS="0.0000" STOCK_PDTE_FABRICAR="0.0000" STOCK_PDTE_RECIBIR="0.0000" STOCK_PDTE_SERVIR="0.0000" STOCK_TOTAL="0.0000" STOCKS_AVISAR="0" TARA="0.0000" TIENE_COMPONENTES="0" TIPO_IVA="16.00" UNIDADES_POR_CAJA="0.0000" ID_ARTICULO="ARTICULO2" ID_ARTICULO_FAMILIA=""TANK TOP"" ID_ARTICULO_GAMA="80S" ID_ARTICULO_GRUPO="WINTER" />
<ROW APLICAR_RETENCION="0" AUTO_ENSAMBLAJE_KIT="0" CANTIDAD1="0.0000" CANTIDAD2="0.0000" CANTIDAD3="0.0000" CANTIDAD4="0.0000" CANTIDAD5="0.0000" CANTIDAD6="0.0000" DESCUENTO1_1="0.0000" DESCUENTO2_1="0.0000" DESCUENTO3_1="0.0000" DESCUENTO4_1="0.0000" DESCUENTO5_1="0.0000" DESCUENTO6_1="0.0000" GESTIONA_CAJAS="0" GESTIONA_MEDIDAS_UNIDADES="0" GESTIONA_MEDIDAS_VOLUMEN="0" GESTIONA_MEDIDAS="0" GESTIONA_PROPIEDADES="1" GESTIONA_STOCKS="1" GESTIONA_TARA="0" MEDIDAS_ALTO="0.0000" MEDIDAS_ANCHO="0.0000" MEDIDAS_LARGO="0.0000" MEDIDAS_UNIDADES="0.0000" NOMBRE="ARTICULOXX" PRECIO1_IVA="0.000000" PRECIO1="0.000000" PRECIO2_IVA="0.000000" PRECIO2="0.000000" PRECIO3_IVA="0.000000" PRECIO3="0.000000" PRECIO4_IVA="0.000000" PRECIO4="0.000000" PRECIO5_IVA="0.000000" PRECIO5="0.000000" PRECIO6_IVA="0.000000" PRECIO6="0.000000" PVP1_IVA="11.000000" PVP1="9.482759" PVP2_IVA="22.000000" PVP2="18.965517" PVP3_IVA="33.000000" PVP3="28.448276" PVP4_IVA="43.999999" PVP4="37.931034" PVP5_IVA="55.000000" PVP5="47.413793" PVP6_IVA="66.000000" PVP6="56.896552" PVP7_IVA="77.000000" PVP7="66.379310" PVP8_IVA="88.000000" PVP8="75.862069" PVP9_IVA="99.000000" PVP9="85.344828" REFERENCIA="ARTICULOXX" STOCK_ACTUAL="0.0000" STOCK_CAJAS="0.0000" STOCK_PDTE_FABRICAR="0.0000" STOCK_PDTE_RECIBIR="0.0000" STOCK_PDTE_SERVIR="0.0000" STOCK_TOTAL="0.0000" STOCKS_AVISAR="0" TARA="0.0000" TIENE_COMPONENTES="0" TIPO_IVA="16.00" UNIDADES_POR_CAJA="0.0000" ID_ARTICULO="ARTICULOXX" ID_ARTICULO_FAMILIA="BLOUSES" ID_ARTICULO_GAMA="70S" ID_ARTICULO_GRUPO=""ALL SEASON"" />
</ROWDATA>
</DATAPACKET>

 
Status
Not open for further replies.

Similar threads

smak1
  • Locked
  • Question
add structure to XML
Replies
0
Views
690
smak1
smak1
Bijan Borazjani
  • Locked
  • Question
XML to PDF
Replies
0
Views
786
Bijan Borazjani
Bijan Borazjani
cdr_greg
  • Locked
  • Question
Display XML Line Breaks in Microsoft Word Content Controls
Replies
0
Views
1K
cdr_greg
cdr_greg
198709km
  • Locked
  • Question
Grouping XML key value using XSLT
Replies
1
Views
742
atlopes
atlopes
Sunil Sharma
  • Locked
  • Question
Add Minus (-) into pattern but constrain is Munis (-) should not be first character
Replies
1
Views
718
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top