Moving PDF collections: Adobe Acrobat Organizer and MySQL
May 6th, 2008Moving to a new computer. The new C drive is a little crammed, so I moved all my PDF files, 4G of them, to D drive. I thought I copied all program perferences to the new user profile, including Adobe Acrobat’s Organizer preferences.
If you are like me, reading tons of PDF files for live, the Organizer (since 8.0?) can be a life saver. You can assign PDF files to categories, and it keeps track of all the files you read in the past week, month, year.
Except for one thing — all the file paths are hard-coded. Once you move your library to a different location, you loose all your "collections". Adobe simply can’t find them, and it makes no attempt to relocate them.
The files, under "C:\Documents and Settings\username\Application Data\Adobe\Acrobat\8.0\organizer70", look awfully like MySQL files. So I gave it a shot. Copied the files to a LAMP server, made new a directory under "htdoc/mysql/data". Fired up PhpMyAdmin. Sure enough, it recognizes it right away like another MySQL databases.
How do I change the path names? Here’s a one liner example:
Search and Replace in MySQL database with phpMyAdmin
UPDATE `flexinode_data` SET textual_data replace textual_data, /audio/ , WHERE `field_id` 41
In my case:
Look under table "files", and do:
UPDATE `files` SET `file_diPath` = replace(`file_diPath`,"/C/Documents and Settings/username/My Documents/eLibrary","/D/eLibrary");
and
You should also edit the table "folders", but that can be easily done manually.UPDATE `files` SET `display_path` = replace(`display_path`,"C:\\Documents and Settings\\username\\My Documents\\eLibrary","D:\\eLibrary") ;
Now copy all the files back to your Adobe Acrobat Organizor folder (I made a backup first). Wola, back to business.
Grover "Russ" Whitehurst is the point man in the push to elevate the role of rigorous research in public education. (Sarah L. Voisin/washington post) 









May 5th, 2008 at 1:16 pm e
Here’s an editorial today from telegram.com
http://www.telegram.com/article/20080505/NEWS/805050317/1020
Article published May 5, 2008
May 5, 2008
The last chapter for federal ‘Reading First’ program
EDITORIAL FOOTNOTE
The latest chapter in the federal government’s Reading First program — part of No Child Left Behind — is a short one: It doesn’t work.
That’s the conclusion of the Department of Education, which found that the billion-dollar-a-year initiative has failed to raise reading levels of elementary school students. The DOE found reading achievement at funded schools was no better than in schools that were not funded.
Putting the federal government in charge of a reading program was a poor use of taxpayer funds from the start. Reading First spent millions on teaching pompously styled “Scientifically Based Reading Research.” Countless generations have learned to read under the guidance of teachers armed with little more than a phonics book and a healthy dose of patience. Even a 2006 DOE interim report mustered only faint praise for the program.
The negative assessment was greeted by one lawmaker with a call to restore funding for Reading First. We have a better idea. Stop wasting federal dollars on what local boards of education and parents should do for themselves. The next page for Reading First should read “The End.”
Order the Telegram & Gazette, delivered daily to your home or office! www.telegram.com/homedelivery Copyright 2008 Worcester Telegram & Gazette Corp.