|
Excel Macro to import/export Tags easily - Printable Version +- Ewon Technical Forum (https://techforum.ewon.biz) +-- Forum: Development (https://techforum.ewon.biz/forum-50.html) +--- Forum: Ewon Embedded Technology (https://techforum.ewon.biz/forum-51.html) +---- Forum: Ewon Core Features (https://techforum.ewon.biz/forum-3.html) +---- Thread: Excel Macro to import/export Tags easily (/thread-1546.html) |
Excel Macro to import/export Tags easily - simon - 20-10-2020 Hi Guys, Here is an Excel Macro that allows you to import/export the Ewon Flexy Tag list without having regional settings issues. Simon RE: Excel Macro to import/export Tags easily - ziozetti - 03-06-2021 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? RE: Excel Macro to import/export Tags easily - simon - 04-06-2021 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 RE: Excel Macro to import/export Tags easily - ziozetti - 04-06-2021 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. RE: Excel Macro to import/export Tags easily - ziozetti - 23-08-2021 (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. RE: Excel Macro to import/export Tags easily - helmersamba1@gmail.com - 10-08-2022 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 RE: Excel Macro to import/export Tags easily - simon - 11-08-2022 Hello, I am not sure to understand... Do you want to restore historical data to your Ewon ? Are you talking about the Talk2M Datamailbox ? RE: Excel Macro to import/export Tags easily - helmersamba1@gmail.com - 11-08-2022 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 want to zero all my historical Tag. what can I do? RE: Excel Macro to import/export Tags easily - simon - 12-08-2022 If you want to erase your historical data, then you can do from the menu Setup > System > storage > Erase and Format. RE: Excel Macro to import/export Tags easily - helmersamba1@gmail.com - 12-08-2022 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. RE: Excel Macro to import/export Tags easily - simon - 12-08-2022 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 RE: Excel Macro to import/export Tags easily - helmersamba1@gmail.com - 12-08-2022 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 ?The clean method will also erase my configuration, which is what I avoid. I might try the delete method |