Insert Multiple data with Barcode Scanners

Applications Forms
#1

Hello, I have to insert multiple products with it serial numbers, but I want to add it all in one time, no one to one. Because I have as 200 serials numbers. How I could made it with multiple form?

Expample:

  • Product Name
  • Serial Number

I have 200 product that are equal but with different serial number, I want to add all the serial numbers with the Barcode Scanner, so I don?t have to enter it one by one. I want to select the product and then read all the barcodes with the Scanner.And then I could made a Consult by Serial Number.

Thanks.
Matias.

#2

Re: Insert Multiple data with Barcode Scanners

Hi,

you can do it with sc_exec_sql macro.
Create a new field that will be the number of products. Then use a FOR or WHILE to insert all of them.

V?tor

#3

Re: Insert Multiple data with Barcode Scanners

Vitor, So I have to create it in simple form or in a multiple form??? then I select the field Product Name,Serial Number from my db and make the Macro sc_exec_sql. Then create the new field Serial Number. But where I use the FOR or WHILE?? and how???
Thanks.
Matias.

#4

Re: Insert Multiple data with Barcode Scanners

You can use a control application to enter the Product Name. Then, save it in a Global Variable and link the application with a form where the Product Name field will be receiving the Variable. So you just need input the serial number with the Scanner.

#5

Re: Insert Multiple data with Barcode Scanners

In the past on my Win32 apps, I would just present a memo field and allow the user to enter all entries from the scanner and then loop through the memo field line by line. The scanner should insert the CR/LF as needed. No need to hassle with an input screen at all.

Regards,
Scott.

#6

Re: Insert Multiple data with Barcode Scanners

Don?t know if anybody reads this thread again.

i have a problem that i have to scan via a Barcode Scanner and the extract a few characters out of the scan which are the amounts of packages on a whole pallet.
This value should be stored in a table field and has to be updated with each scanning of a special barcode.

the reason for this is, that i have a value in a table which is the production quantity for the product. With each scan, the qantity will decrease till the production is ended.
the remaining production quantity has to be shown for the user, think could be done through the containers/widgets update function.

anyone with the same specs ?

#7

Re: Insert Multiple data with Barcode Scanners

Hi Gerd,

not sure I really understand the problem.
Scanning the barcode will send a string to the fokus field. You can set the scanner to send not only the string but also a TAB, so that the fokus will be set to the next field. Just use AJAX_blur or AJAX_change for the field, where the barcode was entered to. In that event you can simply do everything you want with the string, using PHP string functions.

BR

Eric

#8

A barcode scanner is only something which is installed between your keyboard and workstation. That way it doesn’t matter if you enter the code by hand or using the scanner: you click in the field which needs the code to be entered to get the focus on it, next you scan your code. The only problem might be that after scan there’s no automatic submit, so you need to click a button then.
if not mind ,take a look at this guide for using barcode scanner

#9

Check my solution here

You can use a standard form ( multiple record ) with auto-insert on every barcode scanned and put some code on AfterInsert event

#10

[QUOTE=gbravi;19960]Check my solution here

You can use a standard form ( multiple record ) with auto-insert on every barcode scanned and put some code on AfterInsert event[/QUOTE]

er. sounds good idea! i’d like to try

#11

Take a look here. There is some code that you can use. http://www.scriptcase.net/forum/showthread.php?204-Create-a-form-for-product-inclusion-using-barcode

#12

Re: Insert Multiple data with Barcode Scanners

[QUOTE=EricB;7022]Hi Gerd,
not sure I really understand the problem.
Scanning the barcode will send a string to the fokus field. You can set barcode scanner to send not only the string but also a TAB, so that the fokus will be set to the next field. Just use AJAX_blur or AJAX_change for the field, where the barcode was entered to. In that event you can simply do everything you want with the string, using PHP string functions.
[/QUOTE]

In my opinion, this is the point and can help solve barcode scanning problem.

#13

[QUOTE=gbravi;19960]Check my solution here

You can use a standard form ( multiple record ) with auto-insert on every barcode scanned and put some code on AfterInsert event[/QUOTE]

Thank you, it’s easy for me to insert barcode with bar code scanner, but I’ve no idea on auto-inserting bar code.

#14

Autoinserting barcode is not so hard. Configure your barcode reader to automatically send a carriage return + linefeed or a to send it a tab (depending on how you build your application of course). So this lies in the barcode scanner. You should find the needed settings in the manual of the barcode reader.
A more complicated solution would be to add some javascript to detect an end of barcode signal (in the above case a cr + LF) or detect a barcode length.

#15

[QUOTE=rr;36812]Autoinserting barcode is not so hard. Configure your barcode reader to automatically send a carriage return + linefeed or a to send it a tab (depending on how you build your application of course). So this lies in the barcode scanner. You should find the needed settings in the manual of the barcode reader.
A more complicated solution would be to add some javascript to detect an end of barcode signal (in the above case a cr + LF) or detect a barcode length.[/QUOTE]
Thank you so much!:o