RE: MultiColumn Custom Field Problem

[Paul Turner]

If you add the related field via public override void OnAdded(SPAddFieldOptions 
op) then it will always exist in the list.



i.e.



SPFieldText relatedField;

// Set the related field.
if (this.RelatedField == null || this.RelatedField.Length == 0)
{
if (this.ParentList != null)
{
if (!this.ParentList.Fields.ContainsField(this.InternalName 
+ "_Display"))
{
string intName = 
this.ParentList.Fields.Add(this.InternalName + " (linked to item)", 
SPFieldType.Text, true);

relatedField = 
(SPFieldText)this.ParentList.Fields.GetFieldByInternalName(intName);
relatedField.Title = this.Title + " (linked to item)";
relatedField.Hidden = true;
relatedField.ShowInDisplayForm = false;
relatedField.ShowInEditForm = false;
relatedField.ShowInNewForm = false;
relatedField.ShowInVersionHistory = false;
relatedField.ShowInViewForms = true;
relatedField.ShowInListSettings = true;
relatedField.Required = false;
this.RelatedField = relatedField.InternalName;
relatedField.Update(true);
}
}
}



Then in public override void UpdateFieldValueInItem() just update the related 
field value



i.e.



 if (this.Field.RelatedField != null)
{
this.VerifyRelatedFieldOnList(this.ListItem, 
this.Field.RelatedField); // <--- runs the same code as above to force it into 
existance so it can't be deleted...
this.ListItem[this.Field.RelatedField] = displayString;
}








Regards,

Paul Turner
MCT, MCPD: Enterprise, MCSD, MCDBA, MCTS, Microsoft vTSP
Consultant

M: 0412 748 168
A: 66 Henley Beach Road, Mile End SA 5031
E: paul.tur...@dws.com.au  W: 
www.dws.com.au

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 James 
Boman [james.bo...@i-pmo.com.au]
Sent: Wednesday, 9 March 2011 12:34 PM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem

Couple of downsides of related field property to keep in mind:

1.   In my experience the RelatedField property breaks site templates, as 
its not part of the schema.

2.   The only way to display the value of the related field in list view is 
to use CAML DisplayPatterns that are now deprecated. If you try to use XSL 
rendering for the field you cannot get the VALUE of the related field if it is 
not already in the view – so no matter how good your XPATH skills are, you 
can’t make a custom field that renders the contents of a related field if the 
related field is not in the view.

Where does this leave you?

• Use standard custom properties on your custom field to store the 
name(s) of your related field(s).

• Use the related fields in the list views to enable 
sorting/grouping/filtering, while using the custom field in the 
new/edit/display forms.

Cheers,
James.


From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul Turner
Sent: Wednesday, 9 March 2011 11:40 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem


