# Bartender Integration Builder and Epicor... looking for consultant **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [September 1, 2021, 2:01pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156 "2021-09-01T14:01:51Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [September 1, 2021, 2:01pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/1 "2021-09-01T14:01:52Z")
Hello All, I forget whether it is allowed on here to ask about consultants, I know you aren’t supposed to come on here as a consultant and promote services, but I think I can ask? Looking for any recommendations on consultants that have successfully built and coded an integration with bartender’s integration builder. Thanks in advance everyone! -Utah ---
**Author:** ![zachg](https://www.epiusers.help/user_avatar/www.epiusers.help/zachg/32/89129_2.png) [@zachg](https://www.epiusers.help/u/zachg)\ **Post date:** [September 1, 2021, 3:35pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/2 "2021-09-01T15:35:20Z")
Are you limited from using the FileMonitor service? The integration path for this method is extremely simple (csv output essentially) ---
**Author:** ![TomAlexander](https://www.epiusers.help/user_avatar/www.epiusers.help/tomalexander/32/98890_2.png) [@TomAlexander](https://www.epiusers.help/u/TomAlexander)\ **Post date:** [September 1, 2021, 3:42pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/3 "2021-09-01T15:42:50Z")
Hi Utah, Yeah, I try not to advertise on here as a consultant but if you want to DM me I’d be happy to discuss… Adding to what Zach said, the BarTender side of things is usually the simple part of an integration. It’s designing the processes, what labels need to print and how they are triggered from Epicor that tends to be the hard part… ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [September 1, 2021, 3:59pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/4 "2021-09-01T15:59:30Z")
We need to print a label that has a query to the database. We will not have all the data up front. ---
**Author:** ![TomAlexander](https://www.epiusers.help/user_avatar/www.epiusers.help/tomalexander/32/98890_2.png) [@TomAlexander](https://www.epiusers.help/u/TomAlexander)\ **Post date:** [September 1, 2021, 4:17pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/5 "2021-09-01T16:17:59Z")
Sounds interesting. There’s a ton of different ways to go about label printing, but if you use a BPM, Customization, Function, etc. from Epicor that builds and sends a file to BarTender then you can query the Db all you want in order to send BT the dataset it needs. ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [September 1, 2021, 4:23pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/6 "2021-09-01T16:23:24Z")
okay cool, we are using customizations to do this on the UI via a button click at the moment, but we aren’t using bartender integration, we are using a direct method where we call the bartender.exe and we send the label file we want to print along with the following parameters: PackNumber & PackLine **or** JobNumber, and number of copies). So in short, we just need to write this stuff to a file instead and the bartender integration can take care of the rest by reading the file? -Utah ---
**Author:** ![zachg](https://www.epiusers.help/user_avatar/www.epiusers.help/zachg/32/89129_2.png) [@zachg](https://www.epiusers.help/u/zachg)\ **Post date:** [September 1, 2021, 5:21pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/7 "2021-09-01T17:21:16Z")
Epicor’s default implementation uses the file writing method. Create an Integration in the Integration Builder, setup with a simple Print Command Script action. There is also the File Detection settings, but those are self explanatory. ![image](https://www.epiusers.help/uploads/default/original/3X/7/c/7c15a316f70dd9af7c9ae8f1b12a4949ce5b914c.png) Your command script would look something like this: ``` %BTW% /AF="c:\PhysicalPath\To\Labels\OnBTServer\MyLabel.btw" /D="" /C=1 /PRN="(Your Printer Path Here)" /P %END% "PONumber","PartNumber","OutDescription","Operator","Qty","PartDescription" "226735","0021-13575","COMP","EpicorUser","60.00000000","Black anodize per MIL-8625 Type 2 Class 2" ``` (Trigger File Name is intentional, printer path is not) Create a BPM to write this data. Columns are defined once, each newline is a new row. ---
**Author:** ![TomAlexander](https://www.epiusers.help/user_avatar/www.epiusers.help/tomalexander/32/98890_2.png) [@TomAlexander](https://www.epiusers.help/u/TomAlexander)\ **Post date:** [September 1, 2021, 5:26pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/8 "2021-09-01T17:26:55Z")
yeah, so BT Integration Builder replaces a “middleware” application called Commander. Commander more or less watches a folder for a file, reads it and works with BT to actually print something. So if you use epicor to push a file it would need to have the BT label template name, printer name, number of copies, and the actual dataset for the label (probably some other stuff too that I don’t remember off the top of my head). So it’s not really an “integration” per se, it’s more like how SSRS works. Integration Builder has more bells and whistles than Commander, but you can use the file method to make it work like Commander if you want to take that approach. I think you can have BT Integration Builder actually touch the epicor Db but I’m not sure I’d recommend that. It can also do web service integrations now, which will probably become the preferred option down the road. ---
**Author:** ![Doug.C](https://www.epiusers.help/user_avatar/www.epiusers.help/doug.c/32/26714_2.png) [@Doug.C](https://www.epiusers.help/u/Doug.C)\ **Post date:** [September 1, 2021, 6:11pm UTC](https://www.epiusers.help/t/bartender-integration-builder-and-epicor-looking-for-consultant/82156/9 "2021-09-01T18:11:03Z")
> [@TomAlexander](#): > > Sounds interesting. There’s a ton of different ways to go about label printing, but if you use a BPM, Customization, Function, etc. from Epicor that builds and sends a file to BarTender then you can query the Db all you want in order to send BT the dataset it needs I just went in and rewrote our Bartender functions. Now that we’re on Kinetic, I was able to really streamline our processes because we can call functions within the same library. Now when I need to do a new one, it’s really as simple as setting up the template. In fact (for me at least) it takes longer to design the actual label than it does to set the system up to spit out the data which the integration uses…