Import Citavi quotations
Dear all,
I tried to import my Citavi-based library to Zotero, and all went smoothly, except that I haven't found a way to import the quotations from Citavi as well. The abstracts did export, but not one quotation.
Is a direct export possible? If so, could you explain how to proceed? That would be grant!
Cheers!
I tried to import my Citavi-based library to Zotero, and all went smoothly, except that I haven't found a way to import the quotations from Citavi as well. The abstracts did export, but not one quotation.
Is a direct export possible? If so, could you explain how to proceed? That would be grant!
Cheers!
Open it with a text editor and see if the quotations are in there. If they are we can likely do something from the Zotero side, otherwise you'll need to find a way to get that data out of Citavi first.
I don't think we'll write a direct export from Citavi's database (which I believe is MS Access based?) but there may be other ways.
Find out from Citavi if the quotation info is in any export they provide.
Well, I use Citavi Version 2.5 and that one supports exports into BibTeX, RIS, Endnote and Endnote Tagged Import Format.
I tried all three with the same result: no quotations were exported. Indeed, when I open the files (BibTeX, RIS etc.) with a text editor, the quotations are not present.
I will get in touch with the Citavi people, ask what can be done and post their reply here.
That worked indeed, but now I'm stuck: I do see all the data, but everything in different tables, some containing all the book titles, others all the authors, etc. And one chart also contains all the quotations. But how can I make Zotero import that and link it accordingly?
Any help is appreciated.
If anyone reads this and knows how to proceed with the code (i.e. using the .mdb-file to import into Zotero), please revive this thread! I presume that quite a few people might be interested in that.
One reason is that otherwise you're essentially hostage to that company.
The other reason is that Citavi is run by a small company that has already miscalculated once when they put all their money on Windows and now are basically shut out of the increasingly important Mac market. There is no guarantee that they'll be around in 10 or 20 years. And what then? (There is no guarantee that Zotero will be around in 20 years, either, of course, but Zotero data is _much_ more portable).
From what I have gathered, Citavi is basically two programmes rolled into one: A bibliography manager quite like Zotero, and a knowledge management software (that's the part where the quotations are). They linked these two quite nicely together in their software, but the downside is that their bibliographies use .bib or .ris formats, while the knowledge management is MS-Access-based. Being quite unfamiliar with both of these formats, I simply do not know how to proceed to bring the latter into a form that can be read by Zotero (or any other bibliography manager, for that matter), e.g. converting it into notes attached to the item. Citavi support told me that there simply is no field in the .bib or .ris-files to export this kind of data.
Or maybe, by using Access, I could somehow create a whole new sqlite-database from the .mdb-file and then somehow merge that with the Zotero-database that already contains some items, but as mentioned, with my limited knowledge of Access, I am simply stuck here.
Many thanks!
to import my Citavi library (from Citavi 4 on a Mac), but am then told that Zotero (latest version on a Mac) cannot import the file format. Do you know what might be the problem?
Many thanks!
Sina
SQLite format 3@ Ç Œ ÕWÇ-‚'.ù˚ˆÒÏÁ‚›ÿ”Œ…ƒø∫µ∞´¶°úóíçàÉ~ytoje`[VQLGB=83.)$autoindex_CategoryCategory_1CategoryCategoryÑz!--âtableCategoryCategoryCREATE TABLE Category (ID TEXT CONSTRAINT PK_Category PRIMARY KEY, CreatedBy TEXT, CreatedByCitaviId TEXT, CreatedBySid TEXT, CreatedOn DATETIME, ModifiedBy TEXT, ModifiedByCitaviId TEXT, ModifiedBySid TEXT, ModifiedOn DATETúqõpôoónñlïkîjìiíhêgåeàbÑ_Ä\|YxVsSnOiKfGcE`C\AX>S;Q7N5K2F1A-<)7%2!,(%"! :fi ä˚ˆÒÏÁ‚›ÿ”Œ…ƒø∫µ∞´¶°úóíçàÉ~ytoje`[VQLGB=83.)$¸˜ÚÌË„fiÇ}ÅÅEYÅEYEba4b2ba4-616f-4338-8086-55816ba55f23sS-1-5-21-4112557996-2536214275-1069032519-100
https://gist.github.com/zuphilip/02d6478ace4636e4e090e348443c551e
But I'm just seeing that this may require Citavi 5 upwards, so it's possible this won't work with Citavi 4 -- @zuphilip do you happen to know?
Any clue what this might be?
unzip [File].ctv5bak
Thanks!!
Like dstillman I didn't see that option so I did what he said.
The result was:
MacBook-Air:~ sina$ cd filename.ctv5bak
-bash: cd: filename.ctv5bak: Not a directory
MacBook-Air:~ sina$ unzip filename.ctv5bak
Archive: filename.ctv5bak
inflating: firsthalfoffilename.ctv5
MacBook-Air:~ sina$
But no new files showed up at the original location.
:) Thanks!
It indeed got me one step further - but unfortunately only that:
So I repeated the same thing with the Folder now, then unzipped the file, and indeed a new file *.ctv5 was created at the same location. When I imported this file in Zotero, it didn't complain about the format, created a library with the accurate name but then reported a problem, asking me to check whether the file was correct and try again.
Who can help me get to the next level? (Thanks so much in advance!)
<?xml version="1.0" encoding="utf-8"?>
<CitaviExchangeData Version="5.7.0.0" FilePath="C:\Users\SFB700IT\Documents\Citavi 5\Projects\PhD - nothing less\PhD - nothing less.ctv5" Changeset="0">
<ProjectSettings>
<AutoSave>true</AutoSave>
<AttachmentsFolderPath></AttachmentsFolderPath>
<CacheId>ecac1e1f-12e8-4671-b8ed-5d181cec8dc5</CacheId>
<ColorScheme>Blue</ColorScheme>
<CustomFields>
<CustomFieldSettings>
<CompareType>Text</CompareType>
<DefaultValue />
<DropDownStyle>None</DropDownStyle>
<PropertyName>CustomField1</PropertyName>
</CustomFieldSettings>
<CustomFieldSettings>
<CompareType>Text</CompareType>
<DefaultValue />
<DropDownStyle>None</DropDownStyle>
<PropertyName>CustomField2</PropertyName>
it goes on similarly for a while, then:
<DropDownStyle>None</DropDownStyle>
<PropertyName>CustomField9</PropertyName>
</CustomFieldSettings>
</CustomFields>
<Description><![CDATA[]]></Description>
<LastChangeTime>20.11.2017 22:36:48</LastChangeTime>
<OptimizeForSlowDatabaseAccess>Auto</OptimizeForSlowDatabaseAccess>
</ProjectSettings>
<ProjectUserSettings>
<ActiveCategoryId>32198d4b-2bef-4510-ab06-c883d1279dd3</ActiveCategoryId>
<CitationStyleId>57394559-20d9-4787-baea-74728dae6742</CitationStyleId>
<DefaultLocations>
<DefaultLocation>bf009114-e2cb-46bc-b486-cffea797398d|47e9a6b5-2a06-42b5-aaf2-47fca8d5cbbd</DefaultLocation>
<DefaultLocation>ad338421-e1e8-407f-a899-119ddb1d00c6|9d90092a-1e92-4479-b0cf-eec6abaa62ee</DefaultLocation>
and so forth...
Fehler _ Ein Fehler ist aufgetreten beim Importieren der ausgewählten Datei. Bitte überprüfen Sie, ob die Datei korrekt ist und versuchen Sie es erneut.
Thanks!!! I am very curious now :)
@zuphilip can you tell if the Citavi XML looks right?