Help, how to topics > Custom Views > How to modify overdue items or outstanding items due dates?


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

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

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, ...).


export data from custom view

Execute custom view definition.

Click Export Custom View.

In this case items that were never checked out are displayed.

The exported file is saved in the C:/handy_et/data/db/expimp/ folder.



Questions:
Could you show me where to find information on what and how the SQL definitions under Custom View Assistant work, specifically the "items that were not checked out"?
My question is how can I design and run equipment reports and export results to excel spreadsheet.?

Handy Equipment-Tool Manager uses Firebird SQL language.

Questions:
Could you please let me know how handy equipment system can export the checked out items into an excel file?

In the Custom Views you can define any SQL query and export results to a text formatted file (select TAB as separator) that you you can open in Excel. We provide help with SQL queries for users with valid support.




We offer Handy Library Manager application for libraries that includes the same custom views/statistics functionality. In addition, you can find more how-to and sample topics in the Handy Library-Custom Views-Stats help section.

 library software packages (included with handy e-t software):

school library
church library
non-profit org. library
business library
community library
small public library

Copyright © 2023 · All Rights Reserved · PrimaSoft PC