PerfectForms Forums: Forum: Integrating PerfectForms

PerfectForms Forums: Forum: Integrating PerfectForms - Recent Topics http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 04:14:16 +0000 Maximus5684 on "Connection Agent with Forefront TMG" 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/ 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? MABrown on "Copy Database Connection" 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/ I was wondering if there was a way to copy a database connection. 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. 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? 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. TextInput on "Import XML file to Perfect Forms" 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/ Is it possible to get data from xml file to perfect forms? MABrown on "Problems with SQL Server 2008?" 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/ Has anyone had any issues connecting to a SQL Server 2008 database? 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. My connections to SQL Server 2005 have all worked, and I can't tell what is different about this connection. MABrown on "SELECT connection action problem" 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/ 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. 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. schaferdg@yahoo.com on "Functions with SQL" 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/ Does this function exist in perfectforms or is there an equivalent mysql_insert_id() in the form builder? We use this when we create a new record in a table and need to know the specific id assigned to that record. pandrews on "Connection Timing Out" 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/ 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? MABrown on "Enhancement Request" 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/ As our list of forms grows, it is becoming increasingly difficult to manage the many connections associated with those forms. Has PerfectForms considered using folders within the connection types to allow administrators to better manage and organize connections? MABrown on "Database Connection Character Limitations" 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/ 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. 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. 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? MABrown on "Web Service Connection" 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/ 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. 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. 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. Dennis @ PerfectForms on "Connection Agent Configurator will not save changes" 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/ 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. asrivastav on "Synchronize Users with Directory-Service" http://www.perfectforms.com/forums/topic/synchronize-users-with-directory-service#post-1474 Tue, 01 Jun 2010 16:10:28 +0000 asrivastav 1474@http://www.perfectforms.com/forums/ I know that the "Synchronize" process is one-way such that user information flows from the Active Directory Service to Perfect Forms, and not the other way around. With that said, is the synchronization from AD to Perfect Forms 'live'? Meaning, if user data changes in AD, will that information be automatically updated/reflected in the Perfect Forms user account? Or would we have to re-synchronize the users from AD to update user information from AD to Perfect Forms? Thanks, Avaneesh shekar345 on "Can user roles be linked from Active directory" 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/ Hi, 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. Thanks peter.tyrrell on "Load Image via Connection" http://www.perfectforms.com/forums/topic/load-image-via-connection#post-196 Mon, 02 Mar 2009 01:10:17 +0000 peter.tyrrell 196@http://www.perfectforms.com/forums/ I want to be able to retrieve an image that is stored in an MS SQL database. Is there any way to do this? shaiky1 on "problem writing to sql tables" http://www.perfectforms.com/forums/topic/problem-writing-to-sql-tables#post-1632 Mon, 16 Aug 2010 08:36:28 +0000 shaiky1 1632@http://www.perfectforms.com/forums/ Hi, I am trying to use a connection to write to Microsoft Dynamics NAV, and when the connection tries to insert data, I get the following error: An error has occurred Agent SQL error Error converting data type varchar to numeric. This occurs even when I am trying to send data to a field of data type "text", so I dont understand what is being converted to numeric. Any suggestions? MABrown on "Form Insert Error" http://www.perfectforms.com/forums/topic/form-insert-error#post-1645 Fri, 20 Aug 2010 14:14:46 +0000 MABrown 1645@http://www.perfectforms.com/forums/ I am having an issue with a form connection. I setup an Insert action, but when I try to test the action, I get the following error: Form connection error The given key was not present in the dictionary. MABrown on "determine dependencies" http://www.perfectforms.com/forums/topic/determine-dependencies#post-1620 Mon, 09 Aug 2010 18:19:26 +0000 MABrown 1620@http://www.perfectforms.com/forums/ Is there a way to easily determine dependencies of connections? For instance, if I have a connection to a database that is used by multiple forms (such as an LDAP server), is there a way to determine which forms use which actions within that connection? seraph on "Recordset Returned via Stored Procedures" http://www.perfectforms.com/forums/topic/recordset-returned-via-stored-procedures#post-1303 Tue, 23 Mar 2010 12:52:12 +0000 seraph 1303@http://www.perfectforms.com/forums/ Hello, Can PF support returning a recordset result set from a stored procedure call call? Thanks trenthem on "Request for Code Sample" http://www.perfectforms.com/forums/topic/request-for-code-sample#post-1495 Fri, 11 Jun 2010 21:26:44 +0000 trenthem 1495@http://www.perfectforms.com/forums/ I'm looking into the external call function pf_call() and am intriqued by the possibilities there. I've read the online docs, but still haven't produced a working form. I'm sure I'm having some kind of simple syntax error. Are there any "Hello World" style examples of this technique? asrivastav on "Published Forms and Active Directory" http://www.perfectforms.com/forums/topic/published-forms-and-active-directory#post-1475 Tue, 01 Jun 2010 16:34:22 +0000 asrivastav 1475@http://www.perfectforms.com/forums/ Is it possible to custom integrate a published form such that when it is made available on our intranet (which uses AD for authentication), it can pre-populate form fields based on the logged in user? i.e. first name, last name Thanks, Avaneesh capson on "Connect and Search" http://www.perfectforms.com/forums/topic/connect-and-search#post-1481 Sun, 06 Jun 2010 13:44:39 +0000 capson 1481@http://www.perfectforms.com/forums/ I have a Survey form(1) and a lookup Table form(2) that I want to use to auto populate form's(1)census data when a email address on form(1) matches a email address in form(2)(form(2)has only unique entries). To this end I made a connect and search command this works but I need to suppress the popup window and just go directly to populating form(1) fields with the returned data. Is this possible I have looked for a way to do this but can not find how. Thank you Tim swm on "Sending tabular data to a web service method" http://www.perfectforms.com/forums/topic/sending-tabular-data-to-a-web-service-method#post-1416 Thu, 13 May 2010 17:02:26 +0000 swm 1416@http://www.perfectforms.com/forums/ Is it possible to link multiple table rows to a web service method parameter? I have a table that contains a list of items that I want to send to a list/collection object that is a paramter on a web service. When I tested the call to the web service, the service only retrieve the first row instnace data. it di not receive any data from the remining rows in the table. dgordon on "Log function (mathematical)" http://www.perfectforms.com/forums/topic/log-function-mathematical#post-1380 Mon, 26 Apr 2010 20:48:02 +0000 dgordon 1380@http://www.perfectforms.com/forums/ If I wanted to calculate the log of a value, what would be the best way to achieve this as there are no native funstions in pf that seem to be able to do this. Should this be done via javascript or should I create a web service to do this or any other suggestions? Peanuts890 on "Accessing all form instances" http://www.perfectforms.com/forums/topic/accessing-all-form-instances#post-1034 Mon, 21 Dec 2009 09:53:35 +0000 Peanuts890 1034@http://www.perfectforms.com/forums/ I have an employee database (employee_name, data 1, data 2, etc.)made up of a form instance for each employee. The database is usually accessed by another form through a connection which searches for a single name and returns all the data plus the instance ID. This second form can then update some of the data. This all works fine. I have a requirement to access EVERY form instance of the database and update one of the data items based on the value of another data item (in the same form instance). Is there a global way of doing this without having to select each form instance by employee_name one at a time, and if so can it be done from a report (acting as a portal). Thanks MABrown on "Access SQL Server using Active Directory account" http://www.perfectforms.com/forums/topic/access-sql-server-using-active-directory-account#post-1026 Wed, 16 Dec 2009 22:30:03 +0000 MABrown 1026@http://www.perfectforms.com/forums/ We have PerfectForms on-premise with PerfectForms Agent connecting to a SQL Server database. Our current configuration uses SQL Server based accounts for database access, but we want to change to Active Directory accounts for management purposes. We have created an AD account specifically for this purpose, granted it permissions on the server and in the database, and updated config.xml; but for some reason, PerfectForms Agent will not connect using this account. I repeatedly get the error, "Connection failed:Agent system error Login failed for user '<username>'." When I check the PerfectForms Agent Logs I see the error, "ERROR: Exception in GetColumnNames service: Login failed for user '<username>'" When I check the SQL Server logs, I see "Login failed for user '<username>'." and "Error: 18456, Severity: 14, State: 5." In the config.xml file, I have tried just the username, and combination of "<domain>\<username>". (Note: when using "<domain>\<username>" the SQL Server logs show Error State: 6, instead of 5). I don’t know if this is a SQL Server issue or a PerfectForms issue. Any ideas? llewis on "Build an LDAP action that retrieves Manager email?" http://www.perfectforms.com/forums/topic/build-an-ldap-action-that-retrieves-manager-email#post-425 Fri, 22 May 2009 19:33:41 +0000 llewis 425@http://www.perfectforms.com/forums/ Hi, we're using the Gateway-HTTP User field to bring in the username of the person filling out the form, then we're using that to automatically pull back fields from Active Directory, including the "manager" field. Now, we need to use that "manager" field in another action to pull in the manager's email address. Can someone provide guidance on how I can accomplish this? Thanks! capson on "veiw all orders" http://www.perfectforms.com/forums/topic/veiw-all-orders#post-882 Sat, 24 Oct 2009 02:28:12 +0000 capson 882@http://www.perfectforms.com/forums/ Hello, I am using a form connection much like method 4 in the parent child example of connecting a parent form to a child form. On my main (parent form) I have a page that saves all instances of my survey, again like method 4 were the main page has a orders (parent) page that save a references to each instances of the orders form(child. Every thing seems to work except I can not get the orders form(parent) to save each reference to each instance of my survey, all I does is save a reference the last instance of my survey. If I test my connection I get a return of all instances of my survey. I have tryed and tryed but I can not figure out were my mistake is being made. Thanks for any help. Hatano on "Connect behavior Field Value Character Limit" http://www.perfectforms.com/forums/topic/connect-behavior-field-value-character-limit#post-274 Mon, 06 Apr 2009 08:23:32 +0000 Hatano 274@http://www.perfectforms.com/forums/ When I try to populate a field from a connect behavior or Set Field from Other Instance behavior, the number of characters it shows seems to be limited. There is also a double-byte character problem when running a Set Field from Other Instance behavior. Are these limitations of the system or am I doing something wrong? What is the character limit for connect or field-set behaviors? ijobling on "Database Insert is not returning NULL to a datetime field" http://www.perfectforms.com/forums/topic/database-insert-is-not-returning-null-to-a-datetime-field#post-788 Fri, 25 Sep 2009 08:20:16 +0000 ijobling 788@http://www.perfectforms.com/forums/ Inserting or updating data into a database table with a field of type "datetime", where no data is updated from the form expectation is that NULL should be stored in the database table. However when the database is queried later, with a SELECT action it returns, but 1900-01-01 00:00:00.000 This is 'expected' behaviour of SQL The dynamic query will insert default value for date and this can only be handled with a stored procedure where you check for null or empty string and set it with their own value or NULL. This limitation is not because of Perfectforms but because of how MS-Sql works. See below the example for the sql stored procedure example: ALTER PROCEDURE InsertDateTimeNullTest -- Add the parameters for the stored procedure here @FirstName varchar(50), @LastName varchar(50), @DOB datetime = null AS BEGIN IF @DOB = '' OR @DOB IS NULL BEGIN SET @DOB = NULL END -- Insert statements for procedure here INSERT INTO [DateTimeNullInsertTest] ( [FirstName], [LastName], [DOB]) VALUES ( @FirstName, @LastName, @DOB) END ijobling on "When trying to set up a connection I get : Agent communication error fault" http://www.perfectforms.com/forums/topic/when-trying-to-set-up-a-connection-i-get-agent-communication-error-fault#post-753 Thu, 10 Sep 2009 08:39:38 +0000 ijobling 753@http://www.perfectforms.com/forums/ Details shown are: Connection failed: Agent communication error faultCode:Channel.Security.Error faultString:'Security error accessing url' faultDetail:''Destination: DefaultHTTP' Check that you are calling the correct URL and if so, The error message (faultCode:Channel.Security.Error faultString:'Security error accessing url' faultDetail:''Destination: DefaultHTTP') can occur because your Tomcat server might not contain that crossdomain.xml or the file has been copied in the correct location without restarting Tomcat server. Another possibility is that you have a firewall that blocks crossdomain.xml from loading.