• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need help populating database with products

#1
Hi everyone,

I need to learn how to quickly populate my shopping cart database with products. Is there a tutorial suitable for CI or is any kind soul willing to guide me or point me in the right direction? I've been playing with the db products and category tables for some days now but no joy.

Thanks for any help.
Reply

#2
@lulab,

Faker helps you build test data. Check it out: https://github.com/fzaninotto/Faker
Reply

#3
(10-08-2019, 05:37 PM)php_rocs Wrote: @lulab,

Faker helps you build test data. Check it out: https://github.com/fzaninotto/Faker

Hi,

Thank you so much for your reply. I took a quick look at Faker but I'm still wondering if I can use it to upload data for real non-fake products? Sad I need to feed db with product category, sub-category, name, title, description, corresponding image, quantity in stock etc etc. I wish I could do this with a CSV file, with the correct syntax of course and get Faker or similar script push it to the db?
Reply

#4
@lulab,

Faker data is not real data and its not really designed to upload not fake data.

What format is the data in? There are definitely multiple ways to get it into the database.
Reply

#5
Hi, 
I must be able to find a tutorial to help me export data from the db, csv format, then populate the file and upload back to db. Correct? 


Thanks! And have a nice day.
Reply

#6
@lulab,

What database are you exporting from? And what database are you importing too?
Reply

#7
Hi php_rocs,

Sorry I should have mentioned it's MySQL. Thanks.

[url=https://www.mysql.com/downloads/][/url]
Reply

#8
Why do you think you need CI do to this? Chances are that you manage your MySQL database with PhpMyAdmin, which has export and import functions.
Reply

#9
@Wouter60

You're right. I once used PhpMyAdmin to export but had errors during import. I'll reproduce the error and post. Thank you!
Reply

#10
@lulab,

Also, pay attention to the MySQL version that you are migration from and the version that you are migrating to. Also, as mentioned above there are many tools that can help you migrate from one database to another.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.