Quickbooks Import QBI

Just installed QBI on 1.5. I ran into a snag with the SQL not working and I suspect its the same problem that RBiZ and others may have. It looks like some of the SQL commands are not supported by newer MySql versions. Under catalog/admin find the file qbi_0-00_3-21.sql and change all occurrences the following:

timestamp(14)
to
timestamp

TYPE=MyISAM
to
ENGINE=MyISAM

Save the file and upload it and try installing the database changes again. If you are upgrading then you will have to edit all the .sql files with these changes.

So far its working, well at least I'm able to configure it. I still have to do my first import.

Dan, if you still don't have this working let me know. I bet I can fix it. My email is gpstrackphone (at) gmail dot com.

Pete

peatmoss:

Just installed QBI on 1.5. I ran into a snag with the SQL not working and I suspect its the same problem that RBiZ and others may have...
These MySQL changes were already explained back in posts 1188 and 1189 and are needed if you are running MySQL v5.5 or later.

Thanks,
Adam

RBiZ:

OK I followed the instructions posted by delia for Admin Page Registration and was able to get to the database installation page (I placed it in "customers" rather than tools). I ran this step and it said that the installation was successful, however when I follow the instructions to configure QBI it takes me back to the install page /qbi_install.php?db_ver=0&qbi_vers=3.21
There is no option to configure.
QBI doesn't check before saying "Successful". If you are redirected to the table installation page, then the tables were not successfully installed. QBI uses the database constants set in the ZC /includes/configure.php file. Make sure that these are set up correctly, and that you have put the QBI files in the correct location. Also, check your server log immediately after trying the install for PHP errors that might indicate the problem.
Thanks, Adam (QBI creator)

adam5532:

These MySQL changes were already explained back in posts 1188 and 1189 and are needed if you are running MySQL v5.5 or later.

Thanks,
Adam

Dang thanks for pointing that out. Not sure what would have been faster? Reading all 1200 posts or just looking at my logs :) You should update the SQL files, probably only takes 2 min... Not many people running the older versions of MySql.

Also I did not see anything compelling to update to the paid version other than the possibility it works better out of the box. What about donations to you, do you have a paypal account for that? You may collect more money by donation, just a thought.

Anyways thanks for the great plugin! Works on 1.5 and QB2013. I'm still working out import issues but I believe its the configuration on my end.

Pete

Pete,

peatmoss:

Dang thanks for pointing that out. Not sure what would have been faster? Reading all 1200 posts or just looking at my logs :) You should update the SQL files, probably only takes 2 min... Not many people running the older versions of MySql.
The free version of QBI is 6 years old. If I touch it, that opens up a whole can of worms, because the PHP also needs updating as well. I hope to replace it at some point with a stripped down version of the current paid version, but I haven't found the time to do that.
Also I did not see anything compelling to update to the paid version other than the possibility it works better out of the box. What about donations to you, do you have a paypal account for that? You may collect more money by donation, just a thought.
I don't accept donations--I wouldn't take it for six year old code. If you really would like to give me money, then buy the paid version and fairly compensate me for my time and effort. I tried the donation route at first and what I got was miniscule and often insulting (considering the thousands of dollars it saves a typical store in data entry time). QBI (in its current form) has about 10,000 lines of code and has taken 1,000s of hours to write and improve. It also takes a lot of time to support. Maybe donations work for simple plugins, but not for this--that's why I long ago switched to a paid model.
Anyways thanks for the great plugin! Works on 1.5 and QB2013. I'm still working out import issues but I believe its the configuration on my end.

Pete
Thanks, I appreciate it!
Adam

Where can we see the paid version??

CCMall:

Where can we see the paid version??
I can't discuss that in this forum, but Google it and you will find it.
Adam

Hi, I just installed this and nothing happened. I don't see it under Customers or Config or anywhere. Is it because I'm using the latest version on Zen and maybe it doesn't work with it??

I want to sort the list of QB items on the QBI>Match>Products page. I've searched and searched for the SQL and just cannot find it. Anyone know where to make this change?

Thanks,
Leslie

Hi, I just installed this and nothing happened. I don't see it under Customers or Config or anywhere. Is it because I'm using the latest version on Zen and maybe it doesn't work with it??

Likewise, Installed qbi_zen155e on Zencart 1.5.5e, seems too easy, no instructions, are files missing in the latest contribution?

I was able to successfully modify and install QBI import on Zen Cart 1.5.5f. resolved all the errors and even brought to (somewhat) new standard on installing the plug-ins. I will try to find time to package it and upload it to the Plug in page in the coming weeks.

Techiant:

I was able to successfully modify and install QBI import on Zen Cart 1.5.5f. resolved all the errors and even brought to (somewhat) new standard on installing the plug-ins. I will try to find time to package it and upload it to the Plug in page in the coming weeks.

Hi Techiant,

Sorry for replying to this old post.
Would you be able to share your updated package?

Hi all,

After being proprietary from 2007-2021, I am making the last version of QBI, v3.93 (February 2021), available to the community under the GPL license. It has had huge improvements since the earlier versions posted here previously. QBI now installs in its own directory, has its own UI, and accesses the ZC database directly. A comprehensive 72 page user manual with installation instructions is included. I am no longer interested in maintaining or supporting it. This version was tested with PHP 7.4, MySQL 5.6 / MariaDB 10.1 and ZC 1.57, and may need updates to use with later versions. -- Adam

I still use v3.2.1 on ZC 1.5.8 now.
Thank you!

Thanks for doing this, Adam, and good luck in your future endeavors.

Windows Defender has detected a threat: Trojan:Script/Wacatac.B!ml
Is it a false alarm?

siliconbug:

Hi Techiant,

Sorry for replying to this old post.
Would you be able to share your updated package?

You are awesome for doing that, Adam!
Thank you!

siliconbug:

Windows Defender has detected a threat: Trojan:Script/Wacatac.B!ml
Is it a false alarm?

I just scanned it and no issues found.
Sounds like you may have an existing virus in your Downloads folder. I would scan your PC thoroughly.