Need help exporting data from around 1800 "btw" files! S’abonner

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 commentaires

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

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
Actions pour les commentaires Permalien

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.

Vous devez vous connecter pour laisser un commentaire.