Problem using bulk load

Hi, I am using bulk load to import data from an excel file. I create the diferent patients with its uniques TEIs and Events ID as the picture:


image
The thing is I create my own TEI, but dhis2 seems to like it, because dhis create all the patients i made up. The problem is that, when I am importing using bulk load, the program import just the first patient event I created before and ignored the others (an enrollment event). When I do that a second time, the program import the second one and then ignored the others, and the problem persist until I finished importing. What do you think is the problem? Why cant I import all in 1 time? Is there any best option to import it? Thanks!

Hi @aitor_garrido

Thank you for your question! What version of dhis2 are you using and what’s the app version?

The Bulk Load app is developed by EyeSeaTea SL so hopefully someone from their team will support you. Additionally, you may want to check out this resource: Home · EyeSeeTea/Bulk-Load-blessed Wiki · GitHub

@SferaDev @ifoche would you please have a look? Thanks!

My dhis2 version is 2.38.1.1 and the bulk load version is 3.19.1. If they response that will be great. I just need to know what do I have to keep in mind when I want to upload new several patients to the dhis2 database while using excel template. Those patients are created by myself with custom TEI and Event ID (I made up those). So I dont know if there any instructions to follow while creating the patients in the excel file. Thanks!

Hi @aitor_garrido
Thanks for your feedback! It seems what you are doing is correct. Do you have an instance we can use to reproduce the error or can you set up a scenario on https://play.dhis2.org/ we can use to debug the issue? It would also help if you can open the browser console and send to us the response of the trackedEntityInstance and event import calls. Feel free to reach me by private message or email if you want to share any private information or discuss any point

1 Like

Hi Adrian, thank you for your response. I was checking the json document that bulk load generates and I went to that elements that bulk load ignored. The error that the system was giving to me was “Program stage can´t be repeateble” and it was reference to the Event ID. And yes, the program stage is a Enrollment stage that is suposed to be non repetable. But to do some test, I changed it to repetable and then the error is gone, I can import all elements at once…but the thing is that the event must be non repetable. I can´t sent or made up a scneario cause it is a private instance from my company. But if you have time it will be nice to talk and try to get a better solution. Thanks!

Hi @aitor_garrido
This error is an old friend of us :slight_smile: This is actually a bug in DHIS2 that we reported for 2.37 and 2.38 three months ago: [DHIS2-13518] - Jira I am almost sure this is the exact error you are experiencing. If you can confirm this is the case and maybe drop a comment in the issue or vote for it we can get it fixed in the next build. More than happy to have a talk if you think there is something else to discuss. Thank you!

1 Like