Problem with iMacros 6.5 Stopwatch file format

Discussions and Tech Support related to the iMacros Firefox Add-on, including the built-in Javascript scripting interface for playing .js files.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information:CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
jlelu
Posts: 1
Joined: Fri Jan 29, 2010 2:57 pm

Problem with iMacros 6.5 Stopwatch file format

Post by jlelu » Fri Jan 29, 2010 3:16 pm

Hi,

I'm new on this forum, but I used iMacros with Firefox since many months.

I have encountered a problem with my stopwath result file today. Indeed I use this CSV file tu generated some repport with some graphics.

Before the plugin update my reports looked like this :

Code: Select all

"01/08/2010", "14:26:25", "Navigation Simple 2.iim", "ORANGE", "3.089"
"01/08/2010", "14:26:29", "Navigation Simple 2.iim", "CLUBIC", "5.026"
"01/08/2010", "14:26:36", "Navigation Simple 2.iim", "OZAP", "5.824"
"01/08/2010", "14:26:42", "Navigation Simple 2.iim", "CDISCOUNT", "3.652"
"01/08/2010", "14:26:46", "Navigation Simple 2.iim", "JEUXVIDEO.FR", "5.488"
"01/08/2010", "14:26:53", "Navigation Simple 2.iim", "YOUTUBE", "3.894"
"01/08/2010", "14:26:58", "Navigation Simple 2.iim", "DAILYMOTION", "3.505"
"01/08/2010", "14:26:25", "Navigation Simple 2.iim", "TOTAL", "36.061"
and now I obtain this file :

Code: Select all

"Date: 2010/29/01  Time: 16:08, Macro: Navigation Simple 2.iim, Status: OK (1)",
ORANGE,2.508
CLUBIC,9.950
OZAP,7.019
CDISCOUNT,3.284
JEUXVIDEOFR,5.564
YOUTUBE,2.806
DAILYMOTION,5.445
TOTAL,38.254
To use my data I need the datetime for each measure to generate my graphs. How can I recover the old file format with iMacro 6.5 or how can I include the datetime for each action?

Thank you for your responses.

best regards,
Jonathan
Marcia, Tech Support
Posts: 1094
Joined: Thu Jan 29, 2009 1:10 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Marcia, Tech Support » Mon Feb 01, 2010 7:31 am

Hello,

