Abnormal behaviour during importing assignment

After trying importing assignment a couple of times without any success (the verification did not even shows), this weird screen pops uppng .

1048432 assignment ! in the tab file we had only 15 assignment.
Is there a way to cancel this?

This is strange.

Please contact the support with the indication what server it is and please share the file that you were trying to upload (or any other with which the problem may be reproduced).

What is the outcome? How many assignments are actually created?

The user has shared the file used for preloading.
The file contains 1 048 433 lines with 16 columns (tab characters) in each.
Of the above mentioned lines, only 15 are having any values.
The rest are still considered assignments, albeit with no preloaded identifying information.

Recommendation: remove the empty lines.

PS: 1 line is for the column titles, hence Survey Solutions reports 1 048 432 assignments being created.

The assignment is finished by now, and it seems all of the 1048432 assignments have been created!
How do we solve this problem effectively?
Archiving via API?
Please advice! The supervisor has been locked to avoid additional problems on the tablets.

Please see my post above.

If no other assignments exist in this survey, better delete the whole survey and restart from the beginning.

Actually the survey is on progress! we can not delete the survey.
How about creating a new account for the supervisor and moving the whole team ?

Is the server going to work without additional problems? with creating new assignments , exporting data …etc. ?

If you’ve originally requested a server for 1mln interviews to be handled, then I expect no performance issues, but I don’t see the point of retaining 1mln of assignments that you don’t need anyways

If you want to archive via the API and are an R user, @l2nguyen wrote a nice R function that is a wrapper for the endpoint that archives assignments. One simply needs to pass the function the ID(s) of an assignment(s) to archive. See the family of functions here, and the archive function here.

1 Like

If such a screen does not already exist, would it be worth adding a screen that informs the user of the number of cases SuSo detects in the preloading file(s), that confirms the user indeed wants to perform the operation, and that provides some solutions to this type of problem/that points to resources for solving common problems.

1 Like

Good suggestion. But, perhaps, the user should also ask himself, before uploading the file, why 15 cases make 17 million bytes of data?

Clearly the error in this case is stemming from the use of Excel. Hence, another advice for every reader of this message is: please, stop using Excel for the data work. Excel is a spreadsheet, not a database or a statistical package, which are more appropriate for this work.