Exporting all fields for a review file of item records

Sierra, Millennium & Encore
1

Hi

Is there any way to export all the fields for a set of item records in a review file? There is a limit to the number of fields you can export if you go via the normal export records route in Create Lists.

Thanks

Louise

1 Like
2

Do you have the ability to run SQL at your library, @Louise_Simon? If so, a SQL query can be used to produce an export with more than the 32 field limit. There is not a one-size-fits-all solution since we all likely have different customized varfields and even some customized fixed fields, but if anyone wants a starter query to further customize, I could write one. I’ve been kicking the idea around to write this for a couple of years now but keep putting it off, so I’d benefit from it too.

The standard export permits the inclusion of record_metadata fields such as created/modified date and item record number, so those would be included in the query.

If there are takers, would there be interest in including limited bib fields as well, such as the bib number, material type, any of the bib codes and/or the author/title columns from bib_record_property?