📦 AdventurePack Manual

What you will do

1. Download a .adventurepack file (or start from a blank template).
2. Open it on your computer — it is just a ZIP file.
3. Fill in trip data using Excel, Numbers, or an AI assistant.
4. Pack it back into a .adventurepack file.
5. Import it in the AdventureManager app.

Step 1 — Download the AdventurePack

1. Click the download link you received (email, chat, Google Drive, etc.).
2. Save the file in Downloads.
3. Check the filename ends with .adventurepack
   Example: trip_scotland_2026-06-01.adventurepack
4. Make a backup copy before editing.
   Example: trip_scotland_2026-06-01_backup.adventurepack

Step 2 — Open the AdventurePack on your computer

1. Double-click the .adventurepack file. On Mac, it unzips automatically into a folder.
2. Open the new folder. You will see files like:

Step 3 — Recommended: work with a linked Excel workbook

The easiest way to edit an AdventurePack on a computer is with a linked Excel workbook (.xlsx). This workbook has one sheet per CSV, and formula cells automatically copy data from reisplan to vervoer and uitgaven when you edit reisplan — the leading sheet.

How it works:

• reisplan is the master sheet: edit here first.
• vervoer and uitgaven have formula cells that pull matching data from reisplan via the RefID column. Fill in only the fields unique to vervoer (transport mode, flight number, departure/arrival details, etc.).
• contacten and reisinformatie are filled in manually — no join key.
• Dropdown validation on the Categorie and Vervoermiddel columns prevents typos.

To create this workbook from an .adventurepack, ask an AI assistant:

"Convert this .adventurepack to a linked Excel workbook with one sheet per CSV, XLOOKUP formulas from reisplan to vervoer and uitgaven, and dropdown validation for Categorie and Vervoermiddel."

After editing, export each sheet back to CSV (semicolon-separated, UTF-8) and repack as described in step 6.

Step 4 — Fill in manually (direct CSV editing)

1. Open a CSV in Excel or Numbers.
2. Keep row 1 (headers) exactly as it is.
3. Add new rows under the headers.
4. Save with the same filename, still as .csv.
5. Repeat for each CSV you want to update.

Use these safe formats

Valid categories for reisplan.csv

Valid transport modes for vervoer.csv

Step 5 — RefIDs: linking reisplan, vervoer, and uitgaven

RefIDs link rows across CSV files. A transport item in reisplan.csv and its matching row in vervoer.csv must have the same RefID. Without a matching RefID, the route line will not appear on the map.

You can use:

• Human-readable IDs — flight1, hotel_amsterdam, ferry_out
• UUIDs — 3C064C66-5330-4F43-A66D-16C87E963762
• Any unique string — day1_activity, KL935

Rules:

• Every row in reisplan.csv should have a RefID.
• The RefID in vervoer.csv must exactly match the reisplan.csv row it belongs to.
• uitgaven.csv uses ReisplanRef (same value) to link to reisplan.
• If you leave RefID empty, the app will generate one automatically — but cross-file links will not work.

Step 6 — Pack it back into .adventurepack

Mac (recommended — always works correctly)

1. Open Terminal.
2. Navigate into the unpacked folder:
   cd /path/to/trip_scotland_unpacked/
3. Pack from inside the folder:
   zip -r ../trip_scotland_2026-06-01.adventurepack .
4. The .adventurepack file appears one level up.

Windows / manual

1. Open the unpacked folder.
2. Select all files inside it (including the photos folder, even if empty).
3. Right-click → Compress / Send to ZIP.
4. Rename the .zip to .adventurepack.

Step 7 — Upload in the AdventureManager app

1. Put the .adventurepack file in Files / iCloud Drive.
2. Open AdventureManager.
3. Tap Import (or + then import).
4. Pick your .adventurepack.
5. Wait for the import to finish.
6. Open the trip and quickly check: itinerary, transport, contacts, and group members.

Step 8 — Use an AI assistant (Claude, ChatGPT, etc.)

If you already have your trip planned in a document, spreadsheet, email thread, or booking confirmations, you can ask an AI assistant to convert it into the correct CSV format for you.

Copy the prompt below, fill in your trip details where indicated, and send it to Claude, ChatGPT, Gemini, or any other AI assistant.

