Okay so kind of a powershell scripter, but need some assistance with the translation of the CCP member document.
So this script does work I have tested it by using the premade TechNet google translator powershell script linked below:
Link to the google translate powershell script https://gallery.technet.microsoft.com/scriptcenter/Google-Translate-via-36574cef
Since the database is a raw csv it should be fairly easy to script the translation to something like what's below. I'm only trying the name column for the test the rest of the columns show be easy once some of the initial kinks are worked out. The first version prints to console but google returns an error that there are too many requests.
The second works just fine but opens an IE window with the translation for every row. If anyone has a paid google translate account and a little bit of Powershell scripting skills i bet we can translate this thing fairly quick tonight.
Link to the csv file: https://gitlab.com/shanghai-ccp-member-db/shanghai-ccp-member-db/-/raw/master/shanghai-ccp-member.csv
Version of the script that prints to console: $filepath = "C:\Users$env:USERNAME\Downloads\shanghai-ccp-member.csv"
Import-csv $filepath | ForEach-Object {Show-GoogleTranslate -from 'Chinese Simplified' -to English -Text $_.Name -Console}
Version of the script that opens an IE window every time $filepath = "C:\Users$env:USERNAME\Downloads\shanghai-ccp-member.csv"
Import-csv $filepath | ForEach-Object {Show-GoogleTranslate -from 'Chinese Simplified' -to English -Text $_.Name }
Also one thing to note you may have to set your powershell execution policy before running because the TechNet script is unsigned.
Okay so kind of a powershell scripter, but need some assistance with the translation of the CCP member document.
So this script does work I have tested it by using the premade TechNet google translator powershell script linked below:
Link to the google translate powershell script https://gallery.technet.microsoft.com/scriptcenter/Google-Translate-via-36574cef
Since the database is a raw csv it should be fairly easy to script the translation to something like what's below. I'm only trying the name column for the test the rest of the columns show be easy once some of the initial kinks are worked out. The first version prints to console but google returns an error that there are too many requests.
The second works just fine but opens an IE window with the translation for every row. If anyone has a paid google translate account and a little bit of Powershell scripting skills i bet we can translate this thing fairly quick tonight.
Link to the csv file: https://gitlab.com/shanghai-ccp-member-db/shanghai-ccp-member-db/-/raw/master/shanghai-ccp-member.csv
$filepath = "C:\Users$env:USERNAME\Downloads\shanghai-ccp-member.csv"
Import-csv $filepath | ForEach-Object {Show-GoogleTranslate -from 'Chinese Simplified' -to English -Text $_.Name -Console}