i like old stuff wrote:Hi
Because it doesn't support pasting of data from excel other than one cell at a time which isn't suited to my intended use.
If the little hand held was my only scanner I would have used scan 125 but it isn't, I've invested my time in creating a master file in excel and I cannot import that, or parts of that into Scan 125 unless as I say, I'm missing something, which I'll be delighted to be enlightened about.
Cheers
ILOS
Scan125 programs are in fact a suite of TWO programs. Scan125 Control Program and Scan125 Convert Program.
https://nick-bailey.co.uk/scan125convert/index.html Scan125 Convert will process ANY CSV file take the data and convert it to a Scan125 formatted data file which the Scan125 Control Program can then read and load/program the scanner.
I chose to have CSV/excel support outside of the Scan125 Control Program and have a supporting Scan125 Convert Program for a number of reasons:
1) When users asked for Excel and/or CSV support directly reading Excel format files was not going to be that straight forward. However handling CSV files was not going to be as complicated.
2) Spread sheet programs Excel, Open Office, and others all have different internal formats but the can all create CSV files.
3) Implementing CSV file support on a stable Scan125 Control Program release was almost certainly going to cause Scan125 Control Program to go through unnecessary releases and as I'm not a perfect coder then risk of destabilising Scan125 itself would only upset my customers.
4) If other formats/collections of data sources were required then 3) above would still be very relevant.
I suggest you at least give Scan125 Convert a try. It is a far from ideal two step process (Excel -> CSV -> Scan125) but it works and is reliable and can cater for different peoples own spread sheet layouts.
Alternatively you can to what one customer of mine has done. He wrote excel macros to take his excel data and directly create a Scan125 data form file. His excel program used tabs for categories of data and could select a category and target scanner bank etc. He was thinking of releasing/publishing this as a utility for others to use but at the time we last spoke he was very busy on other matters and did not want to publish something that still required extra work to be up to a decent level of quality and robustness he and customers would be proud of.