Spec Sheets Test (file system)

This page is a demo of getting all the spec sheets from the file system directly. It does not require the WP-Filebase plugin to be activated. This demo has been shelved because a better way has been discovered using a shortcode to list files by category that can be used in the Block Editor just like we use the WP-Filebase shortcode now to display spec sheets by category.

List of all Spec Sheets – (unordered, ungrouped). Direct from file system of website. Scans 4 levels into the “wp-content/uploads/filebase” folder. Category relationships are stored in database entries in the “wp_wpfb_files” table. Should be able to get the categories and related files and paths from the database, but they are not Posts. Custom table.

  • This page found 396 total files
  • WP-Filebase reports 396 total files (so we got them all, even off-line ones)

“wp_wpfb_files” table (partial list of fields)

  1. file_id (INT)
  2. file_name
  3. file_path i.e.: ( /wp-content/uploads/filebase/bath_accessories/soma-bath/3400.pdf )
  4. file_category (INT)
  5. file_category_name

 

RED = missing, GREEN = included portion

Notes:

  • list_files() – used to list files, sets a transient called “files_transient” which is used as the input to the $files foreach loop. slight performance boost.

396

Union-Square-Lockset-SN.pdf

Union-Square-Lockset-DB.pdf

Union-Square-Lockset-CH.pdf

Union-Square-Lockset-BLK.pdf

Nob Hill Knobs DB.pdf

Nob Hill Knobs SN.pdf

ED-Trim-Plate-rev1.pdf

ED-Trim-Lever-Storeroom-rev1.pdf

ED-Trim-Lever-Passage-rev1.pdf

ED-Trim-Lever-Entry-rev1.pdf

ul_soma_an.pdf

ul_soma_ab.pdf

ul_soma_pb.pdf

ul_soma_ob.pdf

ul_soma_ch.pdf

ul_soma_dc.pdf

ul_marina_an.pdf

ul_marina_ch.pdf

ul_marina_ob.pdf

ul_marina_ab.pdf

ul_marina_pb.pdf

ul_noe_valley_ab.pdf

ul_noe_valley_ch.pdf

ul_noe_valley_ob.pdf

ul_noe_valley_sn.pdf

ul_noe_valley_pb.pdf

ul_noe_valley_an.pdf

ul_deadbolts_ob.pdf

G2-Deadbolt-Spec-Sheet.pdf

ul_deadbolts_pb.pdf

ul_deadbolts_ch.pdf

ul_deadbolts_an.pdf

ul_deadbolts_dc.pdf

ul_deadbolts_ab.pdf

UL-Low-Profile-Deadbolt-Spec-Sheet-R2.pdf

ul_candlestick_ab.pdf

ul_candlestick_dc.pdf

ul_candlestick_pb.pdf

Door-Closer-100-Spec-Sheet-rev1.pdf

Door-Closer-300-Spec-Sheet-rev1.pdf

Door-Closer-400-Spec-Sheet.pdf

Door-Closer-200-Spec-Sheet.pdf

Handelset-P1-R.pdf

Park Presidio Bath Spec Sheet SN.pdf

Park Presidio Bath Spec Sheet CH.pdf

Park-Presidio-Bath-Spec-Sheet-SB.pdf

Park Presidio Bath Spec Sheet DB.pdf

Park-Presidio-Bath-Spec-Sheet-BLK.pdf

Twin-Peaks-Bath-DB.pdf

Twin-Peaks-Bath-CH.pdf

Twin-Peaks-Bath-SN.pdf

Baker-Beach-Bath-Spec-Sheet-DB.pdf

Baker-Beach-Bath-Spec-Sheet-SN.pdf

Baker-Beach-Bath-Spec-Sheet-CH.pdf

Union-Sq-Bath-Spec-Sheet-CH.pdf

Union-Sq-Bath-Spec-Sheet-SN.pdf

Union-Sq-Bath-Spec-Sheet-DB.pdf

