Hi,
I have offered to help a museum move off a simple filemaker database with 30 years of data (8k records). Lot's of inconsistent use of patterns to pass more information that the db records supported. The data is extremely inconsistent, so I expect to spend a while massaging the incoming data with python.
The museum has an interesting policy where they encourage college students to do accessioning as a way to get people involved with history and old manufactured objects. This makes the data even rougher. We actually process on the order of 10-20 objects a week, so the workload is low.
I am thinking that I want to have a proposed object table that is similar to the object table. The big thing is that I don't want to assign the accession id when doing the proposed, that comes as part of the approval process. I can also add fields to the proposed to allow me to do restructuring work iteratively without risk of breaking/polluting the good data.
This is just an initial thought. How would people approach this problem?
thanks in advance,
jerry
