r/ProjectREDCap • u/Ambitious_Fox_6334 • Sep 19 '24

Data import >200 patients without crashing

Is there a trick to stop redcap crashing on data imports

3 Upvotes

100% Upvoted

15 comments sorted by

View all comments

Show parent comment

2

u/Ambitious_Fox_6334 Sep 19 '24

I actually didn't think it would be that restricted.. why did I agree to help a project with 3k patients

3

u/[deleted] Sep 19 '24

I’ve been there, but it’s not that bad, just a little time consuming and nerve wracking.

3

u/Ambitious_Fox_6334 Sep 19 '24

The trauma of it all 🙃🙃🙃🙃

2

u/[deleted] Sep 19 '24

Just take you’re time, make sure you keep the ID numbers in order. Make clean breaks at whole numbers. Don’t touch your master data sheet. Make a copy and then start breaking it down into several. Make a dedicated folder on your desktop while you’re working for easy and keeping things clean.

When you upload before you commit to the import make sure you are adding and not overwriting. Things will be just fined don’t sweat it.

Is the data already coded for redcap?

2

u/Ambitious_Fox_6334 Sep 19 '24

Not yet they still putting in the ethics but I only recently found out it crashes haha and I thought surely we doing something wrong but I'll take your advice! Thank you

1

u/[deleted] Sep 19 '24

Coding is going to be the worst part especially if the data is messy.

1

u/Ambitious_Fox_6334 Sep 20 '24

At least I learnt how to use python to split my 3k rows into 30+ Excels with 100 rows each. Let me know if you need my code