AssetCompose
CSV / Spreadsheet
P&ID Drawing
The system will auto-match shared columns and only surface exceptions or missing key choices.
Select one or more categories, or leave empty for "Uncategorized".
| # | System Column Name | File Column Name | Sample Values |
|---|
System table columns are listed first. Exact name matches are auto-selected, and you can choose a file column for any unmatched system column.
| # | File Column Name | Table Column Name | Sample Values | Inferred Type | Assigned Type |
|---|
| Row | Column # | PG Column | Value | Expected Type | Error | Row Value |
|---|
No import log data found.
| ID | Filename | Table | Cols | Rows | Status | Validation | Validated At | SQL Error | Imported At | Size | Schema |
|---|
No Data Exists. Please Import Data.
Preview only. No database changes.
Scenarios
| Time | Event | User | Performed by | IP Address |
|---|
Select a project to view checks.
Use the left-hand menu to navigate the app. This page summarizes what each menu area is for.
| Menu Item | What It Does |
|---|---|
| Dashboard | Your starting point — provides an at-a-glance overview of the active project, including recent activity, key metrics, and quick links to common tasks. |
| Data Viewer | Browse, filter, sort, and search rows across any project table. Edit individual cells, manage row-level progress and status, view timeline history, and apply quality-check filters to isolate failing records. Available tables and actions are controlled by your role permissions. |
| Project Management | Monitor delivery health across the project. The Progress view tracks completion by status; Velocity shows throughput over time; Bottlenecks highlights where work is stalling. Use Progress Statuses to define and reorder the workflow stages used across project rows, and Sprints to configure time-boxed delivery cycles. |
| Analytics | Build and view custom dashboard widgets to surface key metrics and trends from your project data. Widgets are configurable and can be arranged into a personalised monitoring view for your team. |
| Build | Maintain the engineering master data that underpins your project. Manage Crafts, Maintenance Strategies, Equipment Types, Locations, Assets, Frequency Units, and Maintenance Jobs. Use Generate Maintenance to produce planned maintenance schedules from the configured master data. |
| Import/Export | Import CSV files into system tables (such as Assets or Locations) or into your own custom tables, with automatic column mapping and pre-import validation. Review all past import activity, including outcomes and error details, in the Import Log. Export any system or custom table as a CSV download. |
| Data Quality | Define automated quality checks that run against columns in your project tables. Each check specifies a column, a rule type (such as Not empty, Equals, or Max length), and an optional criteria value. Checks can be grouped by table name or table category, and results show pass/fail counts with a progress bar. Drill into any failing check to preview the specific rows that are violating the rule. |
| Workspace | Manage the organizations (clients) and projects that structure your data. Create and configure projects, assign tables, and control which tables are active for a given project. Changes here affect what appears in the project switcher across the app. |
| Settings | Configure application-wide metadata. Manage Tables to control logical names and row-value columns; use Table Categories to group tables with custom labels and colours that appear throughout the app; maintain Progress Status labels and ordering used in project workflows. |
| Security | Manage who has access and what they can do. Add and manage user accounts, send email invitations to new users, and define Roles that bundle granular permissions together. Assign roles to users to control access to specific views, actions, and data across the entire application. |
| Time | Status | Endpoint | Error | User |
|---|