gibt es eine Möglichkeit in Calc mit dem XML-Dateiformat zu arbeiten, bei In- und Export.
Ich kann auch keine Exportfunktion finden und beim öffnen einer einfachen XML-Datei in Calc, kommt immer die Fehlermeldung 'Es ist ein nicht behebbarer Fehler aufgetreten'
Eigentlich müsste OO doch mit XML Umgehen können, ist ja sein Speicherformat
Gruss Henry
Dies ist ein einfaches Beispiel zum Importieren was OO nicht schafft.
Code: Alles auswählen
<?xml version="1.0" standalone="yes"?>
<DATAPACKET Version="2.0">
<METADATA>
<FIELDS>
<FIELD FieldName="products_id" DisplayLabel="products_id" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_quantity" DisplayLabel="products_quantity" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_model" DisplayLabel="products_model" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="products_image" DisplayLabel="products_image" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="products_price" DisplayLabel="products_price" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_date_added" DisplayLabel="products_date_added" FieldType="DateTime" FieldClass="TField"/>
<FIELD FieldName="products_last_modified" DisplayLabel="products_last_modified" FieldType="DateTime" FieldClass="TField"/>
<FIELD FieldName="products_date_available" DisplayLabel="products_date_available" FieldType="DateTime" FieldClass="TField"/>
<FIELD FieldName="products_weight" DisplayLabel="products_weight" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_status" DisplayLabel="products_status" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_tax_class_id" DisplayLabel="products_tax_class_id" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="manufacturers_id" DisplayLabel="manufacturers_id" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_ordered" DisplayLabel="products_ordered" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price1" DisplayLabel="products_price1" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_price2" DisplayLabel="products_price2" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_price3" DisplayLabel="products_price3" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_price4" DisplayLabel="products_price4" FieldType="Float" FieldClass="TField"/>
<FIELD FieldName="products_price1_qty_from" DisplayLabel="products_price1_qty_from" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price2_qty_from" DisplayLabel="products_price2_qty_from" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price3_qty_from" DisplayLabel="products_price3_qty_from" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price4_qty_from" DisplayLabel="products_price4_qty_from" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price1_qty_to" DisplayLabel="products_price1_qty_to" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price2_qty_to" DisplayLabel="products_price2_qty_to" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price3_qty_to" DisplayLabel="products_price3_qty_to" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_price4_qty_to" DisplayLabel="products_price4_qty_to" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_qty_blocks" DisplayLabel="products_qty_blocks" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="products_oem" DisplayLabel="products_oem" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="products_artikel_nummer" DisplayLabel="products_artikel_nummer" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="products_extra_code" DisplayLabel="products_extra_code" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="products_date_end" DisplayLabel="products_date_end" FieldType="Date" FieldClass="TField"/>
</FIELDS>
</METADATA>
<ROWDATA>
<ROW products_id="2.148" products_quantity="0" products_model="b-2148" products_image="2148.jpg" products_price="1,800" products_date_added="02.03.2004 12:07:49" products_last_modified="02.03.2004 12:09:38" products_date_available="Null" products_weight="0,000" products_status="1" products_tax_class_id="1" manufacturers_id="0" products_ordered="3" products_price1="0,000" products_price2="0,000" products_price3="0,000" products_price4="0,000" products_price1_qty_from="0" products_price2_qty_from="0" products_price3_qty_from="0" products_price4_qty_from="0" products_price1_qty_to="0" products_price2_qty_to="0" products_price3_qty_to="0" products_price4_qty_to="0" products_qty_blocks="1" products_oem="" products_artikel_nummer="" products_extra_code="" products_date_end="Null"/>
</ROWDATA>
</DATAPACKET>