Use related fields (set it's value to what you want to sort on).



http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfield.relatedfield.aspx



http://msdn.microsoft.com/en-us/library/ms459059.aspx



Regards,

Paul Turner
MCT, MCPD: Enterprise, MCSD, MCDBA, MCTS, Microsoft vTSP
Consultant

M: 0412 748 168
A: 66 Henley Beach Road, Mile End SA 5031
E: paul.tur...@dws.com.au  W: 
www.dws.com.au

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 James 
Boman [james.bo...@i-pmo.com.au]
Sent: Wednesday, 9 March 2011 10:10 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Pr

RE: MultiColumn Custom Field Problem

[James Boman]

Couple of downsides of related field property to keep in mind:

1.   In my experience the RelatedField property breaks site templates, as 
its not part of the schema.

2.   The only way to display the value of the related field in list view is 
to use CAML DisplayPatterns that are now deprecated. If you try to use XSL 
rendering for the field you cannot get the VALUE of the related field if it is 
not already in the view - so no matter how good your XPATH skills are, you 
can't make a custom field that renders the contents of a related field if the 
related field is not in the view.

Where does this leave you?

* Use standard custom properties on your custom field to store the 
name(s) of your related field(s).

* Use the related fields in the list views to enable 
sorting/grouping/filtering, while using the custom field in the 
new/edit/display forms.

Cheers,
James.


From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul Turner
Sent: Wednesday, 9 March 2011 11:40 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem


Use related fields (set it's value to what you want to sort on).



http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfield.relatedfield.aspx



http://msdn.microsoft.com/en-us/library/ms459059.aspx



Regards,

Paul Turner
MCT, MCPD: Enterprise, MCSD, MCDBA, MCTS, Microsoft vTSP
Consultant

M: 0412 748 168
A: 66 Henley Beach Road, Mile End SA 5031
E: paul.tur...@dws.com.au  W: 
www.dws.com.au

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 James 
Boman [james.bo...@i-pmo.com.au]
Sent: Wednesday, 9 March 2011 10:10 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem
When making custom fields, the underlying data type is very important.  The 
Multi-Column Value Type is very useful for storing arrays of values, but the 
downside is that it can't be sorted, filtered, grouped, indexed or edited using 
the normal SharePoint UI.

You might want to consider changing to a different underlying data type to get 
more OOB functionality.  We have several custom fields that when added to a 
list, create other simple columns in the list that don't appear on the 
new/edit/display forms to enable indexing, grouping and other OOB features.

Cheers,
J.

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul English
Sent: Wednesday, 9 March 2011 10:02 AM
To: 'ozmoss@ozmoss.com'
Subject: MultiColumn Custom Field Problem

I'm having an issue with a custom field that I've created.  It is a MultiColumn 
field that renders a list of names taken from a BDC.  The problem I have is 
when I add the column to a Document library I get the following message appear.

"This field type cannot be edited from most client programs and might block the 
programs from saving documents to this library."

When I create a new document in the library the Doc panel displays the control 
but is greyed out and says "Edit property on server". I've set the 
"AllowBaseTypeRendering" property to True and the "ParentType" property is 
MultiColumn in my fieldtypes.xml as suggested in several Google posts but this 
hasn't made any difference. The field seems to work fine when added to a List.

Has anybody been able to resolve this problem using a DropDown? Could it be 
because Word doesn't recognise dropdowns as MultiColumns ?

Thanks

Paul






The information transmitted by this e-mail is intended only for the addressee 
and may contain confidential  and/or privileged material. Any interception, 
review, retransmission, dissemination, or other use of, or taking of any action 
upon this information by persons or entities other than the intended recipient 
is prohibited by law and may subject them to criminal or civil liability. 
Unless explicitly attributed, the opinions expressed are personal and not those 
of HomeStart or the South Australian Government. If you received this 
communication in error, please contact us immediately at 
ad...@homestart.com.au, and delete the 
communication.
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: MultiColumn Custom Field Problem

[Paul Turner]

Use related fields (set it's value to what you want to sort on).



http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfield.relatedfield.aspx



http://msdn.microsoft.com/en-us/library/ms459059.aspx




Regards,

Paul Turner
MCT, MCPD: Enterprise, MCSD, MCDBA, MCTS, Microsoft vTSP
Consultant

M: 0412 748 168
A: 66 Henley Beach Road, Mile End SA 5031
E: paul.tur...@dws.com.au  W: 
www.dws.com.au

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 James 
Boman [james.bo...@i-pmo.com.au]
Sent: Wednesday, 9 March 2011 10:10 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem

When making custom fields, the underlying data type is very important.  The 
Multi-Column Value Type is very useful for storing arrays of values, but the 
downside is that it can’t be sorted, filtered, grouped, indexed or edited using 
the normal SharePoint UI.

You might want to consider changing to a different underlying data type to get 
more OOB functionality.  We have several custom fields that when added to a 
list, create other simple columns in the list that don’t appear on the 
new/edit/display forms to enable indexing, grouping and other OOB features.

Cheers,
J.

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul English
Sent: Wednesday, 9 March 2011 10:02 AM
To: 'ozmoss@ozmoss.com'
Subject: MultiColumn Custom Field Problem

I’m having an issue with a custom field that I’ve created.  It is a MultiColumn 
field that renders a list of names taken from a BDC.  The problem I have is 
when I add the column to a Document library I get the following message appear.

“This field type cannot be edited from most client programs and might block the 
programs from saving documents to this library.”

When I create a new document in the library the Doc panel displays the control 
but is greyed out and says “Edit property on server”. I’ve set the 
“AllowBaseTypeRendering” property to True and the “ParentType” property is 
MultiColumn in my fieldtypes.xml as suggested in several Google posts but this 
hasn’t made any difference. The field seems to work fine when added to a List.

Has anybody been able to resolve this problem using a DropDown? Could it be 
because Word doesn’t recognise dropdowns as MultiColumns ?

Thanks

Paul






The information transmitted by this e-mail is intended only for the addressee 
and may contain confidential  and/or privileged material. Any interception, 
review, retransmission, dissemination, or other use of, or taking of any action 
upon this information by persons or entities other than the intended recipient 
is prohibited by law and may subject them to criminal or civil liability. 
Unless explicitly attributed, the opinions expressed are personal and not those 
of HomeStart or the South Australian Government. If you received this 
communication in error, please contact us immediately at 
ad...@homestart.com.au, and delete the 
communication.
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: attachments issue in DVWP, published page vs draft

[Nigel Hertz]

I wish I could help with this - because that would mean I'd actually got it 
working this side. It works fine until I save the page template, and then I get 
'unspecified errors'.

What I'm trying to do sounds similar to your solution - I'll be interested to 
see if I end up with the same problem or not.




From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Dan Sheedy
Sent: Wednesday, 9 March 2011 10:38 AM
To: ozMOSS
Subject: attachments issue in DVWP, published page vs draft

Hi.

I've got a single item DVWP displaying items from a list (we get the ID of the 
item to display from a query string parameter), it also displays the attachment 
using this;


server
{C0FB9150-7B78-4831-9098-8CE6CD7D31F3}
Attachments
Display
true



We have the problem that when the page the DVWP is in draft, it displays the 
correct attachments for all items.

When the page is published it will display the correct attachments for the 
first item you view, then go on to show those same attachments for all other 
items. It will 'reset' itself when recycle the app pool.

Any help would be appreciated.

Thanks,

Dan.

_

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: MultiColumn Custom Field Problem

[James Boman]

Alternatively - if anyone has figured out how to get a Custom Field based on 
Multi-Column values to be grouped/sorted/filtered, I would be very interested!

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
James Boman
Sent: Wednesday, 9 March 2011 10:10 AM
To: ozMOSS
Subject: RE: MultiColumn Custom Field Problem

When making custom fields, the underlying data type is very important.  The 
Multi-Column Value Type is very useful for storing arrays of values, but the 
downside is that it can't be sorted, filtered, grouped, indexed or edited using 
the normal SharePoint UI.

You might want to consider changing to a different underlying data type to get 
more OOB functionality.  We have several custom fields that when added to a 
list, create other simple columns in the list that don't appear on the 
new/edit/display forms to enable indexing, grouping and other OOB features.

Cheers,
J.

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul English
Sent: Wednesday, 9 March 2011 10:02 AM
To: 'ozmoss@ozmoss.com'
Subject: MultiColumn Custom Field Problem

I'm having an issue with a custom field that I've created.  It is a MultiColumn 
field that renders a list of names taken from a BDC.  The problem I have is 
when I add the column to a Document library I get the following message appear.

"This field type cannot be edited from most client programs and might block the 
programs from saving documents to this library."

When I create a new document in the library the Doc panel displays the control 
but is greyed out and says "Edit property on server". I've set the 
"AllowBaseTypeRendering" property to True and the "ParentType" property is 
MultiColumn in my fieldtypes.xml as suggested in several Google posts but this 
hasn't made any difference. The field seems to work fine when added to a List.

Has anybody been able to resolve this problem using a DropDown? Could it be 
because Word doesn't recognise dropdowns as MultiColumns ?

Thanks

Paul






The information transmitted by this e-mail is intended only for the addressee 
and may contain confidential  and/or privileged material. Any interception, 
review, retransmission, dissemination, or other use of, or taking of any action 
upon this information by persons or entities other than the intended recipient 
is prohibited by law and may subject them to criminal or civil liability. 
Unless explicitly attributed, the opinions expressed are personal and not those 
of HomeStart or the South Australian Government. If you received this 
communication in error, please contact us immediately at 
ad...@homestart.com.au, and delete the 
communication.
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: MultiColumn Custom Field Problem

[James Boman]

When making custom fields, the underlying data type is very important.  The 
Multi-Column Value Type is very useful for storing arrays of values, but the 
downside is that it can't be sorted, filtered, grouped, indexed or edited using 
the normal SharePoint UI.

You might want to consider changing to a different underlying data type to get 
more OOB functionality.  We have several custom fields that when added to a 
list, create other simple columns in the list that don't appear on the 
new/edit/display forms to enable indexing, grouping and other OOB features.

Cheers,
J.

From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Paul English
Sent: Wednesday, 9 March 2011 10:02 AM
To: 'ozmoss@ozmoss.com'
Subject: MultiColumn Custom Field Problem

I'm having an issue with a custom field that I've created.  It is a MultiColumn 
field that renders a list of names taken from a BDC.  The problem I have is 
when I add the column to a Document library I get the following message appear.

"This field type cannot be edited from most client programs and might block the 
programs from saving documents to this library."

When I create a new document in the library the Doc panel displays the control 
but is greyed out and says "Edit property on server". I've set the 
"AllowBaseTypeRendering" property to True and the "ParentType" property is 
MultiColumn in my fieldtypes.xml as suggested in several Google posts but this 
hasn't made any difference. The field seems to work fine when added to a List.

Has anybody been able to resolve this problem using a DropDown? Could it be 
because Word doesn't recognise dropdowns as MultiColumns ?

Thanks

Paul






The information transmitted by this e-mail is intended only for the addressee 
and may contain confidential  and/or privileged material. Any interception, 
review, retransmission, dissemination, or other use of, or taking of any action 
upon this information by persons or entities other than the intended recipient 
is prohibited by law and may subject them to criminal or civil liability. 
Unless explicitly attributed, the opinions expressed are personal and not those 
of HomeStart or the South Australian Government. If you received this 
communication in error, please contact us immediately at 
ad...@homestart.com.au, and delete the 
communication.
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

attachments issue in DVWP, published page vs draft

[Dan Sheedy]

Hi.

I've got a single item DVWP displaying items from a list (we get the ID of
the item to display from a query string parameter), it also displays the
attachment using this;


server
{C0FB9150-7B78-4831-9098-8CE6CD7D31F3}
Attachments
Display
true



We have the problem that when the page the DVWP is in draft, it displays the
correct attachments for all items.

When the page is published it will display the correct attachments for the
first item you view, then go on to show those same attachments for all other
items. It will 'reset' itself when recycle the app pool.

Any help would be appreciated.

Thanks,

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

MultiColumn Custom Field Problem

[Paul English]

I'm having an issue with a custom field that I've created.  It is a MultiColumn 
field that renders a list of names taken from a BDC.  The problem I have is 
when I add the column to a Document library I get the following message appear.

"This field type cannot be edited from most client programs and might block the 
programs from saving documents to this library."

When I create a new document in the library the Doc panel displays the control 
but is greyed out and says "Edit property on server". I've set the 
"AllowBaseTypeRendering" property to True and the "ParentType" property is 
MultiColumn in my fieldtypes.xml as suggested in several Google posts but this 
hasn't made any difference. The field seems to work fine when added to a List.

Has anybody been able to resolve this problem using a DropDown? Could it be 
because Word doesn't recognise dropdowns as MultiColumns ?

Thanks

Paul







The  information  transmitted  by  this e-mail is intended only
for the addressee  and  may  contain  confidential  and/or
privileged material. Any interception, review, retransmission,
dissemination, or  other  use of, or taking of any action upon
this information by persons or entities other than the
intended recipient is prohibited by law and may subject them
to criminal or civil liability.
Unless explicitly attributed, the opinions expressed are personal
and not those of HomeStart or the South Australian Government.
If you received this communication
in error, please contact us immediately at
ad...@homestart.com.au, and delete the communication.

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

Re: Linking lists

[Craig Harvey]

Hi Marko,

Turning this on it's head it is possible to created a Linked Table in Access
which will make the SharePoint List available in your database. You can then
craft some SQL queries in Access to do the 'import' and association of the
reference data. (i.e. insert into LinkedSPList select blah from
AccessTable).

Regards,
Craig



On 9 March 2011 09:04, Marko Salonen wrote:

>  Hi Daniel
>
> Thanks for the link. I know this work for new lists, but when I am
> importing a linked table from access after I add the lookup column its
> obviously empty.
> I was more after how can I programatically perhaps enforce something like
>
> table 1 join table 2 where t1key = t2key
> set t1value = t2value
>
> I suppose I could do this in the access database before importing the data?
> But I don't think converting the column to a lookup field would then work...
>
>
> Regards,
>
> Marko Salonen
>
>
>  --
> *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On
> Behalf Of *Daniel Brown
> *Sent:* Tuesday, 8 March 2011 5:49 PM
> *To:* 'ozMOSS'
> *Subject:* RE: Linking lists
>
>HI Marko,
>
>
>
> Welcome back to the world of SharePoint!!! (rocks back and forth), a lot of
> places are still on 2007, but there is a move to SP2010 which has been
> building steady for awhile now, I would say it’s pretty much how new SP are
> well and truly done these days, unless there are requirements not to.
>
>
>
> Lookup Fields are what you are after, You simply create a column in your
> desired list (table a) of type “lookup”, select the list (table b) and what
> you want for the ID/Value and done.
>
>
>
> A good example is at http://phase2.com/blog/?p=101
>
>
>
> Hope this helps J
>
>
>
> Cheers,
>
>
>
> Daniel
>
>
>
>
>
> *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On
> Behalf Of *Marko Salonen
> *Sent:* Tuesday, 8 March 2011 5:31 PM
> *To:* ozMOSS
> *Subject:* Linking lists
>
>
>
> Hi all
>
>
>
> I have been away from SharePoint for a bit (almost a year), and I am
> guessing most places have gone to 2010? Anybody other than where I
> work still using 2007? Nice to be back in the world of SharePoint anyway...
>
>
>
> I have a requirement to import some old access databases into SharePoint
> lists and I am wondering how to link the tables in SharePoint?
>
> Specifically if Table 1 has a column A that is the value from Table 2
> column B how can I get it to lookup the value?
>
>
>
> Cheers!
>
> Marko
>
> MORETON BAY REGIONAL COUNCIL (MBRC) PRIVILEGED PRIVATE AND CONFIDENTIAL -
> The information contained in this e-mail and any attachments is confidential
> and may attract legal privilege. It is only intended for the named
> recipient/s. If you are not a named recipient any use of this information
> including copying, distribution and publication is prohibited.
> Confidentiality and legal privilege are not waived or lost as a result of
> mistaken or erroneous delivery. If you are not a named recipient, please
> delete all copies immediately and contact the sender to advise of the error.
>
> It is recommended that you scan this email and any attachment before
> opening. MBRC does not accept any responsibility or liability for loss or
> damage arising directly or indirectly from opening this email, opening any
> attachments or any communication errors.
>
> The views expressed in this email and any attachments are the personal
> views of the sender unless otherwise stated.
>
> ___
> 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: Workflows, Stats and ... Videos!

[Paul Turner]

Have a look at Information Mangement Policies too, that will track downloads 
and views.




Regards,

Paul Turner
MCT, MCPD: Enterprise, MCSD, MCDBA, MCTS, Microsoft vTSP
Consultant

M: 0412 748 168
A: 66 Henley Beach Road, Mile End SA 5031
E: paul.tur...@dws.com.au  W: 
www.dws.com.au

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 Ajay 
[akhanna...@gmail.com]
Sent: Wednesday, 9 March 2011 5:46 AM
To: ozMOSS
Subject: Re: Workflows, Stats and ... Videos!

SharePoint 2010 EE has web analytic feature, I haven't worked with it so not 
sure if it can track the things you are after OOTB.

For ideas.. you can also have a look at http://pks.codeplex.com/ .. which

""Retrieve instant ROI and metrics with the ability to track the number of 
podcasts downloaded and/or viewed, instant feedback via rating system and 
comments, and subscribers via the RSS feed""



On Wed, Mar 9, 2011 at 1:35 AM, Uzma Naz 
mailto:uz_my_...@hotmail.com>> wrote:
Hiya,

I have a client who is looking at using WebEx to host videos and track number 
of hits (like youtube) and who viewed them.

I'm looking at using SharePoint to host videos instead. I've been looking into 
how we can meet requirements, such as show how many times a video has been 
viewed and information on who viewed it and when.

How can I best achieve this as I can't see a solution that I can recommend 
online?

I was thinking maybe if I had a SharePoint list which is populated via a 
workflow once a video has been viewed fully and record information such as 
time, user name and video URL?

Thanks,

Uzma

___
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: Linking lists

[Ajay]

I think you can populate the lookup column in code if it helps, maybe using
a console application ...

Just saw this on a blog to update lookup columns
http://blogs.msdn.com/b/sridhara/archive/2007/08/25/update-quot-lookup-quot-fields-in-sharepoint-2007.aspx

string result = string.Empty;
SPSite site = new SPSite("");
SPWeb web = site.OpenWeb();
SPListItemCollection listItems = web.Lists["listwithlookupfield"].Items;
foreach (SPListItem listItem in listItems)
{
if (listItem["Quantity"].ToString() == "100")
{ // update Product lookup field
result += "Current value: " + listItem["ProductLookUp"].ToString() +
System.Environment.NewLine;
listItem["Product"] = new SPFieldLookupValue(1, "A");
listItem.Update();
result += "Updated value: " + listItem["ProductLookUp"].ToString();
}
}
tbresults.Text = result;


On Wed, Mar 9, 2011 at 11:04 AM, Marko Salonen <
marko.salo...@moretonbay.qld.gov.au> wrote:

>  Hi Daniel
>
> Thanks for the link. I know this work for new lists, but when I am
> importing a linked table from access after I add the lookup column its
> obviously empty.
> I was more after how can I programatically perhaps enforce something like
>
> table 1 join table 2 where t1key = t2key
> set t1value = t2value
>
> I suppose I could do this in the access database before importing the data?
> But I don't think converting the column to a lookup field would then work...
>
>
> Regards,
>
> Marko Salonen
>
>
>  --
> *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On
> Behalf Of *Daniel Brown
> *Sent:* Tuesday, 8 March 2011 5:49 PM
> *To:* 'ozMOSS'
> *Subject:* RE: Linking lists
>
>  HI Marko,
>
>
>
> Welcome back to the world of SharePoint!!! (rocks back and forth), a lot of
> places are still on 2007, but there is a move to SP2010 which has been
> building steady for awhile now, I would say it’s pretty much how new SP are
> well and truly done these days, unless there are requirements not to.
>
>
>
> Lookup Fields are what you are after, You simply create a column in your
> desired list (table a) of type “lookup”, select the list (table b) and what
> you want for the ID/Value and done.
>
>
>
> A good example is at http://phase2.com/blog/?p=101
>
>
>
> Hope this helps J
>
>
>
> Cheers,
>
>
>
> Daniel
>
>
>
>
>
> *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On
> Behalf Of *Marko Salonen
> *Sent:* Tuesday, 8 March 2011 5:31 PM
> *To:* ozMOSS
> *Subject:* Linking lists
>
>
>
> Hi all
>
>
>
> I have been away from SharePoint for a bit (almost a year), and I am
> guessing most places have gone to 2010? Anybody other than where I
> work still using 2007? Nice to be back in the world of SharePoint anyway...
>
>
>
> I have a requirement to import some old access databases into SharePoint
> lists and I am wondering how to link the tables in SharePoint?
>
> Specifically if Table 1 has a column A that is the value from Table 2
> column B how can I get it to lookup the value?
>
>
>
> Cheers!
>
> Marko
>
> MORETON BAY REGIONAL COUNCIL (MBRC) PRIVILEGED PRIVATE AND CONFIDENTIAL -
> The information contained in this e-mail and any attachments is confidential
> and may attract legal privilege. It is only intended for the named
> recipient/s. If you are not a named recipient any use of this information
> including copying, distribution and publication is prohibited.
> Confidentiality and legal privilege are not waived or lost as a result of
> mistaken or erroneous delivery. If you are not a named recipient, please
> delete all copies immediately and contact the sender to advise of the error.
>
> It is recommended that you scan this email and any attachment before
> opening. MBRC does not accept any responsibility or liability for loss or
> damage arising directly or indirectly from opening this email, opening any
> attachments or any communication errors.
>
> The views expressed in this email and any attachments are the personal
> views of the sender unless otherwise stated.
>
> ___
> 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: Linking lists

[Marko Salonen]

Hi Daniel

Thanks for the link. I know this work for new lists, but when I am importing a 
linked table from access after I add the lookup column its obviously empty.
I was more after how can I programatically perhaps enforce something like

table 1 join table 2 where t1key = t2key
set t1value = t2value

I suppose I could do this in the access database before importing the data? But 
I don't think converting the column to a lookup field would then work...


Regards,

Marko Salonen




From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Daniel Brown
Sent: Tuesday, 8 March 2011 5:49 PM
To: 'ozMOSS'
Subject: RE: Linking lists

HI Marko,

Welcome back to the world of SharePoint!!! (rocks back and forth), a lot of 
places are still on 2007, but there is a move to SP2010 which has been building 
steady for awhile now, I would say it's pretty much how new SP are well and 
truly done these days, unless there are requirements not to.

Lookup Fields are what you are after, You simply create a column in your 
desired list (table a) of type "lookup", select the list (table b) and what you 
want for the ID/Value and done.

A good example is at http://phase2.com/blog/?p=101

Hope this helps :)

