How can i upload csv Database

[Harold_Royce_Anonuev]

How can i upload my csv file into the database

also i have an issue on routes when my admin pages reloads it show the index header not my admin component page

[Teodor]

Please post different issues in different topics.
You can bulk insert CSV data into your database as explained in the docs:

Bulk Insert Data in a Database

Intro Bulk insert actions involve inserting a large amount of data into a database table in a single operation, which is more efficient than individual row inserts. This method improves performance by reducing overhead, minimizing network traffic, and optimizing logging and indexing. Bulk insert actions are particularly useful for CSV imports. In this tutorial we will show you how to bulk insert data from a CSV file. Bulk Insert CSV data We start by creating a server action in the Server Con…

[sitestreet]

Hi @Harold_Royce_Anonuev. Welcome to the community

Or you can use your normal data management software like phpMyAdmin, Navicat, etc. It will also depend on your database type.

[almatry]

@Teodor

I have a parent id (i.e. or a variable) in a separate table that should be assigned with the imported CSV data, however I can't select it from the options list . It only let me select from the CSV headers. is there a workaround this? i'm using a repeat insert which is slow.

[Teodor]

Can you provide some more details about your workflow?

[almatry]

I want to bulk insert into a database from a CSV file. My table has three columns (parent_id,number,amount) while my CSV has only (number, amount). this parent_id comes from a variable. I can't select that variable in the Bulk insert step. I can't select a value in the database updater.

[Teodor]

I am afraid this is not directly possible. Maybe check the workaround suggested in the following topic: Bulk-insert: options to define dynamic values - same as regular database insert