.
 
.

ÜberwareTM

View Forum Thread

Anyone can view the forums, but you need to log in in order to post messages.

> Forum Home > Feature Requests > How to Export the Smedge Job Details in Excle Sheet

  Tue, 17/Jan/2012 12:28 AM
Dinesh
4 Posts
dear support,

We need to export all the completed smedge job details to excle sheet on daily basis. If we can get some tools that we import all the data to excle in one click it will be helpful for us.

Please provide with solution ASAP

Thanx And Regards
Dinesh.Mahajan
   
  Thu, 19/Jan/2012 2:01 PM
Robin
1136 Posts
Hi

There are several options for this. Probably the easiest is to set up Herald to monitor for the Job finished event, and dump the job details you are interested in into the end of a CSV style table that you can import into Excel. Check out the Herald documentation in the User Manual for more information.

Let me know if that helps or if you have any questions. Thanks,
-robin
   
  Tue, 07/Feb/2012 2:13 AM
Dinesh
4 Posts
Hi Robin,

Thanks for providing the solution but i can only set the following veriables

$(ID),$(Note),$(Name),$(Range),$(Creator)

I need to add the below details in the following order but I am unable to do it.also frame range is coming (101-101) this manner. I need to seperate the start And end frames and need a total frame count column please check the below order

$(ID)
$(Note)
$(Name)
$(Render type)...For e.g (nuke,maya,GenaricScripts)
$(SubRange.Start)
$(SubRange.End)
$(SubRange.total)
$(TotalElapsedRealTime)
$(Creator)


Can you please provide me with a solution so that I can add the above variables.to my .csv list


Regards
Dinesh Mahajan


   
  Wed, 08/Feb/2012 5:11 PM
Robin
1136 Posts
You can add any parameters you want that are available for the type of job you are using. You can find a full list of the parameters in the Administrator Manual. For the ones you list, here are the official names:

$(ID)
$(Note)
$(Name)
$(TypeString) <-- $(Type) will return the ID of the type
$(Range.Start) <-- $(SubRange) is only valid for individual work units
$(Range.End)
... <-- There is no way to get the number of frames, but since you have start and end, you can do the math yourself very easily
$(ElapsedRealTime)
$(Creator)

Thanks
-robin
   
Page 1 of 1

.
.
.
.
©2000 - 2013 Überware. All rights reserved