Return-Path: Received: from mail-gy0-f169.google.com ([209.85.160.169] verified) by media-motion.tv (CommuniGate Pro SMTP 4.2.10) with ESMTP-TLS id 4702465 for AE-List@media-motion.tv; Tue, 01 May 2012 20:05:28 +0200 Received: by ghrr18 with SMTP id r18so2183388ghr.28 for ; Tue, 01 May 2012 11:06:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=pGAOJ91o6WGPD8sXNqPmX7mBVrtLGCODvYKMyLE8UdE=; b=ymRv7YAjOyF4oDPDCHRPKPWntcFXp/OuBuUVsCCkX4LP6YOnvtAmg4Mh+uHWPzBzkc wUJDdvPGyS/d9mlLRk+jSiSyVxyLZRPKkZmShA3KnVcI7Lhhif3PwAlq6Vyii2kgJX6d WEIFm+5Szn293kN8xrF1K2PO6p0Ru8PeB6PWY5G7ra46psQS90YtiujXc01af6g6yNha bSwuOCoFs1NFojWH4dhDf40hHwRF3wuB/BRuE3d1Os5q1ARtDgN+ucK5NG4ceJg2qc8E dBNfNFm4VaazQkOPzU6KEkvTlX5iJnK4UGSh2K98T5u92ypC2PB0bktZWXchBcDfRh1t qU9Q== Received: by 10.60.0.135 with SMTP id 7mr26773663oee.25.1335895608283; Tue, 01 May 2012 11:06:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.60.132.178 with HTTP; Tue, 1 May 2012 11:06:28 -0700 (PDT) In-Reply-To: References: From: Bruce Wainer Date: Tue, 1 May 2012 14:06:28 -0400 Message-ID: Subject: Re: [AE] export markers to textfile with timecode To: After Effects Mail List Content-Type: multipart/alternative; boundary=e89a8fb1ffe030526e04befd6f4a --e89a8fb1ffe030526e04befd6f4a Content-Type: text/plain; charset=ISO-8859-1 Lloyd and Robert, Actually tabs are acceptable in place of commas, the "CSV" format of spreadsheets isn't limited to commas. You can use any character you want but commas and tabs are the most common. When you open a text file in most spreadsheet applications it will either auto-recognize the separator character or ask you what character the file uses. Bruce Wainer On Tue, May 1, 2012 at 1:42 PM, Lloyd Alvarez wrote: > I see, if you use commas to separate each element and a newline at the end > of each line then the exported file will open as a spreadsheet so you > wouldn't need to copy and paste. Does that make sense? > > Lloyd > > On Tue, May 1, 2012 at 1:29 PM, Robert Kjettrup wrote: > >> Hi >> >> yes, i know. I just wanted to skip a step of writing the file, and >> copy/paste from that into a spreadsheet, and just copy/paste directly from >> AE.... just me being lazy. >> >> >> >> Robert Kjettrup / Grafiker / STV Mayday >> Mobil: 25 18 95 16 >> Mail: robert@stvmayday.dk >> >> >> 2012/5/1 Lloyd Alvarez >> >>> Hey Robert, >>> >>> You can export it as a comma delimited or tab delimited file and it >>> should open correctly in your spreadsheet program. Let me know if you need >>> to to elaborate on this. >>> >>> Cheers, >>> Lloyd >>> >>> On Tue, May 1, 2012 at 12:59 PM, Robert Kjettrup wrote: >>> >>>> Yes, i'm on windows. >>>> >>>> it's ok, just a bit faster to copy paste when you want the data in a >>>> spreadsheet, but i will manage :-) >>>> >>>> >>>> >>>> Robert Kjettrup / Grafiker / STV Mayday >>>> Mobil: 25 18 95 16 >>>> Mail: robert@stvmayday.dk >>>> >>>> >>>> 2012/5/1 Lloyd Alvarez >>>> >>>>> I only know how to do that on mac and you said you were on windows >>>>> right? If you know a commandline way to send something to the clipboard >>>>> then i could add it. >>>>> >>>>> >>>>> On Tue, May 1, 2012 at 12:46 PM, Robert Kjettrup wrote: >>>>> >>>>>> Hi Lloyd >>>>>> >>>>>> a small feature request more. Being able to choose to copy to >>>>>> clipboard instead of writing to a file... easy? :-) >>>>>> >>>>>> >>>>>> Robert Kjettrup / Grafiker / STV Mayday >>>>>> Mobil: 25 18 95 16 >>>>>> Mail: robert@stvmayday.dk >>>>>> >>>>>> >>>>>> 2012/5/1 Lloyd Alvarez >>>>>> >>>>>>> Glad you like it, let me know who it works for you. >>>>>>> >>>>>>> -Lloyd >>>>>>> >>>>>>> >>>>>>> On Tue, May 1, 2012 at 12:09 PM, Robert Kjettrup < >>>>>>> robert@stvmayday.dk> wrote: >>>>>>> >>>>>>>> Oh.... that looks absolutely brilliant. And you just made it super >>>>>>>> customizable in what fields to export. >>>>>>>> >>>>>>>> Too bad i am almost finished with this project now... but i just >>>>>>>> bought it anyway, it should speed up the process for the remaining clips. >>>>>>>> ;-) >>>>>>>> >>>>>>>> Thanks! >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Robert Kjettrup / Grafiker / STV Mayday >>>>>>>> Mobil: 25 18 95 16 >>>>>>>> Mail: robert@stvmayday.dk >>>>>>>> >>>>>>>> >>>>>>>> 2012/5/1 Lloyd Alvarez >>>>>>>> >>>>>>>>> Hey Robert, >>>>>>>>> >>>>>>>>> I updated the script to support exporting to a file. You can >>>>>>>>> format the text file however you want, i made a quick screendemo showing >>>>>>>>> how to use it. You can get the script and see the demo here: >>>>>>>>> http://aescripts.com/layer-marker-batch-editor/ >>>>>>>>> >>>>>>>>> Let me know if you have any questions. >>>>>>>>> >>>>>>>>> Cheers, >>>>>>>>> Lloyd >>>>>>>>> >>>>>>>>> On Tue, May 1, 2012 at 5:46 AM, Robert Kjettrup < >>>>>>>>> robert@stvmayday.dk> wrote: >>>>>>>>> >>>>>>>>>> Hi Lloyd >>>>>>>>>> >>>>>>>>>> for this project i just use the AutoHotKeys Premiere script Ed >>>>>>>>>> provided, it works for what i need... or rather what the freelancer we have >>>>>>>>>> hired to do the DVD authoring need, since he doesn't want to use Encore but >>>>>>>>>> really oldschool Spruce he needed the timecodes for chapter markers and >>>>>>>>>> I-frame placement for his mpeg2 encoder. >>>>>>>>>> But, if you really don't know what to do for a few minutes (!) >>>>>>>>>> and would like to add this export feature in your AE script, just make the >>>>>>>>>> output tab spaced like the script Ed did >>>>>>>>>> Heres an output of the Premiere script from Ed: >>>>>>>>>> >>>>>>>>>> Sequence0001 00:00:09:17 "" "" >>>>>>>>>> Sequence0001 00:01:39:03 "" "" >>>>>>>>>> Sequence0001 00:03:34:12 "" "" >>>>>>>>>> Sequence0001 00:04:53:14 "" "" >>>>>>>>>> Sequence0001 00:05:26:10 "" "" >>>>>>>>>> Sequence0001 00:06:02:24 "" "" >>>>>>>>>> Sequence0001 00:06:37:12 "" "" >>>>>>>>>> Sequence0001 00:07:04:18 "" "" >>>>>>>>>> Sequence0001 00:07:33:04 "" "" >>>>>>>>>> Sequence0001 00:08:15:20 "" "" >>>>>>>>>> Sequence0001 00:08:50:20 "" "" >>>>>>>>>> Sequence0001 00:09:24:05 "" "" >>>>>>>>>> Sequence0001 00:09:59:19 "" "" >>>>>>>>>> Sequence0001 00:10:38:11 "" "" >>>>>>>>>> >>>>>>>>>> Another useful feature would be a choice of timecode or >>>>>>>>>> framenumber >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks for the helpful offer to modify your script, this list >>>>>>>>>> reallt is awsome :-) >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Robert Kjettrup / Grafiker / STV Mayday >>>>>>>>>> Mobil: 25 18 95 16 >>>>>>>>>> Mail: robert@stvmayday.dk >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> 2012/5/1 Lloyd Alvarez >>>>>>>>>> >>>>>>>>>>> Hey Robert, >>>>>>>>>>> >>>>>>>>>>> If you tell me what format you need the text file I can update >>>>>>>>>>> my Layer Marker Batch Editor script >>>>>>>>>>> http://aescripts.com/layer-marker-batch-editor/ to have this >>>>>>>>>>> functionality. The main caveat is only layer markers are accessible via >>>>>>>>>>> scripting so unfortunately comp markers won't be included in the export. >>>>>>>>>>> >>>>>>>>>>> Cheers, >>>>>>>>>>> -Lloyd >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Mon, Apr 30, 2012 at 8:50 AM, Robert Kjettrup < >>>>>>>>>>> robert@stvmayday.dk> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi >>>>>>>>>>>> >>>>>>>>>>>> Is there some script that exports layers/comp markers to a >>>>>>>>>>>> simple textfile with timecode? Either directly from AE or via Premiere? >>>>>>>>>>>> >>>>>>>>>>>> i have search a little and i can't find anything that does it >>>>>>>>>>>> as a simple plain textfile. The closest i have found is an old premiere >>>>>>>>>>>> plugin that doesn't seem to work with CS5.5 ( >>>>>>>>>>>> http://www.2writers.com/Eddie/PpExpMark.htm) >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Robert Kjettrup / Grafiker / STV Mayday >>>>>>>>>>>> Mobil: 25 18 95 16 >>>>>>>>>>>> Mail: robert@stvmayday.dk >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --e89a8fb1ffe030526e04befd6f4a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Lloyd and Robert,

