Quickbooks Import QBI

HI

Does anyone know how to solve this issue with the QBI import

Install QBI database tables for version 3.21?



Registered to: QBI_USER_NAME, QBI_USER_COMPANY #QBI_USER_REGNO
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

As soon as I try to install the data tables i get the following

Error: SQL file not found

Can anyone please advise

Many thanks
Justin

ok, I looked and searched thru bunches of pages and cant find what I need help with...prob easy fix.

i installed this mod, everything seems working fine. but when i try to puch the links across the top: create iif, setup, match, config, and support...they all point to a nonexistant link. where do i change this to make it match my site?

Quote:

---

Originally Posted by jrev0

HI

Does anyone know how to solve this issue with the QBI import

Install QBI database tables for version 3.21?



Registered to: QBI_USER_NAME, QBI_USER_COMPANY #QBI_USER_REGNO
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

As soon as I try to install the data tables i get the following

Error: SQL file not found

Can anyone please advise

Many thanks
Justin

---

Are the SQL files actually there where you installed QBI or not?

Thanks,
Adam

Quote:

---

Originally Posted by fusionsp

ok, I looked and searched thru bunches of pages and cant find what I need help with...prob easy fix.

i installed this mod, everything seems working fine. but when i try to puch the links across the top: create iif, setup, match, config, and support...they all point to a nonexistant link. where do i change this to make it match my site?

---

QBI gets the file paths from your Zen Cart set-up, so if the links are wrong you may have an incorrect path in your Zen Cart config file.

What are the links that the menus point to now?

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

QBI gets the file paths from your Zen Cart set-up, so if the links are wrong you may have an incorrect path in your Zen Cart config file.

What are the links that the menus point to now?

Thanks,
Adam

---

Yea thats what i figured. i have looked in a bunch of places and am unable to find them yet.

right now they point to...http://admin/qbi_create.php for example

i understand that it needs to be elsewhere but i dont know how to change the link. Help please:blink:

Hi,

Quote:

---

Originally Posted by fusionsp

Yea thats what i figured. i have looked in a bunch of places and am unable to find them yet.

right now they point to...http://admin/qbi_create.php for example

i understand that it needs to be elsewhere but i dont know how to change the link. Help please:blink:

---

The web and file system constants are set in /catalog/admin/includes/qbi_app_top.php. There's a section near the top called "User Area".

The one that affects the menus is:

[FONT="Courier New"]define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)[/FONT]

so as you can see, if DIR_WS_ADMIN is wrong in Zen Cart, it will be wrong in QBI. If you must, you can replace DIR_WS_ADMIN with a hard-coded location.

Thanks,
Adam

hi

Im still unsure to what im meant to being filling into the qbi_app_top.php

Ive found the 2 areas in question

define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN); // (full virtual file path)

What do i insert here, ive installed all the database patches etc.

Hope you can help as this has really confused me.

Thanks

Justin

Quote:

---

Originally Posted by adam5532

Hi,

The web and file system constants are set in /catalog/admin/includes/qbi_app_top.php. There's a section near the top called "User Area".

The one that affects the menus is:

[FONT="Courier New"]define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)[/FONT]

so as you can see, if DIR_WS_ADMIN is wrong in Zen Cart, it will be wrong in QBI. If you must, you can replace DIR_WS_ADMIN with a hard-coded location.

Thanks,
Adam

---

ok forgive me but i still am unable to figure out the correct way to write this.

i have tried 10 different ways an im still lost. right now i have the following
define('DIR_QBI_WS', DIR_WS_ADMIN,'/admin/'); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN,'/www/fusionspiritualemporium/admin/'); // (full virtual file path)

i must have not installed zencart correct from the beginning. someone please help. :frusty:

Quote:

---

Originally Posted by fusionsp

ok forgive me but i still am unable to figure out the correct way to write this.

i have tried 10 different ways an im still lost. right now i have the following
define('DIR_QBI_WS', DIR_WS_ADMIN,'/admin/'); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN,'/www/fusionspiritualemporium/admin/'); // (full virtual file path)

i must have not installed zencart correct from the beginning. someone please help. :frusty:

---

Replace the existing constant -- don't add a third one. Try this:

define('DIR_QBI_WS', '/admin/'); // (full web path from www root)
define('DIR_QBI_FS', '/www/fusionspiritualemporium/admin/'); // (full virtual file path)

Again, this shouldn't be necessary if DIR_WS_ADMIN and DIR_FS_ADMIN are set correctly in the Zen Cart config file.

- Adam

Quote:

---

Originally Posted by adam5532

Replace the existing constant -- don't add a third one. Try this:

define('DIR_QBI_WS', '/admin/'); // (full web path from www root)
define('DIR_QBI_FS', '/www/fusionspiritualemporium/admin/'); // (full virtual file path)

Again, this shouldn't be necessary if DIR_WS_ADMIN and DIR_FS_ADMIN are set correctly in the Zen Cart config file.

- Adam

---

ok maybe I shoud be changing the zencart config file? I changed it to what you said and now i have an error. Where is the config file? Where do i set the DIR_WS_ADMIN and DIR_FS_ADMIN at?

here is the error i get now:
Warning: require_once(/www/fusionspiritualemporium/admin/includes/classes/qbi_mysql.php) [function.require-once]: failed to open stream: No such file or directory in /home2/fusionsp/public_html/admin/includes/qbi_app_top.php on line 54

Fatal error: require_once() [function.require]: Failed opening required '/www/fusionspiritualemporium/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/fusionsp/public_html/admin/includes/qbi_app_top.php on line 54