Skip to content
Pachurros Help

Database — Overview

The database is the structured core of Pachurros. It works for anything you can think of in rows and columns — shot lists, equipment lists, contacts, tasks, budget overviews, image sequences, and more.

What makes up a database

Section titled “What makes up a database”
Rows
Entries

Each row is a record — a subject, a task, an appointment, or a contact.

Columns
Properties

Status, date, assignee, file — 30 column types for every use case.

Views
Presentations

Same data shown as a Table, Kanban, Gallery, Calendar, Timeline, Storyboard, Map, Chart, or Form.

You can create as many views of the same database as you like and switch between them freely. The data is always the same — only the presentation changes.

Views at a glance

Section titled “Views at a glance”
Table List Kanban Gallery Calendar Timeline Storyboard Map Chart Form
ViewBest used for
TableFull overview, many columns visible at once
ListCompact single-line overview with inline fields
KanbanWorkflow status, task management
GalleryImage-based content, visual overview
CalendarScheduling, shooting days
TimelineProject duration, phases and milestones
StoryboardImage sequences in order
MapLocation-based data, shooting locations
ChartAnalytics, status overviews, time series
FormStructured data entry, submissions

Creating a new database

Section titled “Creating a new database”
  1. Click + New Database in the sidebar
  2. Give it a name
  3. Optionally select a starter template

Adding an entry

Section titled “Adding an entry”
  • In Table view: Click + New Row at the bottom
  • In Kanban view: Click + below a column
  • In Gallery: Click + New Entry

Opening a row

Section titled “Opening a row”

Click on a row (or the open icon) to see the detail view — all fields, comments, and attached media.

Exporting

Section titled “Exporting”

Under ⋯ → Export there are three ways:

WayResult
As Excel.xlsx — plain number columns stay numbers Excel can compute with
As CSV.csv with BOM so Excel reads umlauts correctly
With attachments (ZIP)bundle of Excel and CSV plus every file

What gets exported is what the active view shows: its filters, its sorting, its visible columns. References resolve to plain names — a relation becomes the linked row’s title, a person their name, a select its label.

With attachments

Section titled “With attachments”

Files and images attached to rows travel along as real files:

Invoices.zip
├── Invoices.xlsx
├── Invoices.csv
└── Anhänge/
    ├── 001 Invoice Meier/invoice.pdf
    ├── 001 Invoice Meier/receipt.jpg
    └── 002 Invoice Huber/contract.pdf

One folder per row, named after its title with a running number — that number is also the row number in the sheet, so you can get from row to file. If two attachments of the same row share a name, the column is added.

While bundling, the menu shows progress (“3/12”). If a file is missing the export still completes and adds a FEHLENDE-DATEIEN.txt list — an export that fails over one deleted file would be worse than one that brings 99 of 100.

Further topics

Section titled “Further topics”