Import CSV file
https://www.advancedrenamer.com/user_guide/v4/csvimport
My import csv file has following columns with about 18.000 entries:
"Path","Name","BaseName","Extension","FullName","Length","LastWriteTime"
Is there a sequence I would need to follow to import or special nomenclature of the columns?
On the website it only says Original filename and new file name.
The new filenames start with years like 2010.
Is it then possible only to import the 2010* files or should I separate the csv file first and import by year?
Please advise how to perform the import?
My import csv file has following columns with about 18.000 entries:
"Path","Name","BaseName","Extension","FullName","Length","LastWriteTime"
Is there a sequence I would need to follow to import or special nomenclature of the columns?
On the website it only says Original filename and new file name.
The new filenames start with years like 2010.
Is it then possible only to import the 2010* files or should I separate the csv file first and import by year?
Please advise how to perform the import?
Reply to #1:
I'm afraid I don't quite understand what you want to do with your CSV file. Could you provide a practical example of file renaming?
In my opinion, importing the CSV file data would be appropriate in your case:
https://www.advancedrenamer.com/user_guide/v4/csvdataimport
I'm afraid I don't quite understand what you want to do with your CSV file. Could you provide a practical example of file renaming?
In my opinion, importing the CSV file data would be appropriate in your case:
https://www.advancedrenamer.com/user_guide/v4/csvdataimport
Reply to #2:
I have approx 18.000 pictures. The majority of those start with IMG_xxxx.jpg.
I created a Power Shell script which listed all those images like IMG_1709.JPG in the csv file with following columns: "Name","BaseName","Extension","FullName","Length","LastWriteTime"
With Power Query or EXIF - I will place the year in the New Filename column let's say IMG_1709.jpg was taken in 2015; the filename with then be 2015-IMG_1709.jpg
I thought using https://www.advancedrenamer.com/user_guide/v4/csvimport would be the way to do it; but I don't know if the import csv can only be having three columns
Orginial filename, New filename, Status
How would it know where the IMG_1709.jpg is stored on my computer?
And another thing: maybe the 18.000 images are too much for Advanced Renamer and it is better to use tranches.
I have approx 18.000 pictures. The majority of those start with IMG_xxxx.jpg.
I created a Power Shell script which listed all those images like IMG_1709.JPG in the csv file with following columns: "Name","BaseName","Extension","FullName","Length","LastWriteTime"
With Power Query or EXIF - I will place the year in the New Filename column let's say IMG_1709.jpg was taken in 2015; the filename with then be 2015-IMG_1709.jpg
I thought using https://www.advancedrenamer.com/user_guide/v4/csvimport would be the way to do it; but I don't know if the import csv can only be having three columns
Orginial filename, New filename, Status
How would it know where the IMG_1709.jpg is stored on my computer?
And another thing: maybe the 18.000 images are too much for Advanced Renamer and it is better to use tranches.
Reply to #3:
By default, Aren does only 10K files at a time but you can use a higher value in the settings.
I recommend splitting the set into 2 or three smaller batches.
Re: "How would it know where the IMG_1709.jpg is stored on my computer?"
That would be via the "Base folder for original files:" setting in the import dialog. All the files must all be in the same folder**.
As for what you are trying to do:
A) See https://www.advancedrenamer.com/user_guide/v4/tags
All if the info you listed -- including the DateTaken -- are already available via tags.
So there is no obvious need to use a csv file from what you presented so far. Just add your files, set your methods, then run and done.
B) But if you *do* need a csv (for example, using the command line interface or some other reason)...
"Files from CSV import" will load the files for you, but as you've seen not allow you to use any of the columns except current file name and (optional) new name.
But you can:
1) https://www.advancedrenamer.com/user_guide/v4/csvimport to load the files.
2) Do not reorder the imported list in any way!
3) Use https://www.advancedrenamer.com/user_guide/v4/csvdataimport on the exact same CSV file.
4) You can then use <Csv:X> tags to access and apply info from the other columns. Although in the scenario presented so far, nothing in the CSV file seems to be present that is not already more easily accessed via Aren's other tags.
Hope that helps.
If not, please provide *exact* before and after file examples. And also any other relevant criteria that seems to be missing.
Regards,
Randy
ETA: Specific sub-Q reply
~~~~~~~~~~~~~~~~~~~~
** This seems like a crippling limitation. But I've not needed to use file import, so it's not a pressing concern for me ATM. (I do use *data* import all the time.)
By default, Aren does only 10K files at a time but you can use a higher value in the settings.
I recommend splitting the set into 2 or three smaller batches.
Re: "How would it know where the IMG_1709.jpg is stored on my computer?"
That would be via the "Base folder for original files:" setting in the import dialog. All the files must all be in the same folder**.
As for what you are trying to do:
A) See https://www.advancedrenamer.com/user_guide/v4/tags
All if the info you listed -- including the DateTaken -- are already available via tags.
So there is no obvious need to use a csv file from what you presented so far. Just add your files, set your methods, then run and done.
B) But if you *do* need a csv (for example, using the command line interface or some other reason)...
"Files from CSV import" will load the files for you, but as you've seen not allow you to use any of the columns except current file name and (optional) new name.
But you can:
1) https://www.advancedrenamer.com/user_guide/v4/csvimport to load the files.
2) Do not reorder the imported list in any way!
3) Use https://www.advancedrenamer.com/user_guide/v4/csvdataimport on the exact same CSV file.
4) You can then use <Csv:X> tags to access and apply info from the other columns. Although in the scenario presented so far, nothing in the CSV file seems to be present that is not already more easily accessed via Aren's other tags.
Hope that helps.
If not, please provide *exact* before and after file examples. And also any other relevant criteria that seems to be missing.
Regards,
Randy
ETA: Specific sub-Q reply
~~~~~~~~~~~~~~~~~~~~
** This seems like a crippling limitation. But I've not needed to use file import, so it's not a pressing concern for me ATM. (I do use *data* import all the time.)
Reply to #4:
Thanks, then I split in half and do the usual way.
Thanks, then I split in half and do the usual way.
Reply to #5:
Godspeed! :)
Godspeed! :)
Reply to #1:
Good morning everyone,
I agree with Randy's answer and would like to add a few suggestions.
To add the year to the start of the new file name, use the tags <Img Year>-<Name>.
https://i.postimg.cc/cL0r4xd1/img49.png
Good morning everyone,
I agree with Randy's answer and would like to add a few suggestions.
To add the year to the start of the new file name, use the tags <Img Year>-<Name>.
https://i.postimg.cc/cL0r4xd1/img49.png