Uploading templates
Load MFL File
The Load MFL File option in GCON4 MFL Web operates through the MFL04 Server Process, meaning that one order is created for each file load.
Browse: Allows you to select the file to be uploaded. Note: Only .xlsx files are supported.
Variant:Enables you to select the server process variant to be used. Note: To configure a variant, refer to the Process MFL File section.
Load:Once the file and variant are selected, click this option to upload the file to Unit4 ERP.
Your ordered reports: After the upload, an information box displays the Order ID associated with the process.
Logging
GCON4 MFL Logs
Traditional GCON4 MFL Logs (including detail log) will correspond to the show report column.
MFL04 Server Process Logs
As in Unit4 ERP standard, these logs from MFL04 server process can be found in the Server Logging folder.
Process MFL file
This menu option allows to define variants in the MFL04 server process. Variant 0 is the variant by default.
Report variants management: The MFL04 Server process works like the Unit4 ERP standard and incorporates the Variant management using Report variants button where you can create, modify, and delete variants according to the type of loading you want to perform based on the list of custom Parameters.
The hierarchy of the parameters applied is:
(1) the defined values in the variant
(2) the values defined in the Settings section when Variant=0
To personalize the variants, we listed the parameters ID from the explained above; non-fixed parameters can be added in the MFL04 Server process manually, if required.
| Parameter ID |
Data type |
Parameter name |
Default value |
Length |
Sequence |
Fixed |
|---|---|---|---|---|---|---|
| test_mode |
B |
Test Mode |
0 |
|
12 |
|
| vlte_trs_amt |
B |
Validate Trans. Amount |
1 |
|
13 |
|
| cnt_on_error |
B |
Continue on Error |
0 |
|
14 |
|
| all_emp_csv |
B |
Allow empty CSV files |
1 |
|
15 |
|
| detailed_log |
B |
Detailed log |
0 |
|
16 |
|
| trns_stp_wrg |
B |
Trans. Stop When Warning |
1 |
5 |
18 |
|
| report_file |
B |
Report File |
MFL04 |
25 |
19 |
x |
| blob_id |
B |
Blob Id |
|
36 |
20 |
x |
| remove_blob |
b |
Remove blob |
0 |
5 |
21 |
x |
Links to companies
The report can be executed from more than one company:
Output
In the output section, you can indicate the Server queue.
Note: It is required to use a specific sever queue for the MFL04 process when loading master files that consequently run GL07 (Posting AP, Posting AP, Posting GL) or LG04 (Purchase Order, Sales Order, Good received, Stock Entry, Stock Withdrawal). In these cases, one of the queues will run the MFL04 process and the other the GL07/LG04. For detailed information please check the Appendix section.
Uploading excel templates
The Load window allows you to select the Excel sheet that contains the data to be inserted/updated in the Unit4 ERP.
Key considerations when updating data
To create a template for updating existing records, you can use one of the following approaches:
- Retrieving existing data from Unit4 ERP
Generate a template with data, update the required fields, and upload it. The system will apply only the changes made in the template.
- Generate an empty template
Create a blank template and manually enter only the values that need to be updated.
Regardless of the approach used, keep the following in mind:
- The master file ID in the main (first) tab of the template is always mandatory.
Please note the following distinctions:
- Mandatory field: Required for both insert and update operations
- Mandatory/optional field: Required for insert operations and optional for updates
- Optional field: Not required for either insert or update operations
If a value is left blank in the template, GCON4 MFL will retain the existing value in the database. If you want to clear an existing value, use <#EMPTY#> in the template.
If a tab contains data that does not need to be updated, it can either be left unchanged or removed from the template. In both cases, the existing database values will be preserved. However, it is not recommended to delete any columns or tabs from the template.
If values are included in the template, GCON4 MFL will validate them during the upload process. If they are not included, they will not be validated.
New relations can be added to existing master file IDs in the template without including the existing relations.
Uploading CSV templates
The CSV templates generated by GCON4 MFL must follow a specific nomenclature:
- Master file name (BLUE)
- Tab name in GCON4 MFL (RED)*
- The last number identifies the various CSV files of the same master file (GREEN). In the example given below, there are two CSV files, Supplier_A5_1 with 20 rows (RED) and Supplier_A5_2 with 30 rows (GREEN).
*The first tab shows the ID of the attribute in Unit4 Business World; in this case, supp.id = A5.
To get the specific file names, GCON4 MFL generates CSV templates, as explained in the Generating a CSV template section.
Note: Newline can be inserted using the \n character, example:
Loading via Process MFL File option
In the Open Parameters, the Filename corresponds to the file you intend to upload to the system. By default, the file is retrieved from the Data Import folder on the Unit4 ERP server.
You can upload .CSV files using this option. Only the file name, including the extension, is required (e.g., Personnel_C0_1.csv).