plc.myforum.ro Forum Index plc.myforum.ro
PLCs users www.plc.myforum.ro!
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Help with Intouch FileReadFields from .CSV

 
Post new topic   Reply to topic    plc.myforum.ro Forum Index -> Other HMI-Reg. U
View previous topic :: View next topic  
Author Message
DrGreen
Junior
Junior


Joined: 19 Mar 2012
Posts: 1

PostPosted: 19/03/2012 15:58    Post subject: Help with Intouch FileReadFields from .CSV Reply with quote

Hi all.

I busy with a project and have gotten abit stuck with reading data.
I saving data to a .csv file with the file name being the date-hour-minute.
I am using the bellow code to write my data
Code:
hour = StringFromIntg($Hour, 10 );
min = StringFromIntg($Minute, 10 );

FileWriteFields("C:\File " + $DateString + " H" + hour + "-" + min
 +".csv",1,"Line\Str0",50);


im am now struggling to get the program to read the data from the last written csv file (the file with the latest date)

Is anyone able to help me or guide me on what i should be doing?

Thank you in advance.
Back to top
View user's profile Send private message
messer
Senior
Senior


Joined: 08 Mar 2012
Posts: 2059
Location: Europe

PostPosted: 20/03/2012 10:51    Post subject: Intouch FileReadFields from .CSV Reply with quote

Exporting and Importing Tag Data
You can export the tag data of a managed InTouch application to a .csv file.
You can import this data into another managed InTouch application or a stand-alone InTouch application.

To export tag data from a managed InTouch application
1 Open the ArchestrA IDE.
2 Select the derived InTouch ViewApp template that contains the managed InTouch application from which you want to export the tag data.
3 On the Galaxy menu, point to Export, and then click DBDump. TheCSV File to Dump To dialog box appears.
4 Specify a location and file name for the .csv file and click Save.
A confirmation dialog box appears.
5 SelectGroup output by types if you want the tag data to be grouped by data types in the .csv file.
6 ClickOK . When a success message appears, clickOK .

To import tag data from a .csv file to a managed InTouch application
1 Open the ArchestrA IDE.
2 Select the derived InTouch ViewApp template that contains the managed InTouch application to which you want to import the tag data.
3 On the Galaxy menu, point to Import, and then click DBLoad.
TheCSV File to Load From dialog box appears.
4 Select the .csv file and click Open. During the import, one or more messages may appear warning you of duplicate names.
Select the appropriate option for each duplicate tag.
5 When a success message appears, clickOK .

See this pdf at page 41:
http://www.atrdist.com/RoadShowDocs/Intouch/ITAAIntegration.pdf

See also:
Wonderware West Tech Note 087:
Reading Data from a Microsoft Excel Workbook into InTouch
http://www.wonderwarewest.com/content/wonderware-west-tech-note-087-reading-data-microsoft-excel-workbook-intouch


Using HistData With InTouch and Excel
http://fa.sammicomputer.co.kr/TECH/html/using_hi.htm
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    plc.myforum.ro Forum Index -> Other HMI-Reg. U All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro