Showing results for 
Search instead for 
Do you mean 
Reply
New User
Posts: 1
Registered: ‎01-04-2018
0

Export Groups to Excel

Dear all

Is there a way to add "custom and smart groups" as a field to my excel export output style? I know I can right click a reference, ask for record summary and then copy the text to the clipboard. However, I have over 10'000 references and would like to export them all at once without having to click every one of them. 

Thank you for your help!

Martina

Mentor
Posts: 7,773
Registered: ‎04-10-2008
0

Re: Export Groups to Excel

[ Edited ]

No, the best you could do is select each group, then globally edit the records of each group to include an indicator that the record is a member of that group using the  Change/Move/Copy tool.  

(long time Endnote user)
Highlighted
Moderator
Posts: 432
Registered: ‎06-04-2008
0

Re: Export Groups to Excel

You can globally add the Group name to the references in the group this would be the best workaround to allow the group name to be exported.

 

You can use the Change Text tool in EndNote to change any group of showing references. Using this tool, you will be able to add the name of the group to any unused field in your references.

As you are making a large change to your database, make sure to back up the library before continuing.

Since EndNote makes these changes to every reference in the current view, you will want to choose the group you want to add the text to first so only the references for that group are selected. Then please do the following:

  1. In EndNote, go to Tools then Change and Move fields.
  2. For the field labeled In:, select the unused or custom field you want to use for the group designation.
  3. Under Change, choose "Insert before fields text".
  4. Check "Include a space after inserted text."
  5. In the field on the right, type the name of the group.
  6. Click OK.
  7. Repeat for each group.

This should add the group name in the field you've chosen. You would then get this information exported to Excel.

 

See our website for these steps:

 

https://support.clarivate.com/Endnote/s/article/EndNote-Add-the-group-name-in-references-to-sort?lan...

Best Regards,
Tony M.
Technical Support Representative RS
Clarivate Analytics
Formerly the IP & Science business of Thomson Reuters

Phone: +1 800 336 4474
clarivate.com
ipscience.tr.com

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·
Frequent Contributor
Posts: 72
Registered: ‎03-15-2012
0

Re: Export Groups to Excel

[ Edited ]

Is there a way to do this without going into each group, I have 9509 references in 4136 groups (smartgroups, standard groups and groups on groups) in 125 group sets.  I would prefer not to have to open each group in order to do this.

 

The other problem is that I use most, if not all the extra fields.

 

I should note that the result I am looking for is to actually generate a report from EndNote instead of having to export to excel or copy the group numbers to excel in order to do this.

Scenario:

  • group1 is a search that shows 165 results
  • group2 is a search that shows 259 results
  • group3 shows 178 results

I want to generate a report that says

Group 1 - 165

Group 2 - 259

Group 3 - 178

 

Since the numbers constantly change, I would rather generate the report from EndNote than take the chance of making a mistake while transposing the numbers to excel.

Thomas Zucker-Scharff
Systems Analyst
Moderator
Posts: 432
Registered: ‎06-04-2008
3

Re: Export Groups to Excel

Hello Thomas,

 

Instead of exporting to Excel you could use the Subject Bibliography command to produce a type of Report but in order to get the accurate count you still will need to add the group name to a field.

 

You would then able to run the Subject Bibliography command on that field.

 

You can find out more about the Subject Bibliography feature on our website:

 

https://support.clarivate.com/Endnote/s/article/EndNote-Creating-Stand-Alone-Bibliographies?language...

Best Regards,
Tony M.
Technical Support Representative RS
Clarivate Analytics
Formerly the IP & Science business of Thomson Reuters

Phone: +1 800 336 4474
clarivate.com
ipscience.tr.com

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·
Frequent Contributor
Posts: 72
Registered: ‎03-15-2012
0

Re: Export Groups to Excel

An interesting idea - which I am not sure I can even test.  I use almost all fields already, would the group name have to be by itself in the field, or could I add it to the notes field?  Also, it is good on the surface, but it does mean adding the group name of over 4000 groups.  Most of my publications are in more than one group, so I am not sure how this would work without a lot of testing.

Thomas Zucker-Scharff
Systems Analyst
Frequent Contributor
Posts: 72
Registered: ‎03-15-2012
0

Re: Export Groups to Excel

[ Edited ]

I have done a little testing

 

I added some group names to the Notes field with a carriage return before and after each

I tried running the bibliography report

 

The result is not what I had hoped.  I do get a group name with a number, but the publications are listed under each group, I don't want to list any publications in this type of report

 

Result

<groupname> (number in group)

each publication

each publication

each publication

each publication

 

<groupname> (number in group)

each publication

each publication

each publication

each publication

 

<groupname> (number in group)

each publication

each publication

each publication

each publication

 

What I would like

<groupname><groupname><groupname>
numberingroupnumberingroupnumberingroup

 

Is that possible? Basically can I suppress the publications from printing, and further can I change it from vertical to horizontal?

 

By editing the output style I can get the output to look like this:




2013 collab    (419)



2013 collab 02 - all    (60)



2013 collab 02 - inter    (9)



2013 collab 03 - all    (75)



2013 collab 03 - inter    (14)



2013 collab 03 - intra    (8)



2013 collab 05 - all    (150)



2013 collab 05 - inter    (34)



2013 collab 05 - intra    (19)



2013 collab 06 - all    (125)



2013 collab 06 - inter    (22)



2013 collab 06 - intra    (19)



2013 collab 07 - all    (67)



2013 collab 07 - inter    (14)



2013 collab 07 - intra    (3)



2018 collab 02 - inter    (6)



2018 coolab 02 - intra    (4)

 

But I haven't figured out a way to get it going horizontal yet.

Thomas Zucker-Scharff
Systems Analyst
Moderator
Posts: 432
Registered: ‎06-04-2008
3

Re: Export Groups to Excel

So once you run the Subject Bibliography you can go to Layout then Terms then select Subject Terms Only and it would list the items with the counts.

Best Regards,
Tony M.
Technical Support Representative RS
Clarivate Analytics
Formerly the IP & Science business of Thomson Reuters

Phone: +1 800 336 4474
clarivate.com
ipscience.tr.com

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·
Frequent Contributor
Posts: 72
Registered: ‎03-15-2012
0

Re: Export Groups to Excel

any way to change it so it goes horizontally? 

 

Also I have only put 10 out of nearly 4000 group names in the Research notes field, is there any way to get endnote to do this for me?

Thomas Zucker-Scharff
Systems Analyst
Moderator
Posts: 432
Registered: ‎06-04-2008
0

Re: Export Groups to Excel

You can use the steps above for any field to add a term or word to a field for more than one reference at once but you still would need to do it one group at a time to get the right term or word linked to the correct set of references.

 

See

 

https://support.clarivate.com/Endnote/s/article/EndNote-Add-the-group-name-in-references-to-sort?lan...

 

In step 2 you would just be selecting the Research Notes field.

 

I do not see a way to get the data in any other format but you can save tor RTF or TXT then open it in Word to further manipulate the information.

 

Best Regards,
Tony M.
Technical Support Representative RS
Clarivate Analytics
Formerly the IP & Science business of Thomson Reuters

Phone: +1 800 336 4474
clarivate.com
ipscience.tr.com

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·