Overview
The client receives one folder containing 20 data CSV files plus the original files: customer photos, treatment note drawings, uploaded documents and every completed form or consent as a PDF.
Format: UTF-8 CSV, comma-separated, first row is the header. Records link to each other by their Collums IDs (e.g.
customerIdinappointments.csvmatchescustomer_idincustomers.csv).Files: each file folder has its own CSV index that maps a file to its customer.
Customer and clinical data
customers.csv– Customer records
Columns: customer_id, firstName, surname, dateOfBirth, email, gender, active, title, accountBalance, mobilePhone, address1, address2, postcode, city, country, state, createdAt, notes, marketingTypes, notificationTypesnotes.csv– Customer notes
Columns: customer, firstname, surname, appointment, employee_id, employee, location, createdAt, status, notetreatment-notes.csv– Treatment notes
Columns: treatment_note_id, appointment_ids, serviceId, customerId, firstName, middleName, surname, service, createdAt, practitionerId, practitionerFirstName, practitionerSurname, notestreatment-fillers.csv– Filler treatment records
Columns: treatment_note_id, appointment_ids, treatmentType, serviceId, service, expiry, lotNo, quantity, productId, productName, customer, createdAt, practitionerId, practitionerName, usedProductstreatment-toxins.csv– Toxin treatment records
Columns: treatment_note_id, appointment_ids, treatmentType, serviceId, service, expiry, lotNo, unit, dilution, productId, productName, customer, createdAt, practitionerId, practitionerName, usedProductsprescriptions.csv– Prescriptions
Columns: prescription_id, customerId, customerName, customerSurname, prescriberId, prescriberName, prescriberSurname, clinic, archived, sent, createdAtprescriptionitems.csv– Prescribed items
Columns: prescriptionitem_id, prescription_id, customerId, customerName, customerSurname, item, form, strength, doseUnit, frequency, quantity, route, duration, durationUnit, notes, createdAt
marketingTypes and notificationTypes hold the channels the customer agreed to (SMS, Email), comma-separated. usedProducts is stored as JSON text inside the cell.
Appointments and clinic setup
appointments.csv– Appointments (type Appointment only)
Columns: appointment_id, serviceId, customerId, firstName, middleName, surname, startTime, endTime, practitionerId, practitionerFirstName, practitionerSurname, service, type, status, invoice, notes, courseservices.csv– Service list
Columns: service_id, serviceName, categoryId, categoryName, tax, defaultDuration, defaultNetPrice, defaultGrossPrice, allowOnlineBooking, active, archivedcourses.csv– Course definitions
Columns: course_id, name, serviceName, quantity, netPrice, salePrice, archived, active, tax, servicecustomercourses.csv– Courses bought by customers (quantity > 0)
Columns: customer, course, quantity, redeemed, isCompleted, expirationDate, voidedproducts.csv– Product catalogue
Columns: product_id, name, type, category, categoryName, brand, brandName, grossPrice, netPrice, tax, minStock, maxStock, stock, barcodes, isActive, archivedrooms.csv– Rooms (active only)
Columns: room_id, namestaffs.csv– Staff members
Columns: staff_id, firstName, middleName, surname, email, active, archivedforms.csv– Form and consent templates
Columns: form_id, name, type
Appointment times are exported exactly as stored in Collums (UTC).
Financial data
invoices.csv– Invoices
Columns: invoice_id, discount, paymentStatus, description, isDraft, origin, amount, customer, code, date, createdAt, closedBy, clinicinvoiceitems.csv– Invoice line items
Columns: invoiceitem_id, discount, refundedAmount, tax, referenceId, invoice, type, listPrice, quantity, name, netPrice, soldBy, createdAt, isRedemption, isTempDiscountApplied, customerName, customerSurname, customerIdinvoicepayments.csv– Payments
Columns: invoicepayment_id, invoice, takenBy, method, amount, createdAt, paid, customerName, customerSurname, customerIdgiftcards.csv– Gift cards / vouchers
Columns: giftcard_id, code, status, value, balance, expDate, universalUse, customerId, customerName, customerSurname, purchaserId, purchaserName, purchaserSurname, clinic, originalInvoice, createdAtgiftcardHistoriess.csv– Gift card balance history
Columns: giftcardhistory_id, giftcard_id, giftcardCode, prevBalance, balance, reason, invoice, customerId, customerName, customerSurname, practitionerId, practitionerName, createdAt
Files
Customer photos (JPEG, named
FirstName_Surname_<file>)
Index:customer/customerphotos.csv
Columns: photo_id, customer, name, imagePath, uploadedAt, treatment_note_idTreatment note drawings (canvas / face chart, PNG)
Index:treatmentnotes/treatmentnotesimages.csv
Columns: treatment_note_id, customer, type, service, imagePathUploaded customer documents
Index:customerdocuments/customerdocuments.csv
Columns: document_id, name, customer, type, documentPath, practitioner_id, created_at, treatment_note_idCompleted forms and consents (PDF, one folder per customer)
Index:customerforms/customerforms.csv
Columns: formId, customer, createdAt, name, pdfPath
Form PDFs cover every form type filled in by customers: consent, medical, general and aftercare forms. They are rendered to look the same as in Collums, including the customer's answers and signatures.
Folder structure
Paths in the index CSVs are relative to the folder that holds that CSV.
export/ ├── appointments.csv, customers.csv, notes.csv, ... (20 data CSVs) ├── customer/ │ ├── customerphotos.csv │ └── photos/<customerId>/<FirstName>_<Surname>_<file>.jpeg ├── treatmentnotes/ │ ├── treatmentnotesimages.csv │ └── images/<customerId>/<treatmentNoteId>.png ├── customerdocuments/ │ ├── customerdocuments.csv │ └── documents/<customerId>/<file> └── customerforms/ ├── customerforms.csv └── pdfs/<customerId>/<form>.pdf
Pricing
Your first data export is provided free of charge.
Any subsequent data exports will be charged at £350 + VAT per export.
As data exports need to be scheduled with our development team, we kindly ask that you give us as much notice as possible. This will allow us sufficient time to arrange and prepare your export.
If you would like to arrange a further data export, please get in touch with our team, who will be happy to help.
