Move data across tool sets

[mrfritz44]

We are upgrading from PeopleTools 8.17 to 8.46 and I need to get certain data out of a 8.17 table and into the 8.46 table. I've created a simple data mover script to export the 8.17 data without problems. When I execute the import version of the script in 8.46 I crash the data mover application.

Here is the script:

SET OUTPUT C:\TEMP\HELLO.DAT;
SET LOG C:\TEMP\HELLO.LOG;
EXPORT PSAUTHITEM WHERE CLASSID = 'PAY';


SET INPUT C:\TEMP\HELLO.DAT;
SET LOG C:\TEMP\HELLO.LOG;
IMPORT PSAUTHITEM;

I believe the problem lies in trying to import a 8.17 .dat file into 8.46, but I'm not sure. If I am correct, what other options do I have to get this data into the 8.46 table?

Thanks!

Fritz

 

[jmanj]

You have to understand how your .dat file is formatted in data mover. This is a very complicated format and there is a reference material in PS in creating such data. To simplify your migration from one tools version to another, simply use IMPORT manager and make sure you map the fields properly.

 

[notadba]

One other thing you can try - though is not recommended or 'pretty'. When you create the .data file, it is stamped with a tools version number. If you know that the table structure is the same you can often get data mover to use the file by updating the tools version in the dat file.

The top line of the file will be something like "SET VERSION DAM 8.1" etc.

This has occasionally worked - but only on the simple imports. Otherwise you should follow jmanj's advice.

Good luck