[Vtigercrm-developers] Barcode system

Thu Sep 10 10:03:28 GMT 2015

It's not as simple as you describe, you have to face several problems: 

GLOBAL SEARCH 

You have some problems with the search. First of all searching uses
vtiger_entityname [using the vtiger_crmentity table in the label column
to be more specific]. The problem is that this field is used in other
mechanisms, for example - in the uitype10 field. Currently, if you
change the value of the field you use for searching [eg. EAN] it will
cause EAN to appear in various places, instead of the product name.
Unfortunately, you can't change it, it requires core changes. It is not
easy, it took us two days and caused many problems. The search should be
completely separated from the uitype10 field [best thing is to switch
the field used for searching so that it's different than the label field
in crmentity]. 

You can try to introduce the change only in modules with products and
change it for searching for the product / service, but the problem is
global, because it should not happen that if I look for a company by its
number I have to use the advanced search, or I can'tsearch for an
invoice by its number, and I have to search for it by its name only [and
I want to use both]. We created a separate panel for that [attachment
search1.png] 

BARCODE READERS 

The problem here is more complicated because it consists of several
layers: 

1. Current modules with products [quotes, invoices, orders] - this
module is badly coded - we first wanted to fix it, but finally decided
to write it from scratch. The module in the Vtiger doesn't allow for
manipulating the fields [their visibility, order] also [what is most
important from the code reading perspective] it doesn't allow you to set
the order of fields [index]. And the worst part is that it defines the
same rules for all modules at the same time [which is bad] 

2. When introducing for example a receipt of goods to the warehouse into
the system, then reading products from the receipt document happens this
way: ean, quantity, next line, ean, quantity, next line. This means that
after entering the quantity, the system should automatically create a
new line and proceed to the ean field, so that this process [loading the
document] wouldn't require any interaction from the person who loads the
document. So it should be possible in the field configuration to set the
field in which the jump to a new line takes place! 

3. Note that good systems don't only assign ean to products but also to
other elements, such as document marking. This means that if we load the
document's barcode from a search field, then the system should find that
file [which is now impossible because of the first point]. 

PRINTS AND PREVIEW 

I appreciate the contribution of external companies in the development
of commercial modules, however, there are certain modules that should be
part of the system. One of them is the PDF module, because it should be
fully integrated with the system, and what's more important - it should
be part of the system's development. Apart from the fact that we can
print your document to PDF and they should contain the barcode elements
[that should be built into the system so that the bar code introduced in
the form of eg. a sequence of characters, was visible in the system as a
barcode, for example in the record preview]. 

Certainly, from the business perspective, it's important to think to
what extent Vtiger should be a CRM system, and to what extent it should
contain elements of other systems [eg .: ERP, MRP]. There are certain
standards considered global, including EDI - if someone adds the ability
to create invoices or orders in the system, why not create them in
accordance to the global standards? Why not export the invoice to XML
with the option to set the template? 

These are my observations and thoughts, don't take it too personally. 
---

Z poważaniem / Regards 

BŁAŻEJ PABISZCZAK 
_Chief Executive Officer_ 
M: +48.884999123
E: b.pabiszczak at yetiforce.com 
-------------------------

W dniu 2015-09-08 16:39, Doug napisał(a): 

> Bar code is easy like Alan mentioned.
> In this case click on the field you want filled, like upc number, and shoot; the reader will fill the number automatically. 
> On Sep 8, 2015 12:59 AM, "Simone Travaglini" <simonetravaglini at gmail.com> wrote:
> 
> Hi, 
> anyone have a ready solution for barcode? 
> 
> 2015-07-21 13:55 GMT+02:00 Alan Bell <alan.bell at libertus.co.uk>:
> 
> barcode readers generally appear to computers as being USB keyboards that type stuff, zapping a couple of toner cartridge boxes I have lying about types this:
> 
> 5055628402694
> 821831064739
> 
> so, if you put the barcode in the product name field (or at the start of it at any rate) then in a quote or sales order you should be able to go to the item name field in a line item, zap the box and it will find the item for you.
> 
> would be nice if the typeahead in the line item name field searched on product code as well as product name.
> 
> Alan. 
> 
> On 21/07/15 12:41, Greg Vas wrote: 
> 
> How to make a barcode system like this: 
> 
> 1) Scan a barcode and connect with a product i have. (Maybe put it in the serial number field in product module?) 
> 
> 2) Put the barcode anywhere (eg. in the invoice) and appear the product 
> 
> Generally i want to connect the barcode number with the product and play from there. 
> 
> Is there any barcode solution or go to something else (erp/crm product) 
> 
> _______________________________________________
> http://www.vtiger.com/ [1]
> 
> _______________________________________________
> http://www.vtiger.com/ [1]

 -- 

Simone Travaglini
328 5499846
Linkedin: Simone Travaglini 

Rispetta l'ambiente: non stampare questa mail se non ti è veramente
necessario! 
_______________________________________________
http://www.vtiger.com/ [1] 

_______________________________________________
http://www.vtiger.com/ [1] 

Links:
------
[1] http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150910/89107c3d/attachment-0001.html>