PWTNC, PWHL, XML, tmp

You are here

Haruo's picture

SheWhoWaits requested a page scan in the Hymnal Clearinghouse forum, namely hymns 431 & 432 from the hymnal whose identifier here is PWTNC, don't ask me what the C stands for... This hymnal appears to be identical in content (based on comparing the page index of the one to the pages of the other) to a hymnal I own, but it differs in three ways that I can see from PWTNC, namely
1) It doesn't mention the Nazarenes
2) It doesn't show a publication date, and
3) It says it was published by Lillenas Publishing Company rather than the Nazarene Publishing Company.

So I went ahead and created a new hymnal, PWHL, and tried to copy the contents. I downloaded the Nazarene hymnal as a spreadsheet, saved the spreadsheet to my hard drive as PWHL.xml, and then uploaded it to the new, denominationally generic hymnal. But I got an error message:

File successfully uploaded to /tmp/PWHL.xml
The given file is not a valid XML file.

I tried again with the same result, and then tried just uploading the Page worksheet, but all with the same result. I don't understand why my procedure didn't work. I didn't modify the spreadsheet at all except to rename it, I conserved its XML designation. The only other time I got a similar error message it was because I had saved the spreadsheet inadvertently as *.xls instead of *.xml, but this was not the case in the present instance.

Could one of you with appropriate access look at what got saved in tmp, there should be two versions there, PWHL.xml (page only) and PWHL-full.xml (complete spreadsheet copied from PWTNC)? Thanks!


Comments

I tried this and got the same message. I do not know why the message says it is not a valid XML file. There is an easier way to copy a hymnal though, which I have done for you. You go to the hymnal you want to copy. Under the hymnal Editor Tools, you will find "Copy hymns to other hymnal" You put in your destination hymnal ID, then check the box to "Copy the hymns to an empty hymnal." This will copy the numbers exactly without letter prefixes.

when I copied the Revell edition of "New Hymnal for American Youth" to create the Century edition which turned out to be purt near identical in content. But the instructions say it will copy "to another DNAH hymnal" and I only think of the ones with "d" first line identifiers as DNAH hymnals. So I didn't do it. I will in future like cases.