Cheers,

Daniel


From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of 
Marko Salonen
Sent: Tuesday, 8 March 2011 5:31 PM
To: ozMOSS
Subject: Linking lists

Hi all

I have been away from SharePoint for a bit (almost a year), and I am guessing 
most places have gone to 2010? Anybody other than where I work still using 
2007? Nice to be back in the world of SharePoint anyway...

I have a requirement to import some old access databases into SharePoint lists 
and I am wondering how to link the tables in SharePoint?
Specifically if Table 1 has a column A that is the value from Table 2 column B 
how can I get it to lookup the value?

Cheers!

Marko

MORETON BAY REGIONAL COUNCIL (MBRC) PRIVILEGED PRIVATE AND CONFIDENTIAL - The 
information contained in this e-mail and any attachments is confidential and 
may attract legal privilege. It is only intended for the named recipient/s. If 
you are not a named recipient any use of this information including copying, 
distribution and publication is prohibited. Confidentiality and legal privilege 
are not waived or lost as a result of mistaken or erroneous delivery. If you 
are not a named recipient, please delete all copies immediately and contact the 
sender to advise of the error.

It is recommended that you scan this email and any attachment before opening. 
MBRC does not accept any responsibility or liability for loss or damage arising 
directly or indirectly from opening this email, opening any attachments or any 
communication errors.

