Kryptronic Software Support Forum

queendavidK · 08-29-2003 00:02:30

Hi Nick,

When I try to import my file into Quickbooks I get following message "Found a misplaced SPL Line in the import file" What should I be looking for in the way of errors?

Thank You

Audrey Downing

webmaster · 08-29-2003 09:51:13

Are all of your accounts set up correctly in Quickbooks/CCP?

___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.

Guest · 08-29-2003 10:00:33

All are Legitimate accounts in Quickbooks, But may be I am not understanding the Invoice Name fields. Could that be it.

Thanks in advance

Audrey Downing

kontrabass · 09-07-2003 16:24:52

I'm getting the same error - I have the accounts set up correctly, but I too am having trouble understanding the invoice fields... any advice on how to set those up? I'm using 2003 pro...

Guest · 09-09-2003 17:31:19

If you want super easy, seamless Quickbook integration, you can go to wwwwriteitonce.com and get "Shopping Cart Assistant." One of the best utilities I've ever bought. It will automatically import order files (or read the order emails) and put them in QB. But the neat part is...it sets up a new customer at the same time. Really, really cool. It does some other things too...like shipping integration, and it has a function for taking phone orders. Anyway, check it out and see if it might help you.

kontrabass · 09-11-2003 08:23:26

I'd love to, but $300 is a bit out of my pricerange :-( Thanks though.

dwhs · 09-17-2003 01:16:26

I get the same error too.

I bought quick books just for this reason and now i am really bummed out.

I have accounts and customers set up in it but the import gets the error above.

Is there a help file on this?

$300 that's twice as much as quickbooks and not a good deal in my oppinion.

Thanks, Charles

webmaster · 09-25-2003 11:35:07

I'm looking into this. I've now got three people this isn't working for and ten that it is for sure. Must be a config issue, but I am still looking.

kontrabass1 · 10-20-2003 10:52:36

Just wondering if there's any progess on this. I'd sure like to be able to use this feature

Thanks!

webmaster · 10-20-2003 11:56:02

I have yet to identify any problems with Quickbooks as all my tests come back fine. I am still doing research and will be including any necessary fixes in the pending CCP 5.1 update (due out soon) to take care of this issue.

inksticks · 10-21-2003 11:17:02

I'm having the same problem. I hope you can get that fix soon. I really need to export. Thanks!

dwhs · 10-21-2003 15:36:17

Strange,

I deleted the shopping cart and re-installed it from scratch to see if the cart had a bad install aunfortuantly the export feature still does not work.

I am sure it's based on the product options, maybe if you do not include the options in the export file it may help. Although I tried deleting them on the file; the import did not get the error after I delted them but no information was carried..

webmaster · 10-27-2003 11:14:45

Interesting. To delete the product options from the file, in the file ./cgi-bin/library/modules/adm_acct.pl in the routine 'adm_acct_qb_proc' look for the line:

Code:


$item_string = "$html_item_string\: $trackitem_itemnumber - $trackitem_itemname\; $html_quantity_string\: $trackitem_quantity\; $trackitem_options";

And change to:

Code:


$item_string = "$html_item_string\: $trackitem_itemnumber - $trackitem_itemname\; $html_quantity_string\: $trackitem_quantity";

Does that help?

lvshell · 11-25-2003 15:16:26

queendavidK,08/29/2003 12:02:30 AM wrote:
Hi Nick,

When I try to import my file into Quickbooks I get following message "Found a misplaced SPL Line in the import file" What should I be looking for in the way of errors?

Thank You

Audrey Downing

Actually, I found that the SPL error comes from downloading the file in Binary.
The Quickbooks.iif file has to be downloaded in ASCII only.
If you dl in ASCII, you will not get the missplaced SPL line error.

Good Luck,

LVShell

webmaster · 11-25-2003 16:42:58

Thanks for this. While coding the update I realized that the ENDTRNS lines in the file had a \n character at the end instead of a \r\n. With the pending update this will be corrected. I'm about to post something on the update in a minute or two.

cybermed · 11-28-2003 15:12:56

I too am getting the same error, would be great to ge an update so we can sell this puppy to the client! ) Evan

webmaster · 12-01-2003 15:21:54