Union-Sq-Bath-Spec-Sheet-DB.pdf

Santa-Cruz-Bath-Spec-Sheet-DB.pdf

Santa-Cruz-Bath-Spec-Sheet-SB.pdf

Santa-Cruz-Bath-Spec-Sheet-BLK.pdf

Santa-Cruz-Bath-Spec-Sheet-SN.pdf

Santa-Cruz-Bath-Spec-Sheet-CH.pdf

2200-2.pdf

2200-1.pdf

3400.pdf

6400.pdf

7400.pdf

8400.pdf

Nob-Hill-Bath-5900-ORB.pdf

San-Francisco-Bath-SN-2.pdf

San-Francisco-Bath-DB.pdf

San-Francisco-Bath-CH.pdf

San-Francisco-Bath-BLK-2.pdf

Sea-Cliff-Bath-Spec-Sheet-DB.pdf

Sea-Cliff-Bath-Spec-Sheet-SN.pdf

Sea-Cliff-Bath-Spec-Sheet-CH.pdf

Miraloma-Bath-5100-Antique-Nickel.pdf

Miraloma-Bath-7100-Polished-Brass.pdf

Miraloma-Bath-4100-ORB.pdf

Boardwalk-Bath-Spec-Sheet-DB.pdf

Boardwalk-Bath-Spec-Sheet-BLK.pdf

Boardwalk-Bath-Spec-Sheet-CH.pdf

Boardwalk-Bath-Spec-Sheet-SN.pdf

9000.pdf

7000.pdf

4000.pdf

5000.pdf

3000.pdf

9300-MB.pdf

2300-SN.pdf

8300-CH.pdf

7300.pdf

9300.pdf

3300-DB.pdf

Lombard-Bath-Spec-Sheet-DB.pdf

Lombard-Bath-Spec-Sheet-CH.pdf

Lombard-Bath-Spec-Sheet-SN.pdf

Pacific-Heights-Bath-CH.pdf

Pacific-Heights-Bath-SN.pdf

Pacific-Heights-Bath-DB.pdf

Skyline Bath DB.pdf

Skyline-Bath-SN.pdf

Skyline Bath CH.pdf

Skyline-Bath-Spec-Sheet-BLK.pdf

7200.pdf

6200.pdf

9200.pdf

Shelf-Bracket-Spec-Sheet.pdf

Atherton-Lockset-CH.pdf

Atherton-Lockset-DB.pdf

Atherton-Lockset-SN.pdf

Atherton-Lockset-BLK.pdf

UL-Atherton-Locks-20.pdf

Mag-Catch-Spec-Sheet-R1.pdf

Mission-Bell-Lockset-CH.pdf

Mission-Bell-Lockset-SN.pdf

Mission-Bell-Lockset-DB.pdf

Mission-Bell-Lockset-BLK.pdf

Handelset-P1-R_2.pdf

Crescent Rod.pdf

Shower-Set-R-rev1.pdf

Hillsborough-Lockset-CH.pdf

UL-Hillsborough-Locks-20.pdf

Hillsborough-Lockset-BLK.pdf

Hillsborough-Lockset-SN.pdf

Hillsborough-Lockset-DB.pdf

Tiburon-Lever-BLK.pdf

Mission-Bell-Bath-DB.pdf

Mission-Bell-Bath-SN.pdf

Mission-Bell-Bath-CH.pdf

Fishermen's Wharf Bath DB.pdf

Fishermen's Wharf Bath CH.pdf

Fishermen's Wharf Bath SN.pdf

Park-Presidio-G2-Lever-SN.pdf

Park-Presidio-Lockset-Commecial-grade-DB.pdf

Park-Presidio-G2-Lever-DB.pdf

Park-Presidio-G2-Lever-CH.pdf

Park-Presidio-G2-Lever-BLK.pdf

Skyline-Lever-SN.pdf

