Jump to content

barcode help


This topic is 1881 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello, 

I am extremely new to Filemaker. I've been trying to learn it but time always dictates. I am trying to create what I believe is a simple database. What I am trying to do is to have a very basic system to track parts usage by our mechanics by either barcode or part number. Basically the mechanic would come up to the computer. Enter a unit #, worker order #, date,  part #(either by manual entry or upc.) and qty.  Then I would like to be able to print a report in the morning that will display Unit #, work order #, date, part # and qty. I can then take this information and enter it into our system. The problem I have is our system doesn't allow bar coding. Also some of our parts don't have barcodes such as tires and brass fittings so I need a manual part entry. I can't have the report show a upc number. So I need to have a way for the database to take the upc and switch to show the part # it is related to. I can get the system to work fine and show the repor that I want. The only problem I have is I can't get it to switch the upc to the part #. I was wondering if some one could take a look at what I have done and inform me on what I could do. I am not looking for someone to do it for me. Just give me some guiding information. I wanted to say thank you in advance for any information you can supply.

Inventory 2.fmp12

Link to comment
Share on other sites

Which type of system are you entering the info into?  Maybe it can be scripted?

Are all entries into your system currently done manually?

Can a part have more then one UPC?  If not, it shouldn't be on a separate table, but should be an attribute of the product, as well as the part number.

Link to comment
Share on other sites

