UPDATE images SET id = 1003 WHERE rowid = 3 UPDATE coins SET image = 1003 WHERE rowid = 3
UPDATE images SET id = 1002 WHERE rowid = 2 UPDATE coins SET image = 1002 WHERE rowid = 2 UPDATE images SET id = 1001 WHERE rowid = 1 UPDATE coins SET image = 1001 WHERE rowid = 1 This generates a text file that looks like Run this and redirect the output to afile, let's call it sqlcommands. J =$ (( 1000 + $i )) echo "UPDATE coins SET image=$j WHERE rowid=$i " echo "UPDATE images SET id=$j WHERE rowid=$i " done #!/bin/bash for i in # replace 138 with the highest id do Here is a bash script that accomplishesthe task. Let's create a text filecontaining the sqlite commands first. So to avoid this, let's modify the id of images in the database for commemorative coins. However, we see that the id's of images in both tables start from 1!Which means overwrap, thus conflict. Similarly there is no problem for the id's ofphotos. In our case, we have id's in table 'coins' ranging from1 to 138 in the database for commemorative coins, from 282 to 561 in the databse for standard coins.
#Opennumismat software
You can easily visualize this using a software like SQlitebrowser. First let's make sure there is no overwrapping id's ofcoins and photos. Probably you should take a copy of your databasesbefore trying to merge the databases, unless you are trying to merge freshlydownloaded databases. Fortunately for us, there is no overlap between the id numbers of the tables 'coins' and 'photos' of two databases, which allows us to simply mergethe tables 'coins' and 'photos', but if you happen to have databases with overlapping id in tables 'coins' and 'photos', you should be able to work outa method similar to what I will describe below. The entry 'image' in the table 'coins' corresponds to the entry 'id'in the table 'image', and the entries 'obverseimg','reverseimg','edgeimg','photo1','photo2','photo3' and 'phto4' correspond to the entry 'id' in the tablephoto. The entries of all these fieldsare integers. The two other tables store the images,and the only field that concernes us is the 'id'. The fields that concern us are 'id','image','obverseimg','reverseimg','edgeimg','photo1','photo2','photo3' and 'phto4'. Basically the databases 'coins' contain everything about coins. We are particularly interested in three databases coins, images andphotos. Presumably the table sqlite_sequencecontains crucial information for merging tables, but we can ignore it, at leastfor the sake of merging standard euro coins database and commemorative euro coinsdatabase. An OpenNumismat database contains 10 tables of which I still haven't figured out use of all.
#Opennumismat download
Now, they onlyoffer for the download separate databases for standard coins and euro coins.This means that if I encounter a 2 euro coin that I have never seen, I will haveto consult the two databases, and currently the only way to do is to open the twoone after another (and when I open the second, I close the first).īefore I can explain how I managed to merge databases, I need to describe what isin the OpenNumismat databases. So why is this a problem? Well, I would like to see the collection of standardeuro coins and the commemorative euro coins at the same time. But unfortunately, the current version (as of August 19th, 2014) doesn'tallow us to merge several databases. It also comes withsome databases, so that we don't have to create them from zero by hand. * Importing from CoinsCollector, Numizmat 2, Cabinet, CoinManage 2011, 2013, 2015, Collection Studio 3.OpenNumismat is a niceapplication that allows us to organize our coin collections. * Does not require additional software to work with a database * Ability to add and customize the lists to display the required data * Duplication of coins to quickly add a similar coin * Export customized lists as MS Excel, HTML and CSV * Generate and print reports, saving as HTML, PDF, MS Word * The grouping, filters and sorting to facilitate the retrieval of coins in the catalog * Up to 7 photos coins (insert image from file, clipboard, download from the Web at URL) * More than 60 customizable fields to describe the coin With OpenNumismat, you will be able to organize and manage coin collection: create an advanced catalogue of your coins, wish and selling lists, view statistics for your collection. OpenNumismat is a free, open-source coin collecting software.
#Opennumismat free
OpenNumismat - A free coin collecting software for organize and manage your own catalogue
0 kommentar(er)
