Insert Database Record Folgen

0
Avatar
Eduards Gzibovskis

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?

 

 

2 Kommentare

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

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
Avatar
Eduards Gzibovskis
Aktionen für Kommentare Permalink

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'

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.