So I am working on converting and excel process we use for printing out print for the shop to bartender. I have a BAQ that groups and sums up each part number on a job so that they get one print with a total qty for the job.
Here’s the example. The front of the print, I have working just fine.
The back of the print (we print double sided) is going to have a barcode for each job and operation so that they can clock into the applicable operations with a single barcode.
Here is the data, I’ve use the comma delimited to add the multiple values into a single cell.
I need to be able to pull these operations out of that single column into bartender. The order will matter (it has to be in that order) and I would like it to be dynamic so I don’t have to hardcode values into the templates.
I can make a new query where I duplicate rows if I have to to be able to send to bartender utilizing page breaks, but I was going to see if I could use the same data for my template in bartender in order to have a single source so I have redundant systems without have to maintain redundant BAQ’s (or chop it up in the code I’ll use to write out the CSV)
In Bartender, I can make multiple templates that show up on conditions, but I would have to make them hardcoded (I think) and then the order wouldn’t be preserved since it would be basically if field contains x.
Does anyone have any elegant solutions for this? At this point the only options I see are making a new BAQ that duplicates the rows, or duplicating the rows on export from the customization that I will build in the C#.
Are there only a maximum of 2 operations?
If so, use a function to split the data and display the first half in one barcode and the second in another. If you have more operations available, then perform more splits.
Has any of you guys seen this problem? I’m bringing in image files by a file name from the database connection, and now some of my picture files are rotated.
This is changing gears on you, but have you considered using code in a BPM to kick off the data? With C# code and LINQ statements to your data, you can basically make the CSV file look however you want to do it. Basically, move all of your heavy lifting to the custom code, then your Bartender becomes a pretty simple template.
I’ll be getting all of the data from a BAQ. I was going to have rows on the front page but since I couldn’t do that, I have everything on the front page duplicated on each row between page breaks (with tilde delimited fields so I can add carriage breaks) , and everything that goes on the back on the individual rows. The last problem I have to figure out is this rotating issue. Once that’s done, I’ll make a button on a dashboard the calls the BAQ, builds the CSV and drops it into the watch folder. I’ve done that already quite a bit.