Peruttu

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

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ää: parts designs packaging machinery, designs packaging kids food products for france 2015, designs packaging for tobacco, designs packaging, a variety of designs packaging food bags, trend designs packaging, structural package designs packaging folding, free tattoo designs to print, who designs packaging for products, photo editing artistic designs reproduction print, print create pdf, vbscript ftp upload multiple files, vbscript upload multiple files ftp, vbscript upload multiple files, download upload database, download upload 100mb files, bread designs packaging, 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, invitation designs zebra print, upload csv files database php, can upload multi files time mysql database joomla

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

Projektin tunnus: #13115017

22 freelanceria on tarjonnut keskimäärin 1063 € tähän työhön

srinichal

I am an expert in delivering. custom software's and look forward to discuss further about the project

833 € EUR 8 päivässä
(72 arvostelua)
6.7
mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Lisää

1187 € EUR 6 päivässä
(131 arvostelua)
6.8
flashsaiful

I have reasonable experience in IBM SPSS and R Programming Language,with specialization in examining user data/big data and formulating statistical analysis and business strategies. Dataentry; Database; Data proc Lisää

1250 € EUR 20 päivässä
(109 arvostelua)
6.3
crawlermonkey

Hello, I have gone through your requirement of developing VBSCRIPT to download files and IMPORT it into your DATABASE. I am EXPERT in building scraping tools so I can SURELY work on your project. You will love to Lisää

1250 € EUR 20 päivässä
(5 arvostelua)
4.5
750 € EUR 5 päivässä
(9 arvostelua)
4.4
acronymsolutions

Hi, I am 18+ years experienced Database Programmer at CMMI-5 level company. I have 12 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onwards. D Lisää

1250 € EUR 20 päivässä
(8 arvostelua)
4.4
langlangFan

** DO YOUR PROJECT FREE ** if this project improves my experience and you want long term relationship. Hello. Thanks for your job posting! I'm happy to bid on this project and have a relationship with you. I under Lisää

1250 € EUR 20 päivässä
(3 arvostelua)
4.0
kolosibalint

Üdv, Amennyiben egy Excel alapú alkalmazás is megfelelne a célnak, szívesen lefejleszteném. Nincs olyan része a feladatnak, amit VBA-val ne lehetne megoldani, XML-t kezelni pedig ideális megoldás. Van tapasztala Lisää

750 € EUR 10 päivässä
(4 arvostelua)
3.9
axiomswb

I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

944 € EUR 3 päivässä
(4 arvostelua)
3.9
sandroshubladze

Hello, I am Professional VB Developer and pretty experienced in web scraping I can provide excellent result just as you need So, If interested, contact me Thanks & Regards

850 € EUR 15 päivässä
(6 arvostelua)
3.3
iticus

Hello, I have experience performing each of these tasks; however my programming language of choice is Python. If using Python is acceptable for you I would be happy to work with you. Best wishes, iticus

800 € EUR 8 päivässä
(2 arvostelua)
3.2
822 € EUR 20 päivässä
(1 arvostelu)
1.9
BeautiCG

Hi,dear. Thank you for your interest. I have just checked your project report,I am able to perform this task with my developer team.I look forward to your proposal...

1250 € EUR 4 päivässä
(2 arvostelua)
0.8
1111 € EUR 6 päivässä
(0 arvostelua)
0.0
DavidLindon

This should be fairly straight forward so your project budget is quite generous. Are you ok with the dictionary being in the same oracle schema? C#.net is easier so I can offer you a discount if you are happy to take C Lisää

750 € EUR 20 päivässä
(0 arvostelua)
0.0
EmorphisIoT

Dear Hiring Manager, Thanks for looking at my proposal. My technical summary: - HTML/DHTML/HTML 5, ASP.NET1.1/.NET2.0/4.0, MVC 3/4/4 with Razor, DNN, Entity Framework 3.5/4, LINQ, WCF, javascript/jQuery/toolk Lisää

1250 € EUR 20 päivässä
(0 arvostelua)
0.0
bisprojects

Hello! We can create a VBScript! We are a leading Russian team for IT outsourcing, having 8 years experience in working with different IT task, including yours. We are not freelancers, so we guarantee you quality. We'r Lisää

1250 € EUR 10 päivässä
(1 arvostelu)
0.0
TanzeelAhmed

I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE, JUST TO PROVE MY SELF TO U AND ALSO GET EXCELLENT REVIEWS FROM U, AFTER YOU AWARD ME JOB AND CREATE INITIAL MILESTONE F Lisää

1000 € EUR 15 päivässä
(1 arvostelu)
0.0
amfesh

We have 12 Years Experienced in PHP, HTML, CSS, MySQL, Wordpress, Apache, Server .Net ( C# and Vb.Net ) Android & IOS etc am really good at fixing errors and bugs. I always think outside the box to provide the best Lisää

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

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, Java, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, json Lisää

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