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 |
|
Previous Next Up to "List
Manager"
|