RSS Feed
News
Oct
1
Sports Direct content interruption
Posted by Ian Marsman on 01 October 2016 05:38 PM
An issue on one of our servers is interfering with content production for files from Sports Direct. We are working to resolve this. The estimated time to resolve the issue is 2 PM ET.
Read more »



Apr
20
FeedFetcher release - 2016-04-19
Posted by Ian Marsman on 20 April 2016 08:47 PM

A new release of FeedFetcher is available. You can download it using the link from the FeedFetcher installation page.

It is imperative that clients read and follow all release notes and instructions found here before upgrading or installing FeedFetcher. 


Read more »



Jan
17
Changes to all-star roster files and new NFL keys
Posted by Casey Trauer on 17 January 2014 05:49 PM

XML Team will be sending new team keys for this year's NFL Pro Bowl game, as well as new fixture keys for every all-star roster across sports. These changes affect customers of The Sports Network feed.

The first change reflects the new NFL Pro Bowl format, where Jerry Rice and Deion Sanders will be choosing the teams. The key for Team Rice will be l.nfl.com-t.X91. The key for Team Sanders will be l.nfl.com-t.X92. There will be no update to league directory files.

The Sports Network will be sending a full play-by-play feed for this year's Pro Bowl, for those customers subscribed to the NFL progressive feed.

The second change concerns the fixture-key for all-star rosters, which is being changed from "roster" to "roster-all-star". This change reflects the fact that for many clients, these rosters need to be processed differently, so that, for example, players are not permanantly re-assigned from their primary team to the all-star team.

If you are a FeedFetcherDeluxe client and wish to prevent processing of this file to preserve the player's primary team assignment, take the following steps:

1) Go to {ff}/conf/content-rules/active-fixtures-docs.dat
2) Above the line that reads *:*, add these lines:
sport/15003000:roster-all-star:exclude
sport/15007000:roster-all-star:exclude
sport/15008000:roster-all-star:exclude
sport/15031000:roster-all-star:exclude

If you have any questions, please contact us at support@xmlteam.com.


Read more »



Oct
25
Bad event keys for Oct. 24
Posted by Casey Trauer on 25 October 2013 12:37 PM

If you have duplicate or extraneous events for Thursday, Oct. 24 in your
SportsDB database, and those events have an event key that ends "-e...", please
execute the following query to remove those events from your database.

 

DELETE FROM periods

WHERE periods.participant_event_id IN (
SELECT participants_events.id FROM
participants_events
JOIN events ON participants_events.event_id = events.id
WHERE event_key LIKE '%-e..%'
);

DELETE FROM participants_events
WHERE participants_events.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM affiliations_events
WHERE affiliations_events.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM events_sub_seasons
WHERE events_sub_seasons.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM document_fixtures_events
WHERE document_fixtures_events.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM events_documents
WHERE events_documents.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM events_sub_seasons
WHERE events_sub_seasons.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM events_sub_seasons
WHERE events_sub_seasons.event_id IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM person_event_metadata
WHERE person_event_metadata.event_id
IN (
SELECT events.id FROM events
WHERE event_key LIKE '%-e..%'
);

DELETE FROM events
WHERE event_key LIKE '%-e..%' 


Read more »




Help Desk Software by Kayako Resolve