HComms
asked on
Upload data from computer to remote webserver/mysql database
Hello
I'm looking for some advice, basically i run a script on many windows based computers that creates an xml file, I would like to know if it's possible to transfer this file to my remote web server that runs apache/php/mysql, basically i want to populate the database with some of the values of the xml file, I ok i think with importing the data when it arrives just unsure on how i would achieve the initial transfer.
Could i use something along the lines of powershell with curl, or would i need to investigate potential learning some programming to achieve this. I have 0 programming knowledge but am willing to learn if this is required.
Obviously there may be several ways to achieve this, looking for possibly the easiest way to do it without learning programming but if that's not possible writing an application would be an option.
Thanks in advance
I'm looking for some advice, basically i run a script on many windows based computers that creates an xml file, I would like to know if it's possible to transfer this file to my remote web server that runs apache/php/mysql, basically i want to populate the database with some of the values of the xml file, I ok i think with importing the data when it arrives just unsure on how i would achieve the initial transfer.
Could i use something along the lines of powershell with curl, or would i need to investigate potential learning some programming to achieve this. I have 0 programming knowledge but am willing to learn if this is required.
Obviously there may be several ways to achieve this, looking for possibly the easiest way to do it without learning programming but if that's not possible writing an application would be an option.
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hmm... curl speaks http but not the mysql protocol.
if you have a web service around, that can handle the xml files, a single curl, wget, or whatever equivalent command might do the trick. if not you'll most likely have to convert the xml first, either directly to sql queries if your sql server is available from your location (which is unlikely if it is in a distant location) or to whatever the available service wants which may be csv, json, or possibly xml but most likely with a different structure...
give us more information regarding your setup, a sample xml, and relevant db structure information
--
a simple xml in which you want to extract a few fields and generate an insert query from, might be quite trivial if the server is available or if it is fed by a decent web service. other cases might require some programming skills
if you have a web service around, that can handle the xml files, a single curl, wget, or whatever equivalent command might do the trick. if not you'll most likely have to convert the xml first, either directly to sql queries if your sql server is available from your location (which is unlikely if it is in a distant location) or to whatever the available service wants which may be csv, json, or possibly xml but most likely with a different structure...
give us more information regarding your setup, a sample xml, and relevant db structure information
--
a simple xml in which you want to extract a few fields and generate an insert query from, might be quite trivial if the server is available or if it is fed by a decent web service. other cases might require some programming skills
@skullnobrains: mysql does speak http, but I'd still probably put a script in between because that's what I'm used to. see http://blog.ulf-wendel.de/2014/mysql-5-7-http-plugin-mysql/
ASKER
Hi guys, apologies i have not gotten back to yous on this, i have had other work commitments, I will follow up the suggestion shortly and let you know my results.
Thanks again for input
Thanks again for input
Hi,
You need to create the ODBC connection to the Database, to upload the Xml file to the database.
You need to create the ODBC connection to the Database, to upload the Xml file to the database.
ASKER