Page 1 of 1
[?]: ifix and archive
Posted: Sat Oct 30, 2010 5:31 pm
by PLC_ITA
Hello collegues. For me is the firt time that i use IFIX . My customer ask to me to create a new HMI whit WCC bat my custome ask to me to save a previous report.
Every day a old HMI ( IFIX ) save a report ( or logger ) into a file named day_month_year.H24
Ifix save in this format ? i need to read this archive to know the field.
If i try to open this file using for example a notepad, i dont read comprensible data
anyone have a idea/suggest for me ?
I can attach a file but i do not how to do !
thank you
Re: ifix and archive
Posted: Sun Oct 31, 2010 8:51 am
by bjing
1. Try to use FIX Dynamics Historical Data ODBC driver. It's providing access to iFix history data from MS Office or any application.
2. Find HTD2CSV utility
Re: ifix and archive
Posted: Sun Oct 31, 2010 4:54 pm
by PLC_ITA
thank you a lot Bjing. i have try to search a HYD2CSV but no found.
Can you suggest to me a link or site where i can find this file ?
thank you again
Re: ifix and archive
Posted: Tue Nov 02, 2010 8:05 am
by bjing
http://www.megaupload.com/?d=UPKF1901
The HTD2CSV tool uses HDA toolkit calls to to dump historical information to a CSV file. This is useful for people who wish to view what is in the historical files from Notepad or Excel, etc.
Included in the ZIP file is a VB project which contains the source code to this tool, an iFIX graphic file and also a readme.rtf file that explains the usage.
There are two ways you can do this. You can use the iFIX graphic (HTD2CSV.grf), or use the the cmd command line.
Re: ifix and archive
Posted: Tue Nov 02, 2010 5:21 pm
by hungbka
Anybody help me>
I've started to learn Ifix to build an application. I've tried the student lab workbook to learn it steo by step.
I can't find the file which name is watertags.csv- the file need to complete my trainning.
Anybody have this file please share it for me.
thanks you very much.
( I've tried google it but nothing to find)
Re: [?]: ifix and archive
Posted: Tue Nov 09, 2010 12:08 am
by PLC_ITA
Hello Bjing , i'm sorry for my new question. I have download the HTD2CSV.
I have spend 3-4 days to try this application, bat the result are always the same.
I have ??? instead a data.
My H24 file coming from Ifix 3.0 . In my office system i have install Ifix 4.0
For my try i have copied H24 files into c:\dynamics\htrdata and in the C:\dynamics\apps there is a HTD2CSV.EXE
I have also tryed to lunch the application with /DBG 1 - the result is : normal termination also if in the folder i remove all the H24 files. I do not understand where is my error.
Can you help me ?
I look the GE fanuc site but no more information. In this site i have read that the HTD2CSV was supplied with VB6 source code. Do you have this source ?
THANK YOU
Re: [?]: ifix and archive
Posted: Tue May 15, 2018 1:41 pm
by vijikesh
bjing wrote:http://www.megaupload.com/?d=UPKF1901
The HTD2CSV tool uses HDA toolkit calls to to dump historical information to a CSV file. This is useful for people who wish to view what is in the historical files from Notepad or Excel, etc.
Included in the ZIP file is a VB project which contains the source code to this tool, an iFIX graphic file and also a readme.rtf file that explains the usage.
There are two ways you can do this. You can use the iFIX graphic (HTD2CSV.grf), or use the the cmd command line.
The download link for HTD2CSV tool is not available please reupload the file.
I need to access the Historical data from Trend to integrate to my vba applicataion.
Re: [?]: ifix and archive
Posted: Tue May 15, 2018 7:30 pm
by bjing
Re: [?]: ifix and archive
Posted: Wed May 16, 2018 11:11 am
by vijikesh
Thanks for the tool bjing. Tested and working.
Re: [?]: ifix and archive
Posted: Fri May 18, 2018 11:01 am
by vijikesh
I am using HTD2CSV tool to get the value from the Historical data. I need to read around 100 Historical Tags, but by using this tool only one tag can be used at a time. So it is creating 100 csv file for me. Is there any way to link multiple tag at a time.
I have a sample excel Template format i need to link the Historical tags to this single Excel file. Is there any simple method for it. Please Guide me.
Re: [?]: ifix and archive
Posted: Tue Feb 28, 2023 4:34 pm
by nusselt
Hi,
I need to download the HTD2CSV tool. Where I can find a link?
Thanks a lot
Re: [?]: ifix and archive
Posted: Fri Mar 03, 2023 9:12 am
by dekelec