When doing single cards I get both languages, but batch mode only gives the 1st language, with no translation.

Something strange is happening when I try to bulk add sentences for a list of words.
The words have sentences in my tsv file, but the program won't find them and parse them.
This isn't only with Chinese, it also happened with Russian.
It just won't find any sentences at all, and then it will suddenly find others. Don't understand the pattern.

EDIT: On further review, it looks the add-on freezes Anki whenever it doesn't find the word or expression in the database (but only for batch adding, manual adding gives an error instead: "Create database or change language options"). Batch adding for simple words that have sentences in my tatoeba database works. However, when looking up something without a sentence in the database it freezes and I have to force close Anki.

________ (original post)
I can add sentences by highlighting and clicking the addon button. But whenever I try to batch add Anki becomes non-responsive.

~~If I select just one or a few cards it just freezes until I have to force close Anki. If I select all my notes from the deck (~1500), it says "Processing" and there is a progress bar. At some point it disappears, but when I try to close the Sentence Adder window, Anki hangs and I have to force close. No sentences are added.~~

I am using:
Anki 2.1.65 (aa9a734f) Python 3.9.15 Qt 6.4.3 PyQt 6.4.0
Platform: Windows-10-10.0.22621
Flags: frz=True ao=True sv=3

This is the error that I get:

Error
An error occurred. Please start Anki while holding down the shift key, which will temporarily disable the add-ons you have installed.
If the issue only occurs when add-ons are enabled, please use the Tools>Add-ons menu item to disable some add-ons and restart Anki, repeat until you discover the add-on that is causing the problem.
When you've discovered the add-on that is causing the problem, please report the issue on the add-ons section of our support site.
Debug info:
Anki 2.1.52 (ab1c2395) Python 3.9.7 Qt 6.3.0 PyQt 6.3.0
Platform: Windows 10
Flags: frz=True ao=True sv=2
Add-ons, last update check: 2022-11-12 19:35:54

Caught exception:
Traceback (most recent call last):
File "C:\Users\tibor\AppData\Roaming\Anki2\addons21\1682655437_init_.py", line 120, in createDB
to_db = [row[2]]
IndexError: list index out of range

Is it possible to implement my own tsv file so it can fetch sentences from a file I provide myself?
If possible, could you explain how I would need to design the file?

Thank you for building this excellent addon! I am extremely grateful for your hard work and dedication! I would recommend updating the installation instructions to indicate that this addon only supports the Qt5 variant of Anki. Anybody running the Qt6 variant of Anki will receive a compatibility error when Anki attempts to load the addon during startup:

https://www.reddit.com/r/Anki/comments/lsb631/sentence_adder_anki_addon_add_sentences_matching/

Would it be possible to customize the minimum and maximum number of characters of example sentences?

In fact, it would be great if this was configurable for different sentences. So if I want to add 2 sentences, one might be between 30 and 50 characters and the other one between 50 and 80, for example.

Thanks for this great addon in any case! So useful!

Hi,

just installed the add-on, created the db and all cool. The problem begins after restarting Anki to get the changes done. It all looks normal in the add-on configuration window, but this appears when used:

So, went deep into the folder path until reached the Anki2 folder… For my surprise, these two "ang_db and config.json" files don't exist there but in the user_files folder. No clue what's going on.

Is it possible to make sentences in bulk? Only 1 per card, but not having to do each one manually?

I have come across an issue, where this happens: When I choose a sentence from a list of all available sentences in tsv file containing the word, the sentence is pasted into the field, but each character is in its own separate line.

Hi, krmanik! Thanks again for your work, this is really useful.

I am trying to add some sentences to my cards, but I want to use the ones that have audio. I have downloaded a list with sentences with audio I am interested in. This is a tsv file that includes Sentence ID [tab] Sentence [tab] Sentence translation (if available).

What I'd like to do is to add the audio or the audio link to the note. To do that I need to know the Sentence ID and then create a link to or download the mp3 from https://audio.tatoeba.org/sentences/[languagecode]/[SentenceID].mp3. For example for Chinese sentence 332421, the audio link would be https://audio.tatoeba.org/sentences/cmn/332421.mp3.

