Đã Hủy

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)

Kỹ năng: Shell Script, VB.NET, Web Scraping, Màn hình Windows

Xem thêm: parts designs packaging machinery, designs packaging tobacco, trend designs packaging, free tattoo designs print, designs packaging products, print create pdf, vbscript upload multiple files, download upload database, download upload 100mb files, bread designs packaging, upload multiple files vbscript, invitation designs zebra print, vbscript write sql database, designs packaging boxes

Về Bên Thuê:
( 1 nhận xét ) Budapest, Hungary

Mã Dự Án: #13115017

23 freelancer đang chào giá trung bình €1077 cho công việc này

srinichal

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

€833 EUR trong 8 ngày
(72 Đánh Giá)
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, Thêm

€1187 EUR trong 6 ngày
(131 Đánh Giá)
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 Thêm

€1250 EUR trong 20 ngày
(109 Đánh Giá)
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 Thêm

€1250 EUR trong 20 ngày
(5 Đánh Giá)
4.5
€750 EUR trong 5 ngày
(9 Đánh Giá)
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 Thêm

€1250 EUR trong 20 ngày
(8 Đánh Giá)
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 Thêm

€1250 EUR trong 20 ngày
(3 Đánh Giá)
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 Thêm

€750 EUR trong 10 ngày
(4 Đánh Giá)
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 trong 3 ngày
(4 Đánh Giá)
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 trong 15 ngày
(6 Đánh Giá)
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 trong 8 ngày
(2 Đánh Giá)
3.2
€822 EUR trong 20 ngày
(1 Đánh Giá)
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 trong 4 ngày
(2 Đánh Giá)
0.8
€1111 EUR trong 6 ngày
(0 Đánh Giá)
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 Thêm

€750 EUR trong 20 ngày
(0 Đánh Giá)
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 Thêm

€1250 EUR trong 20 ngày
(0 Đánh Giá)
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 Thêm

€1250 EUR trong 10 ngày
(1 Đánh Giá)
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 Thêm

€1000 EUR trong 15 ngày
(1 Đánh Giá)
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 Thêm

€750 EUR trong 10 ngày
(0 Đánh Giá)
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 Thêm

€1000 EUR trong 10 ngày
(0 Đánh Giá)
0.0