[OzMOSS] RE: Possible UserProfileChanges web service bug
I haven't seen that behaviour before, but I will provide at least 2 POSSIBLE ways (as hacky as they are) to potentially (possibly) overcome the issue: 1. Are you in a farm? a. If you're not, then I am pretty sure it will store all the user information in a list in the site collection root (called User Information List?) i. You could write an IEventSink for this list, to pick up on any changed details? That would be an alternative entry point I guess 2. If you aren't in a farm, then perhaps you could go straight to the user profile database in SQL server (very naughty, by the way, and don't let any sharepoint MVPs know that I suggested this:P), and use a SQL trigger as an entry point into the user profile changing. a. It's all about getting the job done, if it comes to this level of hack to get a better solution then so be it, however, you can guarantee there is maintenece and potential 'blow away' issues by taking such an approach, and i would see it as a temporary solution until MS came up with a fix. Also, this might be a known issue WRT how you are interacting with the service, and I just don't know it. But there's some thoughts anyway... Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Bradley Sent: Friday, 6 June 2008 4:04 PM To: listserver@ozMOSS.com Subject: [OzMOSS] Possible UserProfileChanges web service bug Folks I've got an old problem that first came up before MOSS SP1, and I was hoping that SP1 addressed it but it appears not to have ... I'm continuing to experience problems with the above web service (http://msdn.microsoft.com/en-us/library/ms498695.aspx) in regards to returning record sets for deleted user profiles. You do get an updated token after a delete, but no matter how you format the query xml, nothing ever comes back after a delete, and you need to periodically do a complete re-load of all profiles to determine when there has been deletions instead. Has anyone else on this forum noticed this problem, and are there any known work-arounds? There is a web service API documented here: http://download.microsoft.com/download/8/5/8/858F2155-D48D-4C68-9205-29460FD7698F/%5BMS-USRPCH%5D.PDF which goes into greater depth than the online help for the way you are supposed to invoke this, but it hasn't cast any new light on this problem. Any insight would be appreciated :). Cheers Bob Bradley UNIFY http://www.unifysolutions.net/ Solutions Pty Ltdhttp://www.unifysolutions.net/ Identity Management Specialists Mail: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Office: +61 1300 889 519 Fax: +61 8 8231 8643 Mobile: +61 438 181 003 Web: www.unifysolutions.nethttp://www.unifysolutions.net/ Note: This e-mail and accompanying attachments may contain confidential or privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
Hi All, Thank you so much for your help ... To CAML syntax that *seemed* to finally get things working is shown below: string queryCAML = WhereEqFieldRef Name='Title'/Value Type='Text'{0}/Value/Eq/Where; So it seems to combine two of the suggestions: 1. Avoid the use of double-quote delimeters in the CAML query and 2. Avoid the use of the C# literal string @ directive. Many thanks for your help. Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zakir Azeez Sent: Friday, 6 June 2008 3:47 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions I had the same sort of issue, for some reason it does not like XML in @ style. I changed from @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; to QueryWhereEqFieldRef Name=\Title\ /Value Type=\Text\{0}/Value/Eq/Where/Query; _ From: [EMAIL PROTECTED] on behalf of Paul Noone Sent: Fri 6/6/2008 3:30 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions It's possible your ASP escapes are being taken literally in the query. You might also variations of: @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; and @'QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query'; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 6 June 2008 12:27 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Not sure, but maybe remove the Query element, probably not needed. Also feel free to use single quotes instead of doubles to make the code cleaner. Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Blog: http://cosier.wordpress.com/ http://cosier.wordpress.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 12:22 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, I have a CAML query, which I'm building in U2U CAML's builder - when I test it in CAML Builder, it returns the one custom list item I'm seeking. The CAML generated is shown below: QueryWhereEqFieldRef Name=Title /Value Type=TextABC/Value/Eq/Where/Query But when the query is executed using the following code, I get all of the items in the list returned: SPList configurationList = thisList.ParentWeb.Lists[configurationListName]; SPQuery getConfigurationValueQuery = new SPQuery(); queryCAML = @QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query; getConfigurationValueQuery.Query = string.Format(queryCAML, configurationValueName); SPListItemCollection configurationValues = configurationList.GetItems(getConfigurationValueQuery); I've verified that the string format substitutes the correct value into the CAML query ... Any suggestions kindly welcomed ... Cheers, Trevor Andrew --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com _ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the
RE: [OzMOSS] RE: Possible UserProfileChanges web service bug
Thanks Matthew ... I'm *that* far away from resorting to option #2. I did't know about #1 though - that's marvellous insight. I couldn't find any event sink attached to the user profile itself, but assumed there must be something somewhere ... Bob From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 6 June 2008 3:56 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Possible UserProfileChanges web service bug I haven't seen that behaviour before, but I will provide at least 2 POSSIBLE ways (as hacky as they are) to potentially (possibly) overcome the issue: 1. Are you in a farm? a. If you're not, then I am pretty sure it will store all the user information in a list in the site collection root (called User Information List?) i. You could write an IEventSink for this list, to pick up on any changed details? That would be an alternative entry point I guess 2. If you aren't in a farm, then perhaps you could go straight to the user profile database in SQL server (very naughty, by the way, and don't let any sharepoint MVPs know that I suggested this:P), and use a SQL trigger as an entry point into the user profile changing. a. It's all about getting the job done, if it comes to this level of hack to get a better solution then so be it, however, you can guarantee there is maintenece and potential 'blow away' issues by taking such an approach, and i would see it as a temporary solution until MS came up with a fix. Also, this might be a known issue WRT how you are interacting with the service, and I just don't know it. But there's some thoughts anyway... Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.com http://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Bradley Sent: Friday, 6 June 2008 4:04 PM To: listserver@ozMOSS.com Subject: [OzMOSS] Possible UserProfileChanges web service bug Folks I've got an old problem that first came up before MOSS SP1, and I was hoping that SP1 addressed it but it appears not to have ... I'm continuing to experience problems with the above web service (http://msdn.microsoft.com/en-us/library/ms498695.aspx) in regards to returning record sets for deleted user profiles. You do get an updated token after a delete, but no matter how you format the query xml, nothing ever comes back after a delete, and you need to periodically do a complete re-load of all profiles to determine when there has been deletions instead. Has anyone else on this forum noticed this problem, and are there any known work-arounds? There is a web service API documented here: http://download.microsoft.com/download/8/5/8/858F2155-D48D-4C68-9205-294 60FD7698F/%5BMS-USRPCH%5D.PDF which goes into greater depth than the online help for the way you are supposed to invoke this, but it hasn't cast any new light on this problem. Any insight would be appreciated :). Cheers Bob Bradley UNIFY http://www.unifysolutions.net/ Solutions Pty Ltd http://www.unifysolutions.net/ Identity Management Specialists Mail: [EMAIL PROTECTED] Office: +61 1300 889 519 Fax: +61 8 8231 8643 Mobile: +61 438 181 003 Web: www.unifysolutions.net http://www.unifysolutions.net/ Note: This e-mail and accompanying attachments may contain confidential or privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
Did query have anything to do with it? Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 6:33 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, Thank you so much for your help ... To CAML syntax that *seemed* to finally get things working is shown below: string queryCAML = WhereEqFieldRef Name='Title'/Value Type='Text'{0}/Value/Eq/Where; So it seems to combine two of the suggestions: 1. Avoid the use of double-quote delimeters in the CAML query and 2. Avoid the use of the C# literal string @ directive. Many thanks for your help. Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zakir Azeez Sent: Friday, 6 June 2008 3:47 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions I had the same sort of issue, for some reason it does not like XML in @ style. I changed from @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; to QueryWhereEqFieldRef Name=\Title\ /Value Type=\Text\{0}/Value/Eq/Where/Query; From: [EMAIL PROTECTED] on behalf of Paul Noone Sent: Fri 6/6/2008 3:30 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions It's possible your ASP escapes are being taken literally in the query. You might also variations of: @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; and @'QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query'; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 6 June 2008 12:27 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Not sure, but maybe remove the Query element, probably not needed. Also feel free to use single quotes instead of doubles to make the code cleaner. Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 12:22 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, I have a CAML query, which I'm building in U2U CAML's builder - when I test it in CAML Builder, it returns the one custom list item I'm seeking. The CAML generated is shown below: QueryWhereEqFieldRef Name=Title /Value Type=TextABC/Value/Eq/Where/Query But when the query is executed using the following code, I get all of the items in the list returned: SPList configurationList = thisList.ParentWeb.Lists[configurationListName]; SPQuery getConfigurationValueQuery = new SPQuery(); queryCAML = @QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query; getConfigurationValueQuery.Query = string.Format(queryCAML, configurationValueName); SPListItemCollection configurationValues = configurationList.GetItems(getConfigurationValueQuery); I've verified that the string format substitutes the correct value into the CAML query ... Any suggestions kindly welcomed ... Cheers, Trevor Andrew --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au
RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
Hi All, I should also add that omitting the surrounding Query/Query tags also appeared to be essential ... So to be comprehensive, the things that got the CAML query going were: 1. Removing the Query/Query tags in a CAML query with only a Where clause, 2. Substituting single-quotes for double-quotes as literal delimiters in the CAML query, and 3. Avoiding the use of the C# literal string @ directive in a string to be used as a CAML query. I guess the thing that surprised me most was that when the Where clause is wrong, I got *all* of the items in the list, not *none* of the items in the list ... There's a gotcha to keep in mind when I'm seeing unusual behaviour in the future ... Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 6:33 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, Thank you so much for your help ... To CAML syntax that *seemed* to finally get things working is shown below: string queryCAML = WhereEqFieldRef Name='Title'/Value Type='Text'{0}/Value/Eq/Where; So it seems to combine two of the suggestions: 4. Avoid the use of double-quote delimeters in the CAML query and 5. Avoid the use of the C# literal string @ directive. Many thanks for your help. Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zakir Azeez Sent: Friday, 6 June 2008 3:47 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions I had the same sort of issue, for some reason it does not like XML in @ style. I changed from @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; to QueryWhereEqFieldRef Name=\Title\ /Value Type=\Text\{0}/Value/Eq/Where/Query; _ From: [EMAIL PROTECTED] on behalf of Paul Noone Sent: Fri 6/6/2008 3:30 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions It's possible your ASP escapes are being taken literally in the query. You might also variations of: @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; and @'QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query'; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 6 June 2008 12:27 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Not sure, but maybe remove the Query element, probably not needed. Also feel free to use single quotes instead of doubles to make the code cleaner. Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Blog: http://cosier.wordpress.com/ http://cosier.wordpress.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 12:22 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, I have a CAML query, which I'm building in U2U CAML's builder - when I test it in CAML Builder, it returns the one custom list item I'm seeking. The CAML generated is shown below: QueryWhereEqFieldRef Name=Title /Value Type=TextABC/Value/Eq/Where/Query But when the query is executed using the following code, I get all of the items in the list returned: SPList configurationList = thisList.ParentWeb.Lists[configurationListName]; SPQuery getConfigurationValueQuery = new SPQuery(); queryCAML = @QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query; getConfigurationValueQuery.Query = string.Format(queryCAML, configurationValueName); SPListItemCollection configurationValues = configurationList.GetItems(getConfigurationValueQuery); I've verified that the string format substitutes the correct value into the CAML query ... Any suggestions kindly welcomed ... Cheers, Trevor Andrew --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com _ This e-mail is intended for the use of the
[OzMOSS] Creating a list template for a Feature on x64
Hi All, I need to install a list (with a feature) that has a particular content type associated with it, plus a few custom views. Normally I would use the SharePoint Solution Generator to create my list template, stick it into my feature, and job done. Unfortunately this is all on x64 architecture, and the WSS extensions (even 1.2) don't work on x64. I imagine I can just put together what the SSG does by grabbing the views from the Forms folder, and grabbing the schema.xml for the list from making an stp file - is this correct?? Is there another way to make this up for my feature from an x64 platform? Cheers, Nigel Witherdin Senior Support Analyst Eversheds Direct Dial: +44 (0) 84 549 754 17 Mobile: +44 (0) 7738 553256 www.eversheds.com http://www.eversheds.com/ ** This email is sent for and on behalf of Eversheds LLP ** This email is sent for and on behalf of Eversheds LLP which is a limited liability partnership, registered in England and Wales, registered number OC304065. Registered office One Wood Street, London. EC2V 7WS. Registered VAT number GB820704559. A list of the members' names and their professional qualifications is available for inspection at the above office. Regulated by the Solicitors Regulation Authority (see www.sra.org.uk). Confidentiality: This email and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this email and highlight the error. * [ www.eversheds.com ] * --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] Creating a list template for a Feature on x64
Hi Nigel, try wspbuilder www.codeplex.com\wspbuilder or also try stsdev www.codeplex.com\stsdev these should do the trick. I myself prefer these tools to the VS extensions, but thats just me. Cheers, Aaron From: [EMAIL PROTECTED] on behalf of Witherdin, Nigel Sent: Sat 7/06/2008 12:47 AM To: listserver@ozMOSS.com Subject: [OzMOSS] Creating a list template for a Feature on x64 Hi All, I need to install a list (with a feature) that has a particular content type associated with it, plus a few custom views. Normally I would use the SharePoint Solution Generator to create my list template, stick it into my feature, and job done. Unfortunately this is all on x64 architecture, and the WSS extensions (even 1.2) don't work on x64. I imagine I can just put together what the SSG does by grabbing the views from the Forms folder, and grabbing the schema.xml for the list from making an stp file - is this correct?? Is there another way to make this up for my feature from an x64 platform? Cheers, Nigel Witherdin Senior Support Analyst Eversheds Direct Dial: +44 (0) 84 549 754 17 Mobile: +44 (0) 7738 553256 www.eversheds.com http://www.eversheds.com/ * This email is sent for and on behalf of Eversheds LLP * This email is sent for and on behalf of Eversheds LLP which is a limited liability partnership, registered in England and Wales, registered number OC304065. Registered office One Wood Street, London, EC2V 7WS. Registered VAT number GB820704559. A list of the members' names and their professional qualifications is available for inspection at the above office. Regulated by the Solicitors Regulation Authority (see www.sra.org.uk http://www.sra.org.uk/ ). Confidentiality: This email and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this email and highlight the error. * [ www.eversheds.com http://www.eversheds.com/ ] * --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
RE: [OzMOSS] Creating a list template for a Feature on x64
I had to do this one time and time really was a constrain. I approached a quick and dirty way of grabing the SSG binaries and ran it on x64. From: [EMAIL PROTECTED] on behalf of Aaron Saikovski Sent: Sat 6/7/2008 9:30 AM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] Creating a list template for a Feature on x64 Hi Nigel, try wspbuilder www.codeplex.com\wspbuilder http://www.codeplex.com/wspbuilder or also try stsdev www.codeplex.com\stsdev http://www.codeplex.com/stsdev these should do the trick. I myself prefer these tools to the VS extensions, but thats just me. Cheers, Aaron From: [EMAIL PROTECTED] on behalf of Witherdin, Nigel Sent: Sat 7/06/2008 12:47 AM To: listserver@ozMOSS.com Subject: [OzMOSS] Creating a list template for a Feature on x64 Hi All, I need to install a list (with a feature) that has a particular content type associated with it, plus a few custom views. Normally I would use the SharePoint Solution Generator to create my list template, stick it into my feature, and job done. Unfortunately this is all on x64 architecture, and the WSS extensions (even 1.2) don't work on x64. I imagine I can just put together what the SSG does by grabbing the views from the Forms folder, and grabbing the schema.xml for the list from making an stp file - is this correct?? Is there another way to make this up for my feature from an x64 platform? Cheers, Nigel Witherdin Senior Support Analyst Eversheds Direct Dial: +44 (0) 84 549 754 17 Mobile: +44 (0) 7738 553256 www.eversheds.com http://www.eversheds.com/ * This email is sent for and on behalf of Eversheds LLP * This email is sent for and on behalf of Eversheds LLP which is a limited liability partnership, registered in England and Wales, registered number OC304065. Registered office One Wood Street, London, EC2V 7WS. Registered VAT number GB820704559. A list of the members' names and their professional qualifications is available for inspection at the above office. Regulated by the Solicitors Regulation Authority (see www.sra.org.uk http://www.sra.org.uk/ ). Confidentiality: This email and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this email and highlight the error. * [ www.eversheds.com http://www.eversheds.com/ ] * --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com winmail.dat
RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions
For your #1 point - see http://www.sharepoint-tips.com/2006/12/caml-queries-return-all-items-despite.html I don't understand #3 - I always use the @ literal string directive with CAML, and never had a problem with it. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 8:19 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, I should also add that omitting the surrounding Query/Query tags also appeared to be essential ... So to be comprehensive, the things that got the CAML query going were: 1. Removing the Query/Query tags in a CAML query with only a Where clause, 2. Substituting single-quotes for double-quotes as literal delimiters in the CAML query, and 3. Avoiding the use of the C# literal string @ directive in a string to be used as a CAML query. I guess the thing that surprised me most was that when the Where clause is wrong, I got *all* of the items in the list, not *none* of the items in the list ... There's a gotcha to keep in mind when I'm seeing unusual behaviour in the future ... Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 6:33 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, Thank you so much for your help ... To CAML syntax that *seemed* to finally get things working is shown below: string queryCAML = WhereEqFieldRef Name='Title'/Value Type='Text'{0}/Value/Eq/Where; So it seems to combine two of the suggestions: 4. Avoid the use of double-quote delimeters in the CAML query and 5. Avoid the use of the C# literal string @ directive. Many thanks for your help. Cheers, Trevor Andrew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zakir Azeez Sent: Friday, 6 June 2008 3:47 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions I had the same sort of issue, for some reason it does not like XML in @ style. I changed from @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; to QueryWhereEqFieldRef Name=\Title\ /Value Type=\Text\{0}/Value/Eq/Where/Query; From: [EMAIL PROTECTED] on behalf of Paul Noone Sent: Fri 6/6/2008 3:30 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions It's possible your ASP escapes are being taken literally in the query. You might also variations of: @QueryWhereEqFieldRef Name='Title' /Value Type='Text'{0}/Value/Eq/Where/Query; and @'QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query'; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Cosier Sent: Friday, 6 June 2008 12:27 PM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: CAML Query not filtering - Any suggestions Not sure, but maybe remove the Query element, probably not needed. Also feel free to use single quotes instead of doubles to make the code cleaner. Matthew Cosier Readify | Dev Centre Lead M: +61 401 932 250 | E: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Blog: http://cosier.wordpress.comhttp://cosier.wordpress.com/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Andrew Sent: Friday, 6 June 2008 12:22 PM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: CAML Query not filtering - Any suggestions Hi All, I have a CAML query, which I'm building in U2U CAML's builder - when I test it in CAML Builder, it returns the one custom list item I'm seeking. The CAML generated is shown below: QueryWhereEqFieldRef Name=Title /Value Type=TextABC/Value/Eq/Where/Query But when the query is executed using the following code, I get all of the items in the list returned: SPList configurationList = thisList.ParentWeb.Lists[configurationListName]; SPQuery getConfigurationValueQuery = new SPQuery(); queryCAML = @QueryWhereEqFieldRef Name=Title /Value Type=Text{0}/Value/Eq/Where/Query; getConfigurationValueQuery.Query = string.Format(queryCAML, configurationValueName); SPListItemCollection configurationValues = configurationList.GetItems(getConfigurationValueQuery); I've verified that the string format substitutes the correct value into the CAML query ... Any suggestions kindly welcomed ... Cheers, Trevor Andrew --- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email