42 thoughts on “Content Query Ticker Web Part”

1. Hello Andy,

   This looks fantastic, thank you for allowing download, however I am having problems making it work and wondered if you could help please, I have used the stsadm tool to add the solution to Sharepoint restarted IIS enabled the feature (we already have the publishing features enabled).

   I can add the webpart to the page but it just comes up saying unable to display this web part and when you try to modify it you get a could not load XSL file error.

   Many Thanks

   Alan.

2. Hi Alan,

   As well as adding the solution, you have to enable the feature. Go to your Site Collection Features administration page – has it been enabled?

3. Hello Andy,

   Thank you for your quick reply, we have enabled the feature on the site collection, however we are not so sure on whether or not we have installed the solution correctly.

   The steps we used are as follows (on the MOSS server under the sharepoint admin account)

   stsadm -o addsolution -filename c:\CQTickerWebPart.wsp
   stsadm -o deploysolution -name CQTickerWebPart.wsp -allowgacdeployment -immediate
   iisreset

   We then enabled the feature on the site collection which seemed to work correctly.

   The site collection that we are using is https://comp.dom.org/sites/sitecollectionname

   Many Thanks for your help

   Alan.

4. Hmm. Looks okay. If you’ve got SharePoint Designer, try looking in the Style Library for the root site of your site collection. That’s where the XSL gets installed to.

   I don’t know if it’s too late, but it might be worth examining your logs to see what happened (and if there were errors) during deployment of the solution, and activation of the feature on the site collection.

5. Hello Andy,

   Thanks for the advice, all the files appear to be where they are supposed to be and I can not find any logs with errors, however I may not be looking at the right logs! Looking at the Site Collection Features, the only ones not activated are Server Search Web Parts and Three-state workflow all other are enabled.

   We are running the Enterprise edition if that makes any difference.

   We also have versioning running.

   The only other thing that springs to mind is; do I need to make it a trusted source (Sorry not quite sure on the correct term, but remeber seing something mentioned about adding a line to a web.config file)

   The other thing i have noticed is that the feature does not appear in the Site’s feature list only the site collections feature list.

   Sorry to be a pain and thanks for your help

   Alan.

6. Yes, that’s all correct. It was developed on Enterprise, and it is a Site Collection feature. I’m not sure what the issue might be.

   This web part should not require changes to the web.config; it’s just the Content Query Web Part with some fancy XSL and a bit of JavaScript.

   I wonder – if you check the Style Library for the XSL, is it that the XSL file needs ‘approved’?

   Alternatively, does it look correct if you open up that XSL file?

   Final thought – it’s a bit rubbish, but have you tried uninstalling and reinstalling it?

   If push comes to shove, I could talk you through a manual installation, but that would be less than ideal.

7. From my experiences with content query webparts it seems that you have not modified the absolut pathes. In the CQWP you set the link to item.xsl and main.xsl, but it’s not possible up to my knowledge to make them site-relative. Therefore, you have to write a feature receiver that sets the correct URL. Otherwise you get the exeption shown above.
   Hope that helps
   Regards
   René

8. This is a great solution. I really like it.

   I was wondering if it is possible to have the option of changing to the next item with a next or previous button instead of the ticker based on time.

   Is that possible?

9. Yeah, you could do that. It would mean rewriting a chunk of the JavaScript, but it wouldn’t be that hard, and what I’ve made would make a good starting point.

   I don’t intend doing this, though, unless there’s lots of demand!

10. I understand that you wouldn’t want to rewrite it as this is already a great feature.

    I have tried to rewrite some of the JS but I am having a problem calling a function from the Main.xsl

    I have updated the JS so that it doesn’t run at the start

    I added this to the OuterTemplate in Main.xsl

    Is this way off?

    Thanks for any help you can provide.

    Also if I get this working I will post it up here to share with everyone.

11. sorry my last comment removed the html I put in. Here is What I added to the mail.xsl

    img onclick=”resumeTicker()” src=”\_layouts\images\PLSLBACK.GIF” border=”0″ alt=”none”/

    with the around it of course

12. I implemented this on my site but it conficts with another jquery menu I have on my site. I read about something to do with this not using a unique variable. Is this something that can be fixed

