Software Handbook: Appointment Planning, CSV Mailer, Customer Forms & Meeting Polls
Welcome to the complete technical and operational handbook for the Appointment Planning Bundle (Central Calendar + Documents & CSV Mailer + Appointment Planning) of the Siedelmann Business Suite.
Practical note for mixed contact lists (missing email addresses): In many established customer databases, not every recipient has an email address on file. You do not need to pre-filter your CSV export before uploading: contacts with a valid email receive their personalized invitation automatically, while contacts without (or with an invalid) email address are automatically placed in Missing-Email Follow-Up for phone booking, email entry, or postal letters. → Details in Section 4
1. Overview: The Coupled 3-in-1 Bundle
Scheduling, customer outreach, and calendar synchronization belong together. The module is therefore always delivered as a coupled 3-in-1 bundle at one transparent all-inclusive price per company workspace (€69 net / month or €690 net / year, no per-user fees):
| Component | Key Capabilities |
|---|---|
| 1. Central Calendar | Month, Agenda & Day views, sub-calendars (staff, districts, vehicles), capacity placeholders, 2-way sync with Google Calendar, Microsoft 365 (Outlook), Mailcow (SOGo), CalDAV & iCal/ICS |
| 2. Appointment Planning & Polls | Online booking pages per service, working windows & capacities, self-service rescheduling, Open Customer List & Callback Cards, outage handling, day print sheets & 2-mode Meeting Polls |
| 3. Documents, CSV Mailer & Forms | 4-step throttled CSV Mailer, email & letter templates, Missing-Email Follow-Up, Booking Statistics & Retargeting, Digital Customer Forms (/kundenformular), postal letters & PDF tools |
2. Central Calendar & 2-Way External Sync
- Views & Sub-Calendars (
/app/kalender): Month, Agenda, and Day views with persistent per-user sub-calendar filters. Open capacities appear visually separated from booked appointments (e.g.07:00–11:00 · 7×), and fully booked windows hide automatically. - Google Calendar (OAuth 2.0): Per-tenant encrypted OAuth credentials (
https://siedelmann.com/app/kalender/google/callback), 1- or 2-way sync plus 15-minute background refresh. - Microsoft 365 / Office 365 (Microsoft Graph OAuth 2.0): Per-tenant Entra ID Tenant ID (
commonor GUID), Application ID & Client Secret (https://siedelmann.com/app/kalender/microsoft/callback, scopesopenid, email, offline_access, User.Read, Calendars.ReadWrite), 1- or 2-way sync plus 15-minute background refresh. - Mailcow (SOGo), CalDAV & iCal/ICS: Full 2-way CalDAV sync for Mailcow, Nextcloud, OwnCloud, Apple iCloud, Synology, Baikal, and Thunderbird, plus ICS import and protected per-calendar export feeds.
3. Services, Capacities, Custom Fields & Outage Handling
- Appointment Types (
/app/tools/terminplanung): Configure weekdays, working windows, validity dates (valid_from..valid_until), single or multi-slot capacities, buffer times,show_slot_end_time, date exceptions, and target sub-calendars. - Custom Intake Fields: Collect access notes, key locations, meter numbers, or equipment types. Enable
highlight_in_printto highlight critical notes on daily route printouts. - Self-Service Rescheduling & Outage Assistant: Customers reschedule via their personal link against server-validated real-time capacity. If a technician or day drops out, the outage assistant lets you notify affected customers and launch a re-invitation campaign in one click.
4. The 4-Step CSV Mailer, Missing Emails & Open Customer List
Controlled 4-Step CSV Mailer (/app/tools/csv-mailer)
- Upload CSV from any ERP or spreadsheet (UTF-8 / Windows-1252,
;or,auto-detected). - Compose & Personalize using reusable email/letter templates, placeholders, and an explicit personal booking link (
followup_contact_id) that pre-fills customer details. - Live Preview every rendered message with real customer data before sending.
- Throttled Delivery via your tenant's own mailer (SMTP, Mailjet, Mailchimp Transactional – custom SMTP gateways integrated free of charge), including one-click unsubscribe suppression.
Handling Missing Email Addresses (/app/tools/csv-mailer/nachbearbeitung)
In real-world customer databases (trades, property managers, service businesses), email coverage is rarely 100%. Example: you import 250 customers from your ERP — 195 have a valid email address and receive personalized invitations automatically, while 55 have an empty or invalid email field.
- Zero silent drops, zero import errors: Those 55 contacts are automatically routed into Missing-Email Follow-Up with their complete name, street, ZIP/city, phone number, customer ID, and campaign link intact.
- 4 direct resolution paths:
- Call & 1-Click Book: Call using the displayed phone number and click Book Appointment directly in the row (pre-filled; syncs straight to your calendar and marks the follow-up done).
- Add Email & Send Single Invitation: Capture a new email on the phone, save it, and send that customer's personalized booking invitation in one click.
- Postal Letters / Mail-Merge Export: Export all remaining non-email contacts as a mail-merge CSV or dispatch physical letters via
/app/dokumente/postversand. - Team Status Tracking: Mark each contact (Open, Unreachable, Letter Sent, Done) so office staff never call the same customer twice.
Open Customer List, Callbacks & Retargeting (/app/tools/terminplanung/offene-kundenliste)
- Every invited customer who has not yet booked remains visible in the Open Customer List, linked explicitly by
followup_contact_id(no error-prone guessing by name or address). - Callback requests appear at the top as clear action cards on both desktop and mobile.
- Auto-reopen on cancellation: If a customer cancels a booking, their record immediately returns to the Open Customer List so no customer is ever lost.
- One-Click Retargeting (
/app/tools/csv-mailer/statistik): Track live booking quotes per campaign and launch a follow-up mailing targeting only contacts who have not booked yet.
5. Meeting Polls (2 Modes), Customer Forms & Day Print Sheets
- Meeting Polls – Mode 1 (Group Voting,
/app/tools/terminfindung): GDPR-compliant Doodle alternative with Yes/Maybe/No voting without login, optional deadline, and one-click finalization. - Meeting Polls – Mode 2 (Direct 1-on-1 Customer Booking): Send tailored date proposals to an individual customer; the first selected slot books automatically into your target calendar (with Google/M365/Mailcow sync) and sends instant confirmation emails.
- Digital Customer Forms (
/app/formulare→/kundenformular): Collect meter readings, access notes, or consents from CSV lists via personal links (no login), styled with reusable CSS design presets, optional automated reminders for non-responders, and CSV response export. - Print-Ready Day Sheets & Route Map: Print daily schedules filtered by campaign or sub-calendar, sorted within time windows, with highlighted custom fields and an interactive route map (
/app/kalender/tagesroute/ansicht). - 14-Day Free Trial: Try the entire 3-in-1 bundle free for 14 days with no automatic renewal (
/register). Paying via PayPal automatically promotes your trial workspace into a full tenant account with all data preserved.
