Data Exporter

Data Exporter

The Data Exporter application is used to build, update and export data files for use by IPT or a web portal. 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 is then indexed and exported, along with other relevant files, for use in a web portal. Or, the cache is exported 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 DataExporter (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.

export_tool

Data Exporter Tool

  • 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 has ever been build, up to date, or out of date. If the cache is out of date, it also indicates the number of rows which require updating. The number of out of date rows includes the number of rows that have been deleted from the database, edited in the database and added since the last update. 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.

  • Build/Update - 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.

Note: building/updating the cache will require the IT (MySQL) Username and Password.

  • Export - This exports the current contents of the cache to a tab-delimited text file for IPT.
  • Export for Web Portal - Files for Solr and the web portal will be generated and exported as a .zip file.

Cancelling an Operation - You can cancel an update or export by clicking the close_hover (close) 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.