Documentation
Back to website >

Article CSV

General

You will find the article CSV-Export under "Accessories" in the quick start bar.

Article CSV-Export

 

With CSV export you can select article fields, make a data selection using the characteristics tree and upload the target file to your website via FTP if necessary. This can be useful, for example, if you run an online shop (eCommerce system).

 

Field selection

You use the field selection to determine the fields to be output. For simplification there are the buttons "All" and "None". These select or deselect all fields. If you want to save the images as image files in addition to the CSV file, select the "Image" field. In this case, the Aspect Ratio option is enabled in the data selection area. The article number is always used as the file name for the image file. If the article number contains characters that are not allowed as file names (question marks, arrows, etc.), the affected images are not exported. At the end of the output, you receive an error list of the articles affected.

Field selection

 

Data selection

Using the data selection, any characteristics can be included or excluded using the article characteristic tree.

Data selection

 

At this point, you can combine your characteristics as you wish. You can also exclude characteristics. On the "Sorting" tab you can sort the output file according to any field in three levels. In addition to the characteristics, you can set any filters on the "SQL" tab page so that you can specify output areas according to any fields, for example.

 

picture format

If the "Image" field has also been selected in the field list, you can specify the image format (Jpeg, Tiff, Bmp, etc.) here.

 

Target format

The file name is expected in the "File name" field, i.e. with drive and path specification. Using the small button"[...]" at the end of the field you can select an existing output file or use the dialog to select the storage location.

Field separator

A CSV file is an ASCII file in which fields are separated by an agreed field separator. You can select this field separator at this point. Field separators are offered as comma, semicolon and tab characters. Each data line is always separated with CR+LF.

File mode

For the CSV file you can set whether a possibly existing CSV file is overwritten, whether the new content is appended to an existing file, or whether the file name is to be generated automatically by incrementing a number if the target file already exists.

Include field names

You have the option of outputting a line with the field names at the beginning of the output.

FTP transfer

This can be used to transfer the generated CSV file and, if necessary, all images to a provider via FTP. You must be connected to the Internet. No proxy may be used for the FTP ports. The transfer requires at least the specification of the FTP server. This can be specified as an IP number, e.g. "192.162.10.1", or as a natural name. The protocol, as usual in the Internet browser, is not specified. For example, a valid name would be "ftp.eulanda.eu". 

If the data is not to be copied to the root of the FTP server, the path name must be specified with slashes "/" and not, as is usually the case on a PC, with backslash.

Most FTP servers require access authorization. You can enter the user name and password.

Storage

A valid configuration can be saved using the "Save configuration" button.

Save configuration

Select Menu Title

Menu entry in article

 

The CSV configuration is then available in the extra menu of the article master. The article menu is only updated after a program restart.

 

Changing the configuration

The configuration can be changed by saving the dialog again. In addition, the configuration can be changed via the SQL registry and optimized there with further parameters.

Hint: The configuration change is for technicians only.

You can manually extend the generated SQL command in the SQL registry and enter field aliases and use other field separators or line breaks, for example. You can also change the export using dialog masks. For a complete description of these options, see the SQL Registry chapter in the Developer's Manual. The path for the saved configuration is: \ROOT\OBJECTS\DATAOBJECTS\{DataobjectsNames}
\Actions\{ActionsNames}