Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Server based sequential number

Avatar

Level 5

Hello!


I have this form on which I need to place a sequence number for control reasons.
How can I create this field?

As PDFs can't write or read txt files, let alone over networks, I suppose I must call a webservice to read the sequence number somewhere, increment it and retrieve this number to be filled in a field in the form, correct?

Possible?

Thank you for any ideas!

Marcos

1 Accepted Solution

Avatar

Correct answer by
Level 10

There is an Adobe database ...you can create your table under that.

Paul

View solution in original post

0 Replies

Avatar

Level 10

To be able to get a sequential number you will need an external source to store the number and update it as it is being used. I have used a DB table that will update the number as each user opens the form. This means that you will need a connection to the DB. You can use a Web Service or an ODBC connection to a DB. In either case if you intend on using Reader then you will have to Reader extend the form to be able to use that functionality. This means that LiveCycle Reader Extensions server is required. As well the users must be connected to a network to be able to "get" the number. This can become a very expensive problem to solve ....are you sure you want to go down that path?

Paul

Avatar

Level 5

Hi Paul,

Thank you very much for replying,

Definitely, yes. This is exactly the scenario I have.

The client has Reader Extensions and all forms work over a network.

Today they are using an old platform called JefForms (actually Adobe bought JetForms a long time ago), so today their forms read the sequential number from a TXT file, increment the value there and places this number on the form.

Now they've moved on to PDFs and LiveCycle Reader Extensions - it's all there in place. So, yes, the idea is reading from a DB and incrementing the value for the next form in the sequence.

What I need right now is how to do it in the PDF (LC Designer), taking for granted there is a Webservice or ODBC, or whatever, taking care of the network/server/DB part.

Thank you for any hints.

Marcos

Avatar

Level 10

Do they have a complete LiveCycle server? If so I have doen an example using that. I created a DB table in LC and used that. Then created a process

to read and update that table.

Here are the sample files. The txt file is the SQL that I used to create the table (I am using MySQL as the DB).

Paul

Avatar

Level 5

Hi Paul!

Thank you very much for the sample files!

Well, yes, I believe they have a complete server, that is, they have Reader Extensions and Foundations should be there. They're using Oracle instead of MySQL, anyway, but I guess it makes no difference at all.

Now, to start with, I imported your LCA in the Application Management interface... but nothing is showing on the application list after I import it. Maybe I skipped some operation, some configuration?

Thank you for your help!

Marcos

Avatar

Level 10

In workbench you have to do a get application.....it shoudl be listed there.

Paul

Avatar

Level 5

Hi Paul,

Yes, I know. It´s not there either. 

Avatar

Level 10

did you get any errors when you imported the LCA? What version of LC are you using?

Paul

Avatar

Level 5

Hi Paul,

No errors, apparently.

If this helps, I found this listed in Service Management interface:

getSequenceNumber: 1.0 - State: running - Component Id: com.adobe.idp.workflow.dsc.service.WorkflowDSC - Component version: 9.0.0.2.20100902.2.246889

More info:

lc.GIF

As for the version, as follows (this is my local machine server):

Adobe LiveCycle ES2

Adobe LiveCycle Administrative Framework

Version: 9.0.0.0, GM
Patch Version: SP2
Service Pack Version: 9.0.0.2.20100902.2.246889

Adobe LiveCycle Workbench ES2
Version: 9.5.0.0.20100908.1.247189

Thank you!

Marcos

Avatar

Level 5

Updating...

I have rebooted the server, nothing changed.

The service is listed, shows up as "running" in Service Management, but the application is not showing on the Application Management interface.

It is not listed when I try Get Application on LC Workbench.

Please, help!

Marcos

Avatar

Level 10

I do not remember but I think I built it on an earlier version of LC. You will have to import it in workbench instead of getting it. Create a new application. Then under that app highlight the root node and right click and choose import.  A menu will pop up. Under the LiveCycle runtime content choose Process and click Next. You shoudl get a Test folder ...under that Test folder is the getSequenceNumber process.

Paul

Avatar

Level 5

Hi Paul,

Thank you once again! I will proceed this way.

Now, where do I create the db Table? From Workbench? Do I have access to LiveCycle MySQL to create using the SQL statements?

This is not clear to me.

Thank you.

Marcos

Avatar

Level 5

Hi Paul,

I did exactly as you explained.

However, there was no folder called Test or any folder containing the getSequenceNumber process.

UPDATE: After closing and reopenind Workbench, the Test folder and the process are there!

Thank you!

Now I still need to find out how to connect to the database. 

Marcos

Message was edited by: Marcos J Pinto

Avatar

Level 10

I sent you some SQL code to create the table ...you will need some DB tools that will allow you to executethat script (this is not done in workbench). If you have the turnkey install and arte using MySQL there are database tools you can download to manage and manipulate your databases.

Paul

Avatar

Level 5

Hi Paul,

Database tools such as?

Can't I access mysql from DOS shell? What user/pass should I use?

Thank you!

Marcos

Avatar

Level 10

Nope ...I woudl recommend MySQL query Browser and MySQL gui tools. If you search the net I am sure you will find a download site. You will want the tools for version 5 of MySQL.

Paul

Avatar

Level 5

Hi Paul,

Ok, and once I get there which database should I use to create the table?

Thank you!

Avatar

Correct answer by
Level 10

There is an Adobe database ...you can create your table under that.

Paul

Avatar

Level 5

Hi Paul!

GREAT! It is working perfectly!  Thank you!!

BTW, I figured out my way to MySQL shell access, much quicker and easier; 

Now my next challenge is port this to a Linux SUSE + Weblogic + Oracle environment...

Thank you very much for your help!

Best Regards.

Marcos