RE: Get currently filtered view using JSOM
Where were you two days ago? :) That's exactly what I wound up doing after spending far too long examining the various SP js classes to work out how they achieved it internally. I wound up writing my own average code to strip out the filter key/value pairs and then apply them dynamically to the query. It works but is also limited to text/choice fields at the moment. I might take it a step further and get the field type so I can modify the query's value type for each field as required. Regards, Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ishai Sagi Sent: Friday, 15 August 2014 10:06 AM To: ozMOSS Subject: RE: Get currently filtered view using JSOM From the URL query string? From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Wednesday, 13 August 2014 9:01 AM To: ozMOSS Subject: Get currently filtered view using JSOM Hi all, Does anyone know if it's possible to get the view query from a list view page that will include any filters applied by the end user? view.get_viewQuery() will return the CAML for the view itself. I need to get any user applied filtering. 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
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
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:
