You can export data from a custom view to a formatted text file or a xml file. You can load this file to any spreadsheet application (Excel, Google Sheets, Zoho Sheets, ...).
Execute custom view definition.
Click Export Custom View.
In this case Items Never Loaned Out are displayed.
Select Export Format.
Select data fields.
Select export options.
Enter or select an export to file.
The exported file is saved in the C:/handy_lib/data/db/expimp/ folder.
Click on the file to open.
Select the content of the text file.
Copy the selected content.
Paste the content into Excel.
Questions:
Could you show me where to find information on what and
how the SQL definitions under Custom View Assistant work,
specifically the "copies per title" sort process?
My question is how can I design and run reports and export library
results to excel spreadsheet.?
Handy Library uses Firebird SQL language.
Questions:
Could you please let me know how handy library system can export the loaned items
into an excel file?
In the Custom Views you can define any SQL query and export results to a text formatted file that you you can open in Excel. We provide help with SQL queries for user with valid support.
Library latest how-to articles:
Handy v3.2 supports letter tabs?
How to predefine library email messages?
How to set library automated email notifications with your office365.com account?
How to update library data from the web with ISBN?
How to predefine library email messages?
Compilation of questions and answers from library requests will help you to make purchase decision.
How to verify if the item is checked out in the library main catalog window?
How to create a new record using Copy Selected Item?
Special Library, how to manage digital and paper document library?
How to display future reservations?
What is the maximum number of library items?
How to back up, restore, maintenance library feature?
Handy Library Manager
software
tour
features
try now, download
cloud
software reviews
Copyright © 2021 · All Rights Reserved · PrimaSoft PC