Stuck trying to access the CSV to create a record in Knack

[Tim_Lohnes]

Hi,

I have seen the 1 other post in here talking about it, but it is still not clicking to me.
I’m trying to take a submitted file when a new record (including the file) are created in Knack, parse the CSV, make records in a different knack table (same app) for all the rows in CSV.

I have a scenario with

• Knack New Event trigger (when new record with csv attachment is created)
• Get a record
• Parse CSV
• Create a record in Knack.

I don’t know how to get the csv from the record. There is an overall record and then lots of subfields in the csv. When I parse CSV the input is an empty csv so obviously I’m not getting it from the record. Several attachments to hope update the context. What do I need to change in get record? CSV?

Thanks,
Tim

[samliew]

Welcome to the Make community!

I don’t see any CSVs in your screenshots.

Make sure you are actually parsing CSV data in your Parse CSV module.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Tim_Lohnes]

test unit uploads.csv (551 Bytes)
Here is the test csv I was using.

[samliew]

I was able to parse your CSV.

Here, try it out yourself:

Module Export - quick import into your scenario

You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.

1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:
   

2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.

3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.

JSON module export — paste this directly in your scenario

{"subflows":[{"flow":[{"id":290,"module":"csv:ParseCSV","version":1,"parameters":{"colCount":null,"csvContainsHeaders":true,"delimiterType":"other","relax":false,"delimiter":","},"mapper":{"csv":"Address Text,APN,FullAddress : Street 1,FullAddress : City,FullAddress : State,FullAddress : Zip,Year Built,Property Type,Owner (role)\n29013 Dixon St # 4,078C-0432-002-07,29013 Dixon St # 4,Hayward,CA,94544,1/1/1957,Fourplex,James Davis\n29013 Dixon St # 3,078C-0432-002-07,29013 Dixon St # 3,Hayward,CA,94544,1/1/1957,Fourplex,James Davis\n29013 Dixon St # 2,078C-0432-002-07,29013 Dixon St # 2,Hayward,CA,94544,1/1/1957,Fourplex,James Davis\n29013 Dixon St # 1,078C-0432-002-07,29013 Dixon St # 1,Hayward,CA,94544,1/1/1957,Fourplex,James Davis"},"metadata":{"designer":{"x":1076,"y":-1024}}}]}],"metadata":{"version":1}}

Note: Did you know you can reduce the size of blueprints and module export code like the above, using the Make Blueprint Scrubber?

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.