BobTheDestroyer

joined 5 months ago
[–] [email protected] 1 points 4 months ago

By the way, what would be the equivalent code when using a text file for the list of names rather than a csv file?

[–] [email protected] 1 points 4 months ago

Ah, I think that was it. Forgot about the column heading. Thanks for your help!

[–] [email protected] 1 points 4 months ago* (last edited 4 months ago)

Just figured it out! Added '.pdf' in the second half of the command.

$names = cat "\path\to\names.txt"; $i=0; dir | % { ren $_ "$($names[$i]).pdf"; $i++ }

Thanks for all your help!

[–] [email protected] 1 points 4 months ago* (last edited 4 months ago) (2 children)

So it sort of worked in that it outputed a bunch of files with the names but with blank icons and not the Adobe icons. Powershell also had an error for each list item that looked like the following:

Rename-Item : Cannot bind argument to parameter 'NewName' because it is an empty string.
At line:1 char:86
+ ... ads\individuals.txt"; $i=0; dir | % { ren $_ "$($names[$i])"; $i++ }
+                                                   ~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (:) [Rename-Item], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Microsoft.PowerShell.Commands.Rena
   meItemCommand

Maybe the command needs '.pdf' somewhere?

[–] [email protected] 1 points 4 months ago (3 children)

Hey this worked for me yesterday but now I'm having trouble getting it to work again. It just outputs a Word doc titled '.docx' now.

[–] [email protected] 1 points 5 months ago (4 children)

It manages to output one file titled 'name; 0++'

[–] [email protected] 1 points 5 months ago (1 children)

Actually they're all different files.

[–] [email protected] 1 points 5 months ago (3 children)

I see. Any suggestions on how to correct it?

[–] [email protected] 1 points 5 months ago (1 children)

Thanks but PS closes so I assume it ran into an error. I'm not sure why because there is the same number of files and list items. I doublechecked to make sure.

[–] [email protected] 1 points 5 months ago (6 children)

Also I had someone help with a similar task of duplicating a Word file that is renamed from a list of names found in a csv file. What would be the code when a txt file is used?

Import-csv ‘.\individuals.csv’ | foreach-object {
    $newname = ‘2’ + $_.name + '.docx’
    Copy-item '.\_2023 Summary Page.docx' $newname
}
[–] [email protected] 1 points 5 months ago

Yeah it's a pretty simple task and I'm interested in getting more familiar with PS.

[–] [email protected] 1 points 5 months ago (6 children)

Thanks but I'm getting a 'Cannot create a file when that file already exists.' error. I checked the path so I am certain it is correct.

 

Note: I'm a beginner to Powershell and a bit more familiar with Bash (though still a beginner for that too).

*I have multiple PDF files and I want to rename each file based on a list of names found in an Excel/CSV (could be a text file if easier) file.

*The list begins at the A2 cell and the A1 cell has the header 'name'.

*The files are in sequential order and match the order of the list of names.

Thanks for your help!

 

I'm a beginner to Powershell and CLI in general, but this task does not need to use either so I'm open to using other tools.

I'm trying to do the following:

  1. Create multiple files from a Word template.
  2. Rename each file based on a list of names found in an Excel/CSV sheet.

Thanks in advance!

view more: next ›