Interface Creator

From Wiki csv4you
Jump to: navigation, search
This page is a translated version of the page Individuelle Schnittstellen and the translation is 100% complete.

Other languages:
Deutsch • ‎English

In the Interface Creator you can define free, individual CSV- or XML- formats. You will find a list for selecting an interface you have already created and a button for creating a new one. The number of individual interfaces is not limited.

Example: You have a self-programmed shop system and want to import many products of one of your suppliers into your system in a simple way. Such an interface can be set up individually and reconfigured at any time.


Selection or Creation of an Individual Interface

Select Interface -Select an already saved interface ("Edit" button) or create a new one ("Create Individual Interface" button).


Basic Settings

  • Name
Give your Individual Interface a meaningful description.
  • File-Type
Select the appropriate file type here
  • Data Field Separator:
for example: semicolon (;) or comma (,)
  • Text Identification Mark
For example: double quotation marks (") or a single quote (')
  • Variants
Specify whether your products have variants..

Header

The column definition of your interface is usually located in the header area (e.g. for a simple CSV- file). Please insert the placeholder {#S#} behind each column name (except after the last!). If you want to keep columns empty, use only {#S#} as placeholders in this location.

An example of the header of a CSV interface:

id{#S#}
title{#S#}
desc{#S#}
quantity{#S#}
gewicht{#S#}
size{#S#}
bild1{#S#}
bild2{#S#}
ean{#S#}
...{#S#}
...{#S#}
status

or an example of a simple XML header:

<supplier name="LieferantA" supplierid="56847">
<products category="Schuhe" categoryid="1234567">
<items all="657">

If you want to create more than one header row, insert a {# BR #} after the last column at the end of each header row, except for the last(!). This one gets nothing.

Content Area

In the content area, you must assign the correct data values to the columns defined in the header area. On the right-hand side, you will find all the available data values (placeholders) for the data source. Place the cursor in the content window with the mouse and then click on one of the placeholders on the right. Also insert the placeholder {#S#} behind each data value (except after the last!).

An example of the content area:

[productid]{#S#}
[title]{#S#}
[description]{#S#}
[quantity]{#S#}
[weight]{#S#}
[size]{#S#}
[pic1]{#S#}
[pic2]{#S#}
[ean]{#S#}
...{#S#}
...{#S#}
[lstatus]

and a content example for an XML file:

<item id="[number]" title="[descr]" quantity="[quantity]" gewicht="[weight]" size="[size]" bild1="[pic1]" bild2="[pic2]" status="[lstatus]"/>

This line is repeated in dependence of the number of records found, when you create a CSV or XML file.

Attention!
The order of the columns in the header must match the order of column in the content area.


Footer

Here you can set up the footer for your interface (not necessary for CSV files).

Example for an XML file:

</items>
</products>
</supplier>


Categories

Tragen Sie hier bitte Ihre Kategoriebezeichner ein. Sie finden diese dann danach im Bereich Export ->Kategoriezuordnung als Spaltenname für Ihre Kategoriennamen bzw. IDs.

Attention!

Individual interfaces require compulsory a Category Identifier!

Extended Field Functions

There are various possibilities for the calculation, filtering and individual formatting of column contents at the import and export of data. Please look at our help page "Advanced Field Functions".