Create a VB Excel Script for pulling OMDBAPI metadata

$10-30 USD

Slutfört

Publicerad

över fem år sedan

$10-30 USD

Betalning vid leverans

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"

Project ID: 17999352

Om projektet

9 anbud

Distansprojekt

Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@Grunty

Hi there, I understood the problem and can come up with an 'elegant' (efficient + simple) solution. Looking forward to your contact, Grunty.

$100 USD Om 4 dagar

4,8

(46 omdömen)

5,7

9 frilansar lägger i genomsnitt anbud på $51 USD för detta uppdrag

@jaylancer43

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 Om 1 dag

5,0

(709 omdömen)

8,4

@schoudhary1553

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 Om 2 dagar

4,9

(342 omdömen)

7,9

@dataexplorer

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 Om 3 dagar

4,9

(24 omdömen)

4,7

@webscraper24

"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 Om 1 dag

5,0

(2 omdömen)

0,0

@covin

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 Om 1 dag