Selecting a condition file for each participant and make sure it's not assigned twice across participants

Can I recommend you look at this thread

I specifically wrote the VESPR Study Portal to deal with non-finishers (for licensed users).