I cannot say I know what the underlying database is here, but what I can say is that this is not how databases work. Records are added initially sequentially, but as other records are deleted and new ones added the database will typically optimize where to insert them. In other words, it really shouldn’t matter where in the database the record actually is. And, more to your point, no you cannot go back and insert a record where you want it or think it should be.
I would recommend that you focus on the course levels themselves rather than worrying where the database is inserting the rows.
When bulk uploading it is always a good idea to ensure that your entries will be unique in some way. As @ChiewPang points out, Memrise will try to find existing entries in some other database and this often interferes with bulk add. I recently learned this the hard way! So, to overcome this I built a list of verbs in Greek, then the English translations next to them, but I made sure that the English had at least 2 entries (separated by a comma), ensuring the likelihood that the entry would then be unique. After uploading, I then edited the English in the Level and moved the 2nd Eng. definition into an Alt for that word. I know this would be painful for some, but it worked for me.
The 100th row problem has apparently been known for a long time. Really I cannot understand why they don’t address it.
Also, after I completed uploading everything I went through the database page-by-page looking for errors and empty rows, either fixing them or removing them. Not a fun task, but often necessary. And it will help you better understand the structure and content of your database.
Months have passed and it’s quite incredibly pathetic (to put it rather mildly) that Memrise has refused to address this problem, correction, PROBLEM.
The only databases linked to my courses are MY OWN databases. For the simple reason that I put high-quality audio and I have additional columns. Simple as that. And yet, when I bulk add, Memrise so STUPIDLY extracts some words from some ****-uped database of theirs and inserted those instead of what I provide. And, worse, blanks out these words.
Rather hard to fathom that such a bug has been allowed to exist for months and a so-called professional organisation can’t or won’t do anything about it.
Thank you. Rant over. Now back to RE-INSERTING all these words INDIVIDUALLY and MANUALLY. Yea, like I have all the time in the world and the developers don’t. I should really follow @neal.p.carey’s workaround but I refuse to mess up my spreadsheet, which is being worked on by others too.
Surely fixing this bug would also benefit Memrise when they make their own courses?
I have a workaround if anyone still dreams of the magical bulk add.
Have the word list open in excel, google docs, etc…
Go to the 100th row item and click “insert 1 (new) row above”
That will push your 100th word down into the 101th spot
Now enter “none1” into all of the columns in your new 100th row
Repeat step 2 for the 200th row, 300th row, 400th etc…
But you will need to use none2, none3, none4, because the missing rows actually end up in the database somewhere and just using “none” for every single added row won’t work.