Est. Time: Less than 1 month, Less than 10 hrs/week
A number of InfoPath Forms and IPFormViews with C# code-behind must be made available through SharePoint 2013 Forms Service must be converted to HTML5-forms.
Before ”bulk-conversion” is initiated a Proof-Of-Concept shall be conducted.
The following prerequisites and requirements has been identified.
1.1 Data - read
The existing InfoPath-forms *read* data via SharePoint data connectors (.UDCX’s) partly utilizing Sharepoint’s FormsServiceProxy and pointing to:
a. custom REST-services
b. SharePoint Lists
c. SharePoint SOAP (e.g. UserProfileService)
d. custom SOAP-services (asmx).
1.2 Data - write
The existing InfoPath-forms *write* data via SharePoint data connectors (.UDCX’s) partly utilizing Sharepoint’s FormsServiceProxy and pointing to:
a. custom SOAP-services (asmx).
2.1 Platform support
The HTML5-forms must be fully functional on the following platforms:
a. SharePoint Server (WebPart)
b. IE9 and above
c. Smartphone (Android 5, iOS 8 and Windows 8/Universal – and above)
All forms must pass HTML5 validation.
2.3 Offline application capability
The HTML5-forms must be made off-line available by means of HTML5 Application Cache.
2.4 Offline data capability
Parts of the data read and (to-be) written must be off-line available by means of HTML5 IndexedDB (IE 10+).
The goal is to have an InfoPath form on a SharePoint site that is able to send and receive values with an Excel workbook template. Then when the form is submitted the excel workbook will be saved with the data from the form.
The attached WB sits in a excel document library on the SharePoint site and is the template. I have an InfoPath form that submits to its own library and a workflow that runs when a form is submitted. The workflow creates a new list item in the excel document library with the data from the form. The VBA in the WB sets the named ranges equal to the value of the columns (for that item) in the excel document library. The issue I am having is with retrieving data from the created excel WB and displaying it in the InfoPath form. When I use a web query SOAP/REST to try and retrieve data from the WB, before the WB has been open and closed, it returns blank values.
This is because the event trigger for the WB is On_Open and the values are not set until it is opened and closed. I have tried using the SOAP call OpenWorkbook and OpenWorkbookForEditing and they error along the lines of “ the workbook cannot be opened format not supported’. I believe this is due to the fact that it is a .xlsm file and excel services doesn’t support them, but I’m not sure.
I have the business process working now using individual SOAP calls for each field but I need to move away from that. It is unnecessarily complex and does not work reliably.
The job is to get the code in the excel WB to work. That is having the values set as the workbook is created so that I can receive values back into my form. The IP form will be sending DebitRate and MarginDebit to the excel wb and recieveing the calculated value TotalPL back
I have a couple of infopath forms that needs to be designed, fields validation , integration with SQL database for data view/validation, MultiLanguage support and differnt views (read view , print view , input view) ....