Find Jobs
Hire Freelancers

Create a VB Excel Script for pulling OMDBAPI metadata

$10-30 USD

Imekamilika
Imechapishwa over 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa
I have an Excel spreadsheet with a list of movies and tv shows. I have a script that will connect to [login to view URL] and pull meta information for movies based on the content in Cell A. The problem is, the script is unable to pull metadata for TV shows, and it also has some trouble with the titles and sometimes does not recognize it if the text isn't perfect. Here is a sample of some of the titles. 28 Weeks Later 2 Guns 2013 30,000 Leagues Under The Sea 2007 300[2006] 300 Rise of an Empire 2014 30 Minutes Or Less 2011 30 Rock S01E01 Pilot 30 Rock S01E02 The Aftermath What I need is the script modified so that it IF the title contains season and episode information it instead searches omdbapi using that information transposed from the title into something omdbapi can recognize. I don't know the syntax but it would logically be something like: IF title contains "s##*e##" then use "t=%s&season=%s&episode=%s" instead of searching by title only. Here is a sample of a way to connect to the omdbapi for episode and season information. "String url = "[login to view URL]"; String charset = "UTF-8"; String title = "Game of Thrones"; String season = "5"; String episode "5"; String query = [login to view URL]("t=%s&season=%s&episode=%s", [login to view URL](title, charset), [login to view URL](season, charset), [login to view URL](episode, charset),); URLConnection connection = new URL(url + "?" + query).openConnection(); [login to view URL]("Accept-Charset", charset); InputStream response = [login to view URL](); // Do some stuff with the data"
Kitambulisho cha mradi: 17999352

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi there, I understood the problem and can come up with an 'elegant' (efficient + simple) solution. Looking forward to your contact, Grunty.
$100 USD ndani ya siku 4
4.8 (46 hakiki)
5.7
5.7
9 wafanyakazi huru wana zabuni kwa wastani $51 USD kwa kazi hii
Picha ya Mtumiaji
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$100 USD ndani ya siku 1
5.0 (709 hakiki)
8.4
8.4
Picha ya Mtumiaji
This is Vibrant Webtech and I was glad to see that you're looking for help for project Create a VB Excel Script for pulling OMDBAPI metadata. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Visual Basic, Web Scraping. Please ping me for more discussion.
$100 USD ndani ya siku 2
4.9 (342 hakiki)
7.9
7.9
Picha ya Mtumiaji
Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards
$50 USD ndani ya siku 3
4.9 (24 hakiki)
4.7
4.7
Picha ya Mtumiaji
"Greetings! According to your stated project description you need an excel exper. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
$10 USD ndani ya siku 1
5.0 (2 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have extensive experience using Excel in my past work. As a Statistics TA that used Excel to manage to manipulate and analyze data, I already have an idea of what needs done. Although it seems that you might have some data cleaning problems, I suspect that something can be done that will at the very least make it easier to fix these problems. I would have to look at the sheet to get a better idea of what can be done.
$30 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have 5 years of experience in excel vba webscraping also i offer you sample of the data.
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Tarpon Springs FL, United States
5.0
2
Njia ya malipo imethibitishwa
Mwanachama tangu Okt 20, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.