The general idea is that you send yourself an e-mail that contains one .CSV file for each vehicle. You then open that e-mail on your device. Touch-and-hold the .CSV attachment to pop up an action sheet. Tap on 'Open in "Mileage Keeper"' to import.
Once a vehicle has been imported, it will be a brand new vehicle which has the .CSV filename as its description. If this should replace an existing vehicle, just delete the original. You can also edit the description to suit your preference.
I'm generating a .CSV file myself, what is the exact format I should use?
There is not a perfect standard for .CSV files, but Mileage Keeper is somewhat flexible in what it will import.
The .CSV file is essentially a table of data with rows and columns.
Each row contains the data for a single refueling.
There may be a header row that describes the columns, but it will be completely ignored by Mileage Keeper.
The first 7 columns must be exactly what Mileage Keeper expects:
Date: It should be formatted according to typical rules in your region. It will accept dates in several styles. If the date includes one or more commas (,) then the whole date need to be enclosed in double-quotes. Here are some examples from the U.S. region, similar styles would apply to other regions of the world:
11/23/07
"Nov 23, 2011"
"November 23, 2011"
"Wednesday, November 23, 2011"
Odometer: A number formatted according to your device's regional settings for numbers. If you include a thousands separator or a decimal separator that is a comma character, then the number must be enclosed in double-quotes. Examples:
123456
"123,456"
"123,456.7"
Fuel Amount: A number formatted according to your device's regional settings for numbers. If you include a thousands separator or a decimal separator that is a comma character, then the number must be enclosed in double-quotes. Examples:
5.678
"1,234.45"
Cost: A number formatted according to your device's regional settings for numbers. If you include a thousands separator or a decimal separator that is a comma character, then the number must be enclosed in double-quotes. If you include a currency symbol, it should be the symbol used according to your device's regional settings. Examples:
34.56
$23.45
"$1,234.45"
Note: An arbitrary string. It will be truncated to 25 characters. If this string includes the comma character, then the whole noted should be enclosed in double-quotes. If this string includes double-quotes, then these double quotes need to be 'doubled' (""), and the whole note needs to be enclosed in double-quotes. Examples:
Highway driving
"This was ""city"" driving.
"Lorem ipsum dolor sit amet, consectetur adipisicing elit"
IsPartial: Non-blank for partial refuelings, otherwise blank
X
Partial
IsSkipped: Non-blank for skipped refuelings, otherwise blank
X
Skipped
There may be extra columns after these 7, those will be ignored by Mileage Keeper.
Each field needs to be separated by a comma (,) character.
If a field is double-quoted, then there must not be any whitespace between the commas and the double-quote.
"November 25, 2011","123,987","5.678","$23.45","This, is a ""long"" note.",X,X
I exported a .CSV file from my spreadsheet program, but Mileage Keeper doesn't import it correctly, now what?
This typically happens in regions of the world that use a comma as a 'decimal' separator. Many times spreadsheet applications will substitute a semicolon (;) for the comma as the field separator. If you are using Microsoft Windows, click on "Start, Control Panel, Region and Language, Formats, Additional Settings...". Set the "List Separator" to a comma (,) and try again.
Another common cause is the local format of dates, numbers, and currency in the .CSV file. The format must match the locale of your device. For example, if your device's Settings.app - General, International, Region Format is set to United States, then dates should be in that style - MM/DD/YY.