WeWeb's workspace

WeWeb IncMay 11, 2026

Handling CSV imports without IDs 📂

Handling CSV imports without IDs 📂

WeWeb Inc

Learn how to update your workflow to handle CSV files without IDs by matching items based on their names. This tutorial demonstrates how to configure delimiters and use filters to update existing database entries efficiently.

Handling CSV imports without IDs 📂

WeWeb Inc

Learn how to update your workflow to handle CSV files without IDs by matching items based on their names. This tutorial demonstrates how to configure delimiters and use filters to update existing database entries efficiently.

Chapters

00:00

Introduction

Setting up and duplicating your existing workflow for safe experimentation.

00:23

CSV Parsing

01:31

Database Logic

02:42

Insert vs Update

03:33

Workflow Demo

05:42

Conclusion

Transcript

00:00

Hey, Vim.

00:01

so first thing, if you have a working workflow or workflow that works partially, I would invite you to duplicate it.

00:10

that way you don't, you know, whatever you experiment with, you're not breaking what's already working.

00:16

But so here basically I duplicated my, I think the workflow that I shared in a previous video.

00:23

And you'll see that as a parameter I have CSV.

00:26

then I have this function, the parsecsv to rows.

00:32

So I haven't made any changes to that.

00:34

yeah, no, I did add this delimiter, but let me show you why.

00:39

So let me just test this.

00:43

it's just my CSV is different from last time and you see here that it's returning rows, in a really weird way with the semicolon here.

00:54

So instead of having like for each row having then, the ID something, name, Apple description, blah, blah, it's, it's formatted weirdly here.

01:06

so I just want to make sure that I have the delimiter here.

01:11

And you can see the delimiter here is a semicolon.

01:14

So I added the delimiter here.

01:17

That's why you may not need to, but you may need to.

01:20

And it may be a comma, not a semicolon.

01:22

So you can see here and let me show you what it looks like.

01:25

Once I've added the delimiter, then the response, the result is much easier to read.

01:31

And you see here I don't have an ID for Apple.

01:34

so if I go to my database table, I do have an ID because I already created it.

01:43

but in my CSV I don't, And yeah, and so I tested you notice I tested it here.

01:56

That's because then in the loop I can see the results.

02:00

So all the results are here.

02:02

And then I'm going to check if it already exists in a table.

02:06

And here this is the difference between the, between this video and what I showed you in a previous video is instead of looping on an item id, I'm looping on an item name.

02:19

because like you said, you know, I might not have an ID in in my CSV.

02:24

So here I'm looping on the id, on the item name.

02:28

And so yeah, I'm saying, if it's empty, it, if it.

02:34

So, if it's empty it will go to the false, to the false, branch.

02:42

And then I'm just gonna do an insert row, add the Bind to the loop item, name and description.

02:54

And then if it's true, so it already exists in the table.

02:57

That's where it's different from the video I showed you.

02:59

Instead of doing by id, I'm gonna do by filter and I'm gonna say if the name is equal to the item name.

03:08

So to the loop item name I should say to the loop item name.

03:13

then I'm going to update, I'm not going to update the name, the name is going to stay the same, but I'm going to update the description, with.

03:24

So the loop item description that's in my.

03:27

So the description that's in my CSV and that's it.

03:33

So let me just demonstrate.

03:37

So here I have banana as a yellow and brown fruit.

03:41

I'm just gonna update With saying it's a yellow fruit.

03:52

So let me just go here and here in my test file, I'm going to select a test file that's here, ingredients.

04:04

I'm just going to test here for now just to show you.

04:11

So here you see, banana doesn't have an id.

04:14

Apple doesn't have an ID either.

04:16

And it says yellow fruit instead of yellow brown fruit.

04:18

So now let me test it, completely test the entire workflow.

04:26

And if I go back here, hopefully it will have worked.

04:30

Let's see.

04:33

Do I refresh?

04:37

No.

04:38

So why didn't it work?

04:39

Here, let Me check by name.

04:44

Yellow fruit.

04:50

Yellow fruit.

04:51

Banana.

04:52

it's.

04:53

Sorry.

04:54

So here my my CSV is not using semicolons, it's using, using commas as a separator, as a delimiter.

05:03

So here I need to update this.

05:05

Boom.

05:06

And if I update this now, it should work.

05:09

Boom.

05:15

error testing.

05:17

Let me just check.

05:20

Boom.

05:20

Test this first.

05:27

Okay, that's working fine.

05:28

Banana, yellow fruit.

05:30

Now let's test the entire thing.

05:35

There we go.

05:36

So now yellow fruit.

05:42

Hopefully that was helpful and a little bit clearer.

05:45

let me know if it helps.

05:48

And if it doesn't, it will really help me if you record a video of what you're doing and everything so I can better understand where you're stuck.

Handling CSV imports without IDs 📂