Version 10 (modified by 10 years ago) (diff) | ,
---|
Data Integration
Integration of Cologne Data
general
convertFaust converts faust-xml output into FMPXMLRESULT.
match_faust_arb contains the methods for matching the different object with the ARB data.
texts
First step is matching the texts.
- convert text objects from faust to filemaker format.
- import the texts into filemaker database faust-texte.
- export relevant field for matching in this case only the number part of signatur is comparted with the numbers in Title in N_source_codex
- match with match_faust_arb.doMatchTexts
- import results into C_faust_arb_texte
- manually check (layout -> C_faust_arb_texte)
Relating the matched texts:
- Layout N_source_codex_faust displayes links to the matched texts.
Importing the new texts/ all non matching texts:
- Import all faust-ids into N_source_codex, for each is a new empty data set created, original ID is saved in import_from_faust
- Script import_from_faust_text, imports selected fields from the faust-db into ARB
- Script import_all_from_faust_text, loops through all selected datasets and does the import, if possible.
Matching:
recipes
- Matching of recipies has to be done
- Import non matching recipes (Import all recipies which can't be in ARB because the texts are not in ARB. (Seems to be only one ID:4229)
- Import remaining recipes
lexikon
- General: solves problem material vs. ingredient.
- First step: matching DB_glossary and ingredients. (inported all missing, and comments), should be checked by Sylvie
- Import all Moderne Namen ";" separated into to entries in N_ingredient (datei: moderneNamen_id.csv), new field lexikon_id_cologne, this ID was created by a script (modernNameMatch) and is not in the FAUST db.