{"id":339,"date":"2022-09-24T16:03:11","date_gmt":"2022-09-24T16:03:11","guid":{"rendered":"https:\/\/247blogs.com\/wp\/2022\/09\/24\/laravel-9-tutorial-laravel-9-import-records-in-sql-with-csv-and-seeder\/"},"modified":"2022-09-24T17:41:04","modified_gmt":"2022-09-24T17:41:04","slug":"laravel-9-tutorial-laravel-9-import-records-in-sql-with-csv-and-seeder","status":"publish","type":"post","link":"https:\/\/247blogs.com\/wp\/laravel-9-tutorial-laravel-9-import-records-in-sql-with-csv-and-seeder\/","title":{"rendered":"Laravel-9 Tutorial &#8211; Laravel 9 Import Records in SQL with CSV and Seeder"},"content":{"rendered":"<div id=\"\">\n<p>The database has the integrity to hold the records, be it a few or many more. If you are a Laravel developer and looking to import extensive data records through CSV. Then, this tutorial is going to be a goldmine of knowledge.<\/p>\n<p>This comprehensive tutorial will help you discover how to import large data records in SQL using the CSV and Laravel seeder.<\/p>\n<p>CSV stands for comma-separated values; generally, it is a delimited text file. This file holds a large amount of data; typically, information is laid in rows form. A single row may contain few or more than few values. Every value is separated by commas.<\/p>\n<p>We will use the laravel seeder to grab the data from the CSV; laravel proposes a tool to add dummy data to the database without putting extra effort. You can use it to insert the testing data into the database table using the database seeder.<\/p>\n<h2>How to Import Large SQL Records in Laravel using CSV and Database Seeder<\/h2>\n<ul>\n<li><strong>Step 1:<\/strong> Download New Laravel Project<\/li>\n<li><strong>Step 2:<\/strong> Make Database Ready<\/li>\n<li><strong>Step 3:<\/strong> Set Up CSV<\/li>\n<li><strong>Step 4:<\/strong> Incorporate Model and Migrations<\/li>\n<li><strong>Step 5:<\/strong> Add Large Records using CSV<\/li>\n<li><strong>Step 6:<\/strong> Start Laravel App<\/li>\n<\/ul>\n<h2>Download New Laravel Project<\/h2>\n<p>You must have created the laravel app; however, if not, get to the command-line tool.<\/p>\n<p>Type the command and initiate the app installation process.<\/p>\n<pre class=\" language-markup\" tabindex=\"0\"><code class=\" language-bash\"><span class=\"token function\">composer<\/span> create-project --prefer-dist laravel\/laravel LaravelTest<\/code><\/pre>\n<h2>Make Database Ready<\/h2>\n<p>Next, you will have to make your database ready to create the consensus between your laravel app and database.<\/p>\n<p>Open <strong>.env<\/strong> and define the database name, username and password respectively.<\/p>\n<pre class=\"  language-bash\" tabindex=\"0\"><code class=\"  language-bash\"><span class=\"token assign-left variable\">DB_CONNECTION<\/span><span class=\"token operator\">=<\/span>mysql\n<span class=\"token assign-left variable\">DB_HOST<\/span><span class=\"token operator\">=<\/span><span class=\"token number\">127.0<\/span>.0.1\n<span class=\"token assign-left variable\">DB_PORT<\/span><span class=\"token operator\">=<\/span><span class=\"token number\">3306<\/span>\n<span class=\"token assign-left variable\">DB_DATABASE<\/span><span class=\"token operator\">=<\/span>database_name\n<span class=\"token assign-left variable\">DB_USERNAME<\/span><span class=\"token operator\">=<\/span>database_username\n<span class=\"token assign-left variable\">DB_PASSWORD<\/span><span class=\"token operator\">=<\/span>database_password<\/code><\/pre>\n<p>If you are using MAMP local server in macOs; make sure to append UNIX_SOCKET and DB_SOCKET below database credentials in <strong>.env <\/strong>file.<\/p>\n<pre class=\"language-bash\" tabindex=\"0\"><code class=\"language-bash\"><span class=\"token assign-left variable\">UNIX_SOCKET<\/span><span class=\"token operator\">=<\/span>\/Applications\/MAMP\/tmp\/mysql\/mysql.sock\n<span class=\"token assign-left variable\">DB_SOCKET<\/span><span class=\"token operator\">=<\/span>\/Applications\/MAMP\/tmp\/mysql\/mysql.sock<\/code><\/pre>\n<h2>Set Up CSV File<\/h2>\n<p>Let us prepare the csv file; for that, you have to ensure you are in the database folder, here you have to create `csv` folder and a transaction_report.csv file.<\/p>\n<p>Theoretically, this csv file holds the dummy transaction report with Transaction_date, Price, Payment_Type, Name, City, US Zip<\/p>\n<p>Here is the data that you have to add into the <strong>database\/csv\/transaction_report.csv<\/strong>.<\/p>\n<pre class=\"language-csv\" tabindex=\"0\"><code class=\"language-csv\"><span class=\"token value\">Transaction_date<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Price<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Payment_Type<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Name<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">City<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">US Zip<\/span>\n<span class=\"token value\">01\/11\/2009 17:28<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sophie<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Newtown<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">6470<\/span>\n<span class=\"token value\">01\/03\/2009 21:11<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">asuncion<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Centennial<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">80112<\/span>\n<span class=\"token value\">01\/23\/2009 11:33<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sandrine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Walnut Creek<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">94596<\/span>\n<span class=\"token value\">01\/07\/2009 19:06<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Brittany<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Orlando<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">32801<\/span>\n<span class=\"token value\">01\/05\/2009 19:29<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Carmen<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Arlington<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22201<\/span>\n<span class=\"token value\">01\/25\/2009 8:54<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Corinne<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anthem<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85086<\/span>\n<span class=\"token value\">01\/12\/2009 8:05<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Francoise<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Danville<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">17821<\/span>\n<span class=\"token value\">01\/15\/2009 8:12<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Katherine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Marietta<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">30060<\/span>\n<span class=\"token value\">01\/19\/2009 14:53<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Laura<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fairfield<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">52556<\/span>\n<span class=\"token value\">01\/11\/2009 6:01<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anna<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">New York<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">10007<\/span>\n<span class=\"token value\">01\/18\/2009 11:17<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Rachel<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Atascadero<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">93422<\/span>\n<span class=\"token value\">01\/17\/2009 3:22<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Rachel<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fresno<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">93702<\/span>\n<span class=\"token value\">01\/12\/2009 20:43<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Alicja<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Kenmore<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">98028<\/span>\n<span class=\"token value\">01\/05\/2009 10:25<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">linda<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Arlington<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22201<\/span>\n<span class=\"token value\">01\/06\/2009 16:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">cristina<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Seattle<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">98104<\/span>\n<span class=\"token value\">01\/13\/2009 5:58<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Kit<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Suwanee<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">30024<\/span>\n<span class=\"token value\">01\/01\/2009 9:35<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Barbara<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">La Crescenta<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">91214<\/span>\n<span class=\"token value\">01\/16\/2009 11:49<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Yoko<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Andover<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1810<\/span>\n<span class=\"token value\">01\/13\/2009 11:54<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">alice and rudolf<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Baltimore<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">21224<\/span>\n<span class=\"token value\">01\/15\/2009 9:52<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mark<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Holmdel<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">7733<\/span>\n<span class=\"token value\">01\/27\/2009 8:11<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Helena<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fremont<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">94538<\/span>\n<span class=\"token value\">01\/21\/2009 9:07<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Elaine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Vienna<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22180<\/span>\n<span class=\"token value\">01\/25\/2009 19:59<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Kim<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Seattle<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">98104<\/span>\n<span class=\"token value\">01\/10\/2009 21:36<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Craig<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Seattle<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">98104<\/span>\n<span class=\"token value\">01\/28\/2009 20:59<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Michele<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Austin<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">78701<\/span>\n<span class=\"token value\">01\/05\/2009 12:41<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Kathryn<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Pacific Beach<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">92109<\/span>\n<span class=\"token value\">01\/30\/2009 19:12<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Heather<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ooltewah<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">37363<\/span>\n<span class=\"token value\">01\/19\/2009 8:52<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Pam<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Richmond<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">77469<\/span>\n<span class=\"token value\">01\/28\/2009 20:44<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Whitney<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Falmouth<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22405<\/span>\n<span class=\"token value\">01\/06\/2009 16:07<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Margaret<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Terrell Hills<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">78205<\/span>\n<span class=\"token value\">01\/23\/2009 21:41<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Joanne<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Oak Park<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">48237<\/span>\n<span class=\"token value\">01\/09\/2009 19:41<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Tarah<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">San Jose<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">95113<\/span>\n<span class=\"token value\">01\/07\/2009 13:49<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">megan<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">West Hills<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">91303<\/span>\n<span class=\"token value\">01\/12\/2009 14:50<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Holly<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Arlington<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">2476<\/span>\n<span class=\"token value\">01\/07\/2009 20:15<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Nicole<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Houston<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">77002<\/span>\n<span class=\"token value\">01\/07\/2009 15:12<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anabela<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Flossmoor<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">60422<\/span>\n<span class=\"token value\">01\/07\/2009 7:44<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Marie<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ball Ground<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">30107<\/span>\n<span class=\"token value\">01\/06\/2009 22:19<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ritz<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Pittsfield<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">5762<\/span>\n<span class=\"token value\">01\/06\/2009 23:00<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sylvia<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Pittsfield<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">5762<\/span>\n<span class=\"token value\">01\/09\/2009 6:39<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anneli<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Houston<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">77002<\/span>\n<span class=\"token value\">01\/08\/2009 16:24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">jennifer<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Phoenix<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85004<\/span>\n<span class=\"token value\">01\/06\/2009 7:46<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Kelly<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Reston<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20190<\/span>\n<span class=\"token value\">01\/03\/2009 9:03<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sheila<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Brooklyn<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">11226<\/span>\n<span class=\"token value\">01\/08\/2009 3:16<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Linda<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Miami<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">33130<\/span>\n<span class=\"token value\">01\/08\/2009 3:56<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Katherine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">New York<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">10007<\/span>\n<span class=\"token value\">01\/08\/2009 0:42<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Family<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Los Gatos<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">95032<\/span>\n<span class=\"token value\">01\/01\/2009 20:21<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Maxine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Morton<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">61550<\/span>\n<span class=\"token value\">01\/07\/2009 8:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Bryan Kerrene<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">New York<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">10007<\/span>\n<span class=\"token value\">01\/01\/2009 2:24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Lisa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sugar Land<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">77478<\/span>\n<span class=\"token value\">01\/06\/2009 7:18<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">asuman<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Chula Vista<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">91910<\/span>\n<span class=\"token value\">01\/02\/2009 7:35<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Hani<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Salt Lake City<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">84111<\/span>\n<span class=\"token value\">01\/02\/2009 14:18<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Richard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Riverside<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">8075<\/span>\n<span class=\"token value\">01\/05\/2009 10:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Georgia<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Eagle<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">83616<\/span>\n<span class=\"token value\">01\/02\/2009 9:16<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sean<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Shavano Park<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">78230<\/span>\n<span class=\"token value\">01\/05\/2009 2:42<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Stacy<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">New York<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">10002<\/span>\n<span class=\"token value\">01\/02\/2009 20:09<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">adam<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Martin<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">38237<\/span>\n<span class=\"token value\">01\/04\/2009 20:11<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fleur<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Peoria<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">61601<\/span>\n<span class=\"token value\">01\/04\/2009 13:19<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">LAURENCE<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mickleton<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">8056<\/span>\n<span class=\"token value\">01\/04\/2009 12:56<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Gerd W<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Cahaba Heights<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">35243<\/span>\n<span class=\"token value\">01\/03\/2009 9:58<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anja<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Gainesville<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20155<\/span>\n<span class=\"token value\">01\/06\/2009 15:12<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">lydia<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sandy Plains<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">30075<\/span>\n<span class=\"token value\">01\/24\/2009 11:05<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">alan<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Norcross<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">30071<\/span>\n<span class=\"token value\">01\/24\/2009 7:14<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">nihan<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Roanoke<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">24018<\/span>\n<span class=\"token value\">01\/18\/2009 6:09<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ignacio<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Engleside<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22314<\/span>\n<span class=\"token value\">01\/04\/2009 13:20<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Nuria<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Superior<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">80027<\/span>\n<span class=\"token value\">01\/02\/2009 9:57<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">leigh<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Potomac Falls<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20165<\/span>\n<span class=\"token value\">01\/31\/2009 11:14<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ulrika<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Scottsdale<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85251<\/span>\n<span class=\"token value\">01\/11\/2009 14:07<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sarah<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">San Francisco<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">94103<\/span>\n<span class=\"token value\">01\/31\/2009 8:56<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Laura<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Coconut Grove<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">33133<\/span>\n<span class=\"token value\">01\/31\/2009 7:22<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Monica<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Weston<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">6883<\/span>\n<span class=\"token value\">01\/30\/2009 20:36<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Renee<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Edinburg<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">78539<\/span>\n<span class=\"token value\">01\/08\/2009 13:19<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">valerie et nicolas<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Glenn Dale<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20706<\/span>\n<span class=\"token value\">01\/26\/2009 11:38<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Gabriella<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Austin<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">78701<\/span>\n<span class=\"token value\">01\/07\/2009 18:53<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Marie-Christine<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Durham<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">27701<\/span>\n<span class=\"token value\">01\/19\/2009 10:32<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Maie<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Queen Creek<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85142<\/span>\n<span class=\"token value\">01\/26\/2009 12:05<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1250<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">verena<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Queen Creek<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85142<\/span>\n<span class=\"token value\">01\/02\/2009 9:31<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">camilla<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Chicago<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">60608<\/span>\n<span class=\"token value\">01\/11\/2009 12:22<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Marina<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Minneapolis<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">55401<\/span>\n<span class=\"token value\">01\/02\/2009 13:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Federica e Andrea<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Astoria<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">97103<\/span>\n<span class=\"token value\">01\/22\/2009 22:16<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">leanne<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Clyde Hill<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">98004<\/span>\n<span class=\"token value\">01\/29\/2009 15:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">KERRY<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sunnyvale<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">94086<\/span>\n<span class=\"token value\">01\/29\/2009 10:09<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Jacqui<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Scottsdale<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">85251<\/span>\n<span class=\"token value\">01\/29\/2009 12:28<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Alva and Martin<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Great Falls<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">22066<\/span>\n<span class=\"token value\">01\/23\/2009 15:33<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">T<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Brooklyn<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">11226<\/span>\n<span class=\"token value\">01\/09\/2009 15:24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">alex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Farmingtn Hls<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">48336<\/span>\n<span class=\"token value\">01\/13\/2009 18:08<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amanda<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Houston<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">77002<\/span>\n<span class=\"token value\">01\/29\/2009 5:30<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Vanessa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Ithaca<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">14850<\/span>\n<span class=\"token value\">01\/29\/2009 5:43<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mrs<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Sunnyvale<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">94086<\/span>\n<span class=\"token value\">01\/28\/2009 13:07<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">BALA<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Accokeek<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20607<\/span>\n<span class=\"token value\">01\/18\/2009 4:01<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Eleanor<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fairbanks<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">99701<\/span>\n<span class=\"token value\">01\/12\/2009 18:24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Anthony<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Victor<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">14564<\/span>\n<span class=\"token value\">01\/05\/2009 10:49<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">3600<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Courtney<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mililani<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">96782<\/span>\n<span class=\"token value\">01\/05\/2009 13:46<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Visa<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Courtney<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Atchison<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">66002<\/span>\n<span class=\"token value\">01\/04\/2009 17:54<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">ruth<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Encinitas<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">92024<\/span>\n<span class=\"token value\">01\/18\/2009 8:56<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Stanford<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Howell<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">48843<\/span>\n<span class=\"token value\">01\/07\/2009 12:55<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Amex<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Fiona<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Stamford<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">6901<\/span>\n<span class=\"token value\">01\/14\/2009 12:07<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Lainey<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Lakeville<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">55044<\/span>\n<span class=\"token value\">01\/28\/2009 12:31<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Diners<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">lilia<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Brooklyn<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">11226<\/span>\n<span class=\"token value\">01\/02\/2009 12:16<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">1200<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Mastercard<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Monique<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">Waldorf<\/span><span class=\"token punctuation\">,<\/span><span class=\"token value\">20603<\/span><\/code><\/pre>\n<h2>Incorporate Model and Migrations<\/h2>\n<p>In this step, we will set up the model and migration. It allows you to create the table definition inside the database.<\/p>\n<p>We will demystify the table creation process more eloquently; here are the instructions that are required to be followed.<\/p>\n<p>First, execute the command; make sure to use the below command to generate the model and migrations file simultaneously.<\/p>\n<pre class=\"  language-bash\" tabindex=\"0\"><code class=\"  language-bash\">php artisan make:model Transaction -m<\/code><\/pre>\n<p>Open the <strong>database\/migrations\/create_transactions_table.php<\/strong> and copy the given code and paste into the file.<\/p>\n<pre class=\"language-php\" tabindex=\"0\"><code class=\"language-php\"><span class=\"token php language-php\"><span class=\"token delimiter important\"><?php<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Database<span class=\"token punctuation\"><\/span>Migrations<span class=\"token punctuation\"><\/span>Migration<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Database<span class=\"token punctuation\"><\/span>Schema<span class=\"token punctuation\"><\/span>Blueprint<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Support<span class=\"token punctuation\"><\/span>Facades<span class=\"token punctuation\"><\/span>Schema<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">CreateTransactionsTable<\/span> <span class=\"token keyword\">extends<\/span> <span class=\"token class-name\">Migration<\/span>\n<span class=\"token punctuation\">{<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">up<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token punctuation\">{<\/span>\n        <span class=\"token class-name static-context\">Schema<\/span><span class=\"token operator\">::<\/span><span class=\"token function\">create<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'transactions'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name type-declaration\">Blueprint<\/span> <span class=\"token variable\">$table<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token function\">id<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'transaction_date'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'price'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'payment_type'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'name'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'city'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token keyword type-declaration\">string<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'us_zip'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token variable\">$table<\/span><span class=\"token operator\">-><\/span><span class=\"token function\">timestamps<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">down<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token punctuation\">{<\/span>\n        <span class=\"token class-name static-context\">Schema<\/span><span class=\"token operator\">::<\/span><span class=\"token function\">dropIfExists<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'transactions'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span><\/span><\/code><\/pre>\n<p>Likewise, repeat the similar process in <strong>app\/Models\/Transaction.php<\/strong> file.<\/p>\n<pre class=\"language-php\" tabindex=\"0\"><code class=\"language-php\"><span class=\"token php language-php\"><span class=\"token delimiter important\"><?php<\/span>\n<span class=\"token keyword\">namespace<\/span> <span class=\"token package\">App<span class=\"token punctuation\"><\/span>Models<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Database<span class=\"token punctuation\"><\/span>Eloquent<span class=\"token punctuation\"><\/span>Factories<span class=\"token punctuation\"><\/span>HasFactory<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Database<span class=\"token punctuation\"><\/span>Eloquent<span class=\"token punctuation\"><\/span>Model<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">Transaction<\/span> <span class=\"token keyword\">extends<\/span> <span class=\"token class-name\">Model<\/span>\n<span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">use<\/span> <span class=\"token package\">HasFactory<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token keyword\">protected<\/span> <span class=\"token variable\">$fillable<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n        <span class=\"token string single-quoted-string\">'transaction_date'<\/span><span class=\"token punctuation\">,<\/span> \n        <span class=\"token string single-quoted-string\">'price'<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'payment_type'<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'name'<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'city'<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'us_zip'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span><\/span><\/code><\/pre>\n<p>Eventually, we will execute the migration command.<\/p>\n<pre class=\"  language-bash\" tabindex=\"0\"><code class=\"  language-bash\">php artisan migrate<\/code><\/pre>\n<h2>Add Large Records using CSV<\/h2>\n<p>Almost more than half of the work has been done, now to seed your database with a large CSV, we will use the seeder. The seeder artisan command needs to be evoked to manifest the seed class.<\/p>\n<pre class=\"language-bash\" tabindex=\"0\"><code class=\"language-bash\">php artisan make:seeder TransactionSeeder<\/code><\/pre>\n<p>Generically, seed file stays into the <strong>database\/seeders<\/strong> folder, now you have to define the given code into the <strong>database\/seeders\/TransactionSeeder.php<\/strong> file.<\/p>\n<pre class=\"language-php\" tabindex=\"0\"><code class=\"language-php\"><span class=\"token php language-php\"><span class=\"token delimiter important\"><?php<\/span>\n<span class=\"token keyword\">namespace<\/span> <span class=\"token package\">Database<span class=\"token punctuation\"><\/span>Seeders<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">Illuminate<span class=\"token punctuation\"><\/span>Database<span class=\"token punctuation\"><\/span>Seeder<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">use<\/span> <span class=\"token package\">App<span class=\"token punctuation\"><\/span>Models<span class=\"token punctuation\"><\/span>Transaction<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">TransactionSeeder<\/span> <span class=\"token keyword\">extends<\/span> <span class=\"token class-name\">Seeder<\/span>\n<span class=\"token punctuation\">{<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">run<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token punctuation\">{<\/span>\n        <span class=\"token class-name static-context\">Transaction<\/span><span class=\"token operator\">::<\/span><span class=\"token function\">truncate<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$csvData<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">fopen<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">base_path<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'database\/csv\/transaction_report.csv'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string single-quoted-string\">'r'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$transRow<\/span> <span class=\"token operator\">=<\/span> <span class=\"token constant boolean\">true<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">while<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$data<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">fgetcsv<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$csvData<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">555<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string single-quoted-string\">','<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">!==<\/span> <span class=\"token constant boolean\">false<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token operator\">!<\/span><span class=\"token variable\">$transRow<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n                <span class=\"token class-name static-context\">Transaction<\/span><span class=\"token operator\">::<\/span><span class=\"token function\">create<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span>\n                    <span class=\"token string single-quoted-string\">'transaction_date'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'0'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                    <span class=\"token string single-quoted-string\">'price'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'1'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                    <span class=\"token string single-quoted-string\">'payment_type'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'2'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                    <span class=\"token string single-quoted-string\">'name'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'3'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                    <span class=\"token string single-quoted-string\">'city'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'4'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                    <span class=\"token string single-quoted-string\">'us_zip'<\/span> <span class=\"token operator\">=><\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'5'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n                <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n            <span class=\"token variable\">$transRow<\/span> <span class=\"token operator\">=<\/span> <span class=\"token constant boolean\">false<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        <span class=\"token function\">fclose<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$csvData<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span><\/span><\/code><\/pre>\n<h2>Start Laravel App<\/h2>\n<p>It\u2019s time to seed the records into the database table; let us hand over this task to the recommended command.<\/p>\n<p>It will insert every data defined in our comma-separated file, and we promise it won\u2019t leave even an iota of data.<\/p>\n<pre class=\"language-bash\" tabindex=\"0\"><code class=\"language-bash\">php artisan db:seed --class<span class=\"token operator\">=<\/span>TransactionSeeder<\/code><\/pre>\n<p>To check the imported data in your database, make sure to go to <strong>database > transactions<\/strong> table.<\/p>\n<p>Here is the output you will view on your db screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.positronx.io\/wp-content\/uploads\/2021\/12\/15959-01.jpg\" alt=\"Laravel Import Records in SQL with CSV and Seeder Tutorial\" width=\"1000\" height=\"213\" class=\"alignnone size-full wp-image-16090\" srcset=\"https:\/\/www.positronx.io\/wp-content\/uploads\/2021\/12\/15959-01.jpg 1000w, https:\/\/www.positronx.io\/wp-content\/uploads\/2021\/12\/15959-01-768x164.jpg 768w, https:\/\/www.positronx.io\/wp-content\/uploads\/2021\/12\/15959-01-302x64.jpg 302w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\"><\/p>\n<h2>Summary<\/h2>\n<p>Up until now, we have demystified every process to import large records in the SQL database in the Laravel application. To insert the data in the database table, we used the CSV file and laravel seeder.<\/p>\n<p>We hope we have been more articulative in making you understand.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The database has the integrity to hold the records, be it a few or many more. If you are a Laravel developer and looking to import extensive data records through [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":340,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,14],"tags":[],"class_list":["post-339","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-laravel","category-tutorial","clearfix"],"_links":{"self":[{"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/posts\/339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/comments?post=339"}],"version-history":[{"count":1,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":702,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/posts\/339\/revisions\/702"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/media\/340"}],"wp:attachment":[{"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/media?parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/categories?post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/247blogs.com\/wp\/wp-json\/wp\/v2\/tags?post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}