Hi!
I need some help with a functionality I haven't been able to figure out on my own.
Is it possible to paste information that is different for every file from an excel column into a custom column in Xyplorer?
Specifically, I would like to generate a unique ID for every WAV file in Python and then import that list into a custom Xyplorer column (the one titled "UnID"). I did the ones in the attachment by hand but that method takes a long time and is prone to human error.
Any help is appreciated!
Paste information from external column
Paste information from external column
- Attachments
-
- example.png (21.62 KiB) Viewed 321 times
Last edited by n00bs on 21 Sep 2022 17:26, edited 1 time in total.
Re: Paste informatoin from column
Copy the Excel column into the clipboard (Ctrl+c), go into XY, select the belonging files (count must match!) and execute that script:
Adapt "ex1" to whatever extra column you're using for storing the tags
Adapt "ex1" to whatever extra column you're using for storing the tags
Code: Select all
$sel = <get SelectedItemsPathNames>;
end (!$sel), "No item(s) selected, aborted!";
end (!<clp>), "Nothing in clipboard, aborted!";
$i = 1;
foreach($tag, <clp>, <crlf>, "e") {
$item = gettoken($sel, $i, <crlf>);
tagitems("ex1", $tag, $item);
$i++;
}
One of my scripts helped you out? Please donate via Paypal
Re: Paste information from external column
Thank you so much! It works great!