Data Exporter

Data Exporter

The Data Exporter application is used to build, update and export data files for use by IPT. The term 'build' refers to the process Specify uses to load data into the skeleton, or schema, of a database. Before a data file can be built a 'schema map' must first be created using the Schema Mapping Editor inside Specify. If you have not created a schema map you will need to close the Data Exporter tool , reopen Specify and create the schema map using the Schema Mapper tool. For documentation explaining how to create a schema map please refer to Web Publishing.

The Data Exporter tool actually creates a table, or cache, in the database containing all relevant data based on the map that was created from inside Specify.  This table of data then needs to be exported from the Data Exporter tool as a tab delimited text file for importing into IPT. 

The Data Exporter application is located in the bin directory within the Specify application directory, which stores the executable files for Specify. Double click Exporter (or select it from Start/Program Files/Specify on Windows) to launch the tool. Users are required to login using their Specify Username and Password.

The Data Exporter application opens as a three-column table with action buttons.

Data Exporter

  • The 'Mapping' column of the table indicates the name of both the mapping and table.
  • The 'Last Update' column lists the date and time of the last update of the cache.
  • The 'Status' column indicates whether the cache is out of date, and, if so, how many rows are out of date. The number of out of date rows includes the number of rows that have been deleted from the database together with the number of rows that need to be updated due to changes in the database and the number of new rows in the database which must be added to the cache. This information reflects the database contents at the time the exporter was launched; it will not reflect changes to the database that occur while the exporter is running.

 

Available Actions


Show SQL - Click this button for a mapping whose cache has been completed to generate a dialog showing an SQL select statement that can be copied and used when defining database connections to the cache for IPT or other data providers.


Note: the SQL is based on the current cache structure. If the cache needs to be rebuilt and mappings have been changed, the SQL statement generated will not reflect the changes until the cache is updated.


Update/Build - This will update the cache. When the cache is built or updated it is writing to the database; therefore, the username and password for the database is required before Specify can complete the task.


For caches that do not need to be built, only out-of-date rows are updated. This is significantly faster than an initial build which can take a long time.  Updates are not allowed for mappings that are being edited or updated by another user; therefore, users should close all schema mappings before updating.


Export - This exports the current contents of the cache to a tab-delimited text file.


Note:
The CURRENT contents are exported, if the cache needs to be updated, you should update first if you want to export the latest data.


Canceling an Operation - You can cancel an update or export by clicking the ‘X’ button to close the application window. You will be asked to confirm the cancellation. If you cancel, you will need to start from the beginning the next time you perform the operation.

Note:  If you cancel an update that required a rebuild, the pre-existing cache will have been deleted.