Collection Report Generation HIDWID
Aug 11, 2021 rap
Link on page: Staff Only > Web Site Development
Link on page: Collection
This page details exactly how reports on the Collection page are built.
Updating existing reports is accomplished by creating new files and installing them in Dropbox and on the web server.
Adding new pages is accomplished by creating new files and installing them in Dropbox and on the web server and updating the Collection web page on the server and the local web page on the Patron computer.
Complete Process for Adding Reports
The process is multi-step and consists of:
1) Report Generation Using FileMaker
2) Saving FileMaker reports
3) Uploading files to the server for anrl.org
4) Updating the Collection web page
5) Membership Charts and Reports
6) Updating the Patron computer
7) perl - renaming files
1) Report Generation Using FileMaker
Notes
- I use a Mac laptop and its utilities are far better than what’s available on ANRL’s windows computer. One thing I can easily do is make a pdf file of a report from FileMaker. If you know how to do this then please tell me.
- Reports are saved locally to: ~/Dropbox/ANRL-Web-Site/Reports
- Web pages point to the pages: http://anrl.orgANRL_PDF/Reports/{the file name.pdf}
- The folder ~/Dropbox/ANRL-Web-Site/Reports is placed on the Patron computer for local (non-internet) access to the reports.
- There is a html file called collection.htm in ~/Dropbox/ANRL-Web-Site/Reports that makes a page that patrons can use to access the reports.
Updated Feb 14, 2021 rap
Books
Surplus Book List
1. FileMaker Menu: Books; Books tab: page bottom, in the Printing Reports box, Section: Index Sorted By Title, then in dropdown box, Sort by Title Filter by Surplus; then click on Book Print Index Sorted Web Page; Print to .pdf file; ftp the file to the website
Loanable Book List
1. FileMaker Menu: Books; Books tab: page bottom, in the Printing Reports box, Choose A2: Books that Members can borrow; then click on Book Print Index Sorted Web Page; Print to .pdf file; ftp the file to the website
Scanned Book List
1. The report was made by Ed Westen and he didn’t document how he did it.
Book Shelf List by Title
1. FileMaker Menu: Books; Books tab: page bottom, in the Printing Reports box, Choose Sort by Title; then click on Book Print Index Sorted Web Page; Print to .pdf file; ftp the file to the website
Book Shelf List by LOC
1. FileMaker Menu: Books; Books tab: page bottom, in the Printing Reports box, Choose Sort By LOC; then click on Book Print Index Sorted Web Page; Print to .pdf file; ftp the file to the website
Book Shelf List by Author
1. The report was made by Ed Westen and he didn’t document how he did it.
ANRL’s Book of the Month Recommendations
1. Bob Proctor selects a book then sends a tweet and other notifications to members, facebook and the Cove Newsletter.
127 Guide Books
1. FileMaker Nothing is setup to automatically make this file
Scanned Books
1. FileMaker Menu: Books; Books tab: page bottom, in the Printing Reports box, Section: Index Sorted By Title, then in dropdown box, Scanned Books; then click on Book Print Index Sorted Web Page; Print to .pdf file; ftp the file to the website
Magazines
- Get a hard disc with a copy of the ANRL_Magazine_Archive
- Use the terminal app on a MAC computer
- Navigate to the ANRL_Magazine_Archive
- Use the command > find . > flist.date.text
- Copy flist.date.text to ~/Dropbox/ANRL-PROJECTS/Magazine_Name_Crunch folder
- Edit the go_Mag_Crunch script as needed with BBEdit
- Get into terminal and run the go_Mag_Crunch script
- Edit the file out.txt and split it into two files: United States and Foreign
- Edit each of these two files with ByWord and render to html
- Edit the anrl.org web page and replace the text with what was rendered - see above.
- Repeat this for United States Magazines
- Good to go!
Use same procedure as for United States Magazines.
Magazine Surplus
1. FileMaker Menu: Magazines; Click in Print Magazine Report Print to .pdf file; ftp the file to the website.
—EW—Surplus Magazine List
1. The report was made by Ed Westen and he didn’t document how he did it.
Magazine Shelf List
1. The report was made by Ed Westen and he didn’t document how he did it.
Digitized Magazine Titles
1. The report was made by Ed Westen and he didn’t document how he did it.
2015–11–19 Gaps (Missing magazines)
1. I don’t have a clue who made this report or how to find updates if any exist. The data are not in FileMaker.
Newsletters
- Newsletters by Club This is a list of Club or Organization names for both Active and Inactive Clubs or Organizations. This report came from data in our Synology NAS.
- terminal/perl
- Newsletters by Folder This is a list of directory names and the number of .pdf files in each. It also gives the name of the most recent file in each directory. This is useful in fabricating names which are consistent with previous file name. This report came from data in our Synology NAS.
- terminal/perl
- Club Sending Newsletters to ANRL This report came from the Newsletter Database.
- terminal/perl
- Newsletters Scanned - 2017 Updates to this report are no longer available.
—EW—Scanned Newsletters
1. The report was made by Ed Westen and he didn’t document how he did it.
Club and Organization Information and Newsletters
Club Sending Newsletters to ANRL
1. FileMaker Nothing known on how to get this report?
pdf files from Scanned Club Folders
1. Bob Proctor created this report in 2015 by using a terminal shell command on his Mac Laptop, then converting to a markdown table, then posted it to a web page. There is no .pdf file.
Club Names in Archive Folders
1. I don’t have a clue who made this report or how to find updates if any exist.
People - Who’s Who
Names of people in Who’s Who Folders
http://us217.siteground.us/public_html/ANRL_PDF/Reports/Whhos_Who_Names…
1. FileMaker Menu: Who’s Who; Tab: Special; Click button: Print Who; Print to .pdf file; ftp the file to the website Note: print at 60% expansion on Bob’s Mac Laptop
Video
- Videos sorted by Title
- FileMaker Menu: Video; Reports tab: Choose Sort By Title; then click on Print Web Report; Print to .pdf file; ftp the file to the website. Note Please set the Printer Setup dialog box that pops up to Landscape and 60%
- Videos sorted by Topic
- FileMaker Menu: Video; Reports tab: Choose Sort By GaryN Topic; then click on Print Web Report; Print to .pdf file; ftp the file to the website. Note Please set the Printer Setup dialog box that pops up to Landscape and 60%
- Video-Surplus-DVD
- FileMaker Menu: Video; Reports tab: Choose Surplus DVD; then click on Print Web Report; Print to .pdf file; ftp the file to the website. Note Please set the Printer Setup dialog box that pops up to Landscape and 60% The 60% option is not possible on Windows computers. Sorry!
- Video-Surplus-VHS
- FileMaker Menu: Video; Reports tab: Choose Surplus VHS; then click on Print Web Report; Print to .pdf file; ftp the file to the website. Note Please set the Printer Setup dialog box that pops up to Landscape and 60%. The 60% option is not possible on Windows computers. Sorry!
All DVDs
1. FileMaker Menu: Video; Tab: Special; “—–Print Pages For Web Site—–” select DVD All; Print: Print to .pdf file; ftp the file to the website.
Video Topics
1. Bob Proctor made this report by outputting fields “Key – Video – Topic” from FileMaker to a tab delimited file, then running a perl program. The report was converted to .pdf by on Bob’s laptop with the “save as .pdf” function of the print program.
Video Archive VHS - Lend to Members
1. ??
Video Archive VHS - Surplus
1. Work In Progress!
Audio
Archive of Audio Cassettes
1. FileMaker Procedure not known on how to re-make this file
Titles of the Audio Cassettes
1. FileMaker: Bob Proctor made this report by selecting records for Cove Players“ outputting fields ”Index – Track – Date – Title“ to a tab delimited file, then running a perl program. The report was converted to .pdf by on Bob’s laptop with the ”save as .pdf" function of the print program.
[Performances by the Cypress Cove Players)
1. FileMaker Menu: Video; Tab: Special; “—–Print Pages For Web Site—–” select Cove Players; click on “Print Index” button; On Bob’s laptop, Print: Print to .pdf file; ftp the file to the website.
Video Interviews
Video Interviews by ANRL
1. This page was created manually and is simply the links to video interviews filmed at the library by Bob Proctor.
Photographs and Slides
- ??
2) Saving FileMaker reports
It is important to save reports to this directory: /Users/rproctor/Dropbox-ANRL/Dropbox/ANRL-Web-Site/Reports. Updated Reports should use the exact name of the existing file that is being replaced. Use of new names or names with dates or anything else will break the process and cause work and time to clean up.
3) Uploading files to the server for anrl.org
A FTP program called CyberDuck is used to write report files to the server. Files are written to: http://us217.siteground.us/public_html/ANRL_PDF/Reports/
Use of this directory and use of existing names when replacing files will save lots of time and work.
4) Updating the Collection web page
- Editing a file called /Users/rproctor/Dropbox-ANRL/Dropbox/ANRL-Web-Site/ANRL_PAGES/Collection.md which is the source text for the web page https://anrl.org/collection and making links to new reports as necessary. A simple update with a new report will require no changes to this file.
5) Membership Charts and Reports
- Dues by Year - detail: Member -> Stats -> Button
- Dues by Year - Chart: Member -> Stats -> Button
6) Updating the Patron computer
Procedure
- Reports from FileMaker are saved to ~/Dropbox/ANRL-Web-Site/Reports
- The master file for making html is in the Reports folder and is a file called Collection_Patron.md It is a markdown file.
- I use the ByWord editor to modify the file while working on my Mac laptop
- Save the file then click on Copy HTML
- Edit the file ~/Reports/Collection_Patron.html with your favorite text editor (mine is BBEdit) and paste the clipboard which was copied in previous step, then save the file. This a .html file and you probably won’t be able to read it, and you won’t need to.
- Copy the directory ~/Dropbox/ANRL-Web-Site/Reports to a thumb drive.
- Copy the Reports directory on the thumb drive to the Patron computer to replace the existing directory.
- Test the install to verify everything is correct.
7) perl - renaming files
This code snippet was taken from
./Dropbox/ANRL-PROJECTS/Magazine_Name_Crunch/Mag_Crunch_02.pl
If you are curious about perl, or how this code works, then contact Bob Proctor.
$zero = "0";
foreach $fp (sort keys %{$mag_list{$country} } ) {
printf OUT1 "%4d\. \*\*%s\*\* \n", ++$fp_cnt, $fp;
$fn_cnt = 0;
Fn:
foreach $fn (sort keys %{$mag_list{$country}{$fp} } ) {
$fn_NEW = $fn;
printf OUT1 " %4d\. %s \n", ++$fn_cnt, $fn;
# string with blank digit dot digit digit more
if ($fn_NEW =~ s/(^.* )([0-9]\.\d\d.*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Australian Sun & Health 11 1985.pdf
if ($fn_NEW =~ s/(^Australian Sun & Health )(\d{2} .*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;;
next Fn;
} else { $code = 0; }
# American Nudist Leader \d\d \d\d\d\d more
if ($fn_NEW =~ s/(^American Nudist Leader )(\d{2} .*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;;
next Fn;
} else { $code = 0; }
# Paradies 9.pdf
if ($fn_NEW =~ s/(^Paradies )(\d\.pdf)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Sonnen Mensch 2.pdf
if ($fn_NEW =~ s/(^Sonnen Mensch )(\d\.pdf)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Sonnenfreunde 05.pdf
if ($fn_NEW =~ s/(^Sonnenfreunde )(\d\.pdf)/$1$zero$zero$2/ || $fn_NEW =~ s/(^Sonnenfreunde )(\d\d\.pdf)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# New Zealand Naturist 90.pdf
if ($fn_NEW =~ s/(^New Zealand Naturist )(\d\d\.pdf)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Helios En 13.pdf Helios En 07 1953.pdf
if ($fn_NEW =~ s/(^Helios En )(\d\d\.pdf)/$1$zero$2/ || $fn_NEW =~ s/(^Helios En )(\d\d \d\d\d\d.*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# INF Bulletin 21 1983 06.pdf
if ($fn_NEW =~ s/(^INF Bulletin )(\d\d .*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Journal of the Senses 18 1971.pdf
if ($fn_NEW =~ s/(^Journal of the Senses )(\d\d .*)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
# Sex To Sexty 15.pdf
if ($fn_NEW =~ s/(^Sex To Sexty )(\d\d\.pdf)/$1$zero$2/) {
$code = 1; $code_cnt++;
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code;
next Fn;
} else { $code = 0; }
printf CSV "\"%s\",\"%s\",\"%s\",\"%d\"\n", $fp, $fn, $fn_NEW, $code if $code == 0;
}
