plcforum.uz.ua

International PLC Forum
It is currently Thu Jun 21, 2018 10:35 pm

All times are UTC + 3 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: [?]: ifix and archive
PostPosted: Sat Oct 30, 2010 8:31 pm 

Joined: Sat May 27, 2006 9:46 am
Posts: 242
Location: Europe
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


Top
 Profile  
 
 Post subject: Re: ifix and archive
PostPosted: Sun Oct 31, 2010 11:51 am 

Joined: Sat Mar 08, 2008 11:33 pm
Posts: 86
Location: Belarus
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


Top
 Profile  
 
 Post subject: Re: ifix and archive
PostPosted: Sun Oct 31, 2010 7:54 pm 

Joined: Sat May 27, 2006 9:46 am
Posts: 242
Location: Europe
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 ?

:lol:

thank you again


Top
 Profile  
 
 Post subject: Re: ifix and archive
PostPosted: Tue Nov 02, 2010 11:05 am 

Joined: Sat Mar 08, 2008 11:33 pm
Posts: 86
Location: Belarus
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.


Top
 Profile  
 
 Post subject: Re: ifix and archive
PostPosted: Tue Nov 02, 2010 8:21 pm 

Joined: Tue Jun 01, 2010 6:57 am
Posts: 6
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)


Top
 Profile  
 
PostPosted: Tue Nov 09, 2010 3:08 am 

Joined: Sat May 27, 2006 9:46 am
Posts: 242
Location: Europe
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

(tyou) (tyou)


Top
 Profile  
 
PostPosted: Tue May 15, 2018 4:41 pm 

Joined: Thu Mar 30, 2017 8:17 am
Posts: 3
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.


Top
 Profile  
 
PostPosted: Tue May 15, 2018 10:30 pm 

Joined: Sat Mar 08, 2008 11:33 pm
Posts: 86
Location: Belarus
HTD2CSV tool reuploaded http://fayloobmennik.cloud/7268624

Also try russian utility H24Viewer http://dimassoft.blogspot.ru/2014/07/h24.html


Top
 Profile  
 
PostPosted: Wed May 16, 2018 2:11 pm 

Joined: Thu Mar 30, 2017 8:17 am
Posts: 3
bjing wrote:
HTD2CSV tool reuploaded http://fayloobmennik.cloud/7268624

Also try russian utility H24Viewer http://dimassoft.blogspot.ru/2014/07/h24.html



Thanks for the tool bjing. Tested and working.


Top
 Profile  
 
PostPosted: Fri May 18, 2018 2:01 pm 

Joined: Thu Mar 30, 2017 8:17 am
Posts: 3
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: vlad2006gr and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by International PLCforum® Forum Software © PLCforum
Mobile version