Adding the link to a given field or even just the Sentence ID would be immensely helpful. I could then look for the audio myself or create the link with Find and replace or whatever.

Unfortunately I am unable to create a PR since I can't code, so I hope you consider it. Thanks again in any case!

I can't get the add-on to work on my mac os 11.6.5. I had used this app before. I deleted and added the add-on and tsv database several times. Im not sure what is happening. Any ideas?

Other addons don't need it so I guess that it's not ok?

Anki 23.10.1 (fac9e0ee) Python 3.9.15 Qt 6.5.3 PyQt 6.5.3
Platform: macOS-13.5.2-arm64-arm-64bit
Flags: frz=True ao=True sv=3
Add-ons, last update check: 2023-12-23 21:25:04

When loading Sentence adder for any language with batch add option:
Traceback (most recent call last):
File "aqt.addons", line 245, in loadAddons
File "/Users/lenanetka/Library/Application Support/Anki2/addons21/1682655437/init.py", line 22, in
from PyQt5 import QtWidgets, QtCore
ModuleNotFoundError: No module named 'PyQt5'

Hey! Hope you're doing fine :)
Is it possible to make it so one can choose a minimum and maximum length for fetching sentences?
Say for example sentences between 1 and 5 in length, and not specifically 4,5 or 10 in length only.
Would be cool!

When modified config, it needs to restart Anki to apply the new config.

When unable to locate a word in the database while using Batch Adder mode, it gets stuck and unresponsive. If I wait, it does nothing, but in single mode, it shows "create database or change language options...".
I'm using Anki Version ⁨2.1.65 (aa9a734f)⁩
I downloaded the tsv (English sentences) from tatoeba. added language to db.

BTW thanks for the useful add-on.

Hi, I was the one that rate bad a few hours ago because of an error. Here is my preview message and below I add the files you requested me:

deutsch_sentences TSV file.zip
english_sentences TSV file.zip
frances_sentences TSV file.zip
japanesse_sentences TSV file.zip

Hi, I've tried many times to launch the addon but it keeps sending me an error when I try to load the language data with the tsv document. Could you please assist me with this one? I´m a little bit stuck right now. I will update de rating when everything runs ok! ok?

Error
An error occurred. Please start Anki while holding down the shift key, which will temporarily disable the add-ons you have installed.
If the issue only occurs when add-ons are enabled, please use the Tools > Add-ons menu item to disable some add-ons and restart Anki, repeating until you discover the add-on that is causing the problem.
When you've discovered the add-on that is causing the problem, please report the issue on the add-on support site.
Debug info:
Anki 2.1.42 (8eebfe18) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Windows 10
Flags: frz=True ao=True sv=2
Add-ons, last update check: 2021-03-30 00:34:31

Caught exception:
Traceback (most recent call last):
File "C:\Users\Valde\AppData\Roaming\Anki2\addons21\1682655437_init_.py", line 95, in createDB
for row in reader:
File "C:\python\lib\codecs.py", line 322, in decode
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xbc in position 10: invalid start byte

### Update: Here I attach images of what appears today 30/03/2021

If I try once again it sends me this:

But actually, there's no language loaded:

And, to be clear, it happens with all of the tsv files, with all the 4 languages that I tried to upload

Something to consider is that in the files directory of the addon it does appear the language:

Error
An error occurred. Please start Anki while holding down the shift key, which will temporarily disable the add-ons you have installed.
If the issue only occurs when add-ons are enabled, please use the Tools > Add-ons menu item to disable some add-ons and restart Anki, repeating until you discover the add-on that is causing the problem.
When you've discovered the add-on that is causing the problem, please report the issue on the add-on support site.
Debug info:
Anki 2.1.42 (8eebfe18) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Mac 10.16
Flags: frz=True ao=True sv=2
Add-ons, last update check: 2021-03-21 11:48:36
Add-ons possibly involved: ⁨Sentence adder for any language⁩


