Page History

The

PDF

Forms

plugin

can

be

used

to

publish

PDF

Forms

through

the

Application

Server.

User

can

open

the

PDF

Form,

fill

in

the

fields

and

submit

the

PDF

Form.

The

submitted

PDF

Form

is

sent

to

the

plugin

and

the

values

of

the

fields

are

extracted

from

the

PDF

Form

and

stored

in

the

database.

For

the

plugin

to

receive

the

filled

out

PDF

Form

and

to

extract

the

data,

the

following

is

required:

• The

• fields

• need

• to

• be

• uniquely

• named

• The

• PDF

• Form

• required

• to

• have

• a

• 'submit'

• button

• ,

• which

• sends

• the

• form

• data

• back

• to

• the

• plugin.

The

PDF

Forms

plugin

is

a

100%

server

side

operating

plugin

and

interacts

directly

with

the

database

for

retrieving

the

form

and

storing

the

filled

in

field

values.

Basic

Workflow

1. Actual

1. PDF

1. Forms

1. are

1. uniquely

1. stored

1. as

1. a

1. record

1. in

1. the

1. pdf_template

1. table.

#

2. For

1. each

1. time

1. that

1. an

1. actual

1. PDF

1. Form

1. needs

1. to

1. be

1. filled

1. out

1. a

1. pdf_action

1. record

1. is

1. created

#

2. Links

1. to

1. open

1. the

1. PDF

1. Form

1. for

1. a

1. specific

1. action

1. are

1. provided

1. to

1. the

1. people

1. that

1. need

1. to

1. fill

1. out

1. the

1. form

1. (for

1. example

1. through

1. an

1. application

1. or

1. through

1. email)

#

2. The

1. user

1. opens

1. the

1. PDF

1. Form

1. (in

1. a

1. browser),

1. fills

1. in

1. the

1. fields

1. and

1. submits

1. the

1. PDF

1. Form

#

2. The

1. plugin

1. receives

1. the

1. submitted

1. form,

1. reads

1. the

1. values

1. from

1. the

1. fields

1. and

1. saves

1. those

1. as

1. individual

1. records

1. with

1. the

1. field

1. name

1. and

1. value

1. in

1. the

1. pdf_form_values

1. table,

1. related

1. to

1. the

1. pdf_action

1. record.

#

2. The

1. user

1. gets

1. redirected

1. to

1. the

1. redirect

1. URL

#

2. The

1. pdf_action

1. record

1. is

1. marked

1. as

1. closed

h4.

Creating

PDF

Forms

The

PDF

Forms

plugin

supports

PDF

Forms

(both

FDF

and

XFA)

created

using

