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:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
200
Members:
0
Total:
200
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
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.