I’m just new with dolibarr, and what I can says is “Whoa !!”. For a free product it’s just amaysing.
In my previous compagny I use to configure private ERP/CRM (I do not says any name here) and lot’s of feature are already embeded by Dolibarr.
I just let here some things that missing :
- Item list by customer (customer category, set of customer attribute)
- Price list by customer (customer category, set of customer attribute)
- Discount matrix by product and/or customer attribute
- Possibily to configure order taking with list of discount more than free discount choice
- Retail audit feature for sales man in customer office.
As I’m also a developper, I’ll try to implement this kind of ideas, and we will see how I can manage with it.
I’ve just finnish the module assortment, witch is the first point of my list. I already plublish it on Dolibarr Store. you can found it in new product.
Tried your module and get the following error when clicking on the tab “assortment”
Warning: require_once(C:/wamp/www/testdolibarr-3.0.0/htdocs/assortment/lib/assortment.lib.php) [function.require-once]: failed to open stream: No such file or directory in C:\wamp\www\testdolibarr-3.0.0\htdocs\assortment\assortment.php on line 32
Fatal error: require_once() [function.require]: Failed opening required ‘C:/wamp/www/testdolibarr-3.0.0/htdocs/assortment/lib/assortment.lib.php’ (include_path=‘C:/wamp/www//htdocs’) in C:\wamp\www\testdolibarr-3.0.0\htdocs\assortment\assortment.php on line 32
Hello, it seemes that the tgz do not extract succesfully.
the file assortment\assortment.lib.php is one of the master piece of the module. Could you tell me if the directory assortment exists ?
I’ll check on my side what’s going wrong with the tgz archive.
Maybe the installation process was not good in the desc in dolistore.
I’ve replace the following
Download the archive file of module (.tgz file) from web site DoliStore.com
Put the file into the root directory of Dolibarr.
Uncompress the tgz file, for example with command
[b] tar -xvf assortment.tgz[/b]
Module or skin is then available and can be activated.
by
Download the archive file of module (.tgz file) from web site DoliStore.com
Put the file into the root directory of Dolibarr.
Uncompress the tgz file, for example with command
[b] tar -xvf module_assortment-1.0.tgz[/b]
Module or skin is then available and can be activated.
I found what’s wrong in the tgz. the file assortment.lib.php effectivly missing. I try to build a correct one and I’ll republish the module.
Thanks for the quick test, and, in the future, before publish a module i’ll try to deployed it on a fresh new install.
I know it’s the best pratice, and as a beginner, I do the mistake to overpass this step… My backdraw always follow me. Make things too quick is never good, I should now that after all the time spend on correct my own bugs in my previous life.
Product Assortment
Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20110604194906
Dolibarr: 3.0.0
Level of features: 0
PHP: 5.3.0
Server: Apache/2.2.11 (Win32) PHP/5.3.0
Database type manager: mysql
Request for last database access in error: SELECT assort.rowid, assort.label, soc.nom as SocName, prod.label as ProdLabel, prod.ref as ProdRef, assort.fk_soc, assort.fk_prod FROM llx_assortment as assort INNER JOIN llx_user as userAuth ON userAuth.rowid=assort.fk_user_author INNER JOIN llx_user as userMod ON userMod.rowid=assort.fk_user_mod INNER JOIN llx_product as prod ON prod.rowid=assort.fk_prod INNER JOIN llx_societe as soc ON soc.rowid=assort.fk_soc WHERE soc.rowid=‘206’;
Return code for last database access in error: DB_ERROR_NOSUCHTABLE
Information for last database access in error: Table ‘testdolibarr3.llx_assortment’ doesn’t exist
Warning: Invalid argument supplied for foreach() in C:\wamp\www\testdolibarr-3.0.0\htdocs\assortment\lib\assortment.lib.php on line 230
Could you please inactivate the module, and activate it again ?
If it not solving the problem :
I’ve got the same problem on the beginning, it come from the file htdocs/lib/admin.lib.php.
I’ve put some comment in the SQL instruction file to create the table and I have to modify the admin.lib.php to allow this.
That why the file admin.lib.php is include in my package
Could you please tell me if in this file you have in line 142 this texte :
// Add line buf to buffer if not a comment
if (! preg_match(’/^–/’,$buf))
{
//remove comment from a line that not start with – before add it to the buffer
After the inactivation and activation of the module, I have something working…
However if I understand right and you have choosen an assortiment of products for a customer, then you should only see the assortment of this customer while you are making an order or a propal, or did I not understand the function of your module?
In my previous compagny we have more than 100 000 products and some are only dedicaded to customer from specials countries or some promotionnal product are available only for supermarket as other are only for smallest retailler.
By the way, we use to classied product and customer with Category, and we can filter to witch product for witch customer.
It would be usefull to to sell products to different price to different customer, if you create two products.
Thank a lot again, and do not hesitate to tell me if you have idea to improve this module.
FYI there are 2 ways in dolibarr to add a product to a propal or order!
Your module only works when you set :
“Use a search form to choose a product (instead of using a list box)” to “NO”
When using “YES” your module does not work.
I agree that your product is very usefull, however the administration of your model could be more efficient if per customer you could add and remove the categories of products itself.
Now for example you add a categorie of products but if you want to remove again the categorie you can only do this 1 product at a time and not the whole catégory.
If you want to sell the same product at a different price for a customer I suggest not to create another product but simply a different price can also per called a price exception) per customer and use the same idea as you are doing with your assortment.
Last but not least, since it seems you have also modified some of the core files of Dolibarr, what will happen when there is an upgrade? will your module become obsloete?
Sorry for all the questions and thank you for your contribution of this already quite complete CRM…
Sorry for late answers, I have to re-install all my system (from Ubuntu WUBI to real Ubuntu…) anyway…
I’ve already notice that there is two ways to select products, but I’ve forgot (once again…) to include files in the package, I repost another version that sould correct the bug on no-select item list.
About the fact to remove product by category, I’ll work on it. For the moment, i will concentrate on correct other bugs on application, in order to become more than soldier rank, it’s really frustating to don’t be allowed to post directly bug correction, or enhancement. Be greater and have trust of dev-father take time and need reliable proof !
About the core file modified, it’s a huge question I try to solve. First, I didn’t want to modified them, but I didn’t found any way to do what I want without. That’s why I specified the minimum and maximum version in Dolistore. And I also agree that if anothers module installation change those files, my module will not work anymore on Order and Invoice screen… I will try to suggest some feature that will allow to avoid this kind of modification for next person who want to developp this kind of filters.
Sorry to hear about your problem and reinstall of your system, as for the rest, I think it is possible to make contact with the development team and to find out how to contribute in the best possible way.
There is a wiki on how to creat modules, however I am not a programmer just a user of dolibarr. I think there must be some way to create modules where you do not need to touch the core files.
For now the feature is very interesting and I hope you can fix the bugs and add a way so we can work with categories so we do not need to add and delete items one by one, since this can become very long and boring…
I’ve just publish a new version of my module, I limit the modification of Dolibarr Core file by creating extend class, but still have some other module files modified.
By the way, in this new version, I’ve develop the possibility to remove product of assortiement directly by category.