[

Adobe

Acrobat

|http://www.adobe.com/products/acrobat/]. {note:XFA Form Support}The plugin supports XFA forms since Servoy

.

In

order

for

the

PDF

Forms

plugin

to

work

with

a

specific

PDF

Form,

it

is

required

that

the

PDF

Form

has:

• Uniquely

• named

• fields

• A

• submit

• button

• A

• hidden

• field

• called

• 'servoy_pdf_submit_url'

• A

• hidden

• field

• called

• 'servoy_action_id'

Uniquely

named

fields

When

the

user

has

filled

out

a

form

and

submits

it,

the

PDf

Forms

plugin

retrieves

all

the

fields

and

their

values

and

stores

them

in

the

database.

For

each

field

name,

it

stores

only

one

value.

This

means

that

unless

each

field

is

uniquely

named,

values

will

get

lost.

Submit

button

The

PDF

form

needs

to

contain

a

submit

button

to

allow

the

user

to

post

back

the

filled

in

form

back

to

the

PDF

Forms

plugin

on

the

Application

Server.

Using

Adobe

Acrobat

or

Adobe

LiveCycle,

create

a

submit

button

on

the

form.

For

FDF

form

add

the

following

JavaScript

code

to

the

mouse-up

action

on

the

button:

var ef = this.getField("servoy_pdf_submit_url");
this.submitForm(ef.value);{code}

For

XFA

form

add

the

following

JavaScript

code

to

the

preSubmit

action

on

the

button:

this.resolveNode("#event").submit.target =
event.target.getField("Form[0].Page[0].servoy_pdf_submit_url[0]").value+"?action_id="+event.target.getField ("Form[0].Page[0].servoy_action_id[0]").value;{code}

For

XFA

form

the

form

must

be

submitted

as

XML

using

UTF-8

encoding.

Also

in

this

javascript

code

Form

and

Page

must

be

replaced

with

the

actual

names

present

in

the

PDF

document.

Automatic

submit

button

injection

The

PDF

Forms

plugin

contains

logic

to

automatically

insert

the

submit

button

into

the

PDF

Form.

The

automatic

insert

of

the

submit

button

is

only

supported

when

the

PDF

Form

is

opened

by

users

using

Adobe

Acrobat,

not

when

opened

through

Adobe

Reader.

Also,

it

is

not

supported

for

XFA

forms.

To

enable

automatic

insertion

of

the

submit

button,

the

'skip_placing_submit_button'

field

on

the

pdf_template

record

needs

to

be

set

to

one

('1').

When

set

to

zero

('0')

the

button

will

not

be

inserted

automatically.

Hidden

fields

The

PDF

Form

needs

to

contain

two

hidden

fields,

one

named

'servoy_pdf_submit_url'

and

one

named

'servoy_action_id'.

These

fields

will

be

automatically

populated

by

the

PDF

Forms

plugin

and

are

used

to

retrieve

the

filled

in

data

back.

For

XFA

forms,

these

hidden

fields

are

also

used

in

order

to

put

the

form

to

readonly.

This

is

needed

because

the

XFA

form

cannot

be

flattened

out-of-the-box,

just

as

the

FDF

form.

So,

this

javascript

must

be

added

in

initialize

event

of

the

form:

if (xfa.resolveNode("Form.Page.servoy_pdf_submit_url").rawValue==null) {xfa.resolveNode ("Form.Page.submitButton").presence="invisible";Form.access = "nonInteractive";}
{code}

In

this

javascript

code

Form,

Page

and

submiButton

must

be

replaced

with

the

actual

names

present

in

the

PDF

document.

Also

this

code

only

works

for

PDF

version

9

and

later

when

access

property

was

introduced

for

form.

In

order

to

support

earlier

versions

all

fields

in

form

must

be

parsed

and

put

to

nonInteractive

(in

javascript

code).

Accessing

the

PDF

Forms

The

PDF

Forms

plugin

exposes

two

dynamic

url's

for

accessing

the

PDF

Forms:

-

• <serverUrl>/servoy-service/pdf_forms/pdf_template?template_id=

\

• {template_id}

• 
  Through

• this

• URL,

• the

• PDF

• Forms

• can

• be

• viewed,

• but

• filling

• and

• submitting

• the

• form

• will

• not

• result

• in

• storing

• the

• data

• to

• the

• database

-

• <serverUrl>/servoy-service/pdf_forms/pdf_form/load.fdf?action_id=

\

• {action_id}

• 
  Through

• this

• URL,

• a

• PDF

• Form

• linked

• to

• a

• specific

• pdf_action

• record

• can

• be

• opened.

• When

• submitted,

• the

• filled

• in

• form

• data

• will

• be

• stored

• in

• the

• database,

• as

• records

• in

• the

• pdf_form_values

• table,

• linked

• to

• the

• specific

• pdf_action.

{

:=}

Note
title	pdf_action.action_type
The pdf_template record contains one column that affects if the PDF Form can be submitted or not. If the action_type column is set to VIEW (value=0) the PDf Form will open in read-only mode. The fields will be read-only and the submit button will be disabled. When the action_type column is set to EDIT (value=1) the PDF Form will open in edit-mode, allowing the fields to be edited and the PDf Form to be submitted. {note} {note:Adobe Acrobat Reader}To view PDF Forms in the browser, Adobe Acrobat Reader 7 (or higher) - including the default web browser plugin - must be installed. Acrobat Reader 7 can be downloaded (at no charge) from Adobe: [

Note
Adobe Acrobat Reader Adobe Acrobat Reader
To view PDF Forms in the browser, Adobe Acrobat Reader 7 (or higher) - including the default web browser plugin - must be installed. Acrobat Reader 7 can be downloaded (at no charge) from Adobe: http://www.adobe.com ]{note} h4.Redirect url After submitting the PDF form, the browser will redirect to the

Redirect url

After submitting the PDF form, the browser will redirect to the redirect_url,

if

specified.

If

no

redirect_url

is

specified

on

the

specific

action,

the

PDF

Forms

plugin

will

lookup

the

redirect_url

on

the

pdf_template

record

linked

to

the

pdf_action.

If

both

the

pdf_action

and

pdf_template

do

not

specify

a

redirect_url,

the

browser

will

be

redirected

to

a

default

page

that

displays

the

text

'Data

successfully

stored,close

this

window'

and

will

attempt

to

close

the

window

.

Automatic

pdf_action

closing

When

the

user

submits

a

PDF

Form,

the

related

pdf_action

record

will

be

marked

as

closed.

When

the

user

would

try

to

re-open

a

PDF

Form

that

was

previously

submitted,

thus

the

pdf_action

record

is

marked

as

closed,

instead

a

page

will

be

shown

in

the

browser,

displaying

the

text

'Security

violation,

use

the

pdf

system

to

edit

pdfs'.

h4.

Re-using

data

When

the

PDF

Forms

plugin

opens

a

PDF

Form

linked

to

an

pdf_action,

it

will

fill

any

field

in

the

PDF

Form

with

data

that

is

already

stored

in

the

pdf_form_values

table,

related

to

the

pdf_action

record.

As

can

be

seen

in

the

ERD

below,

the

link

between

the

data

stored

in

the

pdf_form_values

table

and

the

pdf_action

table

is

not

done

based

on

the

primary

key

of

the

pdf_actions

table,

but

on

a

separate

form_id

column.

This

allows

for

the

following:

-

• Link

• multiple

• actions,

• possibly

• linked

• to

• different

• pdf_templates

• to

• the

• same

• set

• of

• data

-

• Provide

• default

• values

• for

• fields,

• by

• pre-populating

• the

• pdf_form_values

• table

h4.

Entity

Relation

Diagram

The

ERD

below

is

the

minimum

required

by

the

plugin

to

operate.

The

data

model

needs

to

be

present

in

one

of

the

Database

Servers.

By

default,

the

DataBase

Server

named

'pdf_forms'

will

be

used,

but

this

can

be

overwritten

using

the

'pdf_forms_plugin_servername'

setting

of

the

plugin,

available

on

the

Admin

page

under

[

Server

Plugin

Settings

]

.

{gliffy:name=ERD|size=M|border=false} *pdf_templates* The pdf_templates table stores the the actual PDF Form: -

Gliffy Diagram
border false size M name ERD

pdf_templates
The pdf_templates table stores the the actual PDF Form:

• template_id:

• the

• primary

• key

• for

• the

• table

-

• actual_pdf_form:

• a

• media

• field

• containing

• the

• actual

• PDF

• Form

-

• filename:

• a

• descriptive

• name

• (excluding

• the

• .pdf

• extention),

• used

• in

• the

• URL's

• the

• plugin

• generates

-

• skip_placing_submit_button:

• flag

• to

• indicate

• if

• the

• plugin

• should

• automatically

• insert

• a

• 'submit'

• button

• into

• the

• PDF

• Form

• (see

[

• #Submit

• button

]

• below)

-

• redirect_url:

• the

• URL

• where

• the

• user

• is

• redirected

• to

• after

• submitting

• the

• form

*

pdf_actions

* -

• action_id:

• the

• primary

• key

• for

• the

• table

-

• template_id:

• foreign

• key

• to

• the

• pdf_templates

• table

-

• form_id:

• identifier

• to

• link

• with

• the

• pdf_form_values

• table

-

• action_type:

• identifier

• indication

• if

• the

• PDF

• form

• is

• editable

• or

• not.

• (VIEW=0,

• EDIT=1)

-

• closed:

• identifier

• indicating

• if

• the

• action

• is

• closed.

• Automatically

• set

• when

• the

• user

• submits

• the

• form.

• When

• set

• to

• closed,

• it

• overrides

• the

• action_type

• EDIT.

• (OPEN=0/null,CLOSED=1)

-

• redirect_url:

• the

• URL

• where

• the

• user

• is

• redirected

• to

• after

• submitting

• the

• form.

• If

• not

• specified,

• the

• plugin

• will

• lookup

• and

• use

• the

• redirect_url

• of

• the

• linked

• pdf_template

• record

{

• Note

:

• title

=

• Additional

• column

• required

}

• Before

• Servoy

• 5.1,

• the

• plugin

• also

• requires

• the

• presence

• of

• a

• 'user_id'

• column,

• although

• not

used{note} *

• used

pdf_form_values

* -

• fval_id:

• the

• primary

• key

• for

• the

• table

-

• form_id:

• foreign

• key

• to

• the

• pdf_forms

• table

-

• value_name:

• the

• name

• of

• the

• field

• that

• was

• filled

-

• field_value:

• the

• value

• of

• the

• field

• that

• was

• filled

h4.

PDF

Template

location

options

When

a

PDF

Form

is

shown

to

the

user

a

related

PDF

Form

template

is

automatically

retrieved.

This

PDF

Form

Template

is

by

default

loaded

from

the

"actual_pdf_form"

column

from

the

pdf_templates

table.

There

are

two

options

to

override

the

location

from

where

the

template

is

retrieved:

#

1. Override

1. template

1. location

1. for

1. individual

1. PDF

1. Forms

\\

1. 
   By

1. appending

1. an

1. extra

1. parameter

1. named

1. "overrideTemplateLocation"

1. to

1. the

1. URL

1. with

1. as

1. value

1. the

1. location

1. of

1. the

1. PDF

1. Form

1. Template,

1. the

1. PDF

1. Form

1. Template

1. will

1. be

1. loaded

1. from

1. the

1. specified

1. location.

\\

1. 
   Example:

1. <serverUrl>/servoy-service/pdf_forms/pdf_form/load.fdf?action_id=

\

1. {action_id}&overrideTemplateLocation=<serverUrl>/template.pdf

#

2. Override

1. template

1. location

1. for

1. all

1. PDF

1. Forms

\\

1. 
   The

1. PDF

1. Form

1. Template

1. location

1. can

1. also

1. be

1. overridden

1. on

1. plugin

1. level

1. by

1. setting

1. the

1. 'pdf_forms_plugin_template_location'

1. property

1. on

1. the

1. plugin.

1. This

1. will

1. override

1. the

1. PDF

1. Form

1. location

1. for

1. all

1. PDF

1. Forms.

1. As

1. this

1. setting

1. affects

1. all

1. PDF

1. Forms,

1. the

1. value

1. of

1. the

1. property

1. should

1. only

1. specify

1. the

1. directory

1. location.

1. The

1. name

1. of

1. the

1. specific

1. PDF

1. Template

1. is

1. be

1. taken

1. from

1. the

1. 'filename'

1. column

1. of

1. the

1. 'pdf_templates'

1. table.

\\

1. 
   Example:

1. if

1. property

1. is

1. set

1. to

1. <serverUrl>

1. the

1. location

1. will

1. be:

1. <serverUrl>/template.pdf

1. where

1. template.pdf

1. is

1. the

1. template

1. filename

The

overrideTemplateLocation

can

be

any

location

that

is

accessible

from

the

machine

where

the

Servoy

Web

Client

is

running,

for

example

../application_server/server/webapps/ROOT/servoy-webclient/..

The

order

of

precedence

for

PDF

Form

Template

location

is:

#

1. if

1. specified

1. the

1. 'overrideTemplateLocation'

1. parameter

1. in

1. the

1. url

1. is

1. used

#

2. Otherwise

1. if

1. the

1. 'pdf_forms_plugin_template_location'

1. is

1. set

1. on

1. the

1. plugin

1. that

1. will

1. be

1. used

#

2. else

1. the

1. default

1. will

1. be

1. taken

1. from

1. the

1. database

HTML Table
id class servoy sSummary
Colgroup Tag Column padding 0px width 80px Column Table Row (tr) style height: 30px; Table Head (th) colspan 2 Server Property Summary Table Body (tbody) Table Row (tr) Table Cell (td) Table Cell (td) #pdf_forms_plugin_servername Table Body (tbody) Table Row (tr) Table Cell (td) Table Cell (td) #pdf_forms_plugin_template_location

...