marketplace pkg.go.dev MIT

CSV & Excel data import/export for togo — mapping, validation, resources.

Install

togo install togo-framework/import-export

Usage

Export

ie, _ := importexport.FromKernel(k)
rows := []map[string]any{{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}}
csvBytes, _ := ie.Export(ctx, rows, importexport.ExportOpts{Format: "csv", Columns: []string{"id", "name"}})
xlsxBytes, _ := ie.Export(ctx, rows, importexport.ExportOpts{Format: "xlsx", Sheet: "People"})

Import (mapping + validation)

data := []byte("Identifier,Full Name\n1,Alice\n,Missing\n")
rows, rowErrors, err := ie.Import(ctx, data, importexport.ImportOpts{
 Format: "csv",
 Mapping: map[string]string{"Identifier": "id", "Full Name": "name"},
 Validate: func(row map[string]any) error {
 if row["id"] == "" { return errors.New("id is required") }
 return nil
 },
})
// rows = valid rows (mapped to id/name); rowErrors = []RowError{ {Row:2, Message:"id is required"} }

Registered resources

importexport.Register(importexport.Resource{
 Name: "people",
 Columns: []string{"id", "name"},
 Fetch: func(ctx context.Context) ([]map[string]any, error) { return loadPeople(ctx) },
 Insert: func(ctx context.Context, row map[string]any) error { return savePerson(ctx, row) },
})
// then export/import by name via the Go API or REST.

REST API

Configuration

ID8 Media · One Studio

_{Support togo — become a sponsor.}