---
title: "Export Data v3.2.0.1"
canonical: "https://servicedesk.maxgeo.com/space/DS/1752727565/Export%20Data%20v3.2.0.1"
format: markdown
---
The Export Data menu option allows the user to extract and download data from the database. Users can choose from the download types ‘**Table**’, ‘**Layout**’, and ‘**Scheme**’, the option selected then defines the other selections available.

Data can be downloaded in the following formats:

- Microsoft Access
- Microsoft Excel
- Comma Separated Values (CSV)
- Fixed Width text

> ℹ️ **Note** that not all these options are available for all download selections. Some formats may be incompatible with or inappropriate for the selected item or items to be downloaded. Only formats supported for the current download selection will be shown in the ‘**File Format**’ selector.

![image-20250702-070733.png](media://15950df0-dfd8-4fe8-bb20-e130811c967d)

A **Settings** option is available, that will allow downloading quoted and non-quoted files for a comma-delimited format.

![image-20250702-070801.png](media://58ce9f1d-bbf2-4e18-b6df-ab64d0fbf96d)

**CSV Export Consistency Enhancements:**

CSV exports in DataShed5 have been standardised across all export methods:

**Unified Column Headings:**

- All CSV exports now use underlying SQL field names as column headers.
- This applies to:
  - Export > Table (Export menu)
  - View Data Grids
  - Import Buffer
- Example: Hole_ID, Hole_Type, Max_Depth  
(replaces alias-style headers like Hole ID, Hole Type, Max Depth)

**Consistent Regional Format Handling:**

- Now standardised: All CSV exports will ignore machine regional settings and consistently use:
  - **.** for decimals
  - **,** for field delimiters  
This ensures predictable behaviour across systems and reduces confusion.

### Table Option:

If the ‘**Table’** download option is selected, the user can then select the desired file format for the download, and then select the table (or view) from which data will be extracted. When the ‘**Download**’ button is pressed the content of that table or view will then be downloaded to the user’s computer.  The ‘**Download**’ button is hidden until a valid option has been selected in all of the required fields. On option for ‘**All Columns**’ will display for Download Type Table.  When unselected the data downloaded will contain the columns selected and the columns order by the user in the Display option for the grid.  When selected all columns for the table will download.

![image-20250702-070956.png](media://adab74c0-1b7e-4674-9bab-e46f95f003e8)

### Layouts:

The ‘**Layout’** download option presents the same file format options as the ‘**Table**’ selection, with the addition of a fixed Width file format. The user selects the data source as before, which is a table or view in the database. DataShed5 then shows a list of the layouts available for the selected data source. Creating a layout will be covered in the following section.

If Validate option is selected, application will validate the selected layout and if there is no error or warning you can see Validate status as “**Validation Pass**” or else **Details**. Details link to display details of the error or warnings. And file will be downloaded.

If you don’t select Validate option status will show “No Validation Checked”.

Once a layout is selected for the source, the ‘download’ button is available to begin the extract/download of the data.

**Shared Layouts – Editable by All Users**  
Shared layouts are now fully editable by all users, not just the original creator. Once a layout is shared, it becomes a collaborative resource—any user level **(User to SysAdmin)** can now:

- Edit layout settings
- Rename the layout
- Delete the layout

**Export Scheme Layout Limit**

Users can now reliably add and save additional layouts to an export scheme, regardless of how many already exist.

A clear error message now appears if a technical or practical limit is reached, preventing confusion during editing.

There is currently no hard cap on the number of layouts in a scheme—users can create and manage large exports (e.g. 100+ layouts) if needed.

#### Creating a Layout

When creating a new layout, first you need to select layout type, File format and Data Source. Once these are selected a ‘New..’ options is presented under the ‘Layout/Scheme’ drop down.

![Export Data - Step 16 (2).png](media://e725f951-676e-4c23-ac36-6a1e88431291)

When the user clicks “**New…**”, it displays the popup window to enter a layout name to be created for selected table. If no name is entered, a warning will appear.

![Export Data - Step 19.png](media://d218bfea-5395-437f-8c7f-0d75116246a0)

If there is no validation error, the system creates a new layout, and then opens the Export Layout Editor in the pop-up. The Export Layout Editor fields table is empty for the newly created layout.

By clicking the “**Select All**” button, the system adds all fields from the selected table to the layout. Once again, click “**Save**” to save selected records to the database.

![Export Data - Step 20.png](media://12ca2f5b-4220-45d4-b632-b7dd924426cf)

The system allows the user to add fields individually by clicking + icon on the left corner. When adding a new field, the user can select the field from a dropdown list, and some values such as Name, Data Type, Decimals, Width, Seq No will be populated by default. The user has the ability to change these values.

![Export Data - Step 22.png](media://e826279b-345c-4b30-8509-ec37999783a4)

- A new “Decimals” column has been added to the Export Layout Editor.
- For fields where Data Type = N (numeric):
  - If left blank, decimal precision values are fetched from the SQL table tblSYSExportLayoutField.Decimals.
  - Users can manually override the number of decimals during layout creation or editing.
- For character (C) and date (D) fields, the Decimals column will remain NULL and non-editable.

![Export Data - Step 51.png](media://623b50b9-9396-4f28-bdf7-3b59859a5475)

**Export Layout Editor**  
The Export Layout Editor has been improved to restore key capabilities and streamline the creation of custom export layouts. These updates enhance user flexibility and accuracy when configuring export schemas.

**Key Enhancements:**

- **Restored “Output Type” Functionality**  
Output Type options (e.g. **Data**, **SQL**, **Value**, **Predefined**) allows advanced formatting, SQL logic, and predefined variables as shown in the legacy layout editor.
- **Auto-Naming for New Fields**  
When new fields are added, they are automatically named using the convention NewField1, NewField2, etc., reducing setup time and confusion.
- **Custom Value Field Type Support**  
Users can now insert custom export values using the "**Value**" or "**Predefined**" Output Type, with the options **#Username, #Date, #Now, #DataBase, #AppVersion** and **#DBVersion** supported for dynamic content injection.

![Export Data - Step 25.png](media://da4b88fd-7418-4368-ae44-20f746784ca0)

- **Layout and Schema Testing**  
Export layout configurations have been validated to ensure compatibility with existing schema requirements and export workflows.

![Export Data - Step 55.png](media://430ac55f-9d9c-461a-a6f0-1d39323768a0)

Once the field records are added, click the “**Save**” button to save the layout to the database.  

> ℹ️ **Please Note:** clicking the “**Close**” button before “**Save**”, will lose the data added or changes made to the layout.

![image-20250702-074158.png](media://87d102f5-994d-4f4f-b98e-198da1c643f8)

By clicking the “**Select None**” button, the system removes all selected fields for the layout. Once again, click “**Save**” to save your changes to the database.

![image-20250702-075223.png](media://385da564-2d2b-47c0-859a-752d626d2fd0)

To Remove individual fields or multiple fields use the “**Delete”** bin icon.

The “**Delete**” bin icon button is disabled when no row is selected. The button will be enabled when the user selects one or more rows.

The user can select one or more rows (by clicking the checkbox) and then click “**Delete**” bin icon button.

Once again, click “**Save**” to save your changes to the database.

![image-20250702-075249.png](media://79451bc1-cd04-4741-a110-5a7371abf2cd)

### Copying a layout:

When copying a layout, first you need to select layout type, File format, Data Source and layout. Once these are selected a ‘Action’ drop down appears with options to **Copy**, **Modify**, **Rename** or **Delete**. Select the ‘**Copy**’ Action.

![image-20250702-075714.png](media://27a2107f-eab3-40ee-be57-35b50ab62180)

A popup will be displayed to enter a name for copied layout.

![image-20250702-075735.png](media://75c97369-f2d5-42f9-bcf0-b2bd6afe9068)

Once the copied layout has been saved the Export Layout Editor will be displayed with the same functionality as creating a layout detail above. The user can customise the layout as required before saving and closing the Export Layout Editor.

### Renaming a layout:

When renaming a layout, first you need to select layout type, File format, Data Source and layout. Once these are selected a ‘Action’ drop down appears with options to Copy, Modify, Rename or Delete. Select the ‘**Rename**’ Action.

![image-20250702-075802.png](media://b098bb05-6742-4d3e-a69d-0bd9c812f885)

A popup will be displayed to enter a name for the layout. Once the layout name has been saved, a green successful message is displayed.

![image-20250702-075827.png](media://3c9230c2-e15b-4a4f-9006-f7aa74699cea)

### Deleting a layout:

When deleting a layout, first you need to select layout type, File format, Data Source and layout. Once these are selected a ‘Action’ drop down appears with options to Copy, Modify, Rename or Delete. Select the ‘**Delete**’ Action.

Upon selecting the “**Delete**” option from the action list, the confirm dialog window will be displayed to ask the user for confirmation.

![image-20250702-075851.png](media://a95ca50f-3354-46a8-bd5b-2ee222647d64)

If the user selects “**Yes**”, the system deletes the selected layout (**RenameTestDHCollar** – as per the above screenshot) and clears it from the Layout/Scheme dropdown. A successful deletion message will be displayed after the process.

![image-20250702-075907.png](media://bdaf9fda-f231-4f0a-a1f5-70c4128e4c2c)

if the user clicks “**No**”, the system will close the confirm dialog and go back to the main screen.

## Schemes:

The ‘**Scheme’** download option shows a list of pre-defined download schemes that are available. Schemes are created in DataShed, and typically consist of a collection of Layouts for various tables. Schemes can be selected for extraction in either Access or Excel format.

If the “**Validate”** option is selected, application will validate the selected scheme and if there is no error or warning you can see Validate status as “**Validation Pass**” or else **Details**. Details link to display details of the error or warnings. And file will be downloaded.

If you don’t select Validate option status will show “No Validation Checked”.

### Creating a Scheme:

When creating a new Scheme, first you need to select Scheme Download Type and selecte the ‘New..’ option under the ‘Layout/Scheme’ drop down.

![Export Data - Step 30.png](media://f9b57207-46fc-4290-81c1-f3eaa6abad1f)

When the user clicks “**New…**”, it displays the popup window to enter a Scheme name. If no name is entered, a warning will appear.

![Export Data - Step 33.png](media://d17abcab-14a8-4af5-ac76-d8d226473268)

If there is no validation error, the system creates a new Scheme, and then opens the Export Scheme Editor in the pop-up. The Export Scheme Editor fields table is empty for the newly created Scheme.

Users can conveniently select an Export Type and add layouts individually by clicking on the '**+**' icon located in the left corner. When incorporating a new layout, users have the flexibility to choose from a dropdown list of existing layouts and modify values of the Seq No and Destination Table name. The Seq number is the order by which the Layouts are exported in and the Destination Table Name is the name of the tab or table which will be exported.

![Export Data - Step 38.png](media://722d339b-aa6f-4a63-bb9d-341551bd42e6)

![Export Data - Step 40.png](media://4c9c7ab6-fce7-44d7-9ce8-9ee21b5e4adb)

Once the field records are added, click the “**Save**” button to save the Scheme to the database. 

> ℹ️ Please Note: clicking the “**Close**” button before “**Save**”, will lose the data added or changes made to the Scheme.

![image-20250702-080840.png](media://17f0f04b-1f2b-40b0-98e3-e65a6ec4ecd6)

By clicking the “Edit” button next to the layout name, the system takes you to the Export Layout Editor which will allow you to edit the Layout while building your scheme. Please refer to the Layout Editor Guide above to learn how to edit this section. Click “**Save**” to save selected records to the Layout and click ‘**Close**’ to return to the Export Scheme Editor.

![image-20250702-080928.png](media://fb2e5dd8-53c8-4786-a3b8-fde3eb1f2a83)

To Remove individual Layouts or multiple Layouts use the “**Delete**” bin icon.

The “**Delete**” bin icon button is disabled when no row is selected. The button will be enabled when the user selects one or more rows.

The user can select one or more rows (by clicking the checkbox) and then click “**Delete**” bin icon button.

Once again, click “**Save**” to save your changes to the database.

![image-20250702-080956.png](media://f243c42b-2675-4a81-9bdd-f45ed030f598)

Once the user saves the Scheme successfully a green successful message will appear as per below. You are now able to close the Export Scheme Editor without losing any of the changes you have made.

![image-20250702-081022.png](media://8f5cb790-35e5-433b-a38b-6c4564b2d775)

### Copying a Scheme:

When copying a Scheme, first you need to select Scheme type as well as the Scheme you would like to copy. Once these are selected a ‘Action’ drop down appears with options to Copy, Modify, Rename or Delete. Select the ‘**Copy**’ Action.

![image-20250702-081138.png](media://60614384-d5cf-4cfc-81cf-cf5ca890b37a)

A popup will be displayed to enter a name for copied layout.

![image-20250702-081155.png](media://cf53a866-8429-4f04-b6df-cb4569b57d04)

Once the copied layout has been saved the Export Scheme Editor will be displayed with the same functionality as creating a layout detail above. The user can customise the layout as required before saving and closing the Export Layout Editor.

### Renaming a Scheme:

When renaming a Scheme, first you need to select Scheme type as well as the Scheme you would like to rename. Once these are selected a ‘Action’ drop down appears with options to Copy, Modify, Rename or Delete. Select the ‘**Rename**’ Action.

![image-20250702-081217.png](media://e96c146b-2bae-4dc3-83e8-a24106b34a88)

A popup will be displayed to enter a name for the layout. Once the layout name has been saved, a green successful message is displayed.

![image-20250702-081230.png](media://15c717d3-1acf-46c9-9fc5-e630cf927892)

### Deleting a Scheme:

When deleting a Scheme, first you need to select the Scheme type as well as the Scheme you would like to delete. Once these are selected a ‘Action’ drop down appears with options to Copy, Modify, Rename or Delete. Select the ‘**Delete**’ Action.

Upon selecting the “Delete” option from the action list, the confirm dialog window will be displayed to ask the user for confirmation.

![image-20250702-081249.png](media://cdd6b0e8-5fa8-47c9-8571-fcc0eec9c1e7)

If the user selects “**Yes**”, the system deletes the selected Scheme and clears it from the Layout/Scheme dropdown. A successful deletion message will be displayed after the process.

![image-20250702-081422.png](media://8ff096c4-8965-4904-9c98-aab2515677e9)

if the user clicks “**No**”, the system will close the confirm dialog and go back to the main screen.

### Sharing a Layout or Scheme:

 

If you would like to share a Layout or Scheme with other users, you can check the ‘Share Scheme or Layout’ option when creating your Scheme or Layout. As per the below screen grab.

![image-20250702-081506.png](media://4375991b-28ce-45c7-8883-86bc4de914ec)

Once The Scheme or Layout has been edited as successfully saved the Scheme or Layout will have a** #** Infront of their name to display that they are a shared Scheme or Layout.

![image-20250702-081523.png](media://11283fbc-967a-4275-9d4a-d6233e9ebc5c)

## Downloading a Scheme, Layout or Table:

After a Scheme, Layout or table has been selected, the ‘Download’ link becomes available to begin the download.

![image-20250702-081549.png](media://8d4c4d05-0c7a-4ced-a642-90b65e1dc2f2)

On selecting Download, a download table will display as above showing the status of the download. Once the download is complete, the Status will display ‘Downloaded’ when successful or Error when an error occurs. If an error occurs, the user will be able to select the Error link to display details of the error.

Downloads can be queued allowing for multiple downloads to be selected. Each download will be displayed in the table that has been requested and a status will display.  A ‘**Cancel’** option will be available for the download that is currently in progress. Selecting the cancel option will cancel the current download and progress to the next download if one has been queued. Selecting the ‘**Remove’** button will remove the download from the display list.

![image-20250702-081611.png](media://c64be481-52dd-4c10-bbff-5e07a2eccdb9)

**Validation Check Rules:**

- Check export layout data source exists in MDS.
- Check exported fields are mapped to the correct datatype.
- Check export layout fields exist in MDS data source.
- Check export fields configured with a SQL output type, checks for valid SQL.
- Check predefined export fields have correct format.
- When downloading a scheme, check if the user has access privileges to each layout in the scheme.  A warning will display if the user has no access privileges to a layout in a scheme and will not download data.

![image-20250702-081712.png](media://d496120f-9510-43bf-aa4d-5fcaf011daf3)

There is “**Copy Validation to Notepad**” option, by clicking this button all the validation check results will be copied to notepad on client side.

 

When downloading a date field for a layout or scheme the format of an export layout date field configuration, where Data Type = C-Character, will export a date format consistent with the current browser language settings and  Data Type =D- Date, will export a date with format dd-MMM-yyyy HH:mm:ss.

Regardless of which download format is selected, only data that belongs in the currently active DataSet Selection AND also conforms to any active Cascade Filters will be extracted.