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 [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ää: 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

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

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ä
(228 arvostelua)
7.3
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ä
(77 arvostelua)
6.7
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ä
(36 arvostelua)
6.9
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ä
(122 arvostelua)
6.4
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ä
(15 arvostelua)
5.5
€750 EUR 5 päivässä
(21 arvostelua)
5.4
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ä
(15 arvostelua)
4.9
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ä
(7 arvostelua)
5.1
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ä
(11 arvostelua)
4.8
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
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
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ä
(3 arvostelua)
3.8
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ä
(20 arvostelua)
4.0
€822 EUR 20 päivässä
(4 arvostelua)
2.8
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ä
(2 arvostelua)
2.1
€1111 EUR 6 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
RubyOnRail

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project Lisää

€1666 EUR 20 päivässä
(0 arvostelua)
0.0
HDDevelopment

dear my friend , i have experience working with vb.net and database

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