The update for 5.1 will be released tomorrow.

LKOS · 02-07-2004 08:36:43

Now, I installed TiKi update and was able to export all the transaction for Quickbooks. I'm using Quickbooks Pro 2004.

After that, when I try to import it to Quickbooks, I'm getting an warning "The Tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, no non-taxable sales will be correct for this district."

and then if I click ok on that warning I get another warning "Error on Line XX: Can't record invalid transactin" I noticed that line xx is ENDTRNS.

I spent whole night to figure out what's wrong, but no luck ..
Please help me ...

Thanks .
You Jee.

sgreiner · 02-07-2004 12:16:06

I dont get "The Tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, no non-taxable sales will be correct for this district." but I do get the error on linexx and that line has the ENDTRNS in it. If I delete that line, it does inport. I posted a different question on Quickbooks and Nick said that the customer info would be imported.. i still cant find any name or address... nothing when I go into Quickbooks. Could it be because of this error?

my other post:

sgreiner · 02-08-2004 01:20:39

I have to correct my last post. I have the same issue as LKOS. I get the "Warning message" and then the "error on line xx" error message.

webmaster · 02-13-2004 11:07:16

I believe we're wrking on this via email. It has to do with the Autotax field and it being required by Quickbooks.

Oliver Passe · 09-24-2004 18:21:50

LKOS,02/07/2004 08:36:43 AM wrote:
Now, I installed TiKi update and was able to export all the transaction for Quickbooks. I'm using Quickbooks Pro 2004.

After that, when I try to import it to Quickbooks, I'm getting an warning "The Tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, no non-taxable sales will be correct for this district."

and then if I click ok on that warning I get another warning "Error on Line XX: Can't record invalid transactin" I noticed that line xx is ENDTRNS.

I spent whole night to figure out what's wrong, but no luck ..
Please help me ...

Thanks .
You Jee.

Nick, Others:

I'm getting the same message from Quickbooks Pro 2004 when attempting to upload the quickbooks.iif datafile.

Any progress on a patch since the last post in February?

Regards,
Oliver Passe
wwwNventa.com

webmaster · 09-27-2004 10:46:02

All Quickbooks issues in 5.1 were corrected in the 11/23/2003 update (first update to tiki). I know of no known issues with the iif files. Most user problems are tracked back to invalid account setup either on the Quickbooks side, or the CCP Accounting Settings side.

Kryptronic Software Support Forum

#1 08-29-2003 00:02:30

Quickbooks Import

#2 08-29-2003 09:51:13

Re: Quickbooks Import

#3 08-29-2003 10:00:33

Re: Quickbooks Import

#4 09-07-2003 16:24:52

Re: Quickbooks Import

#5 09-09-2003 17:31:19

Re: Quickbooks Import

#6 09-11-2003 08:23:26

Re: Quickbooks Import

#7 09-17-2003 01:16:26

Re: Quickbooks Import

#8 09-25-2003 11:35:07

Re: Quickbooks Import

#9 10-20-2003 10:52:36

Re: Quickbooks Import

#10 10-20-2003 11:56:02

Re: Quickbooks Import

#11 10-21-2003 11:17:02

Re: Quickbooks Import

#12 10-21-2003 15:36:17

Re: Quickbooks Import

#13 10-27-2003 11:14:45

Re: Quickbooks Import

Code:

Code:

#14 11-25-2003 15:16:26

Re: Quickbooks Import

queendavidK,08/29/2003 12:02:30 AM wrote:

#15 11-25-2003 16:42:58

Re: Quickbooks Import

#16 11-28-2003 15:12:56

Re: Quickbooks Import

#17 12-01-2003 15:21:54

Re: Quickbooks Import

#18 02-07-2004 08:36:43

Re: Quickbooks Import

#19 02-07-2004 12:16:06

Re: Quickbooks Import

#20 02-08-2004 01:20:39

Re: Quickbooks Import

#21 02-13-2004 11:07:16

Re: Quickbooks Import

#22 09-24-2004 18:21:50

Re: Quickbooks Import

LKOS,02/07/2004 08:36:43 AM wrote:

#23 09-27-2004 10:46:02

Re: Quickbooks Import

Board footer