exporting from data entry to excel Follow

1
Avatar
Ilya Ilya

Greetings everyone!

Im just started to work with Bartender, and im wondering if its possible to export serial number from "Data entry" to Excel file?

For example: 

Im scanning a product SN to data entry to print a sticker. Is it possible, that numbers from data enrty automatically goes to Excel file?

 

4 comments

0
Avatar
Pete Thane
Comment actions Permalink

You will probably need to configure an Action from your Data Entry form to Update Database Record when you print the label:

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

Greetings Ilya!

Welcome to the BarTender Community! We hope you like it here.

BarTender 2019 introduced a write back to database feature available for BarTender Automation or Enterprise editions as it uses our Integration Builder companion app. Writing back to a database is currently also available for BarTender 2021. However, this feature is not available in BarTender 2019/2021 Professional editions and can't be used on Excel Spreadsheets as they are not a proper database per se, we would need to use an SQL database or similar in order to use this feature.

I would recommend reviewing this Webinar on Form and Document Actions as it goes into detail on how to achieve this.

In case using an SQL database is out of the question, another option would be to use our Global Data Fields. These will allow us to share values between different document designs. These fields are stored in our BarTender System Database and can be accessed from any other document or BarTender client connecting to it.

Finally, if the above options don't meet our needs, we can always define a VB script in our documents to write back to the desired database.

Let us know if some of these options worked for you!

0
Avatar
Ilya Ilya
Comment actions Permalink

Thank you very much for the answers!

We have BarTender 2019 Professional edition in our production room. 

So if ill use a VB script, will it allow me to write back to an Excel file? If so, is it possible to get the required code, so i can import it to the "script" window?

Thank you very much for your help again! 

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

Hi again Ilya!

You are welcome!

While we don't have an example of writing back to an Excel database using VB script available right at this moment, I've found some Microsoft document which goes in-depth on the subject and could be useful to you:

I would also keep checking online for more guides and examples, as there are quite a few scripts to test out. However, I would recommend going through these scripts beforehand with a professional to make sure they do as advertised and nothing more.

Please sign in to leave a comment.