13. Hi,

    any hints on how to manage this in WSS 3.0?

14. Sorry Kelly, it won’t work in WSS 3.0. WSS3 doesn’t have the Content Query Web Part that this web part is based around.

15. Hi

    I really like this web part and I have had it working perfectly on my machine at home however when I attempt to deploy to my works environment it gives me the following errors:

    *****

    Unable to display this Web Part. To troubleshoot the problem, open this Web page in a
    Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator

    ****

    and when I open “modify shared web part”

    *****

    Could not load XSL file. The system cannot find the file specified. (Exception from HRESULT: 0×80070002)

    Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
    Troubleshoot issues with Windows SharePoint Services.

    ****

    The web part successfully deployed and central admin states that to me, the web part is activated as a site collection feature and appears in the gallery.

    All the assets are located in the style library which as admin I have full control over, each item is also published.

    The frustrating thing is that I have instgalled this on my local machine at home yet at work it fails. The only significant difference is that the local machine is

    http://someurl/

    and the one at work is

    http://someurl/sites/somesite

    The style library for each of the above examples is situated as follows:

    http://someurl/style library

    and the one at work is

    http://someurl/sites/somesite/style library

    Any help appreciated

16. Hi Andy,

    I’ve added and deployed the solution, however it does not show as a site feature and I therefore cannot activate it.

    However if I go to Central Administration – Solution Management, it shows as Globally Deployed.

    Any advice would be greatly appreciated.

17. Erm, that’s ‘cos it’s a Site Collection level feature! Did you check the Site Collection Features page, rather than the Site Features page?

18. Unable to display this Web Part. To troubleshoot the problem, open this Web page in a
    Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator

    ****

    and when I open “modify shared web part”

    *****

    Could not load XSL file. The system cannot find the file specified. (Exception from HRESULT: 0×80070002)

    Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
    Troubleshoot issues with Windows SharePoint Services.

    ****

    The web part successfully deployed and central admin states that to me, the web part is activated as a site collection feature and appears in the gallery.

    All the assets are located in the style library which as admin I have full control over, each item is also published.

    CAn anyone help me with this error everything seems fine but i am still getting this error any ideas???

19. Hmm. That’s weird. If the XSL is in the style Library (there should be a sub-folder – I forget what, something like “CQTWP”, with the .xsl files within), then it should just… work.

    Is it a multi-front end server environment, and the WSP hasn’t been deployed on both/all front end servers?

20. Hi Andy,

    Thanks for the great webpart – it’s 99% of what I’ve been trying to do for ages!

    Could you point me in the right direction of which bits of code I’d need to change to be able to display more than one item at a time? For example, I’d like to display 12 items in two groups of 6 – is this possible using your solution?

    Thanks again
    Mike

21. I think that would be in the JavaScript somewhere. SharePoint just renders the items as items in an unordered list – it’s javascript and CSS that then hides some of the list items.

22. I deployed the solution package and activated the feature at the site collection level. I went to web part gallery and when I clicked on the webpart, it said

    Unable to display this Web Part. To troubleshoot the problem, open this Web page in a
    Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator

    I had the same error msg when I tried to display my page that hasa DVWP. I could fix that by replacing LISTID with ListName ….http://blog.solanite.com/keith/Lists/Posts/Post.aspx?ID=3

    I don’t know how to fix that error in your example code. ANy thoughts?

    Thanks!

23. Does a standard Content Query Web Part work in your site? It sounds like the problem is related to that.

24. Is there a way to remove the hyperlink feature from the ticker message shown to the user ?

    I want a plain HTML (without hyperlink) to be shown newsticker web part ..

25. Hi Andy,

    The steps to install this web part would be executing this two commands:
    stsadm -o addsolution -filename c:\CQTickerWebPart.wsp
    stsadm -o deploysolution -name CQTickerWebPart.wsp -allowgacdeployment -immediate

    From what I see, there are 2 files for us to download:
    http://www.novolocus.com/files/cqtwp/CQTickerWebPart_1_0_0.zip
    http://www.novolocus.com/files/cqtwp/CQTickerWebPart_1_0_0_Code.zip

    Both folders have a .wsp file. May I know which one do I use when executing the add solution command?

    Regards,
    JH

