Available DB with real/realistic data

Using my Dolibarr
1

Hello.
For a university project, I have to use and test Dolibarr web app. Since I will go through test automation, I will have to automatically fill forms and widgets with some data, Hence, I was wonder if any test database with realistic (not real, of course, due to privacy) data was available somewhere or if any of you could share it with me.
Thank you in advance.

1 Like
2

Dolibarr is easy to use Crm/Erp.

You can just install and start entering the basic data for your knowledge.
When you will enter data by self, then only you will understand what goes where and that will give you an idea for your project.

Advice - fresh install stable version, start from the start.

3

Well, I guess I will have to enter data by myself if I don’t find anything useful next days.
Thanks for the answer!

4

Hi,

ask @eldy if the database of the DOlibarr Demo is availlable somewhere ?
https://demo.dolibarr.org/public/demo/index.php

Edit : May be it is that files : https://github.com/Dolibarr/dolibarr/tree/develop/dev/initdemo

1 Like
5

Thank you, I’ll follow the link.

6

hey were you able to get the data ?

7

Check this module on Dolistore:
https://www.dolistore.com/en/modules/1473-Doli-Dummy-Data.html

8

This is not available for free. Is there some other way

9

I don’t know about any free ready solution. However, you can try one of the free database sample online and try the import function in Dolibarr.

10

Hello all,
Just wanted to update this thread on how I managed to populate my instance with a strong dataset and free of cost.

Few things to note before we proceed:

  1. I just want to share my findings and while I am happy answer any questions you folks may have, I would like to clearly state that I am not taking any responsibility for your instance and if you are trying out this solution, I would like to gently remind you that you are taking the responsibility for the outcome of this process.
  2. This will completely wipe your existing data so I advice to do this immediately after installation or only if you are willing to loose all your data and customizations
  3. You will need an alter access to your database. Without it, this cannot be done.
  4. You should have access to the machine where you have installed Dolibarr.

Steps:

  1. @ksar was spot on with their suggestion given in this reply:

Hi,
ask @eldy if the database of the DOlibarr Demo is availlable somewhere ?
Edit : May be it is that files : https://github.com/Dolibarr/dolibarr/tree/develop/dev/initdemo

I am referring specifically to the github link.

  1. Go to the link and get these files: initdemo.sh, mysqldump_dolibarr_x.y.z.sql (Where x.y.z. represents your Dolibarr version) and updatedemo.php for your relevant version by selecting the version from the dropdown box
  2. Now login to your database with a user that has alter rights on the database.
  3. Drop all the tables in your Dolibarr db. I did it in an easy way by referring to this answer on StackOverflow: MySQL DROP all tables, ignoring foreign keys - Stack Overflow
    Why this destructive step?
    → I have installed Dolibarr on shared hosting and hence I cannot use the sudo command. The initdemo.sh scripts needs to be run as root so this was not possible for me, if you have that privilege you can give that a try but I cannot comment on it’s success or failure.
    → Initially, I tired running the SQL on my existing DB but it kept on failing with Foreign key constraint error despite explicitly asking it to be ignored. Based on some solutions found in this forum itself, dropping and creating a new DB (Or simply deleting all the tables in existing DB which will have the same impact) was the way to go (and it worked)
  4. Once the tables are dropped, you can directly run the SQL script. If you are using shared hosting or want to do this through PHPMyAdmin, you can simply import the SQL and it will do the trick
  5. After this, go to your Dolibarr URL. It will automatically take you to Install/Upgrade/Repair screen. Just click Start → Next → Next → Go to Dolibarr. Default username and password are given in the ReadMe of the Github link.
  6. Ensure that the demo data is populated. Once you see it, go to your machine where Dolibarr is installed, copy the updatedemo.php file in the root location and run it with confirm option. If you are doing it on Linux, it will look like
$ php updatedemo.php confirm

It will show you updating date dialogs for most of the entities. This helps make your seed data realistic rather than everything expired and pending.

  1. Once you have done this, again check the demo data.
  2. While you are doing this, there are high chances you have encountered errors regarding DB or similar undefined errors. In this case (Or I recommend in any case), just go to /install/index.php and rerun the setup from start. This will fix the issues in the third step (You can see the steps if you say Show Details)

Voila, you will now have a fully functional instance with a lot of decent seed data. Remember to add your Admin and remove/disable the demo data admin account.

2 Likes