Format de les dades
El fitxer JSON conté tot el que té l'organització. L'arxiu ZIP conté el mateix contingut repartit en fitxers de full de càlcul, amb els logotips dels socis com a fitxers d'imatge.
Els camps que té cada entitat, amb els noms que fan servir els formularis, es llisten a la secció «Què conté…» de la seva pàgina dins de Components: Organitzacions, Unitats organitzatives, Activitats de tractament, Socis, Contactes, Contractes.
Format del fitxer JSON
Un únic fitxer estructurat, amb:
| Organització | Noms, adreça, contactes, color, logotip, notes |
| Idiomes | Els idiomes configurats i quin és el predeterminat |
| Socis | Tots els socis, amb els seus contactes |
| Contractes | Tots els contractes, amb els socis i activitats que vinculen |
| Unitats i activitats | El nom de cada unitat organitzativa i totes les activitats de tractament, una vegada per idioma, amb tots els seus camps i el seu estat actiu/inactiu |
| Colors i contactes de les unitats | El color i els contactes de cada unitat organitzativa, una sola vegada, perquè són els mateixos en tots els idiomes |
| Plantilles | Les plantilles personalitzades de l'organització |
Els membres i els seus rols no en formen part: pertanyen al compte d'usuari, no al registre. A grans trets, el fitxer té aquest aspecte:
{
"exportVersion": 1,
"exportedAt": "2026-05-18T00:00:00.000Z",
"organization": {
"licenseStart": 0,
"licenseEnd": 0,
"licenseCost": 0,
"shortName": "demo",
"isBlocked": false,
"isPublic": true,
"isDemo": true,
"highestOuId": 4,
"highestActivityId": 7,
"highestPartnerId": 7,
"highestContractId": 11,
"schemaVersion": 15,
"defaultActivityAttributes": {
"activityId": 0,
"activityName": "",
"role": "Controller",
"purposeShort": "",
"purposeLong": "",
"legalbasis": ["Consent"],
"legalbasisLong": "",
"legalbasisSpecial": ["ExplicitConsent"],
"dataCategories": ["Characteristics", "Identification"],
"datasubjectCategories": "",
"activityCategories": ["DataCollection", "DataStorage"],
"dataOrigin": "",
"timeLimit": "",
"profiling": false,
"communications": "",
"communicationsLong": "",
"controllers": [0],
"processors": [],
"transfers": false,
"transfersLong": "",
"securityLevel": "low",
"securityMeasuresLong": "",
"active": false,
"createdAt": 0,
"updatedAt": 0
},
"partners": [
{
"organizationId": 0,
"organizationName": "TEST",
"organizationNameLong": "Demo Organization",
"organizationColor": "#2563EB",
"organizationWebsite": "",
"organizationPostalAddress": {
"addressLine1": "Test Avenue",
"addressLine2": "Test Org Main Office",
"city": "Testville",
"stateProvince": "",
"postalCode": "00000",
"country": "LX"
},
"organizationLogo": null,
"organizationLogoVersion": null,
"organizationVatNumber": "",
"organizationNotes": "Self organization. This is the organization owning this ROPA.",
"organizationContacts": [
{
"contactId": 1,
"contactFirstname": "John",
"contactLastname": "Smith",
"contactRole": "DPO",
"contactEmails": [
{
"email": "dpo@test-organization.com",
"description": "DPO Office",
"isPrimary": true
}
],
"contactPhoneNumbers": [
{
"countryCode": "+1",
"phoneNumber": "5551234567",
"description": "Office",
"isPrimary": true
}
],
"contactNotes": "Data Protection Officer. Primary contact for GDPR compliance matters.",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
],
"contractOrder": [],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"organizationId": 1,
"organizationName": "CloudStore",
"organizationNameLong": "CloudStore Solutions Inc.",
"organizationColor": "#0891B2",
"organizationWebsite": "https://www.cloudstore-demo.com",
"organizationPostalAddress": {
"addressLine1": "123 Tech Boulevard",
"addressLine2": "Suite 400",
"city": "San Francisco",
"stateProvince": "California",
"postalCode": "94105",
"country": "US"
},
"organizationLogo": null,
"organizationLogoVersion": null,
"organizationVatNumber": "",
"organizationNotes": "Cloud storage provider for document archiving and backup services. Primary data processor for file storage.",
"organizationContacts": [
{
"contactId": 1,
"contactFirstname": "Sarah",
"contactLastname": "Mitchell",
"contactRole": "DPO",
"contactEmails": [
{
"email": "sarah.mitchell@cloudstore-demo.com",
"description": "Work",
"isPrimary": true
},
{
"email": "dpo@cloudstore-demo.com",
"description": "DPO Office",
"isPrimary": false
}
],
"contactPhoneNumbers": [
{
"countryCode": "+1",
"phoneNumber": "4155551234",
"description": "Office",
"isPrimary": true
},
{
"countryCode": "+1",
"phoneNumber": "4155559876",
"description": "Mobile",
"isPrimary": false
}
],
"contactNotes": "Available Mon-Fri 9am-5pm PST. Preferred contact for data protection matters.",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"contactId": 2,
"contactFirstname": "James",
"contactLastname": "Rodriguez",
"contactRole": "Technical",
"contactEmails": [
{
"email": "james.rodriguez@cloudstore-demo.com",
"description": "Work",
"isPrimary": true
}
],
"contactPhoneNumbers": [
{
"countryCode": "+1",
"phoneNumber": "4155552345",
"description": "Office",
"isPrimary": true
}
],
"contactNotes": "Technical lead for API integration and data migration projects.",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"contactId": 3,
"contactFirstname": "Emily",
"contactLastname": "Chen",
"contactRole": "Support",
"contactEmails": [
{
"email": "emily.chen@cloudstore-demo.com",
"description": "Work",
"isPrimary": true
},
{
"email": "support@cloudstore-demo.com",
"description": "Support Team",
"isPrimary": false
}
],
"contactPhoneNumbers": [
{
"countryCode": "+1",
"phoneNumber": "4155553456",
"description": "Support Line",
"isPrimary": true
}
],
"contactNotes": "Customer support manager. Contact for service issues and incidents.",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
],
"contractOrder": [1, 9],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
],
"ropas": [
{
"locale": "en",
"isDefault": true
},
{
"locale": "de",
"isDefault": false
}
],
"contracts": [
{
"contractId": 1,
"contractName": "HR-SYS-2024",
"contractUrl": "https://example.com/contracts/hr-sys-2024",
"contractExpirationDate": "2025-12-31",
"contractDescription": "HR management system service agreement including payroll processing and training management",
"activityIds": [1],
"partnerIds": [1],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"contractId": 2,
"contractName": "DPA-BENEFITS-2024",
"contractUrl": "https://example.com/contracts/dpa-benefits",
"contractExpirationDate": "2026-06-30",
"contractDescription": "Data processing agreement for employee benefits administration and healthcare coordination",
"activityIds": [1],
"partnerIds": [5],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"contractId": 3,
"contractName": "OSH-2024",
"contractUrl": "https://example.com/contracts/osh-2024",
"contractExpirationDate": "2025-08-31",
"contractDescription": "Occupational safety and health surveillance service agreement with medical assessment provider",
"activityIds": [3],
"partnerIds": [2],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
],
"ous": [
{
"ouId": 1,
"ouColor": "#C084FC",
"ouContacts": [
{
"contactId": 1,
"contactFirstname": "Laura",
"contactLastname": "Novak",
"contactRole": "HR Manager",
"contactEmails": [
{
"email": "hr@test-organization.com",
"description": "HR Office",
"isPrimary": true
}
],
"contactPhoneNumbers": [
{
"countryCode": "+1",
"phoneNumber": "5551230001",
"description": "Office",
"isPrimary": true
}
],
"contactNotes": "Owns the staff records and answers employees' data access requests.",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
{
"contactId": 2,
"contactFirstname": "Peter",
"contactLastname": "Hall",
"contactRole": "Payroll Lead",
"contactEmails": [
{
"email": "payroll@test-organization.com",
"description": "Work",
"isPrimary": true
}
],
"contactPhoneNumbers": [],
"contactNotes": "",
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
]
},
{
"ouId": 2,
"ouColor": "#1c7958",
"ouContacts": []
}
],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
},
"ropas": [
{
"orgId": "",
"orgShortName": "demo",
"locale": "en",
"ous": [
{
"ouName": "Human Resources",
"ouId": 1,
"activities": [
{
"activityId": 1,
"activityName": "Staff Management",
"purposeShort": "Staff management",
"purposeLong": "Management of training, payroll, promotion, and other aspects related to work life",
"legalbasis": ["Contract", "LegalObligation"],
"legalbasisLong": "",
"legalbasisSpecial": ["Employment", "Healthcare"],
"dataCategories": ["Identification"],
"datasubjectCategories": "Students; Other individuals related to the University; Former students",
"activityCategories": [
"DataCollection",
"DataGeneration",
"DataAccess"
],
"dataOrigin": "From the data subject or their legal representative; Reuse of data already held by the controller in other processing operations",
"timeLimit": "As long as necessary to fulfill the purpose for which they were collected and to determine possible responsibilities arising from the processing. Until consent is revoked.",
"profiling": false,
"communications": "-",
"communicationsLong": "-",
"controllers": [0],
"processors": [1, 5],
"transfers": true,
"transfersLong": "International transfers (outside the EEA) of personal data may be made to companies providing information society services, subject to the signing of contracts, and to other institutions with which data transfer agreements have been signed, in both cases respecting legality",
"securityLevel": "low",
"securityMeasuresLong": "Not required.",
"activityExpirationDate": "2099-12-31",
"forcedInactive": false,
"active": false,
"createdAt": 0,
"updatedAt": 0
}
]
},
{
"ouName": "Sales",
"ouId": 2,
"activities": [
{
"activityId": 4,
"activityName": "Customer Management",
"purposeShort": "Customer management",
"purposeLong": "Order management, logistics, billing, and collections management",
"legalbasis": ["Contract"],
"legalbasisLong": "",
"legalbasisSpecial": [],
"dataCategories": ["Identification"],
"datasubjectCategories": "Customers",
"activityCategories": [
"DataCollection",
"DataGeneration",
"DataAccess"
],
"dataOrigin": "From other public administrations or private entities; From the data subject or their legal representative",
"timeLimit": "As long as necessary to fulfill the purpose for which they were collected and to determine possible responsibilities arising from the processing.",
"profiling": true,
"communications": "",
"communicationsLong": "",
"controllers": [0],
"processors": [4],
"transfers": false,
"transfersLong": "Not made",
"securityLevel": "medium",
"securityMeasuresLong": "Not required.",
"activityExpirationDate": "2099-12-31",
"forcedInactive": false,
"active": true,
"createdAt": 0,
"updatedAt": 0
}
]
}
],
"createdAt": "2026-05-18T00:00:00.000Z",
"updatedAt": "2026-05-18T00:00:00.000Z"
}
],
"templates": []
}
Format del fitxer de dades ZIP
El mateix contingut repartit en fitxers CSV: un per tipus de registre —l'organització, els seus idiomes, socis, contactes, contractes i unitats organitzatives— i un per idioma per a les activitats. Cada registre és una fila d'un fitxer, i els logotips dels socis són fitxers d'imatge en una carpeta logos. Pensat per obrir-lo i editar-lo en un full de càlcul, no perquè el llegeixi un script o un assistent d'IA.
Per a una organització amb el nom curt demo, l'arxiu conté:
| Fitxer | Contingut |
|---|---|
demo-organization.csv | L'organització mateixa: una sola fila |
demo-locales.csv | Una fila per idioma configurat |
demo-partners.csv | Una fila per soci |
demo-contacts.csv | Una fila per contacte, tant si és d'un soci com d'una unitat organitzativa |
demo-contracts.csv | Una fila per contracte |
demo-ous.csv | Una fila per unitat organitzativa, tingui activitats o no: el seu color i el seu nom en cada idioma |
demo-ropa-en.csv, demo-ropa-de.csv, … | Una fila per activitat de tractament, un fitxer per idioma |
logos/partner-0.png, … | El logotip de cada soci, com a fitxer d'imatge; només per als socis que en tenen |
demo-templates.json | Les plantilles personalitzades; només hi és si n'hi ha |
Descarregar una mostra: demo-export.zip, una exportació completa de l'organització de demostració.
Tots els fitxers segueixen les mateixes convencions:
- UTF-8, separats per comes, amb els noms de columna a la primera fila. Una cel·la que conté una coma, cometes o un salt de línia s'envolta amb cometes dobles, i les cometes interiors es dupliquen; els fulls de càlcul ho fan automàticament.
- Els camps sí/no contenen
trueofalse. - Els camps multivalor contenen els valors separats per
|, p. ex.Contract|LegalObligation. - Cada cel·la conté un sol valor. Els correus i telèfons d'un contacte ocupen columnes numerades —
email1…email5,phoneNumber1…phoneNumber5—, ja que un contacte en té com a màxim cinc de cada; les que no es fan servir queden buides. L'única excepció són els atributs per defecte de l'organització (defaultActivityAttributes), desats com a text JSON en una sola cel·la. - Els fitxers es refereixen entre ells per número:
controllers,processorsipartnerIdscontenenorganizationIdde socis,activityIdscontéactivityId,ouIdenllaça una activitat amb la seva unitat organitzativa, iparentTypeambparentIdenllacen un contacte amb el seu soci (partner, unorganizationId) o la seva unitat (ou, unouId). formatVersion, la primera columna del fitxer de l'organització, indica quina estructura té l'arxiu. Els arxius exportats abans que existís aquesta estructura es continuen important.
demo-organization.csv
La configuració de l'organització: el formatVersion de l'arxiu, el nom curt, els comptadors que numeren les noves unitats, activitats, socis i contractes, i els valors per defecte d'una activitat nova (defaultActivityAttributes, en JSON). Rarament hauràs d'editar aquest fitxer.
formatVersion,shortName,licenseStart,licenseEnd,licenseCost,isBlocked,isPublic,isDemo,highestOuId,highestActivityId,highestPartnerId,highestContractId,schemaVersion,defaultActivityAttributes
2,demo,0,0,0,false,true,true,4,7,7,11,15,"{""activityId"":0,""activityName"":"""",""role"":""Controller"",""purposeShort"":"""",""purposeLong"":"""",""legalbasis"":[""Consent""],""legalbasisLong"":"""",""legalbasisSpecial"":[""ExplicitConsent""],""dataCategories"":[""Characteristics"",""Identification""],""datasubjectCategories"":"""",""activityCategories"":[""DataCollection"",""DataStorage""],""dataOrigin"":"""",""timeLimit"":"""",""profiling"":false,""communications"":"""",""communicationsLong"":"""",""controllers"":[0],""processors"":[],""transfers"":false,""transfersLong"":"""",""securityLevel"":""low"",""securityMeasuresLong"":"""",""active"":false,""createdAt"":0,""updatedAt"":0}"
demo-locales.csv
Els idiomes configurats i quin és el predeterminat. Cada idioma llistat aquí té el seu demo-ropa-<locale>.csv.
locale,isDefault
en,true
de,false
demo-partners.csv
Una fila per soci; la mateixa organització és el soci 0. L'adreça postal es reparteix en columnes pròpies, organizationLogo indica el fitxer del logotip del soci a la carpeta logos, i contractOrder és l'ordre en què es mostren els contractes del soci. Els contactes són a demo-contacts.csv.
organizationId,organizationName,organizationNameLong,organizationColor,organizationWebsite,organizationVatNumber,addressLine1,addressLine2,city,stateProvince,postalCode,country,organizationLogo,organizationNotes,contractOrder
0,TEST,Demo Organization,#2563EB,,,Test Avenue,Test Org Main Office,Testville,,00000,LX,,Self organization. This is the organization owning this ROPA.,
1,CloudStore,CloudStore Solutions Inc.,#0891B2,https://www.cloudstore-demo.com,,123 Tech Boulevard,Suite 400,San Francisco,California,94105,US,,Cloud storage provider for document archiving and backup services. Primary data processor for file storage.,1|9
demo-contacts.csv
Una fila per contacte. parentType i parentId indiquen de qui és el contacte —partner i un organizationId, o ou i un ouId— i les files mantenen l'ordre de cada llista, de manera que el primer contacte d'un soci o d'una unitat va primer. Un correu ocupa tres columnes (email, emailDescription, emailIsPrimary) i un telèfon quatre (countryCode, phoneNumber, phoneDescription, phoneIsPrimary), cadascuna numerada de l'1 al 5.
parentType,parentId,contactId,contactFirstname,contactLastname,contactRole,contactNotes,email1,emailDescription1,emailIsPrimary1,email2,emailDescription2,emailIsPrimary2,email3,emailDescription3,emailIsPrimary3,email4,emailDescription4,emailIsPrimary4,email5,emailDescription5,emailIsPrimary5,countryCode1,phoneNumber1,phoneDescription1,phoneIsPrimary1,countryCode2,phoneNumber2,phoneDescription2,phoneIsPrimary2,countryCode3,phoneNumber3,phoneDescription3,phoneIsPrimary3,countryCode4,phoneNumber4,phoneDescription4,phoneIsPrimary4,countryCode5,phoneNumber5,phoneDescription5,phoneIsPrimary5
partner,0,1,John,Smith,DPO,Data Protection Officer. Primary contact for GDPR compliance matters.,dpo@test-organization.com,DPO Office,true,,,,,,,,,,,,,+1,5551234567,Office,true,,,,,,,,,,,,,,,,
partner,1,1,Sarah,Mitchell,DPO,Available Mon-Fri 9am-5pm PST. Preferred contact for data protection matters.,sarah.mitchell@cloudstore-demo.com,Work,true,dpo@cloudstore-demo.com,DPO Office,false,,,,,,,,,,+1,4155551234,Office,true,+1,4155559876,Mobile,false,,,,,,,,,,,,
partner,1,2,James,Rodriguez,Technical,Technical lead for API integration and data migration projects.,james.rodriguez@cloudstore-demo.com,Work,true,,,,,,,,,,,,,+1,4155552345,Office,true,,,,,,,,,,,,,,,,
partner,1,3,Emily,Chen,Support,Customer support manager. Contact for service issues and incidents.,emily.chen@cloudstore-demo.com,Work,true,support@cloudstore-demo.com,Support Team,false,,,,,,,,,,+1,4155553456,Support Line,true,,,,,,,,,,,,,,,,
ou,1,1,Laura,Novak,HR Manager,Owns the staff records and answers employees' data access requests.,hr@test-organization.com,HR Office,true,,,,,,,,,,,,,+1,5551230001,Office,true,,,,,,,,,,,,,,,,
ou,1,2,Peter,Hall,Payroll Lead,,payroll@test-organization.com,Work,true,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
demo-contracts.csv
Una fila per contracte, que enllaça activitats i socis pels seus identificadors.
contractId,contractName,contractUrl,contractExpirationDate,contractDescription,activityIds,partnerIds
1,HR-SYS-2024,https://example.com/contracts/hr-sys-2024,2025-12-31,HR management system service agreement including payroll processing and training management,1,1
2,DPA-BENEFITS-2024,https://example.com/contracts/dpa-benefits,2026-06-30,Data processing agreement for employee benefits administration and healthcare coordination,1,5
3,OSH-2024,https://example.com/contracts/osh-2024,2025-08-31,Occupational safety and health surveillance service agreement with medical assessment provider,3,2
demo-ous.csv
Una fila per unitat organitzativa, incloses les que encara no tenen activitats: ouId, el color de la unitat i una columna name_<locale> per idioma, una al costat de l'altra. És l'únic fitxer que conté el nom d'una unitat; els seus contactes són a demo-contacts.csv.
ouId,ouColor,name_en,name_de
1,#C084FC,Human Resources,Personalwesen
2,#1c7958,Sales,Vertrieb
demo-ropa-en.csv
Una fila per activitat. Les dues primeres columnes són l'idioma i ouId, el número de la unitat organitzativa de l'activitat (el nom de la qual és a demo-ous.csv); la resta són els camps de l'activitat tal com apareixen al formulari. Els multivalor són legalbasis, legalbasisSpecial, dataCategories, activityCategories, controllers i processors.
locale,ouId,activityId,activityName,purposeShort,purposeLong,legalbasis,legalbasisLong,legalbasisSpecial,dataCategories,datasubjectCategories,activityCategories,dataOrigin,timeLimit,profiling,communications,communicationsLong,controllers,processors,transfers,transfersLong,securityLevel,securityMeasuresLong,active,activityExpirationDate,forcedInactive,createdAt,updatedAt
en,1,1,Staff Management,Staff management,"Management of training, payroll, promotion, and other aspects related to work life",Contract|LegalObligation,,Employment|Healthcare,Identification,Students; Other individuals related to the University; Former students,DataCollection|DataGeneration|DataAccess,From the data subject or their legal representative; Reuse of data already held by the controller in other processing operations,As long as necessary to fulfill the purpose for which they were collected and to determine possible responsibilities arising from the processing. Until consent is revoked.,false,-,-,0,1|5,true,"International transfers (outside the EEA) of personal data may be made to companies providing information society services, subject to the signing of contracts, and to other institutions with which data transfer agreements have been signed, in both cases respecting legality",low,Not required.,false,2099-12-31,false,0,0
en,2,4,Customer Management,Customer management,"Order management, logistics, billing, and collections management",Contract,,,Identification,Customers,DataCollection|DataGeneration|DataAccess,From other public administrations or private entities; From the data subject or their legal representative,As long as necessary to fulfill the purpose for which they were collected and to determine possible responsibilities arising from the processing.,true,,,0,4,false,Not made,medium,Not required.,true,2099-12-31,false,0,0
Els exemples provenen de l'organització de demostració, reduïts a dos socis, tres contractes, dues llengües i dues activitats.