Wise Timetable is a software for scheduling used by many universities and schools.
This gist https://gist.github.com/3937963 is a PHP script to parse the classes using the specified courses and convert them to a format most calendar software can read.
Thus one can grab the schedule with eq. Google Calendar or any other web/desktop/mobile app.
Making a script to check, update and add a set of records to MySQL can be quite daunting. And even when done, the script will be slow. Luckily, there is a way to do this with a simple and fast SQL command.
LOAD DATA LOCAL INFILE '/location/on/drive' -- the location of the CSV
REPLACE INTO TABLE mytable -- table to 'replace' in to
CHARACTER SET charset_name -- the character set the CSV is in
FIELDS TERMINATED BY ';' -- character between fields
OPTIONALLY ENCLOSED BY '"' -- character to enclose fields
ESCAPED BY '"' -- excape character
LINES TERMINATED BY 'n' -- end of line character
IGNORE 1 LINES; -- ignore n lines, useful if first line is a header
(id, name, location, @phonenumber) -- fields, use @ to name a field that does not corespond to a existing column
SET contact=CONCAT('Phone number: ',@phonenumber) -- maybe use the new name to set a column value
The keyword LOCAL is used to specify, that the given file is relative to the client, from which the script was run, otherwise, the path relative to the server would be used.
REPLACE replaces the lines, that have a matching unique field. IGNORE ignores them.
A new version of ScreenSave for Joomla! is out!
- option to pick a image position style
- option to pick a animation
- opacity removed for now
The latest of FxKeyboard, the virtual keyboard for Firefox has been released today.
The changes from the last addons.mozilla.org release (2.2.1) are:
- new languages: it-IT, ru-RU
- new settings: ability to set font styles
- new api: ability to set fields that the keyboard ignores
There comes a time, in the life of any webpage, that a redesign is in order. Partly because my old blog RawDev.net was in need of a clean up and I really didn’t want to push that brand any more.
This site will (hopefully) always be WordPress bleeding edge, starting with WordPress 3.5 and it’s default theme Twenty Twelve – to be released December 5th.
Just a bit of visual touches and voilà!