CDRH / chesnutt

Rails site code for the Charles W. Chesnutt Archive https://chesnuttarchive.org
0 stars 0 forks source link

Make correspondence list displayable #150

Closed nichgray closed 1 year ago

nichgray commented 2 years ago

Convert some of the data in the correspondence tracking spreadsheet to CSV and then pursue options for displaying it on the site. Ideally data should have some sorting functionality. May consider datatables approach or try using the API.

karindalziel commented 2 years ago

code to look at: https://github.com/CDRH/data_teaa/blob/5ad818a8a0a0b948948234e51e55c478294f3d92/scripts/overrides/file_csv.rb#L50

the commented out bit wrote out one whole file, the bit below it made an html file for each row

nichgray commented 2 years ago

Documentation of how to generate/update catalog as it stands (in case helpful for Karin):

  1. download CSV from working Google doc
  2. clean up CSV and limit to fields (column names): identifier sender recipient date source
  3. save file as letters_catalog.csv
  4. upload to /source/csv, overwriting if the file already exists
  5. in data repo, run: post -x html -r catalog #this does the csv -> html transformation and outputs into source
  6. in data repo, run: post -x es,html -r catalog #this does the html transformation and ingests into es
  7. view data at catalog link from correspondence page
nichgray commented 2 years ago

NOTES:

nichgray commented 2 years ago

This should be completed and ready to close if code review comes back okay and posting works (though perhaps save documentation separately).

karindalziel commented 1 year ago

Added Nikki's posting instructions, closing this issue https://github.com/CDRH/data_chesnutt/blob/dev/posting_instructions.md#correspondence-csv