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

Đã Hủy

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 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

Mã Dự Án: #13115017

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

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
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
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
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
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
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
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
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
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
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
€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
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
JNickSoftware

I am a long time .NET developer and I have recently decided to do only freelance and consultant work. I am very experienced with SQL Server, the .NET Framework, MVC, C#, VB.Net, ASP.Net, as well as many other technolog Thêm

€1388 EUR trong 20 ngày
(0 Đánh Giá)
0.0
HDDevelopment

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

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

€1666 EUR trong 20 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
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
Rainfall15

Hello, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We're a team of highly experienced Shopify/ Magento / Opencart/ Wordpress/ WooCommerce /PHP/ Thêm

€833 EUR trong 20 ngày
(0 Đánh Giá)
0.0