Import/Export Data

The Import/Export Data function lets you archive, delete, import, or export SPC or DMS data.

 

Contents  [Hide]

  

Accessing the Import/ Export Data function

Import/Export Data is accessed from the Import/Export Data button on the GainSeeker Utility module:

 

Exporting data

Exporting data to a file is useful for transferring data files to other GainSeeker users. It can also be useful for archiving data.

The data can be exported using XML or TAB file formats.

Note: When using the Export to archive data, you should use the XML format. This format exports any notes as well as hidden fields. It also encodes the date format from your Windows Regional Settings, which allows someone with a different date format to import this data correctly.

To export data:

  1. Select whether you want to perform the intended action on SPC or DMS data. The SPC options tab displays by default on the Import/Export utility, or you can click the DMS tab.

  2. Click the Export button.

  3. Create a file in which to save the exported data.

The Chose a File to Export dialog opens with the File name: field prefilled with the current date and time (see image below), but you can change the filename to whatever you want. GainSeeker prefills the file extension type as .xml by default. You can opt to change the extension type to .tab .

Example: The filename prefills reflecting the current date. In this example the filename is prefilled as D131011 (D=DMS [or V=SPC] 13=year, 10=month, and 11=day). You can re-enter text for the filename to whatever you want and opt to change the extension type from .xml to .tab .

  1. Click Save on the Choose a file to export dialog.

The Export Data Utility opens. See Using the Export Data Utility

Importing data

You can import data that has been saved to a file.

  1. Select whether you want to perform the intended action on SPC or DMS data. The SPC options tab displays by default on the Import/Export utility, or you can click the DMS tab.

  2. Click the Import button.

  3. Choose a file to import on the Choose a file to import dialog.

The Import Data Utility opens. See Using the Import Data Utility

Note: If you are importing a .tab file that you exported from GainSeeker and then edited in another program (such as NotePad or Excel), the file must contain all of the columns that were initially exported.

If you are importing a .xml file that you exported from GainSeeker and then edited in another program, and the originally exported data still exists in GainSeeker, you have two options:

    • Delete the data from GainSeeker (see below) before importing.

    • Import the data and replace the existing GainSeeker records ("duplicate" records) with the data in the file. If using this method, you should ensure that the file contains all of the columns that were initially exported - especially when clearing some traceability values.

Deleting data

You can delete a range of data you select.

  1. Select whether you want to delete SPC or DMS data. The SPC options tab displays by default, or you can click the DMS tab.

  2. Click Delete on the Import/Export utility.

The Delete Data Utility displays a list of all available SPC or DMS part numbers. See Using the Delete Data Utility