...
The file must be in CSV (Comma Delimited) format.
Columns should not be rearranged.
The order of the columns must be unit_id, X-RAY Field Name, Active, Min Valid Value, Max Valid Value, Set Value, and use the exact names.
The first column of the file must be a “unit_id”. This column must include valid unit ids, so its values must be filled. In addition, each Id should have a single row (the same unit cannot be updated with 2 different rows).
"X-RAY Field Name" column values must appear in the system key structure. You can view the system key fields by clicking on the following link - Forms Gate Supported Fields List.
In the "Active" column, the value must be "Yes" or "No" (empty rows will be considered as “No”). If active is "No", all the other parameter's column will be ignored, even if they are filled.
Check the file to ensure Ensure that there are no empty lines. It is possible to verify this by opening the file as a text file and deleting the lines containing commas.
The user can upload a file with X-Ray fields that are not defined for the unit, and they will be ignored.
Example of a file:
View file name Example .csv
File Uploading Process
Prepare the CSV (Comma Delimited) format.
Open the Galooli Manager solution and enter the “X-Ray Management” tool.
Click on the three-dot menu.
Select “Import”.
Upload the prepared CSV (Comma Delimited) file.
After uploading a file, the user will get an immediate error message in the following cases:The file is not in a CSV format.
The columns are not in the correct order - The columns order must be: unit_id must be unit_id, X-RAY Field Name, Active, Min Valid Value, Max Valid Value, Set Value
If the file structure is valid (CSV format + Valid columns) - the file will be processed and the results will be displayed to the user.
In case of a failure, the file will not update any unit.
In case of a failure, the reasons for the failure will be detailed.
Example: