I just wanted to ask if you no a way to upload within existing tables (MySQL as source) a csv files (from the frontend) to batch update or create new entries?
As a workaround, we're thinking about:
A form with an upload field Zapier >> formatter to parse data Zapier >> Update the DB
It would probably work (not bulletproof, though), but you may have a better idea or solution...
Thank you for your feedback Greetings from Berlin Best, Gui
The only way i know possible to update an existing MySQL table in the database using CSV,
are two options:
1. Edit the table in Excel-like editor, where you can select a range of cells from an Excel file (you can open the CSV file in Excel, and select only the new data you want to add), copy them and paste them in the last row of the Excel-Like editor, and that will paste all selected cells in the table.
2. Save the new data you want to add (without headers) as a separate CSV file, go to the database and find the database table. Access it, and go to "Import" tab, where you can import that new CSV file, and update the database table in this way.
Our developers will be working on this in the future, but I have no ETA as to when it will be implemented in the plugin
-
But from the front-end, in the way that you described, i can see what you mean, but this kind of method is above my field of expertise, so i will have to check this with senior colleagues from our 2nd level.
As soon as they advise, i will come back to you straight away.
But, unfortunately, we are not able to assist with this solution, we were only able to advise with an example, since it is not covered within our support.
I hope you will be able to find a working solution. Thank you very much for your patience.
Let us know if you have any other questions. Thanks.
thank you VERY much for your answer and making the effort to check further for a solution. I really appreciate it :-)
Ok, no problem! The "python solution" is interesting, we will definitely check that. In the meanwhile, we managed to reach what we wanted like this.
1. Upload form on our website to drop a CSV 2. CSV file is send to a great tool called EasyCSV which parse the CSV data and send them to a webhook from make.com (Intergromat) 3. Intergromat creates or updates rows in our DB
Hey there,
I just wanted to ask if you no a way to upload within existing tables (MySQL as source) a csv files (from the frontend) to batch update or create new entries?
As a workaround, we're thinking about:
A form with an upload field
Zapier >> formatter to parse data
Zapier >> Update the DB
It would probably work (not bulletproof, though), but you may have a better idea or solution...
Thank you for your feedback
Greetings from Berlin
Best,
Gui
Hi, Guillaume
Thanks for reaching out to us
-
The only way i know possible to update an existing MySQL table in the database using CSV,
are two options:
1. Edit the table in Excel-like editor, where you can select a range of cells from an Excel file (you can open the CSV file in Excel, and select only the new data you want to add), copy them and paste them in the last row of the Excel-Like editor, and that will paste all selected cells in the table.
2. Save the new data you want to add (without headers) as a separate CSV file, go to the database and find the database table. Access it, and go to "Import" tab, where you can import that new CSV file, and update the database table in this way.
Our developers will be working on this in the future, but I have no ETA as to when it will be implemented in the plugin
-But from the front-end, in the way that you described, i can see what you mean, but this kind of method is above my field of expertise, so i will have to check this with senior colleagues from our 2nd level.
As soon as they advise, i will come back to you straight away.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Guillaume
Firstly i apologise for so much time that passed.
In the meantime, i did my best to confirm additionally, just to follow up on this.
-
This will be possible, but not through our plugin. This is a custom solution that is done outside our wpDataTables.
Here is an example.
But, unfortunately, we are not able to assist with this solution, we were only able to advise with an example, since it is not covered within our support.
I hope you will be able to find a working solution. Thank you very much for your patience.
Let us know if you have any other questions. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Dear Miloš,
thank you VERY much for your answer and making the effort to check further for a solution. I really appreciate it :-)
Ok, no problem! The "python solution" is interesting, we will definitely check that.
In the meanwhile, we managed to reach what we wanted like this.
1. Upload form on our website to drop a CSV
2. CSV file is send to a great tool called EasyCSV which parse the CSV data and send them to a webhook from make.com (Intergromat)
3. Intergromat creates or updates rows in our DB
Et voilà, the circle is complete ;-)
Greetins from Berlin
Gui
Hey, Guillaume
You're welcome, my senior colleagues helped me search for that example.
Well, i have to say the solution you came up with is very elegant! Awesome
I will pass this to colleagues, we will make a note of it, it might help other users for the future! Thank you so much,
and please don't hesitate to reach out if you have any questions or if anything else happens that we might try to assist with.
Best regards!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank Miloš!
Keep up the good work :-)
Hey, Guillaume
You're welcome.
As we said, please don't hesitate to reach out if you have any questions or if anything else happens that we might try to assist with.
Best regards
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables