RE: Use a newtwork share as the source for a document library
Remote desktop (citrix etc) will not have latency...files never leave the network. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 3:27 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library I was hoping to a void a third-party solution, Ishai, but the DocAve solution does look very good. Nothing's going to solve latency when off-network. I might look at demoing both and will let you know. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 1:40 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns... Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.comhttp://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.aumailto:p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink... I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From:
RE: Use a newtwork share as the source for a document library
Hmmm: Looks like it's no longer a free product. That's a shame: (Only had a very quick look.) DocAve 5 Extender was a free product when I talked about RBS at a some conference a couple of years back: http://www.avepoint.com/news/2010/02/24/avepoint-introduces-free-tool-for-sh arepoint-blob-management/ http://www.avepoint.com/assets/pdf/doc5/DocAve_Extender_v5_Datasheet.pdf Looks like the product has morphed into DocAve 6 Storage Manager. Ouch! But not unexpected I suppose. http://www.avepoint.com/assets/pdf/doc6/DocAve_Storage_Manager_for_SharePoin t_Storage_Management.pdf Perhaps you can still use the free product? The quicker the SharePoint team integrate with the full feature stack of SQL Server, and start using things like FILETABLE the better: From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 3:27 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library I was hoping to a void a third-party solution, Ishai, but the DocAve solution does look very good. Nothing's going to solve latency when off-network. I might look at demoing both and will let you know. From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 1:40 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns: Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.com http://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this: From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download
RE: Use a newtwork share as the source for a document library
Yeah, I keep hoping MS will play catch-up with each new version but I can't really wait that long. :) Citrix desktop cannot achieve what we want apparently. There's a limitation with the wauy it handles profiles. Yey strangely they offerr what we need as an app for iOS and Android. Sadly that doesn't help me. I'll keep tinkering and see what I can do. Ishai, I will no doubt need your elite coding skills if I go the custom connector route! From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 4:08 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Hmmm... Looks like it's no longer a free product. That's a shame... (Only had a very quick look.) DocAve 5 Extender was a free product when I talked about RBS at a some conference a couple of years back: http://www.avepoint.com/news/2010/02/24/avepoint-introduces-free-tool-for-sharepoint-blob-management/ http://www.avepoint.com/assets/pdf/doc5/DocAve_Extender_v5_Datasheet.pdf Looks like the product has morphed into DocAve 6 Storage Manager. Ouch! But not unexpected I suppose. http://www.avepoint.com/assets/pdf/doc6/DocAve_Storage_Manager_for_SharePoint_Storage_Management.pdf Perhaps you can still use the free product? The quicker the SharePoint team integrate with the full feature stack of SQL Server, and start using things like FILETABLE the better... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 3:27 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library I was hoping to a void a third-party solution, Ishai, but the DocAve solution does look very good. Nothing's going to solve latency when off-network. I might look at demoing both and will let you know. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 1:40 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns... Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.comhttp://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.aumailto:p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From:
RE: Use a newtwork share as the source for a document library
It's not encouraging to see that the last post on the Microsoft Business Connectivity Services Team Bloghttp://blogs.msdn.com/b/bcs/ was over 4 years ago. SO are all the examples I've found. :\ This example is the best I could find but it only includes read operations. http://pholpar.wordpress.com/2010/09/19/publishing-files-stored-in-the-file-system-through-external-list/ But I can't find any examples on how to create, copy and delete. Is it even supported? Any assistance would be greatly appreciated. Seems like it should all happen in System.IO.FileInfo. I'd also like to return the file size but it looks like Int64 is unsupported for external lists, at least as of SP2010. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Wednesday, 20 August 2014 8:13 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Yeah, I keep hoping MS will play catch-up with each new version but I can't really wait that long. :) Citrix desktop cannot achieve what we want apparently. There's a limitation with the wauy it handles profiles. Yey strangely they offerr what we need as an app for iOS and Android. Sadly that doesn't help me. I'll keep tinkering and see what I can do. Ishai, I will no doubt need your elite coding skills if I go the custom connector route! From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 4:08 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Hmmm... Looks like it's no longer a free product. That's a shame... (Only had a very quick look.) DocAve 5 Extender was a free product when I talked about RBS at a some conference a couple of years back: http://www.avepoint.com/news/2010/02/24/avepoint-introduces-free-tool-for-sharepoint-blob-management/ http://www.avepoint.com/assets/pdf/doc5/DocAve_Extender_v5_Datasheet.pdf Looks like the product has morphed into DocAve 6 Storage Manager. Ouch! But not unexpected I suppose. http://www.avepoint.com/assets/pdf/doc6/DocAve_Storage_Manager_for_SharePoint_Storage_Management.pdf Perhaps you can still use the free product? The quicker the SharePoint team integrate with the full feature stack of SQL Server, and start using things like FILETABLE the better... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 3:27 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library I was hoping to a void a third-party solution, Ishai, but the DocAve solution does look very good. Nothing's going to solve latency when off-network. I might look at demoing both and will let you know. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 1:40 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns... Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.comhttp://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.aumailto:p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow
RE: Use a newtwork share as the source for a document library
OOC are you using SQL Server Enterprise Edition? This whole RBS / FILESTREAM area is a bit of a mess with lots of miscommunication, etc. And don't get me started on this 200GB content database BS. The person(s) responsible for http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx should be sacked for all the confusion, contradictions and misinformation contained therein. As one of MANY examples of WTF statements in the URL I don't understand why you would even use RBS if the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit., what would be the point? I don't think they have come close to clarifying the situation and what they mean by supported and what Microsoft will support. I would start with the size of your CAD BLOBs and see how large they are. If they are 10GB, do you really want to be channelling them through your WFEs? What frequency will people be accessing data through the share versus SPS? What will be the read / write percentage? And of course, as always what is the performance profile of your storage solution? Other very important factors would also be the potential benefits of WS2012: *Storage spaces *Deduplication (I don't know enough about CAD files to comment here) *SMB 3.0 enhancements Bottom line I think that you would not use the FILESTREAM provider for RBS. AvePoint, Metalogix/StoragePoint, Quest, etc all have far better RBS providers. My AUD $0.02: HTH, Victor From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. *The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. *If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? *You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - link http://support.microsoft.com/kb/2933738 ). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organice http://www.cadac.com/organice/en/solutions/Pages/default.aspx ) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for
Re: Use a newtwork share as the source for a document library
Good explanation Victor. Thanks for this thread guys. Informative. Sutha 0450076504 Sent from my iPhone On 18 Aug 2014, at 4:45 pm, Victor Isakov vic...@sqlserversolutions.com.au wrote: OOC are you using SQL Server Enterprise Edition? This whole RBS / FILESTREAM area is a bit of a mess with lots of miscommunication, etc. And don’t get me started on this 200GB content database BS. The person(s) responsible for http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx should be sacked for all the confusion, contradictions and misinformation contained therein. As one of MANY examples of WTF statements in the URL I don’t understand why you would even use RBS if “the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit.”, what would be the point? I don’t think they have come close to clarifying the situation and what they mean by “supported” and what Microsoft will “support”. I would start with the size of your CAD BLOBs and see how large they are. If they are 10GB, do you really want to be channelling them through your WFEs? What frequency will people be accessing data through the share versus SPS? What will be the read / write percentage? And of course, as always what is the performance profile of your storage solution? Other very important factors would also be the potential benefits of WS2012: ·Storage spaces ·Deduplication (I don’t know enough about CAD files to comment here) ·SMB 3.0 enhancements Bottom line I think that you would not use the FILESTREAM provider for RBS. AvePoint, Metalogix/StoragePoint, Quest, etc all have far better RBS providers. My AUD $0.02… HTH, Victor From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there’s an easy way to expand out to new databases as each one fills up. ·The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what’s meant by “collaboration” unless they’re referring to the Team Site template. ·If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? ·You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they’re talking about terabytes worth of content then I have limited options. They’re not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - link). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I’ve also found that exposing an existing file share as a document library isn’t always a wonderful experience. You won’t have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organice) will link AutoDesk’s Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC’s Organice allows people that don’t have Vault licences to access and review drawings. I haven’t used these products, so don’t have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire
RE: Use a newtwork share as the source for a document library
Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way...). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - linkhttp://support.microsoft.com/kb/2933738). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organicehttp://www.cadac.com/organice/en/solutions/Pages/default.aspx) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for offline use. Dumping of files into the same path will cause OneDrive for Business upload them in the background. I find this feature very handy. Can I specify a UNC path to a remote server using FILESTREAM? From my understanding, the FILESTREAM feature of SQL server is an implementation (not the only one) of the BLOB storage API in SharePoint. A document library in a content database with
RE: Use a newtwork share as the source for a document library
Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way...). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - linkhttp://support.microsoft.com/kb/2933738). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organicehttp://www.cadac.com/organice/en/solutions/Pages/default.aspx) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com
RE: Use a newtwork share as the source for a document library
If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink... I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way...). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - linkhttp://support.microsoft.com/kb/2933738). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a
RE: Use a newtwork share as the source for a document library
SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink... I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way...). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site
RE: Use a newtwork share as the source for a document library
What about something like DropBox? From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink: I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way:). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. *The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. *If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? *You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com
RE: Use a newtwork share as the source for a document library
We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink... I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in those types of databases - with some heavy instructions of the kind of IO you should have for those databases if you expect proper performance. I would suggest that leaving huge CAD documents out of sharepoint is the best approach. Instead, I see two options: 1. Cheap, quick and homemade: have a list in sharepoint with the metadata, including a link to the file in the file share. Develop a timer job to refresh that list every night when someone adds\deletes a file from the file share. Users are trained to add files to the file share, and not through sharepoint. This has the advantage of not affecting backup or upgrades. 2. AvePoint connector: exposes the file share into sharepoint - allowing users to upload using sharepoint interface (assuming the huge files will not time out in IIS on the way...). More expensive, and you are relying on a 3rd party for upgrade, but if you use them for backup less worries. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger
RE: Use a newtwork share as the source for a document library
Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns: Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.com http://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.au mailto:p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this: From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink: I think a RemoteDesktop is a better solution for a situation like this. From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: mailto:ozmoss-boun...@ozmoss.com ozmoss-boun...@ozmoss.com [ mailto:ozmoss-boun...@ozmoss.com mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to document repository (think document centres and record centres) which is a mostly read, rarely write database - and Microsoft supports up to 4TB in
RE: Use a newtwork share as the source for a document library
I was hoping to a void a third-party solution, Ishai, but the DocAve solution does look very good. Nothing's going to solve latency when off-network. I might look at demoing both and will let you know. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 1:40 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library Which is why I suggested Drop Box. Offsite back = good Over the Internet access from virtually all popular O/Ss = good And it integrates into NASs, file servers, etc seamlessly without affecting what you do at the SPS level or anything else. But I completely understand if a business does not want to due to IP / security concerns... Wait until your whole 2TB storage solution fails / corrupts :) I'll be curious what you end up doing in the end. NetApp also have solutions in this space (they OEM AvePoint anyway) From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 1:20 PM To: ozMOSS Subject: Re: Use a newtwork share as the source for a document library Looks like the solution i suggested- which doesn't solve your over-the-internet problem. Thanks, Ishai Sagi Extelligent Design www.extelligentdesign.comhttp://www.extelligentdesign.com Sent from my phone +61 488 789 786 On 19 Aug 2014, at 13:16, Paul Noone p.no...@keller.com.aumailto:p.no...@keller.com.au wrote: Bamboo Solutions have a 2013 solution that does what I want - File Share Library. http://store.bamboosolutions.com/sharepoint-file-share-library.aspx The ability to specify a connection for each library is hard to beat. Would love to know how they achieved this... From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:52 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library We don't want any third party solutions or off-site storage. From what I can find (and information is hard to come by) I can bind the BDC model to an assembly, which means I can write custom actions for file interactions. Is it hard just to expose them as a list (filename,size,modified date) and allow download/upload capabilities? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Victor Isakov Sent: Tuesday, 19 August 2014 12:43 PM To: 'ozMOSS' Subject: RE: Use a newtwork share as the source for a document library What about something like DropBox? From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 12:25 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library SharePoint is available over the Internet. I mean when the user is not directly connected to the network. I agree speed will be an issue. But this is more about providing remote access when required. They need read/write capability. I've never seen an example of a BDC connected list in action so don't even know what it can and can't do. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 12:10 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library If the user is off the network, doesn't that mean that sharepoint will not be available either? Or is sharepoint available through the internet - which only raises more worries - a CAD file would make a dent in most download allowances, not to mention potential speed issues with the uplink... I think a RemoteDesktop is a better solution for a situation like this. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Tuesday, 19 August 2014 11:40 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Thank Victor. I couldn't agree with you more! So much damn contradictory info. And thanks for the explanation, Ishai. All the files already exist on a file share. Users download large files to their system to work on to avoid network latency. My goal is simply to give them access to this file share when they are off the network. I'm assuming a business data connector to SharePoint will allow this to happen by managing the connection itself. Please let me know if I'm wrong. Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Tuesday, 19 August 2014 10:02 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul - the collaboration refers to databases that are used for about equal amounts of read\write, as opposed to
RE: Use a newtwork share as the source for a document library
Paul, Have you considered using FILESTREAM storage on the SQL server for storing the files as files, while still keeping the benefits of housing them in a SharePoint document library? Cheers, James. James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 9:56 AM To: ozMOSS Subject: Use a newtwork share as the source for a document library Hi all, Has anyone successfully achieved this? I have terabytes worth of CAD files and other types that are simply not suitable to storing in a DB. I want to provide a Document Library view of this location and provide basic read/write (upload) functionality. Would my best option be a custom BCS connector that interacts with the file system directly? Regards, Paul The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ___ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Use a newtwork share as the source for a document library
Hi James, I'm open to both. My understanding is they want to a way to easily access or dump files (when offline) for these types of files. · Does using SharePoint synch button on a library physically copy the entire library to the local PC? · Can I specify a UNC path to a remote server using FILESTREAM? Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:16 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Have you considered using FILESTREAM storage on the SQL server for storing the files as files, while still keeping the benefits of housing them in a SharePoint document library? Cheers, James. James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 9:56 AM To: ozMOSS Subject: Use a newtwork share as the source for a document library Hi all, Has anyone successfully achieved this? I have terabytes worth of CAD files and other types that are simply not suitable to storing in a DB. I want to provide a Document Library view of this location and provide basic read/write (upload) functionality. Would my best option be a custom BCS connector that interacts with the file system directly? Regards, Paul The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ___ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Use a newtwork share as the source for a document library
Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for offline use. Dumping of files into the same path will cause OneDrive for Business upload them in the background. I find this feature very handy. Can I specify a UNC path to a remote server using FILESTREAM? From my understanding, the FILESTREAM feature of SQL server is an implementation (not the only one) of the BLOB storage API in SharePoint. A document library in a content database with FILESTREAM enabled behaves no differently from a user point of view. While you can see the filesystem that SQL uses to store the BLOBs, you can't/shouldn't make changes to that filesystem. Mapping of UNC paths would continue to work the same way it does for all document libraries (via WebDAV) using open in explorer mode ribbon button or using the connect to website feature in the map drive dialog. [cid:image001.png@01CFBADC.8AB0FCA0] Kind regards, James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 11:55 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Hi James, I'm open to both. My understanding is they want to a way to easily access or dump files (when offline) for these types of files. · Does using SharePoint synch button on a library physically copy the entire library to the local PC? · Can I specify a UNC path to a remote server using FILESTREAM? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:16 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Have you considered using FILESTREAM storage on the SQL server for storing the files as files, while still keeping the benefits of housing them in a SharePoint document library? Cheers, James. James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 9:56 AM To: ozMOSS Subject: Use a newtwork share as the source for a document library Hi all, Has anyone successfully achieved this? I have terabytes worth of CAD files and other types that are simply not suitable to storing in a DB. I want to provide a Document Library view of this location and provide basic read/write (upload) functionality. Would my best option be a custom BCS connector that interacts with the file system directly? Regards, Paul The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ___ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Use a newtwork share as the source for a document library
My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - linkhttp://support.microsoft.com/kb/2933738). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organicehttp://www.cadac.com/organice/en/solutions/Pages/default.aspx) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for offline use. Dumping of files into the same path will cause OneDrive for Business upload them in the background. I find this feature very handy. Can I specify a UNC path to a remote server using FILESTREAM? From my understanding, the FILESTREAM feature of SQL server is an implementation (not the only one) of the BLOB storage API in SharePoint. A document library in a content database with FILESTREAM enabled behaves no differently from a user point of view. While you can see the filesystem that SQL uses to store the BLOBs, you can't/shouldn't make changes to that filesystem. Mapping of UNC paths would continue to work the same way it does for all document libraries (via WebDAV) using open in explorer mode ribbon button or using the connect to website feature in the map drive dialog. [cid:image001.png@01CFBADC.8AB0FCA0] Kind regards, James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 11:55 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Hi James, I'm open to both. My understanding is they want to a way to easily access or dump files (when offline) for these types of files. · Does using SharePoint synch button on a library physically copy the entire library to the local PC? · Can I specify a UNC path to a remote server using FILESTREAM? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:16 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Have you considered using FILESTREAM storage on the SQL server for storing the files as files, while still keeping the benefits of housing them in a SharePoint document library? Cheers, James. James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 9:56 AM To: ozMOSS Subject: Use a newtwork share as the source for a document library Hi all, Has anyone successfully achieved this? I have terabytes worth of CAD files and other types that are simply not suitable to storing in a DB. I want to provide a Document Library view of this location and provide basic read/write (upload) functionality. Would my best option be a custom BCS connector that interacts with the file system directly? Regards, Paul The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your
RE: Use a newtwork share as the source for a document library
Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. · The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by collaboration unless they're referring to the Team Site template. · If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? · You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - linkhttp://support.microsoft.com/kb/2933738). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organicehttp://www.cadac.com/organice/en/solutions/Pages/default.aspx) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for offline use. Dumping of files into the same path will cause OneDrive for Business upload them in the background. I find this feature very handy. Can I specify a UNC path to a remote server using FILESTREAM? From my understanding, the FILESTREAM feature of SQL server is an implementation (not the only one) of the BLOB storage API in SharePoint. A document library in a content database with FILESTREAM enabled behaves no differently from a user point of view. While you can see the filesystem that SQL uses to store the BLOBs, you can't/shouldn't make changes to that filesystem. Mapping of UNC paths would continue to work the same way it does for all document libraries (via WebDAV) using open in explorer mode ribbon button or using the connect to website feature in the map drive dialog. [cid:image001.png@01CFBADC.8AB0FCA0] Kind regards, James Boman ■ Phone: +61872001100callto:+61872001100 ■ Mobile: +61417857298callto:+61417857298 ■ Skype: JDBomancallto:JDBoman ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au/ From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 11:55 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Hi James, I'm open to both. My understanding is they want to a way to easily access or dump files (when offline) for these types of files. · Does using SharePoint synch button on a library physically copy the entire library to the local PC? · Can I specify a UNC path to a remote server using FILESTREAM? Regards, Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:16 PM To: ozMOSS Subject:
