Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Output Google Books Library XML Files to CSV
- # For creating labels for new library books
- # $UID is the primary key for the library system, make sure you select a free range
- # the script auto increments $UID from the selected starting point for each book
- [xml]$books = Get-Content D:\AR_Middle_years.xml
- $UID = 9000
- $bookObj = $books.library.books.book | ForEach-Object {
- New-Object PSCustomObject -Property @{
- "ISBN" = $_.identifier.value
- "Title" = $_.title
- "Author" = $_.contributor
- "ID" = $UID++
- }
- }
- $bookObj | Select Title, Author, ISBN, ID | Export-Csv -NoTypeInformation -Path D:\Books.csv
Add Comment
Please, Sign In to add comment