Handy Library Manager
 for Windows


Help, how to topics > Custom Views > How to export data from a custom view?


How to export data from a custom view? (v3.0)

How to export data from a custom statistics? (v4.0)

You can export data from the main catalog, borrowers, or loans tables in the library. If you need more complex data that requires linking several tables, you can utilize the export feature available in the custom view window.

You can export data from a custom view to a formatted text file or an XML file. This file can be loaded into any spreadsheet application, such as Excel, Google Sheets, or Zoho Sheets.


export data from custom view to spreadsheet

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.



Question:
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.?

Answer:
You can utilize the Firebird SQL language and review our example on implementing view definitions and the export feature.


Question:
Could you please let me know how handy library system can export the loaned items into an excel file?

Answer:
In Custom Views, you can define any SQL query and export the results to a text-formatted file that you can open in Excel. We provide help with SQL queries for users with valid support.



Copyright © 2024 · All Rights Reserved · PrimaSoft PC