SQL Database Integration

Hello, where does the sharepoint db saved list or library data with Infopath store in the sharepoint database? how do i reach

merturk — Mon, 28 Aug 2023 19:33:38 GMT

Hello, where does the sharepoint db saved list or library data with Infopath store in the sharepoint database? how do i reach

problems receiving data from stored procedure

desasaurus — Fri, 11 Nov 2022 15:26:15 GMT

I'm having problems with a form handed down to me. we recently went through some changes with the stored procedure and it now requires an additional parameter. we've been using the modifysqlquery command in qrules to achieve this, however after altering the procedure and adding the additional parameter, the query returns nothing. no errors or connection problems or anything. I've used wireshark to determine that the data is in fact being sent to and loaded from the server, but it isn't populating in the form. Is there something I'm missing other than changing the parameters?

Office 365 and Oracle datasources

William Ellsworth — Thu, 31 Jan 2019 18:38:41 GMT

Hi, I'm not sure if this is the correct forum for this question so please redirect me if that is the case. We have Office 365 at work and use SharePoint in the cloud. I would like to create a data source in Infopath 2013 to an Oracle database that sits on a physical server in my employer's datacenter. As I do not have access to the SP server to install the Oracle client side libraries, what do I need to request be installed on the SP server in order for me to create my Oracle datasource? Thank you in advance.

Populate Text Field based on dropdown selection value

Anubhav — Fri, 12 Apr 2019 03:04:16 GMT

Hi Experts!! I have just started with InfoPath Development. So I was designing forms based on SQL DB as the backend. So there are just 2 fields in this form: 1 Drop down (which I want to autopopulate on loading of Form) & Text field ( which I want to fill based on the selection of dropdown value). 1) I have not designed this as Database Form as I was not able to populate the dropdown ( Basically i could not find the checkbox of "Autopopulate on load" in wizard) 2) Then I have designed this as a Blank form in which I was able to auto populate the drop down values. Now comes to filling of Text field, so I have adopted this approach: a) On this drop down created a Rule 1 to query the SQL Table. b) Then created Rule 2 - "Set the field value" in Field as "datafield" of Table (text field) and Value as same data field (of SECONDARY CONNECTION) with filter ( dropdown value as equal to dropdown-like field in "datafield"). Issue: Now my dropdown is filled only first time and is NULL on change of dropdown value. So I am not able to ppulate my Text field. Also i have a curiosity that why these Blank Forms does not have queryfields and only DataFields? Any help will be much appreciated.

Populate sql connected repeating table

ek38 — Fri, 25 Jan 2019 15:40:48 GMT

Each employee is required to do things for health insurance requirements. e.g. Get physical, take a health survey, attend wellness day etc. We have an infopath form that has a nested SQL DB connected tables. Table Employee Table Requirements (this would be a repeating table) The Employee is a single row in a database The Requirements is a multiple row per employee tracking if they met all the requirements. So when a new user creates a new form for their employee record, how can I have them click a button and pre-populate the Requirements repeating table with the current years Health Insurance Requirements. Once the data is displayed for the user, the can check fields to say they got their physical, completed the health Survey ---and hit Submit--- and have that data recorded to the Requirements table. I do not want to set defaults on a repeating table as that is hard coded. I want to pull the data from either a DB table or a Sharepoint List.

2 tables submit in one form

Abdul Rahman — Wed, 18 Apr 2018 11:51:44 GMT

Hi, Is not possible to submit to 2 SQL tables from one form? Because, i have 2 SQL connections now in data connections, first one is allowing submit, second one does not !. If create a new form using second connection as first, then that one works and the other one does not work !. I mean, only 1 connection is working for submit in one form? is it like this, or I am doing any thing wrong? !

submit to sql

Abdul Rahman — Wed, 21 Mar 2018 06:59:28 GMT

Hi, I am new to infopath, programmer for some other application. retrieving data from sql is working. Anybody give me an idea or link where i can learn to submit data to sql in infopath2013? I've trying this for 1 week in online, no help. Thanks,

Query to SQL server yields a weird error "The XSL transform for the View XSL failed. Not enough storage is available to complete this operation."

jharih1 — Wed, 28 Mar 2018 18:14:59 GMT

