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.
See also:
Importing a File