You are viewing limited content. For full access, please sign in.

Question

Question

connector

asked on April 20, 2015

Dear,

There is a way in laserfiche connector to call a laserfiche form and send parameters to this forms?

 

Thank you,

Toni

0 0

Answer

APPROVED ANSWER
replied on April 22, 2015

The '12345' isn't static, it is actually the account number that is currently being displayed in our billing system.  Here are my steps:

1.  Select the application from which to extract the data to be entered into the form.  In this case, our billing application.

2. Select the fields from the billing application that are displaying the needed data.  In this case, in the billing application, I have searched an individual customers account and currently have it being displayed on the screen.  With this particular customer selected in the billing application, token1 will assume the value of 109092-001.

3.  Configure the external program, Internet Explorer, and enter the arguments.  The program will be the path on users local machine to the particular browser you are using for Laserfiche Forms.  Into the arguments, I first enter the url of the form I wish to populate, "http://meadelf/Forms/3JVI1" then "?", followed by the name of the variable from Forms, finally with "=%(toaken1)".  My complete arguments is:   http://meadelf/Forms/3JVI1?FORM_VARIABLE=%(token1)

The resulting url when I run the connector profile is:  http://meadelf/Forms/3JVI1?FORM_VARIABLE=109092-001.  If I pull up a different customer in the billing application the next time I run the profile, the end result would be the same, simply a different number on the end of the url which would be entered in the to defined field on the form.  I will also note, that using Justin's direction above, it was very simple for me to edit the xml document to strip off the "-" and numbers that followed before entering the value into the form field.

 

I hope this helps.

4 0

Replies

replied on April 20, 2015

You can accomplish this by creating a Laserfiche Connector profile that runs an external program.  You'd have the profile run a web browser with the argument containing the URL to the form, formatted to include any tokens to pre-populate fields.  This Tech Tip article discusses how to fill fields in forms using URL parameters.  

2 0
replied on April 21, 2015

You can manually add some triming and string splitting functions in the XML profile directly. http://www.laserfiche.com/support/webhelp/laserficheconnector/9.0/en-us/userguide/#EditingAProfilesXML.htm discusses the currently supported functions. 

1 0
replied on October 21, 2021

The Help file does not have an example of the TRIM syntax. Can you provide that for me?

0 0
replied on April 20, 2015

At this point in time this is not possible.  I asked about this at Empower and was told that it is on the list for future feature requests.  I am hoping that this feature will be added in the near future.

0 0
replied on April 20, 2015

Dear,

I am able to call laserfiche form URL from laserfiche connector but i am not able to pass parameters even when I make the tocken in the arguments.

Let us suppose we have the following link : http://localhost/Forms/form/new/28  and the token is %(token1) .

Can you please tell us what we put in the URL and in the arguments??

Thank you for your help

Toni

0 0
replied on April 21, 2015

Caroline's Tech tip article above has the example you want already (see the screenshot in it): http://localhost/Forms/form/new/28?variable1=%(token1)

2 0
replied on April 22, 2015

Dear ,

I think you didn't understand my question.

Here is the steps that I did:

1-In action and application phase, I choose "Run External Program"

2-In Define token, I create a new token that read the ID from a specific application and give it "token1" name.

3-In External Program, I wrote the following URL in the program phase "http://localhost/Forms/form/new/28?variable1=%(token1)"  , and in the argument i wrote  "%(token1)".

4- Then I click on finish.

5-I run the application and I wrote in the ID field "12345" then I clicked in the profile created in laserfiche connector.

6-The URL generated is as following http://localhost/Forms/form/new/28?variable1=%(token1)

As you can see that the %(token1) is not replaced by 12345

 

what i want to see in the URL is the following:

http://localhost/Forms/form/new/28?variable1=12345

 

Thanks for your Help,

Toni

0 0
replied on April 22, 2015

Forms is a web product, it does not run its own program, so you can't just use the URL with "run external program". You need to launch a web browser and pass in the URL.

See you favorite browser's documentation on how to do that. For example, with Internet Explorer, see this Microsoft KB article.

0 0
replied on April 21, 2015

Thank you very much, this works beautifully!  I do however have one last question on this topic.  The token that is being extracted from my application by Connector is in the format of either 12345-001 or 123456-002.  How can I trim off the "-" and anything that follows it to be inserted into the form field?

0 0
replied on April 21, 2015

From what I understand, regular expressions cannot be used with Connector at this time.

0 0
replied on April 21, 2015

Worked beautifully!  Thank you Justin!

0 0
replied on April 22, 2015

Dear ,

I think you didn't understand my question.

Here is the steps that I did:

1-In action and application phase, I choose "Run External Program"

2-In Define token, I create a new token that read the ID from a specific application and give it "token1" name.

3-In External Program, I wrote the following URL in the program phase "http://localhost/Forms/form/new/28?variable1=%(token1)"  , and in the argument i wrote  "%(token1)".

4- Then I click on finish.

5-I run the application and I wrote in the ID field "12345" then I clicked in the profile created in laserfiche connector.

6-The URL generated is as following http://localhost/Forms/form/new/28?variable1=%(token1)

As you can see that the %(token1) is not replaced by 12345

 

what i want to see in the URL is the following:

http://localhost/Forms/form/new/28?variable1=12345

 

Thanks for your Help,

Toni

0 0
replied on April 22, 2015

Check the name of the variable in the form itself to ensure that you should be entering the phrase "variable1" as in your example.  In the case below, my variable name is "memsep" and the url which is generated is:  http://meadelf/Forms/qKECa?memsep=12345

 

0 0
replied on April 22, 2015

Dear,

In your case, '12345' is static number. I want the token to be dynamic and selected from my application.

 

0 0
replied on April 22, 2015

My apologies, I don't think I was fully understanding what your problem was.  I think the problem lies in step #3 of your process.  Where you enter the external program, IE, Chrome, Firefox, etc...  you need to enter the path to the .exe on the local machine for that particular browser you wish your users to use.  For example, with Internet Explorer the path would be "C:\Program Files (x86)\Internet Explorer\iexplore.exeC:\Program Files (x86)\Internet Explorer\iexplore.exe

APPROVED ANSWER
replied on April 22, 2015

The '12345' isn't static, it is actually the account number that is currently being displayed in our billing system.  Here are my steps:

1.  Select the application from which to extract the data to be entered into the form.  In this case, our billing application.

2. Select the fields from the billing application that are displaying the needed data.  In this case, in the billing application, I have searched an individual customers account and currently have it being displayed on the screen.  With this particular customer selected in the billing application, token1 will assume the value of 109092-001.

3.  Configure the external program, Internet Explorer, and enter the arguments.  The program will be the path on users local machine to the particular browser you are using for Laserfiche Forms.  Into the arguments, I first enter the url of the form I wish to populate, "http://meadelf/Forms/3JVI1" then "?", followed by the name of the variable from Forms, finally with "=%(toaken1)".  My complete arguments is:   http://meadelf/Forms/3JVI1?FORM_VARIABLE=%(token1)

The resulting url when I run the connector profile is:  http://meadelf/Forms/3JVI1?FORM_VARIABLE=109092-001.  If I pull up a different customer in the billing application the next time I run the profile, the end result would be the same, simply a different number on the end of the url which would be entered in the to defined field on the form.  I will also note, that using Justin's direction above, it was very simple for me to edit the xml document to strip off the "-" and numbers that followed before entering the value into the form field.

 

I hope this helps.

4 0
You are not allowed to follow up in this post.

Sign in to reply to this post.