How to import data in CSV format and batch match the creation time and modification time
I intend to utilize Excel to organize the information pertaining to the files that require modification, encompassing the new names for each file post-modification, as well as the creation and modification dates that need adjustment. Once all this information has been duly recorded in Excel, I plan to export a CSV format file and subsequently import it into the software. My aspiration is that, upon importation, the data contained within the CSV file can align with the data fields present in the software, thereby enabling the batch processing of these files. Currently, I possess the capability to rename files in bulk; however, I am unable to establish an accurate correspondence and modify the file names, creation dates, and modification dates accordingly.
Reply to #1:
Hi Tom,
I think Advanced Renamer is unable to change the file timestamps based on data present in a CSV spreadsheet.
Wait for other users' answers.
Hi Tom,
I think Advanced Renamer is unable to change the file timestamps based on data present in a CSV spreadsheet.
Wait for other users' answers.
Reply to #2:
Hi Tom,
Loved your work in Dunkirk, btw... :)
The easiest way is probably to incorporate a date/time into the filename on the first pass; then use a timestamp method to take that date and put it into whichever timestamp you choose; then use another batch to remove the date from the filename. Although you may be able to both write the timestamp and remove the date from the filename in one pass, I'm not sure.
I don't think it's possible to write two different dates into timestamps (creation and modified) without adding another layer of complexity and more batch runs. I think you'd have to set one timestamp from the date, remove it from the filename, add another date to the filename, set another timestamp, and then delete it from the filename. Gives me a headache thinking about it.
Randy, Kim?
Best,
DF
Hi Tom,
Loved your work in Dunkirk, btw... :)
The easiest way is probably to incorporate a date/time into the filename on the first pass; then use a timestamp method to take that date and put it into whichever timestamp you choose; then use another batch to remove the date from the filename. Although you may be able to both write the timestamp and remove the date from the filename in one pass, I'm not sure.
I don't think it's possible to write two different dates into timestamps (creation and modified) without adding another layer of complexity and more batch runs. I think you'd have to set one timestamp from the date, remove it from the filename, add another date to the filename, set another timestamp, and then delete it from the filename. Gives me a headache thinking about it.
Randy, Kim?
Best,
DF
Reply to #3:
Hey DF,
You try'n to nerd snipe ya boy?! (^_^)
Reference https://xkcd.com/356/
I *think* this is doable using a javascript method but I don't have time to test and write it up today.
IIF Tom shows back up, I'll give it some more thought.
Regards,
Randy
Hey DF,
You try'n to nerd snipe ya boy?! (^_^)
Reference https://xkcd.com/356/
I *think* this is doable using a javascript method but I don't have time to test and write it up today.
IIF Tom shows back up, I'll give it some more thought.
Regards,
Randy
Reply to #4:
> Reference https://xkcd.com/356/
Hilarious! But I would *never* do that to you... truck or not! ;)
EDIT: Well... not intentionally. END EDIT
> I don't have time to test and write it up today.
Too busy reading nerdy comics? hmmmmm?
:) btw, what IS the equivalent resistance?
Best,
DF
> Reference https://xkcd.com/356/
Hilarious! But I would *never* do that to you... truck or not! ;)
EDIT: Well... not intentionally. END EDIT
> I don't have time to test and write it up today.
Too busy reading nerdy comics? hmmmmm?
:) btw, what IS the equivalent resistance?
Best,
DF
Reply to #3:
Hi DF,
My thoughts when I woke up this morning are the same as what you said. I also plan to first modify the file names by adding timestamps, and then batch delete the file names and dates.
But I'm not sure if it can be achieved. I can try the assistance operation you provided. Thank you very much!
Regards,
Tom
Hi DF,
My thoughts when I woke up this morning are the same as what you said. I also plan to first modify the file names by adding timestamps, and then batch delete the file names and dates.
But I'm not sure if it can be achieved. I can try the assistance operation you provided. Thank you very much!
Regards,
Tom