Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

quickbooks mod causing crash


John W

Recommended Posts

Posted

Hi Everyone,

 

I installed the quickbooks mod and everything seemed fine until I ran a test order and I got this message.

 

Warning: fopen("/home/driedflo/public_html/qb/qb_sale.iif", "a") - No such file or directory in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 126

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 132

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 133

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 134

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 150

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 215

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 227

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 243

 

Warning: fclose(): supplied argument is not a valid File-Handle resource in /home/driedflo/public_html/catalog/includes/qb_iif_sale.php on line 244

 

Warning: Cannot add header information - headers already sent by (output started at /home/driedflo/public_html/catalog/includes/qb_iif_sale.php:126) in /home/driedflo/public_html/catalog/includes/functions/general.php on line 23

 

 

 

Any help is VERY much appreciated.

I'm not really a dog.

Posted

The first error message...

Warning: fopen("/home/driedflo/public_html/qb/qb_sale.iif

It looks like its having problems finding you qb_sale.iif file which is supposed to be located (according to what is in the code) in /qb directory off of root.

 

Make sure that the qb_sale.iif file is actually there and has the appropriate permissions set.

 

Good Luck.

 

-R

Posted

Hi Randy, thanks for responding. The mod is supposed to create the file but I tried putting it up there myself and setting permissions to 777 and it still gave the same error. It was getting the best of me so I had to walk away for a while and I was out of ideas.

 

Hopefully, I will find a solution and I can post it for the next person.

 

John

I'm not really a dog.

Posted

I had the same problem, madding isn't it???

 

In the qb_iif_customer.php file

 

change $custfile = $DOCUMENT_ROOT . $myfile;

 

to

 

$custfile = $/home/www/yourdomain.com . $myfile;

 

(or whatever your actual path is), for some reason the QB mod did not pick up on the correct path.

 

I was looking at the Server Info in Admin when I noticed the paths did not match.

 

HTH

 

-Thomas

"Silence!", thundered Sir Topham Hatt.

Posted

Thomas, did it work for you after you made that change?

I'm not really a dog.

Posted

Work is such a relative term isn't it?

Assuming only people with preexisting accounts order from your site you should be good to go.

I had installed the contribution about 6 weeks ago and the next day the client said osCommerce just was not for him. Sorry I forgot that when you created a new account it would abend.

I changed the $myfile variable to just contain the entire path, I put a few orders on (new and existing customer) and it updated the .iif file as expected.

 

Here is the change I made-

 

$myfile = "/home/www/yourdomain.com/catalog/quickk/qb_sale.iif";

// Where will our transaction import file be located?

 

// **** You shouldn't have to touch anything past this point ****

 

$custfile = $myfile;

 

Sorry for the trouble,

-ctw

"Silence!", thundered Sir Topham Hatt.

Posted

I appreciate you help and this is maddening :x

 

Did you just change customer.php or did you change sale.php too?

 

As I play with it I think I get closer sometimes but I still get errors.

 

Did you switch off the sale.php?

 

that is the one that keeps giving me errors.

I'm not really a dog.

Posted

Same deal with qb_iff_sale.php

 

define

$myfile = "/home/www/plumbware.com/catalog/qb_sale.iif"; // Where will our transaction import file be located?

 

to

 

$myfile = "/correct path/qb_sale.iif"; // Where will our transaction import file be located?

 

and

change (line 43?)

$salefile = $DOCUMENT_ROOT . $myfile ;

 

to

 

$salefile = $myfile ;

 

I tried to import the file into QB 2003 Pro

Trial version and it bombed out, but that is another story. Invalid Transaction Line 4 was the error i got.

 

HTH

-ctw

"Silence!", thundered Sir Topham Hatt.

Posted

Well, I have it working to where it is not crashing the site but I ended up having to manually create that file and I think the last time I tried to create it I didn't have the path correct. However, now when I import it to quickbooks I get a bunch of errors there. I guess one day I'll get this to work.

 

I appreciate everyones help with this and I think the hardest part is over. Of course, you never know.

I'm not really a dog.

Posted

Well, something is unstable because it's yielding error codes again.

 

This is definitely an excercise in frustration :evil:

I'm not really a dog.

Posted

Sorry, this isn't anything helpful, but I did have a question.

 

Where do you find this Quickbooks Mod and what all does it allow you to do working with Quickbooks?

 

Thanks

Shawn

Posted

The Mod is in the contribution section on the downloads of the main OSC site and you can find the button at the top left of the forums screen.

 

What it will do is allow you to import your customer and sales information into Quickbooks instead of manually keying it in.

 

I found my error code just now was something I had done without realizing it. User error :oops:

I'm not really a dog.

Posted

Thanks John. Glad to hear you figured out what the problem was. Sounds like it could be a very useful tool. I think I'm going to have to give it a try.

 

 

Shawn

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...