How to Read CSV File Using Root Script in Magento 2
Complete tutotial on using root script in Magento 2 to read data from CSV file.
If you are a Magento 2 developer, sometimes you may require to process records from a CSV file and add it to the Magento 2 database. In such case, you can use the Magento 2 root script to read data from the CSV file.
For an example, consider you have thousands of rows of data that you want to import into Magento 2. In such scenario, adding the data manually can be tedious and therefore you may require to use the Magento 2 root script to read the data from the CSV file.
Let’s go with the root script to read CSV file data in Magento 2!
How to Read CSV Data in Magento 2 Using Root Script?
In order to read the data from a CSV file in Magento 2, we’ll be using the fopen & fgetcsv functions in the root script. After opening the file, we’ll read each element of the file using the ‘for loop’ and close the file using the fclose, once the data reading is completed.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
<?php use Magento\Framework\App\Bootstrap; require 'app/bootstrap.php'; $bootstrap = Bootstrap::create(BP, $_SERVER); $objectManager = $bootstrap->getObjectManager(); $state = $objectManager->get('\Magento\Framework\App\State'); $state->setAreaCode('frontend'); $open = fopen("my_csv.csv", "r"); // name of csv file $data = fgetcsv($open, 1000, ","); try{ $handle = fopen("my_csv.csv", "r"); // name of csv file for ($i = 0; $data = fgetcsv($handle); ++$i) { if ($i == 0) { continue; } echo $data[$i]; } fclose($handle); }catch (\Exception $e) { print($e->getMessage()); } |
That’s it!
This is how we can use the Magento 2 root script to read CSV file data. I hope this blog post will help through the same. In case you still have any queries or doubts, feel free to comment. I will be happy to help you.
Also, do not forget to share this Magento 2 tutorial with your Magento friends via social media.
Thanks for reading!
Also Read:
- How to Get Data From Custom Database Table in Magento 2
- How To Run Direct SQL Query In Magento 2
- How to Download All Product Data in CSV Using Root Script in Magento 2
Prev
How to Reload Current Page Without Losing Any Form Data in JavaScript?
New Magento 2 Extensions & Updates [June 2022]
Next