Import file formats
TimeCache's list import feature requires text-only files that have been saved with each field separated by a tab character, and each listing on a separate line (as determined by a Return character). This is commonly known as "Tab-delimited" or "Tab and Return Separated" format in other applications.

Each type of TimeCache listing file must follow a specific format with certain fields required. Those formats are listed here. If required fields are missing from line, the line won't be imported.

Client Import format:
Field Required
Client name Y
Client code N
Client hourly billing rate *N
Contact name N
Company N
Address line 1 N
Address line 2 N
City N
State/Province N
Zip/Postal code N
Country N
Phone N
Email address N

* Required when TimeCache preferences are set for Client billing rates.

Project Import format:
Field Required
Client name Y
Project/Matter name Y
Job number Y
Project hourly billing rate **N
Estimate amount N
Custom data N
Calendar shortcut N

** Required when TimeCache preferences are set for Project billing rates.

Billing Category Import format:
Field Required
Activity name Y
Report alias Y
Hourly billing rate ***N
Category type ("A" for timed activity, "E" for Expense -- both A and E should be entered without quotation marks) Y
Calendar shortcut N

*** Billing rate not required for Expense categories that are not "fixed rate", which bill at a per-unit rate.


Glossary Import format:
Field Required
Glossary entry abbreviation Y
Full glossary entry text Y



Markup Import format:
Field Required
Markup name Y
Percentage (in whole number, e.g. "20" for 20%) Y