Hi all, I have built an InfoPath 2013 filler form that has a manual query connection to a SQL server table. I had to build it this way because the data is too huge. However, I am getting an error when trying to query the DB: The XSL transform for the View XSL failed. Not enough storage is available to complete this operation. What does this mean? Has anybody else had this error?

SQL Query with repeating table

jharih1 — Tue, 13 Mar 2018 13:54:15 GMT

I tried searching for this topic, but couldnt find anything that I could use. I have an Infopath 2013 form, which pulls some vendor name and number info from a sql server (about 65000 records). I originally had this connection automatically connecting, but because of the size of the database - I am doing a manual query. So I have a field - VendorSearch, on each line of the repeating table, where user will enter a vendor name. The search will look up records in the SQL DB - and give a pull down list. The first line works perfectly. Problem happens when I add a new line - the query is stuck on the first search. I would like to requery the data for the new info user will need.

Datetime filter not working

Preeti1309 — Fri, 03 Nov 2017 12:58:26 GMT

Hi All,

I have a SQL server database table with a column called Observation_Date in it which is of datetime format.

Scenario:

Step 1: When users opens the form first user should get a Date picker.

Step 2: Once the user picks a date, another dropdown listbox should come with all the Observation_Dates for the selected Date picked via the date picker in Step1.

Step 3: Once the Observation_Date is sleected, a repeating table should display all the data against that Date and time selected in Step 2.

