First off, this isn't the 'new' website I've been talking about,
though this did come as a result of that.
There's been a lot of problems with importing csv files with the old
website. This was largely caused by two issues. The first was that
in order for accented characters to show up right in a csv file, the
csv file needed to be encoded in UTF-8, and Excel, as well as a few
other spreadsheet programs had a lot of problems exporting to UTF-8.
The other was that many spreadsheet programs didn't follow CSV
standards exactly, and as a result there were a lot of "File Format
Invalid" problems.
To fix this I did two things. First, I updated the CSV importer to be
a little more forgiving with format, which should cause less "File
Format Invalid" problems. The other thing I did was add native
support for Excel (.xls and .xlsx) and OpenOffice (.ods) documents.
So now you can import your excel documents directly into the website
and so long as the front text is in column A and the back text is in
column B it should import correctly, with all accents, ect.
These are released and out at the current website
(
flashcards.red5dev.com) and you can start using them immediately. So
if you have problems with any CSV files, try saving your documents to
an Excel format (.xls or .xlsx) instead and seeing how that transfers
over.
The major website update is still coming later this month, and I
should have a beta up for people to start playing with soon.
Thanks!
Jason