Käynnissä

Write a simple VBScript to download some files and upload them into a database -- 2

The project goal is develop a VBScript which downloads certain (XML) files from [url removed, login to view] through Entsoe’s API ([url removed, login to view]). The files should be then processed and uploaded to an Oracle database via ODBC interface.

The project steps are:

#1 - Download the specified files (the URLs are listed with parameters in Oracle – example code is available)

#2 - Move (or some case unzip) the files into a temporary folder

#3 - Read from the temp folder each and every file and process the XML tree

#4 - Upload the XML elements and it’s values into an Oracle table via ODBC

There isn’t an exact match between the target Oracle table and the source XML. Some of the XML elements are excluded, and some has different names – the script should use a dictionary table (which also have to be designed under the project scope) to assign the XML elements to the table fields.

The coding should meet the following criteria

> The coding should be clean, easy to understand and well structured

> Each function should have a comment section in its header, describing its parameters and the output

> There should be a debug option in the code (a constant) where the XML files aren’t uploaded into Oracle, but converted into XLS files (the XML tree in this case is simply just flattened out).

> The code should be general in terms of:

.. The files / URLs to download can be changed

.. The dictionary table should be easily editable (via SQL)

Taidot: Shell Script, VB.NET, Tietojen kaavinta verkosta, Windows Desktop

Näytä lisää: vbscript upload multiple files, download upload database, download upload 100mb files, upload multiple files vbscript, vbscript write sql database

About the Employer:
( 1 review ) Budapest, Hungary

Projektin tunnus: #13177019

Myönnetty käyttäjälle:

400 € EUR 7 päivässä
(50 arvostelua)
5.8

3 freelanceria on tarjonnut keskimäärin 522 € tähän työhön

asin1987

Dear Employer, I will scrape all the data for you using C#, Python, PHP, Nodejs, VBA, imacros etc. I have scrapped data and images from following website as well as APIs. I know how to bypass Captchas and how to Lisää

666 € EUR 10 päivässä
(2 arvostelua)
3.2
amitdollop

Hello, I have reviewed the requirement and I am ready to work for you as according to your need, Ready to start the work immediate on project. Awaiting for your positive response. Thanks !

500 € EUR 10 päivässä
(0 arvostelua)
0.0