Microsoft Excel to Next Capture Name

Discussion regarding all scripting related questions
Please DO NOT post to this thread anything that is not directly related to scripting of Capture One.

Microsoft Excel to Next Capture Name

Postby NN227160UL1 » Thu Feb 27, 2020 10:58 am

Simple question using Apple Script.
Can somebody know the way to achieve this??
What I would like to apply is below.

Copy the text in the selected cell on Excel file.
Then paste onto the next capture name (job name) of Capture One session.

Many thanks.
NN227160UL1
 
Posts: 6
Joined: Thu Nov 11, 2010 1:26 am

Re: Microsoft Excel to Next Capture Name

Postby Eric Nepean » Fri Feb 28, 2020 6:12 pm

If you select a cell with the jobname in Excel, this should work
Code: Select all
tell application "Microsoft Excel" to set jobName to get value of active cell
tell application "Capture One 12" to tell current document to tell next capture settings to set status job identifier to jobName

For me the Excel value is correctly retreived, but the status job identifier is not updated and I don't get any error message.

Could be because I don't have a camera tethered and I don't have tethered shooting set up.
Eric Nepean
 
Posts: 678
Joined: Sat Oct 25, 2014 8:02 am
Location: Ottawa

Re: Microsoft Excel to Next Capture Name

Postby rapdigital » Mon Mar 09, 2020 10:03 am

Code: Select all
tell application "Microsoft Excel" to set jobName to get value of active cell
tell application "Capture One 12"
   tell current document
      set {capture counter, capture name, capture name format} to {0, jobName, "[Name]-[4 Digit Counter]"}
   end tell
end tell


to omit the counter reset

Code: Select all
set {capture name, capture name format} to {jobName, "[Name]-[4 Digit Counter]"}


I think status job identifier refers to IPTC metadata fields.
rapdigital
Certified Professional
Certified Professional
 
Posts: 190
Joined: Mon Feb 02, 2009 1:52 pm


Return to Scripting



Who is online

Users browsing this forum: No registered users and 1 guest