PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/21/2016 5:03 PM by  Greg Moeller
rngdbdump
 11 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Brett
Software Administrator
Brazos River Authority
Basic Member
(29 points)
Basic Member
Posts:15


Send Message:

--
01/13/2015 10:41 AM

    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    01/13/2015 10:48 AM
    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
    Software Administrator
    Brazos River Authority
    Basic Member
    (29 points)
    Basic Member
    Posts:15


    Send Message:

    --
    01/13/2015 10:57 AM
    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
    DB Application Developer
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    06/17/2015 10:01 AM

    rngdbdump –c dev cbformats >cbformats.csv
    returns ‘Extra Parameter Not Understood’
    TJ Mann
    Private
    Private
    Advanced Member
    (92 points)
    Advanced Member
    Posts:38


    Send Message:

    --
    06/17/2015 10:16 AM
    do:
    count dev cbformats

    just to make sure your table is there.
    Brian
    Lawson Developer
    IASIS Healthcare
    Advanced Member
    (85 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    06/17/2015 10:17 AM

    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
    DB Application Developer
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    06/17/2015 10:25 AM
    Yep, count shows 7 records.
    Brian
    Lawson Developer
    IASIS Healthcare
    Advanced Member
    (85 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    06/17/2015 10:41 AM

    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
    DB Application Developer
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    06/17/2015 10:45 AM
    Thanks Brian, that was the problem.
    Brian
    Lawson Developer
    IASIS Healthcare
    Advanced Member
    (85 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    06/17/2015 10:47 AM

    No problem.... Glad to help!

    BTM
    Cherie O
    System Analyst
    Private
    Basic Member
    (43 points)
    Basic Member
    Posts:19


    Send Message:

    --
    10/03/2016 10:33 AM

    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    12/21/2016 5:03 PM
    Cherie: You need the productline in there. rngdbdump -c prodline gltrans -v obj-id=163 > filename.csv
    You are not authorized to post a reply.