Quickbooks Import QBI Support Thread

[wolfderby]

so after reading more into the database abstraction I'm convinced I need to go this bindVars route... so I'm trying this...

	function find_country_id($country_name) {
		$country_id=0;
		$sql="SELECT countries_id FROM ".TABLE_COUNTRIES." WHERE countries_name LIKE :country_name";
		$sql = $db->bindVars($sql, ':country_name', $country_name, 'string');
		$result = $db->Execute($sql);
		$country_id = $result->fields['countries_id']; 
		//$result=$this->db->query($sql);
		//if ($row=$result->fetch()) $country_id=$row['countries_id'];
		return($country_id);
	}

but it results in...

[08-Jan-2018 22:01:16 America/New_York] PHP Fatal error: Call to a member function bindVars() on a non-object in

[mc12345678]

so after reading more into the database abstraction I'm convinced I need to go this bindVars route... so I'm trying this...

	function find_country_id($country_name) {
		$country_id=0;
		$sql="SELECT countries_id FROM ".TABLE_COUNTRIES." WHERE countries_name LIKE :country_name";
		$sql = $db->bindVars($sql, ':country_name', $country_name, 'string');
		$result = $db->Execute($sql);
		$country_id = $result->fields['countries_id']; 
		//$result=$this->db->query($sql);
		//if ($row=$result->fetch()) $country_id=$row['countries_id'];
		return($country_id);
	}

but it results in...

[08-Jan-2018 22:01:16 America/New_York] PHP Fatal error: Call to a member function bindVars() on a non-object in

I don't know if the following is cruel or just enough of a carrot. So, considering the things that have been made available to the function, is there anything in that line that seems undefined? Think beyond what is in the line as something you know/expect.

Now again, regarding the use of mysql_/mysqli_ related functions, these are typically abstracted in the ZC code so that a "common" function name can be used through all versions of ZC and the software still work. A concern I have whether valid or not, is that it appears that the software is written to take a sort of snapshot of the database and hold it in time while processing, as compared to constantly using the data of the current database. While it may not be so important in this particular function of whether to use the class' internal $db or the one that is used throughout the ZC software, there may be instances where an operation is performed on the internal $db in one function the results of which are pulled from another with the expectation that the internal $db data hasn't been modified between the two operations.

It's not something that I necessarily expect, but considering how the internal $db was assigned at one point or another, it seems possible to use it that way and therefore would consider continuing to use in the same way but through migration to the functions available in the database's class.

[wolfderby]

I don't know if the following is cruel or just enough of a carrot. So, considering the things that have been made available to the function, is there anything in that line that seems undefined? Think beyond what is in the line as something you know/expect.

Now again, regarding the use of mysql_/mysqli_ related functions, these are typically abstracted in the ZC code so that a "common" function name can be used through all versions of ZC and the software still work. A concern I have whether valid or not, is that it appears that the software is written to take a sort of snapshot of the database and hold it in time while processing, as compared to constantly using the data of the current database. While it may not be so important in this particular function of whether to use the class' internal $db or the one that is used throughout the ZC software, there may be instances where an operation is performed on the internal $db in one function the results of which are pulled from another with the expectation that the internal $db data hasn't been modified between the two operations.

It's not something that I necessarily expect, but considering how the internal $db was assigned at one point or another, it seems possible to use it that way and therefore would consider continuing to use in the same way but through migration to the functions available in the database's class.

Just enough of a carrot, thanks!

added global $db and it seems to be working for at least 1 new order.

attempting to dl 7206 orders internal server error 500'd but that's probably just my hosting, might attempt to add order range constraints.

[wolfderby]

...seems to be work so far, I'm going to do a bit more testing before uploading the latest version. Thanks.

[wolfderby]

So basically I got it sort of working, :/ . But it's probably not use-able. I did these rounding error mods (https://www.zen-cart.com/showthread....GST-VAT/page2) a while back, that I think back-fired w/ the QB import, because it kept throwing an error on import into QB 2016 (The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form.) Then I'd also end up w/ an "error on line XX: can't record invalid transaction error"

I compared the iif w/ qb's latest example but I probably need to dig back further for something to match better.

Long story short I jammed most of my 2017 transactions into a backed up QB company file only to have most of the data look good until I attempted to open the account register within QB and it would just error and crash QB.

If anyone's interested in what I have or thinks I should upload it as it's probably "better" than what I last uploaded let me know. I think I'm bailing on this in the meantime.

[mc12345678]

So basically I got it sort of working, :/ . But it's probably not use-able. I did these rounding error mods (https://www.zen-cart.com/showthread....GST-VAT/page2) a while back, that I think back-fired w/ the QB import, because it kept throwing an error on import into QB 2016 (The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form.) Then I'd also end up w/ an "error on line XX: can't record invalid transaction error"

I compared the iif w/ qb's latest example but I probably need to dig back further for something to match better.

Long story short I jammed most of my 2017 transactions into a backed up QB company file only to have most of the data look good until I attempted to open the account register within QB and it would just error and crash QB.

If anyone's interested in what I have or thinks I should upload it as it's probably "better" than what I last uploaded let me know. I think I'm bailing on this in the meantime.

I say go for the upload, sure identify that there are issues, but at least having before and after code, perhaps something can be identified.

I mean, no real reason for someone else to start from scratch again if all the work has been done. My only "concern" is that way back when there was some other "tool" that had to be obtained in order to communicate with QB. Is that either included in the fileset or an improved reference about where/how to accomplish that part of the communication addressed? I spent days searching for that other software and ended up in some sort of loop where one page referenced another and then click here and just kept going. Couldn't find anything "official" about what the status of that software was...

[dvtalk]

Hi,

So I have been using this plug-in since ver 3.21 (quite a bit customized for my needs). I am in the process of rebuilding the old ZC site with new 1.5.5f and I simply must have QBI.
I am about to install what you have on my test server and will be happy to collaborate. I was just wondering if you have made any progress since Januiary and what is it that is causing you problems.

I personally use it to export Invoices (as opposed to Sales Order) and I am quite familiar with qbi format (the old enemy), its pitfalls and even use it to output custom qbi from paypal raw data (mostly for fees/payments). Hope we can help each other.

[lankeeyankee]

Can this map an item with attributes to a specific item in QB? I am currently using T-Hub but they jacked the price from $350/year to over $1200/year. The thing about T-Hub was that I was able to modify the PHP connector code that resides in ZC admin to be able to map items with attributes to specific items in QB which is a critical function for me. I would be interested in helping develop this if this feature is possible/available.

[adam5532]

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

[siliconbug]

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