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.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> [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 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: +61872001100<callto:+61872001100> ■ Mobile: +61417857298<callto:+61417857298> ■ Skype: JDBoman<callto:JDBoman> ■ Web: www.ipmo.com.au<http://www.ipmo.com.au/> 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 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.com<mailto: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: +61872001100<callto:+61872001100> ■ Mobile: +61417857298<callto:+61417857298> ■ Skype: JDBoman<callto:JDBoman> ■ Web: www.ipmo.com.au<http://www.ipmo.com.au/> 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 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 ________________________________ 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