- Posts: 205
- Thank you received: 0
- Community Forum
- Appointment Booking Pro - Retired, no longer for sale or supported.
- ABPro 4.0.x
- can you share the Export/CSV query?
can you share the Export/CSV query?
- Steve Klund
-
Topic Author
- Offline
- Gold Boarder
-
- Technology is our friend
Less
More
1 year 3 weeks ago #26778
by Steve Klund
can you share the Export/CSV query? was created by Steve Klund
Hello.
I am trying to export csv's of appointment data (see pic). However, there apparently is a limit via apache / php. I cannot pull the amount of data I need to view unless I export in multiple sections. So, my question is, can you point me to the backend sql script that is executed when clicking the "Export/CSV" button (on any admin page)? I'd like to use that as base to build a number of queries that target specific items and handle the amount of records needed (will use phpadmin or MySql Workbench to execute queries.
Thank you
I am trying to export csv's of appointment data (see pic). However, there apparently is a limit via apache / php. I cannot pull the amount of data I need to view unless I export in multiple sections. So, my question is, can you point me to the backend sql script that is executed when clicking the "Export/CSV" button (on any admin page)? I'd like to use that as base to build a number of queries that target specific items and handle the amount of records needed (will use phpadmin or MySql Workbench to execute queries.
Thank you
Attachments:
Please Log in to join the conversation.
- Rob
-
- Offline
- Administrator
-
Less
More
- Posts: 4775
- Karma: 103
- Thank you received: 672
1 year 3 weeks ago #26779
by Rob
Replied by Rob on topic can you share the Export/CSV query?
There are no limits in the export, other than, it will only export the bookings you select.
The export is a rather complex combination of SQL and procedural data merging to support all the different tables involved (bookings, udfs, seat, etc.)
The code can be found in file:
\administrator\components\com_rsappt_pro3\controllers
function:
export_to_csv()
The export is a rather complex combination of SQL and procedural data merging to support all the different tables involved (bookings, udfs, seat, etc.)
The code can be found in file:
\administrator\components\com_rsappt_pro3\controllers
function:
export_to_csv()
The following user(s) said Thank You: Steve Klund
Please Log in to join the conversation.
- Steve Klund
-
Topic Author
- Offline
- Gold Boarder
-
- Technology is our friend
Less
More
- Posts: 205
- Thank you received: 0
1 year 3 weeks ago #26780
by Steve Klund
Replied by Steve Klund on topic can you share the Export/CSV query?
I cannot find a file named 'controllers'. Looked in /administrator/... as well as /html/components/.....
Please Log in to join the conversation.
- Rob
-
- Offline
- Administrator
-
Less
More
- Posts: 4775
- Karma: 103
- Thank you received: 672
1 year 3 weeks ago #26781
by Rob
Replied by Rob on topic can you share the Export/CSV query?
Sorry, controllers is the folder, the file is requests.php
Please Log in to join the conversation.
- Steve Klund
-
Topic Author
- Offline
- Gold Boarder
-
- Technology is our friend
Less
More
- Posts: 205
- Thank you received: 0
10 months 3 weeks ago #26802
by Steve Klund
Replied by Steve Klund on topic can you share the Export/CSV query?
Sorry for the late response. Apparently there is a 1000 row block from within Joomla. I wrote a query and am getting the complete data query via phpmyadmin. Seemed easier for me to do that way than exploring why there was a cap on results.
Thanks again!
Thanks again!
Please Log in to join the conversation.
- Community Forum
- Appointment Booking Pro - Retired, no longer for sale or supported.
- ABPro 4.0.x
- can you share the Export/CSV query?
Time to create page: 0.118 seconds