Help With New Project? Stamp database.

News items. General trends, new issues, new policies etc. **Whatever** you like. WORLDWIDE. Start a new thread on your question. Please do not discuss ebay in THIS forum as we have a separate and popular Forum for that discussion.

Moderator: Volunteer Moderator Team

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi

Basically a little strange.

The policy I pursue is one of non interference with your computer so no modifying the registry no creation of desktop shortcuts and no start menu items.

So unless you create them they will not exist.

The only thing I can think of is that the .exe file has not been extracted. Windows seems to allow you to run applications from within compressed folders which can produce some weird results. You have a cluster of empty folders one should be 'Databases' check inside that folder you should have some .db files in there the others will be empty until you use them through the application.

You have the .zip file which is good, this needs to be uncompressed.

Create a folder on your hard drive, I call mine 'World Collector'. Copy world Collector.exe from the compressed folder to your new folder. Then run the application from there.

If you want a desktop icon right click on the .exe file and select create shortcut, this creates a small shortcut file in the same folder. You can then place the shortcut file onto your desktop.

Please let me know how you get on.

I will fire up my win 10 computer later and try it my self later today.

Kind Regards

CD
get to World Collector here
http://worldcollector.eu/

scmrak
Blue Star less than 5 posts NEWBIE!
Blue Star less than 5 posts NEWBIE!
Posts: 3
Joined: 23 Jan 2020 22:32
Location: Indianapolis, USA

Re: Help With New Project? Stamp database.

Post by scmrak »

Yes, that was exactly it: the executable hadn't been extracted. Ahhh, the wonders of Microsoft. :roll:

Thanks for the reply.

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Good to hear it is working now.

I have tried three or four unzipping applications each gives different results, so after pulling out a little more hair I am writing a small setup application which will unzip all files into the correct place.

The application will be extracted to the users home directory keeping it visible to the user that downloads and installs it. (Not usable by guests).

Regards

CD
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi All

Setup app written not quite up to 400,000 items just yet and migrating help files as well.

The setup exe downloads and extracts the files you need into the correct places so no need for extracting files yourself.

If anyone wants to give it a try just leave a reply here and when I get back I will post the link to the setup file.

Please bear in mind I will be releasing it on the web site as soon as I get above 400,000 items and the help files are substantially done. So you will be testing the app.

Kind regards

CD
get to World Collector here
http://worldcollector.eu/

User avatar
casmx
GOLD Star Super Posting Stampboarder!
GOLD Star Super Posting Stampboarder!
Posts: 316
Joined: 12 May 2019 09:28
Location: Brisbane, Qld, Australia

Re: Help With New Project? Stamp database.

Post by casmx »

Hi CollectorDave. Trying to get hold of you.

What is the best way to add a new country. eg: Chad.

Can seem to find an easy way to do it. Without destroying an existing country. I have SQL LITE.

Thanks CasMx.

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi casmx

Be careful with sqlite.

The database is optimized for allowing multiple sorts none of which are in the Postage Stamp.db

To keep the DB consistent I have not programmed any tools to allow users to add new countries etc.

That said, thanks for pointing out that Chad is missing!

I will add Chad ASAP and upload an updated database.

I have also written a small help program so you can modify the country data and upload the modifications for me to add to the main database.

Once I have Chad in I will respond here.

Kind Regards

CD
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi casmx

Chad added to main database will set uploads etc later today or tomorrow.

I have added the first few stamps to this as well.

The csv file can be downloaded here https://www.mediafire.com/file/kzddxkut350wtp0/Chad.csv/file

Just a few dos and don'ts

Do not be tempted to change the order of the entries.

Do not delete anything in the StampID or catalogue Number columns.

When adding stamps ignore these two columns do not enter any catalogue numbers as they will be lost.

After the file is imported you can add catalog numbers from your favourite catalog and sort them any way you wish.

Do add any new stamp data below the last entry using the column headers as a guide.

I am following the Stampworld catalogue for these entries to some extent.

After you have added a few more let me know here and I will post a link so you can upload the new Chad.CSV file for inclusion.

Note for all. If you notice any other country I have missed please let me know and I can get it included.

Kind regards

collector dave
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Chad now added up to the 1980's will add more over the following weeks wife and time permitting.

Adding a digital perforation guide to the application as well which will be released with version 10.2.
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi All

Got a little sidetracked.

I have now added an AlbumEasy export function to the World Collector application.

When building an album you can now use it as it is or export to AlbumEasy format for further editing.

The file output is in the form of a folder which holds any images assigned as well as the AlbumEasy text file.

The text file itself has each page split with some white space to make editing easier.

Just waiting to see what collectors think of the new export so here is a link to one just done:

http://www.mediafire.com/file/oc1chp6hz6fzyd4/France.zip/file

If you use AlbumEasy unzip the file and it contains the txt file and images.

Please try it and let me know of any improvements that could be made.

Anyone with an Apple computer can also have the latest version now 10.3 just leave me message and I will send back a download link. Do not use the main web page.

The windows version will follow later.

regards

CD
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

World Collector now supports the export of AlbumEasy files.

My intention is to create an album for every country in the database, the first few are done and are available here. http://stampcollector.epizy.com/AlbumEasy.html

These should give anyone using AlbumEasy a good start.

Of course the albums stop where I run out of stamp sizes. If you can help and use an Apple mac I can export a small spreadsheet for the year and country you can help with and link to a small application so you can upload the edit spreadsheet.

The more size information I get the more complete the albums will become I will update the webpage when I add more pages and or albums.

Regards

CD
get to World Collector here
http://worldcollector.eu/

User avatar
collectordave
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 178
Joined: 21 Mar 2015 16:46
Location: Tomar, Portugal

Re: Help With New Project? Stamp database.

Post by collectordave »

Hi all,


As I am running through the database producing albums where I find myself short of size information stops some of them prematurely.

To help with this I have created a help page on the website, basically if you can help fill in some of the blanks I am creating a series of CSV files which you can download and then there is a link to upload them after adding the size data.

you can go directly to this page here. http://stampcollector.epizy.com/Helping.html

Thanks In Advance for anyone who helps.

Cd
get to World Collector here
http://worldcollector.eu/

Post Reply

Return to “Discuss stamps - and *anything* at ALL happening with stamps”

Who is online

Users browsing this forum: Allanswood, Anita, Cullen, Google [Bot], mobbor and 10 guests