Devam Ediyor

Get Data from Website with Login to Excel

I'm a music teacher and my students use a website called "EarZ", where they practice their music theory and hearing skills. The website hast some possibilities to show me the results of my students using filters like date, class or exercise. I can manually copy the stuff from the page into an excel sheet and the columns and rows are luckily the same. In Excel I can use my own filters or add some extra information on an extra column to see, how my students are progressing (or not...)

Unfortunately I haven't been able to login succesfully through the "Get data from web"-Function in my (Windows) Excel-Sheet. The website developers told me that

"The login system is not designed for that. You log in by POSTING a username, password and a unique one-time token to a login URL. If that is successful, a session is started and a cookie is created, keeping you logged in." But they're not completely sure if Excel can handle that or not. So I'll give it a try with an Excel professional on freelancer.

First Milestone: Login through Excel to the website to gather data.

Second Milestone: Write script to automatize regular checks every day (or manually with a macro-button) and collect different databases (depending on the exercise, the URL for the results summary vary). Add columns with the game's name (title's only in the select box, not in the table itself) and the exact time of collecting data with the sheet.

The website domain for the teacher backend is [login to view URL], login is simply an email and a personal password. You can create a demo account for free for one week: [login to view URL]

Beceriler: Excel, PHP, Veri Girişi, Veri İşleme, Web Scraping

Daha fazlasını gör: getafreelancercom extract data website excel sheet, read data website excel, extracting data website excel sheet, load data website excel, script cut paste data website excel, copy data website excel, copy web page excel, copy data website excel vba login, vba code copy web page excel, excel macro to get data from website, excel vba get data from website, get data from website that requires a login excel, get data from website that requires a login, php login to remote website and get data, vba login to website and get data, excel get data from web with login, get data from website that requires a login python

İşveren Hakkında:
( 1 değerlendirme ) Brugg, Switzerland

Proje NO: #31591256

Seçilen:

cqrnebula

Hallo Ich bin System Engineer aus dem Kanton Freiburg und biete hier hie und da auf kleinere Projekte, damit ich meine Progammierskills verbessern kann. Ich kenne die Plattform nicht und in den offiziellen Handbücher Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 20 freelancer ortalamada $37 teklif veriyor

mantislin

Hi sir, This is Lin and I am scraping expert, I scraped 500+ websites, please check my reviews then you will know. I will create scraping tool with PHP & CURL that extracts all requested data, And provides data in th Daha Fazla

$200 USD in 3 gün içinde
(517 Değerlendirme)
8.1
(66 Değerlendirme)
5.7
suvashdev475

Greetings, I think you are looking for someone for your project who expert in Get Data from Website with Login to Excel we can discuss more about the work? First of all, I'll provide you a demo file of the work. So, p Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(59 Değerlendirme)
5.7
Lagripe

Hi. I am a freelancer working in 24/7 service. I have much experience of +6 years in Scraping field, I can do your job with Python. I will produce the output in any format you desire. I think this project is for me and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
4.6
tonikurochkinpro

Dear, client. Hope you are doing very well. I have read your requirements and I am confident I can do it perfectly. Can you share more details with me? These are my skills: - Ruby on Rails - HTML5, CSS/SCSS, Bootstrap Daha Fazla

$20 USD in 7 gün içinde
(2 Değerlendirme)
3.4
jinhui12

Hi Sir, This is Lan and I am an automated process expert. I can provide UiPath solutions , use UiPath to create automated processes to complete this process. Thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
3.2
rashidmalick731

Hi I would love to help you to create a website for your new business and Provide you Easy to Navigate ➕ Easy to manage ➕ 100% compatible for Mobile and Desktop ➕ Conversion Focused ➕ Modern and UNIQUE design. Why Daha Fazla

$10 USD in 4 gün içinde
(2 Değerlendirme)
2.0
deependras251097

Hi there...this is Deependra. I have completed my graduation and post graduation from Banaras Hindu University in statistics. So the area of my expertise is data handling and I have got much expertise (5 years) in hand Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
suhanighorai1306

i am data entry operator... i will never let you down regarding my work.. and i will complete it as soon as possible.. i have also completed basic degree on computer and also very much knowledge about computer and ot Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
(0 Değerlendirme)
0.0
assdrew94

I can handle this job perfectly as i have good experience of Excel Data Entry type work because I already have worked this before . and lemme assured you that I'll do this ASAP and i won't let you down.

$15 USD in 5 gün içinde
(0 Değerlendirme)
0.0
Kristianinpoika

Hello! I can provide you full support for this project. I have high experience with web technologies and I am pretty sure I can help you. Feel free to contact me!

$75 USD in 7 gün içinde
(0 Değerlendirme)
0.0
alex369

Hi , I can do this module as web scraping and lets discuss further details to proceed on this project if you are interested

$10 USD in 7 gün içinde
(0 Değerlendirme)
0.0
yadav316

There are a few details you can include to give your bid the best chance of success. We'll look at some well-written bids as an example. I do data entry in excel

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
omkumarmukhi

My skill set is a perfect match for the job requirements. In particular, my typing skills and managerial experience make me an ideal candidate for the position.

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
fwfchandan777

Hi, I can do project Professionally . I believe I can do a great work for you and ensure your quality.

$25 USD in 7 gün içinde
(0 Değerlendirme)
0.0
Zenemy

Hi , I will summarize all the lectures and provide you with clear, concise notes. I have worked on several similar projects compiling presentation slides and lecture notes into a single set of notes, and can deliver qu Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
tarunsahare65

Mujhe sb aata hai mai kar lunga kaam ek baar de ke toh dekho nahi hua toh mai apna kaam band kar dunga ye mai dil se bol raha hu apka kaam apke waqt me mil jayega

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
alihusnain41

My First goal is be honest and satisfy my clients. And the 2nd is I assure you to complete work in time.

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0