IIF file says it imported, but nothing there?

Grace Testani

unread,

Jun 25, 2002, 1:19:49 PM6/25/02

to

Hi All:

I just created an IIF file for ITEMS following the format of an exported
ITEMS file. Everything looks fine.

When I import it into QuickBooks, the program says "Your data has been
imported". But when I look at the list of ITEMS, the entries are not there.
(The HIDDEN field is set to N)

Any ideas on what's happening here?

TIA,
Grace

JMC

unread,

Jun 26, 2002, 12:55:58 PM6/26/02

to

It means that you don't have the file formatted properly. I assume you set
it up in Excel. It has to be saved as a text file and the file name has to
be in quotes with the .IIF file extension on it such as a file name like:
"My Items.IIF" If you have the correct headings and have used the !INVITEM
heading to start the list, then this is probably the problem.
"Grace Testani" <c...@ccc3online.com> wrote in message
news:VC1S8.4554$DQ5.2...@newsread2.prod.itd.earthlink.net...

Ed Hickland

unread,

Jun 27, 2002, 3:57:25 PM6/27/02

to

Your file is not formatted properly. QB can read the file and does not find
errors or data it can read.

BTW. The file does not need the .iif extension but it must be a
comma-separated-value (CSV) text file. Use "Save As" from Excel to create
the file.

"Grace Testani" <c...@ccc3online.com> wrote in message
news:VC1S8.4554$DQ5.2...@newsread2.prod.itd.earthlink.net...

Grace Testani

unread,

Jul 7, 2002, 12:58:36 PM7/7/02

to

Thanks,
I'll check that out.

Grace

"JMC" <dothe...@email.com> wrote in message
news:OLnmkITHCHA.2040@cpimsnntpa03...

Grace Testani

unread,

Jul 7, 2002, 12:59:25 PM7/7/02

to

Thanks, Ed:

I'll double check that I'm saving it properly.

Grace

"Ed Hickland" <ehic...@nassau.cv.net> wrote in message
news:z6KS8.30362$5M2.1...@news4.srv.hcvlny.cv.net...

apti...@yahoo.com

unread,

Jul 7, 2002, 8:15:43 PM7/7/02

to

"Grace Testani" <c...@ccc3online.com> wrote in message news:<Nr_V8.5402$A43.4...@newsread2.prod.itd.earthlink.net>...

> Thanks, Ed:
>
> I'll double check that I'm saving it properly.

I agree with the previous response that the problem is most likely the
headers -- it is very tricky.

I would suggest that you create one item manually in QB; export the
inventory list; import it to Excel or whatever; then add items to the
list to be exported/imported into QB.

HTH

Grace Testani

unread,

Jul 11, 2002, 9:47:14 AM7/11/02

to

I found the problem. You were right -- it was the header. Actually, I did
a fill down from the header and that included the "!" -- which I didn't need
infront of each item name. Now the imports work like a dream.

Thanks for all your help.

Grace

<apti...@yahoo.com> wrote in message
news:36288df9.02070...@posting.google.com...

Dennis Perron

unread,

Jul 15, 2002, 9:07:47 PM7/15/02

to

Did your "quantity on hand" and "current price" fields fill
in properly? I've been trying, with no success, to import an
inventory file of approx. 6500 items into the Items list and
every field except these two load fine.

I met with a 'Certified Quickbooks Advisor' today and
he told me this is the way the item list imports and if I can
find out how to get these fields to load to show him!

Dennis

"Grace Testani" <c...@ccc3online.com> wrote in message

news:C%fX8.5808$Kx3....@newsread1.prod.itd.earthlink.net...

Karl Irvin

unread,

Jul 16, 2002, 8:21:46 AM7/16/02

to

"Dennis Perron" <per...@sympatico.ca> wrote in message
news:slKY8.1731$o7.5...@news20.bellglobal.com...

> Did your "quantity on hand" and "current price" fields fill
> in properly? I've been trying, with no success, to import an
> inventory file of approx. 6500 items into the Items list and
> every field except these two load fine.
>
> I met with a 'Certified Quickbooks Advisor' today and
> he told me this is the way the item list imports and if I can
> find out how to get these fields to load to show him!
>
> Dennis
>

You need to use an ITEMADJ iif to enter quantity and prices. A sample is
listed below.

!TRNS TRNSTYPE DATE ACCNT AMOUNT
!SPL TRNSTYPE DATE ACCNT AMOUNT QNTY INVITEM VALADJ
TRNS ITEMADJ 12/15/99 OPENING BAL EQUITY -175
SPL ITEMADJ 12/15/99 INVENTORY ASSET 175 100 Cabinets:Cabinet Pulls Y
ENDTRNS

Dennis Perron

unread,

Jul 16, 2002, 10:09:39 PM7/16/02

to

Thanks for the help Karl. I tried the ITEMADJ iif and it got the
quantity on hand numbers to load, but I still can't get the current
price to work. Is there something I missed?

Also, do I have to enter each item with a teamed TRS/SPL entry
or can I list all the TRS lines, then the SPL lines?

Thanks again for the help.

Dennis
"Karl Irvin" <88k...@attbi.com> wrote in message
news:udUY8.538325$352.92142@sccrnsc02...