Hello,
I need someone to convert data from Adobe Experience Manager (AEM) into a CSV file.
The files from AEM are in XML files that are in a Java Content Repository (JCR) format.
Each XML file is in its own folder, in the format of:
year/month/day/article-title/[login to view URL]
You would need to loop through each folder and add the contents of each file into one line of the CSV file. The end result would be that each file/article is added into one CSV file
I do not need all the data from the files, but just:
Author
Content
Lead
FeaturedImagePath
Section
onTime
The will be 9 sites that this needs to happen to. I have an example of the XML file that would need to be converted and added to the CSV.