http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 03:21:19 +0000 http://www.perfectforms.com/forums/topic/connection-agent-with-forefront-tmg#post-2501 Wed, 23 Nov 2011 18:37:59 +0000 Dennis @ PerfectForms 2501@http://www.perfectforms.com/forums/ <p>Tomcat installs by default to port 8080. You can configure it to use a different port. The Connection Agent can be configured to accept queries from only specific IPs. If you restrict the IP that can send requests to the Connection Agent, you will have to use the IP address for PerfectForms (The IP address of app.perfectforms.com is 67.192.109.138), and use proxy in all of your connections. Normally queries to the Connection Agent come from the users' browser. Checking Use Proxy will route all queries through the PerfectForms app.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/connection-agent-with-forefront-tmg#post-2499 Tue, 22 Nov 2011 21:55:15 +0000 Maximus5684 2499@http://www.perfectforms.com/forums/ <p>Are there any recommendations out there regarding using the Connection Agent with Forefront Threat Management Gateway? We really want a reverse proxy in front of the connection agent since the connections it makes are so sensitive. What ports need to be open on the front end? Is 80 or 443 sufficient? </p> http://www.perfectforms.com/forums/topic/copy-database-connection#post-2367 Wed, 21 Sep 2011 16:16:44 +0000 Dennis @ PerfectForms 2367@http://www.perfectforms.com/forums/ <p>Once you have your connection and action created it is possible to "re-point" them to a different datasource. In the connection click the button that says "Check". it will then allow you to choose a Datasource and Database from the drop-downs below.<br /> Of course this presumes that all of the send and receive parameters are identical, and that you have properly configured your Connection Agent to map to your datasources.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/copy-database-connection#post-2365 Tue, 20 Sep 2011 22:14:50 +0000 evelina.liu 2365@http://www.perfectforms.com/forums/ <p>Hi, Dennis,</p> <p>Not sure if I am correct - the import/export connection probably works the best for backup purposes.</p> <p>I also would like to know if there is a better solution regarding setting up new database connection. In our case, we have the need to first build out the form to point to test database table(s) (from our other enterprise systems) to test the entire business process. Then when everything is verified, the database table(s) will then be migrated to the production environment - which will then become a different datasource v.s. the test database. When I am getting ready to launch the form (or save as a new form for production usage), is it possible to just make a simple "re-pointing", or optionally import/export the entire connection and action settings/objects, with provided datasource parameters, so that I don't need to reconfigure the entire connection settings/actions and even the form behaviors on the production form? </p> <p>Any suggestion is appreciated. Thanks. </p> http://www.perfectforms.com/forums/topic/copy-database-connection#post-2321 Tue, 30 Aug 2011 23:23:50 +0000 Dennis @ PerfectForms 2321@http://www.perfectforms.com/forums/ <p>Please see our help guide topic on Migrating Connections: <a href="http://www.perfectforms.com/Documentation/manual/html/?admin_migrating_a_connection.htm." rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?admin_migrating_a_connection.htm.</a> You can export it, import it and change the name/details.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/copy-database-connection#post-2319 Tue, 30 Aug 2011 18:26:25 +0000 MABrown 2319@http://www.perfectforms.com/forums/ <p>I was wondering if there was a way to copy a database connection. </p> <p>I have created a clone of an existing database (same server, new database name, same table structure, stored procedures, etc) and I have made a copy of my form. I have also created a new database entry in the config.xml file pointing to the new database. I am faced with the prospect of creating a new connection and manually replicating the actions to connect the form copy to the database copy, unless there is a way to copy the existing connection.</p> <p>Could I export the connection and then re-import it with a new name, and update the datasource/database to point to the new database? Or would that cause conflicts in the system? </p> <p>I do realize that, no matter what, I will have to go into the form an update the connection behaviors, but that shouldn't be too difficult. </p> http://www.perfectforms.com/forums/topic/import-xml-file-to-perfect-forms#post-2252 Mon, 27 Jun 2011 18:23:18 +0000 Dennis @ PerfectForms 2252@http://www.perfectforms.com/forums/ <p>Yes it is possible using the PerfectForms Connection Agent. Please see our help guide about the ConnectionAgetn: <a href="http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm</a><br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/import-xml-file-to-perfect-forms#post-2248 Mon, 27 Jun 2011 03:10:30 +0000 TextInput 2248@http://www.perfectforms.com/forums/ <p>Is it possible to get data from xml file to perfect forms? </p> http://www.perfectforms.com/forums/topic/problems-with-sql-server-2008#post-2236 Wed, 22 Jun 2011 18:04:36 +0000 MABrown 2236@http://www.perfectforms.com/forums/ <p>Success! That worked; thank you very much! </p> http://www.perfectforms.com/forums/topic/problems-with-sql-server-2008#post-2235 Wed, 22 Jun 2011 18:01:23 +0000 Dennis @ PerfectForms 2235@http://www.perfectforms.com/forums/ <p>If you are using the configurator, change the value in the database type drop-down, and then change it back to SQL. Then restart Tomcat and test.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/problems-with-sql-server-2008#post-2234 Wed, 22 Jun 2011 17:52:01 +0000 MABrown 2234@http://www.perfectforms.com/forums/ <p>Has anyone had any issues connecting to a SQL Server 2008 database? </p> <p>I have setup my first connection/action to a 2008 db, and I am receiving the error "Invalid request database type" whenever I try the Auto Complete function.</p> <p>My connections to SQL Server 2005 have all worked, and I can't tell what is different about this connection. </p> http://www.perfectforms.com/forums/topic/select-connection-action-problem#post-2215 Tue, 14 Jun 2011 22:18:44 +0000 Dennis @ PerfectForms 2215@http://www.perfectforms.com/forums/ <p>Ian Jobling addressed this issue in a forum post:<br /> <a href="http://www.perfectforms.com/forums/topic/response-from-a-lookup-action-returns-netsourceforgejtdsjdbcclobimplxxxx" rel="nofollow">http://www.perfectforms.com/forums/topic/response-from-a-lookup-action-returns-netsourceforgejtdsjdbcclobimplxxxx</a></p> <p><a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/select-connection-action-problem#post-2214 Tue, 14 Jun 2011 21:23:40 +0000 MABrown 2214@http://www.perfectforms.com/forums/ <p>I have a connection to a SQL Server database with a basic SELECT action. One of the columns being selected is a VARCHAR(MAX) data type, but the connection returns "net.sourceforge.jtds.jdbc.Clobimpl" followed by an error code. </p> <p>Is there an issue in selecting VARCHAR(MAX) columns? I also have a stored procedure that selects the same column (returned in a result set) and it works fine. </p> http://www.perfectforms.com/forums/topic/functions-with-sql#post-2184 Tue, 24 May 2011 22:29:44 +0000 schaferdg@yahoo.com 2184@http://www.perfectforms.com/forums/ <p>Does this function exist in perfectforms or is there an equivalent mysql_insert_id() in the form builder?</p> <p>We use this when we create a new record in a table and need to know the specific id assigned to that record. </p> http://www.perfectforms.com/forums/topic/connection-timing-out#post-2129 Thu, 21 Apr 2011 15:24:38 +0000 Dennis @ PerfectForms 2129@http://www.perfectforms.com/forums/ <p>What version of the Connection Agent are you using? You can check it by navigating to yourtomcatIP:8080/ConnectionAgent. </p> http://www.perfectforms.com/forums/topic/connection-timing-out#post-2127 Wed, 20 Apr 2011 19:18:30 +0000 pandrews 2127@http://www.perfectforms.com/forums/ <p>So the issue has been resolved, from what I can tell. It was either one of two things. One I was not clearing all of the fields before connecting and searching, which I thought could have been clogging something up. Secondly, and what I think was the issue, is I was using time fields where the user could enter in a work schedule of start and end times for each day. On the SQL server database I was using the time data type to store these fields. These were being stored correctly, but when returning the data types it seems like it was having a problem butting the time data types from the sql server back into the time fields on the form. I changed the data types to varchar and everything works now. </p> http://www.perfectforms.com/forums/topic/connection-timing-out#post-2123 Wed, 20 Apr 2011 14:13:38 +0000 pandrews 2123@http://www.perfectforms.com/forums/ <p>I have created a search page allowing the user to enter an order id and press a search button. I have setup a behavior behind the search button that uses a connection with our SQL Server database. I pass the primary key as the input parameter that the user entered and return all the values from the table back to perfect forms and assign them to the screen. The first time I perform the search the connection and everything works perfectly. When I try to search again, I get the please wait screen and it continues this until I close the session. This was in design mode and me using the preview function. I published the page and tried from the link provided. I had a little more luck being able to search 3 or 4 times but eventually would get stuck again and then I would get a time out box. After hitting the ok button on the time out box my results would then return. Any ideas? </p> http://www.perfectforms.com/forums/topic/enhancement-request#post-2108 Thu, 14 Apr 2011 22:09:29 +0000 Dennis @ PerfectForms 2108@http://www.perfectforms.com/forums/ <p>I will submit the development request for you. I cannot promise that it will be introduced into the application but that is the first step. </p> http://www.perfectforms.com/forums/topic/enhancement-request#post-2107 Thu, 14 Apr 2011 19:00:02 +0000 MABrown 2107@http://www.perfectforms.com/forums/ <p>As our list of forms grows, it is becoming increasingly difficult to manage the many connections associated with those forms. </p> <p>Has PerfectForms considered using folders within the connection types to allow administrators to better manage and organize connections? </p> http://www.perfectforms.com/forums/topic/database-connection-character-limitations#post-2067 Thu, 31 Mar 2011 15:49:31 +0000 Dennis @ PerfectForms 2067@http://www.perfectforms.com/forums/ <p>You are seeing error code 231: Invalid request parameters. Our troubleshooting documentation at: <a href="http://www.perfectforms.com/Documentation/manual/html/?admin_connection_agent_troubleshooti.htm." rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?admin_connection_agent_troubleshooti.htm.</a> says the following:</p> <p>Database ID and/or Datasource ID are not in the request. This means the connection is not correctly configured in the connection details screen (if this occurs in ConnectionEditor when using<br /> "Check" button) or the connection is not correctly saved (if this occurs in Player or MainEditor).</p> <p>We have tested inserting the following text ('“Smart quotes” "plain quotes" en dash (–) em dash (—) ellipsis (…)' ) into SQL server using ConnectionAgent.<br /> The result: success. All characters have been inserted into the database. </p> http://www.perfectforms.com/forums/topic/database-connection-character-limitations#post-2059 Fri, 25 Mar 2011 20:53:41 +0000 MABrown 2059@http://www.perfectforms.com/forums/ <p>I have an issue with a form that updates a database. I have found that, when sending text with certain characters to the database, the update behavior fails and the error "An error has occurred. Invalid request parameters" is displayed.</p> <p>Characters that can cause this problem include quotation marks that are not straight (such as MS Word's Smart Quotes), the ellipsis character, Em dashes, etc.</p> <p>I believe this is a PerfectForms issue, as the Database is able to handle the characters. In fact, PerfectForms is able to retrieve the characters from the database and display them without any problems; the error only occurs when trying to update the database. Are there any ideas as to why this might be? Is there any documentation regarding what characters the Connection Agent can and cannot handle? </p> http://www.perfectforms.com/forums/topic/web-service-connection#post-2005 Tue, 08 Mar 2011 16:04:13 +0000 Dennis @ PerfectForms 2005@http://www.perfectforms.com/forums/ <p>I will be emailing you some examples that demonstrate how to accomplish what you need. </p> http://www.perfectforms.com/forums/topic/connection-agent-configurator-will-not-save-changes#post-1991 Thu, 03 Mar 2011 17:08:33 +0000 Dennis @ PerfectForms 1991@http://www.perfectforms.com/forums/ <p>If your changes to the configuration file are not saving the problems probably comes from the fact that you are running the Connection Agent Configurator without the administrator permissions. When you try to save, an error message will appear. when you run the CA Configurator right click on the icon and choose run as administrator, then you will be able to save. </p> http://www.perfectforms.com/forums/topic/web-service-connection#post-1978 Thu, 24 Feb 2011 18:05:37 +0000 MABrown 1978@http://www.perfectforms.com/forums/ <p>I have implemented a workaround by hosting a copy of the WSDL file on a local web server, but it doesn't fully solve the issue. </p> <p>The Web Service provider for my connection requires the SOAP request contain the "Authorization" header. For testing, the connection works when I disable this requirement, however that is not a practical long-term solution. Is there a way to edit the values in the Authentication header to pass a logon and password? </p> http://www.perfectforms.com/forums/topic/web-service-connection#post-1977 Thu, 24 Feb 2011 17:27:36 +0000 MABrown 1977@http://www.perfectforms.com/forums/ <p>Since I cannot load the WSDL, I cannot create a connection in the first place. Is there a way to create a web service connection that does not use WSDL files? </p> http://www.perfectforms.com/forums/topic/web-service-connection#post-1960 Thu, 10 Feb 2011 19:18:13 +0000 Dennis @ PerfectForms 1960@http://www.perfectforms.com/forums/ <p>I break it down to two connections. In the first connection I return the token and result and store them in hidden fields. In the second connection I send the token and the other send parameters to get what I need from the web service. </p> http://www.perfectforms.com/forums/topic/web-service-connection#post-1958 Wed, 09 Feb 2011 20:11:19 +0000 MABrown 1958@http://www.perfectforms.com/forums/ <p>I am attempting to establish a Web Service connection with a SAAS provider. The provider supports SOAP web services, however their WSDL files are behind their authentication. </p> <p>As a result, unless you are logged in, you cannot connect to the service. They recommend downloading the WSDL file to implement in the application consuming the service, however I don't see how that would be possible with PerfectForms. </p> <p>Is there a way to reference a local WSDL file in a Web Service Connection? If not, is there a way to embed authentication parameters into a Web Service Connection? So far as I can tell they do not have a CROSSDOMAIN.XML file in their root directory, so it needs to be a proxy connection. </p> http://www.perfectforms.com/forums/topic/synchronize-users-with-directory-service#post-1945 Tue, 01 Feb 2011 19:48:29 +0000 evelina.liu 1945@http://www.perfectforms.com/forums/ <p>We are now evaluating the possibility of using "Synchronize" to automatically create user accounts based on defined properties (or filters). For example, to grant Limited User License to all the supervisors in our institution as their "base access" so that they can interact with forms through notification emails. I would like to know how other institutions are managing user accounts and keeping up with them, and how well this "Synchronize" is. Any feedback is appreciated. </p> http://www.perfectforms.com/forums/topic/can-user-roles-be-linked-from-active-directory#post-1846 Wed, 01 Dec 2010 18:34:10 +0000 Dennis @ PerfectForms 1846@http://www.perfectforms.com/forums/ <p>The PerfectForms user guide describes how the Connection Agent enables connections to outside data sources including AD. <a href="http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm." rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm.</a><br /> More details can be found at: <a href="http://www.perfectforms.com/Documentation/manual/html/?directory_services_ldap.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?directory_services_ldap.htm</a> </p> http://www.perfectforms.com/forums/topic/can-user-roles-be-linked-from-active-directory#post-1842 Wed, 01 Dec 2010 11:07:13 +0000 shekar345 1842@http://www.perfectforms.com/forums/ <p>Hi,</p> <p>Is there a possibility where I can integrate the users in my active directory with the perfect forms. So that i can maintain the organizational hiearchy. I should also be able to use the same in Workflows.</p> <p>Thanks </p>