overview for BobTheDestroyer

Powershell: How do I update my code to use a different file type? in c/programming@beehaw.org

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

Powershell: How do I update my code to use a different file type? in c/programming@beehaw.org

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

Just words? It's a list of names.

Powershell: How do I update my code to use a different file type? in c/programming@beehaw.org

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

Powershell: How do I update my code to use a different file type? in c/programming@beehaw.org

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

It's just a Notepad text file.

4

Powershell: How do I update my code to use a different file type? (lemy.lol)

submitted 5 months ago by BobTheDestroyer@lemy.lol to c/programming@beehaw.org

10 comments fedilink

I have a script that duplicates a Word doc template and renames each using a csv file with a list of names. What would be the equivalent code if instead of a csv file I use a text file?

Import-csv ‘.\individuals2.csv’ | foreach-object {
	$newname = ‘2 ‘ + $_.name + '.docx’
	Copy-item '.\template.docx' $newname
}

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

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

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

I got it now!

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

[-] BobTheDestroyer@lemy.lol 2 points 5 months ago

Nevermind I got it!

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

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.

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV in c/programming@programming.dev

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

Sorry I'm new to this. What exactly do I enter into Powershell for each step?

10

Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV (lemy.lol)

submitted 5 months ago by BobTheDestroyer@lemy.lol to c/programming@programming.dev

17 comments fedilink

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:

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

Thanks in advance!