Data import by users

Knack 101 Use Case Discussion
1

Is there a way to import records by users through live app?

1 Like
2

Hi @Monika,

This is currently not possible, however, implementing this feature is on our product roadmap: Live App Record Import | FEATURE | Knack :raised_hands:

3

Hi @Monika,

That’s exactly what I’ve done for my client Morbern.

Every week, they import their backlog into the system from an Excel file, in the front end. I’m talking about the XLSX format - not CSV.

I’ve done some custom code that does it nicely.

Here’s what it can do:

  1. does a dry-run to test if all is ok
  2. validates the proper file format, including all fields format and logical dates (ex: shipping in the past = error)
  3. prevents importing if pre-validation fails
  4. supports interruption upon error detection once started
  5. generates a comprehensive report of success, warnings and errors
  6. resumes where it stopped if an error occurred

It can do both inserts and updates of existing records.

Normand D.
Cortex R&D Inc.