Actually tabs are acceptable in place of commas, t= he "CSV" format of spreadsheets isn't limited to commas. You = can use any character you want but commas and tabs are the most common. Whe= n you open a text file in most spreadsheet applications it will either auto= -recognize the separator character or ask you what character the file uses.=

Bruce Wainer

On Tue, May 1, 2012 at 1= :42 PM, Lloyd Alvarez <lists@aescripts.com> wrote:
I see, if you use commas to separate each element and a newline at the end = of each line then the exported file will open as a spreadsheet so you would= n't need to copy and paste. =A0Does that make sense?

Lloyd

<= div class=3D"gmail_quote"> On Tue, May 1, 2012 at 1:29 PM, Robert Kjettrup <robert@stvmayday.dk= > wrote:
Hi

yes, i know. I just wanted to skip a step of writing = the file, and copy/paste from that into a spreadsheet, and just copy/paste = directly from AE.... just me being lazy.



Robert Kjettrup / Grafiker / STV Mayday
Mobil: 25= 18 95 16
Mail: robert@stvmayday.dk


2012/5/1 Lloyd Alvarez <lists@aescrip= ts.com>

Hey Robert,

You can export it as a comma delimited or tab delimited file and it shou= ld open correctly in your spreadsheet program. Let me know if you need to t= o elaborate on this.

