Home Page link  

IIF files

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
IIF files Chris 09-17-2007
Posted by Chris on September 17, 2007, 2:02 am
Please log in for more thread options
 Our QB file (2002 Pro US) is set up to import new and edited supplier
& customer addresses via IIF files from our proprietry order entry
system.

Everything is fine except that the Accounts people do not want to
import the contact name, tel, fax & email information so that they can
then enter their own details. So I removed these 4 fields from the IIF
file and on import QB blanks them all out.

Is their any work around to leave the fields alone on import?

Many Thanks

Chris


Posted by Gary E on September 17, 2007, 9:30 am
Please log in for more thread options
 On the four offending fields, how did you remove the info?

Did you completely delete the four columns, including the header info -or-
Did you leave the header info, and just leave blanks in the data.

Gary

> Our QB file (2002 Pro US) is set up to import new and edited supplier
> & customer addresses via IIF files from our proprietry order entry
> system.
>
> Everything is fine except that the Accounts people do not want to
> import the contact name, tel, fax & email information so that they can
> then enter their own details. So I removed these 4 fields from the IIF
> file and on import QB blanks them all out.
>
> Is their any work around to leave the fields alone on import?
>
> Many Thanks
>
> Chris
>



Posted by klunk on September 17, 2007, 12:13 pm
Please log in for more thread options

"Chris":
> Our QB file (2002 Pro US) is set up to import new and edited supplier
> & customer addresses via IIF files from our proprietry order entry
> system.
>
> Everything is fine except that the Accounts people do not want to
> import the contact name, tel, fax & email information so that they can
> then enter their own details. So I removed these 4 fields from the IIF
> file and on import QB blanks them all out.
>
> Is their any work around to leave the fields alone on import?
>


With IIF, importing a list that already exists overwrites
all fields. So if the field is blank or not included the result is
the same. The only way I can think of to deal with this in IIF
is to first export the lists from QB and merge the fields you
note into your data before importing your IIF into QB.

If you use the QB SDK, you can selectively import fields
without overwriting others.
http://developer.intuit.com
http://idnforums.intuit.com



Posted by klunk on September 17, 2007, 12:16 pm
Please log in for more thread options

"klunk"
> With IIF, importing a list that already exists overwrites
> all fields. ...


That should have been:

With IIF, importing a list record that already exists overwrites
all fields in that record (records are ID'd by the NAME field).



Similar ThreadsPosted
Help files February 23, 2007, 7:49 am
How to keep files in sync June 10, 2006, 9:11 am
location of QB files August 16, 2006, 8:09 pm
combining files August 22, 2006, 12:15 pm
Open files on another mac? June 27, 2007, 12:22 pm
Copying data files October 16, 2006, 12:46 pm
Restoring files in Quickbooks PRO 99 ?"? August 4, 2008, 12:57 pm
Backup vs COPYing the files in XP August 12, 2008, 5:46 pm
Multiple files - how to discern/open October 20, 2006, 4:21 pm
Restore from multiple backup files? January 25, 2007, 5:25 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap