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 [login to view URL] through Entsoe’s API ([login to view URL]). 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 ftp upload multiple files, vbscript upload multiple files ftp, vbscript upload multiple files, download upload database, download upload 100mb files, upload multiple files vbscript, upload files jsp simple progress bar, php upload csv files save database code, data outsourcing projest download simple files, aspnet ajax upload multiple files download, upload csv files database php, can upload multi files time mysql database joomla, vbscript write sql database, simple vbscript update access database

Tietoa työnantajasta:
( 1 arvostelu ) Budapest, Hungary

Projektin tunnus: #13177019

Myönnetty käyttäjälle:

€400 EUR 7 päivässä
(65 Arvostelua)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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ä
(73 arvostelua)