---
title: "Import Data v3.2.0.1"
canonical: "https://servicedesk.maxgeo.com/space/DS/1750892567/Import%20Data%20v3.2.0.1"
format: markdown
---
> Macro (toc-zone)

The Import Data menu option allows the user to load data into the database. The import data menu allows you to import CSV, Excel, Assay Files as well as creating and editing import layouts.

![Import Data - CSV Files - Step 1.png](media://bc351976-2848-4281-965e-c1e726f15fe2)

## Import Data Header

To make setting up imports easier and more intuitive, the Import Layout selection has been simplified into two dropdowns.

- **Updated Control Name:**
  - The original “Import Layout” dropdown is now called **“Layout Type”**.
  - This first dropdown lets you choose a layout category, such as:
    - Any CSV
    - Any Excel
    - Assay File
    - XRF File
    - Control Points (MDS5 only)

Once a category is selected, a second dropdown can be used to let you pick a specific layout from that group.

![Import Data - CSV Files - Step 2.png](media://d25ddd45-a3c8-4b89-9ea0-f5516f48971e)

## Importing CSV Files

The **Import Data** menu option allows the user to load data into the database. The import data menu allows you to import CSV, Excel, Assay Files and Control Points (MDS5 only) as well as creating and editing import layouts.

- To import a CSV file first you need to select the import Layout ‘**Any CSV File**’  
and then click "**New Layout**". Or you can choose a predefined Layout.
- Then click "**Load File**".
- This will open the Import Layout editor.
- Select the table to import into. Then select the CSV file to import.
- Choose a DataSet for the data. This can be left blank if the import file contains this data.
- If you choose a Default DataSet, you will need to confirm the choice.
- Select a Date Format mask. For CSV files "**DD/MM/YYYY**" is the usual preferred format.

> ℹ️ **Please Note:** If you do not select a date format, we will use your browser locale configuration to determine the date format we will import to.

![Import Data - CSV Files - Step 4.webp](media://b1e8e11b-c55a-49ed-a375-387005cac82e)

By selecting the ‘**Append Data Source to Buffer Table**’ check box above the buffer table, upon import we will use the file name as your data source. You will notice, once the options have been checked, an info Icon will appear next to the Data_Source ‘To Field’ explaining the action.

> ℹ️ **Please Note:** If you select this option and have data in your source file under the Data_Source column, this data will be ignored and populated with the name of the import file.

![Import Data - CSV Files - Step 13.png](media://e932a38d-651f-4a9a-adb8-d56c6ee88ea2)

In the Import Layout table, we will automatically try match 'From’ and ‘To’ fields if the names match. These are displayed in the screen grab above. Fields that are not matched will be displayed in a peach color.

> ℹ️ Please Note: Not all fields need to be mapped for you to save the layout or load data. If you do not map a field and attempt to load the data, we will only display the fields you have mapped in the buffer table.


![Import Data - CSV Files - Step 14.png](media://687d44cb-9828-4f48-980a-2ffd53cd9906)

### Editing a CSV Import Layout

The System Import Layout screen allows you to add, delete and map ‘**To**’ and ‘**From**’ Fields.

- To add fields, click the ‘**+**’ Icon on the top left-hand side of the screen. This allows you to map a single ‘From’ field to multiple ‘To’ fields.
- Select the "**From**" field
- Then select the "**To**" field.
- To delete a field, select the field using the check box on the left-hand side,  
then select the ‘Delete’ trashcan Icon at the top left. As shown in the screengrab below.

![Import Data - CSV Files - Step 15.webp](media://61f817b3-cf0f-49e9-a980-fbb50814623f)

### Saving the Import Layout

Once you have edited your layout you can then either save the layout or import data using the buttons at the bottom of the Import Layout Editor.  
Clicking the **Save Layout** option will allow you to enter a name to save the layout for future use. Enter a name for the layout and this will now be available for you under the Import Layout drop down. Saving the layout will remember the table and the mapping configurations you edited.  
After you have saved your layout or without saving the layout you can proceed to click the ‘**Load**’ button. If you have any unmapped fields in your layout, a warning message will appear. If you do not require the unmapped fields and want to import data with the unmapped fields, click ‘**Yes**’. Otherwise click ‘**No**’ and map the remaining fields.

> ℹ️ Please Note: Any fields not mapped will not be displayed in the buffer table or able to import with the remainder of your mapped fields.

Clicking '**Yes**' will load the data to the buffer table for review prior to importing.  
The data will be loaded to the Import Buffer.


![Import Data - CSV Files - Step 22.webp](media://49a8cb75-8826-4365-be05-d4fed3657c87)


## Importing Excel Files

- To import an Excel file first you need to select the import Layout ‘**Any Excel Spreadsheet**’  
and then click "**New Layout**". Or you can choose a predefined Layout.
- Then click "**Load File**". This will open the Import Layout editor.
- Select the table to import into. Then select the Excel file to import.
- Then select the "**Worksheet**".
- Choose a DataSet for the data. This can be left blank if the import file contains this data.  
If you choose a Default DataSet, you will need to confirm the choice.
- Select a Date Format mask. For Excel files "**MM/DD/YYYY**" is the usual preferred format, no matter how dates are displayed in the Excel file.

![Import Data - Excel Files - Step 4.webp](media://e4503109-3eaf-44c8-b6a7-c10022386b0a)

By selecting the ‘**Append Data Source to Buffer Table**’ check box above the buffer table, upon import we will use the file name as your data source. You will notice, once the options have been checked, an info Icon will appear next to the Data_Source ‘To Field’ explaining the action.


> ℹ️ **Please Note:** If you select this option and have data in your source file under the Data_Source column, this data will be ignored and populated with the name of the import file.

![Import Data - Excel Files - Step 13.png](media://20e3b862-6a7a-4704-a0b8-93665c455e13)

### Editing an Excel Import Layout

The System Import Layout screen allows you to add, delete and map ‘**To**’ and ‘**From**’ Fields.

- To add fields, click the ‘**+**’ Icon on the top left-hand side of the screen. This allows you to map a single ‘**From**’ field to multiple ‘**To’** fields.
- Select the ‘**From**' field
- Then select the '**To**’ field.
- To delete a field, select the field using the check box on the left-hand side,  
then select the ‘**Delete**’ trashcan Icon at the top left. As shown in the screengrab below.

![Import Data - Excel Files - Step 15.webp](media://e3ad999d-2ba4-4304-88a5-26fb58efbb10)

> 📝 Saving the Import Layout is the same as for CSV Files above.


## Import Buffer Table

For both CSV and Excel file formats, once the data has been loaded into the buffer table, you can Edit, Delete, Update, Export and Import data that is within the buffer table.

Simply click into the cells to edit the data within the grid. Once you have edited the data, press enter or click out of the cell to save the updates you made. Once you have saved the record you can use your arrow keys to toggle around the table.

> ℹ️ **Please Note**: If you delete any data that is a required field a warning will appear.

To delete a row or multiple rows from the grid, simply, select the row using the left-hand check box and click the ‘**Delete**’ trash icon on the top left-hand side. Selecting the check box in the top left-hand corner of the grid will select or deselect all rows.

The Import Buffer Table screen is divided into two tabs – **Append Buffer to Database** and **Merge Buffer to Database**.

![image](media://04895731-3325-44ae-84c8-89f29e5efcc3)

The **Append Buffer to Database** tab contains records that are new, and these will be appended to the database using a SQL Bulk Insert command on clicking the Append Data button. 

The **Merge Buffer to Database** tab contains records that already exist, and these records will be updated in the database using a SQL Update command on clicking the Merge Data button.

On both tabs, if a data error is encountered, a message will be displayed where you can choose either:

1. Validate and display errors
  1. This will append records row by row. Valid records will be appended while erroneous records will remain in the Import Buffer where they can be edited and corrected. An alert icon will be displayed, which will display the error for the record when clicked
2. Return to the Import Buffer to manually correct the data.

To Export data from the grid, select the '**Export**’ Icon on the top right-hand side of the screen. You are then able to choose between exporting all data from the grid or selected rows to Excel. 

![image](media://7b122a51-d698-4a89-b494-87cd10cb0016)

Once you've made necessary edits to the data in the grids, initiate the data import process by selecting the '**Import Data**' button located in the top-left corner. The system will attempt to load all data residing in the buffer table. 

> ℹ️ **Please Note: **Only data passing the validation checks will be successfully loaded into the database. Any data failing the validation process will be retained in the buffer table for subsequent remediation.

![image](media://018fdd86-1057-4d74-a37f-32ee8e7c1804)

As mentioned above, if there are any errors with the data you are importing, a red error notification will appear in the top right corner as well as a warning triangle will appear on the left-hand side of the record. As shown in the screen grab below. 

![image](media://536e6272-eb38-448d-975b-3ee4056ecceb)

You can view the details of the error by clicking on the red triangle on the left-hand side of the record. This will display the error messages as shown in the image below.

![image](media://840d1207-8150-45a1-af97-1fc1f445f269)

Click ‘**OK**’ to exit the error message and fix any issues with the data in the buffer table. Once you have fixed the data, you can proceed to click the ‘**Append Data**’ or ‘**Merge Data**’ button again to reload the data. If successful a green notification will appear in the top right of the screen and the data will be loaded to the specified table and the buffer table will be cleared.

![image](media://3e1c1cc4-570d-488e-a1c5-1e897b483b22)

## Find and Replace

- A “**Find & Replace**” option has been added to the right-click menu on all columns within buffer tables (e.g. Import > Buffers). This feature is available only to users with **SysAdmin** or **UserPlus** roles.
- A third right-click option – “**Find & Replace**” – now appears alongside existing Fix and Unfix options on buffer table columns.
- The dialog title dynamically reflects the column name on which the action is performed for clarity.

![Import Buffer - Updates - Step 1.png](media://fe411868-1a37-471c-9e18-d08c90c8a755)

A right click on a field name in the Import Buffer table, will display a menu with three items, the bottom of which is "**Find and Replace**".  
Click "**Find and Replace**" to open the below window.

> ℹ️ **Note:** The window is titled with the Field name that the operation will effect.

- Click the "**Enter value to replace with...**" field.
- Enter the value to replace it with, then click "**Apply**".
- A confirmation message will display. Click "**OK**" to continue.  
a success message is displayed.

![Import Buffer - Updates - Step 2.webp](media://734ec8ec-f5a5-4d8f-bd18-3f4b00d67a41)


## Import Layout Configurations

### Buffer Modifications

To access Buffer Modifications, click "**Import Layout Configurations**"  
A new "**Layout Type**" dropdown list has been added to the top left of the screen, This allows you the select a Layout Type.  
Layouts of the selected type are displayed in the list below.

Select the Layout to use.  
Buffer Modifications now support **Update To**, **SQL Delete** and **SQL Update** Actions.

![Import Buffer - Updates - Step 11.webp](media://5d5aac69-cb2b-4c6f-8535-aff556c60175)

Selected **UPDATE functions** and selected **SQL UPDATE statements** are supported in DataShed5 when using buffer modifications on a saved layout.

- The SQL Update tool has 3 uses:
  - Set one field equal to another field in the buffer table or a constant
  - Use the Where clause to filter records to apply the SQL Update to
  - Use the CASE WHEN statement to apply various values to replace

> ⚠️ **Limits:** The SQL Update can’t be used in combination with Functions from Update To


**Syntax examples**  
Set a field’s value using the Where clause  
Program_Type = ‘Grade Control’ Where Prospect = ‘Nswazwi’  
Program_Type = Comments Where Comments = ‘Grade Control’  
Case When  
Core_Diameter = CASE WHEN Hole_Type = 'DD' THEN 'HQ' WHEN Hole_Type = 'DDH' THEN 'PQ' ELSE 'NR' END

When using constant text or dates in functions, the text/dates need to be enclosed in double brackets “ “  
Example: ISNULL(Orig_Grid_ID, "MGA94_51")  
or DATEDIFF(day, "01/01/2025", "24/04/2025")

![Import Buffer - Updates - Step 16.png](media://015e961a-8fe4-42c9-9990-0e3bfa3c6672)

When the Buffer Modifications have been configured, click "**Save**". Then return to the Import Data screen.

Select your **Layout Type**, **Import Layout** and then click "**Load File**"  
Select your import file. Apply a Date Format. Then click "**Load**".

![Import Buffer - Updates - Step 18.webp](media://d33cf0cc-f19e-4735-8cd9-e1fadcbf0c21)

The Import Buffer will load containing the Buffer Modifications as below.


![Import Buffer - Updates - Step 21.png](media://29acc0c6-70df-48d5-bbcd-f70c95e59e47)

Here is the raw CSV file used for the import.

![Import Buffer - Updates - Step 22.png](media://71cea026-5e11-45a1-bc4b-bcd1a47e8185)


## Importing Assay Files

Assays can be imported under the import menu item. First you need to configure your assay layout then you import the assay file and fix any potential errors with the loading.

### Assay Import Process

When DataShed initiates the assay import process, the following process occurs:

- **Data Validation:** Assays are loaded into an incoming buffer table, enabling checks to ensure data integrity. DataShed5 scrutinizes the lab method, element, unit, and lab libraries to validate data against these standards. The Generic Method is updated based on the Original Lab Method, and the Element and Repeat fields are populated from the Lab Element library.
- **Sample ID Matching:** Incoming Sample IDs are compared with those in each Sample table.
- **Result Calculation:** DataShed5 calculates the sysResult from the Assay Result. Text fields are converted to corresponding substitution values, and the text equivalent is entered into the sysAssayStatus field.  
Automatic Record Merging: The system automatically merges records that have successfully passed validation. The assays are subsequently ranked post the merge process.
- **Handling Unsuccessful Records:** To review unsuccessful records, navigate to the Assay Manager. Unmerged data is listed in the Unmerged Assay Results section. Upon resolving the unmerged data, click the Process Batch button. DataShed5 conducts checks and attempts to merge the data seamlessly.

### Import Layout Configurations

To configure your Assay Import Layout, first you need to click on the ‘**Import Dat**a’ menu item and then ‘**Import Layout Configuration**’ button in the top right corner.

![Import Data - Assay Files - Step 6.png](media://c37a33a3-c4b9-464e-b0f2-bb6d92e95d4e)

To make setting up imports easier and more intuitive, the Import Layout Configurations selection has been simplified by adding a "**Layout Type**" dropdown.

This will only display Layout Configurations for the selected Layout Type.

In this case, select "**Assay File**".

![Import Data - Assay Files - Step 8.png](media://027af6e2-80ca-4fad-b5e1-8fc667bc9010)

The import layouts page shows the existing import layouts on the left, you can search, delete (Bin Icon) and edit existing import layouts. A new layout can be added by clicking “**Add New Layout**” button at the top left of the screen.

When the “**Add New Layout**” button is clicked, the Import Layout page is opened for the user to enter the details of the Import Layout. During this process the existing Import Layout list is disabled until the new layout page is saved or closed.

![Import Data - Assay Files - Step 9.png](media://772927cd-218b-471d-837f-d8165c33b3e4)

Once you have entered the details of the Import Layout, click ‘**Save**’ button to save the import layout or ‘**Close**’ to cancel the creation. Once the new layout is saved, a successful message is displayed at the top right, and the created layout should be selected by default.

![image](media://29ee0b74-93ac-4304-8f5f-bc350b2e43fc)

### Select Import Layout Type

Next you will need to select the ‘**Import File Type**’ from the dropdown list. For example, “SGS CSV Format” is selected for '**Import File Type**’. The selected file type is saved to the database on selection. The save successful message is displayed on selection.

![image](media://7a1fea48-b1ac-45a4-b2b5-d59c141eb355)

### Import Layout List

The ‘**Import file type list**’ can be managed by click on the ‘**Import file type list**’ icon. When you hover the mouse over on the icon, the “**Import file type list**” tooltip is displayed. (As below screen grab)

![image](media://c709e607-cfed-4de3-9704-b331aaf80d85)

Clicking “**Import file type list**” opens the file type list pop up which allows you to:

- Add a new file type using the **+** Icon and updating the information for the new file type. File Type and Description Fields are required.
- Edit existing file types by either editing directly into the cell or using the provided drop downs.
- Delete/bulk delete file types by either selecting one or multiple rows using the checkboxes on the lefthand side and selecting the ‘**Delete**’ trach icon at the top left.

> ℹ️ **Please Note:** You are required to click the “Save” button to save the details to the database. Closing the popup without saving may lose changes you have made.

> ℹ️ **Please Note:** You cannot have a duplicate File Name or Description; a warning will appear if you attempt to save a supplicate record.

![image-20250701-051432.png](media://a1358a70-3068-4645-ac7f-362c95fa8ede)

Once you have successfully updated the Import File Types and click save you will receive a successful message as per below. 

![image-20250701-051652.png](media://4e35b58b-d12e-4ee0-bc76-b4d0bd3ef8b4)

### Assay File Format Editor

Next you will need to select the 'Assay file format editor’ icon.

![BufferMods7.jpg](media://fb61413f-e2f3-4af3-a99e-caff28643eed)

> ℹ️ **Please Note:** The Assay file format editor doesn’t appear until the destination table under Buffer Modifications has been selected.

Once you have clicked the ‘**File icon**’ (Assay file format editor), the Assay File Format Editor page will be opened in the same page.

The Assay File Format Editor displays the selected file type description as Scheme Name. 

You can now upload the **.csv** and **.sif** file types by clicking “**Select File**” button. 

> ℹ️ **Please Note:** DataShed5 only supports these two file types.

![BufferMods8.jpg](media://a8ab5988-8bd8-46e4-a645-3a31c4f23108)


Once you have selected your file, The Layout Definition panel can be seen under the file editor panel. The layout definition can be defined for each file type. 

In the Layout Definition go to the Data Item drop down list and select a Data Item.

For each comma delimited field, click the mouse cursor at the start of each comma delimited section. 

![BufferMods8a.jpg](media://d18c0284-7ea1-40a1-8f1e-2298bb217563)


When selecting another Data Item, the value for previous selected Data Item will be saved automatically. Once the layout definition has saved successfully a message is displayed.

![BufferMods9.jpg](media://903fecd3-3754-43a6-982e-cfb2b5c73caf)


### Import Substitution

To manage substitutions, click the “**Substitution**” button. The import substitution list popup window will be open. From there you can add, edit or delete substitutions. 

Click **+** icon button to add a new substitution. The substitution set is pre-populated with the selected file type. (For example, SGS_CSV)

The Symbol and AssayStatus fields are required fields. So, leaving these fields empty, the following error message will be prompted.

![image-20250701-052235.png](media://93859c84-d359-4b87-a5a5-a9cbab10d9df)

The Symbol and other fields are free text fields, but AssayStatus value can be selected from the dropdown list.

> ℹ️ **Please Note: **You cannot duplicate the substitution set and symbol.

![image-20250701-052315.png](media://86072109-b1f5-452b-85dd-a7206fbece5f)

Once the new record is added to the list, make sure you click the “**Save**” button to ensure that the data is saved to the database. 

> ℹ️ **Please Note:** Clicking the “**Close**” button may result in losing the pending changes so the system will always show the confirmation dialog for unsaved changes if there are any pending changes.

![image-20250701-052349.png](media://7db564e5-de3a-496e-85da-2aa00c9b2c6c)

Clicking “**Save**” button will save the new substitution record to the database and display the saved successful message.

![image-20250701-052511.png](media://4947e021-a8fd-4eac-a0d6-6b8d1b538302)

Editing existing substitution records is same as adding a new substitution records. Go to the field that needs to be edited, update the value. Then click the “**Save**” button to ensure that changes are saved to the database.

To delete a substitution you can either single delete and bulk delete by selecting the substitution record(s) and clicking the ‘**Bin icon**’. The selected substitution record(s) will be deleted from the list.

![image-20250701-053133.png](media://3219d189-da23-4bf5-b002-ba633de8b486)

Then click the “**Save**” button to ensure that the records are removed from the database.

![image-20250701-053157.png](media://802f54d3-4c42-4325-aefa-1fcf4b56a52d)


### Import Validation

Once you have finished updating your layout definition and substitutions you can validate the layout by clicking ‘**Validate**’ button. The system will go through the saved data items for the selected file and display the data items in the result pop up (As below diagram).

The progress bar shows the validation progress. The “**Copy to clipboard**” button allows you to copy the result to clipboard.

![image-20250702-054334.png](media://92a11e5e-ddd1-48de-87a9-ac9a6e3f61d0)


### Buffer Modifications

The Buffer Modifications panel opens when you click the ‘**Buffer modifications**’ button (The checklist icon). When you mouse over on the checklist icon button, you will notice a “**Buffer modifications**” tooltip is displayed. (As below diagram)

![BufferMods.jpg](media://dd6b4115-1f97-4643-bdc4-da95dd0b7d4b)


The buffer modifications section has a Destination Table Name dropdown. Here you can choose which table you would like the file to be imported to.

> ℹ️ **Please Note:** Once you have selected your destination table, please click save to save the selection to the database.

![BufferMods2.jpg](media://eaf8a039-3b4a-4eeb-af7d-3d6fb0fcaf18)


Click plus icon button to add a new field modification. The FieldDB column and Action columns have dropdown lookup lists to select from which is based on the selected import file type.

> ℹ️ **Please Note**: there is no validation check for any of the fields.

![BufferMods3.jpg](media://c1149988-6813-48b9-b444-5821c30887d6)


Once you have added new buffer fields modifications you need to click “**Save**” to ensure that the record(s) are saved to the database. A saved successfully message is displayed on clicking “**Save**” button.

![BufferMods4.jpg](media://855e806d-e08b-4ff6-ac1f-59767cec6ec0)


To edit a modification, simply select a field, edit it as required and click ‘**Save’** to save your changes.

To delete a modification simply select one or more records and click the ‘**Bin Icon**’. These records will be removed from the list. Once again, click '**Save**’ to save you changes.

![BufferMods5.jpg](media://be4b3508-d6fe-4f66-b4a9-0330621a1250)


### Check Config:

Next, you will need to check your configuration. Once you click the ‘Check config button’ (The check mark icon) The Check Config panel will open.

![BufferMods6.jpg](media://033c5a72-adfd-4b1e-acca-1fb4de1c8509)


The ‘**Check Config**’ section has two boxes, one is for the config description, and one is for any errors which may be found.

There are three main buttons ‘**Check Config**’, ‘**Check Config for All**’, ‘**Save to File**’.

- The '**Check Config’** button checks the configuration for selected import layout.
- The ‘**Check Config for All**’ button checks the configuration for all import layouts in the system.
- The ‘**Save to File**’ button export and download the diagnostic result in .dsd file.

Once you select either the '**Check Config**’ or the ‘Check Config for All’ buttons, you will notice the Check config boxes will be populated with successful checks and errors as per below.

![image-20250702-055903.png](media://692a05dc-c112-4d8e-8b6a-7e254d0e88db)

Clicking the “**Save to File**” button will export and download the **DataShed Diagnostics File.dsd** file. The file can be opened in notepad. 


## Importing pXRF Data

This guide offers a clear, step-by-step process for importing pXRF sample and assay data from Excel and CSV files. It covers layout creation, data review, and appending for both drillhole and surface samples. Designed to streamline data input, the guide helps users improve accuracy and efficiency in managing geochemical data for their projects.

### Import pXRF DH Sample Data

1. Click "**Import Data**"
2. Select the Import File format type - in this case an Excel file
3. Click "**+ New Layout**" to create a new Import Layout.
4. Click "**Load File**" to open the File Loader modal window.
5. Select "**XRF DH Samples**" for DH Samples.
  - For Point Samples, select "XRF Surface Samples".
6. Select the file and worksheet to import.
7. Select a default DataSet (if required) and a Date Format.
8. Match the fields to import and delete unrequired fields.
9. Click "**Save Layout**" to save the Layout.
10. Enter a Layout name and click "**Ok**".
11. Click "**Load**" to load the import file to the Import Buffer.
12. Review the data in the Import Buffer. When satisfied the data is correct, click "**Append Data**".
13. A message "Data has been appended successfully." is displayed for a successful file import. The Import Buffer will be empty.

![Importing pXRF Sample and Assay Data - Step 1.webp](media://a80a47f5-b01c-420a-b6e7-a6d3972579f7)


### Viewing the imported Samples

1. Click "**View Data**"
2. Expand the **XRF Management** module.
3. and select "**XRF DH Samples**"
4. Apply a filter to see the imported samples.

![Importing pXRF Sample and Assay Data - Step 16.webp](media://a5814d22-b252-44dc-9e83-96b273746587)


### Importing pXRF Assay Results

- To import a pXRF file, select **pXRF File** from the drop down list.
- Then select "**+ New Layout**" from the Select Import Layout drop down.
- and click "**Load File**" to open the pXRF Import Layout screen.
- On the pXRF Import Layout screen, select the pXRF file to be imported.

> ℹ️ **NOTE:** pXRF files must be in CSV format and the Element Columns must be the right most columns.  
> ℹ️ Select the **Date Format, Units, Lab Code** and **Lab Method** from the drop down lists.

![Import Data - pXRF File - Step 1.webp](media://f61ab03e-e319-4979-a26a-fb44d5f37e48)

### Field Matching

In the Import Layout table, we will automatically try match 'From’ and ‘To’ fields if the names match. These are displayed below. Required fields that are not matched will be displayed in a blue color.

**Please Note:** Not all fields need to be mapped for you to save the layout or load data. If you do not map a field and attempt to load the data, only the fields you have mapped will be displayed in the buffer table.  
For matching the Elements, only the first pXRF Elements needs to be matched. The importer will automatically identify following Elements.  
Saving the layout is a required step before loading the data. To save the layout, click "**Save Layout**"  
then enter a valid Layout Name. If you click the "Load" button without saving the layout, a warning will display in the top right of the screen and the Save Layout screen will display.

After entering a name, click "**Save**".  
A "Saved layout successfully." message will be displayed.  
When the Layout Configuration is complete and the Layout saved, click "**Load**". The file will be imported as per the Layout Configuration.

> ℹ️ **NOTE:** Any unmatched fields will not be imported.

![Importing pXRF Sample and Assay Data - Step 28.png](media://fb468bfc-3a9b-4863-8b69-296989fac399)


The Import Data dialog shows the import progress and will notify any errors in red. The example below show a successful import.

Click "**Close**" to return to DataShed. The loaded pXRF data will be available in Assay Manager.

![Import Data - pXRF File - Step 15.png](media://d435e722-5087-45a7-95f0-630d4847493d)

### Viewing the imported pXRF Assays

1. Click "**View Data**"
2. Select the "**XRF Management**" module.
3. Open the "**XRF DH Results**" table.
  1. For Point samples, open the "**VW XRF Results**" table.
4. Set an appropriate filter

![Importing pXRF Sample and Assay Data - Step 38.webp](media://1fc40d90-1a46-4e00-aad6-26f65bdff06b)


## Import Control Points

To import Coordinate Control Points, you need to select the import Layout ‘Control Points’ and click ‘Load File’

 This will open the Import Layout editor. From this window you have the option to select the File to import. Once you have selected your CSV File, the Import Layout table will be displayed as per below screen grab.

> ℹ️ **Please Note:** The file type must be CSV and the format must be as indicated in the red rectangle below.

![image-20250702-061841.png](media://da76e212-e5a8-420e-803a-deb2b1284698)

In the Import Layout table, we will automatically try match 'From’ and ‘To’ fields if the names match. These are displayed in the screen grab above. Fields that are not matched will be displayed in a peach color.

After the fields have been correctly mapped, click the Load button to load the Control Points data to the Import Buffer.

### Import Buffer Table

Control Points data will be loaded to the SRS Control Points table located in the Database Management Module.

![image-20250702-062402.png](media://b4ff80fb-f94b-44d2-aa91-7468144082f7)

### Add and Edit Coordinates

Coordinates are maintained in the “**DH Coordinates Normalised**” table located in the Drilling Management Module.

Click the **+** button to add a new record. If a transformation has been defined for the Grid ID, transformation records will be automatically generated when the new record is saved. The system prioritises the measured source coordinates for transformations based on the highest **Confidence Level** and best priority **Survey Method**.

Additionally, a Lat/Long transformation is automatically added to the collar record and is always kept up to date as the coordinates in the DH Coordinates table change over time.

If a new coordinate record with higher accuracy is entered — like one surveyed via DGPS — the system will regenerate the transformation records using the best coordinates available, and the collar Lat/Long fields will update to reflect the more accurate values.