We have already generated output file with some parameters but I need to add two more parameters (No. of Accounts, No. of safes) to the already generated output file(.csv). Code for already generated output file is attached.
(i) We have excel file(.csv) as input with platform ID, Target system user name, Target
System Address (which you can leave no need to bother about), Safe.
Now, in our Already generated output file we already have PlatformID, so this
PlatformID from already generated output file should be compared with Platform ID
from the input .csv file then if Platform ID matches then, it should check for accounts
and safes for that particular PlatformID and now in final output file - No. of Accounts,
No. of Safes - these two columns should be added with TOTAL no. of accounts and
TOTAL no. of safes associated with that single PlatformID.
(ii) Sample Input and Sample output file is attached (just for your understanding).
(iii) You can edit in Function readExcel(), as final code is attached. As this function
readExcel() is used for fetching One Time Password(IsOTP) and Password Change
frequency from the same input file. So, No. of accounts, No. of Safes is only pending
ABOUT MY CODE:
(a) To fetch the information from .ini file (first 23 columns)
(b) To fetch the information from xml file (24, 25, 26 columns)
(c) To fetch the information from excel(.csv) file( 27, 28 columns)
now, 29 and 30 columns should be added for [login to view URL] Accounts and No. of safes
My code will generate three ouput files (Output, Output1, Output2)
Output: for .ini file fetched information.
Output1: for xml file info and it will append the info to Output file
Output2: Final output (info from 3 files)
So, you can edit in function readexcel() to add info for these two columns and please
follow sample input file to right in a generic way (like if platformID exists these many
accounts and Safes like a way) because will have so many accounts
and safes in real input file.
(iv) Already generated file is also attached, please add these two parameters to the
already generated output file. Sample Input and Sample output files are only for your
understanding of requirement.
9 freelancers are bidding on average $129 for this job
Hi, I have been working in powershell for the last 3 years, i have strong knowledge on powershell. i can complete your work in very less time. Regards, Venkatesh
Hi, I can write PowerShell script that does the specified criteria. I write script in efficient and generic way possible. I will ensure to deliver the script in minimal possible time.