Create an ID conversion file

Use this procedure to create an ID conversion file for archive reprocessing. The file maps PointID and Recno values from the source PI Data Archive to the corresponding points on the target PI Data Archive. During migration or reprocessing, the ID conversion file ensures that the archived data is written to the correct points.

Note: For details on required columns and file constraints, see ID conversion file.

Prerequisites

Before you begin, perform the following tasks:

• Run the piconfig script on the source Data Archive.

• Run the piarchss executable on the target Data Archive.

• Verify that all required destination PI points exist on the target server.

• Identify which points require mapping or remapping.

Generate the ID conversion file

1. Open a command prompt on the source PI Data Archive and navigate to the %piserver%\adm directory.

2. Create a piconfig command file named ptidconv.txt with the following contents:

   @table pipoint

   @ostru pointid, recno, tag

   @select tag=*

   @ends

3. Export point information by running the following command:

   piconfig < ptidconv.txt > ptidconv.out

4. Open ptidconv.out in a text editor and remove:

   • Lines beginning with an asterisk (*)

   • Summary lines such as “PIconfig”, “0 Data lines”, “4 Command line”, “0 Records in error”, and “### Records Listed”

     The file must contain only three columns: PointID, Recno, TagName

5. (Optional) Edit the TagName column if you need to redirect archived data to different tags.

   For example, update the third column to map a source point to a different target tag.

6. Save the cleaned file as ptidconv.out using ANSI encoding.

7. Copy ptidconv.out to the target PI Data Archive.

8. On the target server, open a command prompt and navigate to %piserver%\bin (or %piserver%\adm on older versions).

9. Create the binary ID conversion file by running:

   piarchss -idci <path to ptidconv.out> -idco <path to ptidconv.bin>

10. Reprocess each archive that requires mapping by running:

    piarchss -id <path to ptidconv.bin> -if <input archive> -of <output archive>

    After processing is complete, register the output.

Troubleshooting

• If the input file contains comments or summary lines, the offline archive utility reports an error.

• If mappings are incorrect, edit ptidconv.out, recreate the binary file, and reprocess the archives.