General information
Category:
Coding, syntax & commands
>>>>>>>Hi,
>>>>>>>
>>>>>>>I want to automate the loading of information contained in a PDF document to a database. Any easy ways to do this?
>>>>>>>
>>>>>>>Best Regards,
>>>>>>>
>>>>>>>J Miller
>>>>>>This will give an access to document's fields collection:
>>>>>>AcroExchAVDoc = CreateObject("AcroExch.AVDoc")
>>>>>>AcroExchAVDoc.Open("pdfform.pdf", "")
>>>>>>AFormAut = CreateObject("AFormAut.App")
>>>>>>Fields = AFormAut.Fields
>>>>>>
>>>>>>You need a full version of Acrobat or Acrobat Business Tools.
>>>>>>Mark
>>>>>
>>>>>Hi Mark,
>>>>>
>>>>>I finally purchased version 4 of Acrobat. I've been perusing the documentation along with any docs I found on the Adobe site to give me better insight as to what I wanted to do with the PDFs.
>>>>>
>>>>>I downloaded and installed the Acrobat SDK. Is this a necessity to do what I describe above? Can you point me in the right direction as far as the documentation I need to read to continue on with the code segment that you shared above?
>>>>>
>>>>>Any help would be appreciated.
>>>>>
>>>>>John
>>>>
>>>>To do what you want with fields no SDK is needed. Acrobat SDK does not offer much more then you already have with a full version of the product. SDK in mainly for C++ developers who are developing Add-ons for Acrobat. In fact, Automation between VB (VFP) and Acrobat is limited comparing to what you can do using SDK (and C++). Remember, you cannot run Acrobat on the Web server to modify PDFs to send them out to client's browser.
>>>>HTH,
>>>>Mark
>>>
>>>
>>>Hi Mark,
>>>
>>>I went through just about all the Acrobat docs I could find on the Adobe site looking for a way to access the fields collection of a PDF. The code segment you gave me (which I tested and works great) stops short of how to actually start getting the data out of a PDF. Any further direction you could give me?
>>>
>>>Best Regards,
>>>
>>>John
>>
>>
>>To access existing fields you need to know their names:
>>?fields.Item('test').value
>>?fields.Item('test').type
>>
>>Mark
>
>
>Mark,
>
>That's the problem - I don't know their names. There are two PDF documents that I have created by another source. It contains information that I want to dig out and put into a database. If I don't know their names, is there a way to programmatically get them?
>
>Thanks for all your help. You've saved me much time so far.
>
>John
You can create a new pushbutton in the document you need to get fields from and add this LS code to mouse down actions:
console.clear();
// Loop through collection of fields
for (var i = 0; i < numFields; i++)
{ var f_name = getNthFieldName(i);
var f = getField(f_name);
console.println("Field " + (i + 1) + ": " + f_name + " - " + f.type);
}
console.show();
then copy and paste fields names. Still not a true Automation :((. Will let you know if I find anything else.
Mark
PS. No credits to me for a trick.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only