[-] BobTheDestroyer@lemy.lol 1 points 7 months ago

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
[-] BobTheDestroyer@lemy.lol 1 points 7 months ago

Just words? It's a list of names.

[-] BobTheDestroyer@lemy.lol 1 points 7 months ago

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.

[-] BobTheDestroyer@lemy.lol 1 points 8 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?

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

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

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago* (last edited 8 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!

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago* (last edited 8 months ago)

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?

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

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.

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

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

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

Actually they're all different files.

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

I see. Any suggestions on how to correct it?

[-] BobTheDestroyer@lemy.lol 1 points 8 months ago

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?

view more: ‹ prev next ›

BobTheDestroyer

joined 8 months ago