Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

rngdbdump

 11 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Brett
Basic Member
Posts: 19
Basic Member
1/13/2015 3:41 PM

    I am trying to dump data, in a .csv file for a single customer out of ARCUSTOMER and ARCOMMENTS. What is the correct syntax if the dataid is prod9 and the key fields are company=1 and customer=4059?

    So far I can get it on screen but I need it in a .csv file. I have rngdbdump -c arcustomer -v company=1 customer=4059. Where do I put the name of the file I want to dump to?

    Thanks in advance for any help.

     

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    1/13/2015 3:48 PM
      You'd need to redirect it. Unix: rngdbdump -c arcustomer -v company=1 customer=4059 > filename.csv (perhaps Windows too?)
      Or if you are in LID, you could rngdbdump -c arcustomer -v company=1 customer=4059 | lashow and do a send to - file.
      Brett
      Basic Member
      Posts: 19
      Basic Member
      1/13/2015 3:57 PM
        Thanks Greg. Works great when the syntax is correct. I just couldn't remember how to put in the filename for the .csv to dump to it. I am using LID by the way.
        dcarter
        Posts: 3
        6/17/2015 2:01 PM

          rngdbdump –c dev cbformats >cbformats.csv
          returns ‘Extra Parameter Not Understood’
          TJ Mann
          Veteran Member
          Posts: 44
          Veteran Member
          6/17/2015 2:16 PM
            do:
            count dev cbformats

            just to make sure your table is there.
            BrianM
            Advanced Member
            Posts: 41
            Advanced Member
            6/17/2015 2:17 PM

              Interesting...  We don't have that table so I tried the exact syntax your using on cucodes and it worked fine.  Not that it helps you much but at least you know the syntax should be correct.

              BTM
              dcarter
              Posts: 3
              6/17/2015 2:25 PM
                Yep, count shows 7 records.
                BrianM
                Advanced Member
                Posts: 41
                Advanced Member
                6/17/2015 2:41 PM

                  Did you copy and paste the command from anywhere?  I've read that the "-c", if using a copy and paste will produce that error.

                  BTM
                  dcarter
                  Posts: 3
                  6/17/2015 2:45 PM
                    Thanks Brian, that was the problem.
                    BrianM
                    Advanced Member
                    Posts: 41
                    Advanced Member
                    6/17/2015 2:47 PM

                      No problem.... Glad to help!

                      BTM
                      Cherie O
                      Basic Member
                      Posts: 19
                      Basic Member
                      10/3/2016 2:33 PM

                        trying to run rngdbdump -c gltrans -v obj-id=163 > filename.csv

                        but getting "Extra Parameter Not Understood"

                        i am typing it, not pasting and also in Windows, not Unix

                        Greg Moeller
                        Veteran Member
                        Posts: 1498
                        Veteran Member
                        12/21/2016 10:03 PM
                          Cherie: You need the productline in there. rngdbdump -c prodline gltrans -v obj-id=163 > filename.csv