Re: Help..InfoPath and UserProfileService
Hi Tommy, Where does the infopath form sit? Is it a form services form, or is it a form template running on the desktop (if so, what domain is the desktop machine on, and/or what domain is the form services machine on?). Generally when you're getting auth prompts, it means that you're trying to hit it outside of the security boundary. Humer me, and on the Infopath desktop machine add prod to the local intranet zone within internet explorer. Tell me if that works (+ provide us with the details of the client). Matthew Cosier On Thu, Nov 19, 2009 at 6:45 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 1:38 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can’t replicated it L Something must have changed in Prod but I’m not sure what. What areas should we check? Please help. I’ve spent more than 2 days trying to resolve this issue. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Noone *Sent:* Thursday, 19 November 2009 12:55 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 3:50 PM *To:* ozMOSS *Subject:* Help..InfoPath and UserProfileService Hi everyone, I’ve got a strange problem right now. I’ve got 2 servers, Test and Prod. In Test, if I tried to connect a blank InfoPath form to http://test/_vti_bin/userprofileservice.asmx it all works fine. But as soon as I tried to connect to http://prod/_vti_bin/userprofileservice.asmxI get an authentication box. I tried to compare the settings between 2 servers (web.config, IIS, SQL, file permission, etc), they’re all the same! L Has anyone ever encountered this problem before? The solutions in Google don’t help at all. Cheers, Tommy ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: Help..InfoPath and UserProfileService
Humor me rather :) On Thu, Nov 19, 2009 at 7:09 PM, Matthew Cosier cos...@gmail.com wrote: Hi Tommy, Where does the infopath form sit? Is it a form services form, or is it a form template running on the desktop (if so, what domain is the desktop machine on, and/or what domain is the form services machine on?). Generally when you're getting auth prompts, it means that you're trying to hit it outside of the security boundary. Humer me, and on the Infopath desktop machine add prod to the local intranet zone within internet explorer. Tell me if that works (+ provide us with the details of the client). Matthew Cosier On Thu, Nov 19, 2009 at 6:45 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 1:38 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can’t replicated it L Something must have changed in Prod but I’m not sure what. What areas should we check? Please help. I’ve spent more than 2 days trying to resolve this issue. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Noone *Sent:* Thursday, 19 November 2009 12:55 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 3:50 PM *To:* ozMOSS *Subject:* Help..InfoPath and UserProfileService Hi everyone, I’ve got a strange problem right now. I’ve got 2 servers, Test and Prod. In Test, if I tried to connect a blank InfoPath form to http://test/_vti_bin/userprofileservice.asmx it all works fine. But as soon as I tried to connect to http://prod/_vti_bin/userprofileservice.asmx I get an authentication box. I tried to compare the settings between 2 servers (web.config, IIS, SQL, file permission, etc), they’re all the same! L Has anyone ever encountered this problem before? The solutions in Google don’t help at all. Cheers, Tommy ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: Help..InfoPath and UserProfileService
Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using *Process Monitor* in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 1:38 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can’t replicated it L Something must have changed in Prod but I’m not sure what. What areas should we check? Please help. I’ve spent more than 2 days trying to resolve this issue. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Noone *Sent:* Thursday, 19 November 2009 12:55 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 3:50 PM *To:* ozMOSS *Subject:* Help..InfoPath and UserProfileService Hi everyone, I’ve got a strange problem right now. I’ve got 2 servers, Test and Prod. In Test, if I tried to connect a blank InfoPath form to http://test/_vti_bin/userprofileservice.asmx it all works fine. But as soon as I tried to connect to http://prod/_vti_bin/userprofileservice.asmxI get an authentication box. I tried to compare the settings between 2 servers (web.config, IIS, SQL, file permission, etc), they’re all the same! L Has anyone ever encountered this problem before? The solutions in Google don’t help at all. Cheers, Tommy ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: Help..InfoPath and UserProfileService
Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.comwrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using *Process Monitor* in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 1:38 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can’t replicated it L Something must have changed in Prod but I’m not sure what. What areas should we check? Please help. I’ve spent more than 2 days trying to resolve this issue. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Noone *Sent:* Thursday, 19 November 2009 12:55 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 3:50 PM *To:* ozMOSS *Subject:* Help..InfoPath and UserProfileService Hi everyone, I’ve got a strange problem right now. I’ve got 2 servers, Test and Prod. In Test, if I tried to connect a blank InfoPath form to http://test/_vti_bin/userprofileservice.asmx it all works fine. But as soon as I tried to connect to http://prod/_vti_bin/userprofileservice.asmx I get an authentication box. I tried to compare the settings between 2 servers (web.config, IIS, SQL, file permission, etc), they’re all the same! L Has anyone ever encountered this problem before? The solutions in Google don’t help at all. Cheers, Tommy ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Help..InfoPath and UserProfileService
Hi everyone, I've run Proc Mon and no access denied there :( Client has added the URLs as Trusted sites since ages ago. I've turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I'm going crazy here..I really can't check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Matthew Cosier Sent: Thursday, 19 November 2009 4:14 PM To: ozMOSS Subject: Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.commailto:sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using Process Monitor in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.aumailto:tommy.seg...@l7.com.au wrote: Paul, I'm connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy's reply, what's even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167http://prod:30167/, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts :( So I suspect there must be something wrong with Prod's IIS :( Please help. 911 Tommy From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Thursday, 19 November 2009 3:36 PM To: 'ozMOSS' Subject: RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Jeremy Thake Sent: Thursday, 19 November 2009 3:31 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService I've had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 1:38 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can't replicated it :( Something must have changed in Prod but I'm not sure what. What areas should we check? Please help. I've spent more than 2 days trying to resolve this issue. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 19 November 2009 12:55 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 3:50 PM To: ozMOSS Subject: Help..InfoPath and UserProfileService Hi everyone, I've got a strange problem right now. I've got 2 servers, Test and Prod. In Test, if I tried to connect a blank InfoPath form to http://test/_vti_bin/userprofileservice.asmx it all works fine. But as soon
Re: Help..InfoPath and UserProfileService
You could always switch to basic auth and see if that resolves it (temporarily). However, have you tried running it locally on the server box itself? See if it works - if it does, you know its definitely a security issue between the 2 machines, (or something in between). M On Thu, Nov 19, 2009 at 7:20 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: Hi everyone, I’ve run Proc Mon and no access denied there L Client has added the URLs as Trusted sites since ages ago. I’ve turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I’m going crazy here..I really can’t check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Matthew Cosier *Sent:* Thursday, 19 November 2009 4:14 PM *To:* ozMOSS *Subject:* Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using *Process Monitor* in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 1:38 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can’t replicated it L Something must have changed in Prod but I’m not sure what. What areas should we check? Please help. I’ve spent more than 2 days trying to resolve this issue. *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Noone *Sent:* Thursday, 19 November 2009 12:55 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Tommy Segoro *Sent:* Thursday, 19 November 2009 3:50 PM *To:* ozMOSS *Subject:* Help..InfoPath and UserProfileService Hi everyone, I’ve got a strange problem right now. I’ve got 2
RE: Help..InfoPath and UserProfileService
You also didn't mention (the the groups benefit we are troubleshooting over MSN), that hitting the webservice with the browser lists all the methods just fine whether on the server locally or from the same client. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 4:21 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Hi everyone, I've run Proc Mon and no access denied there L Client has added the URLs as Trusted sites since ages ago. I've turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I'm going crazy here..I really can't check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Matthew Cosier Sent: Thursday, 19 November 2009 4:14 PM To: ozMOSS Subject: Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using Process Monitor in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permissio n-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Paul, I'm connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy's reply, what's even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167 http://prod:30167/ , I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod's IIS L Please help. 911 Tommy From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Thursday, 19 November 2009 3:36 PM To: 'ozMOSS' Subject: RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Jeremy Thake Sent: Thursday, 19 November 2009 3:31 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService I've had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 1:38 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can't replicated it L Something must have changed in Prod but I'm not sure what. What areas should we check? Please help. I've spent more than 2 days trying to resolve this issue. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 19 November 2009 12:55 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Same DC for both? Do you have anonymous access enabled? Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 3:50 PM To: ozMOSS Subject: Help..InfoPath and UserProfileService Hi everyone, I've got a strange problem right now. I've got 2 servers, Test and Prod. In Test, if I
RE: Help..InfoPath and UserProfileService
The thing is I don't have InfoPath client running on the server. I can access the web service URL via browser directly no problem. But when I tried to access the same URL via InfoPath client (via Data Connections - Add Data connection - receive data - web service URL), I get prompted with authentication box. :( From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Matthew Cosier Sent: Thursday, 19 November 2009 4:24 PM To: ozMOSS Subject: Re: Help..InfoPath and UserProfileService You could always switch to basic auth and see if that resolves it (temporarily). However, have you tried running it locally on the server box itself? See if it works - if it does, you know its definitely a security issue between the 2 machines, (or something in between). M On Thu, Nov 19, 2009 at 7:20 PM, Tommy Segoro tommy.seg...@l7.com.aumailto:tommy.seg...@l7.com.au wrote: Hi everyone, I've run Proc Mon and no access denied there :( Client has added the URLs as Trusted sites since ages ago. I've turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I'm going crazy here..I really can't check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Matthew Cosier Sent: Thursday, 19 November 2009 4:14 PM To: ozMOSS Subject: Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.commailto:sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using Process Monitor in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.aumailto:tommy.seg...@l7.com.au wrote: Paul, I'm connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy's reply, what's even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167http://prod:30167/, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts :( So I suspect there must be something wrong with Prod's IIS :( Please help. 911 Tommy From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Thursday, 19 November 2009 3:36 PM To: 'ozMOSS' Subject: RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Jeremy Thake Sent: Thursday, 19 November 2009 3:31 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService I've had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the IIS metabase gets corrupted. The only way to recover is to delete the IIS web application and create it again. From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tommy Segoro Sent: Thursday, 19 November 2009 1:38 PM To: ozMOSS Subject: RE: Help..InfoPath and UserProfileService Same DC. Anonymous is turned off only Windows Authentication is allowed. I tried to replicate the problem by building a 3rd server and yet I can't replicated it :( Something must have changed in Prod but
Re: Help..InfoPath and UserProfileService
Oh yeah, maybe it's the old loop back issue (worth a shot?) Open Regedit, open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa select DisableLoopbackCheck and set it to 1 (if it doesnt exist, create a new DWORD value and set it to 1). Need to restart the machine though unfortunately. There's a KB for it here: http://support.microsoft.com/default.aspx/kb/896861 Because you're accessing the service via 'prod' it can sometimes do this. You could always try accessing the web service in infopath using the IP address of the prod server instead (unless you need the hostheader to be 'prod' then youll need to do the above ^) Matt On Thu, Nov 19, 2009 at 7:26 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: The thing is I don’t have InfoPath client running on the server. I can access the web service URL via browser directly no problem. But when I tried to access the same URL via InfoPath client (via Data Connections - Add Data connection - receive data - web service URL), I get prompted with authentication box. L *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Matthew Cosier *Sent:* Thursday, 19 November 2009 4:24 PM *To:* ozMOSS *Subject:* Re: Help..InfoPath and UserProfileService You could always switch to basic auth and see if that resolves it (temporarily). However, have you tried running it locally on the server box itself? See if it works - if it does, you know its definitely a security issue between the 2 machines, (or something in between). M On Thu, Nov 19, 2009 at 7:20 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Hi everyone, I’ve run Proc Mon and no access denied there L Client has added the URLs as Trusted sites since ages ago. I’ve turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I’m going crazy here..I really can’t check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Matthew Cosier *Sent:* Thursday, 19 November 2009 4:14 PM *To:* ozMOSS *Subject:* Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using *Process Monitor* in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you are connecting to it with no params to get additional user detail? Are you connecting to it at the same site level to where the form is published? Regards Paul *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Jeremy Thake *Sent:* Thursday, 19 November 2009 3:31 PM *To:* ozMOSS *Subject:* RE: Help..InfoPath and UserProfileService I’ve had this at a particular client in Perth... ;-) probably the same one...this can sometimes be because the
Re: Help..InfoPath and UserProfileService
Seeing as its not working externally either though, might not be the case... still worth a shot? Have you tried creating a new web service outside the realm of sharepoint all together and tried calling that from the infopath client? Perhaps the service is trying to touch a directory that doesnt have the appropriate ACLs set up (you've updated a few but maybe it's trying to touch something else...). Matt On Thu, Nov 19, 2009 at 7:43 PM, Matthew Cosier cos...@gmail.com wrote: Oh yeah, maybe it's the old loop back issue (worth a shot?) Open Regedit, open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa select DisableLoopbackCheck and set it to 1 (if it doesnt exist, create a new DWORD value and set it to 1). Need to restart the machine though unfortunately. There's a KB for it here: http://support.microsoft.com/default.aspx/kb/896861 Because you're accessing the service via 'prod' it can sometimes do this. You could always try accessing the web service in infopath using the IP address of the prod server instead (unless you need the hostheader to be 'prod' then youll need to do the above ^) Matt On Thu, Nov 19, 2009 at 7:26 PM, Tommy Segoro tommy.seg...@l7.com.auwrote: The thing is I don’t have InfoPath client running on the server. I can access the web service URL via browser directly no problem. But when I tried to access the same URL via InfoPath client (via Data Connections - Add Data connection - receive data - web service URL), I get prompted with authentication box. L *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Matthew Cosier *Sent:* Thursday, 19 November 2009 4:24 PM *To:* ozMOSS *Subject:* Re: Help..InfoPath and UserProfileService You could always switch to basic auth and see if that resolves it (temporarily). However, have you tried running it locally on the server box itself? See if it works - if it does, you know its definitely a security issue between the 2 machines, (or something in between). M On Thu, Nov 19, 2009 at 7:20 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Hi everyone, I’ve run Proc Mon and no access denied there L Client has added the URLs as Trusted sites since ages ago. I’ve turned off proxy and still no luck. I even give EVERYONE access to 12 folder and sub-folders/files and still no luck... I even tried to turn on Failure logon audit on client and yet no error message there... I’m going crazy here..I really can’t check anything else. The only thing that I suspect is a corrupted IIS meta base or something. Hmphh... Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Matthew Cosier *Sent:* Thursday, 19 November 2009 4:14 PM *To:* ozMOSS *Subject:* Re: Help..InfoPath and UserProfileService Yeah that could be it as well, ACLs on the directory. Tommy: If none of this works, can you please verify that you can hit the web service locally on the prod box within internet explorer (being locally, you should get the option to execute the service as well, see what happens). If it works locally, you're definitely looking at some kind of security issue between the client and the server - there's a few options here, but let us know! Matthew Cosier On Thu, Nov 19, 2009 at 7:11 PM, Sezai Komur sharepointse...@gmail.com wrote: Have a look at the file and folder permissions in prod, there's a chance they might be different to test, thus causing the auth popup. Maybe try using *Process Monitor* in prod to see what's causing the auth popup. see: http://weblogs.asp.net/steveschofield/archive/2008/03/07/detecting-permission-issues-using-auditing-and-process-monitor.aspx Also - what versions of IIS are setup in test and prod? On Thu, Nov 19, 2009 at 3:45 PM, Tommy Segoro tommy.seg...@l7.com.au wrote: Paul, I’m connecting at site level. Form template is published at root site collection level and it also tries to connect to a webservice at root level but still no joy. Following Jeremy’s reply, what’s even more strange is, I tried to create a test blank site collection level at Test server with port 30167, I then tried to connect to its web service via InfoPath eg http://test:30167/_vti_bin/userprofileservice.asmx it works fine. I then create the same blank site collection on Prod http://prod:30167, I then tried to connect to the web service and it prompts me with authentication box ARGHGHGHGHGHHGHGHG..it drives me nuts L So I suspect there must be something wrong with Prod’s IIS L Please help. 911 Tommy *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On Behalf Of *Paul Culmsee *Sent:* Thursday, 19 November 2009 3:36 PM *To:* 'ozMOSS' *Subject:* RE: Help..InfoPath and UserProfileService Hehe, then I know who it is too ;-) Tommy, what about the other webservices? Just this one? Presumably you
RE: Productivity Hub updates
Thanks for that Chris, Yeah - I found the doc where it had notes on how to add new projects. I'm desperately praying you don't need to manually add them all, and that there's an easier way. I haven't logged a support ticket yet, but a friend at MS is looking into it. If he's unable to find anything, then I'll log one. N -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Chris Denniss Sent: Thursday, 19 November 2009 4:21 PM To: ozMOSS Subject: RE: Productivity Hub updates Hi Nigel Updated PH a while ago in a test VM. From memory you had to manually add updated docs to the appropriate libraries. time consuming I know. Would be interested in the support ticket reply! c Nigel Hertz nigel.he...@stockland.com.au 19/11/2009 12:21 pm Hey Paul Not that I've seen. I download the exe and run it, it asks for a destination which I provide, and it extracts (for the Aug 09 update) 14 zip files and 1 excel file. The zip files only contain documents - no exe. Might go the route of opening a support ticket - probably the best option J N From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 19 November 2009 12:17 PM To: ozMOSS Subject: RE: Productivity Hub updates Hi Nigel, Is there no executable within the extracted files?? You should just need to run this on the WFE where it's installed. It's a native SharePoint app so you can open a support ticket with MS if you get stuck. Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Nigel Hertz Sent: Thursday, 19 November 2009 12:07 PM To: ozMOSS Subject: Productivity Hub updates Hey all Do any of you use the Productivity Hub http://www.microsoft.com/downloads/details.aspx?displaylang=enFamilyID =277fefca-d62f-41bc-943d-79002254cfee at all? If so, do you have any idea how to install updates for it (Aug 09 update and Win 7 update) I can't seem to find any installation notes for it, and the auto-extract exe files extract to zip files with no installation method. Nigel Kind regards Nigel Hertz Software Developer | Information Technology Stockland Level 25 | 133 Castlereagh Street | Sydney NSW 2000 T: 02 9035 2617 | F: 02 8988 2617 Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. _ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Auto Load of Meta Data
Hi everyone, Is there are tool or a facility available in Sharepoint that would allow you to bulk upload meta data to Sharepoint. For example we have meta data in an Access database and we would like to transfer it as sharepoint data We only have Sharepoint Lite. Regards, Kylea White Core Applications Analyst Monadelphous Group Limited | Grd Flr, 1 Sleat Rd T 08 93337063 | www.monadelphous.com.au P Please consider our environment before printing this e-mail _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _Monadelphous E-mail disclaimer If you have received this message in error, please delete the e-mail and notify the sender. This e-mail (including all attachments) is the sole property of Monadelphous Group Ltd and may contain personal, confidential or legally privileged information including information subject to privacy legislation.Any confidentiality or privilege is not waived because this e-mail may have been sent to the wrong address. If you are not the intended recipient you must not copy or disseminate the information contained in it, or take any action in reliance on it, without the written consent of the sender. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the Company are neither given nor endorsed by it. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Auto Load of Meta Data
Access 2007 can do lots with SharePoint too... it can be very powerful (and dangerous) Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@dws.com.aumailto:paul.tur...@dws.com.au W: www.dws.com.auhttps://webmail.dws.com.au/owa/UrlBlockedError.aspx ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. From: ozmoss-boun...@ozmoss.com [ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone [paul.no...@ceosyd.catholic.edu.au] Sent: Friday, 20 November 2009 12:59 PM To: ozMOSS Subject: RE: Auto Load of Meta Data • Export to an excel spreadsheet all the document names (sort by Name) and metadata for a single library. • Create a new view on the destination library that shows all metadata in the same column order as your spreadsheet - and order by Name! • Bulk upload all the documents to the library root. • Open in Datasheet view and paste your metadata column data. • Go back to standard view and check-in files. It’s not perfect but it’s the best OOTB solution we’ve found. Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of kawh...@monadel.com.au Sent: Friday, 20 November 2009 1:03 PM To: ozmoss@ozmoss.com Subject: Auto Load of Meta Data Hi everyone, Is there are tool or a facility available in Sharepoint that would allow you to bulk upload meta data to Sharepoint. For example we have meta data in an Access database and we would like to transfer it as sharepoint data We only have Sharepoint Lite. Regards, Kylea White Core Applications Analyst Monadelphous Group Limited | Grd Flr, 1 Sleat Rd T 08 93337063 | www.monadelphous.com.au P Please consider our environment before printing this e-mail _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Monadelphous E-mail disclaimer If you have received this message in error, please delete the e-mail and notify the sender. This e-mail (including all attachments) is the sole property of Monadelphous Group Ltd and may contain personal, confidential or legally privileged information including information subject to privacy legislation. Any confidentiality or privilege is not waived because this e-mail may have been sent to the wrong address. If you are not the intended recipient you must not copy or disseminate the information contained in it, or take any action in reliance on it, without the written consent of the sender. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the Company are neither given nor endorsed by it. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Auto Load of Meta Data
Could this be used to say add a new column and populate the field for existing documents? I.E. create a new column Part Number, add it to all content types, view it in datasheet view and add the data to the new column. I know I answered my own question there, I am just brain storming! Any other ways you guys would recommend? Regards, Marko From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 20 November 2009 12:29 PM To: ozMOSS Subject: RE: Auto Load of Meta Data * Export to an excel spreadsheet all the document names (sort by Name) and metadata for a single library. * Create a new view on the destination library that shows all metadata in the same column order as your spreadsheet - and order by Name! * Bulk upload all the documents to the library root. * Open in Datasheet view and paste your metadata column data. * Go back to standard view and check-in files. It's not perfect but it's the best OOTB solution we've found. Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of kawh...@monadel.com.au Sent: Friday, 20 November 2009 1:03 PM To: ozmoss@ozmoss.com Subject: Auto Load of Meta Data Hi everyone, Is there are tool or a facility available in Sharepoint that would allow you to bulk upload meta data to Sharepoint. For example we have meta data in an Access database and we would like to transfer it as sharepoint data We only have Sharepoint Lite. Regards, Kylea White Core Applications Analyst Monadelphous Group Limited | Grd Flr, 1 Sleat Rd T 08 93337063 | www.monadelphous.com.au P Please consider our environment before printing this e-mail _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Monadelphous E-mail disclaimer If you have received this message in error, please delete the e-mail and notify the sender. This e-mail (including all attachments) is the sole property of Monadelphous Group Ltd and may contain personal, confidential or legally privileged information including information subject to privacy legislation. Any confidentiality or privilege is not waived because this e-mail may have been sent to the wrong address. If you are not the intended recipient you must not copy or disseminate the information contained in it, or take any action in reliance on it, without the written consent of the sender. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the Company are neither given nor endorsed by it. This email and any files transmitted with it are intended solely for the use of the individual or entity to whom this email is addressed. This email's contents are confidential and may contain copyright and/or legally privileged information. If you are not the intended recipient, you must not read, print, store, copy, forward or use this email for any reason. If this e-mail was sent to you in error, please notify the sender by return email, and delete this email without making a copy. Any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. Thank you. Please consider the environment before printing this email ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss