Skip to main content
Question

CSV Import - Check Records

  • May 14, 2025 10:41 PM UTC
  • 0 replies
  • 262 views

Forum|alt.badge.img+3

I am looking for help in importing a CSV file to a Company table that will check if the Company Name if it exists (text only as complete match) before importing.

This pipeline imports company data from a CSV file into a Quickbase table. It checks if a company already exists before creating a new record to prevent duplicates.

It fetches the CSV file (all+1300 rows) -  This is  test file and only has 3 rows

I receive the following error 

Validation error: Incorrect template "{{c.company}}". ValueError: invalid literal for int() with base 10: 'company'

Attched are the pipeline steps

Thank you, 

Eric

Mez
Forum|alt.badge.img+7
  • Qrew Colonel
  • May 15, 2025 4:51 PM UTC

Usually this is a type mismatch. Is the "company" field a string, and is the value in the file a string? Or, is the field a number and the value on the file is being treated as a string? Can you share some more screenshots of the field and the data on this test file just to confirm? 

If the value in the file should be converted to a number, you can do: {{ c.company | int }}


Mez
Forum|alt.badge.img+7
  • Qrew Colonel
  • May 18, 2025 2:17 PM UTC

Noticed a few things, in the iterate step you have your column headers as 'First,Last,Company,...' yet this screenshot of the company names looks like this is column D. 

Also, in your search step, C, do you have any filters applied in that step versus the next conditional?