CSV
jMemorize allows you to import and export CSV (character separated values) files. Go to the 'files'-menu, click on import or export and select CSV or TSV.
The CSV file has to have a header which specifies the columns. The valid columns are:
- Frontside (mandatory)
- Flipside (mandatory)
- Category (optional)
- Level (optional)
Without this header, jMemorize won't know the meaning of the values in your file and won't be able to import the file. As jMemorizer is sensitive to the case of the header, please make sure to stick to the case as shown above.
How to Create a CSV File
Open notepad or the text editor of your choice, and add an appropriate header on the first line. The header must start with "Frontside, Flipside" and may also include "Category" and "Level". Then add the data for each flashcard, one per line, following the same pattern as indicated in the header. You can then save your file using the ".csv" extension. Be careful to choose the correct encoding.
Make sure that you are not using any extra commas in any of your entries.
If you are importing Japanese/Chinese characters, UTF-16 will generally yield better results than UTF-8. The characters must also be surrounded by quotes.
A Windows Excel user from the latinstudy group who imported Latin letters with macrons reports: "If the worksheet entries have no macrons, it's a straight csv import, using the windows-1250 on the Character set menu of jMemorize. With macrons, save the worksheet in Excel as a Unicode text file with a .tsv extension. Import into jMemorize as a tsv file, using UTF-16 on the Character set menu."
You might consider using a spreadsheet application such as OpenOffice.org Calc or Excel to automatically convert large amounts of data to a format suitable for import.
Examples
The following text box shows the contents of a simple CSV file which contains states with their capitals and languages.
Frontside, Flipside, Category germany, berlin, capital germany, german, language france, paris, capital
The following file also specifies the deck at which every card should be positioned. Since the file gives no data on the category all cards will be added to the root category.
Frontside, Flipside, Level germany, berlin, 2 france, paris, 0 spain, madrid, 5 england, london,
The following file will generate an exception because the initials of the header are written in small letters.
frontside, flipside, category germany, berlin, capital germany, german, language france, paris, capital
An example using chinese characters:
Frontside, Flipside, Category "ä¸", 1 , basic "äº", 2 , basic "ä¸", 3 , basic
