PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/10/2009 8:37 AM by  brihyn
User Analysis Values copying-moved from other thread
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brihyn
Private
Private
Veteran Member
(247 points)
Veteran Member
Posts:95


Send Message:

--
08/07/2009 3: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
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    08/07/2009 9:42 PM
    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.

    Thanks for using the LawsonGuru.com forums!
    John
    brihyn
    Private
    Private
    Veteran Member
    (247 points)
    Veteran Member
    Posts:95


    Send Message:

    --
    08/10/2009 8:37 AM
    Great, thanks for your reply.
    You are not authorized to post a reply.