Include Device ID in File (Content or Name)

[Tom Millington]

Hi. I am a bit of a newbie here so please excuse me if this has been asked before.

I am also not sure if this should be in the Mobile Client forum, or in Desktop or Connect so sending it to all three (also sorry if this breaks any forum rules).

We have a very simple app - it reads barcodes (customer code and item number, and date/time stamp). When all reads are completed, an Excel file is transmitted to a server using TracerPlus Connect.

So far, so good (and working!).

When it gets to the server, an Excel VBA app processes the data, but it needs to know which device it came from.

We need to include the device ID in the filename. It may be possible to include it as an additional field in each data row, but there is a possibility of two files arriving at the same time with the same filename.

One obvious way around this is to have multiple instances of TracerPlus Connect (one for each device, each having its own designated filename) but this would be a pain to maintain.

Any suggestions would be appreciated.

Regards, Tom

 

[Joseph Kraebel]

Hi Tom,

Currently we don't have a way to embed the device ID into the filename but is on our feature request list.

One thing you can do if you sync this to a .txt or .csv file is append a unique date/time stamp or counter to each file synced so you will always have a unique file. This coupled with saving the device ID with each row may be useful for you.

 

[Tom Millington]

Hi Tom,

Currently we don't have a way to embed the device ID into the filename but is on our feature request list.

One thing you can do if you sync this to a .txt or .csv file is append a unique date/time stamp or counter to each file synced so you will always have a unique file. This coupled with saving the device ID with each row may be useful for you.

Hi Joseph

I would love to sync this to a .csv or .txt as they seem to be far more flexible than syncing to a .xls. The problem is that the resultant file has to be read into another Excel workbook using Excel VBA. I am not an Excel specialist and could only seem to get the data in a row to read into a single cell, which just didn't work. Also, how do I save the device ID into a TracerPlus field? I cannot see an option for that?

Many thanks for your reply.

Tom

 

[OliverR]

(...) Also, how do I save the device ID into a TracerPlus field? I cannot see an option for that?

Hi Tom, in your Field Settings set the field type to Variable. Then in the Variable Options tab set the Variable type to Device.

 

[Tom Millington]

Thanks Oliver - that works fine.

I just need to work on how to get the data into Excel using VBA - I have an idea how to do that.