Site
Home / Forum / General Discussion / Update Event Name / Dots v Hyphens in dates?

Update Event Name / Dots v Hyphens in dates?


Posted: 03 Jun 2021 13:30
carlsore
Posts: 20
Joined: 2020-10-22

How can I remove the apostrophes from the following event titles that I added yesterday? They seem to be throwing off the match to Plex.

https://www.thesportsdb.com/event/1136332
https://www.thesportsdb.com/event/1136333
https://www.thesportsdb.com/event/1136336

Also, are there ways to add add'l possible filename formats to an event? I've noticed that anything I add now has a YYYY-MM-DD format to dates recommended, but there are many events, guessing older adds, that have it as YYYY.MM.DD, and Plex also struggles with those.

zag
Posted: 03 Jun 2021 13:40
curswine
Posts: 869
Joined: 2020-06-17

How can I remove the apostrophes from the following event titles that I added yesterday? They seem to be throwing off the match to Plex.

https://www.thesportsdb.com/event/1136332
https://www.thesportsdb.com/event/1136333
https://www.thesportsdb.com/event/1136336


There is no way to remove apostrophes other than deleting the events and re-adding them without, if you're willing to re-add them?

Also, are there ways to add add'l possible filename formats to an event? I've noticed that anything I add now has a YYYY-MM-DD format to dates recommended, but there are many events, guessing older adds, that have it as YYYY.MM.DD, and Plex also struggles with those.

Can you give an example event of where this is the case so I can get a better understanding of what you're talking about?

Posted: 03 Jun 2021 19:12
carlsore
Posts: 20
Joined: 2020-10-22

100% willing to re-add them - I'm also looking at the Plex SportScanner add-on to see if there's a way to augment the call to work around it.

For the Dots/Hyphens issue:
1. https://www.thesportsdb.com/event/1136325 > I added this one yesterday, and you can see the 2007-01-04 format in the recommended filename (this works perfectly in the plugins)
2. I've set up an example by adding a duplicated record - use https://www.thesportsdb.com/api/v1/json/1/searchevents.php?e=Wrestle_Kingdom_11 as the API call, and the first returned response will be the one I just made, second will be the pre-existing one. If you look at the strFilename parameter for each, you'll see that there appears to be some sort of REPLACE('.',' ') happening where the dots get swapped out for spaces, while the hyphenated dates stay together, and my guess is that's why some of the matching algorithms lose the others.

NEW: https://www.thesportsdb.com/event/1136510
OLD: https://www.thesportsdb.com/event/672206

zag
Posted: 06 Jun 2021 21:01

zag
Posts: 3,329
Joined: 2020-03-23

Thanks for pointing this out, yeh its actually a bug in the code for adding fighting events.

I've fixed it now and normalized all the other events with apostrophes.

I'll need to look deeper into the date issue, it should all be hyphens I think.

Posted: 06 Jun 2021 21:30

zag
Posts: 3,329
Joined: 2020-03-23

OK fixed the filename date issue as well on historical events.

Basically it was a historical thing and I have now normalized all events to the same format with hyphens.

Posted: 08 Jun 2021 18:21
carlsore
Posts: 20
Joined: 2020-10-22

Awesome! Thank you so much for doing that!

I'll keep working through filling in blanks for leagues I have that are already out there, but eventually I can add a good handful of additional ones as well, so will report back once I've contributed more.

zag

Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 0 to 6 (Total: 6)