date:20111019

RE: [SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

2011-10-19 Thread ken zheng

thanks Paul.

From: ptur...@smsmt.com
To: ozmoss@ozmoss.com
Date: Thu, 20 Oct 2011 15:00:58 +1100
Subject: RE: [SP2010]External Data  column cannot be edited in datasheet
viewin sharepoint 2010

I am sure I saw it in a MSDN article.. but can’t find it… here is an alternate 
source:

http://www.sharepointanalysthq.com/2010/07/bcs-external-list-limitations/

So the bottom line is “no”… if you have access to the original data source (SQL 
or something), you could try to update it there.

Regards

Paul Turner
Practice Lead - SharePoint
SMS Management & Technology

M 0412 748 168
paul.tur...@smsmt.com

www.smsmt.com

About SMS: Level 29, Westpac House, 91 King William Street, Adelaide SA 5095

SMS Management & Technology (SMS) [ASX:SMX] is Australia's largest publicly 
listed Management Services company. We solve complex problems and transform 
business through
 Consulting, Technology and Systems Integration
P
please consider the environment before printing this email

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com]
On Behalf Of ken zheng

Sent: Thursday, 20 October 2011 11:01 AM

To: ozmoss@ozmoss.com

Subject: [SP2010]External Data column cannot be edited in datasheet view in 
sharepoint 2010

Hi Guys,

  I have a list that has a couple of columns are extenral data. when editing 
individual item, you can edit it without problem. but if I switch to a 
datasheet view, you cann't edit them. the errors are "Teh Selected cells are 
read-only".

 So is that true you cannot edit the External Data column in datasheet view? 
any work around as I have 500 items to update and I do want to do it manually.

Cheers

Ken

NOTICE - This communication is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking
 any action in reliance on, this communication by persons or entities other 
than the intended recipient is prohibited. If you are not the intended 
recipient of this communication please delete and destroy all copies and 
telephone SMS Management & Technology
 on 1300 842 767 immediately. Any views expressed in this Communication are 
those of the individual sender, except where the sender specifically states 
them to be the views of SMS Management & Technology. Except as required by law, 
SMS Management & Technology
 does not represent, warrant and/or guarantee that the integrity of this 
communication has been maintained nor that the communication is free from 
errors, virus, interception or interference.

___
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

SP2010 Page layouts - RichImageField

2011-10-19 Thread Nigel Hertz

Hi all

I'm creating a page layout for news articles in our 2010 dev environment. On 
the page, I have a "Page image" field (PublishingWebControls:RichImageField) 
into which I want to add an image.

I've got a new page, using the above page layout. When editing it, I  can click 
the 'Click here to insert a picture from SharePoint', browse to an image, and 
insert it. As soon as I click save (either save and close, or save and keep 
editing) the image disappears, and it defaults back to the 'Click here to 
insert' I've checked all tag properties, and everything appears fine. 
Google isn't much helps - the only issues others seem to be having is that the 
page shows html instead of the image, but I'm not even getting that far.

Does anyone have any suggestions?


Kind Regards,
Nigel Hertz

SharePoint Administrator & Developer, Information Technology
Stockland, Level 25, 133 Castlereagh Street, Sydney NSW 2000
T: +61 2 9035 2617  M: +61 4 0103 4605
F: +61 2 8988 2617   E:  nigel.he...@stockland.com.au
www.stockland.com.au
Before printing this email, please consider the environment.


_

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

