Table of Contents

Using the Pd Data Extractor.

Issue

This describes how to use the new Pd Data Extractor.

Explanation

Some configurations require that data be extracted from a database using custom data prep program. The Pd Data extractor was created for just that purpose. The data extractor requires version 6.685 or higher of Intersection Magic and a supporting configuration. This article gives a brief description on how to run the extractor for a standard extraction.

Solution

The custom data prep program extracts data from a database into a text file that Intersection Magic can import. You must have a supporting configuration and version 6.685 or higher.

  1. Open Intersection Magic.
  2. Select Utilities/Database/Import.
  3. Click the button ÒClick here to execute your custom data prep programÓ.
  4. Click the button ÒClick here to select the input database file nameÓ.
  5. Browse to the MS Access data file from that you would like to import. It should have a *.mdb extension. (The default database is Access, but others can be selected in the advanced tab).
  6. Click the button ÒClick here to begin extractionÓ, and accept the default location for the temporary text file.( If you need to change the file location and/or name click on the ÒClick here to select the output file nameÓ)
  7. Click the Ok button when the extraction has finished.
  8. Click the Exit button to close the Pd Extractor window.
  9. Click the Ok button in the Import window to begin the import process.
  10. Click the Yes button to confirm the Import.
  11. Review the logs when finished.
  12. If everything was done correctly it should only contain one error ÒImport errors   (critical errors. record not imported): 1Ó Line one will not be imported. Line one contains the field definitions for the import file, and is not imported.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?