Hi, I’m trying to add words to create a 5000-word list. When I use “Bulk add words”, the software only allows me to add 1000 words at a time. But when I finished my five 1000-word additions, it said I only had 4950 words. And when I checked the uploaded list against the original list, it showed that every 100th word is missing: #100 is missing, #200 is missing, etc.
Can anyone explain what’s happening? Thanks!
The problem here may be that 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 just edit the entry after it is in the db.
Unfortunately, I don’t think we have the same problem as each other. I don’t see any empty rows in my db. I know that the words are missing because although row 99 does contain word 99, row 100 contains word 101, and so on.
@supplementfacts ~ this is a known issue on this forum, that was discussed a while ago. I can’t find the link just yet, but it is in here somewhere. The issue is indeed that when bulk adding more than 100 words (say 600 words for example) every 100th word will not upload. The current workaround is to do at least 2 uploads. One for all your words. The second for the missing words (the ones that were the 100th, 200th, etc. on your list). Hopefully in your case of 5,000 you had a list and can identify which ones were in the 100 series. If you can, just upload the missing 50 words (i.e. numbers 100, 200, 300, etc). Once they are in Memrise you can move them to wherever they need to be, if they are out of some kind of logical order. Again, the discussion about this issue is in this forum somewhere (I was even a part of it). I just can’t find the link. Maybe someone can. Bottom-line, it is not something you did wrong with the process, it was the process itself. Hopefully Memrise will address this issue since it effects anyone who uploads more than 99 words at a time.
Ah, ok. I’ll report this as a separate issue - it really is a problem.
@Arete_Hime ~ thanks, that was the thread ! I still struggle with the search function on this new forum. Perhaps I will learn with time. Thanks again.
Because of this error, I need to start over with my list. But I don’t see any way to delete all the words at once so I can start over. Is there any way to do that? Thanks.
@supplementfacts ~ why don’t you just delete the database your course is currently created on, and then create a new database once you are ready to go again. That’s what I do whenever I encounter issues.
@supplementfacts ~ click on the “Edit Course” button and then select the “Database” option with the down arrow. You should see your database in the list. If you don’t know the name of it. Look on each of the levels of your course - it will be the name that is in parenthesis. From the database list, select the name that you are using and at the bottom of the first page of words you will see an option in red that says “Delete Database”. Click on that and you will delete it. Once deleted, you can’t retrieve it (which is a good thing if you delete it intentionally. Not good if you do it by accident).
@pdao I’m sorry, but I can’t find any “Edit Course” button. I’ve looked all over the site, but I don’t know where the button is.
It should be on the first page of your course (the one with the description, leaderboard, levels, etc. It is in the upper right corner, just above the leaderboard. See attached.
Once you are in, here are the 2 things you need to do. Look for your database, and then delete it. Here is what I see in my course, and what I would delete, if I wanted to (which I don’t want to, but you would want to).
@pdao I found the “Edit Course” button, but I’m not sure where to go from here. I don’t see any ‘Databases’ down arrow to click on: http://i.imgur.com/JlJc68c.png
You are probably only using one level. Click on the "Add Level’ button and create a second level it doesn’t mater what it is called. Even though there are no words in this new level, it will allow you to go back and see the dropdown for the Database. You can then proceed to delete it. Let us know how it goes…
@supplementfacts ~ sort of odd, yes, but not odd if you had more than one level in your database to begin with, which for many is usually the case.
Seems like you are good to go to start over again. Bear in mind the 99 word limit for uploads (before a skip). If you do more than that, then just keep track of the 100th of each series and download them separately, after the first upload. Good luck with your course !
A question to anyone who may have an answer,
I want to bulk upload thousands of items and for them to be in a particular order when I use the “create levels” feature from the database page. However, due to the 100th item always missing, how can I then add the item back in to the database list so it can be in the original order? I know how to do this when creating levels manually but not when doing it via database. If I go through and add them into the already created levels that also means I cannot use the auto-level creation function… which defeats the purpose of bulk adding more than 50 in the first place.
If this can’t be worked around, can we get a fix or something? ugh…
This is another of the glaring problems that Memrise has chosen to ignore.
First, apart from specifying my own database, Memrise always attempts to take from an existing database if the entry exists. This, in itself, is wrong, wrong, wrong. The minimum it should do - and I’d rather it didn’t at all - is to compare the number of columns! If they are different, the entries DO NOT match, for loudness sake.
So, what happens now? It’s got even worse. We bulk add, and we get LOTS OF BLANK ROWS.
Honestly, if it carries on being so bad, I fear that course creators will just abandon the ship eventually. What should take 1 minute now takes 100 times more.
