Hi all,
I’m faced with an interesting challenge. A client of mine wants to import data from SurveyMonkey into SharePoint for analytics and to create further surveys directly in SharePoint. The current survey has around 300 questions which exceeds the 8k data column size limit for a row as specified by the Software boundaries and limits for SharePoint 2013. They want item-level permissions and versioning on the items.
I was thinking of some creative way to overcome this issue but would appreciation some input:
Option 1: Use Access Database in SharePoint
- The data actually gets stored in a SharePoint list so I wouldn’t be better off.
Option 2: Use data in BCS
- BCS doesn’t support versioning or permissions. So no good.
- Also, I would need to build the relational structure and tables for choices manually
Option 3: Increase number of rows in SQL row wrapping
- SP data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SP will create several rows in the database when data will not fit on a single row. This is called row wrapping.
- The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit.
- I don’t have any experience with this
Option 4: Storing data across multiple lists
- Is it possible to have a single SharePoint item extend across multiple lists? If so, does SharePoint take care of all the versioning, permissions, etc.?
Any other options?
Thanks,
-Haniel
(Visited 329 times, 1 visits today)
