#Transfer SQL DB to CSV# 1. Code can find code here https://dkswiftproject.blogspot.com/2018/10/powershell-transfert-ups-worldship.html , save as file Name : transfer-WorldshipSQLToUISAddressBook.ps1 2. Please check your Powershel version update to 5.1 3. Right click Mouse button and Run with PowerShell 4. Support Worldship SQL version :SQL2005, SQL2008, SQL2012, SQL2014 5. File default export to : UPS\WSTD\ImpExp, File Name : UISCSVEXPORT.csv

PowerShell transfer UPS Worldship address book to csv file, for UPS Web shipping address book import. Code Release : ``` cls Set-ExecutionPolicy -ExecutionPolicy Bypass # database Intraction Write-Host "##################################################" -ForegroundColor Red Write-Host " Start Transfer Worldship Address Bokk data to UIS" -ForegroundColor Green Write-Host " " -ForegroundColor Red Write-Host "##################################################" -ForegroundColor Red Start-Sleep -Seconds 3 $Win64Arch = [Environment]::Is64BitProcess if($PSVersionTable.PSVersion -le 5.1){ write-host "Update Powershell first" exit } try{ if($Win64Arch -eq $true){ $temp = Get-ItemProperty -Path HKLM:SOFTWARE\WOW6432Node\UPS\Installation -ErrorAction Stop }else{ $temp = Get-ItemProperty -Path HKLM:SOFTWARE\UPS\Installation -ErrorAction Stop } }catch...