You are helping me create an AdventurePack for the AdventureManager travel app.
An AdventurePack is a ZIP file renamed to .adventurepack, containing CSV files
separated by semicolons (;), encoded in UTF-8 without BOM.

Please generate the following CSV files based on my trip data below.

FILE 1: reis.csv
Headers: Naam;Bestemming;Startdatum;Einddatum
- One row only. Startdatum/Einddatum: YYYY-MM-DD.

FILE 2: groepsleden.csv
Headers: Naam;Rol;Kleur
- Rol: "planner" (organizer, full access) or "reiziger" (traveler, read-only).
- Kleur: hex color like #FF6B6B. Assign a different color per person.
- Always include at least one planner.

FILE 3: reisplan.csv
Headers: RefID;Datum;Locatie;Titel;Omschrijving;Categorie;Verborgen;Starttijd;Eindtijd;
Straat;Postcode;Stad;Provincie;Land;Lokaal adres;Telefoon;E-mail;Website;Kosten (EUR);
Kosten notitie;Betaald door;Breedtegraad;Lengtegraad
- RefID: use a short human-readable ID per row (e.g. flight1, hotel_amsterdam, ferry_out).
  Must be unique. Must match the RefID in vervoer.csv for transport items.
- Datum: YYYY-MM-DD.
- Categorie: hotel / transport / activity  (these are the ONLY valid values)
  Use "transport" for flights, trains, ferries, car journeys, buses.
  Use "hotel" for overnight stays.
  Use "activity" for excursions, tours, dinners, walks, experiences.
- Verborgen: false (use true only to hide a surprise from travelers).
- Starttijd/Eindtijd: HH:MM (24h) or leave empty.
- Kosten (EUR): number only (e.g. 85.00) or leave empty.
- Breedtegraad/Lengtegraad: decimal GPS coordinates (e.g. 52.3731 / 4.8922) or leave empty.

FILE 4: vervoer.csv (one row per transport item — RefID must match reisplan.csv)
Headers: RefID;Datum;Titel;Omschrijving;Locatie;Vervoermiddel;Luchtvaartmaatschappij;
Vluchtnummer;Boekingsnummer;Online inchecknummer;Vertrekstation;Vertrekterminal;Incheckdatum;
Vertrekdatum;Aankomststation;Aankomstterminal;Aankomstdatum;Ticketnummer;E-ticketnummer;
Ruimbagage;Handbagage;Telefoon;E-mail;Website;Adres;Kosten (EUR);Kosten notitie;Betaald door;
Vertrek breedtegraad;Vertrek lengtegraad;Aankomst breedtegraad;Aankomst lengtegraad;
Breedtegraad;Lengtegraad
- RefID: MUST be the same value as the matching row in reisplan.csv.
- Vervoermiddel: airplane / car / train / boat / bus / bike / moped  (only these values)
  Use "boat" for ferries. Use "car" for car rental.
- Vertrekdatum/Aankomstdatum: YYYY-MM-DD HH:MM.
- Leave unknown fields empty.

FILE 5: contacten.csv
Headers: Naam;Locatie;Type;Platform;Website;E-mail;Telefoon;Adres;Lokaal adres;Data;Volgorde
- One row per hotel, restaurant, or venue.
- Leave unknown fields empty.

FILE 6: uitgaven.csv
Headers: RefID;ReisplanRef;Bedrag;Valuta;Bedrag EUR;Categorie;Datum;Betaald door;Notitie
- RefID: unique ID per row (e.g. exp1, exp2).
- ReisplanRef: RefID of the related reisplan.csv row (or leave empty).
- Bedrag EUR: cost in euros as a number.
- Datum: YYYY-MM-DD.

Rules:
- Semicolons as column separator, UTF-8, no BOM.
- reisplan.csv and vervoer.csv RefIDs must match for the same transport item.
- Leave optional fields empty rather than guessing.
- Only include rows where you have actual data.
- Output each file with its filename as a header, like: === reisplan.csv ===

My trip details:
[PASTE YOUR TRIP INFORMATION HERE — destinations, dates, activities, transport
bookings, hotel names, group members, costs, etc.]

If something goes wrong