Data (re)ingestion

[jamiefolsom]

This is one to work on, but you may get stuck for lack of information, or need my input. I am assigning it to you as it's been on my plate for some time, and I think it needs more focus than I have right now. We can revisit when I'm back if need be.

For now, at least just get into filemaker, read through the Airtable migration tutorial, so you can help me puzzle through how to capture relations in the export/import and let's discuss.

For both Company Towns and Bourgeau projects in Core Data, we need to ingest or reingest their data from Filemaker. Using the filemaker credentials in 1password (Shared Vault):

• Export .mer files, including relations to linked tables
• Rename to .csv files
• Ingest to airtable and inspect
• Ingest to Core Data

For Company Towns in Core Data, it appears that my last attempt to reingest created 300+ duplicates of the city called "Gachsaran", to which all relations from other cities were added. This is the reason for the reingest.

Here are instructions for ingesting into airtable:

• https://blog.airtable.com/migrating-from-filemaker-to-airtable-part-one/
• https://blog.airtable.com/migrating-from-filemaker-to-airtable-part-two/

Here are the airtable bases:

• Company towns: https://airtable.com/appZuJXaYocUxLX6Z/tbl1R2oakHuCU6dfY/viwLKDIB3nB1hOhHM?blocks=bipRQ3XIcRmZV7erR
• Bourgeau (empty): https://airtable.com/apptnyQ8AHUWst3YZ/tblNoZgCdap3mkrOx/viwt1KO1DLpjOMlv5?blocks=hide

Don't import media tables if any for either project (eg: Iconotheque, Audio/Video Theque/Planotheque).

• For Company Towns,
  • Createurs > People
  • Villes > Places
  • Compagnies > Companies (orgs)
  • Relations between them.
• For Bourgeau:
  • Oeuvres > buildings, which are places
  • Travaux > events, related to oeuvres
  • Individus > people
  • Lieu > places/cities
  • Relations between them