Quickbooks Import QBI

[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

[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?

[adam5532]

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

[adam5532]

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

[fusionsp]

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

[adam5532]

Hi,

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

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

[jrev0]

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

[fusionsp]

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.

[adam5532]

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.

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

[fusionsp]

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