kent Posted June 12, 2020 Share Posted June 12, 2020 Hi all, I would like to ask for your opinions about encrypting files with different or unique password to individual files. Explanation here. I usually generate invoice from quickbook which save as pdf. The pdf can have names like customer ID. I would like to assign different password based on customer ID. For example, if customer ID = 003, password = customer birthday+ birthmonth The data I have it in excel I'm think either to assign the unique password to the pdf files, or zip them then create password on the zip file. I have been searching, googling, youtube... couldn't find a solution. Please help if possible. Link to comment Share on other sites More sharing options...
flash13 Posted June 12, 2020 Share Posted June 12, 2020 I'm not sure exactly what you are asking. Do you want to just generate unique passwords based on their information ? All the information is made up. Just an example ! ! ! Name Address City Country Phone Invoice Password 1 Password 2 Password 3 Password 4 Kent 1234 apple way london uk 523.6495 737389932 Ke234ria 73234don 73ondway 73ent495 flash13 4321 loch st lv usa 7329026 9502-394 fl321ami 95321lv 95vane 95las026 Matt 5678 nsane ave victoria usa 565.8799 83747649403 Ma678lin 83678ria 83icthwy 83att799 TT3rM1nat0Rr3 8765 enforcer lane miami usa 233.9926 5r937252 TT765 5r765ami 5riam 5rT3r926 Karlston 7890 post hwy berlin germany 878.2397 49405982 Ka890 49890lin 49erl 49arl397 Link to comment Share on other sites More sharing options...
Dodel Posted June 13, 2020 Share Posted June 13, 2020 20 hours ago, kent said: Hi all, I would like to ask for your opinions about encrypting files with different or unique password to individual files. Explanation here. I usually generate invoice from quickbook which save as pdf. The pdf can have names like customer ID. I would like to assign different password based on customer ID. For example, if customer ID = 003, password = customer birthday+ birthmonth The data I have it in excel I'm think either to assign the unique password to the pdf files, or zip them then create password on the zip file. I have been searching, googling, youtube... couldn't find a solution. Please help if possible. Possibly something like use PWGEN to generate unique passwords via command line, dump them to an excel file, then use some funky scripting via Autohotkey to pull a unique password from excel, store that password in clipboard, and then use 7zip to zip your invoice and use the password in the clipboard. 7zip command line reference here : https://sevenzip.osdn.jp/chm/cmdline/switches/index.htm Using Vtask Studio for example, you can extract a cell reference, store that as a variable, and pass that to the command line / 7zip. Link to comment Share on other sites More sharing options...
kent Posted June 23, 2020 Author Share Posted June 23, 2020 On 6/13/2020 at 4:56 PM, Dodel said: Possibly something like use PWGEN to generate unique passwords via command line, dump them to an excel file, then use some funky scripting via Autohotkey to pull a unique password from excel, store that password in clipboard, and then use 7zip to zip your invoice and use the password in the clipboard. 7zip command line reference here : https://sevenzip.osdn.jp/chm/cmdline/switches/index.htm Using Vtask Studio for example, you can extract a cell reference, store that as a variable, and pass that to the command line / 7zip. This is super advanced. I have some basics in macros, will give it a try. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.