Ewon TechForum
Providing technical solutions to technical requests



Excel Macro to import/export Tags easily
simon Offline
eWON Support
#1
Solved: 18-11-2020, 02:41 AM
Hi Guys,

Here is an Excel Macro that allows you to import/export the Ewon Flexy Tag list without having regional settings issues.

Simon


Attached Files
.zip   eWON TAG GENERATOR REV 6.zip (Size: 41,96 KB / Downloads: 357)
Reply

ziozetti Offline
Senior Member
#2
Hi Simon,
I'm using Tag Generator rev. 7 but sometimes I've issues in sending tags to Flexy.

I downloaded blank Excel fil, imported tags, modified some of them and then sent back to the Flexy but it didn't work and in log I can read:

23304
varld-Import config error at line (Line: XX)
20512
mgio-Coef. is zero

What does mgio-Coef. is zero mean?
Reply

simon Offline
eWON Support
#3
Hello,

I don't think the rev 7 is coming from me.
Did you get it from the hms.how forum ? I think we worked on the same excel file but in //

Simon
Reply

ziozetti Offline
Senior Member
#4
Oops! I thought it was the same team/project and that rev. 7 was an "evolution" of rev. 6. I'll try with your branch, thank you.
Reply

ziozetti Offline
Senior Member
#5
(03-06-2021, 02:09 PM)ziozetti Wrote: What does mgio-Coef. is zero mean?

Yeah, I found the solution!
I don't know if it is only an "italian" problem (but I think it is the same in most of european countries) but something get wrong in coefficient import/export: Flexy expects . (dot) as a decimal separator while generator uses , (comma) as separator.
I changed decimal separator in generator and all tags have been exported correctly. I think it will be the same with all commas used as decimal separator but I've to check.
Reply

helmersamba1@gmail.com Offline
Menber
#6
This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate.

Hello Simon I would like to be able to import directly via the table Tag history is this possible?
I already have my ID developer and my T2MToken

Hello Simon I would like to be able to import directly via the table Tag history is this possible?

I already have my ID developer and my T2MToken
Reply

simon Offline
eWON Support
#7
Hello,

I am not sure to understand...
Do you want to restore historical data to your Ewon ?
Are you talking about the Talk2M Datamailbox ?
Reply

helmersamba1@gmail.com Offline
Menber
#8
This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate.

(11-08-2022, 12:52 PM)simon Wrote: Hello,

I am not sure to understand...
Do you want to restore historical data to your Ewon ?
Are you talking about the Talk2M Datamailbox ?

I want to zero all my historical Tag. what can I do?
Reply

simon Offline
eWON Support
#9
If you want to erase your historical data, then you can do from the menu Setup > System > storage > Erase and Format.
Reply

helmersamba1@gmail.com Offline
Menber
#10
This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate.

(12-08-2022, 09:22 AM)simon Wrote: If you want to erase your historical data, then you can do from the menu Setup > System > storage > Erase and Format.

I  do that but when I try to synchronize my tags in DMWeb file I always get values that are displayed.


Attached Files Thumbnail(s)
   
Reply

simon Offline
eWON Support
#11
Then you perhaps want to clear the data IN the Datamailbox ?
For this you have to call the method "clean" from the DMWebAPI.
You can easily call it using the DMBoxViewer included into the DatamailboxSDK. -> https://developer.ewon.biz/content/dmweb-api
Reply

helmersamba1@gmail.com Offline
Menber
#12
This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate.

(12-08-2022, 10:13 AM)simon Wrote: Then you perhaps want to clear the data IN the Datamailbox ?
For this you have to call the method "clean" from the DMWebAPI.
You can easily call it using the DMBoxViewer included into the DatamailboxSDK. -> https://developer.ewon.biz/content/dmweb-api
The clean method will also erase my configuration, which is what I avoid. I might try the delete method


Attached Files Thumbnail(s)
   
Reply




Possibly Related Threads…
12-08-2025, 10:06 AM
Last Post: EElab
08-08-2023, 12:27 PM
Last Post: ISCStefanS
06-04-2022, 12:21 PM
Last Post: em3v
22-03-2021, 09:55 AM
Last Post: simon
04-03-2021, 02:25 PM
Last Post: antoniopnp
10-08-2020, 09:04 AM
Last Post: Mitchellgr
  Uploading tags to Flexy Started by tomT
0 Replies - 4.995 Views
21-12-2018, 06:59 PM
Last Post: tomT
22-10-2018, 11:55 PM
Last Post: simon
09-05-2018, 10:56 AM
Last Post: simon
02-03-2018, 02:29 PM
Last Post: simon



Users browsing this thread:
2 Guest(s)



Theme © Ewon 2019 - Forum software by © MyBB - Cookie policy