Who's On?

	Membership:
	Latest: Isabella Harris
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 434
	Members: 0
	Total: 434

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

User Analysis Values copying-moved from other thread

2 Replies

0 Subscribed to this topic

11 Subscribed to this forum

Sort:

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

Posts: 3362

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.