How to import CSV into Weweb tables

[SynopsisLabs (Steve)]

Hi,

Can CSV data be imported into the new Weweb tables? If so, where can I find it?

Thanks
Steve

[Joyce]

Hey @SynopsisLabs

We don’t have the feature yet. It’s planned but, in the meantime, you can go to Data & API > Backend Workflows > API Endpoints > Data and use the Import CSV to Table workflow:

I hope that helps!

[SynopsisLabs (Steve)]

Hi Joyce,

I did that and followed the wizard but it failed. I then realised that I have to add the file name and the table name in the workflow, but once I do that I don’t see how to run the workflow.

Thanks
Steve

[Joyce]

@SynopsisLabs

once I do that I don’t see how to run the workflow.

Hey Steve

You’ll need to choose how you call the workflow. You can create a button and trigger the workflow on click for example.

Here’s a short video explaining what I mean: https://www.tella.tv/video/triggering-backend-workflows-via-file-upload-3vtw

Does that help?

[SynopsisLabs (Steve)]

Sorry for the late response. Thanks

[SynopsisLabs (Steve)]

Hi Joyce,

I followed the video but am getting an Internal Server error so I went into the workflow and tried to test it there.

I tried putting the file name in the Parameters in the workflow -

but when I test the workflow I get a 400 Error as the file validation fails. If I disable the validation, I get an error in the Parse CSV block which complains of no csv file.

If it possible that you can do a video to show the full process I would be very grateful.

Thanks
Steve

[Joyce]

Hi Steve !

The internal server error may be coming from the file being too large. Can you look at the response message you get in the network tab of your browser inspector when you test the workflow?