Bulk Add any single word already in default db fails (empty row inserted)

When you try to add bulk words there is a bug when one of the words you’re adding is the same as that which exists in the standard (default?) database. I am experiencing this problem quite often. What ends up happening is that it actually has been inserting an empty row into the database when it encounters the duplicate. So, you might want to page through your database and look for those empty rows. The real problem is how to figure out which ones are missing? For me it is easy as I’m using “bulk add” for just a couple of records at a time. I figured out that if I make sure that the Target Language Word (Greek for me) and the English are a unique combination, then it works as expected.

Here is what my db looks like right now after two dupes:

Now I need to remove the empty rows, which means paging through the db to find them.

Let’s say the word I’m trying to insert is:

διάσημος [tab] famous

but that it is already in the default db exactly like this, but I still want it added to my db, then I’ll change my insertion and use the following (note that I’m inserting a number of column here):

διάσημος [tab] famous, well known [tab] adjective [tab] [tab] Είναι ένα πολύ διάσημο διαμάντι.

so that the English has two meanings, which would be much less likely to already be in the standard db exactly like this. Then I have to edit the entry after it is in the db, which is a lot of extra work.

I have been working in an English course for months. Now that I have all the material, this is happening to me. I’m trying to bulk add words to my course and I’m experiencing the “white row” issue.

I have deleted the usual “English” database, and use a brand new one, without WIKI (because with Wiki happens the same).

I have tried, and now it seems to accept all my terms. But my question is:

Which are the consequences of using a custom database instead of the “English” one?

Will I be capable to edit this brand new created database and use in other courses I create?

Why is this happening now after creating several courses?

I would really appreciate any guidance regarding this matter. This behaviour is unaceptable in a tool with years of development.

Thanks for listening :pray:t2:

“Which are the consequences of using a custom database instead of the “English” one?” - really cannot say if there are any unintended consequences. One thing you’ll want to check carefully when you’ve had these issues is to go to the last pages of the database and look for entries that are blank or half-blank and remove them. I believe this happens because the word you tried to add already exists in the database. The trick I’ve always used is to tack on a trailing x (or some other character) so that the import tool thinks it is ‘unique’ then edit it after it is imported. Clunky, but it works.

“Will I be capable to edit this brand new created database and use in other courses I create?” I wish I knew the answer to this. I have always found it very difficult to get a straight answer to almost any question from a Memrise developer (which I am not!).

“Why is this happening now after creating several courses?” Wish I could tell you, but I don’t know. The platform is constantly being tweaked without any notifications or explanations.