Automatic EBP export to xls or mysql file
PetiteFee38
Posted messages
5
Status
Member
-
PetiteFee38 Posted messages 5 Status Member -
PetiteFee38 Posted messages 5 Status Member -
Hello,
The EBP software allows exporting databases to Excel files by clicking a button in EBP.
I would like to know if it is possible to automate this action.
In detail: I want to create a satisfaction questionnaire for a client using EBP,
my idea is to avoid double data entry on my own interface, and thus synchronize, for example every evening, his client database with my database containing the clients who will respond to the survey.
To do this, it would be necessary for the xls file to be automatically copied to my server every x time (every evening in my example).
Then my code would retrieve this file and update my database.
Is this possible? Is there an API or interface that allows me to automate this process?
Thank you for your insights,
E.
Configuration: Windows / Firefox 58.0
The EBP software allows exporting databases to Excel files by clicking a button in EBP.
I would like to know if it is possible to automate this action.
In detail: I want to create a satisfaction questionnaire for a client using EBP,
my idea is to avoid double data entry on my own interface, and thus synchronize, for example every evening, his client database with my database containing the clients who will respond to the survey.
To do this, it would be necessary for the xls file to be automatically copied to my server every x time (every evening in my example).
Then my code would retrieve this file and update my database.
Is this possible? Is there an API or interface that allows me to automate this process?
Thank you for your insights,
E.
Configuration: Windows / Firefox 58.0
2 answers
Hello,
Step 1: Choose a programming language
Step 2: Write the script that performs the desired action
Step 3: Schedule it via your OS's "scheduled tasks" (cron on Linux, Task Scheduler on Windows) (or use a scheduling software… but just for a script, it's not worth paying for...)
--
Best regards,
Jordane
Step 1: Choose a programming language
Step 2: Write the script that performs the desired action
Step 3: Schedule it via your OS's "scheduled tasks" (cron on Linux, Task Scheduler on Windows) (or use a scheduling software… but just for a script, it's not worth paying for...)
--
Best regards,
Jordane
No, I don't have access because I don't know EPB and I don't know if it's possible to get access. I'm currently preparing a quote for the client, so I was hoping to find answers here.
I called EPB, but without the license number, they don't want to respond.
I'll consult my client, ask them for their license number, or go see how it works at their place.
Thank you for your help, anyway,
E.
I called EPB, but without the license number, they don't want to respond.
I'll consult my client, ask them for their license number, or go see how it works at their place.
Thank you for your help, anyway,
E.
Actually, your answer is a bit vague :o)
I program in PHP, my database will be located on a shared OVH server, in PHP/MySQL.
I know how to schedule a task on the server; I already back up the databases of my websites this way every evening.
What I’m missing is "how to access the EBP database to generate the XLS file and copy it to my server?".
Thanks again for your help,
E.
Have you checked if there is any documentation available for the EPB software explaining the possible existence of a WebService that allows you to extract the data?
You're asking your question in the MySQL forum... but I have the impression that these are more questions concerning the functioning of the EPB application...