search

azizkayumov / flashcard-maker-android

Flashcard Maker is an android app that allows you to create and import e-flashcards for convenient, paperless studying.
https://play.google.com/store/apps/details?id=com.piapps.flashcardpro
GNU General Public License v2.0
63 stars 22 forks source link

Export-import file format #9

Open greyboxgt opened 4 years ago

greyboxgt commented 4 years ago

Currently CSV files are used for export-import. But CSV does not work very well with Unicode/UTF-8. And commas are often used in the sentences as a comma, not as a delimiter. Is it possible to use a simple text format with a tab delimiter to do the job?

azizkayumov commented 4 years ago

You can open CSV files in PC using Excel(Windows) or Numbers (MacOS), that's why I chose the format. Can I ask to have a look at this guide if you're having format problems with Unicode: https://www.nextofwindows.com/how-to-display-csv-files-with-unicode-utf-8-encoding-in-excel

greyboxgt commented 4 years ago

Unfortunately, Unicode/UTF-8 import is a bit complicated and the tool does not come automatically with all versions of Microsoft Excel. It seems to be missing in Excel 2003. That is why I had to use native .xls files with Notepad++ text editor to process your .CSV files in a few steps. Is it possible for Flashcard-Maker to understand .xls files directly?

azizkayumov commented 4 years ago

It seems there are some libraries that I can use for this: https://github.com/andruhon/AndroidReadXLSX https://github.com/mitchtabian/ImportFromExcel/tree/master/ImportExcelData They were not updated in last 3-4 years. I think I need to invest some time on this, so I can't fix the issue in coming 3-4 weeks.

greyboxgt commented 4 years ago

Currently, with .csv file format we are very limited with text only, and even Unicode text is not that simple. If you could use a Microsoft Excel spreadsheet or maybe even better Microsoft Word, would it also be possible to draft, import, export and backup the cards with images? And also editing on a desktop computer is much easier. That would be a huge improvement!