Find Jobs
Hire Freelancers

Create a VB Excel Script for pulling OMDBAPI metadata

$10-30 USD

Abgeschlossen
Veröffentlicht vor mehr als 5 Jahren

$10-30 USD

Bezahlt bei Lieferung
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"
Projekt-ID: 17999352

Über das Projekt

9 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
Hi there, I understood the problem and can come up with an 'elegant' (efficient + simple) solution. Looking forward to your contact, Grunty.
$100 USD in 4 Tagen
4,8 (46 Bewertungen)
5,7
5,7
9 freelancers are bidding on average $51 USD for this job
Avatar des Nutzers
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 in 1 Tag
5,0 (709 Bewertungen)
8,4
8,4
Avatar des Nutzers
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 in 2 Tagen
4,9 (342 Bewertungen)
7,9
7,9
Avatar des Nutzers
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 in 3 Tagen
4,9 (24 Bewertungen)
4,7
4,7
Avatar des Nutzers
"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 in 1 Tag
5,0 (2 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I have 5 years of experience in excel vba webscraping also i offer you sample of the data.
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Tarpon Springs FL, United States
5,0
2
Zahlungsmethode verifiziert
Mitglied seit Okt. 20, 2018

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.