Generate Sharegate Excel Files Using Powershell
We would like to be able to generate Sharegate Excel files using powershell. This would greatly help in automating the entire proces of migration for the powershell modules we have built around all of the other Sharegate powershell commands.
I would like to be able to have a command that produces the intermediate excel file like you can generate from the UI.
Input params would be:
Network location , siteurl, documentlibrary name, propertymapping, contenttypemapping, outputfilename, outputfolder.
What would be even more awesome if you could think up a way to be able to insert Excel formulas into the propertymapping when generating this excel file. Something like sourceproperty -> transformation excel fomula -> destination property
and insert that transformation into each row of the excel file if it is specified.
Really need it. When is it here?
Jim Duncan commented
We also have this need :-)
Is it on the roadmap yet?