Skip to main content

Collums Data Export – What's Included

What's included in your data export from Collums

Written by Emma Rochester

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. customerId in appointments.csv matches customer_id in customers.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, notificationTypes

  • notes.csv – Customer notes
    Columns: customer, firstname, surname, appointment, employee_id, employee, location, createdAt, status, note

  • treatment-notes.csv – Treatment notes
    Columns: treatment_note_id, appointment_ids, serviceId, customerId, firstName, middleName, surname, service, createdAt, practitionerId, practitionerFirstName, practitionerSurname, notes

  • treatment-fillers.csv – Filler treatment records
    Columns: treatment_note_id, appointment_ids, treatmentType, serviceId, service, expiry, lotNo, quantity, productId, productName, customer, createdAt, practitionerId, practitionerName, usedProducts

  • treatment-toxins.csv – Toxin treatment records
    Columns: treatment_note_id, appointment_ids, treatmentType, serviceId, service, expiry, lotNo, unit, dilution, productId, productName, customer, createdAt, practitionerId, practitionerName, usedProducts

  • prescriptions.csv – Prescriptions
    Columns: prescription_id, customerId, customerName, customerSurname, prescriberId, prescriberName, prescriberSurname, clinic, archived, sent, createdAt

  • prescriptionitems.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, course

  • services.csv – Service list
    Columns: service_id, serviceName, categoryId, categoryName, tax, defaultDuration, defaultNetPrice, defaultGrossPrice, allowOnlineBooking, active, archived

  • courses.csv – Course definitions
    Columns: course_id, name, serviceName, quantity, netPrice, salePrice, archived, active, tax, service

  • customercourses.csv – Courses bought by customers (quantity > 0)
    Columns: customer, course, quantity, redeemed, isCompleted, expirationDate, voided

  • products.csv – Product catalogue
    Columns: product_id, name, type, category, categoryName, brand, brandName, grossPrice, netPrice, tax, minStock, maxStock, stock, barcodes, isActive, archived

  • rooms.csv – Rooms (active only)
    Columns: room_id, name

  • staffs.csv – Staff members
    Columns: staff_id, firstName, middleName, surname, email, active, archived

  • forms.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, clinic

  • invoiceitems.csv – Invoice line items
    Columns: invoiceitem_id, discount, refundedAmount, tax, referenceId, invoice, type, listPrice, quantity, name, netPrice, soldBy, createdAt, isRedemption, isTempDiscountApplied, customerName, customerSurname, customerId

  • invoicepayments.csv – Payments
    Columns: invoicepayment_id, invoice, takenBy, method, amount, createdAt, paid, customerName, customerSurname, customerId

  • giftcards.csv – Gift cards / vouchers
    Columns: giftcard_id, code, status, value, balance, expDate, universalUse, customerId, customerName, customerSurname, purchaserId, purchaserName, purchaserSurname, clinic, originalInvoice, createdAt

  • giftcardHistoriess.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_id

  • Treatment note drawings (canvas / face chart, PNG)
    Index: treatmentnotes/treatmentnotesimages.csv
    Columns: treatment_note_id, customer, type, service, imagePath

  • Uploaded customer documents
    Index: customerdocuments/customerdocuments.csv
    Columns: document_id, name, customer, type, documentPath, practitioner_id, created_at, treatment_note_id

  • Completed 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.
​

Did this answer your question?