Ektron DMS File List
Following my code on Ektron – DMS Content List I created this Ektron Widget
-
-
Ektron Framework API – List Folders
I found this code on the Ektron Developer Center (see link below) that pertained mainly to menus but assisted me in getting a folder drill-down so I could add it into my DMS content widget. Similar to the DMS content widget make sure you setup the proper permissions to the page that lists these as…
-
Test Password Strength
See JSFiddle: JSFiddle Resource: CSS-Tricks.com
-
Compare SQL column against another column
In a recent effort to clean up duplicates in my contacts I came across a script to assist me. In my situation I have some contacts that have had the company name inserted as the first/last name. In my case almost all of the records could be modified to null the first and last name…
-
Excel Macro – Autofit width and height
AutoFit() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+d to select all columns and rows and then set a temporary width and height to then autofit based on all the content in the worksheet. Windows macOS AutoFitHeight() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+e…
-
Code | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.7 | SQL
C# ASPX Phone Number Validation
Credit: fatcat1111 @ stackoverflow.com
-
Excel – VLookup – Compare Two Columns/Sheets
Sometimes we need to compare lists in Excel, this function will assist in getting a clean comparison. NOTE: It is best when comparing that all columns are same format (ie. Text, Number, etc.) OR Going one step further, if you find a match and need a value from the other worksheet you can do this.In…
-
-
SQLite – Auto-Increment / Auto Generate GUID
Recently was asked if it’s possible to create an auto-incrementing GUID in SQLite. Here is one approach: In Firefox there is an add-on called SQLite Manager (also available at https://code.google.com/p/sqlite-manager/) Open Firefox, in the “Tools” menu select “SQLite Manager” With SQLite Manager open click on the “Database” menu and select “New Database” Type in the…
-
MSSQL – Remove Line Breaks
Sometimes you need to remove line breaks or carriage returns, the code below should help. The above script will not work if the column type is TEXT so you must convert it first.