Publication Year to display No Date or just plain n.d.
glendac - August 20, 2009 - 02:36
| Project: | Bibliography Module |
| Version: | 6.x-1.6 |
| Component: | User interface |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
We're using the bibliography module to display an index to a collection of sheet music (in print) in our library and a lot of the records don't have publication years. The value of n.d. shows up as "Submitted". I see that this has been already addressed several times here. But the best solution that I've gotten so far - the one about putting a zero (0) value - is still not optimal for user display. Would it be possible to convert the value of 0 to something like "No Date" or just plain "n.d"? You could see our test site for this project at http://softtester.org/sheetmusic. Thank you for any help.
#1
I could make the "no date" text is a configuration option, thus you could change "Submitted" to anything you want.
By the way, I noticed some of your author names have leading quotation marks and some trailing ones. How did you input the data? Was it imported from a file and if so what format? There is clearly an issue there.
Ron.
#2
Thanks Ron for noticing the leading quotations. Yes, we are doing batch import. Our process involves exporting the data (about 30,000 records) out of an Access database into Excel where we clean it up then we export it into a tab-delimited text file which we then import into EndNote (where I created a custom Reference Type for sheet music) and then export it as an XML file to be imported into Biblio (where I created a Publication Type for sheet music and mapped to the EndNote sheet music reference type).
The leading quotations are only found in multi-author fields. The original data has two or more composers or lyricists in separate fields but we put them together in one column in Excel (each author name separated by a semicolon).
We'd appreciate any help on this.
#3
Hmmm, Sounds like Excel is double quoting the "semi-colon" delimited field. If you could get rid of those quotes it would probably work OK. According to the EndNote manual..
Author Names:Before you export data from a database or spreadsheet into a
text file, we recommend that you separate multiple author
names with a semicolon (;) or two forward slashes “//”, such
as: McCartney, P.//Harrison, G.//Lennon, J. If you cannot
easily do this in your database, you can do it after exporting,
or manually edit the data after it is in EndNote.
So I suspect you just need to get rid of the quotation marks, if they exist, in Excel.
Ron.
#4
Hi Ron, we cleaned out the double quotation marks in either the text file exported from Excel or in the xml file exported from EndNote and both approaches work. [We still have to clear out older entries so the test site still shows authors indexed under ".]
Also, I looked for all instances of "Submitted" (except for the form state) in the Biblio files and replaced it with "No Date" and this seemed to work fine.
One more item to ask for help however: why is it that there is no primary title field showing in the list of biblio fields when we create a new publication type? We want to map Song Title to a primary title field but can't see it so we mapped it to biblio_secondary_title. The data entry form shows a Title field and a Song Title field. We want the title indexed too.
Thank you very much for all your work on Biblio!
-- Glenda
#5
Hi Glenda,
"Biblio" type nodes are an extension of the basic Drupal node type and as such uses the node->title field for the primary title information, rather than a biblio specific field. Thus ALL types have a title field by default.
I'm a bit confused (you say there is no title field, but then you say there is a title field on the input form), but I guess what you are really saying is that you want to change the name of the "Title" field on the input form to "Song Title"?
You probably don't want to use the secondary title field for the primary title, since that is typically used for the title of the publication which contains the specific work (i.e. Book or Journal title). So if your song was contained in a song book then the book title would go in the secondary title field.
Ron.