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

[TMR]

Personally, for this type of task I'd use something like HeidiSQL, its very easy to import from CSV, literally one click:

[Teodor]

I believe @almatry asks about allowing his clients/users to do this through a web site/app he built.

[almatry]

Why not just allow this option and then we benefit from the performance it offers as per this post

thank you in advance.

[Teodor]

We will see what can be done about this for the next updates.

[patrick]

Use the Add Columns action under Data Transformations to add the parent_id to the collection. For the bulk insert you then use the output from that action.