DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Displaying numbers of records processed/time upon completion

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> Forms Playback Support (.fld files)
View previous topic :: View next topic  
Author Message
rappaj



Joined: 19 Dec 2006
Posts: 12
Location: New York, NY

PostPosted: Mon Feb 05, 2007 11:57 am    Post subject: Displaying numbers of records processed/time upon completion Reply with quote

Hi,

On the MACRO version, upon completion of a load, it would give the time it took to complete the load as well as how many records got processed. Does the PROFESSIONAL version do it as well?

If so, how can I make it display?

Thanks,
Joe
Back to top
View user's profile Send private message Send e-mail
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Mon Feb 05, 2007 9:11 pm    Post subject: Reply with quote

Joe,

I don't think that it does (and I don't have access to a system to check right now). I wanted to do some timings to prove how much faster DataLoad Professional is, so I did it in Excel. I clicked a cell labelled "Start Time" and did CTL+Shift+; then I clicked on another cell containing the URL then, when it finished, I clicked on another cell labelled "End Time" and did CTL+Shift+; and finally I had a cell called "Duration" which calculated the difference. To get the record count, I would use SQL to count the records before and after, then calculate the difference.

BTW, the cell containing the URL was built by concatenating a number of cells, including the record and playback file names, which in turn were a concatenation of "record_file" or "playback_file" and a cell containing the number 1 or 2 or 3 or ....., giving the file names discussed in your other post http://www.dataload.net/forum/viewtopic.php?t=71.

Cool HTH

David
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
rappaj



Joined: 19 Dec 2006
Posts: 12
Location: New York, NY

PostPosted: Tue Feb 06, 2007 2:34 pm    Post subject: progress Reply with quote

David,

I se that the progress button is turned off for the PRO version, but is available with the MACRO.

Thanks for telling me how you track your speed/progress.

Joe
Back to top
View user's profile Send private message Send e-mail
DataLoad
Site Admin


Joined: 15 Nov 2005
Posts: 231
Location: Dorset, UK

PostPosted: Tue Feb 06, 2007 6:05 pm    Post subject: Reply with quote

Joe, David,

No, Dataload doesn't (and can't) tell you how many records have been processed in a forms playback load and how long the load took. This is becaue the actual load is run by Oracle Forms and not by DataLoad so DataLoad doesn't have this information.

Regards,

Jonathan Stuart
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> Forms Playback Support (.fld files) All times are GMT
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