join CSPRODB

Discussions about tools to complement CSPro data processing
Forum rules
New release: CSPro 8.0
Post Reply
leulae
Posts: 46
Joined: December 16th, 2016, 5:51 am

join CSPRODB

Post by leulae »

Hello all,

How do I join two CSPRODB file to One CSPRODB file. Then after I need to sort using CSSORT

Please help me on this regard

Thank in advance

Leulae
sah
Posts: 97
Joined: May 28th, 2015, 3:16 pm

Re: join CSPRODB

Post by sah »

Go to tools then concatenate the files if and only if they are of same dictionary.
leulae
Posts: 46
Joined: December 16th, 2016, 5:51 am

Re: join CSPRODB

Post by leulae »

Thank sah, appreciate,

I know how to make one data file using different dictionaries with text data, sort tool help to sort Record sort. Finally we can get one data file

I need to join two CSPRODB files which belong to two different dictionaries and make one data file.

I can write batch file to do this, but finding convenient and easy way to do this

Thanks again

Leulae
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: join CSPRODB

Post by Gregory Martin »

You can't directly do with the CSPro DB format. You will have to:

1) Convert the CSPro DB files to text files. You can use the Data Viewer to do this or do it with a batch application.

2) Do the manipulation with the text files (concat, record sort, etc.).

3) Convert from text back to CSPro DB (if needed).

The CSPro DB format is very convenient to use for data collection, but it has some limitations, which you've discovered with your task.
leulae
Posts: 46
Joined: December 16th, 2016, 5:51 am

Re: join CSPRODB

Post by leulae »

Thank you very much,

Leulae
Gregory Martin wrote:You can't directly do with the CSPro DB format. You will have to:

1) Convert the CSPro DB files to text files. You can use the Data Viewer to do this or do it with a batch application.

2) Do the manipulation with the text files (concat, record sort, etc.).

3) Convert from text back to CSPro DB (if needed).

The CSPro DB format is very convenient to use for data collection, but it has some limitations, which you've discovered with your task.
Post Reply