Importing a File: Master Data

You have a TXT file on your PC with the following product group characteristics:

LADIES_Ladies shoes

MENS_Mens shoes

CHILDREN_Childrens shoes

The underscore ( _) between the fields in the lines symbolizes the TAB character that separates the fields.

You want to import this data into aspect 001 ( Profitability Analysis ). The aspect contains the characteristic ARTGR ( Product group ).

You create sender structure ARTGR and enter the following data:

Characteristic: ARTGR

Conversion: 0

Field name	Type	Length	Dec. places
Product group	C	8
Description	C	20

You generate the sender structure and then maintain the transfer rules. In this case the language D (German) has been entered as a constant. You maintain the following rules for the fields:

Recv. field	Assign. rule	Sender field	Offset	Length	Constant
ARTGR	MOVE	ARTGR	0	0
TXT20	MOVE	TXT20	0	0
LANGU	SET				D

You save the transfer rules and then edit the selection data for importing the file.

To carry out a test run of the transfer, enter the following data:

Field	Entry/Selection
Sender structure	ARTGR
File	Path, in which the file can be found, for example, d:\file\ablexcel\artgr.csv
File system	Presentation server
Editing	Display file Display sender record - field assignment
File type	CSV format
Number format	Type P No editing characters
Data format	ASCII
Date format	YYYYMMDD

You can now start the program.

If the test data is satisfactory, you can select Data transfer and execute the program again.