I am trying to achieve this form 2 days but no success :(

Thakns & Regards,

Preeti

Infopath form with multiple SQL tables.

Preeti1309 — Thu, 05 Oct 2017 18:16:36 GMT

Hi All,

I am new to InfoPath. Got some requirements from my users. Stuck at few. Didn't get much help on web but found this portal where InfoPath champs are sharing there valueable feedbacks and suggestions. Any help will be much appreciated.

Let me explain my requirement step by step. Please let me know if some one can help me on them.

Form1: In the below Form user can enter a location and select applicable parameters for those locations via check boxes. For example for Location 07 Header(row 1 in form) only Grav, Methanol and Avg BHP values are checked. So once the form is submitted the corresponding Location gets entered into SQL server table (say table 1) shown in right (Applicable parameters will have value 1 and not applicable parameters will have value NULL)

Form 2: form2 will show the Location that we configured in Form1 via a dropdown list box and the applicable parameters as text box, where users can submit the values.The submitted values will be saved in a SQL server table (Say table 2, shown in right).

My first requirement: The value that is greyed in below form, should be grayed dynamically based on the values that we configured in Form 1/Table1. For Example for Location 07 Header, if you see Form1 S&W and Methanol is unchecked/Null. So in form2 it should be dynamically greyed out and users should not be able to enter the values. (Currently I have done this in form2 for each location manually)

Requirement 2: This requirement is also in Form2. Users need 5 comment boxes at the end of each parameter as shown below in red text.

On click of submit, data should be saves in DB corresponding to each location. in the table2. Table 2 will have 5 new columns for each comment

For example if user enters comment in comment box for API Gravity as "XYZ" then in Table2 I will add one more column Comment API Gravity and that XYZ should be shown for All 5 locations as shown below (right hand side.)

Requirement 3: Using the same table and columns shown in step 2/ Table2. I want to create a form that should look some thing like this

Thanks & Regards,

Shilpa

Passing Parameter to Infopath from ACCESS 2010

Massa — Thu, 07 Sep 2017 17:27:16 GMT

Is it possible to pass a sql parameter to the Main connection of an InfoPath form. When I open INFO path from access, I use objIP.XDocuments.Open ("\\OurServer\test\test.xml") Is there syntax to add to this line, like FieldName = "X"?

Populate username in infopath 2010 form from Access db. Do not have sharepoint.

Massa — Tue, 12 Sep 2017 00:03:12 GMT

Survey form needs Yes/No responses from an email. Is there a way to get the username of the person filling out the form. I cant find anything on the internet, except for using sharepoint, which our company doesn't use. Does anyone know how to do this? I tried referencing the operating system's whoami, but couldn't get it to work. Any help would be greatly appreciated!

Select individual rows in a repeating table to populate another repeating table

altamiranm — Fri, 23 Jun 2017 22:26:04 GMT

I am trying to figure out how to allow users to populate a repeating table with information and then to have them select certain rows in that table and have it populate another repeating table. The form has a database backend, so the second repeating table is from the database. So, basically I have a repeating table whereas individuals participate in an event, but some of those individuals need to be billed while others do not. Those that need to be billed get selected and fed into the billing database table. Hope that makes sense. I do not use Qdabra qRules and do not have the resources to use them so I have to do this through some other means. Any help would be awesome. Thank you.

SQL QUERY RESULTS

Arvind — Fri, 19 May 2017 14:39:17 GMT

Hi, I have two date fields, and a SQL query result box in a Repeating Table, How do I get it work so that if somebody selects the dates in the two fields, the result box queries the data between those dates in a repeating table. I am not using Sharepoint but is making this form as a Report that pulls data from SQL which is entered through the main form. Makes Sense. Hope to get some results.

Repeating Tables and DB

jacobostop — Thu, 19 Mar 2009 19:03:08 GMT

Ok this might be hard to explain. I have a repeating table that is stored in a InfoPath 2003 form. This form has the following type of layout

TYPE ( )

____________________________________________________________

Date ( ) Review ( )

The user wants to have the type stay at the top of the repeating table. So I put it in the table header and then in the repeating section of i have the date and review. Now they are able to submit the date to the table, the only problem is that i want the type to be included in every row that gets submitted to the DB but it only seems to happen on the first data entry.... Please someone help.... I have been trying to figure this out for awhile.

Getting a sporadic "cannot insert duplicate key row in object with unique index"

brandtsmith — Wed, 28 Dec 2016 16:15:48 GMT

I have a table with a unique index constraint that works great 98% of the time. Occasionally, I will get the duplicate key error when submitting - but the row is definitely NOT in the table. If I make a small change to , say a note field, in another row and submit that THEN go back and add the row IP complained about previously then the row is accepted and no error message. Almost like a diffgram error?

Anybody seen this before?

Infopath Form with Sql Server 2012

venkatsriram — Tue, 29 Nov 2016 14:30:21 GMT

All, I am trying to connect Sql Server with Infopath form. Design form based on the Table structure as mentioned below: Ref Link The database connection works in Sql authentication. The form is set to be published to windows Share folder. How could the connection string be encrypted (Is it possible). Would it be possible to embed a encrypted connection string with in Infopath form and decrypt at runtime. Appreciate your inputs. Regards, Venkat

Pre-populating repeating section from database.

kee81 — Tue, 25 Oct 2016 14:52:38 GMT

Having some trouble figuring out how to pre-populate my repeating section in InfoPath. Here's my scenario. I need to provide some production personnel with a form that lets them submit production data to the database. I have a form that has a repeating section that lets them submit whatever number of rows they need to. Each row represents the production numbers for a given part on a given shift. Often times the full production run of these parts might take several days, sometimes weeks to complete. At the end of a shift, a supervisor will look over the numbers carefully and submit them to the database via the form. Then, when the next shift's supervisor opens the form, I want the last shift's record rows to auto-populate in the form upon opening, so that they don't have to fill in 20 rows of part numbers for parts that still have many shifts to go before the order is complete. I have the query worked out to get these "last shift's numbers" records from the SQL Server, and I know InfoPath can query the server, but I can't figure out how to get InfoPath to populate that repeating section based on it. I have a main connection set up that allows me to submit the form data. I created a secondary "retrieve data" connection to query the data, but I can't figure out if the query is truly working or not, or how to get that queried data to my form. Thanks for any help or direction!

Increase Timeout length when creating a SQL data connection

CCBSFranco — Thu, 01 May 2014 16:09:24 GMT

Hey Everyone. I am creating a Database Form and am attempting to add a secondary data connection. I have a SQL query that timesout on the initial creation of the connection when I attempt to "Test connection" or hit "Next" after editing the SQL command.

Normally I would add a where clause into the query and limit its size to create the connection then I would convert it to a UDCX and remove the where clause. Then I could use the ModifySql command to fire my query with the where clause when I needed the data. In this case I cannot use the UDC.

Is there a way to increase the timeout length so that I can create the data connection I require?

Submit to Microsoft SQL Server

biddlesby — Fri, 26 Sep 2008 14:38:58 GMT

I believe this is a common problem but I couldn't find a solution.

I set up a main data connection to my sql server and I get "submit status: Not allowed - a SQL JOIN statement was used". Firstly, why should this be a problem?

The thing I am confused about is I get this error even when I have only added one table. How can there be an JOIN when there is only one table?1?

Many thanks,

Harry

Auto populate - only adds data from first row in SQL database

frymic — Tue, 20 Sep 2016 20:00:16 GMT

Good afternoon, I am trying to develop a form that can pull data from a SQL Server secondary data source to populate a Client Info section (Client ID, Name, Phone, etc...) and then from there have a their order appear in a Repeating Table. The client section will currently populate with only the first row of information in SQL. When I try to query for a different record no records appear. I have been able to get the repeating table to filter the data to show only the individual client's order but do not know if this is causing a problem with the client section. I have read this post (http://www.infopathdev.com/forums/t/8421.aspx?PageIndex=1) but the methods here do not seem to work with SQL only Access and Sharepoint. Any help would be greatly appreciated. Thanks

UDCX stored proc not working - sometimes

brandtsmith — Wed, 13 Jul 2016 17:45:14 GMT

Been a while since I've posted here...but the issue I am having is using a SQL stored proc (as a secondary data source) that I created a UDCX file from and uploaded to SP ....on a new form it works as expected...but if I have retrieved a record via a query, the UDCX secondary data source does not return any rows...the sql statement is correct...just no data...when I deleted the UDCX data source and re-created it to be an internal data source it works as expected in all scenarios...so for kicks I added the udcx data source back in and again - no rows after I queried a record....took it back out and re-created the data source internally again and all is fine.

????

Fetching data from Sql database with millions of records

Harman2685 — Tue, 08 Mar 2016 16:53:43 GMT

Hi All, I am working on a requirement where user needs to enter first name , last name and all matching records will be pulled from database and displayed . I have created a SQL Server dataconnection and used repeating section to display the data. But when i click on button, i get timeout error. Is it that as database has 8 million records, initially it will pull all the records? Can we filter the data to be pulled from database? If not, what is the best approach to implement this requirement. vl really appreciate if anyone can help me with this Thanks Harman

Using textbox entry to set SQL data connected dropdown

RubyScye — Fri, 14 Aug 2015 19:51:55 GMT

Hi all,

I have a form (InfoPath 2013) that connects to a SQL view with just 2 columns - ItemNum and ItemDesc. I have created the connection in InfoPath and it pulls the data fine (tested with a repeating table to be sure it's getting all the data).

The backward requirement I have for this form is that there is a textbox (ItemNumberEntered) on the form where the user will type in the Item Number data themselves.

When they type in an item number, I need for another field called ItemDescriptionPulled to populate with the ItemDesc *if* it exists...otherwise it stays blank.

So I have my ItemNumberEntered textbox and my ItemDescriptionPulled rich text field and my SQL view connection. I have tried to set ItemDescriptionPulled's default value to the ItemDesc where ItemNum = ItemNumberEntered and it stays blank (even when I KNOW the entered number is correct and there is a description).

I have tried to run a rule that when ItemNumberEntered is changed the ItemDescriptionPulled is set to ItemDesc where ItemNum = ItemNumberEntered. It stays empty.

Then I bound the ItemNum from SQL to a dropdown (SQLddHolder), and set it's default value to be = ItemNumberEntered. This did indeed seem to work and when the textbox ItemNumberEntered changed it changed the dropdown.

I then tried with rules and setting default value on ItemDescriptionPulled to be equal to ItemDesc where ItemNum = SQLddHolder. Nothing - it would stay blank. But if I manually changed the SQLddHolder to some other ItemNum then the ItemDescriptionPulled box would populate with data.

When I did that, I noticed that the text entered by the user would end up in the dropdown list....even if it was already there. So if a user typed in 111-111-001, the dropdown would look like it populated correctly, but if you expand the dropdown there are now 2 entries of that number. The first one leaves the ItemDescriptionPulled blank, but change it to the other one and the data populates like it should.
I've done Google searches and this apparently should not be such a difficult and time consuming setup. I even found this thread - http://www.infopathdev.com/forums/p/28187/97316.aspx but nothing I've tried is working rules or otherwise.

I hope I explained it clearly enough....Is there something I'm missing to get this to work? It seems like it should be a quick and easy thing.

Thanks for any help/suggestions,
Ruby