View Full Version : Timer for Mac users to be imported to PC
willisco
10-09-2002, 06:01 PM
Is there a way for Mac users to input timesheet data which can be imported into QBPro2000 or higher as a time sheet? The 3rd party software I've explored thus far can import data entered over the internet into pc qb, but generates an invoice - i just need it to create a time sheet.
Maybe even the Mac version of the Timer program could create an iif file which could be imported to pc?
Thanks for any input.
gibbo
10-25-2002, 07:27 PM
The timer is getting a lot of attention lately. People don't seem to quite understand what it is or how it works.
The Timer is a small Visual Basic program over an Access Database. You can see the database by renaming the database with .mdb and opening it in Access. When you export a Timer file, it creates an IIF file for import to QuickBooks. When the information has been charged to the client, a field chages form 0 to 1. (I haven't got it on this amchine so I can't give you the exact details).
An IIF file is a Tab-delimited text file with headers. It can be created in anything that can create a tab-delimited text file, from Notepad to Excel, or a Mac program.
The Timer uses Customer and Item information from QuickBooks as it's data. You export these from QuickBooks and import into the Database. The timer then uses these with the time billed to create the file for import into QuickBooks.
Have a look at these files and you can see what to do.
LUKEIRE
01-07-2003, 03:00 PM
IS THERE AN ADD ON FOR BASIC QUICKBOOKS SO WE CAN USE "TIMER" ?????
gibbo
01-07-2003, 03:25 PM
Interesting thought.
The timer is a completely free-standing program, using list information exported from QuickBooks and exporting list-style information back to QuickBooks. The linkage in QuickBooks only simplifies the process. It is possible to simply put the timer on your computer and manually export the lists from your QuickBooks file in an IIF format. From these, you could create the file in Excel from the Lists exported from your QuickBooks file.
It uses: Company info
Items
Customers
Classes
Vendors
Employees
Other Names
It also requires specific header information.You would need to get a copy of the file to see how it is set up.
This can then be manually entered into the timer from within the timer itself. After using it, you export a timer file as an IIF file for input into QuickBooks. This can be done through the File / Utilities / Import function in QuickBooks. I only have the Pro version so have not looked at whether there is any missing functionality in the basic QuickBooks relating to billing time. If the functionality exists, then everything can be done manually.
The Timer is in a separate folder on the QuickBooks pro disk and can be installed separately.
Not sure what the legal implications are, though.
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.