UL-Skyline-Blvd-Locks-20.pdf

Skyline-Lever-DB.pdf

Skyline-Lever-CH.pdf

Skyline-Lever-BLK.pdf

Skyline-Deadbolt-Spec-Sheet-R.pdf

Tiburon-Lever-DB.pdf

Tiburon-Lever-SB.pdf

Tiburon-Lever-SN.pdf

UL-Tiburon-Locks-20.pdf

Tiburon-Deadbolt-Spec-Sheet-R.pdf

Tiburon-Lever-CH.pdf

Tiburon-Lever-BLK_2.pdf

Dolores-Park-Lever-BLK.pdf

NLIF7000.pdf

Dolores-Park-Lever-DB.pdf

N4000.pdf

N8300.pdf

N5000.pdf

N9000.pdf

N6000.pdf

Buena-Vista-Lever-CH.pdf

Buena-Vista-Lever-DB.pdf

Buena-Vista-Lever-SN.pdf

Miraloma-Knob-Spec-Sheet-DB-.pdf

Miraloma-Knob-Spec-Sheet-CH.pdf

Miraloma-Knob-Spec-Sheet-SN.pdf

Miraloma-Knob-Spec-Sheet-BLK.pdf

Sunset-Blvd-Spec-CH.pdf

Sunset-Blvd-Spec-BLK.pdf

Sunset-Blvd-Spec-DB.pdf

Sunset-Blvd-Spec-SN.pdf

San-Francisco-Spec-Sheet-DB.pdf

UL-SF-Locks-20.pdf

San-Francisco-Spec-Sheet-CH.pdf

San-Francisco-Spec-Sheet-SN.pdf

San-Francisco-Spec-Sheet-BLK.pdf

West Portal Commercial Lockset SN.pdf

West-Portal-G2-Lever-DB.pdf

soma_IV.pdf

Soma-Lever-Push-Button-Privacy-SN.pdf

Soma-Lever-BLK.pdf

soma.pdf

Soma-Lever-Push-Button-Privacy-DB.pdf

Soma-Lever-SN.pdf

soma_V.pdf

soma_III.pdf

soma_II.pdf

Soma-Lever-DB.pdf

marina_II.pdf

Marina-knob-DB.pdf

marina_IV.pdf

marina.pdf

Marina-knob-BLK.pdf

marina_lifetime.pdf

marina_III.pdf

marina_VI.pdf

marina_VII.pdf

marina_V.pdf

IC Locks Pgs1&2.pdf

noe_valley_lifetime.pdf

noe_valley_IV.pdf

noe_valley_VII.pdf

Noe-Valley-Knob-DB.pdf

noe_valley_III.pdf

Noe-Valley-Knob-BLK.pdf

noe_valley_V.pdf

noe_valley.pdf

noe_valley_II.pdf

noe_valley_VI.pdf

Sea-Cliff-BLK-Spec.pdf

Sea Cliff AB Spec.pdf

Sea Cliff SN Spec.pdf

Sea Cliff PB Spec.pdf

Sea Cliff ORB Spec.pdf

Sea Cliff AN Spec.pdf

Sea-Cliff-DB-Spec.pdf

Sea-Cliff-CH-Spec.pdf

candlestick_park.pdf

Candlestick-Park-Lever-DB-rev1.pdf

Candlestick-Park-Lever-Push-Button-Privacy-DB.pdf

candlestick_park_II.pdf

candlestick_park_III.pdf

Candlestick-Park-Lever-Push-Button-Privacy-SN.pdf

Santa-Cruz-Spec-Sheet-BLK.pdf

Santa-Cruz-Lever-CH.pdf

UL-Santa-Cruz-Locks-20.pdf

Santa-Cruz-Lever-SB.pdf

Santa-Cruz-Lever-DB.pdf

Santa-Cruz-Lever-SN.pdf

Diamond-Heights-BLK.pdf

diamond_heights_LIF2600.pdf

