| 10 | | == Integration of Cologne Data == |
| 11 | | |
| 12 | | === general === |
| 13 | | |
| 14 | | '''convertFaust''' converts faust-xml output into FMPXMLRESULT. |
| 15 | | |
| 16 | | ''' match_faust_arb''' contains the methods for matching the different object with the ARB data. |
| 17 | | |
| 18 | | === texts === |
| 19 | | First step is matching the texts. |
| 20 | | |
| 21 | | * convert text objects from faust to filemaker format. |
| 22 | | * import the texts into filemaker database faust-texte. |
| 23 | | * 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 |
| 24 | | * match with '''match_faust_arb.doMatchTexts''' |
| 25 | | * import results into C_faust_arb_texte |
| 26 | | * manually check (layout -> C_faust_arb_texte) |
| 27 | | |
| 28 | | |
| 29 | | Relating the matched texts: |
| 30 | | |
| 31 | | * Layout N_source_codex_faust displayes links to the matched texts. |
| 32 | | |
| 33 | | Importing the new texts/ all non matching texts: |
| 34 | | |
| 35 | | * 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 |
| 36 | | * Script import_from_faust_text, imports selected fields from the faust-db into ARB |
| 37 | | * Script import_all_from_faust_text, loops through all selected datasets and does the import, if possible. |
| 38 | | |
| 39 | | Matching: |
| 40 | | |
| 41 | | * [ticket:25 Contents / Remarks of the matching docs have to be integrated?] |
| 42 | | * [ticket:26 needs an layout to do so] |
| 43 | | |
| 44 | | |
| 45 | | |
| 46 | | |
| 47 | | === recipes === |
| 48 | | |
| 49 | | * [ticket:21 Matching of recipies has to be done] |
| 50 | | * [ticket:18 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) |
| 51 | | * [ticket:22 Import remaining recipes] |
| 52 | | * first: import von faust-recepte: kommentar -> remark, key --> {{{__import_key__from_cologne}}}, Material --> material |
| 53 | | * second : import now : Folio_Seite --> location, c_faust_arb_texte:correct_arb --> ID_target, N_recipies:ID --> ID_source |
| 54 | | * Now export the now generated datasets (fields: ID_source, ID) |
| 55 | | * Now import the exported data into N_recipes, with ID_soruce matching ID und ID -> ID_recipes_sources |
| 56 | | * Now import transcription and translation: |
| 57 | | * Export transcription and Übersetzung mit ID_recep_ |
| 58 | | * Import in N_representation transkription --> transcription, Übersetzung --> translation, C:recipes_soruces:ID --> _tmp |
| 59 | | * Export the new datasets from there _tmp,ID |
| 60 | | * Import this into C_recipes_source, witch matching _tmp -> ID_source, ID -> ID_representation |
| 61 | | * Export from faust-lexikon.fp7 N_ingredient, N_recipes and key |
| 62 | | * Generate from the export file with splitExport mapping for C_recipes_ingredient. |
| 63 | | * Import this into C_recipes_ingredient |
| 64 | | * Import in N_appellation from faust-lexikon, key -> __import_from_cologne, name -> appelation |
| 65 | | * Export from N_appellation {{{ __import__from_cologne_ID }}} and ID |
| 66 | | * Import into C_recipes_ingredient matching {{{ __import__from_cologne_ID}}} ID --> ID_appellation |
| 67 | | * Import in N_lemma from faust-lexikon, key -> __import_from_cologne, lemma -> name |
| 68 | | * Export from N_Lemma {{{ __import__from_cologne_ID }}} and ID |
| 69 | | * Import into C_recipes_ingredient matching {{{ __import__from_cologne_ID}}} ID --> ID_lemma |
| 70 | | * Results need checking [ticket:28 Lemmas] and [ticket:29 Appellation] |
| 71 | | |
| 72 | | |
| 73 | | |
| 74 | | === lexikon === |
| 75 | | |
| 76 | | * [ticket:24 General: solves problem material vs. ingredient.] |
| 77 | | * First step: matching DB_glossary and ingredients. (inported all missing, and comments), [ticket:23 should be checked by Sylvie] |
| 78 | | * 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. |
| 79 | | |
| 80 | | |
| 81 | | |
| 82 | | |
