Importing CSV for List Replace
Hello,
I am attempting to data import a .CSV file with around 4K rows to rename a group of folders the same size. The .CSV file is not giving me an error when attempting to load, but after the load bar completes, nothing happens. There is no data in the List Replace section. I have also tried this with a .txt file and had the same result. I haven't had this happen before so I'm unsure what could be the cause. Any thoughts?
I am on 4.20. Any insight would be helpful.
Thank you
I am attempting to data import a .CSV file with around 4K rows to rename a group of folders the same size. The .CSV file is not giving me an error when attempting to load, but after the load bar completes, nothing happens. There is no data in the List Replace section. I have also tried this with a .txt file and had the same result. I haven't had this happen before so I'm unsure what could be the cause. Any thoughts?
I am on 4.20. Any insight would be helpful.
Thank you
Reply to #1:
[original post removed by DF]
I'm not getting any <csv:x> to work with 4.20... I'd try using an earlier (portable) version and see what happens.
[original post removed by DF]
I'm not getting any <csv:x> to work with 4.20... I'd try using an earlier (portable) version and see what happens.
Reply to #2:
Dear DF, (DDF)
It works, I use it a few times per month. I guess I'll post an answer here in a bit.
Regards,
Randy
Dear DF, (DDF)
It works, I use it a few times per month. I guess I'll post an answer here in a bit.
Regards,
Randy
Reply to #1:
Hello Alec,
You said you "haven't had this happen before", so I'll assume you've used it successfully more than once. If you can't get it to work at all (with a smaller CSV file), say so and we can show how it works.
On the idea that it might be a size issue, I tried it with a 5586 line CSV file, pointing to messy real-world folders.
During the "Adding files..." stage, ARen popped up an Error:
"9996596580023804552" is an invalid integer
and stalled out
Tried again with 5107 lines -- same thing
With 4501 lines, I didn't get that error but the "Analyzing files..." dialog blinks flakily for several seconds. After that it appeared to work okay (except that I didn't actually run the batch, 'cause I like my folders as -is TYVM).
So ***** It appears that Aren flakes out at around 4000 folders imported via CSV *****
The exact number probably varies from system to system.
*** This appears to be a bug. ***
If, you try it with a 2000 line CSV and it still doesn't work, then you're probably doing something else, let us know.
~~~~~~~~~~~~~~~~~~
Dear DF,
The OP question is kinda ambiguous (I assume for now that it is just the bug for him).
As for getting csv to work in general, here's some prior answers (because I'm lazy and pressed for time). If you want more or different, please ask a new question. :)
MOST IMPORTANTLY, using csv data from JS: (^_^)
https://www.advancedrenamer.com/forum_thread/renaming-files- from-a-csv-17030
With that, you certainly don't need/want non-javascript methods!
But here are some for potential newcomers to this thread...
Straight renaming files from a two-column CSV: ( <csv:x> tag not needed)
https://www.advancedrenamer.com/forum_thread/help-rename-fil es-to-specific-number-16930
Complex import files from CSV and also use <csv:x> tags to access data from additional columns:
https://www.advancedrenamer.com/forum_thread/import-csv-file -16819#:~:text=Reply%20to%20%233%3A
Regards,
Randy
Hello Alec,
You said you "haven't had this happen before", so I'll assume you've used it successfully more than once. If you can't get it to work at all (with a smaller CSV file), say so and we can show how it works.
On the idea that it might be a size issue, I tried it with a 5586 line CSV file, pointing to messy real-world folders.
During the "Adding files..." stage, ARen popped up an Error:
"9996596580023804552" is an invalid integer
and stalled out
Tried again with 5107 lines -- same thing
With 4501 lines, I didn't get that error but the "Analyzing files..." dialog blinks flakily for several seconds. After that it appeared to work okay (except that I didn't actually run the batch, 'cause I like my folders as -is TYVM).
So ***** It appears that Aren flakes out at around 4000 folders imported via CSV *****
The exact number probably varies from system to system.
*** This appears to be a bug. ***
If, you try it with a 2000 line CSV and it still doesn't work, then you're probably doing something else, let us know.
~~~~~~~~~~~~~~~~~~
Dear DF,
The OP question is kinda ambiguous (I assume for now that it is just the bug for him).
As for getting csv to work in general, here's some prior answers (because I'm lazy and pressed for time). If you want more or different, please ask a new question. :)
MOST IMPORTANTLY, using csv data from JS: (^_^)
https://www.advancedrenamer.com/forum_thread/renaming-files- from-a-csv-17030
With that, you certainly don't need/want non-javascript methods!
But here are some for potential newcomers to this thread...
Straight renaming files from a two-column CSV: ( <csv:x> tag not needed)
https://www.advancedrenamer.com/forum_thread/help-rename-fil es-to-specific-number-16930
Complex import files from CSV and also use <csv:x> tags to access data from additional columns:
https://www.advancedrenamer.com/forum_thread/import-csv-file -16819#:~:text=Reply%20to%20%233%3A
Regards,
Randy
Reply to #4:
Hi Randy,
Sorry you went through all that for me, and thanks, but I just meant I couldn't get the <csv:x> tag to work in a replace method, or a list-replace method (which works in the 3.95p version I keep for special stuff). I didn't say any more because I never use <csv>, I use js for any csv-type stuff I do. Which works fine. The largest .csv I use is only about 2800 lines, so I can't vouch for beyond that.
Again, though, thanks for taking the time to research that. You're very kind and I appreciate it.
Best,
DF
Hi Randy,
Sorry you went through all that for me, and thanks, but I just meant I couldn't get the <csv:x> tag to work in a replace method, or a list-replace method (which works in the 3.95p version I keep for special stuff). I didn't say any more because I never use <csv>, I use js for any csv-type stuff I do. Which works fine. The largest .csv I use is only about 2800 lines, so I can't vouch for beyond that.
Again, though, thanks for taking the time to research that. You're very kind and I appreciate it.
Best,
DF
Reply to #5:
No problem. It might help someone sometime, maybe...
I just tested <csv> in Replace and List replace methods. It still works fine for me there too,
Although it doesn't make as much sense in a List replace method, since the data is keyed by item index... ;P
And, yeah, my CSV files have ranged from 4 to about 60 lines. But I *suspect* that a list of files can be longer than a list of folders before Aren gets whammied. I ain't got no reason to test that though.
Regards,
Randy
No problem. It might help someone sometime, maybe...
I just tested <csv> in Replace and List replace methods. It still works fine for me there too,
Although it doesn't make as much sense in a List replace method, since the data is keyed by item index... ;P
And, yeah, my CSV files have ranged from 4 to about 60 lines. But I *suspect* that a list of files can be longer than a list of folders before Aren gets whammied. I ain't got no reason to test that though.
Regards,
Randy
Reply to #4:
Thanks for the response. I had the # of files wrong, it's actually 1591 so I'm guessing number of files isn't the issue. Even at the lower number of 1591 Importing the data through .CSV or .TXT still isn't loading the list into the List Replace section.
I have tried this before with about 1K files before and had no issues.
Thank you for the additional links, I will look through them and see if I can find anything that may help.
Alec
Thanks for the response. I had the # of files wrong, it's actually 1591 so I'm guessing number of files isn't the issue. Even at the lower number of 1591 Importing the data through .CSV or .TXT still isn't loading the list into the List Replace section.
I have tried this before with about 1K files before and had no issues.
Thank you for the additional links, I will look through them and see if I can find anything that may help.
Alec
Reply to #7:
Just to be precise, "List" and "List replace" are two different methods in Aren. "List replace" is never populated by/from csv. And List is only populated when importing Files and not Data.
Perhaps you are not really loading files/folders?
Or you've set the import dialog (https://www.advancedrenamer.com/user_guide/v4/csvimport#:~:t ext=Column%20for ) incorrectly for the CSV file?
==> Please post the first three lines of your CSV.
Also, please provide an example of what you are trying to accomplish. EG:
C:\stuff\foo -> C:\stuff\bar
Where the CSV looks like:
Old;New
"C:\stuff\foo","bar"
If you are feeling frisky, linking to your screenshots would help too.
Regards and best of luck,
Randy
Just to be precise, "List" and "List replace" are two different methods in Aren. "List replace" is never populated by/from csv. And List is only populated when importing Files and not Data.
Perhaps you are not really loading files/folders?
Or you've set the import dialog (https://www.advancedrenamer.com/user_guide/v4/csvimport#:~:t ext=Column%20for ) incorrectly for the CSV file?
==> Please post the first three lines of your CSV.
Also, please provide an example of what you are trying to accomplish. EG:
C:\stuff\foo -> C:\stuff\bar
Where the CSV looks like:
Old;New
"C:\stuff\foo","bar"
If you are feeling frisky, linking to your screenshots would help too.
Regards and best of luck,
Randy
Reply to #8:
Ok, so maybe I have a misunderstanding of importing the data through .CSV, if I want to import the list of old name and new name from a .csv or file, can I not load that so I don't have to add them in one at a time? Because I can get the folders to load into Renamer no problem, it's just getting the list replace names added to the program for renaming.
Is there a better way to add in the old/new name data to the List Replace section without adding them 1 cell at a time?
Ok, so maybe I have a misunderstanding of importing the data through .CSV, if I want to import the list of old name and new name from a .csv or file, can I not load that so I don't have to add them in one at a time? Because I can get the folders to load into Renamer no problem, it's just getting the list replace names added to the program for renaming.
Is there a better way to add in the old/new name data to the List Replace section without adding them 1 cell at a time?
Reply to #9:
Post the requested information please.
Post the requested information please.
Are you guys aware of the difference between the two CSV import features? Not everyone notice the difference and might end up using the wrong one.
https://www.advancedrenamer.com/user_guide/v4/csvimport
This one imports files and assigns new names from a column in the CSV. It will load the files from one column and create a List method to assign them new names based on another column in the CSV.
https://www.advancedrenamer.com/user_guide/v4/csvdataimport
This will import data from a CSV and make them available to the items already in the list. First row of values will be available to first item in the list. The same goes for row 2, 3, 4 etc. The data will be available through the <csv:X> tag. You can also see the imported data when selecting and item in the list and changing the metadata group to CSV on the information panel.
https://www.advancedrenamer.com/user_guide/v4/csvimport
This one imports files and assigns new names from a column in the CSV. It will load the files from one column and create a List method to assign them new names based on another column in the CSV.
https://www.advancedrenamer.com/user_guide/v4/csvdataimport
This will import data from a CSV and make them available to the items already in the list. First row of values will be available to first item in the list. The same goes for row 2, 3, 4 etc. The data will be available through the <csv:X> tag. You can also see the imported data when selecting and item in the list and changing the metadata group to CSV on the information panel.