Wiki me!

After years of doing work and then forgetting that I had done it, last year I decided to take a drastic step and start a record of previous fixes and information.  After discovering that writing things down on tiny scraps of paper was ineffective (the scraps tend to bunch together in the washing machine), I installed a personal Wiki on my workstation.

Minimal web research led me to choose MoinMoinWiki.  Now I have an easy-to-update, searchable, browser-hosted record of my day-to-day work activities.  This is far superior to just unrelated Word documents in a LAN folder.

Wiki: not just for sharing!

Notes for fixing ILLiad Invoices by editing the SQL tables on the ILLiad server.

Just to show I mean business here, I’m posting one of my manual fixes for the OCLC ILLiad ILL Management system. ILLiad is great, but sometimes I have to get into its guts and fiddle around.

 

Use this fix at your own risk! And I always appreciate comments and complaints. If you see a problem let me know.

---

At IU we occasionally have mysterious transactions for which monthly invoices are not generated. It’s possible to create invoice records for transactions that weren’t invoiced automatically. You need to add records in the following tables: