rngdbdump

 11 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
Brett
Basic Member
Posts: 19
Basic Member
New Poster
New Poster
Congrats on posting!

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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
New Poster
New Poster
Congrats on posting!
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

rngdbdump –c dev cbformats >cbformats.csv
returns ‘Extra Parameter Not Understood’
TJ Mann
Veteran Member
Posts: 44
Veteran Member
New Poster
New Poster
Congrats on posting!
do:
count dev cbformats

just to make sure your table is there.
BrianM
Advanced Member
Posts: 41
Advanced Member

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
Yep, count shows 7 records.
BrianM
Advanced Member
Posts: 41
Advanced Member

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
Thanks Brian, that was the problem.
BrianM
Advanced Member
Posts: 41
Advanced Member

No problem.... Glad to help!

BTM
Cherie O
Basic Member
Posts: 19
Basic Member
New Poster
New Poster
Congrats on posting!

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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Cherie: You need the productline in there. rngdbdump -c prodline gltrans -v obj-id=163 > filename.csv