diamond_heights_5600.pdf

Diamond-Heights-Lockset-Dark-Bronze.pdf

diamond_heights_4600.pdf

diamond_heights_3600.pdf

diamond_heights_0600.pdf

Pacifica-Spec-Sheet-CH.pdf

Pacifica-Spec-Sheet-SN.pdf

Pacifica-Spec-Sheet-BLK.pdf

Pacifica-Spec-Sheet-DB.pdf

UL-Pacifica-Locks-20.pdf

5500.pdf

Twin-Peaks-Lever-BLK.pdf

6500.pdf

LIF3500.pdf

Twin-Peaks-Lever-DB.pdf

4500.pdf

2500.pdf

Stinson-Beach-Spec-Sheet-SN.pdf

Stinson-Beach-Spec-Sheet-SB.pdf

Stinson-Beach-Spec-Sheet-CH.pdf

Stinson-Beach-Spec-Sheet-DB.pdf

UL-Stinson-Beach-Locks-20.pdf

Stinson-Beach-Spec-Sheet-BLK-6.pdf

AB.pdf

deadbolt-DC-new.pdf

Low-Profile-Deadbolt-Spec-Sheet.pdf

Deadbolt-Spec-Sheet-BLK.pdf

deadbolt-DB-new.pdf

deadbolt-PB-new.pdf

Electronic-Deadbolt-Rev-3-21.pdf

AN.pdf

LIF.pdf

Tiburon-Deadbolt-Spec-Sheet-R.pdf

deadbolt-CH-new.pdf

deadbolt-ORB-new.pdf

Low-Profile-Deadbolt-Spec-Sheet_2.pdf

North-Beach-Spec-Sheet-CH.pdf

North-Beach-Spec-Sheet-SN.pdf

North-Beach-Spec-Sheet-DB.pdf

North-Beach-Spec-Sheet-BLK.pdf

UL-North-Beach-Locks-20.pdf

UL-Baker-Beach-Locks-20.pdf

Baker-Beach-Spec-Sheet-SN.pdf

Baker-Beach-Spec-Sheet-CH.pdf

Baker-Beach-Spec-Sheet-BLK.pdf

Baker-Beach-Spec-Sheet-DB.pdf

1300_lands_end.pdf

LandE28099s-End-lockset-1200-dull-chrome.pdf

1200_lands_end.pdf

1400_lands_end.pdf

Handleset-P2-R.pdf

Handlesets.pdf

Dolores-Park-Handleset-Spec-Sheet.pdf

Handelset-P1-R_3.pdf

New-Handleset-Spec-Sheet.pdf

Handleset-3.pdf

UL-Boardwalk-Locks-20.pdf

Boardwalk-Spec-Sheet-CH.pdf

Boardwalk-Spec-Sheet-SN.pdf

Boardwalk-Spec-Sheet-DB.pdf

Boardwalk-Spec-Sheet-BLK.pdf

LIF15000.pdf

15000PB.pdf

17000CH.pdf

14000AN.pdf

Pacific-Heights-Lever-DB.pdf

19000ORB.pdf

14000BLK.pdf

16000SN.pdf

Lombard-Levers-DB-Spec.pdf

Lombard-Levers-SN-Spec.pdf

Mill-Valley-Spec-Sheets-DB.pdf

UL-Mill-Valley-Locks-20.pdf

Mill-Valley-Spec-Sheets-BLK-8.pdf

Mill-Valley-Spec-Sheets-CH.pdf

Mill-Valley-Spec-Sheets-SN.pdf

Buena Vista Lockset - Chrome.pdf

Buena Vista Lockset - Dark Bronze.pdf

Buena Vista Lockset - Satin Nickel.pdf

Rockway-Beach-Spec-Sheet-BLK.pdf

Rockway-Beach-Spec-Sheet-SN.pdf

Rockway-Beach-Spec-Sheet-CH.pdf

