Skip to main content

Importing Camps

Theme camp information is often collected via Google Sheets, Air Table or another spreadsheet tool. If you can export to a CSV file then dust can import the camp information.

Importing CSV

You can import a CSV file of camps by:

  1. Click Camps
  2. Click (in the top right corner)
  3. Choose Import CSV and select your CSV file

Preview Before Import

After selecting your file, you'll see a categorized preview:

  • New Camps: Items that will be created
  • Updated Camps: Existing items with changed fields (shows exactly which fields changed)
  • Existing Camps: Items with no changes

Review the preview, then click Import to apply the changes.

Supported Fields

The CSV should contain the following fields in any order:

CSV ColumnDescription
nameCamp name (required)
descriptionCamp description
type / camp typeCamp type classification (eg "Sound Camp")
emailContact email address
image / logoOptional URL to camp image
# / idOptional External ID for matching

Smart Matching

The import system uses intelligent matching to identify existing records:

  1. External ID Match: If your CSV includes an ID column, items are matched by external ID first
  2. Name Match: Items are matched by name (case-insensitive)

This allows you to update existing records even if names have minor variations, as long as the external ID matches.

Change Detection

For updated items, the system compares these fields and shows which have changed:

  • name
  • description
  • camp_type
  • contact_email
  • imageUrl
  • externalId

Image Import

When your CSV includes image URLs, the system will download, convert to WebP format, resize, and upload to your burn's image storage.

Tips

  • Export your existing data first to see the expected column format
  • Use external IDs for reliable matching across imports
  • Review the preview carefully before importing
  • Large imports may take a few minutes to process