change of field numbers for MS Addins and .uwf files

 6 Replies
 2 Subscribed to this topic
 226 Subscribed to this forum
Sort:
Author
Messages
Phil Simon
Veteran Member
Posts: 135
Veteran Member

    Hello

    I'll probably have to open a case with Lawson but I'm hoping that there's a solution to this. On 8.0.3, we have quite a few upload files (UWFs) that are obviously linked to field numbers. These field numbers, however, have changed aross the board on 9 and Excel isn't liking the 'old' file definitions in the new TEST 9 product line.  Aside from rewriting all of these from scratch, is there anything that can be done to get 9 to recognize 8.0.3 UWFs?

    Thanks.

    ps

    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    Phil Simon
    Veteran Member
    Posts: 135
    Veteran Member
      Lawson says that you can't but our community is smart.
      Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
      kadkins
      Advanced Member
      Posts: 23
      Advanced Member

        Phil,

         

        Have you opened the .UWF file and modified the product line?  You can open these in Notepad and change the string info there.  Try that and see if it works.

        Thanks,

        Kyle

        Phil Simon
        Veteran Member
        Posts: 135
        Veteran Member
          Thanks, Kyle. If the field #s had remained constant, then that might work. Since they haven't (and they're not in a usable/flat format), it probably makes sense to just recreate them. How Lawson changes field numbers is beyond me. While not as inimical as changing field and table names, I'm still baffled about why they'd do this.
          Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
          John Henley
          Posts: 3353
            You can do manually/carefully by editing the .uwf. I have found it easier to just re-create them.
            Thanks for using the LawsonGuru.com forums!
            John
            John Henley
            Posts: 3353
              What they really should do is store the COBOLish name instead of the f number.
              Thanks for using the LawsonGuru.com forums!
              John
              Phil Simon
              Veteran Member
              Posts: 135
              Veteran Member

                No argument here.

                Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com