Help‎ > ‎

1. How to import data from CSV text file

Sample data


> Sample spreadsheet 1



Instruction


A CSV file is a plain text file which stores spreadsheet or basic database-style information in a very simple format. Most PC based spreadsheet program can create CSV file and we will use Microsoft Excel for this example.


Step 1) Excel

Go to Excel and open a spreadsheet. 


Step 2) Header


Create header line in the first row with the titles of each column. Available column titles are as follows.

entryProject
entryClient
entryTag

entryDate
entryTimeStart
entryTimeEnd
entryTimeBreak
entryTimeRate

entryMileStart
entryMileEnd
entryMileBreak
entryMileRate

entryLocation
entryNote

Please make sure to use only the given titles listed above. If a column is not properly titled, all the values in the column will be ignored.


Step 3) Rows



Enter the entries from the second row.

Each row will become one entry and Texts in each columns are imported to corresponding fields.

When entering the data, please make sure the following data format requirements.

1. Date format
All the date values should be in "YYYY-MM-DD" format.
(i.e. 2011-12-31, 2012-02-28, ..)

2. Time format
All the time values should be in 24 hour "HH:MM" format.
(i.e. 23:59, 15:00, 09:30...)

3. Match the prject, client or tag
The value in "entryProject", "entryClient" and "entryTag" should match to the existing ones in Time Punch. Otherwise, new prject, client and tags will be created.

In case, the project column is left blank, the entry will be imported into "Imported" project by default.



Step 4) Save


Save the spreadsheet.

When saving file, make sure to save the spreadsheet as "csv" type. For this, use the "CSV (Comma delimited) (*.csv)" option in "Save as Type". Class Buddy cannot understand the default "xls" type.


Step 5) SD card

Now, your job is done in Excel. Copy the file to SD card and go to Time Punch 


Step 6) Import setting


"Import" options are located in Time Punch Main > MENU > Settings > Import & Export.


Step 7) Import screen


In import screen, you will see the list of folders and files in SD card. Folders have yellow folder icon in left, and CSV files has white import icon in right side.

Select the CSV file you just created in Excel. Then you will see your entries. 


Step 8) Import

You can import either (1) individual items or (2) all entries. "Import All" Button will import all the entries at once. For individual items, press on the entry item and select "Import" button.


Extra) Language encoding problem

If your CSV file includes non-English characters such as Asian two-byte character, you may have display problem.

This problem is mostly caused by the language-encoding difference between Windows Excel and Android OS. If you are familiar with encoding, you may solve the problem using third party notepad application such as NotePad++ or EditPlus. These programs can convert "ASCII" in Excel CSV to "UTF-8" which is used by android OS. Otherwise, we recommend "Import from Google Docs" option instead of CSV import.


Questions?

If you have some problem, please contact us. We will be more than happy to assist you. :^)