Caught exception:
Traceback (most recent call last):
File "/Users/user/Library/Application Support/Anki2/addons21/1682655437/init.py", line 87, in createDB
curs.execute(
sqlite3.OperationalError: table examples already exists

When learning monolingually or wanting shorter sentences this would be excellent.
Could be a tickbox so one could choose to have only long or short sentences!

on 3/25/2021
Wow, amazing!!
<3 I has tried to use your add-on which is a significant idea.
@@@@@@ A number of functions may be useful and attracting to users:

• allow users create their own databases with simple file types, such as TXT, excel, tsv,.. => It's is better to have more tools assist creating database easily; small, simple but powerful.
• A simple tool (may be integral) for splitting text into sentences to create databases automatically
• use separate databases for each fields
• bulking creating function: should have a warning window which inform us when it finishes tasks
• highlight words which is substituted, for instance:
  love -> I <u>love</u> you in result.
  I love you.
  => options
• can choose source field and destination field in editor or browser
• base on keyword/a specific field => can select a export field in editor (1)
• base on keyword/a specific field => can select export fields from different databases in editor (2)
• add shortcut to perform typical tasks+
• compatible with Edit Field During Review (Cloze) https://ankiweb.net/shared/info/385888438 + shortcut
• some functions are similar to https://github.com/sth2018/FastWordQuery <3
• reduce (options) spaces of extracted sentences
• can select the number of exporting sentence: 1/2/3/..
  +...

Many thanks!

--- solved

• bulking creating function doesn't work on the newest Anki. => it works properly (25-03-2021)

--- 2021-03-25 <3 Congratulations!

Nice addon! It would be really nice if you have an option do batch download audio as well. Every sentence on tatoeba has an ID and the audio ID is the same of the sentence. On the download page of tatoeba you can donwload a tsv file that shows only sentences with audio. You can cross references there!

Would it be possible to implement the option adding custom HTML to wrap around the target word (say, if I wanted bold; target word; now there are some tatoeba sentences which already include this so it would probably require to strip formatting from tsv file and then wrap custom formatting around a target word...) and not just the color when in the config? If it has already been added and I did not notice, my bad. Also, I noticed, that even if adding just one sentence, it adds a line break, which has a tendency to multiply and annoy :D ...

I am no programmer and I have not the slightest idea how much work it includes but I was just wondering, I tend to just emphasize the target words with bold.

Anyway, thanks for your work!

Would be nice if the generated sentences get put into a new field, not the one of the query, giving us more flexibility with its content.

If a word is contained within another word, for example
et is contained within toilette
Then the sentence generator considers toilette as a valid sentence for et, which it isn't obviously and et is a different word in french.

Hello, I've been using this add-on for a while and I love it. You've saved me hours of work. Thank you.

After the last update, I am able to add sentences to a single card but I'm getting an error when I'm trying to batch add them to multiple cards. I've tried reinstalling but nothing changed.

Debug info:
Anki 2.1.44 (b2b3275f) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Windows 10
Flags: frz=True ao=True sv=2
Add-ons, last update check: 2022-06-20 22:58:12

Caught exception:
Traceback (most recent call last):
  File "C:\Users\.....\AppData\Roaming\Anki2\addons21\1682655437\batch_edit.py", line 111, in <lambda>
    action.triggered.connect(lambda x, b=browser: onSentenceBatchEdit(b))
  File "C:\Users\......\AppData\Roaming\Anki2\addons21\1682655437\batch_edit.py", line 103, in onSentenceBatchEdit
    dlg = SentenceBatchEdit(browser, nids)
  File "C:\Users\.....\AppData\Roaming\Anki2\addons21\1682655437\batch_edit.py", line 39, in __init__
    note_type = self.mw.col.get_note(nid).note_type()
AttributeError: 'Collection' object has no attribute 'get_note'

Btw I'm really glad that you've added a limiter to sentences lengths, if I could give one suggestion it would be the ability to blacklist words. Tatoeba's English depository have a lot of sentences with Albania for some reason.

I downloaded sentence pairs for two langauges and imported into my Anki deck. I freeze all the cards and then browse for sentences when I need them. Unfortunately this has maxed out my sync account. Do you have any idea when the Sentence pairs will be available through your add-on?