Wonderware Historian Database Import/Export Utility — How to use the import feature with a manually created Industrial Data Acquisition Service (IDAS)

Tech Note: ISS-TN067
Published Date: June 26, 2008
Primary Product: Historian Server
Revision Date:

Applies to

  • Wonderware IndustrialSQL Server/Historian version 9
  • Wonderware Historian version 10

Abstract

It may become necessary for a developer to create an IDAS in Wonderware Historian that views many data points without having an InTouch HMI application to import tags from. This document provides the procedure necessary to utilize the Import Tags feature of Wonderware Historian without an existing Wonderware InTouch application, as well as how to use the Wonderware IndustrialSQL Server database export/import utility for archiving or troubleshooting.

Procedure

1. Create a new IDAS and applicable Topic through the System Management Console. Once you have created your IDAS and Topic information, create a new tag by right-clicking on your Topic and selecting New * Tag, where * is either Analog, Discrete, Event, or String.

NOTE: One tag will be created for every “type” of tag you need.  For instance if you need 1,000 analogs, 500 discretes, and 70 strings, then here you would simply create 1 analog, 1 discrete, and 1 string.

2. Once you have created your tag you should be able to view it in the right-hand pane and make any changes necessary before proceeding.

3. The next step in the process is to Commit Pending Changes, so that the Wonderware IndustrialSQL Server database can be properly updated with the new information. Navigate to Action->Commit Pending Changes and click Commit button.

4. Click the OK button to continue.

5. Now we need to export the IndustrialSQL Server database. To complete this action navigate to: Start->All Programs->Wonderware->IndustrialSQL Server->Database configuration export and Import.
Select the Export from InSQL to a text file radio button from the Welcome screen and click Next.

6. In the Connect screen enter valid SQL Server or Windows authentication credentials, along with the directory where you wish the exported text file to save to.

Note: Make sure that the Export all objects checkbox is checked (the InSQL database export utility will NOT export IAS tags).

Click Next.

7. If you have previously exported a copy of your Industrial SQL Server database to the desired directory with the same name, then the following message will be displayed. If not, then proceed to Step 8. If so, then click the OK button to continue.

8. The last screen before the action is completed is the Confirm screen. There is nothing to configure here, yet it does give one last opportunity to go back to a previous step before the export is created. Click Next.

9. Once the export file is successfully created click the Finish button to complete the export process.

10. Navigate to where the export file was created. Right-click on the file and select Open With->Microsoft Office Excel.

11. Locate the newly created tag for your IDAS, and then insert as many lines as needed to add the rest of your tags by right-clicking on the cell below and selecting Insert.

Note: Data in the export file is grouped by type. If you need to add discrete tags, then you will need to add them to the :(DiscreteTag) section, for strings it is the :(StringTag) section and so on. Column A contains section names.

12. Copy the entire row with the tag created in the System Management Console, and then proceed by pasting it into the new blank rows created in the preceding step.

13. Modify the name after pasting the original to avoid duplicate tagnames. Here you can also specify different parameters for the copied tags (such as min/max EU).

14. When finished close Microsoft Excel. You will receive a message asking if you would like to save your changes. Click Yes to proceed.

15. The Save As window will appear. Navigate to the export file, left-click on it once to select it, and then click the Save button.

16. A message will prompt you letting you know that the file already exists. Click Yes to replace the existing file.

17. You will receive one final dialog letting you know that some of the features may not be available if left in the .txt format. To continue select Yes.

18. Begin the import process. Navigate to: Start->All Programs->Wonderware->IndustrialSQL Server->Database configuration export and Import. Select the Import from a text file to InSQL. Click Next to proceed.

19. Enter valid SQL Server or Windows authentication credentials, along with the directory where the text file containing the database is located. Click Next.

20. Click Next in the Confirm screen to continue.

21. Once the import has been successfully accomplished the Status screen will have an informational dialog box stating that the Import succeeded. Click the Finish.

22. Make sure you Commit Pending Changes.

23. Once the pending changes have been committed you should be able to view all of your new tags contained within your Topic.


All Industrial Software Solutions Tech Notes are provided "as is" without warranty of any kind.