Announcement

Collapse
No announcement yet.

Insert Multiple data with Barcode Scanners

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Insert Multiple data with Barcode Scanners

    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

    Comment


    • #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.

      Comment


      • #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.

        Comment


        • #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.

          Comment


          • #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 ?

            Comment


            • #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

              Comment


              • #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

                Comment


                • #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
                  Giorgio Bravi
                  Dolphin Software & Thinkware
                  www.dolphin.it

                  Comment


                  • #10
                    Originally posted by gbravi View Post
                    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
                    er. sounds good idea! i'd like to try

                    Comment


                    • #11
                      Take a look here. There is some code that you can use. http://www.scriptcase.net/forum/show...-using-barcode
                      Giorgio Bravi
                      Dolphin Software & Thinkware
                      www.dolphin.it

                      Comment


                      • #12
                        Re: Insert Multiple data with Barcode Scanners

                        Originally posted by EricB View Post
                        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.
                        In my opinion, this is the point and can help solve barcode scanning problem.
                        Last edited by susannamoore; 05-31-2015, 03:03 AM.

                        Comment


                        • #13
                          Originally posted by gbravi View Post
                          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
                          Thank you, it's easy for me to insert barcode with bar code scanner, but I've no idea on auto-inserting bar code.

                          Comment


                          • #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.

                            Comment


                            • #15
                              Originally posted by rr View Post
                              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.
                              Thank you so much!

                              Comment

                              Working...
                              X