Associations History Data - CIF

[Deek]

Good morning all,

A question about maintaining the history of association creation, and deletion. Firstly would I be right in saying that the association only arrives from the CIF, and that there is no other mechanism that amends or updates the association raw (i.e., perhaps through VSTP or something similar)

The problem I seem to have is that when I take a full CIF on Saturday morning, this rewrites all of the import_version_id  for that week and replaces the date with the date of the full CIF import.

Is this correct behavior?

Many thanks in advance.

Derek  

[Ian Sargent]

Yes it is. 

A full CIF update file is effectively starting again from scratch with all previous alterations combined into the base data. If you wish to hold historic updates and amends you will need to store them elsewhere.

[Oscar Harris]

Hi Derek,

Is there a reason you're taking a full CIF every Saturday? Usually once you've imported your first full CIF, you can just take the daily update files every day forever after, and then the history is properly maintained in your database.

Kind regards,

Oscar

Derek   --
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 view this discussion, visit https://groups.google.com/d/msgid/openraildata-talk/72d88f64-6e49-4c61-9e33-13a3aa49a392n%40googlegroups.com.

[Deek]

Good morning,

Thank you for all the responses.

The only reason I was taking a full CIF every Saturday morning was that I thought it was the right thing to do. Obviously, I should have spoken to this group beforehand, and I find myself now with a costly error.To be fair, when I started building this project, I didn't know about this group, which is obviously a vast wealth of knowledge.

Many thanks. 

To view this discussion, visit https://groups.google.com/d/msgid/openraildata-talk/63bb775b-b939-4b48-9578-0b31ffd20ec9%40oscar-h.com.