askrobots / dbbasic-object-server
Public
Runs live, versioned Python application objects on one VM, with a suite of apps: projects, notes, tasks, files and more.
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 | } |