Skip to main content
Question

Pipelines CSV Handler

  • July 28, 2022
  • 0 replies
  • 148 views

SSNJeffP
Forum|alt.badge.img+11

I'm receiving a .CSV file via the Pipelines 'CSV Handler'.    In the second step I'm using 'Iterate over CSV Records'.  

What I am trying to do is use the csv which looks like this:


I want to create a single record in a table called 'Orders' for each order, and then child records in a table called 'Warehouse Requests' for each SKU under an 'Order', which will be used to generate a warehouse pick-list.

I'm getting stumped by the first part of this.   The pipeline runs and seems to loop over the records but only creates blank records for each row.    

I haven't even started on the next part which is to generate all of the child records for each SKU.

Anyone have any ideas on what I might be doing wrong or if there's a different approach I should consider?



------------------------------
Jeff Peterson
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • July 28, 2022
Is the file format regular CSV?  I had a problem where I inadvertently was testing with a CSV UTF -8 file.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------