Re: [Dhis2-devs] Generating 2.5 mill UIDs and saving them to a file

Morten, Firstly, thanks for confirming there's a hard-coded limit - I suspected it, but found no reference to any limits in the developer manual. Secondly, I did generate them easily enough using Bob's uid function and a small temp table to store the uids: DO $do$ BEGIN FOR i IN 1..2411000 LOOP

Re: [Dhis2-devs] Generating 2.5 mill UIDs and saving them to a file

Hi Calle Just use something like this (you need to have the uid() function installed first) copy (select uid() as uid from generate_series(1,10)) to '/tmp/test.csv'; and replace 10 with whatever number you want -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo

Re: [Dhis2-devs] Generating 2.5 mill UIDs and saving them to a file

Knut Aware of that, but it generates only one UID. I can use it in a small program, of course, but that's not the point here: I would like to know if there is a way to get the web API to create 2.5 mill UIDs into a csv file. Regards Calle On 25 June 2017 at 23:45, Knut Staring

[Dhis2-devs] Generating 2.5 mill UIDs and saving them to a file

Hi I need around 2.5 mill UIDs for use as event UIDs, but the following only returns 10,000 (this might be a browser setting - not sure): http://localhost:8080/dhis//api/26/system/id.csv?limit=250=false Any other way to generate those 2.5 mill UIDs and dump them directly out into a csv