DatumForms.
Join the panel Sign in Create a survey

DATUMFORMS DOCUMENTATION

Map CSV fields and update existing records

Match incoming columns to stable survey questions and update the intended list records.

For researchers and administrators

Updated 15 November 2026

On this page

Before you start

Use a published ordinary survey and a stable identity field. Review the complete file before applying changes.

Open: API integration → /api/csv-import.

Steps

  1. Read the published survey definition and record the question IDs for each incoming column. Keep an identity question, such as item code, in the mapping.
  2. Prepare the uploader request with upsert mode, the imported question IDs, identity question and complete expected row count.
  3. Upload the unchanged CSV, complete the upload and poll for the review summary.
  4. Inspect proposed inserts and updates. Decide whether blank incoming cells should clear existing values using clear_blanks.
  5. Apply the exact review token and verify the completed row count and a sample of changed records.

Check the result

Matching identities update the intended ordinary records and new identities create the appropriate rows.

Troubleshooting

If the review is stale, prepare a fresh preview against the changed list. Duplicate or missing identities should be corrected in the source file before applying. Keep response IDs and prior extracts for reconciliation without rewriting survey history.

Next steps

Replace a complete list and uploader API reference.

Need help with this task? Contact DatumForms. Include the article URL and the step you reached.

Tracking preferences

Essential functions stay on. Choose whether to allow optional tracking on this website. You can change your choices in the footer at any time.

Read our privacy policy