The best way to make your DB/Text Works library catalogue easily and widely available is with a browser-based OPAC accessible via the internet. But what if you don’t have Web Publisher Pro or the necessary IT infrastructure?
Add value to your Inmagic solutions for as little as a few hundred dollars with one or more of our software plug-ins.
View short video presentations of the plug-ins.
For more details, please call us on +61(0)2 9880 8666.
Trimagic Blog
Excel data from your Web Publisher Pro system
By Trimagic Technical Team
Using DB/Text Works and Web Publisher Pro you can design web forms to display statistical information along with your search results. You might, for example, design a report form that shows you how many copies you have of each item in a particular collection, or how many books are on loan to one of your borrowers. But what if you want to get the data into Excel, either for more complex data analysis, or simply to insert the data into a table that can be embedded in other documents? You can do this using table forms. Here's how:
1. Open your textbase and choose "Design Form" from the "Display" option in the DB/Text Works dropdown menu:
2. The "Open Form" dialogue box will display. Select "New Tabular Form" and click the "OK" button:
3. Select your fields:
and format the form as required:
4. When you save the form (using "Form Operations" > "Save Form As" from the DB/Text Works dropdown menu), select the following options:
5. You can now use this table form to display the results of a Web Publisher Pro query. To do this, select an existing Query Screen, or create a new Query Screen, and set the screen properties as follows (where "ExcelTable" is the name of the form that you've just created):
6. When you do your next search using this Query Screen, you'll get a search result that looks something like this:
7. Right-click on the table and choose "Select All" followed by "Copy" to copy the data. Open Excel, select the top left-hand cell (A1), then right-click and select "Paste" or "Paste Special" (if you select "Paste Special" make sure that you choose "HTML"). You can now treat the data as you would any other data in Excel, for example, using them in calculations or graphs:
<< Back
