# Host CSV Import Tool with Rails: Structured Data Imports

Deploy a CSV import tool built with Rails on Ample using the bulk import staging pattern. Compute runs the app in an isolated microVM behind a public HTTPS URL, a managed PostgreSQL 16 database is auto-provisioned and injected as DATABASE_URL, a private S3-compatible bucket holds objects with credentials delivered as encrypted environment variables. Verified on Rails: a CSV staged as an object, row-level validation with per-row errors recorded, and a restart-safe import keyed by import id (imported=2 rejected=1 restart=ok). Not separately tested: your import format, mapping and conflict rules; treat the CSV import tool-specific behavior as your application code.

## Summary
- **Family**: Workload recipe  
- **Framework**: Rails  
- **Release Status**: Published  
- **Support Status**: Verified  
- **Execution Status**: Ready

### Input Schema
```json
{
  "env": ["string"],
  "name": "string",
  "path": "string",
  "release_command": "string"
}
```

### Prerequisites
1. A Rails project that builds and starts with the documented commands.
2. A PostgreSQL driver reading DATABASE_URL at runtime.
3. A bucket from `ample bucket create` with its credentials passed as encrypted S3_* environment variables.
4. An Ample account token with `servers:write`, `databases:read`, `buckets:read`.

### Workflow Steps
1. **Build and start**: `bundle install` and start the server.
2. **Implement the pattern on PostgreSQL**: Create the bulk import staging module in your schema.
3. **Wire object storage**: Pass endpoint, region, bucket, and keys as environment values.
4. **Deploy**: Run the synchronous deploy.
5. **Verify**: Fetch the live URL and perform checks.

### Tested Configuration
- **Template**: ruby-3.4  
- **Runtime**: ruby  
- **Size**: s-1vcpu-1gb

### Examples
- **Rails pattern fixture**: Multi-pattern Rails app whose bulk import staging module was checked live.

### Limitations
- Verified on the ruby-3.4 template; other versions are not verified.
- The CSV import tool's behavior is application code and was not separately tested.

### Cost Estimate
- **Monthly Amount**: $10.00  
- Details: includes costs for app server and managed PostgreSQL database.

### Evidence Summary
- **Canary Run**: Rails pattern fixture deployed on Ample, checks passed for bulk-import-staging.

### Next Actions
- Browse the catalog index.
- Prepare a deployment plan.  
- Read the existing agent authentication setup.