PDA Scholar

Products

Overview

MiniFlash

PocketScholar

Converter

     Home     Products     Downloads     Links       
Converter

 

The Converter utility allows you to convert your card decks to and from different file formats.  Currently version 1.0.0.7 of the Converter utility only allows you to read/write Excel CSV and MiniFlash Palm database files.

 

The Converter utility requires that the Microsoft .Net Framework 2.0 be installed on your desktop PC first.  Supported Operating Systems for the .Net Framework are Windows 2000/98/ME/NT/XP.  I will be looking at porting this to Linux/Mac OS X via mono, but no promises.

 

 

 

CSV Files

 

CSV (Comma Separated Value) files are simply text files were each line is a row and values are separated by commas. Here is an example of the CSV format accepted by the Converter utility.  The columns are:

 

Prompt,  Answer, Skill Level, Custom 1, Custom 2, Category

 

If you are linking the cards to audio files (only on the Pocket PC) the format is

 

Prompt,  Answer, Skill Level, Custom 1, Custom 2, Category, Audio File Name

 

 

CSV Format

 

You can get the following format by entering your flash cards into Excel and saving it as a CSV file or by entering the CSV format directly into a text editor.

 

"Ai[guptoV, -ou, hJ",Egypt,5,25,99,Noun
"Babulwvn, -w:noV, hJ",Babylon,5,12,99,Noun
"Barabba:V, -a:, oJ",Barabbas,5,11,99,Noun
"Barnaba:V, -a:, oJ",Barnabas,5,28,99,Noun
"Bhqaniva, -aV, hJ",Bethany,5,12,99,Noun
"CristovV, -ou:, oJ","Christ, Messiah, Anointed One",5,529,4,Noun
"DamaskovV, -ou:, oJ",Damascus,5,15,99,Noun
"Dauivd, oJ",David,5,59,4,Noun
"Farisai:oV, -ou, oJ",Pharisee,5,98,21,Noun
"FivlippoV, -ou, oJ",Philip,5,36,99,Noun
"Galilai:oV, -a, -on",Galilean,5,11,99,Adjective
"Galilaiva, -aV, hJ",Galilee,5,61,4,Noun
"JAnanivaV, -ou, oJ",Ananias,5,11,99,Noun
"JHrwv/dhV, -ou, oJ",Herod,5,43,99,Noun
JIerosovluma,Jerusalem,5,62,27,Noun
 

 

Categories

 

Palm:

When creating databases for the Palm there can only be 14 unique categories apart from the "Unfiled" category. If your CSV file contains more than 14 unique categories only the first 14 will be  including and all other unique categories will be set to "Unfiled". Each category can only be 15 characters long.  These restrictions are related to the Palm OS and are not a restriction of MiniFlash.

 

Pocket PC:

Pocket PC databases can have unlimited numbers of unique categories. The categories can be 50 characters in length.

 

 

Using Excel

 

Excel is good for creating card decks because you can set the font in the prompt field and see it as it will appear on your PDA device.

 

After you have created your word list in excel, export it to CSV when you are done. The CSV file is what you will run through the converter.

 

Each row in Excel is a card.

 

Each row should have the following cells

  • Column A is the prompt

  • Column B is the definition

  • Column C is the skill (1-5)

  • Column D is Custom 1 (Frequency usually)

  • Column E is Custom 2 (Chapter usually)

  • Column F is the category

  • Column G is the audio file name (optional and only on the Pocket PC)

 

 

Below is an example of what your spreadsheet should look like.

 

 

 

Card Deck Installation

 

Palm:

  1. Create the palm pdb database file using the converter

  2. Install the pdb database on your Palm OS device using the Palm sync software

 

Pocket PC:

  1. Create a CSV file with or without the audio column

  2. Copy the CSV file to your Pocket PC device

  3. Import the CSV file into PocketScholar using the Import function

  4. Specify if the CSV file you are importing includes an audio column

 

[download] - Latest version 1.0.0.9

[download] - Previous version 1.0.0.7