FanDuel Format Tweaks Causes RT Sync Issues

Easy one-time fix available if you're having issues doing a sync with our browser extension.

FanDuel has just made a slight tweak to their CSV file format, which is causing a problem for some users using our RT Sync browser extension. If you've been having issues the last couple of days, here's the quick fix. Below, we'll explain a bit more.

Quick Fix

If you're finding that RT Sync is trying to download your entire FanDuel account history, which is taking ages or ultimately failing, here's what to do.

  • In RT Sync, click on Sync Settings button in the bottom right.
  • Check the box "override default settings for FanDuel and Yahoo."
  • In the text box below, next to always upload my latest...", enter in a number that will be more than enough to cover all your latest results you want to import (don't worry about putting in a number that's too big — duplicates will not import. Which are just trying to avoid importing your entire database!)
  • Save settings, then do a Sync as normal. This should work fine, and upload the number you chose.
  • You can then go back into Sync Settings, and uncheck this option. You shouldn't need it next time.

Here's what's going on

FanDuel updated their CSV file format over the weekend. The change was small: In the last field, which provides a link to view the entry, they removed the domain from the URL. So instead of https://fanduel.com/entry/AJVBHXFRJ it was changed to just /entry/AJVBHXFRJ

This is generally not a problem — our importer handled this fine (we've just pushed up a quick update to better handle this so links still work and point to FanDuel). However, it caused one substantive issue with how RT Sync works.

RT Sync's default behavior is to first gets the top lines of your latest successful file upload to our system. It then polls FanDuel and gets your latest results, 250 lines at a time. It checks each line, and if it already exists in our database then the process stops, as it knows it has hit a duplicate. That way, RT Sync doesn't have to upload your entire database each time, which would be a slow process.

However, because the line format has just been changed, this check for duplication fails — it never finds a duplicate. So it proceeds to download your entire history from FanDuel and upload that to our servers.

That in itself isn't really a problem. It would take a little longer, but the results get uploaded and our server would skip any duplication. However, for users with really big databases — like tens or hundreds of thousands of results — the process can be very slow and sometimes really big file uploads can fail as well.

So the recommended recourse above changes this behavior and tells RT Sync to ignore the duplication check and just upload a set number of lines. This only needs to be once because after one sync, your lines will include the new-style links, so for future checks the duplication checker should work again.


Quick links

Search the FAQ