Need help exporting data from around 1800 "btw" files! Follow

0
Avatar
A Amiri

Hello Community,

My manager has asked me to extract serial numbers from bartender files. I know I like an excel file and read and print data from it but I have no idea  how to extract 1800 product name, codes and serial numbers from individual bartender files.

The only thing that comes to my mind is to do it manually but it will require a lot of time, I want to know if there is any other way I can come up with the task in an easier fashion. 

2 comments

0
Avatar
Pete Thane
Comment actions Permalink

There is not an easy way I can think of. 

Depending on your BarTender version you could enable logging to a Text file and configure it to only include the data fields you want and then print a label which would in turn create a file with this information in too.

Haven't you got the product information in electronic format already in your ERP system that you can extract from there?

0
Avatar
A Amiri
Comment actions Permalink

I have an excel database from around 5 years ago and then the person responsible for barcoding used her chaotic way of changing them to new barcodes/format and saving them in BTW. No ERP system whatsoever.

Here's what I did:
I printed all the BTW files to PDF.

Next step is trying to extract the data and make a new database in excel.

Please sign in to leave a comment.