26. Oh okay, I figured it out myself what the two files are for. Sorry for the dumb question haha.

27. Yes. Edit the XSL being used to display item. I forget the name of the file, but it should be pretty obvious – and you should be able to edit it using SharePoint designer.

28. Hey Everyone with the “Could not load XSL file. The system cannot find the file specified. (Exception from HRESULT: 0×80070002)” error!

    I got this error too, but I finally found a way to solve it!

    You have to check out your 3 xsl files in Style Library/XSL Style Sheets/CQTickerWP:
    Main.xsl, Header.xsl and ItemStyles.xsl.

    You have to edit the file, CQTickerWP.webpart, too.

    Edit all the links to your xsl files.

    Example:
    /Style Library/XSL Style Sheets/CQTickerWP/ItemStyles.xsl

    to

    /sites//Style Library/XSL Style Sheets/CQTickerWP/ItemStyles.xsl

    Fixed!

29. Hi,

    I have applied the changes as you mentioned but still the web part is giving problem. I

    have opened the page in SharePoint designer and I have checked the web part then I

    found wrong xsl path like /../../Style Library/XSL Style Sheets/CQTickerWP/ItemStyles.xsl.

    Even though after modifying this it didn’t works.

30. Andy, this is a great little utility you’ve made. Installed with no problems whatsoever. I did have some fun modifying some of the XSL for our own needs *shudder*

    I’m also going to be looking at adding ‘previous’, ‘next’ and ‘pause’ buttons. More fun :p

31. Hi,

    I just can’t get the ‘description’ field to work when selecting the Style ‘TitleandDescription’. I’ve tried this with various Lists e.g. Annoucements and I know they don’t have a @description field by default – I’ve looked at the items.xsl but can’t get any descriptions or even @body to appear. Any ideas?
    Thanks.

32. Not off the top of my head – Description did work for me, but I do get confused too about what column you have to get for a description. Sometimes it’s @Description, others @Body; either way it’s confusing.

33. This looks a great webPart, Does it work for Sharepoint 2010?

    Thanks again

    Ben

34. For those of you using this solution, it was mentioned to create a feature receiver to change the URL automatically for the specific site collection you are on.

    I was able to utilize a posting on another site that enabled me to do just this: http://blog.mastykarz.nl/inconvenient-content-query-web-part-server-relative-urls/

    NOTE: The code from the above mentioned blog utilizes Linq, so if you don’t have .NET 3.5 on your server you will need to change the webpart query to a loop.

    … Now to figure out how to add Prev / Next buttons …

35. Hi there, great article Andy!

    Do also check out my post in this subject, about how to use easySlider and create a template for a news ticker. Works for 2010.

    http://chrisstahl.wordpress.com/2011/07/18/display-news-pages-with-cqwp-–-part-3/

36. We have impleneted this web part on our 2010 intranet and there is an unusual amount of CPU spike (50%) on end users machive eveytime the news item changes. When the ticker changes to show a new item it spikes the CPU. Does anyone have the same problem, can anyone help me figure out why?

37. Hmm. Surprising. I guess it could the ‘fade-out, fade in’ being processed; I forget how that works, but would guess that that’s the most intensive bit of what it’s doing. What browser(s) are you using?

38. We’ve just moved to Sharepoint 2010 from 2007. We were using the CQ ticker for news releases. We customized the itemstyles.xml to show an image, the title, and then the description from and article page. Everything worked well until we went in to change the default number of items to display. Now the description has disappeared. Nothing I do can make it show. I have added it to the webpart options but still won’t display. Any ideas?

39. Not really, not off the top of my head. I’d suggest checking that the itemstyles.xml file is actually checked-in/published – I was forever forgetting to do that during development, and that led to some surprising results.

40. Hi,

    I need to have play/pause button on this webpart, please let me know how to have that in this webaprt.

    Thanks in advance..
    Unmesha

41. With Announcements on 2010 you need to edit the web part and put Body in the Body of the display fields section. Make sure you have changed @Description to @Body in the ItemStyle.xsl

42. Hi,

    I did not understand the solution given by JH (on August 20, 2010 at 9:31), is that someone has done the same thing?

    Tx for you help.