I. Configuring data import rules
According to our own understanding, in order to facilitate the processing of logic, generally choose the temporary table + personalized SP mode. In this mode, the template will be imported into the temporary table first, and then processed through the stored procedure "SPUDF_SKU_UDFIMP" to import the relevant logic into the system.
where its implementation number is the line number where the indicator title field is located.
II. New temporary table "TMP_UDFIMP_SKU"
Keep the structure of the temporary table consistent with BAS_SKU.
III. Setting up field mapping for imported temporary tables
1. In the list, right-click and select Import Field Configuration to enter the configuration page.
2、Switch the specified table to the new temporary table "TMP_UDFIMP_SKU", please note that the temporary table must start with TMP_UDFIMP_, otherwise it can not be recognized.
3, the title field in EXCEL with the system field mapping. Mapping system fields can be dragged from the left column over
IV. Setting up the imported stored procedures
1. If you confirm which stored procedure is it?
According to the function number "A1028" in the data import rule configuration in Figure 1, you can find the corresponding stored procedure in the standard business extension configuration.
2, the follow-up is to modify the stored procedure to edit the import process, and then do not do a detailed discussion.