Serialization with a database connected number

Alexandre Dubois

• 2016年09月27日 16:12

Good afternoon,

I am Alexandre from Belgium and I have been using Bartender only for a couple of weeks. I have tried hard to make it this way...

I request your help for the serialization of a number connected to a excel database which I want to serialize.

I connect the bartender to an excel file in Vbscript with “On new record” to raise the number by “3” and “on process data” to update the number in yellow above.

The number In yellow above is updated “on process data” after the user chose the number of material through an application form.

I want to print out 3 labels two times but with a serialization.

It’s not going well. The serialization takes the number in yellow, already written down when opening the file and then serialize. It doesn’t take the number taken in the excel file at first for serializing it.

My request for help to you: how can I force Bartender through Vbscript or else to take in an excel file and serialize from this number?

Attached are the files, just for you to understand and see the code if you wish.

Thanks a lot… I am really stuck here…

Have a nice evening!

Alexandre

0

• 

  Alexandre Dubois

  ★ BarTender Hero ★

  • 2016年09月27日 16:18

  Oups! The links for the files:

  For the bartender file:

  https://5nplusinc-my.sharepoint.com/personal/alexandre_dubois_5nplus_com/_layouts/15/guestaccess.aspx?guestaccesstoken=R%2fAveQiYSvE5ybt9vVDaD44kMuHB5T%2b5zZ8EZhyK9Zs%3d&docid=11099e2d4b5a347a0a419e829a7df04a1&rev=1

   

  For the excel file:

  https://5nplusinc-my.sharepoint.com/personal/alexandre_dubois_5nplus_com/_layouts/15/guestaccess.aspx?guestaccesstoken=FFvG7KlJhJuA9KbH7OldYU7n9H81u15SMwAo%2bMMfN2Y%3d&docid=166974a2ba8ed4263a031cda6cdd3ec30&rev=1

   

  Thank you!

  0
• 

  Brandon Morrisey

  ★ BarTender Hero ★

  • 2016年11月21日 19:35

  I think you can use the built in serialization features of BarTender to handle the serialization in this situation, this can be found in the transforms section for the properties of the data source next to the VB script transforms in newer versions of BarTender.

  0

サインインしてコメントを残してください。