Just words? It’s a list of names.
Just words? It’s a list of names.
Oh I see. I thought only .txt files are text files.
I was trying to adjust the code so that it uses a .txt file instead of a .csv file.
It’s just a Notepad text file.
By the way, what would be the equivalent code when using a text file for the list of names rather than a csv file?
Ah, I think that was it. Forgot about the column heading. Thanks for your help!
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?
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.
It manages to output one file titled ‘name; 0++’
Actually they’re all different files.
I see. Any suggestions on how to correct it?
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.
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
}
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.
Perhaps my directions were unclear. The Excel/CSV file has the new names and I want to use them to replace the default names for the PDF files.
I got rid of that task. Now it’s just Task #1
Nevermind I got it!
Actually nevermind that question. Just realized the command was split.
I’m assuming I need to replace the name portion of the 2nd line. What do I input if the data is a list that starts in A1?
So I’m new to all this. When I enter the first command with my csv file and doc file included, it just opens the word doc. Wasn’t sure what I should do next.
Thanks for your help, but I had a couple errors pop up when I tried this out. I don’t need to input anything in the code you provided, do I?
Cannot convert value "VALUE" to type "System.Int32". Error: "Input string was not in a correct format." At line:4 char:55 + ... py-Item -Path .\template.docx -Destination ".\$(2 + $line + '.docs')" + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Copy-Item : Cannot overwrite the item FILENAME with itself. At line:4 char:5 + Copy-Item -Path .\template.docx -Destination ".\$(2 + $line + '.d ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (FILENAME) [Copy-Item], IOException + FullyQualifiedErrorId : CopyError,Microsoft.PowerShell.Commands.CopyItemCommand