Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

X-Ray Management provides an environment for managing configurations, defining valid ranges for each configuration and setting the required values for each site.

...

X-Ray Management File Import

The purpose of the file import option is to update/edit the X-Ray configuration table parameters for a large number of units by uploading a file, as opposed to manually updating each unit.

Note

The data in the file will overwrite the information in the system, if there are units in the system that are not in the file, then they will not be changed

Requirements

Units:

  • The units that will appear in the file must already be present in the system.

User:

  • Users with "Full” permission to the "X-Ray" tool will be able to view the button and upload the file.

  • The user must have permission at least to view the cluster/group that the unit belongs to.

File:

  • 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.

  • 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
nameExample .csv

File Uploading Process

  1. Prepare the CSV (Comma Delimited) format.

  2. Open the Galooli Manager solution and enter the “X-Ray Management” tool.

  3. Click on the three-dot menu.

  4. Select “Import”.

  5. Upload the prepared CSV (Comma Delimited) file.
    After uploading a file, the user will get an immediate error message in the following cases:

    1. The file is not in a CSV format.

    2. 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

  6. If the file structure is valid (CSV format + Valid columns) - the file will be processed and the results will be sent to the user by email in case of a failure or success.

    1. In case of a failure, the file will not update any unit.

    2. In case of a failure, the reasons for the failure will be detailed in the email the user will receive.
      Email Example:

TBA

The report will contain the failure reason.

TBA

File Update Success and Error Messages

  • Success Result
    After a successful update of the parameters.

...

  • Partial Success Result
    After a partially successful update of the parameters but with some issues.

...

  • Failure Result

...