Post by levi on Jun 18, 2019 22:26:00 GMT
I am working to replace my user state migration swapping tool with UI++ for the interface. I want to read values from a CSV and turn them into variables
Backup.csv
User,OldPC,NewPC
Levi,LeviPC,LeviPC2
The first line is the header, and the second is the values. It would be great if there was a FileReadCSV option that would read a csv, and populate variables based on the CSV Column name. If there were multiple lines, it would start appending a 01, 02 to the variable name.
<Action Type="FileReadCSV" FileName="C:\backup\backup.csv" DeleteFile="False"/>
Based on the above file, the above proposed XML would generate the following TS variables
User = Levi
OldPC = LeviPC
NewPC = LeviPC2
Backup.csv
User,OldPC,NewPC
Levi,LeviPC,LeviPC2
The first line is the header, and the second is the values. It would be great if there was a FileReadCSV option that would read a csv, and populate variables based on the CSV Column name. If there were multiple lines, it would start appending a 01, 02 to the variable name.
<Action Type="FileReadCSV" FileName="C:\backup\backup.csv" DeleteFile="False"/>
Based on the above file, the above proposed XML would generate the following TS variables
User = Levi
OldPC = LeviPC
NewPC = LeviPC2