Runs live, versioned Python application objects on one VM, with a suite of apps: projects, notes, tasks, files and more.

0 downloads

Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-object-server.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-object-server.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-object-server.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 signup: the person chooses the password and name on the confirm page 83c7aa6 2 weeks, 5 days ago History
bank_import_profiles.json · 2.7 KB · 31 lines
1{
2 "name": "bank_import_profiles",
3 "title": "Import Profiles",
4 "version": 1,
5 "description": "How to read one bank's export: column_map as DATA, not code. Every bank's CSV is different, so the FIRST import from a new bank is a configuration job -- paste a sample, let AI propose the mapping, confirm it, save it here. Every import after that runs the saved profile deterministically. The anti-pattern this exists to refuse: AI re-reading statements every month, which is nondeterministic and unauditable -- exactly what a fraud control must never be. AI configures; code executes.",
6 "fields": [
7 {"name": "id"},
8 {"name": "name", "type": "text", "required": true, "label": "Name"},
9 {"name": "bank_account_id", "required": true, "label": "Bank Account",
10 "relation": {"collection": "value_accounts", "display_field": "name"}},
11 {"name": "source_format", "type": "enum", "default": "csv", "label": "Format",
12 "enum": ["csv", "ofx", "camt053", "mt940"],
13 "help": "v1 ships csv; ofx (FITID + balances) is the next importer. The canonical landing shape (bank_lines) is the same for all of them."},
14 {"name": "column_map", "type": "textarea", "label": "Column Map (JSON)",
15 "help": "{\"date\": \"Posted Date\", \"amount\": \"Amount\", \"description\": \"Description\", \"external_id\": \"Transaction ID\", \"date_format\": \"%m/%d/%Y\", \"decimal_sep\": \".\", \"sign\": \"normal\"}. Use debit/credit instead of amount for two-column exports; sign=flip for banks that export withdrawals as positive."},
16 {"name": "has_balances", "type": "boolean", "default": "false", "label": "Carries Balances",
17 "help": "Whether this export states opening/closing balances. Without them the tie-out check cannot run and imports are honestly marked lower-assurance."},
18 {"name": "has_external_ids", "type": "boolean", "default": "false", "label": "Carries Transaction IDs",
19 "help": "Whether the bank gives each line a stable id (OFX FITID). Without one, dedup falls back to a content hash."},
20 {"name": "sample", "type": "textarea", "label": "Sample Rows",
21 "help": "A few real lines from this bank, kept so the mapping can be re-derived or reviewed later."},
22 {"name": "notes", "type": "textarea", "label": "Notes"},
23 {"name": "owner_id", "type": "text", "label": "Owner"},
24 {"name": "created_at", "type": "datetime", "read_only": true, "label": "Created"}
25 ],
26 "search": {"fields": ["name"]},
27 "forms": {"default": {"fields": ["name", "bank_account_id", "source_format", "column_map",
28 "has_balances", "has_external_ids", "sample", "notes"]}},
29 "views": {"list_mode": "table",
30 "list_fields": ["name", "bank_account_id", "source_format", "has_balances"]}
31}