![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. |
#3
| |||
| |||
|
|
Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. Steve- |
#4
| |||
| |||
|
|
Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. |
#5
| |||
| |||
|
|
Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. |
#6
| |||
| |||
|
|
Steve, If I remember correctly, Worthington Data (Sorry- don't have their URL) used to market a hand held barcode gun that was radio controlled. In those days, it came with a base station that had a serial port and would support up to 16 'guns'. There was a screen onto which you could display information - such as menus or input requests or whatever, all controlled by the computer. There was also a special sequence of commands you could use that would allow the user to poll for data from the devices. Thus - each of 16 'guns' could have a different 'data collection' program running and if the person who wrote the 'control program' on Pick was very careful, it could easily interface with each of terminals and track things very well. The last time I checked, today's system might have allowed for as many as 256 terminals/'guns'. The special sequence of commands was nothing more than a series of text data that you printed out the serial port. The programmer writing the program on Pick had to ensure that they maintained the sequence for each 'gun' properly. I used an array dimensioned at 16. It would have to be as big as the number of guns that were in operation. Each message between the serial port and the base station had to identify which 'gun' it was addressed to. Each message from the base station (and thereby from the 'guns') had the guns sequence number attached. That was the key. The program also had to jump through all sorts of hoops trying to figure out if the person was entering the right type of data (there might have been some rudimentary type verification on the 'gun' such as numeric, etc). There was a keypad on top of the 'gun' that allowed for non barcode entered data. I haven't looked at this for years, so I don't know it if would still be possible to write the control program in Pick since I think the newer models might be attached via network. It might be worth a look. Hope this helps. Larry Hazel "Steve Mattson" <smatts_NOSPAM (AT) tampabay (DOT) rr.com> wrote in message news:0ldqf.17765$md.1940 (AT) tornado (DOT) tampabay.rr.com... Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. Steven J Dorst |
#7
| |||
| |||
|
#8
| |||
| |||
|
|
Well I suppose that starting with the fact that you are probably using one of the more difficult versions of multi-value to do the work with. Nevertheless, it should be relatively simple to interface a PC docking station with your mvBASE system - though you will need a third party interface to provide the Pick -> PC interface.. Perhaps Coyote is the product you need... This would allow you to interface the barcode systems with a Pc Program (choose your software of choice, but vb/vb.net/java/whatever - ie *mainstream* tools) which could then interface back to your multi-value database through the third party interface. If you were using D3 - then the middleware you could use would be FlashConnect and/or web services. For jBASE then jrcs or mv.net or similar. etc.. Not sure it helps, but what I'm saying is get access to your data from generic PC development environments and the whole thing is much easier... Symbol for example make a number of "intelligent" bar code systems.. I've also seen others based on palm tops with bar code scanner "cradles".. Regards Simon "Steve Mattson" <smatts_NOSPAM (AT) tampabay (DOT) rr.com> wrote in message news:0ldqf.17765$md.1940 (AT) tornado (DOT) tampabay.rr.com... Hello group, Sorry for the length of this post, but I'm desperate. The Open Systems Database Association (formerly Pick Users of Florida) did not have a meeting this year and I didn't get a chance to talk to vendors or other users. I have e-mailed a couple of officers from their web site, but haven't received any reply. So, I turn to you good folks for help. We are using mvBase, running on a Windows NT system, using Viaduct to connect users via telnet, and networking the printers. We are a manufacturing company that must take inventory every month. We are looking for technology to assist in doing this. I know there are systems that will allow scanning barcode and entering counts, I see them all the time. The trick is to upload the data to the Pick system. I have some experience using a Dynasys 2001 data collection device with a scanner that can read bar code up to 12 feet away (on high shelves). After writing a short program, stored on the device, to make the collection easy for the operator, the trick then was to upload the collected data. In this case we had to run a DOS program to read the data through the serial port on a PC and then use a Pick program to port the data into the Pick system and reformat it to update the database. We used this system for a few years to keep track of cartons of pre-counted inventory. The actual counts were kept in the pick system. We only scanned the box ID numbers and their shelf location ID number in the warehouse. What we want to do with the inventory on the floor is to scan a bar code on a traveler that will identify the specific operation the parts are at as of the inventory. This is important because value is added at each operation through the manufacturing process. (Probably too much information, but I don 't know how much you may need.) After scanning the traveler, the count then needs to be entered, either by a keypad, or by scanning numbers on a sheet. Then the next traveler can be scanned and the next count entered, etc. Finally the data collected must be uploaded to the Pick system, where the existing software can take over the processing. The data collection device must be portable, so it can be taken around the shop. It must be easy to use, so that miscounts can be avoided. It must be relatively inexpensive, because there will be several of them. The upload should be easy to accomplish, because it has to be done for each device used. Thank you in advance. Any assistance you can give will be greatly appreciated. You may email my at smatts at tampabay dot rr dot com, or reply to the group. If you email, be sure to include "bar code" in the subject line, so I can find your email amoung the spam. |
#9
| |||
| |||
|
#10
| |||
| |||
|
|
Thank you all for your responses. I will be reading them and doing a little research while on vacation next week. Have a joyous holliday. Steve |
![]() |
| Thread Tools | |
| Display Modes | |
| |