Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_php thread: Script to output QIF format


Message #1 by "Mark Whiteley" <info@c...> on Tue, 19 Feb 2002 23:18:32 +1000
I found this, it may help...

Nasser Ahmed :)

Addressed to: "Dallas Kropka" <dallask@a...>
php-general@l... 

** Reply to note from "Dallas Kropka" <dallask@a...> Sat, 13
Jan 2001 19:15:02 -0600 > > I need to create files and reports for
importation into QuickBooks, > but they need to be in the IIF file
format that QuickBooks > supports.... where can I find information for
creating these files? 

The content of the iif files is defined in Quickbooks help. Look for IIF
or Data import. It differs for each type of data you are transferring.
You will have to look in help to get the definitions. There is also info
on the subject and example files on the quickbooks web site.
www.quickbooks.com, I think. Search on IIF, and maybe the type of file
you want to create. 

<From memory, not tested> You can provide several different types of
data in a single file. The file needs to start with a definition of the
fields you are going to present. These definition lines start with !.
Each of your data lines must have the exact same fields in the order you
defined them in the ! lines. You don't have to provide all the possible
values, but some record types do have required fields that must be
provided, and filled in. 

Each record is a number of values with "\t" between them. The record
ends with "\r\n". You must use double quotes so the tabs (\t) and
Dos/Windows style line breaks {\r\n) are converted to the proper
character values. </from memory> 

Once you have reviewed Quickbooks help, and the web site, if you have
specific quesions on your file format, ask again. It is actually pretty
easy. The best way to verify your files during development is to open
them with a spreadsheet program. Also, you MUST backup the quickbooks
data before you try testing your upload. If it fails for any reason,
just restore, fix the problem and upload again. Don't feel bad if you do
this a couple dozen times before everything works. 

Rick Widmer Internet Marketing Specialists http://www.developersdesk.com


-----Original Message-----
From: Mark Whiteley [mailto:info@c...] 
Sent: 19 February 2002 13:19
To: professional php
Subject: [pro_php] Script to output QIF format


Does anyone know or have a script that outputs transaction data to QIF
format for upload to Quickbooks?

thanks

Mark Whiteley
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to $subst('Email.Unsub').






  Return to Index