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.

Dedication and passion goes to those who are able to push and merge a project.

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
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo


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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

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

Users browsing this forum: Semrush [Bot], Shiftcom and 410 guests