c# pdf to image : Extracting data from pdf into excel Library control component .net web page windows mvc fdm_admin_guide19-part251

Ev
ent Script Parameters
Each FDM Event script has its own set of parameters. These parameters can be used within the
script instead of calling a FDM function, method, or property that returns the same value. For
example, the parameter 
strLoc
contains the name of the active FDM location. This is more
efficient than using the 
API.POVMgr.PPOVLocation
property to return the name of the FDM
location. See the FDM API guide for descriptions of all the event script parameters.
Dy
namicall
y
Changing Import 
F
ormats
You can dynamically change the import format for a location using the 
BefFileImport
event.
In the example that follows, the script changes the import group based on the file name. To
implement this script, you must create two import formats and assign one of them to the FDM
location. The script evaluates the file name and changes the import format if necessary.
-------------------------------------------------------------------
Sub BefFileImport(strLoc, strCat, strPer, strFile)
‘------------------------------------------------------------------
‘Hyperion EVENT Script: 
‘Created By:      Admin
‘Date Created:     10/28/2004 4:29:54 PM
‘Purpose: Change the import group if importing the B/S
‘------------------------------------------------------------------
‘Check if the file name contains “BS”
If InStr(strFile,”BS”)>0 Then
‘Override default import group with B/S import group
RES.PblnImportGroupOverride=True
RES.PstrImportGroup=”BSImportFormat”
End If
End Sub
Ev
ent Scr
i
pts
191
Extracting data from pdf into excel - extract form data from PDF in C#.net, ASP.NET, MVC, Ajax, WPF
Help to Read and Extract Field Data from PDF with a Convenient C# Solution
extract data from pdf forms; extracting data from pdf to excel
Extracting data from pdf into excel - VB.NET PDF Form Data Read library: extract form data from PDF in vb.net, ASP.NET, MVC, Ajax, WPF
Convenient VB.NET Solution to Read and Extract Field Data from PDF
extract data out of pdf file; extract pdf form data to xml
-------------------------------------------------------------------
Dy
namicall
y
Changing 
O
ther 
L
ocation 
A
ttributes
You can use event scripts to dynamically change validation groups, validation rules, and logic
groups before they are processed. Refer to the following table for a description of the events and
properties to change a location attribute.
T
able 3
Ev
ents and propert
i
es to change a 
l
ocat
i
on attr
i
bute
Ev
ent 
N
ame
FD
M Properties
Purpose
BefFileImport
RES.PblnImportGroupOverride=T
rue
RES.PstrImportGroup=”MyNewImp
ortFormat”
C
hange 
I
mpo
r
F
o
r
mat be
f
o
r
i
mpo
r
t
BefProcLogicGrp
RES.PblnLogicGroupOverride
=True
RES.PstrLogicGroup
=”MyNewLogicGroup”
C
hange 
L
og
i
Gr
oup be
f
o
r
e p
r
ocess
i
ng 
l
og
i
c.
BefConsolidate
RES.PblnValEntGroupOverride
=True
RES.PstrValEntGroup=”MyNewEnt
ityGroup”
C
hange 
V
a
li
dat
i
on 
E
nt
i
t
y
Gr
oup be
f
o
r
e
conso
li
dat
i
ng.
BefCheck
RES.PblnValRuleGroupOverride=
True
RES.PstrValRuleGroup=”MyNewVa
lRuleGroup”
C
hange 
V
a
li
dat
i
on 
R
u
l
Gr
oup be
f
o
r
r
unn
i
ng
V
a
li
dat
i
on 
r
epo
r
t.
Using the 
F
ile S
y
stem 
O
bject in an 
Ev
ent Script
Use the Visual Basic File System Object to process files and folders. The following example uses
the File System Object to create a new file and copies the contents of an existing file to the new
file.
-------------------------------------------------------------------
Sub AftExportToDat(strLoc, strCat, strPer, strTCat, strTPer, strFile)
‘------------------------------------------------------------------
‘ FDM EVENT Script: 
‘Created By:      Admin
‘Date Created:     3/18/2004 4:17:58 PM
‘Purpose: This script loops through the newly created Hyperion 
‘     Enterprise .dat file And creates a new .dat file with
‘     a different category and multiplies the amount by .75 
‘------------------------------------------------------------------
‘Declare local variables
Dim strline
192
Scr
i
pt
i
ng
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
Detailed VB.NET Guide for Extracting Pages from Microsoft PDF Doc. Help to extract single or multiple pages from adobe PDF file and save into a new PDF file.
how to type into a pdf form in reader; extract data from pdf to excel
C# PDF Text Extract Library: extract text content from PDF file in
Free online source code for extracting text from adobe PDF document in C#.NET class. Enable extracting PDF text to another PDF file, TXT and SVG formats.
can reader edit pdf forms; pdf data extraction
Dim fso
Dim f1
Dim f2
Dim strNewFileName
Dim strEntity
Dim strAcct
Dim dblAmt
‘Declare file system object
Set fso = CreateObject(“Scripting.FileSystemObject”)
‘Open existing dat file for reading
Set f1 = fso.OpenTextFile(strFile, 1)
‘Create new .dat file with a “-FAS” suffix
strNewFileName=Left(strFile,Len(strFile)-4) & “-FAS” & Right(strFile,4)
Set f2=fso.CreateTextFile(strNewFileName,True)
‘Write category and beginning and ending periods to new file
f2.writeLine “FAS”
f2.writeLine strTPer
f2.writeLine strTPer
‘Skip first 3 header lines of existing dat file
f1.SkipLine
f1.SkipLine
f1.SkipLine
‘Loop through existing .dat file
Do While f1.AtEndOfStream <> True
‘Store line in a variable
strline = f1.ReadLine
‘Parse the entity from the line
strEntity = DW.Utilities.fParseString(strline, 3, 1, “,”)
‘Parse the account from the file
strAcct = DW.Utilities.fParseString(strline, 3, 2, “,”)
‘Parse the amount from the file 
dblAmt = DW.Utilities.fParseString(strline, 3, 3, “,”) 
‘Write out line to new .dat file but multiply amt by .75
f2.writeline strEntity & “,” & strAcct & “,” & dblAmt * .75
Loop
‘Close the files
f1.Close
f2.Close
‘Destroy file system object
Set fso=Nothing
End Sub
-------------------------------------------------------------------
See Appendix A for more advanced information about scripting in FDM.
Menu Maker
The Menu Maker is used to assign custom scripts to new menu options. and enables scripts to
be assigned a meaningful menu name that allows end users to invoke a script. After the script
has been created in the Script Editor, a link to the script can be added to the Web Client interface
to allow users to manually run the script.
Menu Maker
193
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
C# programming sample for extracting all images from PDF. // Open a document. C# programming sample for extracting all images from a specific PDF page.
extract data from pdf form to excel; using pdf forms to collect data
C# PDF insert text Library: insert text into PDF content in C#.net
such as inserting text to PDF, deleting text from PDF, searching text in PDF, extracting text from PDF, and value, The char wil be added into PDF page, 0
pdf data extraction open source; pdf form save in reader
ä
To add the script to the Task Flows screen:
1
Wi
th
i
n the 
W
eb 
Cli
ent, se
l
ect 
T
oo
l
s > Menu Maker.
The Menu Maker screen is displayed.
2
Cli
ck 
A
dd.
A new row is added to the grid.
3
I
n the Menu 
C
apt
i
on co
l
umn, 
E
nter a capt
i
on 
f
or the menu.
4
D
oub
l
e-c
li
ck 
i
n the 
A
ssoc
i
ated Scr
i
pt co
l
umn and se
l
ect the 
W
eb Scr
i
pt 
f
rom the menu.
The sequence field controls the order of all the custom web scripts as they appear on the Task
Flows screen.
5
Se
l
ect the 
A
ct
iv
e checkbo
x
to d
i
sp
l
a
y
the scr
i
pt on the 
T
ask 
Fl
o
w
s screen 
i
n the 
W
eb c
li
ent.
ä
To execute a script from the Task Flows screen:
1
F
rom 
wi
th
i
n the 
W
eb c
li
ent, se
l
ect 
T
oo
l
s > 
T
ask 
Fl
o
w
s.
2
Cli
ck the 
li
nk o
f
the scr
i
pt to e
x
ecute.
The script runs immediately.
A
s
y
nchronous Script 
Ex
ecution
FDM can execute scripts in parallel using a command line interface object. Run any selected
script from within an asynchronous script shell and the script will execute in parallel mode.
Sub AsynchScript()
‘------------------------------------------------------------------
‘Oracle's Hyperion
®
Financial Data Quality Management Custom Script: 
‘Created By:      Admin
‘Date Created:     3/23/2006 13:57
194
Scr
i
pt
i
ng
VB.NET PDF Text Extract Library: extract text content from PDF
Enable extracting PDF text to another PDF file, and other formats such as TXT and SVG form. OCR text from scanned PDF by working with XImage.OCR SDK.
edit pdf form in reader; how to save pdf form data in reader
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
Sample for extracting all images from PDF in VB.NET program. Sample for extracting an image from a specific position on PDF in VB.NET program.
exporting data from excel to pdf form; extract data from pdf forms
‘Purpose:        Asynchronous Script Processing
‘        
‘------------------------------------------------------------------
‘Declare Local Variables
Dim strScriptToRun
Dim strLoadBalanceServerName
‘Initialize variables Variables
strScriptToRun = “YourScriptName”  ‘Name of the script to execute (Type 
Custom General Only)
strLoadBalanceServerName = “LocalHost”     ‘Load balance server for 
Asynchronous process to use
‘Execute the script
If API.DataWindow.Utilities.fExecuteCustomScriptAsync(CStr
(strScriptToRun), CStr(strLoadBalanceServerName)) = True Then
‘Async Script Started, you can make another call while it is 
executing    
Else
‘Async process failed to start
End If
End Sub
------------------------------------------------------------------
This functionality is also supported in the Task Manager which allows scripts to execute at the
same time within a task or to allow individual tasks to behave asynchronously.
A
s
y
nchronous Scr
i
pt 
Ex
ecut
i
on
195
How to C#: Basic SDK Concept of XDoc.PDF for .NET
And PDF file text processing like text writing, extracting, searching, etc., are to load a PDF document from file or query data and save the PDF document.
extracting data from pdf forms to excel; how to make a pdf form fillable in reader
VB.NET PDF: Basic SDK Concept of XDoc.PDF
And PDF file text processing like text writing, extracting, searching, etc., are to load a PDF document from file or query data and save the PDF document.
make pdf form editable in reader; change font size pdf form reader
196
Scr
i
pt
i
ng
VB.NET PDF insert text library: insert text into PDF content in vb
functions to PDF document imaging application, such as inserting text to PDF, deleting text from PDF, searching text in PDF, extracting text from PDF, and so on
pdf data extraction to excel; c# read pdf form fields
A
Common Visual Basic Scripting
Expressions
In 
T
his 
A
ppendi
x
Ov
e
rvi
e
w
..................................................................................................................................................................197
I
nSt
r
........................................................................................................................................................................197
I
nSt
rR
e
v
...................................................................................................................................................................199
I
s
N
ume
ri
c................................................................................................................................................................201
L
en..........................................................................................................................................................................201
L
e
f
t..........................................................................................................................................................................202
LC
ase......................................................................................................................................................................203
LTri
m and 
RTri
m.......................................................................................................................................................203
Mi
d..........................................................................................................................................................................203
M
sg
B
o
x
....................................................................................................................................................................204
N
o
w
.........................................................................................................................................................................206
R
ep
l
ace...................................................................................................................................................................206
Ri
ght........................................................................................................................................................................208
UC
ase......................................................................................................................................................................208
D
o…
L
oop.................................................................................................................................................................209
If
...
T
hen...
El
se..........................................................................................................................................................210
Fil
e S
y
stem 
O
b
j
ect...................................................................................................................................................212
R
ead
i
ng 
Fil
es...........................................................................................................................................................213
M
o
vi
ng, 
C
op
yi
ng, and 
D
e
l
et
i
ng 
Fil
es.........................................................................................................................214
Ov
er
v
iew
This appendix includes a list of common Visual Basic scripting functions. For a complete
reference to VB scripting refer the following Microsoft web site:
http:\\www.msdn.microsoft.com\\vbscript
InStr
Returns the position of the first occurrence of one string within another string.
InStr([start, ]string1, string2[, compare])
Ov
er
vi
e
w
197
A
rguments
start
Numeric expression that sets the starting position for each search. If omitted, search begins at
the first character position. If start contains 
Null
, an error occurs. The start argument is required
if compare is specified (optional).
string1
String expression being searched (required).
string2
String expression searched for (required).
compare
Numeric value indicating the kind of comparison to use when evaluating substrings. See the
following section for values. If omitted, a binary comparison is performed (optional).
Settings
The compare argument can have the following values:
Constant
V
alue
D
escription
vbBinaryCompare
0
Pe
rf
o
r
m a b
i
na
ry
compa
ri
son
vbTextCompare
1
Pe
rf
o
r
m a te
x
tua
l
compa
ri
son
Return 
V
alues
The 
InStr
function returns the following values:
If
InStr Returns
st
ri
ng1 
i
z
e
r
o-
l
ength
0
st
ri
ng1 
i
N
u
ll
N
u
ll
st
ri
ng2 
i
z
e
r
o-
l
ength
sta
r
t
st
ri
ng2 
i
N
u
ll
N
u
ll
st
ri
ng2 
i
s not 
f
ound
0
198
C
ommon 
Vi
sua
l
Bas
i
c Scr
i
pt
i
ng 
Ex
press
i
ons
If
InStr Returns
st
ri
ng2 
i
f
ound 
wi
th
i
n st
ri
ng1
Pos
i
t
i
on at 
w
h
i
ch match 
i
f
ound
sta
r
t > 
L
en(st
ri
ng2)
0
Remarks
The following examples use InStr to search a string:
Dim SearchString, SearchChar, MyPos
SearchString =”XXpXXpXXPXXP”  ‘ String to search in.
SearchChar = “P”  ‘ Search for “P”.
MyPos = InStr(4, SearchString, SearchChar, 1)  ‘ A textual comparison 
starting at position 4. Returns 6.
MyPos = InStr(1, SearchString, SearchChar, 0)  ‘ A binary comparison 
starting at position 1. Returns 9.
MyPos = InStr(SearchString, SearchCharb  ‘ Comparison is binary by default 
(last argument is omitted). Returns 9.
MyPos = InStr(1, SearchString, “W”)  ‘ A binary comparison starting at 
position 1. Returns 0 (“W” is not found).
N
ote:
The 
InStrB
function is used with byte data contained in a string. Instead of returning the
character position of the first occurrence of one string within another, 
InStrB
returns the byte
position.
InStrRe
v
Returns the position of an occurrence of one string within another, from the end of string.
InStrRev(string1, string2[, start[, compare]])
A
rguments
string1
String expression being searched (required).
string2
String expression being searched for (required).
I
nStr
R
e
v
199
start
Numeric expression that sets the starting position for each search. If omitted, -1 is used, which
means that the search begins at the last character position. If start contains 
Null
, an error occurs
(optional).
compare
Numeric value indicating the kind of comparison to use when evaluating substrings. If omitted,
a binary comparison is performed. See the following section for values (optional).
Settings
The compare argument can have the following values:
Constant
V
alue
D
escription
vbBinaryCompare
0
Pe
rf
o
r
m a b
i
na
ry
compa
ri
son
vbTextCompare
1
Pe
rf
o
r
m a te
x
tua
l
compa
ri
son
Return 
V
alues
InStrRev
returns the following values:
If
InStrRe
v
returns
st
ri
ng1 
i
z
e
r
o-
l
ength
0
st
ri
ng1 
i
Null
N
u
ll
st
ri
ng2 
i
z
e
r
o-
l
ength
sta
r
t
st
ri
ng2 
i
Null
N
u
ll
st
ri
ng2 
i
s not 
f
ound
0
st
ri
ng2 
i
f
ound 
wi
th
i
n st
ri
ng1
Pos
i
t
i
on at 
w
h
i
ch match 
i
f
ound
sta
r
t >
Len(string2)
0
Remarks
The following examples use the 
InStrRev
function to search a string:
Dim SearchString, SearchChar, MyPos
SearchString =”XXpXXpXXPXXP”  ‘ String to search in.
SearchChar = “P”  ‘ Search for “P”.
MyPos = InStrRev(SearchString, SearchChar, 10, 0)  ‘ A binary comparison 
starting at position 10. Returns 9.
200
C
ommon 
Vi
sua
l
Bas
i
c Scr
i
pt
i
ng 
Ex
press
i
ons
Documents you may be interested
Documents you may be interested