Download Excel Files Using PhantomJS and Python and Import into Azure SQL

$30-250 AUD

Stengt

Lagt ut

nesten 6 år siden

$30-250 AUD

Betalt ved levering

High Level Overview: I have several files that need to be downloaded from 4 different websites. After these files are downloaded they will need to be transformed and loaded into a SQL database hosted on Azure. Details / Requirements: - All 4 of the sites have user names and passwords and you will need to login to them - Some of the files will be in XLS format and other files will be in CSV - I have an M-Script to describe the transformation that's needed before loading the files - Importing into the SQL database: - a new SQL Database will be setup on Azure - some of the files will require tables to be overwritten with new data - other files will be appended to an existing table (where the current date will be included as an extra column) - The process must be fully automated and should be scheduled to run once a week on a wednesday morning - The extraction must be done with python and a headerless / browserless solution such as PhantomJS or equivalent - The solution must be fully contained in Azure

Azure

Python

SQL

Prosjekt-ID: 17259389

Om prosjektet

13 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

13 frilansere byr i gjennomsnitt $214 AUD for denne jobben

@lkhelladi

Hello, I'd be glad to develop the python script for file downloading and parsing . Looking forward to chat with you soon for more details. Best regards,

$388 AUD om 5 dager

5,0

(165 omtaler)

7,3

@schoudhary1553

Hi there..... Warm Greetings We came along with your request for Download Excel Files Using PhantomJS and Python and Import into Azure SQL and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Azure, Python, SQL We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$250 AUD om 3 dager

5,0

(62 omtaler)

6,6

@bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and smart technic with web scraping (1000 over projects for scraping), automation and bot(500 over projects for automation and bot), selenium, mobile (android, ios native and others). Especially, I am an expert in betting project and gambling games and sites(bet365, bwin, pinnacle, betfair...) ,,, shopping auto buyer(adidas, footlocker, eastbay, supreme and etc) So, I can solve the captcha automatically. Please contact me, then we can discuss about the details and the price. And I am free in recent days, so I can do my best for your project. Thanks.

$155 AUD om 3 dager

5,0

(65 omtaler)

6,6

@DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have good experience in python and I am an expert in it. I have all necessary skills required to be a good developer. I am interested in your. Please check my portfolio and reviews. Ping me to discuss in detail. Waiting for you response.

$125 AUD om 2 dager

4,7

(34 omtaler)

5,6

@origami07

Greetings, I have experience with web automation, azure, python and sql. Please see certifications and portfolio. Kind Regards

$177 AUD om 3 dager

4,3

(12 omtaler)

3,8

@shivanimishra19

Hi, I am Shivani and having 9+ years of extensive experience in .Net. My skills are .Net, C#, SQL, MVC, Azure, Dynamics, ANgular JS and many more. I have strong knowledge of Azure. Looking forward to hear from you and a long term association. Thanks, Shivani

$222 AUD om 5 dager

5,0

(1 omtale)

1,9

@vamsikrishna0621

Hi, I have used headless browser with phantomjs to download pdf documents in my past experience. I also have experience in importing data to SQL. just these two have to be connected and I can complete this fast and easily. Ping me to discuss further about those 4 sites and we can get started.

$244 AUD om 2 dager

0,0

(0 omtaler)

0,0

@martintaichman

Hello, I used Azure Data Factory on very similar jobs. Typically, I do this. I combine multiple CSV files using U-SQL (Data Lake Analytic), in which I prepare the data and then load them into Azure SQL to STAGE schema and then run stored procedure which merging data. Everything is running on the Azure Data Factory. Give me please example of your data and I look at that. Thank you so much Kind regards Martin Taichman

$155 AUD om 3 dager