whitespace COMPANY whitespace SERVICES whitespace PRODUCTS whitespace PURCHASE whitespace SUPPORT whitespace CONTACTS whitespace Home whitespace Contact Us whitespace Site Map whitespace
whitespace
SUPPORT
whitespace
FORUM
whitespace
FAQS
whitespace
SUBSCRIPTION
whitespace
REQUEST ON-LINE
whitespace
whitespace

Technical Support Forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
bburke  
#1 Posted : Tuesday, May 4, 2010 6:15:47 PM(UTC)
bburke
Rank: Member

Groups: Registered
Joined: 4/18/2010(UTC)
Posts: 20

I am using the cross site lookup 1.2.

When using the bamboo list rollup web part there is extra data retreived. Example (in red); 8;#74D30 CBRN BNCOC When I use the WSS lookup (OOB) the extra characters do not appear.

UserPostedImage

Edited by user Tuesday, May 4, 2010 6:17:56 PM(UTC)  | Reason: Not specified

bburke  
#2 Posted : Tuesday, May 4, 2010 7:40:47 PM(UTC)
bburke
Rank: Member

Groups: Registered
Joined: 4/18/2010(UTC)
Posts: 20

It seems I'm unable to use the AB Cross Site Lookup data in other web parts (above) and Claculated columns.

The AB Cross Site Columns are not available when creating a calculated column.

UserPostedImage

I manually add the formula and receive this error:

One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)
at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)
Nazar  
#3 Posted : Wednesday, May 5, 2010 9:10:51 PM(UTC)
Guest
Rank: Guest

Groups: Guests
Joined: 7/9/2009(UTC)
Posts: 3,341

We will check our Cross-site Lookup column with this 3d-party web part and reply you soon.
NOTE: Standard SharePoint formula does not support Lookup columns.
Nazar  
#4 Posted : Thursday, May 6, 2010 2:03:38 PM(UTC)
Guest
Rank: Guest

Groups: Guests
Joined: 7/9/2009(UTC)
Posts: 3,341

There are two ways how to resolve this problem:
1) Convert Cross-Site Lookup to Standard SharePoint lookup column, then create List Rollup Data View Web Part, and then convert back this lookup column to ArtfulBits Cross-Site Lookup column.

2) Bamboo List Rollup web part create standard SharePoint DataFormWebPart. So you can customize this DataFromWebPart by manually modifying XSLT of this web part ( Modify Shared Web  XSL Editor  find and replace the following lines:
<td class="ms-vb2"><xsl:value-of select="@CrossSiteLookup" /></td>
replace to
<td class="ms-vb2"><xsl:value-of select="substring-after(@CrossSiteLookup,';#')" /></td>
where CrossSiteLookup is column name (for your case, please do it for Course, DO, Ship From, Ship To columns).
bshook  
#5 Posted : Monday, May 24, 2010 11:50:32 PM(UTC)
bshook
Rank: Newbie

Groups: Registered
Joined: 4/19/2010(UTC)
Posts: 7
Location: Odessa, TX

I am having this same issue with my List Rollup web part. I will try this. Thanks!!
bshook  
#6 Posted : Monday, May 24, 2010 11:56:18 PM(UTC)
bshook
Rank: Newbie

Groups: Registered
Joined: 4/19/2010(UTC)
Posts: 7
Location: Odessa, TX

I can not find those fields in the XSLT sheet.
stets  
#7 Posted : Thursday, May 27, 2010 3:12:31 PM(UTC)
stets
Rank: Developers Team

Groups: Registered
Joined: 5/27/2010(UTC)
Posts: 80
Location: Lviv

You should replace
<xsl:value-of select="@CrossSiteLookupColumnName" />
to
<xsl:value-of select="substring-after(@CrossSiteLookupColumnName,';#')" />
where CrossSiteLookupColumnName is internal name of Cross-Site Lookup column.

Let me know if you need any additional help.
bshook  
#8 Posted : Friday, May 28, 2010 9:44:59 PM(UTC)
bshook
Rank: Newbie

Groups: Registered
Joined: 4/19/2010(UTC)
Posts: 7
Location: Odessa, TX

Ok, I can get it to not display the ;# but it is still not sorting correctly.
Thanks,
Brad

Edited by user Saturday, May 29, 2010 12:45:50 AM(UTC)  | Reason: Not specified

File Attachment(s):
LRUGoals.txt (67kb) downloaded 4 time(s).

You cannot view/download attachments. Try to login or register.
stets  
#9 Posted : Monday, May 31, 2010 4:35:50 PM(UTC)
stets
Rank: Developers Team

Groups: Registered
Joined: 5/27/2010(UTC)
Posts: 80
Location: Lviv

Please use Cross-Site Lookup "conversion" feature. Convert Cross-Site Lookup to standard SharePoint lookup column, then generate new Data Form Web Part, and convert back this lookup column to ArtfulBits Cross-Site Lookup column.

Please let me know if it works for you.
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Company | Services | Practices | Technologies | Career | Contacts | Privacy
© 2005-2017 ArtfulBits. All rights reserved.