Dynamics Sl Integration S’abonner

0
Avatar
Legacy Poster

Hello Everybody,
                          I want some information regarding Integration with BarTender. I am using Microsoft Dynamics SL(ERP) and I want to  print labels using BarTender. So, I need help that how can i integrate Microsoft Dynamics SL with BarTender and how can I import data from external application(Dynamics SL). Is there any manual or video  available to explain the integration process. Please Kindly post if any. Thanks in advance. 

8 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

There are a few for Dynamics AX, but I am not aware of any for Dynamics SL.

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

As you might imagine there are many systems out there of various types so we don't have materials giving a specific "how to" on each and every one of them.  The exception there being for the likes of Oracle and SAP.  Certainly the are a number of ways in which you could integrate BarTender with Microsoft Dynamics SL(ERP), I suggest you take a look at the below white papers and decide on which makes the most sense for yourselves.  As a default start position, I'd be minded to make use of the Integrations Platform in BarTender 2016.

 

http://www.seagullscientific.com/media/101563/bartender-integration-methods-201511.pdf

 

http://www.seagullscientific.com/media/101724/bartender-integration-builder-201511.pdf

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Great Thanks for the replies..And Ian C, I got some ideas from your answer,thank you!

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Is there any way to import data from "txt" file into Labels. As I want to print data from my text file into labels, So is there any possibilities to do that?

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

Does the text file contain record data with fields, like what you get in a CSV file, or do you want to data source the text, as is, in the text file to print directly in the label using a single text object.  BarTender can of course do either.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Is there any document or pdf  available for file integration. please post if there any files.

 

I referred the following pdf:

file:///C:/Users/BLP0028/Downloads/BarTender%202016%20(Build%20a%20GET%20Web%20Service%20Integration).pdf

 

This gives the clear details about Web Service Integration.

 

Likewise kindly post pdf for file integration so that it will help me a lot.

Thanks

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

For a simple POSTed data example that uses CSV data as the payload, its not so dissimilar to the GET example.  However, as we're POSTing data the parameters will not be used, and thus the custom variables in the integration are not needed.  For the first action select the "Transform Text to Record Set", which as the name suggests, transforms the payload data into a BarTender record set object that the document you wish to print can be connected to,  Click the "Database Setup" button in this action to connect to a sample file of the same field structure as will be used at print time.  Make sure your BarTender document has database data sources defined, with the name of the field it is to connect to.

 

Note the payload content of POSTed data is set to the "%EventData% integration variable, so therefore the input of the transform action will make use of the variable, but likewise, the output will be to the integration variable %EventData% although it can be different if you want.

 

Your next action can be a Print Document action, and here you need to make sure you set the "Database Overrides" so that the variable %EventData% is selected.  I think in this case, "Integration Input Data" will also do the trick.  Note that the field values can also be referenced in the action, so for example if you have a field in the CSV titled "fldPrinterName", then you could make use of the contained value via the %fldPrinterName% integration variable to set the printer that you wish to use for the print job.

0
Avatar
Steve Wierenga
Actions pour les commentaires Permalien

We use Bartender Automation with Dynamics SL and have found it to work well.  The basic process is to create your labels linked to a stored procedure.  You can then customize any screen with a custom button and use the bartender command line to print a label linked to a record. 

 

Here is a script I use to print Packing and Item labels from a button on the Shippers Screen.  As you can see, I used a users field in the soshipaddress table to further customize the labeling options. We have a default label and the option to create custom labels for Customers or Ship Addresses. The Ship Address screen has an option to select a label type. You are welcome to contact me for more information about this implementation.

Private Sub BTLabels_Click()
Dim CmdLine As String
Dim Path As String
Dim SqlStmt1 As String


'Check the Status of the Shipper
If Trim(sivMyApp.Controls("cshipperid_0")) <> "<NEW>" And Trim(sivMyApp.Controls("cstatus_0")) <> "Closed" Then
'Set the Default Path
Path = "M:\Bartender Labels\"

'If the Ship to Type is Customer, lookup the ShiptoID for the type of label to print
If Trim(sivMyApp.Controls("cshiptotype_0")) = "Customer" Then
SqlStmt1 = "Select * from SOAddress where CustID = " + SParm(Trim(sivMyApp.Controls("cshipcustid_0"))) + " and ShiptoID = " + SParm(Trim(sivMyApp.Controls("cshiptoid_0")))

'Retreive the Customer NoteID
Call sql(c1, SqlStmt1)
serr1 = SFetch1(c1, bSOAddress, LenB(bSOAddress))
Call SqlFree(c1)

If serr1 <> NOTFOUND Then
Select Case Trim(bSOAddress.User5)
Case "CUSTID"
Path = "M:\Bartender Labels\" & Trim(sivMyApp.Controls("cshipcustid_0")) & "\"
GoTo PrintLabels
Case "SHIPTOID"
Path = "M:\Bartender Labels\" & Trim(sivMyApp.Controls("cshipcustid_0")) & "\" & Trim(sivMyApp.Controls("cshiptoid_0")) & "\"
GoTo PrintLabels
Case "AJACS"
GoTo PrintLabels
Case Else
GoTo PrintLabels
End Select

Else
GoTo PrintLabels
End If



Else
GoTo PrintLabels
End If


Else
serr1 = MsgBox(Trim(sivMyApp.Controls("cshipperid_0")) & " is closed or not available for printing labels", vbOKOnly + vbExclamation, "Error")
GoTo LastLine
End If

PrintLabels:
'Print Ajacs Packing; Label
CmdLine = "C:\Program Files\Seagull\BarTender Suite\bartend.exe /F=" & Chr(34) & Path & "Package.btw" & Chr(34) & " /P /?ShipperID=" & Chr(34) & Trim(sivMyApp.Controls("cshipperid_0")) & Chr(34)
serr1 = Launch(CmdLine, False, False, 0)

'Print Ajacs Item Labels
CmdLine = "C:\Program Files\Seagull\BarTender Suite\bartend.exe /F=" & Chr(34) & Path & "Item.btw" & Chr(34) & " /P /?ShipperID=" & Chr(34) & Trim(sivMyApp.Controls("cshipperid_0")) & Chr(34)
serr1 = Launch(CmdLine, False, False, 0)

LastLine:
End Sub

Vous devez vous connecter pour laisser un commentaire.