♥John W Posted May 10, 2003 Posted May 10, 2003 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.
Guest Posted May 10, 2003 Posted May 10, 2003 The first error message... Warning: fopen("/home/driedflo/public_html/qb/qb_sale.iifIt 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
♥John W Posted May 10, 2003 Author Posted May 10, 2003 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.
Thomas Whitelock Posted May 14, 2003 Posted May 14, 2003 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.
♥John W Posted May 14, 2003 Author Posted May 14, 2003 Thomas, did it work for you after you made that change? I'm not really a dog.
Thomas Whitelock Posted May 14, 2003 Posted May 14, 2003 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.
♥John W Posted May 14, 2003 Author Posted May 14, 2003 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.
Thomas Whitelock Posted May 15, 2003 Posted May 15, 2003 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.
♥John W Posted May 15, 2003 Author Posted May 15, 2003 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.
♥John W Posted May 15, 2003 Author Posted May 15, 2003 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.
Guest Posted May 15, 2003 Posted May 15, 2003 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
♥John W Posted May 15, 2003 Author Posted May 15, 2003 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.
Guest Posted May 16, 2003 Posted May 16, 2003 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.