Project LID Homepage: Distributable Modules
LCCInvestigateRecords Homepage
Updates

Update 6/27/2023: Upgrade: handling delimited columns when every column is qualified, even if not required (i.e. column does not contain delimiter)

Update 3/8/2023: Upgrade: Added keys "lcc:LDAPServer", "lcc:LDAPUserId", "lcc:LDAPUserPassword", "lcc:LDAPSecurityGroup". Added section Encrypt Logic Values.

Update 9/1/2022: Upgrade: added "Download As CSV", and "Download As TXT" options below reports.

Update 8/30/2022: Upgrade: Sped up encryption of records.

Update 8/1/2022: Upgrade: Added keys 'lcc:columnInfoTranslateValue', 'lcc:columnInfoTranslateValuesFromPath'.

Update 10/29/2021: Upgrade: upgraded character encoding (re-escaping) for web form values.

Update 10/25/2021: Upgrade: display Portal Id and Title in footer.

Update 10/13/2021: Bug fix: using '!' in global filter to negate value was not working. Fixed.

Update 10/11/2021: Upgraded to .NET 4.8 to support TLS 1.2. Added negate filter option with '!'.

Update 12/10/2020: Upgrade: Added key 'lcc:columnInfoHide'

Update 8/12/2020: Upgrade: Added key 'lcc:flag'.

Update 7/7/2020: Upgrade: Added key 'lcc:hideHeaderRow'.

Update 7/6/2020: Upgrade: Added empty value option for column filters.

Update 9/4/2019: Upgraded: case insensitivity on specific column searches

Update 4/2/2019: Upgraded: handle user supplied quoted values

Update 4/19/2018: Upgraded: auto focus on password box. Added key 'lcc:maxRecords'.

Update 11/1/2017: Upgraded: show the date of the data file.

Update 11/3/2016: Upgraded: now highlights filters found in values.

Update 9/15/2016: Changed Error message when loading Source file and not found. Generic if not debug IP.

Update 1/26/2016: Upgraded CSV module to handle values with commas and double quotes.

Update 5/19/2014: Bug fix: 'and' search with >= and <= during numeric column search upgraded.

Update 3/17/2014: Upgraded lcc:sourcePath for Labels and multiple source paths (files)

Update 3/14/2014: Bug fix: Global Filter logic.

Update 3/13/2014: Added Keys for 'lcc.addFlags...', lcc:headerPath, lcc:formHeaderPath, lcc:footerPath.

Update 3/11/2014: Added 'next' and 'previous', Key 'lcc:columnInfoFilterAsNumber'.

Update 3/10/2014: Added keys lcc:sourceEncrypted, lcc:addNotes, lcc:borderOnUniqueKeyCol, lcc:singleRecordOnly, lcc:accessPassword.

Update 2/20/2014: Added lcc:disableFooter key. Added Max Records option.

Update 1/27/2014: Program released.

Demo Sites

Description

lccInvestigateRecords was created to allow dynamic querying (investigation) of records in a flat file through a website.

Installation Documentation
Disclaimer
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.