I have a list of file names in Excel and would like to link to the SQL back end to verify each of those file names exists in AEM. How can I accomplish this?
Solved! Go to Solution.
Views
Replies
Total Likes
@SidCharming You can find how to setup groovy console here -
https://adobecommunity.com/pdf/meetup-1/AEM_Groovy_Console.pdf
https://aemgeeks.com/aem-tools/use-groovy-script-in-aem/
Some cool groovy scripts examples can be found here -
https://hashimkhan.in/aem-adobecq5-code-templates/groovy-script/
Other way out would be to use ACS commons MCP if you don't have groovy console installed in your AEM environment already.
https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp/index.html
Hope this helps.
@SidCharming I am not sure if i understand this correctly. Assuming that you have an excel containing a list of AEM resources (assets most likely) and you need to know if each of them exists in AEM or not, you can use any of the following based on your actual use case -
Hope this helps.
Thank you @Harwinder-singh, The list I have is just file names and it is in quantity of 45,000 names. I am new to AEM and feel your second option is what I'll need to do. Where do I go to learn how to do the Groovy scripting?
@SidCharming You can find how to setup groovy console here -
https://adobecommunity.com/pdf/meetup-1/AEM_Groovy_Console.pdf
https://aemgeeks.com/aem-tools/use-groovy-script-in-aem/
Some cool groovy scripts examples can be found here -
https://hashimkhan.in/aem-adobecq5-code-templates/groovy-script/
Other way out would be to use ACS commons MCP if you don't have groovy console installed in your AEM environment already.
https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp/index.html
Hope this helps.
Views
Likes
Replies
Views
Likes
Replies