Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Interfaces/Conversion
User Analysis Values copying-moved from other thread
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Joyce
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5158
People Online:
Visitors:
177
Members:
0
Total:
177
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Interfaces/Conversion
User Analysis Values copying-moved from other thread
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
brihyn
Veteran Member
Posts: 95
8/7/2009 7:49 PM
Wanted to bump the topic in the other forum to see if there's any answers and noticed this forum listing...figured while bumping it, i'd move to a more appropriate area. So...anyone have any hints or tricks for this original request?
Thanks!
Brian Hynes
We're still in the implementation phase of Lawson. The users have been working in a training pdl, and as of next week, will be moving to a conversion pdl.
I'm being asked if we can somehow get the User Analysis values copied over to this new pdl, however the users don't want all of the data copied over from training.
LIS states that they don't support copying this data unless i'm copying the entire database, but then through out the hook "however, if you know of some way that has worked for you in the past, you can use that" which makes me think that there's an answer they're just not allowed to provide.
Any thoughts/insight for getting just this data copied over?
John Henley
Senior Member
Posts: 3348
8/8/2009 1:42 AM
Brian, the tables you want are in the SL system code, and you probably want to copy
SLSEGMENT
SLSEGVALUE
SLGROUPHDR
SLGROUPDTL
SLRELATHDR
SLRELATDTL
The other option is to copy the SL system code and then use truncfile to remove the data from the SLTRANS and SLTRANSEG tables.
There are a copy of ways to copy the data.
If your product lines are in the same environment, you can use dbcopy to copy them, either table by table, or for the entire system code. If they are on different servers, you can use either expsysdb to export and impexp to import the SL system code, or dbdump and dbload to export and import the individual tables.
Understand that there is a reason why Lawson does not support this, and realize that you may be corrupting your data integrity. For instance you might be copying a relation from SLRELATHDR-SLRELATDTL that does not match an account in your chart.
brihyn
Veteran Member
Posts: 95
8/10/2009 12:37 PM
Great, thanks for your reply.
You are not authorized to post a reply.