Cheers,
Lloyd


On Tue, May= 1, 2012 at 12:59 PM, Robert Kjettrup <robert@stvmayday.dk> wrote:
Yes, i'm on windows.

= it's ok, just a bit faster to copy paste when you want the data in a sp= readsheet, but i will manage :-)



Robert Kjettrup / Grafiker /= STV Mayday
Mobil: 25 18 95 16
Mail: robert@stvmayday.dk


2012/5/1 Lloyd Alvarez <lists@aescrip= ts.com>
I only know how to do that on mac and you said you were on windows right? = =A0If you know a commandline way to send something to the clipboard then i = could add it.


On Tue, May 1, 2012 at 12:46 PM, Robert Kjettrup <robert@stvmayday.dk> wrote:
Hi Lloyd

a small feature = request more. Being able to choose to copy to clipboard instead of writing = to a file... easy? :-)


Robert Kjettrup / Grafiker = / STV Mayday
Mobil: 25 18 95 16
Mail: robert@stvmayday.dk


2012/5/1 Lloyd Alvarez <lists@aescrip= ts.com>
Glad you like it, let me know who it works for you.

-Lloy= d


On Tue, May 1, 2012 at 12:09 PM, Robert Kjettrup <robert@stvmayday.dk> wrote:
Oh.... that looks absolutely brilliant. And = you just made it super customizable in what fields to export.=A0

