https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/15741.aspxMon, 16 Oct 2006 18:16:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15741Paula Crist0https://www.infopathdev.com:443/forums/thread/15741.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15741Here are the limits I found for SharePoint 2003:<br /><br />Sharepoint Services Limits<br /><br /><br />Hard Coded Site Limits for WSS (SharePoint Services)<br /><br />&gt; 40,000 subfolders and documents - cannot delete (applies to a single folder. a single document library, a site or site collection)<br />&gt; 2 GB of information - cannot delete<br />&gt; 10,000 subfolders and documents - cannot rename<br />&gt; 500 MB of information - cannot rename<br /><br />Lists cannot handle a lot of documents ( alot being over 1000 or 2000 documents)<br /><br />For portal, if you have more than 30,000 documents in a library, the list will not be crawled correctly and no items will be retruned in the search results.<br /><br />Column Limits per List<br />- support a maximum of 64 test fields in the SQL database per list<br />- these are furthre limited as such:<br /> - 8 calculated fields<br /> - 16 lookup fields<br /> - 16 date/time fields<br /> - 16 yes/no fields<br /> - 32 number and currency fields<br /> - 32 multiline text fields<br /><br />https://www.infopathdev.com:443/forums/thread/15740.aspxWed, 21 Sep 2005 21:57:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15740Patrick Halstead0https://www.infopathdev.com:443/forums/thread/15740.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15740Should be in the SharePoint SDK. Please look.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/15739.aspxWed, 21 Sep 2005 18:43:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15739rem1000https://www.infopathdev.com:443/forums/thread/15739.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15739Thanks, Patrick.<br /><br />Can anyone give me a more definitive answer? Knowledge of such limitations will guide our development of forms for which we wish to create SharePoint views.<br /><br />Russhttps://www.infopathdev.com:443/forums/thread/15738.aspxWed, 21 Sep 2005 07:18:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15738Patrick Halstead0https://www.infopathdev.com:443/forums/thread/15738.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15738Yes, SharePoint limits the types. For example, I think there are only slots for 16 dates. For a web-based view, you could use our Database Accelerator and Dashboard to display the data and export it to Excel.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/15282.aspxTue, 20 Sep 2005 17:47:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15282rem1000https://www.infopathdev.com:443/forums/thread/15282.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15282I have an InfoPath form that contains about 250 data fields of various data types, mostly text. When I go to SharePoint to create views of my data, a number of my data fields are not available in the Edit View screen.<br /><br />I have specified in the form that these fields are available (via Form Library Columns).<br /><br />The number of columns that SharePoint shows seems stuck at 117. The columns I cannot see are of various data types.<br /><br />Am I running up against a SharePoint limitation of some sort?<br /><br />Russ