The YIMPEXCEL script code was developed to allow the import of Excel files (.xsl or .xlsx) into Sage X3, without the need for prior conversion to .csv.
In order for this to be possible, the following implementations must be made:
- Installation of the provided Sage X3 patch.
- Addition of the F5IT value in the miscellaneous table 901 - Chapters for parameters.
- Addition of the EXCEL value in the miscellaneous table 903 - Parameter group.
- Definition of the value of the parameter YEXCHEADER - Excel import header.
- Creation of the YIMPEXCEL trt
- For normal imports, creation of the SPE trt for the import action TRTIMPOBJ (ex: XYTRTIMPOBJ) and in this treatment call the tag YIMPORT_EXCEL in the CONTROL action.
- For imports by Table/Setup, creation of the SPE trt for the import action V3 TRTIMPV3 (ex: XY TRTIMPV3) and in this treatment call the tag YIMPORT_SETUP_EXCEL in the EXEC action.
NOTE
A check has been added to the global variable YF5IT_EXCEL, if this variable is declared Sage X3 will ignore the parameter and assume the value of the variable.
This allows for the desired behavior to be forced depending on the SPE development.
