Insert Database Record

Eduards Gzibovskis

• 27 de noviembre de 2019 15:42

There is a new feature in BarTender 2019 called Process Builder.

 

I am trying to use `Insert Database Record`.

 

What I am intending to do is, create a form on BarTender designer, use them fields to be inserted into SQL.

 

How can I insert a field from barTender field into SQL database?

 

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 28 de noviembre de 2019 10:57

  Not looked into Process Builder in any great detail yet although some of the layout/functionality looks similar to the way you configure Integration Builder which I have used. I see there is an Update Database option in Actions menu so I believe you would need to use that.

  For Integration Builder I found the online tutorials to be very useful and I see there is one for Process to and so this may help

  https://support.seagullscientific.com/hc/en-us/articles/360022771874-Introduction-to-Process-Builder

   

  0
• 

  Eduards Gzibovskis

  ★ BarTender Hero ★

  • 2 de diciembre de 2019 13:57
  • Editado

  Hi,

   

  I have managed to figure it out.

  Within BarTender template, you should have Named Data Sources. Right Click a field > Properties > Set `Name` to anything you'd like, In this scenario we'll call it 'test'.

  Next, load the tool called: `Process builder` > Open/Browse for the BarTender document you have just created > Click Import Document Settings...

  Now, if you click the 'Named Data Sources' tab, it should bring up all the Named Sources from the template.

  Check box - 'Copy data source values to variable at end of print job' > Set prefix to whatever you'd like to, default value is 'BTDS_'

  Now the variable from template is now named in the following format: %BTDS_test%. You may use this as 'Value' within 'Insert Database Record'

  0

Iniciar sesión para dejar un comentario.