Prev
Next
Forums Integration / Customization S3 Interfaces/Conversion

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
Veteran Member
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: 3353
    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.

      Thanks for using the LawsonGuru.com forums!
      John
      brihyn
      Veteran Member
      Posts: 95
      Veteran Member
      8/10/2009 12:37 PM
        Great, thanks for your reply.