This topic is 1881 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By HOnza
      [FOR IMMEDIATE RELEASE]
      24U releases Gonector 2.0 for Claris FileMaker
      This new version of the mobile hardware integration plug-in doubles the number of supported devices with new barcode and RFID scanners and more
       
      Prague, CZ -- May 4, 2020 -- 24U Software announces immediate availability of Gonector 2.0, the plug-in that enables custom FileMaker apps running on iPhone or iPad to seamlessly integrate with professional mobile hardware devices. such as digital scales, RFID readers and mobile printers. The new version adds support for industrial barcode scanners from Zebra, handheld RAIN UHF RFID readers with circular polarization CANE skID and Alien ALR-S350, and the DPP line of mobile receipt/label printers from Infinite Peripherals. It also extends the existing functionality by allowing for writing to NFC tags on iPhone with no additional hardware and triggering FileMaker scripts by pressing the programmable hardware button available on some sled readers from Infinite Peripherals, such as Infinea X.
       
      Version 2.0 brings:
      Support for Infinite Peripherals DPP receipt/label printers Support for CAEN skID, a new high-performance RAIN/UHF RFID reader Support for Alien ALR-S350 hand-held RAIN/UHF RFID reader Support for Zebra CS4070 and DS3678 barcode scanners Additional Zebra scanners may be compatible but have not been tested Extended CAEN RFID readers support by enabling user memory reading and writing Extended iPhone built-in NFC reader support to enable NFC tag writing Extended Infinea X support to allow for triggering scripts with programmable buttons Added possibility to control visual, audible and haptic feedback of capable readers Improved cadence of script triggers for scales, RFID readers Compatibility with FileMaker iOS App SDK 19  
      About Gonector
      Gonector is a FileMaker plug-in that allows a native application for iPhone or iPad, built using the FileMaker iOS App SDK, to communicate directly with mobile hardware devices. Being able to interact with professional mobile devices enables developers to use the FileMaker platform to create POS, inventory and other heavy-duty mobile business apps with friendly, fast, and reliable user interface.
      The first version of Gonector was released in July 2018. It has enabled custom apps, such as JOGS, to replace manual work with modern technologies, such as RFID and digital scales, without compromising the ease of use and development efficiency provided by the Claris FileMaker platform.
      Duncan McDavid, CEO of Jacoma Estates said about JOGS and its use of Gonector: "The product we received from 24U has been helpful for us because it's given us a competitive edge over some of our suppliers. We've got a much quicker system in terms of procurement products and a much more transparent system... It's cut out a lot of inefficiencies both through removal of paper paperwork and paper-based processing but we're also able to do a lot more transactions now so our return on investment into the system has been very good."
      The JOGS application combines digital scales, RFID and mobile receipt printers to bring modern technologies to one of the poorest countries in Africa. But Gonector can be used even for more than just the devices it explicitly supports. With its function, designed for reading weight from digital scales, Alan Meinhart from Three Z Printing also successfully used Gonector to read data from a specialized sensor in order to accurately measure paper consumption during print jobs.
      Since plug-ins cannot be added to FileMaker Go, adding these features to a mobile FileMaker app requires the use of the FileMaker iOS App SDK. This can be significantly simplified to just a few clicks by using the 24U's Xgode service. With this service, adding the Gonector to the app is a matter of clicking a checkbox and selecting the devices to enable.
       
      Requirements
      For development, Gonector 2.0 requires any Mac running macOS 10.12 or later and FileMaker Pro 16 or later, or an x86 PC running Windows 7 or later and FileMaker Pro 16 or later.
      macOS 10.14.6 or later and Xcode with Swift version 5 is necessary for building the iOS and iPadOS apps containing Gonector 2.0. Alternatively, the 24U's Xgode online service can be used.
      Apps built with Gonector 2.0 can be installed on iOS 13.1 or newer.
       
      Availability and Pricing
      Gonector 2.0 is immediately available for download free of charge as a fully functional 14-days trial version. Development dummy plug-in does not require activation, iOS version embedded into an app can be activated with a license that is tight to specific bundle ID of the app.
      Licenses for Gonector start at US$499 per year for app deployed to up to 20 users.
      License for Payment Terminals Edition of Gonector is available for US$7999 and includes implementation support for one type of payment terminal.
       
      More information about the new version: https://24usw.com/gon2wf
      More information about Gonector: https://24usoftware.com/gonector
      Download: https://24usoftware.com/gonector#download
      Buy: https://24uSoftware.com/gonector#buy
       
       
      About 24U Software
      With customers in 76 countries and 30 years of experience with the Claris FileMaker platform, 24U excels in developing new or taking care of existing custom desktop, web and mobile apps, optimizing their performance, identifying and resolving potential issues and liabilities, improving reliability, stability and scalability, integrating them with other systems including various hardware devices, and extending them beyond expectation.
      As a Claris Platinum Partner, 24U helps global businesses around the world to maintain sustainable growth by working with their in-house developers or completely taking care of the maintenance and development of their business solutions.
       
      Customer contact:
      HOnza Koudelka
      Software Division Manager, 24U s.r.o.
      [email protected]
      http://www.24usoftware.com
       
      Press Contact:
      [email protected]
       
      ###
       
      (c)2021 24U s.r.o. All rights reserved. 24U and 24U Software are trademarks of 24U s.r.o. Claris and FileMaker area trademarks of Claris International, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.
    • By naio
      I designed a FM Go app that uses a bluetooth scanner (Socket CHS 7). I can't find the way to control the active keyboard (scanner or ios). I tried the "Enable touch keyboard" script step but if I hide the keyboard, I loose the focus on the field that must get the scanned code, so it's like having no keyboard. That seems to be the problem: https://community.filemaker.com/thread/136708 a bug not fixed yet?
      So far the only way to hide the ios keyboard without loosing field focus is to turn off the ios keyboard is from the scanner itself, clicking twice the power button. Once the active keyboard is the scanner, I still have the edit bar that shows on the top of the ios keyboard covering the bottom of my FM Go app:
       

       
      Do you know if there's a way to hide this bar?

       
    • By Mc128k
      Hey all, this time I created two functions that generate a BMP file with a code-128 barcode. It's more complicated, despite being shorter than the previous (EAN13), and it also has to generate a variable-length BMP file. There are some hacks, like the generation of a little-endian number for the BMP header, but overall it seems stable.
      I tried uploading it to Brian Dunning's website but it didn't give me the link. I'll post it here, and if there are problems, please PM me.
       
      /** * ===================================== * BarcodeCode128B_BMP_380px ( string ) * * PURPOSE: * Generate a binary BMP file containing a Code-128 Type B barcode * * NOTE: * Embed the contents in a container to see it. Valid for UP TO 20 CHARACTERS * * RETURNS: * Binary BMP. * * PARAMETERS: * string: The string to encode in Code-128 * * DEPENDENCIES: * BarcodeCode128B_Raw * * RELEASE: * 2017-06-15 * * VERSION: 1.0 * * AUTHOR: © 2017 Mc128k - http://www.mc128k.com * ===================================== */ Let ( [ ~binary=BarcodeCode128B_Raw(string); ~size=Length(~binary) * 4 // size increased by (4 pixels wide) * (11 chars) * n = 44 ] ; Let ( [ _foreground_color = Substitute ( "1111" ; "1" ; "AAAA" ) ; // set to black _background_color = Substitute ( "1111" ; "1" ; "////" ) ; // white _base =Base64Encode ( HexDecode ( // BMP header "42 4D " & // File size (fake) "10 27 00 00 00 00 00 00 36 00 00 00 28 00 00 00 " & // Image size (bad solution but effective, creating little-endian values with functions is hard) // MAXIMUM 20 CHARACTERS Case ( ~size=220 ; "DC 00 00 00"; ~size=264 ; "08 01 00 00"; ~size=308 ; "34 01 00 00"; ~size=352 ; "60 01 00 00"; ~size=396 ; "8C 01 00 00"; ~size=440 ; "B8 01 00 00"; ~size=484 ; "E4 01 00 00"; ~size=528 ; "10 02 00 00"; ~size=572 ; "3C 02 00 00"; ~size=616 ; "68 02 00 00"; ~size=660 ; "94 02 00 00"; ~size=704 ; "C0 02 00 00"; ~size=748 ; "EC 02 00 00"; ~size=792 ; "18 03 00 00"; ~size=836 ; "44 03 00 00"; ~size=880 ; "70 03 00 00"; ~size=924 ; "9C 03 00 00"; ~size=968 ; "C8 03 00 00"; ~size=1012 ; "F4 03 00 00"; ~size=1056 ; "20 04 00 00"; ~size=1100 ; "4C 04 00 00"; ~size=1144 ; "78 04 00 00"; ) & " " & // Other BMP stuff "01 00 00 00 01 00 18 00 00 00 00 00 76 04 00 00 12 0B 00 00 12 0B 00 00 00 00 00 00 00 00 00 00" ; "barcode.bmp" )) // Base64, Hex ; _map = Substitute ( ~binary ; "0" ; _background_color ); _map = Substitute ( _map; "1" ; _foreground_color ); _map = _map & "////" ] ; If ( ~size > 1144 ; "error" ; Base64Decode ( _base & _map ; "barcode.bmp" ) ) ) ) /** * ===================================== * BarcodeCode128B_Raw ( input ) * * PURPOSE: * Generates the binary number for the Code-128 Type B barcode * * RETURNS: * A binary number representing the barcode * * PARAMETERS: * input: the string to encode * * DEPENDENCIES: * ForEach, Repeat * * RELEASE: * 2017-06-15 * * REFERENCES: * https://en.wikipedia.org/wiki/Code_128 * * VERSION: 1.0 * * AUTHOR: © 2017 Mc128k - http://www.mc128k.com * ===================================== */ Let ( [ ~code=Filter ( input ; "!\"#$%&'()*+,-./0123456789:;<=>[email protected][\]^_`abcdefghijklmnopqrstuvwxyz{|}~" ); /** * Behold, all 108 symbols of Code-128. Use GetValue() to pick the desired one. * * Bar weights are specified by the number of black or white consecutive bars * For example a weight of "212222" means that the code will be "11011001100" * where the first "2" means that there will be two "1" bits, and the next * "1" will tell that there will be one "0" bit * * Type B, keep +1 as it allows C-style array numbers, 32 shifts the ASCII value to the array position */ $code128_sym="212222¶222122¶222221¶121223¶121322¶131222¶122213¶122312¶132212¶221213¶221312¶231212¶112232¶122132¶122231¶113222¶123122¶123221¶223211¶221132¶221231¶213212¶223112¶312131¶311222¶321122¶321221¶312212¶322112¶322211¶212123¶212321¶232121¶111323¶131123¶131321¶112313¶132113¶132311¶211313¶231113¶231311¶112133¶112331¶132131¶113123¶113321¶133121¶313121¶211331¶231131¶213113¶213311¶213131¶311123¶311321¶331121¶312113¶312311¶332111¶314111¶221411¶431111¶111224¶111422¶121124¶121421¶141122¶141221¶112214¶112412¶122114¶122411¶142112¶142211¶241211¶221114¶413111¶241112¶134111¶111242¶121142¶121241¶114212¶124112¶124211¶411212¶421112¶421211¶212141¶214121¶412121¶111143¶111341¶131141¶114113¶114311¶411113¶411311¶113141¶114131¶311141¶411131¶211412¶211214¶211232¶2331112¶" ]; /** * Zones: * * Quiet zone * Start symbol * Encoded data * Check symbol * Stop symbol & final bar * Quiet zone */ // Quiet zone (10x) "0000000000" & // Start symbol Substitute ( ForEach ( StringToList ( GetValue ( $code128_sym ; 104 +1) ) ; "If ( Mod ( $~i ; 2 ) = 1 ; Repeat ( \"1\" ; ~n ) ; Repeat ( \"0\" ; ~n ) ) " ) ; "¶" ; Null ) & // Encoded data - Substitute string with symbols, symbols with binary. Evaluation hell incoming Evaluate (Substitute ( ForEach ( // substitute rows with calculations that return binary code. Should look like this: // Substitute ( ForEach ( StringToList ( "311321" ) ; "If ( Mod ( $~i ; 2 ) = 1 ; Repeat ( \"1\" ; ~n ) ; Repeat ( \"0\" ; ~n ) ) " ) ; "¶" ; Null ) ForEach ( StringToList ( ~code ) ; "GetValue ( $code128_sym ; code ( ~n ) +1 -32 )" ); // "abc" -> 121124¶121421¶141122 " \"Substitute ( ForEach ( StringToList ( \\\"\" & ~n & \"\\\" ) ; \\\"If ( Mod ( $~i ; 2 ) = 1 ; Repeat ( \\\\\\\"1\\\\\\\" ; ~n ) ; Repeat ( \\\\\\\"0\\\\\\\" ; ~n ) ) \\\" ) ; \\\"\\\¶\\\" ; Null )\" " ) ; "¶" ; " & ")) & // Checksum Let ( ~checksum = Evaluate( "Mod(104+" & Substitute ( ForEach ( StringToList ( ~code ) ; "(Code ( ~n ) - 32) * $~i" ) ; "¶" ; "+") & "; 103)"); Substitute ( ForEach ( StringToList ( GetValue ( $code128_sym ; ~checksum +1) ) ; "If ( Mod ( $~i ; 2 ) = 1 ; Repeat ( \"1\" ; ~n ) ; Repeat ( \"0\" ; ~n ) ) " ) ; "¶" ; Null ) ) & // Stop symbol Substitute ( ForEach ( StringToList ( GetValue ( $code128_sym ; 106 +1) ) ; "If ( Mod ( $~i ; 2 ) = 1 ; Repeat ( \"1\" ; ~n ) ; Repeat ( \"0\" ; ~n ) ) " ) ; "¶" ; Null ) & // Quiet zone (10x) "0000000000" ) // End Let /** * ===================================== * Repeat ( text ; times ) * * PURPOSE: * Just repeat a string many times * * RETURNS: * A string * * PARAMETERS: * text: The text to be repeated * times: How many times to repeat it * * RELEASE: * 2017-06-11 * * VERSION: 1.0 * * AUTHOR: © 2017 Mc128k * ===================================== */ If (times > 0 ; text & If ( times > 1 ; Repeat ( text ; times - 1) ; "") ; "" ) /** * ===================================== * ForEach ( valueList ; expression ) * * PURPOSE: * ForEach repeatedly applies a calculation to each value in a ¶-delimited * list. For each value in valueList, evaluates expression, substituting * the value for each "~n" in expression. Expressions may also reference * the value index (line number) being evaluated with "$~i". This is * analogous to Map functionality in functional programming languages. * * NOTE: * This is the recursive version of this function. It is slower, but * capable of processing larger lists. * * RETURNS: * A ¶-delimited list of the results of evaluating expression on valueList. * * EXAMPLE: * ForEach ( * List ( "1 One" ; "2 Two" ; "3 Three" ); * "Left ( ~n ; 1 ) + $~i" * ) // = "2¶4¶6" * * PARAMETERS: * valueList: A ¶-delimited list of inputs to expression * expression: A calculation to evaluate * * DEPENDENCIES: none * * RELEASE: 2012-01-06 * * REFERENCES: * http://en.wikipedia.org/wiki/Map_(higher-order_function) * ===================================== */ Case ( /* Step 0, initialize routine */ not $~map.step; Let ( [ $~map.valueCount = ValueCount ( valueList ); $~map.step = 1 ]; ForEach ( valueList ; expression ) ); /* Step 1, evaluate expression */ $~map.step = 1; Let ( [ $~i = $~i + 1; ~value = Evaluate ( "Let ( ~n = " & Quote ( GetValue ( valueList ; $~i ) ) & " ; " & expression & " )" ); $~map.resultList = If ( $~i > 1 ; $~map.resultList & ¶ ) & ~value; $~map.step = If ( $~i < $~map.valueCount; $~map.step; /* Else */ $~map.step + 1 ) ]; ForEach ( valueList ; expression ) ); /* Step 2, clean-up and return result */ $~map.step = 2; Let ( [ ~resultList = $~map.resultList; // Purge variables $~i = ""; $~map.resultList = ""; $~map.step = ""; $~map.valueCount = "" ]; ~resultList ) ) /** * ===================================== * Null * * PURPOSE: * Mark in a readable way an empty string (for parameters and stuff) * * RETURNS: * "" * * EXAMPLE: * If ( PatternCount ( Table::fieldName ; Tab & Tab ) ≥ 1; * "Awesome use of indentation!"; * Null * ); * * RELEASE: * 2017-06-11 * * REFERENCES: * http://filemakerstandards.org/pages/viewpage.action?pageId=557129 * * VERSION: 1.0 * * AUTHOR: © 2017 Mc128k * ===================================== */ ""  
      Code128B.fmp12
    • By 34South
      I developed a solution which utilises the barcode reader function. This worked perfectly in FMGo 14 on an iPhone 6 Plus. I upgraded to FMGo 15 but at the same time made a few programming changes, although not to the script containing the 'Insert from Device function'. On activating the script, the camera would activate and the barcode would be read successfully but, on a later occasion, the camera would activate, but not trigger on the same barcode as before and the camera would remain in scan mode unless cancelled. Thinking this was due to the changes I made, I spent hours trying to overcome the problem. Eventually, I deleted FMGo 15 and downloaded it again. It worked. However, the problem resurfaced. When it does, quitting the app restores the functionality. The 'Insert from Device' step I have scripted writes to a global field which I have placed off the layout. Again, sometimes it works, other times not, even when activated from the same layout using the same script. Could this be a bug in FMGo 15? Also, sometimes when clicking on an image in a container field, instead of going to the app extensions, FMGo 15 quits. Relaunching, on the same layout and photo, it works as expected. Again a bug?
    • By Budi Hananto Seto
      i have a script to find and add barcode if not available, but, the problem is, it is not automatically add new barcode, if the find result is not available, any suggestion about this script?
      i want to to find barcode through iphone camera, if not available, it will automatically add the new barcode. thank you
       
       
      script.tiff
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.