RockefellerArchiveCenter / scripts

Useful scripts
MIT License
16 stars 5 forks source link

Box labels #51

Closed p-galligan closed 4 years ago

p-galligan commented 4 years ago

Add script for creating box labels.

helrond commented 4 years ago

We still need to do a couple of things:

  1. Write the de-duplicated data to a file (TSV or CSV). Should probably also include a header row.
  2. review get_objects and get_title methods. These are both basically one-line functions, so I'm not sure they need to be a method.
  3. consider adding additional logic to the get_id method to handle multipart ids.
  4. Consider some exception handling for AS connection in __init__ method
p-galligan commented 4 years ago

@helrond Struggling with a concise way to check for ids in multiple fields, but otherwise script is currently working.

p-galligan commented 4 years ago

Ok, have not done any exception handling. Only potential current issue I see is that you cannot sort the sheet by box number because the box and number are in the same cell. Additionally, it writes the boxes out of order to the csv. I believe this is due to running set on the label_data.

helrond commented 4 years ago

@p-galligan check out this tutorial on sorting. You should still be able to sort even if the container type and indicator are in a single field.

p-galligan commented 4 years ago

@helrond Do you think this is ready to merge? Should I send it along to Emeline?