Thank you for the report. I forwarded this to the development team (FX#425).
Regards,

Marcia
f.sluijs
Posts: 2
Joined: Tue Feb 02, 2010 12:19 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by f.sluijs » Tue Feb 02, 2010 12:28 pm

I have the same situation here. My measurements need a date and a time to be accumulated in my reports. I understand that this issue is raised under FX#425. How can I stay informed on the status of this issue and the fix?

Thanks, Frank
Marcia, Tech Support
Posts: 1094
Joined: Thu Jan 29, 2009 1:10 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Marcia, Tech Support » Tue Feb 02, 2010 7:53 pm

Hello,

Sorry, the number is internal, just for our development team to have an easy way to find this thread and the support team to know that the issue reported here has been forwarded to dev.

Edit: I just got the info from development, that the new format is no bug, but a feature...
Regards,

Marcia
Binney
Posts: 2
Joined: Tue Feb 23, 2010 1:03 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Binney » Wed Feb 24, 2010 2:30 pm

Hello

This change seems to have altered the results being recorded when I use the play loop feature.

The times being recorded are no longer accurate as per the expected stopwatch label. They appear to be an accumulation of the previous run times so the last loop is merely a total runtime of the macro.

Is this going to be corrected or do I need to alter how i run the scripts.

Thanks
Marcia, Tech Support
Posts: 1094
Joined: Thu Jan 29, 2009 1:10 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Marcia, Tech Support » Mon Mar 01, 2010 8:55 am

Hello,

Sorry, I am not sure I understand the problem. Could you please, post the macro here and, perhaps the result which you believe is wrong?
Regards,

Marcia
Binney
Posts: 2
Joined: Tue Feb 23, 2010 1:03 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Binney » Mon Mar 01, 2010 9:49 am

VERSION BUILD=6251204 RECORDER=FX
TAB T=1
TAB CLOSEALLOTHERS
SET !FILESTOPWATCH Name-HOUR-Portal-login_{{!NOW:dd-mm-yy_hh}}.csv
STOPWATCH ID=LoginData
URL GOTO=http://website.test.com/default.htm
TAG POS=1 TYPE=DIV ATTR=ID:login
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:loginDetails ATTR=ID:username CONTENT=Name
SET !ENCRYPTION NO
TAG POS=1 TYPE=INPUT:PASSWORD FORM=NAME:loginDetails ATTR=NAME:password CONTENT=password
STOPWATCH ID=LoginSubmitData
TAG POS=1 TYPE=INPUT:SUBMIT FORM=NAME:loginDetails ATTR=NAME:loginSubmit&&VALUE:Log<SP>in
STOPWATCH ID=LoginSubmitData
STOPWATCH ID=LoginData
FRAME F=1
WAIT SECONDS=2
STOPWATCH ID=InboxLoad
TAG POS=1 TYPE=SPAN ATTR=TXT:Inbox
STOPWATCH ID=InboxLoad
WAIT SECONDS=2
STOPWATCH ID=PotalPageLoad
TAG POS=1 TYPE=SPAN ATTR=TXT:Create<SP>Job
STOPWATCH ID=PotalPageLoad
WAIT SECONDS=2
STOPWATCH ID=LogOutData
FRAME F=2
TAG POS=1 TYPE=IMG ATTR=ID:logout_h
TAG POS=1 TYPE=INPUT:BUTTON ATTR=ID:logout_yes
FRAME F=0
TAG POS=1 TYPE=A ATTR=TXT:click<SP>here
STOPWATCH ID=LogOutData

Previous results of macro were

01/15/2010 "13:39:10" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINSUBMITDATA" "19.497"
01/15/2010 "13:39:10" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINDATA" "20.201"
01/15/2010 "13:39:32" "NAME_HOUR_Login_Inbox_Portal.iim" "INBOXLOAD" "1.428"
01/15/2010 "13:39:35" "NAME_HOUR_Login_Inbox_Portal.iim" "POTALPAGELOAD" "16.802"
01/15/2010 "13:39:54" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGOUTDATA" "1.098"
01/15/2010 "13:39:56" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINSUBMITDATA" "17.935"
01/15/2010 "13:39:55" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINDATA" "18.458"
01/15/2010 "13:40:16" "NAME_HOUR_Login_Inbox_Portal.iim" "INBOXLOAD" "1.283"
01/15/2010 "13:40:19" "NAME_HOUR_Login_Inbox_Portal.iim" "POTALPAGELOAD" "14.578"
01/15/2010 "13:40:36" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGOUTDATA" "1.132"
01/15/2010 "13:40:38" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINSUBMITDATA" "22.080"
01/15/2010 "13:40:37" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINDATA" "22.547"
01/15/2010 "13:41:02" "NAME_HOUR_Login_Inbox_Portal.iim" "INBOXLOAD" "2.911"
01/15/2010 "13:41:07" "NAME_HOUR_Login_Inbox_Portal.iim" "POTALPAGELOAD" "16.833"
01/15/2010 "13:41:26" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGOUTDATA" "0.677"
01/15/2010 "13:41:27" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINSUBMITDATA" "16.314"
01/15/2010 "13:41:27" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGINDATA" "16.750"
01/15/2010 "13:41:46" "NAME_HOUR_Login_Inbox_Portal.iim" "INBOXLOAD" "1.460"
01/15/2010 "13:41:49" "NAME_HOUR_Login_Inbox_Portal.iim" "POTALPAGELOAD" "11.353"
01/15/2010 "13:42:03" "NAME_HOUR_Login_Inbox_Portal.iim" "LOGOUTDATA" "1.137"

The extracted data now looks like this.

Date: 2010/23/02 Time: 09:00, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (1)
LOGINSUBMITDATA 18.364
LOGINDATA 18.715
INBOXLOAD 3.922
POTALPAGELOAD 12.467
LOGOUTDATA 0.7
LOGINDATA 42.244
LOGINSUBMITDATA 42.183
LOGINSUBMITDATA 54.774
LOGINDATA 55.118
INBOXLOAD 36.397
INBOXLOAD 38.85
POTALPAGELOAD 34.896
POTALPAGELOAD 48.009
LOGOUTDATA 35.537
LOGOUTDATA 36.285
LOGINDATA 77.775
LOGINSUBMITDATA 77.786
LOGINSUBMITDATA 94.473
LOGINDATA 94.816
INBOXLOAD 76.085
INBOXLOAD 76.116
POTALPAGELOAD 74.931
POTALPAGELOAD 86.988
LOGOUTDATA 74.526
LOGOUTDATA 75.841

The timings now appear accumulative rather than defined to the specific loop run being executed.

What i would hope to have seen is something like this.

Date: 2010/25/02 Time: 09:15, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (1)
LOGINSUBMITDATA 11.882
LOGINDATA 12.213
INBOXLOAD 4.321
POTALPAGELOAD 12.864
LOGOUTDATA 0.43
Date: 2010/25/02 Time: 09:17, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (2)
LOGINSUBMITDATA 13.359
LOGINDATA 13.759
INBOXLOAD 2.851
POTALPAGELOAD 14.619
LOGOUTDATA 1.058
Date: 2010/25/02 Time: 09:18, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (3)
LOGINSUBMITDATA 12.215
LOGINDATA 12.739
INBOXLOAD 2.596
POTALPAGELOAD 11.53
LOGOUTDATA 0.41

Hope that's explained my problem better.
Marcia, Tech Support
Posts: 1094
Joined: Thu Jan 29, 2009 1:10 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Marcia, Tech Support » Wed Mar 03, 2010 10:42 am

Hello,

In other words, it seems that the values are not being reset after each macro run.

Thank you for reporting. I will forward this to the developers (FX439).
Regards,

Marcia
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Tech Support » Thu Mar 25, 2010 1:35 pm

Thank you for reporting these issues. We have here two issues at once: A format change to fit with our new Version 7 format. The goal is to have a header line for each measurement.

Example:

Code: Select all

Date: 2010/23/02 Time: 09:00, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (1) 
=> This contains also the iMacros result code, and this is very useful for automatic parsing of the performance log result.
To use my data I need the datetime for each measure to generate my graphs.
This makes good sense.
The timings now appear accumulative rather than defined to the specific loop run being executed.
This is a bug.

So the correct result should be:
What i would hope to have seen is something like this.

Date: 2010/25/02 Time: 09:15, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (1)
LOGINSUBMITDATA 11.882
LOGINDATA 12.213
INBOXLOAD 4.321
POTALPAGELOAD 12.864
LOGOUTDATA 0.43
Date: 2010/25/02 Time: 09:17, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (2)
LOGINSUBMITDATA 13.359
LOGINDATA 13.759
INBOXLOAD 2.851
POTALPAGELOAD 14.619
LOGOUTDATA 1.058
Date: 2010/25/02 Time: 09:18, Macro: NAME_HOUR_Login_Inbox_Portal.iim, Status: OK (3)
LOGINSUBMITDATA 12.215
LOGINDATA 12.739
INBOXLOAD 2.596
POTALPAGELOAD 11.53
LOGOUTDATA 0.41
Based on the feedback in this thread we plan to adjust the format slightly, so that it contains the best of both worlds.
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Tech Support » Thu Mar 25, 2010 2:06 pm

The proposed new format will be:

Code: Select all

"Date: 2009/11/12,  Time: 15:01:12, Macro: test1.iim, Status: OK (1)",,,
11/12/2009,15:01:14,STARTING,0.125
11/12/2009,15:01:22,FIRSTPAGE,0.468
11/12/2009,15:03:12,SUBMITDATA,2.468
11/12/2009,15:05:22,STORE,5.265
11/12/2009,15:05:33,BEFOREWAIT,5.281
11/12/2009,15:07:12,AFTERWAIT,7.328
11/12/2009,15:07:42,ATTHEEND,7.64
"Date: 2009/11/12,  Time: 15:22:01, Macro: test1.iim, Status: TAG not found (-111)",,,
11/12/2009,15:22:15,STARTING,0.093
11/12/2009,15:22:30,FIRSTPAGE,14.093
11/12/2009,15:22:44,SUBMITDATA,27.843
11/12/2009,15:23:11,STORE,44.031
11/12/2009,15:23:13,BEFOREWAIT,47.671
"Date: 2009/11/12,  Time: 15:32:11, Macro: test1.iim, Status: OK (1)",,,
11/12/2009,15:32:14,STARTING,0.094
11/12/2009,15:32:22,FIRST PAGE,0.422
11/12/2009,15:34:12,SUBMIT,2.516
11/12/2009,15:34:22,STORE,5.219
11/12/2009,15:34:33,BEFORE WAIT,5.235
11/12/2009,15:36:12,AFTER WAIT,7.282
11/12/2009,15:36:42,AT THE END,7.578
It combines the best of the old and new format.

Please note that you can access stopwatch performance data directly from any script via http://wiki.imacros.net/iimGetLastPerformance . If you automate iMacros from a script we recommend the use of iimGetLastPerformance.

If you have any suggestions or questions about the new format, please let us know.
f.sluijs
Posts: 2
Joined: Tue Feb 02, 2010 12:19 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by f.sluijs » Thu Apr 01, 2010 7:28 am

Hello Tech Support.

I like your 'best of both worlds' approach. I tested your example output and it imports fine in to Excel 2007. Can you tell me in which version this should be included? I am now referring from updating to keep my system running.

Some ideas I have for further improvement:
  • I would like to be able to toggle writing a header line to the output file by setting a parameter like:

    Code: Select all

    SET !STOPWATCHHEADER NO
  • on some systems (like mine) the decimal delimiteris a comma instead of a dot. Yes, it is possible to correct this during a import of a data file in Advanced Text Import in Excel, but it would be great if you could instruct iMacros to use a dot or a comma as a decimal separator by setting a parameter like:

    Code: Select all

    SET !STOPWATCHDECIMALDELIMITERCOMMA YES
To close I would like to place an offer: I use Excel to accumulate my measurements to a average per day and then to a average per version of the web application that I am testing. Please feel free to email me if you would like a copy and make available for the iMacros community.


Thanks again!
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Tech Support » Tue Apr 06, 2010 10:21 am

f.sluijs, thank you for the useful feedback. I added these suggestions to our todo list.

The latest iMacros Beta V6.6.5.0 contains the updated stopwatch command, as discussed in this forum post. If there are further stopwatch related suggestios or questions, please post it in this thread.
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Re: Problem with iMacros 6.5 Stopwatch file format

Post by Tech Support » Tue Apr 06, 2010 10:23 am

To close I would like to place an offer: I use Excel to accumulate my measurements to a average per day and then to a average per version of the web application that I am testing. Please feel free to email me if you would like a copy and make available for the iMacros community.
This sounds interesting! Please email it to info@iopus.com and mention this forum post. We will then upload it and link it from this forum post and the wiki :)
oaguila
Posts: 1
Joined: Wed Dec 29, 2010 9:17 pm

Re: Problem with iMacros 6.5 Stopwatch file format

Post by oaguila » Wed Dec 29, 2010 9:22 pm

Hi
I´m newie using imacro.
Just a question, is´t possible to obtain the stopwatch old csv format working with the new imacros version?
How is´t possible
Thanks
Osvaldo
Post Reply