fromXls.ps1

fromXls.ps1

Get-ChildItem '.' -Directory | ForEach-Object {	
	$folder = $_
	if (!$folder.Name.StartsWith('values') -or $folder.Name.EndsWith('dp')) { return }
	$isEN = ($folder.Name -eq "values")
	
	Write-Output $folder.Name
	
	Get-ChildItem $folder -File | ForEach-Object {
		$file = $_
		$fileName = $file.BaseName

		if (!$file.FullName.EndsWith('csv')) { return }		
		if ($file.FullName.EndsWith('_final.csv')) { return }		
		if (!($fileName.StartsWith('strings') -or $fileName.StartsWith('array'))) { return }
		
		Write-Output $file.FullName
		
		# pre-sort CSV
		$finalPath = $file.DirectoryName+"/"+$file.BaseName+"_final.csv"
		Import-Csv $file.FullName | sort Key | Export-Csv -Path $finalPath -Encoding utf8 -NoTypeInformation
	}
				
	Get-ChildItem $folder -File | ForEach-Object {
		$file = $_
		$fileName = $file.BaseName

		if (!$file.FullName.EndsWith('_final.csv')) { return }		
		if (!($fileName.StartsWith('strings') -or $fileName.StartsWith('array'))) { return }
		
		$xmlsettings = New-Object System.Xml.XmlWriterSettings
		$xmlsettings.Indent = $true
		
		$xmlWriter = [System.XML.XmlWriter]::Create($file.FullName+"_.xml", $xmlsettings)
		$xmlWriter.WriteStartDocument()
		
		$xmlWriter.WriteStartElement('resources')
		$xmlWriter.WriteAttributeString("xmlns","tools",$null,"http://schemas.android.com/tools")
		
		$pluralKey = ''
		$arrayKey = ''
		Import-Csv $file.FullName | ForEach-Object {
			if ($_.Type -eq 'plurals' -or $_.Key -contains ".") {
				$keyParts = $_.Key.Split(".")
				if (!($pluralKey -eq $keyParts[0])) 
				{
					if (!($pluralKey -eq '')) { $xmlWriter.WriteEndElement() }
					$xmlWriter.WriteStartElement('plurals') 
					$XmlWriter.WriteAttributeString('name', $keyParts[0])
				}
				if (!($arrayKey -eq '')) { 
					$arrayKey = ''
					$xmlWriter.WriteEndElement() 
				}
				$pluralKey = $keyParts[0]
				$xmlWriter.WriteStartElement('item')
				$XmlWriter.WriteAttributeString('quantity', $keyParts[1])
				$XmlWriter.WriteValue($_.Value)
				$xmlWriter.WriteEndElement()
			} elseif ($_.Type -eq 'string-array') {
				$keyParts = $_.Key.Split("/")
				if (!($arrayKey -eq $keyParts[0])) 
				{
					if (!($arrayKey -eq '')) { $xmlWriter.WriteEndElement() }
					$xmlWriter.WriteStartElement('string-array') 
					$XmlWriter.WriteAttributeString('name', $keyParts[0])
				}
				if (!($pluralKey -eq '')) { 
					$pluralKey = ''
					$xmlWriter.WriteEndElement() 
				}
				$arrayKey = $keyParts[0]
				$xmlWriter.WriteStartElement('item')
				$XmlWriter.WriteValue($_.Value)
				$xmlWriter.WriteEndElement()
			} else {
				if (!($pluralKey -eq '')) { 
					$pluralKey = ''
					$xmlWriter.WriteEndElement() 
				}
				if (!($arrayKey -eq '')) { 
					$arrayKey = ''
					$xmlWriter.WriteEndElement() 
				}
				$xmlWriter.WriteStartElement($_.Type)
				$XmlWriter.WriteAttributeString('name', $_.Key)
				$XmlWriter.WriteValue($_.Value)
				$xmlWriter.WriteEndElement()
			}
		}
		if (!($pluralKey -eq '')) { 
			$pluralKey = ''
			$xmlWriter.WriteEndElement() 
		}
		if (!($arrayKey -eq '')) { 
			$arrayKey = ''
			$xmlWriter.WriteEndElement() 
		}
		
		$xmlWriter.WriteEndElement()
		
		$xmlWriter.WriteEndDocument()
		$xmlWriter.Flush()
		$xmlWriter.Close()
	}
}