CSV

CSV Import

A CSV file may be imported as a card stack. The format of the CSV file is shown below. Frist, place the .csv file into the SD Card directory

Android/data/net.ekimd.andcards

Then, inside AndCards, choose Import from the menu and select the appropriate file.

CSV Format

The format of the CSV file is as follows. First, a header row is present to indicate field names. Optionally, if the first column may be named "Category" to place the cards into separate categories. For example, the following table

Category	Country	Capital	Currency
Unfiled	Afghanistan	Kabul	Afghani
Unfiled	Albania	Tirana	Lek
Unfiled	Algeria	Algiers	Algerian Dinar

is expressed in CSV as

"Category","Country","Capital","Currency"
"Unfiled","Afghanistan","Kabul","Afghani"
"Unfiled","Albania","Tirana","Lek"
"Unfiled","Algeria","Algiers","Algerian Dinar"

Import from Twinkle (for Palm OS)

It is possible to import flashcard stacks used with Twinkle Flashcards and maintain the learning history. First download the .pdb database files from the device and then use the program TwinkEdit (available as part of the Twinkle project) to read in the .pdb database. From the Edit menu, select Show Info, then highlight all of the table and copy and paste into a spreadsheet program. Finally, export the file as a .csv and read it into AndCards. The above CSV example including learning information is shown below.

"Category","New","Create Date","Quiz Date","Interval","Previous","Country","Capital","Currency"
"Unfiled",FALSE,"Sun Dec 18 23:59:09 MST 2005","Sat Jan 15 23:59:09 MST 2011",125,125,"Afghanistan","Kabul","Afghani"
"Unfiled",TRUE,"Sun Dec 18 23:59:09 MST 2005","Sat Dec 17 23:59:09 MST 2005",3,0,"Albania","Tirana","Lek"
"Unfiled",FALSE,"Sun Dec 18 23:59:09 MST 2005","Mon Jan 31 23:59:09 MST 2011",146,127,"Algeria","Algiers","Algerian Dinar"