Français

DataImporter : Example of importing data with Excel

Modified: 2008/08/25 09:00 by dgutman - Categorized as: Technical
The program ESI.Octopus.DataImporterApp.exe, located in the Octopus installation directory, allows data to be imported from any ODBC source (including Excel).

You can use DataImporter for an initial import as well as a daily data synchronization with an external source (for example, synchronization with SMS).

To obtain more details on the utilization of DataImporter, click here.

Edit

Example

The following steps explain how to import the workstation "VISTA_PCTEST", the monitor "3334_TEST", and the relationship between the workstation and the monitor. To delete the imported data, you simply have to delete the workstation and the monitor. 1. Copy the files contained in CIen.zip into the C:\ directory.

The file CI.zip contains the following 2 files :

  • CI.xls : Excel spreadsheet containing the data to import into Octopus.

  • CI.xml : declaration of data sources used by DataImporter.

2. Start the program cmd.exe to execute DataImporter.

  • Change the current directory to the Octopus directory.

cd "C:\Program Files\Octopus"

  • Start DataImporter while specifying a valid Octopus user.

ESI.Octopus.DataImporterApp.exe /login:user name /password:password /configfilepath:C:\CI.xml

Administration | This wiki was designed using ScrewTurn.