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
Solved! Go to Solution.
Views
Replies
Total Likes
There is an Adobe database ...you can create your table under that.
Paul
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
In workbench you have to do a get application.....it shoudl be listed there.
Paul
Views
Replies
Total Likes
Hi Paul,
Yes, I know. It´s not there either.
Views
Replies
Total Likes
did you get any errors when you imported the LCA? What version of LC are you using?
Paul
Views
Replies
Total Likes
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:
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi Paul,
Database tools such as?
Can't I access mysql from DOS shell? What user/pass should I use?
Thank you!
Marcos
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi Paul,
Ok, and once I get there which database should I use to create the table?
Thank you!
Views
Replies
Total Likes
There is an Adobe database ...you can create your table under that.
Paul
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies