SCHEDULE feed and timing of updates

[Aleksa Jakovljevic]

HI all,

Reading the wiki I'm just trying to make sure I've understood correctly the update sequence:

-daily SCHEDULE update for the previous day available each day at 0100 UK time (CIF files, which seem to be faster on my end)

-weekly SCHEDULE full snapshot available Saturday at the same time (the wiki says "Friday" but I assume this is overnight like the others?)

-VSTP feed for all the last-minute changes and non-STP planned movements

So if I wanted to import the data to a new database on my end it would be best to download a file on Saturday and apply the updates afterwards each day, correct?

Thanks,

Alex

[Peter Hicks]

Hi Alex

On a Friday, there is both an update and a full extract produced.  You only need process the full extract if you need to reinitialise your schedule database - you can happily take a full extract from three weeks ago and then apply each of the daily updates (including the Friday updates), and you should end up with the same data as if you took last night's full extract.

You can always check your processing is correct by periodically importing a full extract to a separate database and comparing it to your historical full extract plus daily updates (i.e. exclude any VSTP changes).  You should have the same data in both.

Peter

[Phil Wieland]

Just to confirm the above, the master schedule database on my live system is a full extract dated 2013-11-30 with daily updates applied since then.  Every Saturday I also download a full extract and compare it with the database, today's run shows 0 discrepancies.

Gosh, was it really that long ago!

Phil