Form NorwexImportBOMForm
- Unit name: Forms.NorwexImportBOM
- Form name: NorwexImportBOMForm
- Old form name: unit22 (Form22) Bitbtn34.
Synopsis
Form om de Norwex BOM (Excel) te importeren.
Functionalities
- The form has an edit box where a filename can be entered/Selected.
- Once an excel file is selected, a combobox with excel sheets found in the excel file is shown.
- A button allows to execute the View action.
- A grid is present to show the content of an excel sheet.
- If there is only 1 sheet, automatically select it and execute view action.
- A button allows to execute the Import action.
Optionally, to be discussed:
- Show report: Norwex disabled local with stock
- Show report: Norwex articles without stock
Actions
View
Show details of an excel sheet. 1. Enabled only when a sheet is chosen. 2. preview the contents of the selected sheet: the contents of the selected sheet is shown in a grid.
Import
Imports the CSV file. 1. Only active if the grid contents is non-empty. 2. When executed: 1. Table NRW_ARTICLE_GLOBAL is cleared. 2. Table NRW_ARTICLE_GLOBAL is filled with the data as in the below table. (first row skipped) 3. After the import was succesful, the number of imported records is shown to the user. 4. After the table was filled, the service call Stock.FinishNorwexBOMImport call is executed. 3. Import table mapping:
| Field | Excel column |
|---|---|
| ARTCODE | 0 |
| ART_DESCRIPTION | 1 |
| COUNTRY | 2 |
| LANGUAGE | 3 |
| LINKEDARTCODE1 | 4 |
| LINKEDAR_DESCRIPTION1 | 5 |
| SizeSticker1 | 6 |
| LINKEDARTCODE2 | 7 |
| LINKEDAR_DESCRIPTION2 | 8 |
| SizeSticker2 | 9 |
| Comments | 10 |
Tables/Views
- NRW_ARTICLE_GLOBAL
Needed Service Calls
Stock.FinishNorwexBOMImport
No parameters are needed.