Repository navigation
ImportExport
The program allows to export data from the dictionary into CSV or HTML file, and import data into the dictionary from CSV file with the certain structure.
CSV format can be used to make exchange with other programs or data sources. For example user can fill out an Excel file line by line, then save it as CSV and insert all this data into the dictionary (instead of adding it word by word).
All import/export commands are located in the "File" menu.
Firstly, only words that shown in the main window will be exported. Thus user can control what exactly will be exported.
After executing menu command "Export shown words into CSV/Html..." user must select a file which will contain data.
In the first row of a CSV file will be shown its structure (columns): Id, Sound, Word, Transcription, Translations, Context, Relations, Added, Updated, Watched, WatchedCount, Group.
The other rows will contain clauses' data, a clause per row. Values in the rows are separated by commas, if a clause doesn't have a value in a certain column then commas will go one by one (e.g. fourth clause in the example below has no sound link - the second column).
An example of CSV file:
Id,Sound,Word,Transcription,Translations,Context,Relations,Added,Updated,Watched,WatchedCount,Group
1,https://translate.google.com/translate_tts?ie=UTF-8&q=abrigo&tl=es&total=1&idx=0&textlen=6&tk=501319.72647&client=webapp,abrigo,,shelter (n); refuge (n),me refugiaba en el abrigo de tu mirada,refugio -- synonym,05/19/2020 11:37:15,05/19/2020 11:37:15,06/04/2020 21:10:52,3,B
2,https://translate.google.com/translate_tts?ie=UTF-8&q=refugio&tl=es&total=1&idx=0&textlen=7&tk=230004.344052&client=webapp&prev=input,refugio,,refuge (n); shelter (n),este sitio siempre será tu refugio,abrigo -- synonym,05/19/2020 11:40:21,05/19/2020 11:40:21,06/09/2020 20:12:59,4,A
3,https://translate.google.com/translate_tts?ie=UTF-8&q=Topo&tl=es&total=1&idx=0&textlen=4&tk=830205.661373&client=webapp&prev=input,topo,,mole (n),"los topos son muy voraces, y se alimentan sobre todo de lombrices de tierra y larvas de insectos",,05/23/2020 11:44:14,05/23/2020 11:44:14,05/23/2020 11:44:14,1,C
4,,un par de veces,,a couple of times,,,05/23/2020 11:45:43,05/23/2020 11:45:43,05/23/2020 11:45:43,0,C
Html files contain the same information but they are intended to be used not for export data but for get data in another form (e.g. to save data on the phone).
An example of Html file:
Program can import data into the dictionary from the CSV files which have same structure as described in the export data.
After executing menu command "Import words from CSV..." user must select a file which contains the data and this data will be added to the dictionary.
If any errors occur then they will be shown in the "Report" window and no changes will be made with the dictionary (all or nothing).