Automation Blocks - Import Properties of Clips from Spreadsheet

[Philip23922101edh8]

Hi!

I love the extension Automation Blocks - it is exactly what I need for my project. However, the library template "Import Properties of Clips from Spreadsheet" seems to cause an error, and won't replace my clips, and I am not able to fix it. Therefore, I am looking for help.

I carefully followed the steps of the instruction video  "Batch Replace Clips, Texts, Colors & more in Pr with a Spreadsheet" (https://www.youtube.com/watch?v=6kd98g6IR2U)

The first step of exporting works. This is what the console shows when I export:

execute script
process param Opacity\Opacity of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 100
process param Opacity\Blend Mode of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 18
process param Motion\Position of clip \UntitledTest.prproj\Main Sequence::V1\1 with value [0.5,0.5]
process param Motion\Scale of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 100
execution result:undefined
process param Motion\Scale Width of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 100
process param Motion\Uniform Scale of clip \UntitledTest.prproj\Main Sequence::V1\1 with value true
process param Motion\Rotation of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 0
process param Motion\Anchor Point of clip \UntitledTest.prproj\Main Sequence::V1\1 with value [0.5,0.5]
process param Motion\Anti-flicker Filter of clip \UntitledTest.prproj\Main Sequence::V1\1 with value 0
destructor final end point 'main script' reached

However, when I make my adjustment in the CSV (just replacing the value of the source file), where I am absolutely not touching the 'Clip Path in Project' column at all, the script can be executed, but the intended changes do not happen. In the console it says:

execute script
execution result:undefined
set of to
warning: could not find component parameter \
destructor final end point 'main script' reached

I have repeated the steps several times (also with a blank new project), always following the steps in the tutorial. However, the intended replacements do not take place, and the console always gives me the same warning of not being able to find the component parameter, even though I am not touching the column Clip Path in Project.

Could you please point me in the right direction of what I could be doing wrong. Thank you very much in advance!

[Philip23922101edh8 · Accepted solution]

I have just solved this issue.

I found out that the issue was caused by the CSV.  When I change the delimiter of the CSV to "only commas", Automation Blocks is able to read the CSV perfectly.

This matter is solved.

[Mathias Moehl]

Thanks for sharing your solution! 🙂