3

I want to export search result on CME to an excel file.

I found Export To Excel on SDL AppStore, but it's Supported products is blank and I cannot download it.

Can Export To Excel download search result?

Is Export To Excel available on SDL Web 8?

I also read the following post, and a respondent mentions there is an extension which can exports search result on Tridion 2011.

Is there any similar extension for SDL Web8?

Improve this question
9

You can also try the Export Item List alchemy plugin. It can be downloaded from here: https://www.alchemywebstore.com/plugins/Export-Item-List

If you want to customize or extend it the code is also available at https://github.com/saurabhgangwar/Alchemy.Plugins/tree/master/Alchemy.Plugins.ExportItemList

Improve this answer
  • Thanks.This is good extension.But I need 'Location(folder's path)' of search result view, so I'll try customize the extension. – Hirokazu Shikata Jan 10 '20 at 10:11
  • I found it's possible to customize the extension by editing JS file. But I'm afraid Alchemy's Terms and Conditions doesn't allow customizing programs.So could you write clearly that it's OK to customize the Extension to Alchemy's Plugin page, if there's no problem? – Hirokazu Shikata Mar 10 '20 at 3:33
  • Yeah, The code is public on the GitHub. Please feel free to customize it. – Saurabh Gangwar Mar 10 '20 at 5:43
  • Thank you for kindness.But according to Alchemy's Terms & Conditions, it doesn't seem to allow modify downloaded programs. So I'd like you to write clearly 'Export Item List can be customized freely' to Alchemy plugin page, otherwise customizing Export Item List can be license violation. – Hirokazu Shikata Mar 10 '20 at 7:26
  • Please ask a Question to Alchemy Support or here at Stack Exchange. I am sure the Alchemy Team will help you with this and the answer might help others. Personally I don't see any issue with this. Below is what I would do: 1. Get The Source Code from GitHub 2. Customize it 3.Build and Generate A4T file 4. Install the extension by dragging the A4T file in your CMS Alchemy Install Page. – Saurabh Gangwar Mar 10 '20 at 20:00
2

I tried to to download 'Export to Excel' from the App Store too and got the following message:

enter image description here

We have a version of 'Export to Excel' working on Tridion 8.5 at my current client. Unfortunately this isn't my code, so I can't just share it, so I suggest that you contact SDL Support to get a version from the App Store.

However, although the 'Export to Excel' button was available on the Search Results screen, nothing happened when I clicked on it.

I then saved the search results into a Virtual Search Folder, but the 'Export to Excel' tool gave an error when I clicked on it.

enter image description here

I then created a bundle and added all of the items from the Virtual Folder into the Bundle and the 'Export to Excel' functionality worked and gave me a CSV file.

You could probably miss out the middle step here (creating the Virtual Search Folder) and just add the search results to a Bundle and then use 'Export to Excel'.

Hope this helps!

Improve this answer
  • I asked about the 'Export To Excel' to SDL Support and SDL Community, but I couldn't know how to download it and whether is works. – Hirokazu Shikata Jan 9 '20 at 11:13
  • Did SDL Support reply? – Jonathan Williams Jan 9 '20 at 12:08
  • SDL Support just suggests asking about the extension to SDL Community. – Hirokazu Shikata Feb 6 '20 at 1:39
  • Well, that’s not very helpful of them! They can’t even supply you with the source code or point you in the direction of the git repo? – Jonathan Williams Feb 6 '20 at 2:09
  • SDL support only shared community's similar issue page. – Hirokazu Shikata Mar 10 '20 at 3:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.