Paste information from external column

Please check the FAQ (https://www.xyplorer.com/faq.php) before posting a question...
Post Reply
n00bs
Posts: 5
Joined: 05 Sep 2022 09:27

Paste information from external column

Post by n00bs »

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!
Attachments
example.png
example.png (21.62 KiB) Viewed 281 times
Last edited by n00bs on 21 Sep 2022 17:26, edited 1 time in total.

highend
Posts: 13274
Joined: 06 Feb 2011 00:33

Re: Paste informatoin from column

Post by highend »

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

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

n00bs
Posts: 5
Joined: 05 Sep 2022 09:27

Re: Paste information from external column

Post by n00bs »

Thank you so much! It works great!

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Paste information from external column

Post by admin »

Cool script indeed! :appl:

Post Reply