Re: Excel Spreadsheet > SharePoint List > Infopath Form?

Clay Fox — Fri, 10 Oct 2008 03:27:38 GMT

I would recommend a SQL database. I think the list is a bit limited. Plus once you get over 2K records the performance wil quickly decline.

The issue with sequential numbering is that you have to assign the number upon submit if multiple users have forms open.

With SQL it can assign it on submit.

I would look at using web services like qdabra provides to create a real enterprise solution.

Excel Spreadsheet > SharePoint List > Infopath Form?

Michael Clark — Wed, 08 Oct 2008 16:04:39 GMT

OK,

We have an Excel spreadsheet which contains our Engineering Change Tracking log. It is used to track the critical data about every Engineering Change we process. I wrote a few easy to use VB dialog boxes for users to maintain & search the data in the spreadsheet. One user has created her own spreadsheets which read in data from our Excel tracking log. The biggest problem I have is that Shared Workbooks have proven to be very problematic for us. So, currently, only one user can open the tracking log spreadsheet at any one time. THIS SHOULD BE A PERFECT APPLICATION FOR A SHAREPOINT LIST.

I have exported the spreadsheet to a sharepoint list. (No Problems)

I have been able to replace most of the functionality of my VB dialog boxes with standard List functionality. (Minor Problems)

I have been able to address the spreadsheets linking into the original spreadsheet.

My biggest problem MUST have a simple answer;

How can I get the numeric tracking number to default to the next one when someone creates a new EC?

Is there a simple way to create an InfoPath form that uses this list as it's primary data source? With Infopath, I should be able to create an input form that will blow my old Excel VB dialog boxes out of the water.

Thanks

MRC

SharePoint Integration

Re: Excel Spreadsheet > SharePoint List > Infopath Form?

Excel Spreadsheet > SharePoint List > Infopath Form?