pdfbox-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Hewson <j...@jahewson.com>
Subject Re: Data from PDF - > MS Access
Date Thu, 17 Mar 2016 14:12:51 GMT
Can we please *not* have this conversation on the PDFBox mailing list, thanks.

— John

> On 17 Mar 2016, at 07:01, Tres Finocchiaro <tres.finocchiaro@gmail.com> wrote:
> 
>> 
>> There is a good outlook connector called moyosoft but it does cost about
>> $200
> 
> 
> I'm not sure why you'd use outlook at all.  If the data is going to be
> available in email, use something that can fetch email silently and process
> the inbox as a batch process.
> 
> To have a desktop application interact with Outlook is likely a bad
> design.  Something like a silent IMAP processor would be much more scalable
> <https://pymotw.com/2/imaplib/>, in my opinion. :)
> 
> - Tres.Finocchiaro@gmail.com
> 
> On Thu, Mar 17, 2016 at 12:45 AM, Al Grant <bigal.nz@gmail.com> wrote:
> 
>> Thanks Ken.
>> 
>> Yes that's the only way I can see so far.
>> 
>> There is a good outlook connector called moyosoft but it does cost about
>> $200
>> 
>> The field itself might be called CompanyXYZ Ave the data type longstring.
>> 
>> I will also need record number in the email to update the correct record.
>> 
>> Cheers
>> 
>> Al
>> On 17/03/2016 5:28 pm, "Ken Bowen" <ken@form-runner.com> wrote:
>> 
>>> What is the nature of the feedback into the database?
>>> 
>>> If it amounts to more or less make entries in fields in the db,
>>> and you are stuck with email as a medium, you might hack up a
>>> convention like this:
>>> 1) Select a recognizable boundary line (begin & end), say a line of
>>> at least 10 + or *, or whatever.
>>> 2) Between the boundary lines, have your compatriots make entries like:
>>>        [Field Name] = [Value to be input]
>>> with the restriction that no ‘=‘ sign occurs on either side (or replace
>>> the use of ‘=‘ by something else that would satisfy that restriction).
>>> 
>>> You can knock out a script to process each email to a csv file, and
>>> then import that to your Access db.
>>> 
>>> Regards,
>>> Ken Bowen
>>> 
>>> On Mar 16, 2016, at 9:23 PM, Al Grant <bigal.nz@gmail.com> wrote:
>>> 
>>>> Hi All
>>>> 
>>>> This might be slightly OT - but the list was so helpful in the past...
>>>> 
>>>> I have a database in MS Access and a standalone Java applet that
>> imports
>>>> data from a PDF form and scrapes data from the PDF form into
>>> corresponding
>>>> fields in the Access Database. (Thanks to the list for help on this!)
>>>> 
>>>> A report from this Access database then goes out via email to a handful
>>> of
>>>> people in other companies and they need a way to provide feedback into
>>> the
>>>> database.
>>>> 
>>>> The question is how to achieve this feedback?
>>>> 
>>>> It is difficult because the I am working within a number of
>> constraints:
>>>> 
>>>> 1. We are all working behind large corporate firewalls;
>>>> 2. I have Office 2007 installed;
>>>> 3. Our shared mailboxes are accessed only via a web interface (not OWA
>> -
>>> I
>>>> think Lotus)
>>>> 
>>>> Getting ports on firewall, vpns etc is not an option, nor are cloud
>>>> services like Dropbox or Amazon, so I think I am stuck with email as
>> the
>>>> transport medium.
>>>> 
>>>> Solutions?
>>>> 
>>>> Cheers
>>>> 
>>>> -AL
>>>> 
>>>> --
>>>> "Beat it punk!"
>>>> - Clint Eastwood
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@pdfbox.apache.org
>>> For additional commands, e-mail: users-help@pdfbox.apache.org
>>> 
>>> 
>> 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@pdfbox.apache.org
For additional commands, e-mail: users-help@pdfbox.apache.org


Mime
View raw message