Formato dos datos
O ficheiro JSON contén todo o que ten a organización. O arquivo ZIP contén o mesmo contido repartido en ficheiros de folla de cálculo, cos logotipos dos socios como ficheiros de imaxe.
Os campos que ten cada entidade, cos nomes que usan os formularios, lístanse na sección «Que contén…» da súa páxina dentro de Compoñentes: Organizacións, Unidades organizativas, Actividades de tratamento, Socios, Contactos, Contratos.
Formato do ficheiro JSON
Un único ficheiro estruturado, con:
| Organización | Nomes, enderezo, contactos, cor, logotipo, notas |
| Idiomas | Os idiomas configurados e cal é o predeterminado |
| Socios | Todos os socios, cos seus contactos |
| Contratos | Todos os contratos, cos socios e actividades que vinculan |
| Unidades e actividades | O nome de cada unidade organizativa e todas as actividades de tratamento, unha vez por idioma, con todos os seus campos e o seu estado activo/inactivo |
| Cores e contactos das unidades | A cor e os contactos de cada unidade organizativa, unha soa vez, porque son os mesmos en todos os idiomas |
| Modelos | Os modelos personalizados da organización |
Os membros e os seus roles non forman parte del: pertencen á conta de usuario, non ao rexistro. A grandes trazos, o ficheiro ten este aspecto:
{
"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": []
}
Formato do ficheiro de datos ZIP
O mesmo contido, dividido en ficheiros CSV: un por tipo de rexistro —a organización, os seus idiomas, socios, contactos, contratos e unidades organizativas— e un por idioma para as actividades. Cada rexistro é unha fila dun ficheiro, e os logotipos dos socios son ficheiros de imaxe nun cartafol logos. Pensado para abrilo e editalo nunha folla de cálculo, non para que o lea un script ou un asistente de IA.
Para unha organización co nome curto demo, o arquivo contén:
| Ficheiro | Contido |
|---|---|
demo-organization.csv | A propia organización: unha soa fila |
demo-locales.csv | Unha fila por idioma configurado |
demo-partners.csv | Unha fila por socio |
demo-contacts.csv | Unha fila por contacto, sexa dun socio ou dunha unidade organizativa |
demo-contracts.csv | Unha fila por contrato |
demo-ous.csv | Unha fila por unidade organizativa, teña ou non actividades: a súa cor e o seu nome en cada idioma |
demo-ropa-en.csv, demo-ropa-de.csv, … | Unha fila por actividade de tratamento, un ficheiro por idioma |
logos/partner-0.png, … | O logotipo de cada socio, como ficheiro de imaxe; só para os socios que teñen un |
demo-templates.json | Os modelos personalizados; só está se hai algún |
Descargar unha mostra: demo-export.zip, unha exportación completa da organización de demostración.
Todos os ficheiros seguen as mesmas convencións:
- UTF-8, separados por comas, cos nomes de columna na primeira fila. Unha cela que contén unha coma, comiñas ou un salto de liña envólvese entre comiñas dobres, e as comiñas interiores duplícanse; as follas de cálculo fano automaticamente.
- Os campos si/non conteñen
trueoufalse. - Os campos multivalor conteñen os seus valores separados por
|, p. ex.Contract|LegalObligation. - Cada cela contén un só valor. Os correos e teléfonos dun contacto ocupan columnas numeradas —
email1…email5,phoneNumber1…phoneNumber5—, xa que un contacto ten como máximo cinco de cada; as que non se usan quedan baleiras. A única excepción son os atributos por defecto da organización (defaultActivityAttributes), gardados como texto JSON nunha soa cela. - Os ficheiros refírense entre si por número:
controllers,processorsepartnerIdsconteñenorganizationIdde socios,activityIdsconténactivityId,ouIdliga unha actividade coa súa unidade organizativa, eparentTypeconparentIdligan un contacto co seu socio (partner, unorganizationId) ou coa súa unidade (ou, unouId). formatVersion, a primeira columna do ficheiro da organización, indica que estrutura ten o arquivo. Os arquivos exportados antes de que existise esta estrutura seguen a importarse.
demo-organization.csv
A configuración da propia organización: o formatVersion do arquivo, o seu nome curto, os contadores que numeran as novas unidades, actividades, socios e contratos, e os valores por defecto dunha actividade nova (defaultActivityAttributes, en JSON). Poucas veces terás que editar este ficheiro.
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
Os idiomas configurados e cal é o predeterminado. Cada idioma listado aquí ten o seu demo-ropa-<locale>.csv.
locale,isDefault
en,true
de,false
demo-partners.csv
Unha fila por socio; a propia organización é o socio 0. O enderezo postal repártese en columnas propias, organizationLogo indica o ficheiro do logotipo do socio no cartafol logos, e contractOrder é a orde en que se mostran os contratos do socio. Os contactos están en 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
Unha fila por contacto. parentType e parentId indican de quen é o contacto —partner e un organizationId, ou ou e un ouId— e as filas manteñen a orde de cada lista, así que o primeiro contacto dun socio ou dunha unidade vai primeiro. Un correo ocupa tres columnas (email, emailDescription, emailIsPrimary) e un teléfono catro (countryCode, phoneNumber, phoneDescription, phoneIsPrimary), cada unha numerada do 1 ao 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
Unha fila por contrato, que liga actividades e socios polos seus identificadores.
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
Unha fila por unidade organizativa, incluídas as que aínda non teñen actividades: ouId, a cor da unidade e unha columna name_<locale> por idioma, unha xunto á outra. É o único ficheiro que contén o nome dunha unidade; os seus contactos están en demo-contacts.csv.
ouId,ouColor,name_en,name_de
1,#C084FC,Human Resources,Personalwesen
2,#1c7958,Sales,Vertrieb
demo-ropa-en.csv
Unha fila por actividade. As dúas primeiras columnas son o idioma e ouId, o número da unidade organizativa da actividade (cuxo nome está en demo-ous.csv); o resto son os campos da actividade tal como aparecen no formulario. Os multivalor son legalbasis, legalbasisSpecial, dataCategories, activityCategories, controllers e 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
Os exemplos proveñen da organización de demostración, reducidos a dous socios, tres contratos, dúas linguas e dúas actividades.