The Bulk Upload feature in GageMakkal streamlines the process of adding multiple instruments and their associated data via a CSV file. This ensures efficiency and minimizes errors.

Navigate to the main menu and select the "Instrument" to open "All Instruments" page.

1. On "All Insturments" screen, click on the three dots and select the "Import" button.

2. On the Import CSV screen, choose the CSV file that contains the list of instruments.  CSV file and it's details can be found below.

3. Select a base folder where the certificate files are stored.

4. Click Preview to bring up the prview of the imported data from CSV file.

5. Review and Fix Data:

   1. If all data is correct, you will see an "Add" button to add the instruments.

   2. If there are errors, such fields are marked in red colour.  Click "Edit" button to fix any errors anc click "Verify" to recheck the data.  Repeat this process until all red boxes are cleared.

   3. If some details deoesn't exist in GageMakkal, fix those issues in background GageMakkal tab. Some examples of fixing issues are as

      1. Make: If a make does not exist, open a new tab, go to the models section, add the model, select the appropriate make, and save it.

      2. Model: If a model does not exist, open a new tab, go to the models section, add the model, select the appropriate model under make, and save it.

      3. Instrument Cluster: If an instrument cluster does not exist, open a new tab, go to the cluster section, create a new clusters, and save it.

      4. Team: If a team does not exist, add the team in the teams section. Include necessary members, e.g., Jack Williams and Mark Dewitt.

      5. Dependency Group: If a dependency group does not exist, create a new one or rename an existing one as needed.

      6. File Path: Ensure the file names and paths with sub-folders are correct.

6. Add Instruments:

   1. Once all issues are resolved and the red boxes are cleared, you will see the "Add" button.

   2. You can also select specific instruments using the checkboxes on the left and click "Import" in the bottom right to bulk import the selected items.

Bulk Import CSV Headers

Each field of the CSV file that used for bulk upload is explained here

• Serial Number: The serial number of the instrument.

• Make: Manufacturer name or brand.**

• Model: Specific model name of the instrument under given Make.**

• Alias Name: A unique identifier for the instrument, typically a combination of serial number, make, and model.

• Asset ID: Organization-specific asset identification number.

• Instrument Cluster: Existing cluster name.**

• Team: Name(s) of the team(s) assigned to the instrument, separated by a semicolon. **

• Assigned To:  First person name who is responsible for the instrument. **

• Second Person Assigned To: Additional person assigned, format: name;team.***

• Calibration Lead Time: Lead time for calibration, formatted as 2H, 2D, etc.**

• Status: Status of the instrument. Either Active or Inactive.

• Alert Days: Number of days before calibration to send an alert, e.g., 30D. *

• Critical Alert Days: Number of days before calibration to send a critical alert, e.g., 10D *

• Calibration Based on Usage: Specify if calibration is based on usage. Either True or False.

• Maximum Days per Calibration: Maximum days between calibrations, formatted as 30D, 1M, etc. *

• Maximum Usage Days per Calibration: Maximum usage days allowed per calibration. Number of days.

• Alert Begins At (Usage Days): Number of usage days remaining before which alert notification starts.

• Critical Alert Begins At (Usage Days): Number of usage days remaining before which critical alert notification starts.

• Dependency Group: Name of the dependency group for the instrument. **

• Calibration Frequency: Frequency of calibration, e.g., 1Y for one year. *

• Next Calibration Date: Date of the next scheduled calibration.

• Last Calibration Date: Date of the last performed calibration.

• Calibration Certificate Path: Path to the calibration certificate file relative to the base folder.

* D for days, M for months, Y for years 

**If name doesn't exist in GageMakkal prior to import, error shows on import and need to be added and re-verified to fix the error.

*** H for hours, D for days

Final Notes

• Ensure all data is pre-added to GageMakkal (e.g., makes, models, clusters) to avoid errors during import.

• Verify each field and fix errors as they appear to ensure a smooth import process.

By following these steps and guidelines, you can efficiently bulk upload multiple instruments into GageMakkal, ensuring all necessary data is included and correctly formatted.