Exporting Records From a Review File - Add option to display meanings of fixed-length fields instead of codes
When you print a list of records from a review file, one of your options is to display meanings of fixed-length fields instead of codes. In our case, we prefer to export data as a .csv/delimited file vs. printing. It would be much easier if we could opt to export the actual meaning of certain fields vs. just the code itself.
Idea Value
Save time - currently we are forced, after exporting, to find specific codes and replace them with the actual label/meaning. Sorry, most of us don't have these codes memorized (and often someone on the business side needs to look at the data). So it's off to parameters > general... many lines of codes/meanings await you.
Data integrity - manually replacing codes with their meaning opens up the possibility of mistakes/changing the wrong fields, etc.
-
Kimberly Allen commented
This would be a big ease of use improvement. As the local stats maven, I am frequently asked to translate these code for other users. I use Excel macros or PowerQuery and others in my group are not familar with that form of slicing/dicing data. If I am not available, that means a delay in generating their reports.
-
Elizabeth Wright commented
I understand that you could create macros to translate codes to descriptions, but codes create barriers for users, and we want the users that are authorized to use Create Lists to engage with the raw data without needing to modify it. This idea would streamline workflows for staff (those that are familiar with the data and those that are not).
-
Bruce Eames commented
This would a valuable addition to Create Lists functionality.
Time and time again over the years staff have asked for list exports for collection management but being able to export the codes only for fields like location, status etc has always been so frustrating.