12-08-2010, 08:17 AM
kedavis425 Wrote:I have the first version of the import utility completed.
It is a Windows 32 application as my PHP is sketchy at best. While I have tested it on a test server and it appears to work well, I have not yet run it on our production system.
I had to split the file into 3 parts because of the 265 KB file upload limitation of this BB. Just download all three parts and extract the first file. it will combine it all back together into one installer.
Installation Instructions
After installing this utility, create a System ODBC Data Source call "opendocman".
Point this Data Source at your OpenDocMan database.
Open the OpenDocMan.udl file, in the installation folder, and point it at your newly created System ODBC Data Source.
Best results are received if you create a Catagory in OpenDocMan called "Imported", then import all documents into this folder.
Now you may run the application. It allows you to select the Owner, Category, Department, and Department Authorities.
You must also list the file extensions you want to import.
The application will take all directory names and the file name (without the extension) and place it in the "Description" Field.
Please let me know what you think.
Ken
THANKS FOR THIS!!!! It saved me a TON ... did I say TON ... of work.