The views expressed in this email and any attachments are the personal views of 
the sender unless otherwise stated.
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Re: Workflows, Stats and ... Videos!

[Ajay]

SharePoint 2010 EE has web analytic feature, I haven't worked with it so not
sure if it can track the things you are after OOTB.

For ideas.. you can also have a look at http://pks.codeplex.com/ .. which

""Retrieve instant ROI and metrics with the ability to track the number of
podcasts downloaded and/or viewed, instant feedback via rating system and
comments, and subscribers via the RSS feed""



On Wed, Mar 9, 2011 at 1:35 AM, Uzma Naz  wrote:

>  Hiya,
>
> I have a client who is looking at using WebEx to host videos and track
> number of hits (like youtube) and who viewed them.
>
> I'm looking at using SharePoint to host videos instead. I've been looking
> into how we can meet requirements, such as show how many times a video has
> been viewed and information on who viewed it and when.
>
> How can I best achieve this as I can't see a solution that I can recommend
> online?
>
> I was thinking maybe if I had a SharePoint list which is populated via a
> workflow once a video has been viewed fully and record information such as
> time, user name and video URL?
>
> Thanks,
>
> Uzma
>
> ___
> 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

Workflows, Stats and ... Videos!

[Uzma Naz]

Hiya, 
 
I have a client who is looking at using WebEx to host videos and track number 
of hits (like youtube) and who viewed them. 

I'm looking at using SharePoint to host videos instead. I've been looking into 
how we can meet requirements, such as show how many times a video has been 
viewed and information on who viewed it and when. 
 
How can I best achieve this as I can't see a solution that I can recommend 
online? 
 
I was thinking maybe if I had a SharePoint list which is populated via a 
workflow once a video has been viewed fully and record information such as 
time, user name and video URL? 
 
Thanks, 
 
Uzma  ___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss