Scripts

This is a place that I stash handly little python scripts.

Excel-CSV to MySQL date transform

MySQL expects dates to be of the format YYYY/MM/DD, while Excel exports to CSV as MM/DD/YYYY. Here's a python script to transform a (string) date field to a proper one.

Generate URL-firendly IDs for existing Plone objects

Sometimes you end up with Plone objects with names like "organization.2007-01-12.024642" this script runs them through the machinery that uses the title content to generate a more readable ID