<#list classifications as classificationKey, classification>
    ${classification.id}
</#list>

<#assign languageId="en-EN">
ClassifcationId,ClassificationDescription,GroupID,GroupDescription,GroupStatus
<#list classifications as classificationKey, classification>
    <#list classificationGroups as classificationId, classifications2classificationGroupMap>
        <#list classifications2classificationGroupMap as classificationGroupId, classificationGroup>
            ${classificationId},${classification.description(languageId)!},${classificationGroupId},${classificationGroup.description(languageId)!},${classificationGroup.statusId}
        </#list>
    </#list>
</#list>

ClassifcationId,ClassificationDescription,GroupID,GroupDescription,GroupStatus
jcatDemo,,Equipment,ZubehörEquipment,400
jcatDemo,,Computer,ComputerComputer,400
jcatDemo,,Monitors,MonitoreMonitors,400
jcatDemo,,Service,ServiceService,400
jcatDemo,,Tablet,TabletTablet,400
VariantAttributes,,Tablets,Tablets,400
VariantAttributes,,CarParts,,400
VariantAttributes,,BrakeDiscs,,400
VariantAttributes,,Cables,,400
VariantAttributes,,CoffeeMakers,,100
VariantAttributes,,HairCare,,400
VariantAttributes,,Rim,,400
VariantAttributes,,Wearables,,400
VariantAttributes,,Childseats,,100
VariantAttributes,,Software,,400
VariantAttributes,,Tires,,400
VariantAttributes,,MC_Tablets,,400
VariantAttributes,,Paints,Paints,400
CarParts,,Wheel,Complete wheels,100
CarParts,,BrakeCaliper,Brake Caliper,400
CarParts,,RoofRack,Roof-racks,100
CarParts,,BabyProducts,Baby Products,400
CarParts,,BrakeDiscs,Brake discs,100
...

<#macro escapeJson text>${text?js_string?replace("\\'", "\'")?replace("\\>",">")}</#macro>
<#assign languages = ["de-DE", "en-GB"]>
{
  "classifications" : [ <#list classifications as classificationKey, classification>{
    "classificationId" : "${classification.id!}",
    "createdOn" : "${.now?iso_utc}",
    "changedOn" : "${.now?iso_utc}",
    "classificationSN" : "${classification.classificationSN!}",
    "description" : {<#list languages as language>
      "${language}" : "<@escapeJson classification.description(language)!/>"<#sep>,</#list>
    },
    "longDescription" : {<#list languages as language>
      "${language}" : "<@escapeJson classification.longDescription[language]!/>"<#sep>,</#list>
    },
    "type" : "${classification.type!}",
    "hierarchyCode" : "${classification.hierarchyCode!}",
    "versionNo" : "${classification.versionNo!}",
    "orderNo" : "${classification.orderNo!}",
    "documentUrl1" : "${classification.documentUrl1!}",
    "documentUrl2" : "${classification.documentUrl2!}",
    "documentUrl3" : "${classification.documentUrl3!}",
    "classificationGroups" : [
    <#list classificationGroups as classificationId, classifications2classificationGroupMap>
      <#list classifications2classificationGroupMap as classificationGroupId, classificationGroup> {
        "classificationGroupId" : "${classificationGroupId}",
        "createdOn" : "${.now?iso_utc}",
        "changedOn" : "${.now?iso_utc}",
        "description" : {<#list languages as language>
          "${language}" : "<@escapeJson classificationGroup.description(language)!/>"<#sep>,</#list>
        },
        "longDescriptions" : {<#list languages as language>
          "${language}" : "<@escapeJson classificationGroup.longDescriptions[language]!/>"<#sep>,</#list>
        },
        "fallbackDescShort" : "<@escapeJson classificationGroup.fallbackShortDescription!/>",
        "classificationGroupSN" : "${classificationGroup.classificationGroupSN}",
        "statusId" : "${classificationGroup.statusID!}",
        "hierarchyCode" : "${classificationGroup.hierarchyCode!}",
        "orderNo" : "${classificationGroup.orderNo!}",
        "concatenatedInformation" : "<@escapeJson classificationGroup.concatenatedInformation!/>}",
        "documentUrl1" : "${classificationGroup.documentUrl1!}",
        "documentUrl2" : "${classificationGroup.documentUrl2!}",
        "documentUrl3" : "${classificationGroup.documentUrl3!}",
        "parentClassificationGroupId" : "${classificationGroup.parentClassificationGroupId!}"
        "parentClassificationGroupSN" : "${classificationGroup.parentClassificationGroupSN!}"
      }
      <#sep>,</#list>
    </#list> ]
  }<#sep>,</#list> ]
}