Bulk change author names/journal titles/year/date etc.

Alex B. shared this question 2 months ago
Answered

Could you please introduce a method to bulk change author names/journal titles/year/date etc.? I have many scanned newspaper articles and bulk changing those would spare me days of work. Is their any method to do this? Otherwise such a funtion would be great, just as the already existing bulk change reference type function.

Comments (5)

photo
1

Hi, Alex

You can already do this for some fields (the plain text ones) via References > Search and replace. This'll work for Year and Date, but not for author names and journal titles as they are kept in separate lists. For these it's probably easiest to merge them via the Lists menu. Could you please describe your requirements in a little more detail? I might have a macro in store that does exactly what you need.

Best regards

Sebastian

photo
1

Hello!

I do not understand yet how to change year and date via References > Search and replace when it can't be done automatically. I need to select the references in question manually and want to bulk change year, date, journal name etc. one after another. Search and replace won't do it because it would also change other references I don't want to change, right?

Neither do I understand how to use the merge function in the lists menu. I need to bulk change the journal names of many dozens of references all of them being from one particular journal.

photo
1

Hi, Alex

The search/replace feature always refers to the current selection of references. This enables you e.g. to fill blank fields by searching for RX_^$ (that's the regular expression syntax for fields that have nothing in them between their start and end) and replacing with the value you'd like to set for any given selection of references.

If many dozens of references have the same journal name you'd like to change, you don't need to change each of the references but the journal name itself that can be accessed through Lists > Periodicals. The references will then show the updated periodical name. If you have variant spellings of the same periodical, you can merge them in the same menu.

Best regards

Sebastian

photo
1

Hello!

To specify the problem, which hasn't been covered yet in the above cases:

Say, we have 50 digitized newspaper pages from one particular newspaper. When you add them in Citavi, all of them by default get the label "Journal Article" as reference type. All the other fields are empty.

Now I need to give all those references the correct reference type (Newspaper Article). And I need to give them the same newspaper title.

Bulk changing the reference type is easy. No problem. Bulk changing/inputting a newspaper title still won't work. The RX_^$ search didn't work, neither the List menu.

photo
1

Hello, Alex,

there are basically two ways of achieving this end. One is creating a "template" reference before adding the PDFs with all the information that doesn't change and the adding the PDFs to each of these duplicates in turn.

The other is the Citavi macro editor. A skeleton method is already ready when you open it with a "foreach" loop that affects every reference in your current selection.

You can there assign values to different properties of the Reference object, e.g.

reference.ReferenceType = ReferenceType.NewspaperArticle;
When you run the macro this'll change the reference type of all references in your selection. You can have a look at the other properties by tying reference in a new line and a full stop. The menu will show avaialble methods and properties. Note that some properties are read only.

Best regards

Sebastian

photo