• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Automation Blocks - Spreadsheet Being Generated with Combined Columns

Explorer ,
Apr 05, 2024 Apr 05, 2024

Copy link to clipboard

Copied

Hi Mathias and Premiere Community,

 

I followed the tutorial on Export Properties of Selected Clips to Spreadsheet for Automation Blocks.

When viewing the .csv in Open Office, the Clip Name, Parameter, and Value are all combined in column A, instead of in separate columns like in the video. Each cell in column A has clip name, parameter and value all together, separated by commas. Quite a jumble.

 

Column B has "Path"

 

Any idea why?

 

 

TOPICS
SDK

Views

224

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Apr 06, 2024 Apr 06, 2024

Hi Sam,

there are different flavors of cvs files - some use tabs as as separator symbol between the cells, some use tabs and some use ;

In Open Office during import you can choose which separator symbol you want. Make sure to use comma.

 

This is what the import dialog looks like in my German Open Office:

Screenshot 2024-04-06 at 20.45.47.png

Votes

Translate

Translate
Community Expert ,
Apr 06, 2024 Apr 06, 2024

Copy link to clipboard

Copied

Hi Sam,

there are different flavors of cvs files - some use tabs as as separator symbol between the cells, some use tabs and some use ;

In Open Office during import you can choose which separator symbol you want. Make sure to use comma.

 

This is what the import dialog looks like in my German Open Office:

Screenshot 2024-04-06 at 20.45.47.png

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 08, 2024 Apr 08, 2024

Copy link to clipboard

Copied

That worked! Thank you!
There wouldn't be a way to export only the 'source file' parameter, would there?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 09, 2024 Apr 09, 2024

Copy link to clipboard

Copied

LATEST

You can write custom tools which export exactly what you want.

 

See 

 

and 

 

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines