×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Move data across tool sets

Move data across tool sets

Move data across tool sets

(OP)
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

RE: Move data across tool sets

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.

RE: Move data across tool sets

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close