Style needed, Format [Mey09]


We are using EN X1 and for our department literature database (about 2000 entries - we do not have the time for manual labels :wink: ), we need a style with the first three letters of the first author and the year of the publication, so for example for

1.    Dhiman, R., A.G. McDonald, and S. Chandra, Predicting splat morphology in a thermal spray process. Surface and Coatings Technology, 2007. 201(18): p. 7789-7801.

it would be [Dhi07]

How can this be done?

thanks for any help!


Message Edited by ellendt on 08-13-2009 04:03 AM

No ideas?

Not within Endnote.  I am not sure if some clever individual could design a macro that would extract the information on an exported set of data and then reimport it into Endnote, and then to extract it from down loaded records, to import for future additions? 

Besides, it would be unlikely to be unique - if the same first author wrote two papers in the same year?

Then it would be Mey09a oder Mey09b or Mey09c

Well, at risk of mentioning the “Z” word, it doesn’t seem to have this ability either (Discussion).  But you might find some of the discussion and links helpful?

It’s not en elegant solution, but you could make an output file that can be imported excel, and use excel’s LEFT/RIGHT function and CONCATENATE function. To extract 3 letters of the first author’s last name, use LEFT function. To extract 07 from 2007, use RIGHT function. Then, concatenate these two letters using CONCATENATE. Square brackets can be handled by Endnote.

You could do the similar thing using Filemaker Pro which has a powerful text handling functions. Once new filed is made, import them back to Endnote. This one can’t do the “a”, “b” thing, so you need to identify them manually. The question is how much you are familiar with export to Excel or Excel’s text function, or Filemaker.

I made a quick sample of these functions in Excel spread sheet, but couldn’t upload because it’s got .xls extension. (This forum doesn’t allow attachments having xls extension!!). I’ll try sending personal message to you.

Message Edited by myoshigi on 08-17-2009 03:06 PM

Message Edited by myoshigi on 08-17-2009 03:06 PM

I can of course write a script that will do that for me. Can I automatically add the generated labels to my database entries then? Otherwise, this does not make too much sense to me :wink:

No, you would have to export your library, add  the modified labels and then import again.  Not elegant, I agree. 

The problem I see, is that this style is very specific: 3 first of 1st author letters with and without a, when is the a introduced, only when a b is present? or would there be a MEY09, MEY09a, etc- what happens if the authors last name has only 2 letters?

And has a number of variants   that I found on with some googling – 4 first letters of 1st author; the first letter of the first 3 or 4 authors, Which complicates matters. 

And would the a,b,c you suggested be hardwired or is it publication specific? Is this a specific fix, you are suggesting or is this a published requirement?

All of this must be taken into account before the company undertakes the modification of the database programming and macros development within the program.  A need so specific might be solved by the  organization requiring the style?   I think that is what developers have done  here with merlin which I don’t pretend to understand. 

good luck!

Export and import is a real problem, because probably all of our attached PDF-Files would get lost. That is no choice at all. I see that the style is more complicated that plain numbering, but programs like JabRef also do support it and at least in germany this style is really common. Thanks for you help, seems like we’ll probably switch to a different software then…

You may not lose the link information even after export and import, if you use absolute paths to PDFs. The problem to export to excel is, it can’t export authors and keywords, which contain carriage return, into multiple data cells. Then, this scheme can’t solve the requests, such as, 2 letters from the first author, 2 letters from the second author, if the authors are two…etc etc kind of stuff.

To be able to accomplish such tasks perfectly, all the authors should be registered in individual data cells, with dynamic array size (in the programming world). I have done data export/import between Endnote and the native programming language called Labview, which allows me almost any kind of text tweaking. But, for that, you need Labview or somebody who has it. If you are interested, let me know.

Well, I’m not in Germany and I don’t need this particular author heading myself, but I just wrote a small Labview code to break down Endnote Export text file into each element, register authors and keywords into array format (indexable data cells), and import other field data into individual fields. This is totally outside of Endnote, but as you can see, the German style author heading is possible in “Synthetic Field 2” data field. By the way, somebody wanted senior author, so I made “Synthetic Field 1” as senior (last) author data.

I wrote this code to achieve the requirement these guys (in Germany) are talking.

1 author: take first 4 letters of the last name.

2 author: take 2 letters from each author.

3 author: take 2 letters from the first author, take 1 letter from second and third author.

4 authors and more: take 1 letter from the first 4 authors.

Then add year (last two digits)

I’m making this Labview code to make an output file that is compatible with Endnote Import, such that, after import, these “synthetic fields” are accomodated in the field of choice. But, I can’t override record number of individual record, which is pretty much untouchable in Endnote.

If you are interested, I can burn executable (.exe) files, but easiest way to distribute this code for free is to have some friends who have Labview, and I can send native .vi (virtual instrument) format with e-mail. In either case, there will be several megabytes transfer, and I can’t do that through forum. Labview is very common software in engineering/bioengineering science used for signal processing, data acquisition, and machine vision, so you may ask your friends around.

Best regards,

Since I can’t attach more than three files in one post, the last one (4 author case) is attached here.

This code can read a Endnote Export text file which contains several thousands of records, and successfully recover path links to attachment when imported back to Endnote libraray. Record numbers will be all new. Limitations are: it doesn’t work if paths are multiple lines. It doesn’t work well with custom fields. But most of the purpose I’m using (such as searching keywords with senior author), it’s just fine.