Too bad i am almost finished with this project now... but i just bough= t it anyway, it should speed up the process for the remaining clips. ;-)

Thanks!




Robert Kjettrup / Grafiker / STV Mayday
Mobil: 25 18 = 95 16
Mail: rob= ert@stvmayday.dk


2012/5/1 Lloyd Alvarez <lists@aescrip= ts.com>
Hey Robert,

I updated the script to support exporting to= a file. =A0You can format the text file however you want, i made a quick s= creendemo showing how to use it. =A0You can get the script and see the demo= here:=A0http://aescripts.com/layer-marker-batch-editor/

Let me know if you have any questions.

Cheers,
Lloyd

<= div>On Tue, May 1, 2012 at 5:46 AM, Robert Kjettrup <<= a href=3D"mailto:robert@stvmayday.dk" target=3D"_blank">robert@stvmayday.dk= > wrote:
Hi Lloyd

for t= his project i just use the AutoHotKeys Premiere script Ed provided, it work= s for what i need... or rather what the freelancer we have hired to do the = DVD authoring need, since he doesn't want to use Encore but really olds= chool Spruce he needed the timecodes for chapter markers and I-frame placem= ent for his mpeg2 encoder.
But, if you really don't know what to do for a few minutes (!) and= would like to add this export feature in your AE script, just make the out= put tab spaced like the script Ed did
Heres an output of the Prem= iere script from Ed:

Sequence0001 = 00:00:09:17 ""= ""
Sequence0001 00:01:39:03 "" ""
Sequence0001 00:03:34:12 "" ""
Sequence0001 00:04:53:14 "" ""
Sequence0001 00:05:26:10 "" ""
Sequence0001 00:06:02:24 "" ""
Sequence0001 00:06:37:12 "" ""
Sequence0001 00:07:04:18 "" ""
Sequence0001 00:07:33:04 "" ""
Sequence0001 00:08:15:20 "" ""
Sequence0001 00:08:50:20 "" ""
Sequence0001 00:09:24:05 "" ""
Sequence0001 00:09:59:19 "" ""
Sequence0001 00:10:38:11 "" ""

Another useful feature would be a choice of timec= ode or framenumber


Thanks for the h= elpful offer to modify your script, this list reallt is awsome :-)


Robert Kjettrup / Gra= fiker / STV Mayday
Mobil: 25 18 95 16
Mail: robert@stvmayday.dk


2012/5/1 Lloyd Alvarez <l= ists@aescripts.com>
Hey Robert,

If you tell me what format you need the text= file I can update my Layer Marker Batch Editor script http://aescripts.= com/layer-marker-batch-editor/ to have this functionality. =A0The main = caveat is only layer markers are accessible via scripting so=A0unfortunatel= y=A0comp markers won't be included in the export. =A0

Cheers,
-Lloyd


On Mon, Apr 30, 2012 at 8:50 AM, Robert Kjet= trup <robert@stvmayday.dk> wrote:
Hi

= Is there some script that exports layers/comp markers to a simple textfile = with timecode? Either directly from AE or via Premiere?

i have search a little and i can't find anything th= at does it as a simple plain textfile. The closest i have found is an old p= remiere plugin that doesn't seem to work with CS5.5 (http://www.2writers= .com/Eddie/PpExpMark.htm)




Robert = Kjettrup / Grafiker / STV Mayday
Mobil: 25 18 95 16
Mail: robert@stvmayday.dk












--e89a8fb1ffe030526e04befd6f4a--