bascript to import CSV and XML electric data into a MySQL DB
$30-250 USD
Selesai
Dibuat sekitar 12 tahun yang lalu
$30-250 USD
Dibayar ketika dikirim
I have a script that downloads data from the electric company. I need a similar script that downloads data from individual MTUs using wget and then parses out that XML and populates a MySQL database.
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.
Python would make this job very simple. I have much experience with XML parsing and MySQL databases, so this will be a simple project. You pay nothing until you are 100% happy. Thanks
i have some exprience working with csv, xml and mysql, one of my previous projects is download csv files from ftp servers and loading into mysql after parsing it, i think it's similar with u need.
Project Plan 1. Create a shell script to download the data using wget. The fileshare where the data will be available has to be known. 2. Create a PHP web interface that will integrate the above script. Given the data file name the file has to be automatically downloaded in the file system 3. Once the data is ready there is another script which integrates with MYSQL database and uploads the data to the table in XML format. 4. If the data has to be converted to XML format then that can also be done using python XML libraries. At each stage the script and the interface will be tested properly using various test cases.