Post by Karonia69 » Fri Apr 30, 2021 8:32 pm

Hi,
Just wondered if anyone knows of a way / module that would allow reports to be run and the results emailed to a user.
Would ideally prefer to use SQL remotely to get the same data, but just can't access it via MySQl Workbench.

TIA

New member

Posts

Joined
Thu May 17, 2018 4:09 pm

Post by straightlight » Fri Apr 30, 2021 10:49 pm

Karonia69 wrote:
Fri Apr 30, 2021 8:32 pm
Hi,
Just wondered if anyone knows of a way / module that would allow reports to be run and the results emailed to a user.
Would ideally prefer to use SQL remotely to get the same data, but just can't access it via MySQl Workbench.

TIA
With the use of an extension from the Marketplace. If no extensions suits your needs regarding this request, you could always create a new service request in the Commercial Support section of the forum. As for the remote SQL to gather the data, I would not suggest this solution with the exception of the PDO library loaded on the same domain.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by rjcalifornia » Sat May 01, 2021 3:37 am

Karonia69 wrote:
Fri Apr 30, 2021 8:32 pm
Hi,
Just wondered if anyone knows of a way / module that would allow reports to be run and the results emailed to a user.
Would ideally prefer to use SQL remotely to get the same data, but just can't access it via MySQl Workbench.

TIA
As suggested above, the marketplace has extensions for that, and you can contact the developer if you need something very specific:

https://www.opencart.com/index.php?rout ... n_id=25645

Image


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by paulfeakins » Tue May 04, 2021 7:47 pm

Karonia69 wrote:
Fri Apr 30, 2021 8:32 pm
Just wondered if anyone knows of a way / module that would allow reports to be run and the results emailed to a user.
Would ideally prefer to use SQL remotely to get the same data, but just can't access it via MySQl Workbench.
If you can't find an extension, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Guru Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom
Who is online

Users browsing this forum: No registered users and 30 guests