CSPro Users Forum

Hello Everyone,

is there a way to export data with uuid? instead of case_id it will be uuid or caseid+uuid.

Thanks.

You can do this in a batch export application but not using the Export Data tool. If you haven't used a batch export before, what you can do is:

1) Open your export specification in Export Data.
2) Select View -> Batch Logic.
3) Click Create Batch Application.

Once you've done this, you'll have a batch export application that exports the data you're interested in. For example, I did this with the Popstan Census dictionary and I get this:
The next step is that you have to add a dictionary item that will contain the UUID. I'll do this using a working storage dictionary:

1) Select File -> Add Files.
2) Click on "Working Storage Dictionary..."
3) Edit the dictionary, adding an item to WS_REC, CASE_UUID, alpha, length 36.

Then I modify the logic to set this value, and to export it:
Now when you run this application, you'll get the UUID in the export.

Its working, Thanks Greg!

Hi Greg,

I have a question. For example, I have a single .csdb file that contains data for multiple cities/municipalities, and I want to extract the text files separately by city/municipality.

Example:
Input: 01.csdb
Output:
01/01001/cspro_export_file_var_f.txt
01/01002/cspro_export_file_var_f.txt
01/01003/cspro_export_file_var_f.txt
01/01004/cspro_export_file_var_f.txt
01/01005/cspro_export_file_var_f.txt

Thanks

You can use setoutput function in a batch application to split the contents of the input data file into one file for each city code;
https://www.csprousers.org/help/CSPro/s ... ction.html

Tried the setoutput but when multiple records are set, the output is directed only in a single record, all other records are blanks. Thanks

Your logic is not quite right. To get the correct logic, use CSExport tool and set your options correctly. Then click on View->Batch Logic to get the correct logic and paste it into your batch application as Greg mentioned below. For comma delimited export, if you do not want it in a single record, choose "Multiple Files" option and "As separate records"