Text File Field To More Than One Bartender Field 追蹤

0
Avatar
Legacy Poster

I have a topic in the Bartender/VB scripting forum (Type Mismatch Errors) that runs through some issues and ends with this one which hasn't been answered.  I thought I'd try over here to see if anyone can help with this.

 

I have a single field of serial data coming from a scale being saved to a text file by Commander in a folder that is then detected and read by Commander in another task which then prints a label using the text file's single field of data.  The trick is that I need to use that text file data in multiple fields in the Bartender file.  In one field I'm showing just that data, in the others I'm running calculations using that data in vb to derive related field values.

 

The problem is that Commander seems to require that the text file data be set up as a Database field, and it appears that a database field passed from Commander can only be used in a single Bartender label field.  If you try to access that same data source either directly or via a share name, it will not come through to additional fields.

 

The question is: how can I get that single field of data from the text file into multiple bartender label fields?  Or, is there a better way to approach this rather than using a text file to trigger the process?  Looking for any ideas to solve this issue.

 

I can make this all work easily if I use a sample text file and set the Data Source as an External File, but if I set it as a Database Field (as Commander requires for files it detects coming into a folder) then it fails.

 

Thanks for your help.

3 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

You can access the same database field in as many data sources as you wish for as many label objects as you wish.  Just choose "Database" as the source type and then select the field.  There is probably no need to set a name on any particular data source for sharing, as like you say, other data sources might wish to transform the data in slightly different ways.  When referring to the database field in VB script you'd use the syntax: Field("Table.Field",[default value])

 

Example: Field("Products.ArticleNo","ABC123")

0
Avatar
Legacy Poster
評論操作 永久連結

I can now make this print if I have the text file just sitting there and print from Bartender, but the label will not print if I run it through from Commander using the tasks.  The file gets created, is read and renamed, but gets hung there and never reaches the print queue.

 

I ran through the troubleshooting pdf and found that it will print running Commander as an application.  Switching back to service makes it not print again.  None of these files are on network drives, they are all on the user account's desktop so UNC path shouldn't be an issue.  The user account also has administrative privileges on this machine. 

 

 

 

0
Avatar
Ian Cummings
版主
評論操作 永久連結

You're problem is going to be user account permissions for the service.  Make sure the Commander service itself is configured with an account you know to be good for all resources you need to use.  In the Commander handler clear away any login credentials there as you'll be inheriting the permissions from the service.

 

I hear what you say when the user has admin privileges, but this sort of thing ALWAYS turns out to a permissions problem, so you'll need to delve into it.

登入寫評論。