Administration Data import export Import Detail information - robinfeng/beashelp GitHub Wiki
详细信息
Navigation: Administration > Data import/export > Import: Detail information No contents entries on this page Contents More conditions, sorts and conversions can be defined under detail information.
conversion Conversion tables for specific source fields can be created here. Examples shown below Filter The source table can be filtered here, i.e. the entries to be adopted can be defined this way. Example: Adoption only when item number does not begin with 1 and is not completely empty left(item,1)<>"1" and item<>"" Sort The transfer sequence can be defined here. Example: Sorting according to source field "item" ascending: "item" Example: Sorting according to source field "item" descending and "no." ascending: "item desc, nr asc" Start Script This is a beasSCRIPT executed before the actual script. The process is terminated at CANCEL Example: Question=Do you really want to start the import?=end=cancel End Script This is a beas SCRIPT executed at the end. Example: After import, the flag U_KE is to be set to K if the item number begins with "1" SQL=update oitm set u_ke='K' where substring(itemcode,1,1)='1' SQL=update oitm set u_ke='E' where substring(itemcode,1,1)<>'1' Check A preliminary check can be defined here taking place BEFORE the import. It can be specified whether source field contents are included in target fields Structure: Target table=Target primary=Source field e.g. Do not perform import if the source field "Material group" does not exist in the material groups u_beas_matgrp.
beas_matgrp=matgrp_id=material group
Field conversion The value of a source field can be converted here into another value. The program determines all existing source values and then permits entry into the target values.
Example: The source field "Material group" should be entered into the target field "u_matgrp". The partially chaotic target values should be converted into 5 specific values. For this purpose, the user clicks on the sheet symbol before the input field and enters the name of the source field. An analysis of the source now takes place. The result is then entered in the input field in the following format:
sourcefield=sourcevalue:tartgetvalue,sourcevalue:targetvalue,sourcevalue:targetvalue,other:??
The target values can now be corrected manually or source value:target value can be removed and the results for all values not defined here can be stored at "other".
u_matgrp=100:100,120:120,130:130,131:131,132:132,other:??
can be changed in u_matgrp=100:B1,120:B2,130:B3,other:BZ
This would mean that source 100 is to be converted in B1, 120 in B2, 130 in B3 and the remainder in BZ.
返回 主页