Hi Mark -
I have been working with FreeEed whenever able in the past few weeks.
Below are a few observations and issues.
I have had some _SUCCESS with sample_freeeed_windows.project, but not
with my own data. The only difference I can see initially is the fact
that the test-data for sample project is inside the FreeEed
application folder, while mine is on another drive. It does not appear
to be a permissions issue.
https://docs.google.com/open?id=0BxFq_4HTyS8UX3ZPMUdPYlhUd3k1X09lMHFWNmFWQQ
Above is a link to the processing history for my most recent attempt
at my sample data. It looks like FreeEed staged 214 files, and then
started processing them, but got through only 25.
And this has been consistently the case for this data set - the
source, staging and output counts. I have even run processing on a
different machine, with the same effect.
Also, for my tests, Native.zip appears to be corrupt; I have tried to
open it with winzip and mac archive utility - both to no avail. A
sample is available at:
https://docs.google.com/open?id=0BxFq_4HTyS8USG1zcThDTDZTa1NpWG4zRThCeEJGZw
Native.zip for the sample project opens fine for me.
Also, the metadata output is not playing nice with database import. It
seems to have 19 fields named, but each record has a varying number of
fields. From my test case, here are the headers from the metadata
file:
"UPI"
"File Name"
"Custodian"
"Source Device"
"Source Path"
"Production Path"
"Modified Date"
"Modified Time"
"Time Offset Value"
"processing_exception"
"To"
"From"
"CC"
"BCC"
"Date Sent"
"Time Sent"
"Subject"
"Date Received"
"Time Received"
These also match the named fields in the Sample_Project metadata file.
And here is record 2 from my case output:
"00002"
"011NewCaseDONE.jpg"
""
""
"011NewCaseDONE.jpg"
""
""
""
""
""
""
" "
""
""
""
""
""
""
""
"011NewCaseDONE.jpg"
"application/msword"
"10"
"Normal.dot"
"Chad M. Wilmer"
""
"1"
"Microsoft Office Word"
"Erin Wrage"
" "
"1"
"269"
"94800000000"
"2006-12-05T21:55:00Z"
""
"10 and 11"
"1536"
""
"BOF
Inc."
"818957243"
""
"2008-01-04T19:12:00Z"
"
ewr...@imagecap.com"
As you see, there are many more fields here than are listed in the
header. And other records have more or fewer fields in the same
metadata file.
I am unaware of a convenient way to code a file like this into an
"Insert Into..." sql script. That's something I've done a lot of, with
standardized output files where each record has the same number of
fields. This could be a "my problem", but it's the first time I've run
into it.
Below is a link to the entire metadata file:
https://docs.google.com/open?id=0BxFq_4HTyS8UYjFHNFBmQ29RbnFRcTllUDhvbFBmdw
While I continue to work on this project, your assistance would be
most greatly appreciated. Nevertheless, my curiosity is maximally
piqued, and I'm excited to be involved in this interesting endeavor.
So thanks very much.
I hope to hear from you.
-Matt