Download to Quickbooks?

[schunard]

Trying to figure out how to fix this:
Fatal error: SQL in .../admin/quickbooks_download_view.php on line 45

And ty for your work on this:)

[confused_aswell]

Hi

This is your table prefix, what are your table prefixes?

Phil

[Tezla]

Trying to figure out how to fix this:
Fatal error: SQL in .../admin/quickbooks_download_view.php on line 45

And ty for your work on this:)

Yes, this is the error you get when your database table prefixes are incorrect. Take another peak at the ReadMe.txt.

In my case, I had no prefix, so I replaced the zen_ on the SQL lines with nothing (stripped them away).

As far as recent work goes, you are welcome. But I'm just trying to "help out around here". Phil deserves most of the credit.

[Vortex12]

Yes, this is the error you get when your database table prefixes are incorrect. Take another peak at the ReadMe.txt.

In my case, I had no prefix, so I replaced the zen_ on the SQL lines with nothing (stripped them away).

As far as recent work goes, you are welcome. But I'm just trying to "help out around here". Phil deserves most of the credit.

Hello all Great scrip its just what ive been looking for, I have been trying to get this script working and also getting this error, i Am a biginner to code, so Im not sure what to do .
Any help would be heaps appreciated
thanks in foreword :)

[confused_aswell]

Hi Vortex

What is the prefix to your database tables - Zen_admin....,Shop_admin... or admin etc? Find out what they are and get back to me. It is a really easy problem to fix.

Phil

[Vortex12]

Sorry about taking so long, Im not sure what you meen by "What is the prefix to your database tables" do you meen my admin in shop name?
Solar-shop/admin/ ?

Ps your help is much appreciated thank you for this great addon :)

[confused_aswell]

Hi

You will need to log on to your phpmyadmin, then click on the database for the zen-cart mine is Zc_1. When you click on the link there will be a lot of tables on the left hand side of the page like this....

zen_address_book
zen_address_format
zen_admin
zen_admin_activity_log
zen_authorizenet
zen_banners
zen_banners_history
zen_categories
zen_categories_description
zen_configuration
zen_configuration_group
zen_counter
zen_counter_history
zen_countries
zen_coupons
zen_coupons_description
zen_coupon_email_track
zen_coupon_gv_customer
zen_coupon_gv_queue
zen_coupon_redeem_track
zen_coupon_restrict
zen_currencies
zen_customers
zen_customers_basket
zen_customers_basket_attributes
zen_customers_info
zen_customers_wishlist
zen_db_cache
zen_email_archive
zen_ezpages
zen_featured
zen_files_uploaded
zen_geo_zones
zen_get_terms_to_filter

As you can see my tables are prefixed with the zen_ whatever your tables are prefixed with is what you need to change according to the read me.txt document.

Any other problems then come back to me.

Thanks for the comment

Phil

[loosefast]

Would it be possible to filter the results by some of the same options available in the Newsletter Options
"All Newsletter Subscribers"
"Dormant Customers"
Active customers"
Active customers in past 3 months
or
by address

This is for import into a 3rd party newsletter service

thanks for the mod!

[kernheimer]

THANK YOU so much, you have no idea how proud i am of myself doing the zen_ thingy and so on. myself...
and how greatfull i am for your module
thank you!!

[littlehawk]

I havent downloaded yet, but i apperciate your effort!!!!!!!!!!!!keep it up, support you