Open shiffer1 opened 6 years ago
Thanks @shiffer1! I think we could add some recommendations for importing spreadsheets to Keemei's docs (e.g. don't try to infer column types when importing; keep everything as strings).
You might also create an issue on the cual-id repo to discuss cual-id specifics (e.g. removing use of the e
character). That seems like a separate issue/discussion from updating Keemei's docs. Thanks!
Improvement Description As I have been working with these again I wanted to revisit this issue. Just to reiterate, as it has been a while, the problems are when opening a metadata sheet that contains cual-ids (or any alpha-numeric ids) in Excel or Google Sheets are:
Proposed Behavior Above we offered the solution of using importing. I used the import functions in both Excel and Google Sheets and this works well. It is a little bit technical and I worry about some folks ability to deal with it without a nice set of instructions. I definitely think we should provide some language on how to handle this. We currently recommend Keemei for verifying metadata sheets and I talked with @jairideout about this yesterday. We should have instructions in the tool descriptions for how to import these documents into Excel and Google Sheets in conjunction with caul-ids as we recommend both of these tools.
Comments