This guide covers prerequisites and initial setup for the Archive System.
Download from https://dotnet.microsoft.com/download.
Verify installation:
dotnet --version
# should output 10.x.xRequired if you are using AWS RDS for PostgreSQL or S3 for images.
- Install: https://aws.amazon.com/cli/
- Configure:
aws configure(enter your access key, secret, and region) - The system retrieves PostgreSQL credentials from AWS Secrets Manager at runtime — no passwords are stored in config files
If you are running PostgreSQL locally or on another provider, you can skip AWS CLI setup and configure the connection string directly in appsettings.json. See configuration-reference.md.
- Go to https://airtable.com/create/tokens
- Create a token with
data.records:readandschema.bases:readscopes - Grant access to your base
- Copy the token — you will add it to
appsettings.json
Each tool is a separate repository. Clone the ones you need:
git clone https://github.com/hoganlong/AirtableSchemaReader
git clone https://github.com/hoganlong/AirtableToPostgres
git clone https://github.com/hoganlong/AirtableImageDownloader # optional
git clone https://github.com/hoganlong/ArtWorkHTML # optionalEach project has an appsettings.template.json. Copy it and fill in your values:
cp appsettings.template.json appsettings.jsonAt minimum you will need:
AirtableApiKey— your Personal Access TokenAirtableBaseId— the ID of your Airtable base (starts withapp)- PostgreSQL connection details or AWS Secrets Manager ARN
See configuration-reference.md for every available field.
- Airtable to PostgreSQL only: airtable-to-postgres.md
- Full pipeline: full-system-guide.md
- Adapting for your own artist/base: adapting-for-new-artist.md