CIF file date formats

[Dave Butland]

So I'm ready to tear my hair out but I've finally got a working CIF file loader that can use the weekly file to validate the current database. It de-duplicates a load of records and can now process a new CIF weekly file in around 10 minutes (which is mostly network time in my test system). 

I'm now just updating it to process the daily deltas and I can't believe what I'm seeing. Are the date formats for the user extract start and end dates really in different formats between the full extract and the delta extract? 

 

[petermount]

That sounds odd as I use the same code for full & delta's - no change in the dates.

What date files are you comparing & which record?

For example, the first line for friday's full & update CIF's look right to me:

27-full.cif.gz

HDTPS.UDFROC1.PD1502272702150010DFROC2P       FA270215270216                    

27-update.cif.gz

HDTPS.UDFROC1.PD1502272702150016DFROC1KDFROC1JUA270215270216        

[Dave Butland]

My mistake as usual. I'm transposing all the dates for some reason and was looking at 15-02-2013 and thinking it was valid when it was 13-02-2015. 

[Ben Woodward]

Yeah, the CIF has two date formats, IIRC the header is reverse to the
rest of them.

> --
> You received this message because you are subscribed to the Google Groups "A
> gathering place for the Open Rail Data community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to openraildata-t...@googlegroups.com.
> To post to this group, send email to openrail...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Dave Butland]

Thanks, I remember changing the date formatting for the detail records. I didn't realise I was using the same date formatting for the header records and therefore it switched them around too. Using separate formatters now.