Case Else:

This script will take a CSV file of two columns — ostensibly in ‘last-name, first-name’ format — and attempt to convert it into valid userIDs, despite irregularities in the list.

[Read more →]

Here’s a request that happens fairly regularly in different offices I’ve been associated with:

We receive surveys/orders/documents that have been filled out by various people as Excel spreadsheets
We need to put the information into a database
We want you to write a script to automate the imports.

My thoughts as a scripter:

[Read more →]