If anyone else is using FD7 with Radarbox, I've now discovered a way of auto-populating the routes for EVERY aircraft. Use the "Start Tour" button in Radarbox. This cycles round each aircraft in the list, and sends a SEL message on port 30003, triggering FD7 to do a route lookup.
Then at the end of the day, export the routes from FD7, using this query:
SELECT DISTINCT
Routes.FlightID AS FN,
Routes.DepICAO AS NO,
Routes.ArrICAO AS ND,
"" AS NV,
substr(Routes.Posted,1,4)||substr(Routes.Posted,6,2)||substr(Routes.Posted,9,2)||"000000" AS CH
FROM
Routes
WHERE
(Routes.DepICAO IS NOT NULL) AND
(Routes.ArrICAO IS NOT NULL) AND
(Routes.DepICAO <> "") AND
(Routes.ArrICAO <> "")
ANd import into the Radarbox routes table.