Rockway-Beach-Spec-Sheet-DB.pdf

UL-Rockaway-Locks-20.pdf

N9300.pdf

Water-Front-Lever-BLK.pdf

N8300.pdf

Water-Front-Lever-DB.pdf

N0300.pdf

N2300.pdf

NLIF7300.pdf

6600.pdf

9600.pdf

7600.pdf

8600.pdf

Dillon-Beach-Lever-SN.pdf

Dillon-Beach-Lever-BLK.pdf

Dillon-Beach-Lever-DB.pdf

Dillon-Beach-Lever-CH.pdf

Round-Bore-Pocket-Door-Locks-2-14-2019.pdf

Round-Bore-Pocket-Door-Locks-spec-older-sheet.pdf

Exit-Device-400-Vertical-Fire-ED-460-rev3-21.pdf

Exit-Device-300-Vertical-ED-360-rev3-21.pdf

Exit-Device-300-RIM-ED-336-Rev3-21.pdf

Exit-Device-400-RIM-Fire-ED-436-rev3-21.pdf

Fishermen's Wharf Lever DB.pdf

Fishermen's Wharf Lever SN.pdf

Fishermen's Wharf Lever CH.pdf

UL-Fishermans-Wharf-Locks-20.pdf

Golder-Gate-Bath-SN.pdf

Tiburon-Bath-Spec-Sheet-SB.pdf

Tiburon-Bath-Spec-Sheet-BLK.pdf

Tiburon-Bath-CH-updated.pdf

Tiburon-Bath-DB-updated.pdf

Tiburon-Bath-SN-updated.pdf

cabinet_hardware_knobs.pdf

cabinet_hardware_pulls.pdf

Stinson-Beach-Pull-DB.pdf

Stinson-Beach-Pull-SN.pdf

Stinson-Beach-Pull-BLK.pdf

Stinson-Beach-Pull-CH.pdf

Santa-Cruz-Cabinet-Pull-CH.pdf

Santa-Cruz-Cabinet-Pull-BLK.pdf

Santa-Cruz-Cabinet-Pull-DB.pdf

Santa-Cruz-Cabinet-Pull-SN.pdf

Pulls-R.pdf

SF-Cabinet-Pull-CH.pdf

SF-Cabinet-Pull-DB.pdf

SF-Cabinet-Pull-SN.pdf

SF-Cabinet-Pull-BLK.pdf

Skyline-Bar-Pull-Spec-Sheet-CH.pdf

Skyline-Bar-Pull-Spec-Sheet-BLK.pdf

Skyline-Bar-Pull-Spec-Sheet-DB.pdf

Skyline-Bar-Pull-Spec-Sheet-SN.pdf

Knobs-R.pdf

Handrail-brackets-Spec-Sheet.pdf

Ocean Beach SN Spec Sheet.pdf

Ocean Beach DB Spec Sheet.pdf

Ocean Beach CH Spec Sheet.pdf

Dolores-Park-Bath-DB.pdf

8000.pdf

Dolores-Park-Bath-BLK.pdf

6000.pdf

5300-1.pdf

5400.pdf

5300-2.pdf

4300-1.pdf

5200.pdf

Noe-Valley-Bath-BLK.pdf

8200.pdf

1200-1.pdf

Nob-Hill-Bath-Spec-Sheet-CH.pdf

Nob-Hill-Bath-Spec-Sheet-DB.pdf

Nob-Hill-Bath-Spec-Sheet-SN.pdf

Miraloma-Park-Bath-MB.pdf

Miraloma-Bath-6100-Satin-Nickel.pdf

Miraloma-Bath-8100-Chrome.pdf

Miraloma-Park-Bath-DB.pdf

grab_bars.pdf

Grab-Bars-2020-rev1.pdf

Door-Viewer-Spec-Sheet.pdf

West Portal DB.pdf

West Portal SN.pdf

West Portal CH.pdf