http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/574.aspxMon, 06 Apr 2009 20:38:11 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:574Anonymous0http://forums.method.me/cs/forums/thread/574.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=574<p>I received a question from David who asked:<br /><br /><i>&quot;I am doing some work for a landscaping company and we want to import our employees timesheet information from excel into quickbooks.&nbsp; We will need to allocate what amount of time an employee spends on several different tasks and whether or not those items will be billable or unbillable.&nbsp; Do you have a solution for this?&quot;</i></p> <p>In order to import any information from an outside program, such as Excel, into Method, you need to use the Method API.&nbsp; The Method API is a way for programmers to communicate with Method from outside.&nbsp; Lucky for you, we have a sample app that we created for developers that imports information from Excel into Method.&nbsp; To download the app, click the link below.</p> <p><a target="_blank" title="Method API Excel Importer" href="http://www.methodintegration.com/documentation/MethodAPISample_ImportRecordsIntoMethod.zip">MethodAPIExcelImporter</a></p> <p>You will need a Method account in order to use the Excel importer.&nbsp; Follow the instructions on the first page of the sheet.&nbsp; As a hint, be sure that each of your columns has a proper field name mapped to the name of the field in your database.&nbsp; In your case, you will be using the Timetracking table in Method.&nbsp; After that, copy and paste all your records into the Excel sheet, making sure they match up with the column headings.&nbsp; You will then be able to import this data right into Method.&nbsp; </p> <p>Powerful stuff!</p>