GreaseMunky™ User Guide

Setting up the Import

Now we have our CSV file installed on our iPhone™ and available to GreaseMunky. In order to integrated data from a CSV file into GreaseMunky, we must first select the CSV file.

CSV Files Page

The CSV Files page allows the user to select files the user has installed into GreaseMunky. The files can be deleted, or selected for parsing. An example of a CSV Files page appears below.

We can select CSV files from the list of files presented. Once selected we go to a wizard that will allow us to match column names to GreaseMunky supported fields. Additionally we can use the Edit button to enter editing mode so we can delete any of the CSV files from our phone. Only files with the .csv extension will appear in this list.

Matching GreaseMunky Fields to CSV Columns

In order for GreaseMunky to convert a CSV file, it must know which columns from the CSV file contain information that match fields in GreaseMunky. There may be columns that are not supported in GreaseMunky, likewise there may be fields in GreaseMunky that are not included in the CSV file. That's OK, it should still work, and worse case, you may have to manually enter some information for the fields that were not included.

Vehicle Selection

In order for GreaseMunky to create a new record, it must know what vehicle to associate the record with. The first page in the wizard allows the user to either select an existing vehicle already created in GreaseMunky explicitly, or select a field that contains the name of the vehicle. The Vehicle Select page looks like the image below.

In the above image, you can see (as indicated by the blue checkmark), the vehicle named "Jetta" is selected. In cases where the vehicle is predefined like this, no column of the CSV file will be used to determine the vehicle name, instead the vehicle selected will be associated with all new records.

In other cases, there will be a column in the CSV file that identifies the vehicle. When you select "Select vehicle field" from the table, GreaseMunky will take you to a page containing a list of all the columns found in the CSV file. The Column Picker page looks like this:

The titles of these columns is determined from the first row of the CSV file, so make sure there is a row starting the file with the names of the associated columns. You can see on this page that the column title is displayed at the top of each row, below that is an example of the data from that row. This can be very useful in determining what the row contains. Select the desired row, and when you are done, hit the back button to go back to the vehicle selection page.

GreaseMunky will check that all the vehicles specified in that column have already been defined in GreaseMunky. If they do not, the user will be asked if the discovered vehicles should be added. If the user says no, the column select is aborted since there is not a vehicle for each of the entries in the column.

Notice the button in the upper right corner of the screen. This is the wizard navigation button, and it used to go to the next step in the wizard. This button is not enabled until the requirements of the current step has been satisfied. In this case a vehicle has be explicitly selected or a valid column with vehicle names must chosen.

Record Type Selection

GreaseMunky must also be able to ascertain what type of record it is that is being imported. Currently only Fueling and Repair records can be imported. Much as was the case with the Vehicle Selection page, the user has the option of explicitly choosing Fueling or Repair from the table, or a column can be chosen that specifies the type of data record. If a column is chosen, no validation is done on the data in the column to ensure it represents record type. If the column contains the words "fuel", "gas" or "petrol", the record is assumed to be a fueling, otherwise it is maintenance.

Identifying Other Fields

With the previous two steps in this wizard process satisfied, we can associate other columns from the CSV file with the remaining available GreaseMunky fields. After completing record type selection and hitting the Next button, you will see the Field Selection page like the one below:

This page contains a table with one entry for each supported GreaseMunky field. Each row in the table has a description of the GreaseMunky field on the top, and below the name of the column from the CSV file (if one is selected) in white, or if one is not selected yet, the name of the field in gray.

When you select a row, you will be taken to the Column Picker to select a column from the CSV file. The selected column will provide the data for the associated GreaseMunky field. When you return, you will see the name of the column you selected under the description of the GreaseMunky field.

Once you have matched all possible fields, click the wizard navigation button in the upper right corner of the screen to move on to the next step where we can see the records as GreaseMunky parsed them, and select the ones we want to import. The next section provides more detail on this topic.