|
|
|
|
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
1138 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
1138 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
|
| |
|
|
|
|
. |