RE: [SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

2011-10-19 Thread Paul Turner

I am sure I saw it in a MSDN article.. but can't find it... here is an 
alternate source:

http://www.sharepointanalysthq.com/2010/07/bcs-external-list-limitations/

So the bottom line is "no"... if you have access to the original data source 
(SQL or something), you could try to update it there.

Regards

Paul Turner
Practice Lead - SharePoint
SMS Management & Technology

M 0412 748 168
paul.tur...@smsmt.com
www.smsmt.com
About SMS: Level 29, Westpac House, 91 King William Street, Adelaide SA 5095
SMS Management & Technology (SMS) [ASX:SMX] is Australia's largest publicly 
listed Management Services company. We solve complex problems and transform 
business through Consulting, Technology and Systems Integration
P please consider the environment before printing this email
[cid:image001.png@01CC8F34.E0EF9210]

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
ken zheng
Sent: Thursday, 20 October 2011 11:01 AM
To: ozmoss@ozmoss.com
Subject: [SP2010]External Data column cannot be edited in datasheet view in 
sharepoint 2010

Hi Guys,

  I have a list that has a couple of columns are extenral data. when editing 
individual item, you can edit it without problem. but if I switch to a 
datasheet view, you cann't edit them. the errors are "Teh Selected cells are 
read-only".

 So is that true you cannot edit the External Data column in datasheet view? 
any work around as I have 500 items to update and I do want to do it manually.

Cheers

Ken


NOTICE - This communication is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking any action in 
reliance on, this communication by persons or entities other than the intended 
recipient is prohibited. If you are not the intended recipient of this 
communication please delete and destroy all copies and telephone SMS Management 
& Technology on 1300 842 767 immediately. Any views expressed in this 
Communication are those of the individual sender, except where the sender 
specifically states them to be the views of SMS Management & Technology. Except 
as required by law, SMS Management & Technology does not represent, warrant 
and/or guarantee that the integrity of this communication has been maintained 
nor that the communication is free from errors, virus, interception or 
interference.
<>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

[SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

2011-10-19 Thread ken zheng


Hi Guys,

  I have a list that has a couple of columns are extenral data. when editing 
individual item, you can edit it without problem. but if I switch to a 
datasheet view, you cann't edit them. the errors are "Teh Selected cells are 
read-only".

 So is that true you cannot edit the External Data column in datasheet view? 
any work around as I have 500 items to update and I do want to do it manually.

Cheers

Ken
  <>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: Check null or empty on it field

2011-10-19 Thread Paul Noone

Thanks for all the different methods!

I’ve had no luck with the non-coalescing or ternary operators. Checking for 
null value simply doesn’t seem to cut it.

Finally cracked it with Salaman’s example.

string iTitle = "Untitled";
if (listItem["Title"] != null && 
SPEncode.HtmlEncode(listItem["Title"].ToString()) != string.Empty && 
!string.IsNullOrEmpty(listItem["Title"].ToString()))
{
iTitle = listItem["Title"].ToString();
}

Is it just me that goes through all this pain trying to achieve the most basic 
needs?

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Shahram Banihashem
Sent: Wednesday, 19 October 2011 10:40 PM
To: ozMOSS
Subject: Re: Check null or empty on it field

This is the way I go:

country = (item["Country"] ?? "No Country").ToString();

All in one line, neat and easy!

Regards,

Shahram.


From: Salman Ahmad 
To: ozmoss@ozmoss.com
Sent: Wednesday, 19 October 2011 10:21 PM
Subject: RE: Check null or empty on it field

It should work,

if (item["Country"] != null )
{
country = item["Country"].ToString();
}

You can also check this way,

if (item["Country"] != null && SPEncode.HtmlEncode(item["Country"].ToString()) 
!= string.Empty && !string.IsNullOrEmpty(item["Country"].ToString()))
{
country = item["Country"].ToString();
}

 Regards,
Salman Ahmad


From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 12:44:26 +1100
Subject: RE: Check null or empty on it field
That looks great Nigel thanks.

And the null-coalescing operator checks both null and empty?


From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Nigel Witherdin
Sent: Wednesday, 19 October 2011 12:42 PM
To: OzMoss
Subject: RE: Check null or empty on it field

Rather than pull the title out to a seperate string variable and then check on 
it, I would use something like:

string iTitle = (string)(spListItem["Title"] ?? "No Title");
string iDesc = (string)(spListItem["Description"] ?? "No description");

I believe casting the field value to string is more efficient then using a 
ToString function, and using the null-coalescing operator is more efficient 
then a seperate "if" statement (though I am prepared to be shouted down over 
this :)
Also, I think it is a lot neater in the code, and the same form can be used for 
different datatypes:

DateTime someDate = (DateTime)(item["Date Field Name"] ?? DateTime.MinValue);

Cheers,

Nigel


From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 11:10:58 +1100
Subject: Check null or empty on it field
Hi all,
I’m trying to put some checks in place to avoid exceptions when a field has no 
value. I had tried null but it didn’t seem to be enough. I’m now trying the 
following but continue to get an exception when a field in any item is empty.
Is there a more robust way to do this? Check length as well, or instead??
// Check the value for each string and supply a defualt if none exists
if (string.IsNullOrEmpty(iTitle))
{
iTitle = "No Title";
}
if (string.IsNullOrEmpty(iDesc))
{
iDesc = "No description";
}

Kind regards,

Paul Noone

---
Online Developer/SharePoint Administrator
Infrastructure Team, ICT
Catholic Education Office, Sydney
p: (02) 9568 8461
f: (02) 9568 8483
e: paul.no...@ceosyd.catholic.edu.au
w: http://www.ceosyd.catholic.edu.au/


___ 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

___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Re: Check null or empty on it field

2011-10-19 Thread Shahram Banihashem

This is the way I go:

country = (item["Country"] ?? "No Country").ToString();

All in one line, neat and easy!
 
Regards,
 
Shahram.



From: Salman Ahmad 
To: ozmoss@ozmoss.com
Sent: Wednesday, 19 October 2011 10:21 PM
Subject: RE: Check null or empty on it field


 
 
It should work,
 
if(item["Country"] != null)
{
country = item["Country"].ToString();
}
 
You can also check this way,
 
if(item["Country"] != null&& SPEncode.HtmlEncode(item["Country"].ToString()) != 
string.Empty && !string.IsNullOrEmpty(item["Country"].ToString()))
{
country = item["Country"].ToString();
}

 Regards,
Salman Ahmad
 



 From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 12:44:26 +1100
Subject: RE: Check null or empty on it field

  
That looks great Nigel thanks.
 
And the null-coalescing operator checks both null and empty?
 
 
From:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Nigel Witherdin
Sent: Wednesday, 19 October 2011 12:42 PM
To: OzMoss
Subject: RE: Check null or empty on it field
 
Rather than pull the title out to a seperate string variable and then check on 
it, I would use something like:
 
string iTitle = (string)(spListItem["Title"] ?? "No Title");
string iDesc = (string)(spListItem["Description"] ?? "No description");
 
I believe casting the field value to string is more efficient then using a 
ToString function, and using the null-coalescing operator is more efficient 
then a seperate "if" statement (though I am prepared to be shouted down over 
this :)
Also, I think it is a lot neater in the code, and the same form can be used for 
different datatypes:
 
DateTime someDate = (DateTime)(item["Date Field Name"] ?? DateTime.MinValue);
 
Cheers,
 
Nigel
 


 
From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 11:10:58 +1100
Subject: Check null or empty on it field
Hi all,
I’m trying to put some checks in place to avoid exceptions when a field has no 
value. I had tried null but it didn’t seem to be enough. I’m now trying the 
following but continue to get an exception when a field in any item is empty.
Is there a more robust way to do this? Check length as well, or instead??
// Check the value for each string and supply a defualt if none exists
if(string.IsNullOrEmpty(iTitle))
{
    iTitle = "No Title";
}
if(string.IsNullOrEmpty(iDesc))
{
    iDesc = "No description";
}
 
Kind regards,

Paul Noone
 
---
Online Developer/SharePoint Administrator
Infrastructure Team, ICT
Catholic Education Office, Sydney
p: (02) 9568 8461
f: (02) 9568 8483
e: paul.no...@ceosyd.catholic.edu.au
w: http://www.ceosyd.catholic.edu.au/
 

___ 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___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: Check null or empty on it field

2011-10-19 Thread Salman Ahmad


 
It should work,
 
if (item["Country"] != null )
{
country = item["Country"].ToString();
}
 
You can also check this way,
 
if (item["Country"] != null && SPEncode.HtmlEncode(item["Country"].ToString()) 
!= string.Empty && !string.IsNullOrEmpty(item["Country"].ToString()))
{
country = item["Country"].ToString();
}

 Regards,
Salman Ahmad
 



From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 12:44:26 +1100
Subject: RE: Check null or empty on it field








That looks great Nigel thanks.
 
And the null-coalescing operator checks both null and empty?
 
 


From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Nigel Witherdin
Sent: Wednesday, 19 October 2011 12:42 PM
To: OzMoss
Subject: RE: Check null or empty on it field
 

Rather than pull the title out to a seperate string variable and then check on 
it, I would use something like:
 
string iTitle = (string)(spListItem["Title"] ?? "No Title");
string iDesc = (string)(spListItem["Description"] ?? "No description");
 
I believe casting the field value to string is more efficient then using a 
ToString function, and using the null-coalescing operator is more efficient 
then a seperate "if" statement (though I am prepared to be shouted down over 
this :)
Also, I think it is a lot neater in the code, and the same form can be used for 
different datatypes:
 
DateTime someDate = (DateTime)(item["Date Field Name"] ?? DateTime.MinValue);
 
Cheers,
 
Nigel
 




From: paul.no...@ceosyd.catholic.edu.au
To: ozmoss@ozmoss.com
Date: Wed, 19 Oct 2011 11:10:58 +1100
Subject: Check null or empty on it field

Hi all,
I’m trying to put some checks in place to avoid exceptions when a field has no 
value. I had tried null but it didn’t seem to be enough. I’m now trying the 
following but continue to get an exception when a field in any item is empty.
Is there a more robust way to do this? Check length as well, or instead??
// Check the value for each string and supply a defualt if none exists
if (string.IsNullOrEmpty(iTitle))
{
iTitle = "No Title";
}
if (string.IsNullOrEmpty(iDesc))
{
iDesc = "No description";
}
 
Kind regards,

Paul Noone
 
---
Online Developer/SharePoint Administrator
Infrastructure Team, ICT
Catholic Education Office, Sydney
p: (02) 9568 8461
f: (02) 9568 8483
e: paul.no...@ceosyd.catholic.edu.au
w: http://www.ceosyd.catholic.edu.au/
 

___ 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: [SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

SP2010 Page layouts - RichImageField

RE: [SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

[SP2010]External Data column cannot be edited in datasheet view in sharepoint 2010

RE: Check null or empty on it field

Re: Check null or empty on it field

RE: Check null or empty on it field

7 matches

Site Navigation

Mail list logo

Footer information