Thanks for all of your videos. I created a form with flowable expanding tables that I use to collect data. I use this data to populate other forms to distribute the data. I used the xml data sample option and it seems to work well but after I connected a few documents to the xml data of the original it became VERY sluggish. I get the blue wheel constantly on my cursor. Is there a more efficient way to transfer data from expanding tables from one form to another or am I doing something wrong?
Hello All, This video is a bit outdated and some are running into problems even though they are following my example perfectly. One thing that is not in the video (because I did not know it at the time), is that on a 64-bit version of Windows, the ODBC Connections Wizard is 64-bit by default. On those versions, you will need to find the 32-bit ODBC Connection Wizard in the System32 folder and use it instead.
+True Tech Troubleshooting New security features in LiveCycle will prevent you from doing this. There is no way to "mod" the SQL call to allow for variable due to potential SQL Injection exploits. Incidentally, I no longer recommends using ODBC, due to security concerns (ODBC is pre-Internet technology). You have better results by using a LiveCycle Webservices connection. Sorry to say I don't have any videos on this topic, but checkout www.adobe.com for more info.
Great Videos... Really helps to improve business... Thanks for that 😀 Question: how can I search for example a row by entering an id or name in a text field ? (I have to much data for using big just first, last, previous and next) You know where can I get more information about livecycle and odbc?
Great ! how to make submit button for to send values to database. if user submit the form via email & i want to submit to DB manually. ( if user already filled form, when we open the connection- it will reset the data & load the first record)
Thank you for this great video tutorial. I am not a database person and new to LiveCycle. In your example, you only made connection to a single table in the database. What would be the SQL script to use in LiveCycle to connect to an entire database to access all the tables? Thank you in advanced.
This question is beyond the scope of this video, but you may find help with another expert in SQL. Multiple tables means WHERE clauses and JOIN clauses. It can get complex.
Found using: xfa.sourceSet.DataConnection.update(); after adding a record works well and is more dependable. However how do you perform a look up by using a field record (i.e. ID Number, first name, etc) to then populate remaining fields?
Thank you for the very informative video. Can you do a video in which you obtain the data from either Excel or a comma separated values file and populate drop downs with the data?
Need some help. In the OLEDB Connection set up in LifeCycle, you select the SQL Query, Then you typed select and entered the column names. How did you enter the column names? Did you type each one of them or did you use a short cut. I have a database with 30 columns and I wanted to know how you did this step.
Is there a way to automatically add columns in the access database, right from LiveCycle? Or do I always have to specify all of the fields in Access first?
how do you write sql commands in javascript? i want to enter an employee number in a field and it to populate other field in the form. can't find anything recent on the web.
If I remember right I just copy/pasted a SQL statement I had typed out in notepad. To get all columns you should just enter the simplest statement such as: SELECT * FROM tableName;
First of all I would like to thank you for making really helpful and informative videos.. I am running into a problem with the buttons that I am hoping you might be able to answer..When I copy the FirstName and LastName from the Data View to the Desginer and Preview it that works fine and I can see my first record but when I create the buttons with xfa.sourceSet.DataConnection.next(); or any other button that is not working I am not able to move on to the next record in the Table..Any suggestions as to why this might be happening?
arizwan91 Yes sir. I know its a year later since you posted this. But I am having the same issue. Did you ever receive a response or did you figure out what the issue was? Please send me some help, suggestions if possible. I followed the tutorial to a "tee" but I could not get the buttons work.
I think you're asking the wrong question. It's not a matter of writing SQL statments. Rather, it is a matter of setting up a data connection with your database, and then binding certain fields to "columns" in your dataset. Then you can use event driven javascript to populate the other fields.
Please help us on this Found using: xfa.sourceSet.DataConnection.update(); after adding a record works well and is more dependable. However how do you perform a look up by using a field record (i.e. ID Number, first name, etc) to then populate remaining fields?
Thanks for the videos, had a question, is there a way to create a hyperlink on a table column and if the user clicks on the link opens into a new browser
Hey man, I got this WSDL SOAP API that I am using to properly fetch this data. On the import export bindings I've got them bound properly for fetching and it works. Any chance you could look at it for me? If you can get it working to push this data, I'd be able to not just get and fetch, but update as well. It's worth at least $250 to me and I can Venmo. Thanks for all your demos, they've really helped me out. Anyway, look forward to hearing from you!
Very Good tutorial, I've developed LiveCycle Forms and Access databases separately and never had the need to create an ODBC connection until recently. So, I have a some questions about the SQL Query radio button on the OLEDB Connection dialog box. 1.) How complex can a query be? 2.) Are there any special syntax rules for writing queries. Example: Select * from Table_A Inner Join Table_B On Table_A.Column2=Table_B.Column2 Where Table_B.Column5 = "Test" The above example failed, "Select" worked by itself and also worked with Inner Join". The error came when I added the "Where" statement. Any suggestions? Thanks
My suggestion is to NOT use ODBC for complex Acrobat / Database connections. That may sound funny coming from the producer of this video, but I've learned in the years since producing it that ODBC is simply an archaic technology. Adobe will most likely pull support for it soon (my opinion). They've (for security reasons) had to severely limit the ability to customize SQL statement (which is what you are experiencing in your example) due to security / sql-injection concerns. I suggest using the web-services model. Hopefully, in the near future, I will be producing some more howTo videos related to that technology. Thanks for the question.
This working fine for me when I access the form using Adobe Acrobat/Livecycle Designer. But, If I'm trying to access the same using Reader DC, it's not working. Can anyone suggest me an answer. Thanks in Advance.
This is quite a big topic and requires a database that is configured to allow for a "data connection" from a LiveCycle / AEM form. There are a few methods allowed: WSDL, XMLSchema, OLEDB, and Adobe Data Model. I have a few videos on my channel that talk about this process, but it is quite complex and varied. My suggestion is to look through the material on data connections on help.adobe.com
Yes, using a webservice you can connect to SQL. This video is a few years out of date...ODBC is pre-Internet technology and has been rendered obsolete by Adobe's recent security updates and sandboxing of pdf scripting.
Great video - everything worked except I could not any of the button functionality to work... (First name, Last Name, etc...) Please help of suggest. thanks and keep up the good work
+PublicTechSupport - I had the same issue... and I finally figured out what the problem was.... Livecycle was using Acrobat Reader for the preview. Once I used Acrobat Pro, the buttons worked as described in the video. Hope that helps.
Just a wonderful tutorial, i am designer but i can understand this. i have two questions 1) is it not possible to fill the form using adobe reader? adobe acrobat is must? if there is a way please share it. 2) once i am adding the record its mandate to tell the order of the record is that must? is there any other option? The questions might be crazy. but i am not a expert in this. but once the above 2 is resolved then i work is over. thanks in advance
True Tech Troubleshooting Hi there, I have a similar issue here. I've made a PDF which needs a connection to the database but when opened in reader no connection is initialized to the database... But I've made a workaround to have all the data in Adobe Reader.. I'm just wondering if I'm using a good method with the PDF. Even if I have the form "Reader Extensions" it does not connect to database in Adobe Reader X. I've created a function which gather all the information from the database if the connection is successful, validate the data if it's the same as before.. if it ain't the same, I update the form... The way I work is having each data items to be held in dropdown lists inside a table for each columns... if the connection is successful, a function is executed to transfer all the data inside another table which is saved in dropdown lists as well. The problem with this is that it needs to be updated only in Adobe Acrobat Pro each time a change is applied in the database... Is there a setting for the PDF to be able to connect to database with reader? Also, is it possible to have the message removed which asks if it's okay to connect to the database? As I know, it's more likely a security failure...
+murphy torn Sounds as if there is some new security feature that is getting in between LiveCycle and ODBC. I no longer recommends using ODBC, due to security concerns (ODBC is pre-Internet technology), and the fact that Adobe does not support it any longer.
I am not an expert. But from what I found we do not have the full features. And when I tried to create the database connections also to MS ACCESS none of the drivers were available. I need to submit the data imputed into a form to be submitted to a database to extract meta data from certain fields. Do you know if this could be achieved ? I tried te form distribution by email also but the response file is not getting updated.
+shanuki connections via ODBC to MS Access are even more limited than Javascript. I have not tried, but my assumption is it will not be allowed due to security restrictions.
My name is Everton Santos, I'm from Brazil.... Great!!!!
How can i search for a specific record???
Like a search box.
Thanks for all of your videos. I created a form with flowable expanding tables that I use to collect data. I use this data to populate other forms to distribute the data. I used the xml data sample option and it seems to work well but after I connected a few documents to the xml data of the original it became VERY sluggish. I get the blue wheel constantly on my cursor. Is there a more efficient way to transfer data from expanding tables from one form to another or am I doing something wrong?
Hello All,
This video is a bit outdated and some are running into problems even though they are following my example perfectly. One thing that is not in the video (because I did not know it at the time), is that on a 64-bit version of Windows, the ODBC Connections Wizard is 64-bit by default. On those versions, you will need to find the 32-bit ODBC Connection Wizard in the System32 folder and use it instead.
+True Tech Troubleshooting New security features in LiveCycle will prevent you from doing this. There is no way to "mod" the SQL call to allow for variable due to potential SQL Injection exploits. Incidentally, I no longer recommends using ODBC, due to security concerns (ODBC is pre-Internet technology). You have better results by using a LiveCycle Webservices connection. Sorry to say I don't have any videos on this topic, but checkout www.adobe.com for more info.
can you make a find / search button if you have a big database?
Great Videos... Really helps to improve business... Thanks for that 😀
Question: how can I search for example a row by entering an id or name in a text field ? (I have to much data for using big just first, last, previous and next)
You know where can I get more information about livecycle and odbc?
Worth noting if you using latest version of MS Office (2013) to save Access DB as 2000-2003 version.
Great ! how to make submit button for to send values to database. if user submit the form via email & i want to submit to DB manually. ( if user already filled form, when we open the connection- it will reset the data & load the first record)
Thank you for this great video tutorial. I am not a database person and new to LiveCycle. In your example, you only made connection to a single table in the database. What would be the SQL script to use in LiveCycle to connect to an entire database to access all the tables? Thank you in advanced.
This question is beyond the scope of this video, but you may find help with another expert in SQL. Multiple tables means WHERE clauses and JOIN clauses. It can get complex.
Found using: xfa.sourceSet.DataConnection.update(); after adding a record works well and is more dependable.
However how do you perform a look up by using a field record (i.e. ID Number, first name, etc) to then populate remaining fields?
I have same question ! , Please help us True Tech Troubleshooting
Thank you for the very informative video. Can you do a video in which you obtain the data from either Excel or a comma separated values file and populate drop downs with the data?
that would be very usefull!
Need some help. In the OLEDB Connection set up in LifeCycle, you select the SQL Query, Then you typed select and entered the column names. How did you enter the column names? Did you type each one of them or did you use a short cut. I have a database with 30 columns and I wanted to know how you did this step.
Is there a way to automatically add columns in the access database, right from LiveCycle? Or do I always have to specify all of the fields in Access first?
how do you write sql commands in javascript? i want to enter an employee number in a field and it to populate other field in the form. can't find anything recent on the web.
Also wondering the same thing?? I'm having some connection issues by have SQL as my database source.
If I remember right I just copy/pasted a SQL statement I had typed out in notepad. To get all columns you should just enter the simplest statement such as: SELECT * FROM tableName;
I'm not sure. This may be possible, but I have never done it. Let us know if you figure it out. Thanks!
its the same Javascript for SQL ODBC connection?
First of all I would like to thank you for making really helpful and informative videos..
I am running into a problem with the buttons that I am hoping you might be able to answer..When I copy the FirstName and LastName from the Data View to the Desginer and Preview it that works fine and I can see my first record but when I create the buttons with xfa.sourceSet.DataConnection.next(); or any other button that is not working I am not able to move on to the next record in the Table..Any suggestions as to why this might be happening?
arizwan91 Yes sir. I know its a year later since you posted this. But I am having the same issue. Did you ever receive a response or did you figure out what the issue was? Please send me some help, suggestions if possible. I followed the tutorial to a "tee" but I could not get the buttons work.
I think you're asking the wrong question. It's not a matter of writing SQL statments. Rather, it is a matter of setting up a data connection with your database, and then binding certain fields to "columns" in your dataset. Then you can use event driven javascript to populate the other fields.
Please help us on this
Found using: xfa.sourceSet.DataConnection.update(); after adding a record works well and is more dependable.
However how do you perform a look up by using a field record (i.e. ID Number, first name, etc) to then populate remaining fields?
Thanks for the videos, had a question, is there a way to create a hyperlink on a table column and if the user clicks on the link opens into a new browser
+Prince Mathew Yes, you will need to use a Text object (with the hyperlink) nested inside the Table for this to work.
Hey man, I got this WSDL SOAP API that I am using to properly fetch this data. On the import export bindings I've got them bound properly for fetching and it works. Any chance you could look at it for me? If you can get it working to push this data, I'd be able to not just get and fetch, but update as well. It's worth at least $250 to me and I can Venmo. Thanks for all your demos, they've really helped me out. Anyway, look forward to hearing from you!
Thanks for the question. Can you contact me via the blog? Then we can interact further via email. Cheers.
Very Good tutorial, I've developed LiveCycle Forms and Access databases separately and never had the need to create an ODBC connection until recently. So, I have a some questions about the SQL Query radio button on the OLEDB Connection dialog box.
1.) How complex can a query be?
2.) Are there any special syntax rules for writing queries.
Example:
Select * from Table_A
Inner Join Table_B On Table_A.Column2=Table_B.Column2
Where Table_B.Column5 = "Test"
The above example failed, "Select" worked by itself and also worked with Inner Join". The error came when I added the "Where" statement.
Any suggestions?
Thanks
My suggestion is to NOT use ODBC for complex Acrobat / Database connections. That may sound funny coming from the producer of this video, but I've learned in the years since producing it that ODBC is simply an archaic technology. Adobe will most likely pull support for it soon (my opinion). They've (for security reasons) had to severely limit the ability to customize SQL statement (which is what you are experiencing in your example) due to security / sql-injection concerns.
I suggest using the web-services model. Hopefully, in the near future, I will be producing some more howTo videos related to that technology. Thanks for the question.
This working fine for me when I access the form using Adobe Acrobat/Livecycle Designer. But, If I'm trying to access the same using Reader DC, it's not working. Can anyone suggest me an answer. Thanks in Advance.
Hello
I would like to know how I put a field to search for the field within the database?
Thank you.
This is quite a big topic and requires a database that is configured to allow for a "data connection" from a LiveCycle / AEM form. There are a few methods allowed: WSDL, XMLSchema, OLEDB, and Adobe Data Model.
I have a few videos on my channel that talk about this process, but it is quite complex and varied. My suggestion is to look through the material on data connections on help.adobe.com
Good afternoon!
Thank you very much for the answer, could you tell me what these videos would be?
Yes. Look at his other videos :)
it works with sql databases?
Yes, using a webservice you can connect to SQL. This video is a few years out of date...ODBC is pre-Internet technology and has been rendered obsolete by Adobe's recent security updates and sandboxing of pdf scripting.
Great video - everything worked except I could not any of the button functionality to work... (First name, Last Name, etc...) Please help of suggest.
thanks and keep up the good work
+PublicTechSupport - I had the same issue... and I finally figured out what the problem was.... Livecycle was using Acrobat Reader for the preview. Once I used Acrobat Pro, the buttons worked as described in the video. Hope that helps.
Thank you, thank you, thank you. So frustrating that these dependencies are not made clearer in the documentation.
Just a wonderful tutorial, i am designer but i can understand this. i have two questions
1) is it not possible to fill the form using adobe reader? adobe acrobat is must? if there is a way please share it.
2) once i am adding the record its mandate to tell the order of the record is that must? is there any other option?
The questions might be crazy. but i am not a expert in this. but once the above 2 is resolved then i work is over. thanks in advance
Yes, forms can be created so that the end-user only need to have Adobe Reader. However, dynamic forms need to have "Reader Extentions" enabled.
True Tech Troubleshooting Hi there, I have a similar issue here. I've made a PDF which needs a connection to the database but when opened in reader no connection is initialized to the database... But I've made a workaround to have all the data in Adobe Reader.. I'm just wondering if I'm using a good method with the PDF. Even if I have the form "Reader Extensions" it does not connect to database in Adobe Reader X.
I've created a function which gather all the information from the database if the connection is successful, validate the data if it's the same as before.. if it ain't the same, I update the form... The way I work is having each data items to be held in dropdown lists inside a table for each columns... if the connection is successful, a function is executed to transfer all the data inside another table which is saved in dropdown lists as well. The problem with this is that it needs to be updated only in Adobe Acrobat Pro each time a change is applied in the database... Is there a setting for the PDF to be able to connect to database with reader?
Also, is it possible to have the message removed which asks if it's okay to connect to the database? As I know, it's more likely a security failure...
I have a problem , if the database via ODBC attached I get a message that the environment is unfamiliar and become the data file does not open
+murphy torn Sounds as if there is some new security feature that is getting in between LiveCycle and ODBC. I no longer recommends using ODBC, due to security concerns (ODBC is pre-Internet technology), and the fact that Adobe does not support it any longer.
Hello, Could you show how to connect a form to a Sharepoint Database?
+shanuki Not sure. Does Sharepoint have a WSDL connection component?
I am not an expert. But from what I found we do not have the full features. And when I tried to create the database connections also to MS ACCESS none of the drivers were available. I need to submit the data imputed into a form to be submitted to a database to extract meta data from certain fields. Do you know if this could be achieved ? I tried te form distribution by email also but the response file is not getting updated.
+shanuki connections via ODBC to MS Access are even more limited than Javascript. I have not tried, but my assumption is it will not be allowed due to security restrictions.
Is it possible to collect the data via the adobe distribution feature ? By email ?
+shanuki i don't know. That is an Acrobat feature, not a Designer feature.
If you are in searches of ODBC driver you may check this drivers list directory www.devart.com/odbc/