Import historial data in xsl spreadsheet to infopath template.

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Hi,

 

Have a really strange issue here that I can't figure out and wondered if any of you have had this issue?

Basically we have 5 libraries and the infopath form moves between them and there is consistent promoted fields in all the libraries.

We have 4 forms per lib with all the same properties promoted.

But one of the forms does not seem to show it data in the table view (you can see it in edit form (SP Page)???) for lib 4 (it shows in all the others).

 

I can't determine why this is occuring and what I need to do to fix it.

Hello

When I try to upload form template that uses “Data Connection”,  I receive the following error any idea “The data source referenced in the form template is not valid or not found”

Any idea ?

Thanks

 

---

Momo

I created an InfoPath template part using an XSD.  I added it to my custom controls, but when I try to insert it into the main template, it asks to be bound to a data source.  I have created a group to bind it to in the data source, and I created a "complete XML document or schema" based on the same XSD as well.  It matches the schema in the template part exactly.  The template part won't bind to either node.  I get the error message, "Requirements_Template_Part cannot be bound to the selected field or group." 

 

This XSD is complex and contains a repeating table.  I read somewhere that this might be a problem.  Unfortunately , the XSD cannot be changed much though this is a format imposed on us from another group.  A coworker is writing a transform to cull out the data from this XSD and feed it into another system.  He says he will update the XSD from time to time, and I thought that a template part would make it easy for me to update it whenever he updates his XSD.

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.

Hi

I'm seeing some very strange behaviour with some browser based Infopath forms.  The user is trying to fill the infopath form using safari on the Mac and when the user hits the submit button the form reset itself.

An other behaviour is that when the user click on a form field all the form fields will automatically populate one value.  This happen intermittently.

We have two load balancing web front ends. Server1 and Server2 the users that a reporting this problem get served by Server1 when I test on my Mac to replicate the problem the request get served by Server2. This problem occurs on different forms across the sharepoint implementation.

Can anybody shed any light on the problem?

 

Thanks

Dominic

Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

Overview

 

We are currently using SharePoint Server 2007 and have multiple InfoPath lists configured and one workflow tasks list. We have workflows configured for these InfoPath lists using Visual Studio to design these workflows and use InfoPath forms as the main document. After using the workflow items for a while we have changed and upgraded the workflow for the last year. The issue came when we tried to upgrade to the third version we designed.

 

Issue

 

We have two InfoPath lists in SharePoint that have identical form templates. In both lists there are around 3000-3100 InfoPath forms give or take. I modified the template to accommodate some new fields and promoted additional fields but did not go over the

Hello, I am using the following Style on a custom TabItem that I am using: <Style TargetType="{x:Type local:GSFTabItem}"> <Style.Resources> <cmn:EnumDisplayConverter x:Key="Converter" Type="{x:Type crys:GSFOperator}"/> <local:GSFTabVisibilityConverter x:Key="visibility"/> </Style.Resources> <Setter Property="DataContext" Value="{DynamicResource GSFObject}"></Setter> <Setter Property="Header" Value="{Binding Field}"/> <Setter Property="Content" Value="{DynamicResource GSFObject}"/> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type local:GSFTabItem}"> <Grid> <Border Name="Border" BorderBrush="Black" BorderThickness=".5,.5,.5,0" Background="White" > <StackPanel Orientation="Horizontal"> <Label VerticalAlignment="Center" HorizontalAlignment="Center" Content="{Binding Field}"/> <Label Content="X" IsHitTestVisible="True"

I am trying to download wirelessly or cradled, data from 3 Access 2003 tables into my SQLCE 3.5 datatables. I already have a successful method + web method that uploads data from my sqlce datatables into the Access 2003 tables. I just need feedback to know if I'm headed in the right direction. Web method: Public Function UpdateSqlCeData(ByVal downloadSet As DataSet) As Boolean ' Connect to Access DB here, execute command and populate data set with returned data. Me.Server.ScriptTimeout = 600000 Dim strSql2 As SqlCeCommand Dim oleDbDataset As System.Data.DataSet = New DataSet Dim sqlParam As New SqlCeParameter Dim fhAccDt, fhCeDt As New DataTable strSql2 = Nothing sqlParam = Nothing 'Connection string to connect to access DB Dim FHLiveDB As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testpre\testservertest.mdb") Dim Pbrd As New OleDb.OleDbDataAdapter("SELECT * FROM tblProductBrand", FHLiveDB) FHLiveDB.Open() Pbrd.Fill(oleDbDataset) With strSql2 .CommandTimeout = 600000 .CommandText = "INSERT INTO Product_Brand ([BrandID],[Brand_Name]) VALUES (@Brand_ID,@Brand_Name)" sqlParam = .Parameters.Add("@Brand_ID", SqlDbType.NVarChar, 50, "Brand_ID&

i m having excel file a.xlsi m having gridview1,fileupload1how to import excel file from fileupload1 get the destination of a.xls and show the values in gridview1if any boby knows full code answer/mail me at ponmanivannangj@mobiusservices.in

I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

Hi, I am having sharepoint 2010 RTM trial on Windows Server 2008 SP2. I want to populate csv filke data to new sharepoint list. I am using custom List Wizard to achieve this... When I Import csv on server then everything is fine but when i inport csv from client, i get the following error "The Specified is not valid Spreadsheet or contains no data to import" I have also checked to import excel workbook but it gives the same error on client and do great on server..... can anybody have any idea what is wrong ?? thanks

We are in the process of shifting our draft system from SP 2007 to SP 2010 and we are re-visiting our Infopath forms service. Admin approved IP forms,  the templates emailed to our 12 remote 'offices' 12 Site collections -identical structure for remote locations 12 Remote user locations, never connected! ,fills in the form, selects own site, and emails back to office Custom button on form with rules reads 'selected site' and uses appropiate data connection to submit to correct Site Collection/Form Library. We are only using 1 site at the moment but obviously with 12 sites it becomes unmanagable, my thoughts;- Can we use a web service to act as an intermediary to point to correct library? Would a dataconnection library help?, or is the amount of work the same? ??? casey  

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Hi All, Trying to use SSIS SQL 2005 to import an Excel 2007 file (.xlsx). I'm using Office 12.0 Access Database Engine OLEDB Provider with extended properties Excel 12.0;HDR=Yes;IMEX=1 The problem is when I have text with more than 255 characters. It basically defaults the source output to Unicode string[DT_WSTR] 255, If I change it it errors out. I have done the registry change according to http://msdn.microsoft.com/en-us/library/ms141683.aspx but I think it only applies to Excel source not OleDb Source. (A Excel source does give me a text instead of string )   I have also tried to increasing the length of output such as 4000 instead of 255 but it doesn't allow either.   Anybody can help?I'm stuck for a day. Thank you very much for your help. Regards, Koala  

This is not a programming question, I simply have a lot of data in two columns in an excel spreadsheet of data that I gathered.  I want to copy and paste this (manually) into a table that I have created in my ASPNETDB in my ASP.NET web application.  I thought it'd be as easy as copy the column, and hit paste in the "table data" view, but it's not (it only pastes one cell).Is there a way for me to manually copy data from excel and paste it in a table in my SQL Server?Thanks in advance! :)