Moderators: richierich, ua900, PanAm_DC10, hOMSaR

 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

Spotterbase

Thu Mar 10, 2016 7:06 pm

Greetings mortals!

As this might be helpful to some of you, I just wanted introduce you to a program I created and I want to share with other spotters.

I started this project in November 2012 as I wanted a better solution organising my planespotting photos.
As I wanted to learn about software development anyway, I thought: Lets try it myself! (Learning by doing)
After some time the first version was done which had some basic functions. Many friends liked it very much so I added more and more functions and it became a pretty nice program.

Here a quick overview:

  • Simple addition of new data through an "auto-fill" function.
  • Statistics for example number of distinct registrations, aircraft, airlines etc. Top 10 Airlines, Aircraft, Airlines etc.; Overview of the the last years and nice pie charts!
    z.B. Anzahl verschiedener Registrierungen, Airlines usw.; Top10 Airlines, Aircraft, Airlines; Übersicht über die aktivsten Monate / letzten Jahre und nette Torten-Diagramme etc.
  • Flexible filter function
  • Three different ways to match your photos to your data.
  • Trips: Bundle Dates/Airports to “Trips” => Statistics (number of new registration, airlines...) + Comparison to other trips
  • Auto Back-Up (just to make sure)
  • Simple synchronisation with other computers.
  • Load your photo directly into your editing software. (if you notice anything which needs correction for example)
  • Export-Function: Export your data as TXT, CSV or HTML.
  • Updates with new functions from time to time.
Download available: www.spotterbase.eu
The program is free. Of course, donations are very welcome but no one should be forced to that.
If you have happy and don't have any financial struggles, I would be very happy about your support as I am doing this beside my study and invested a lot of time and keep investing.
If you have any ideas or wishes, feel free to contact me and I will see how/if I can build it in.

http://spotterbase.eu/img/home/back2.png

Thank you and have a great weekend!

Regards,
Nicolas
 
User avatar
airkas1
Posts: 7904
Joined: Sat Dec 20, 2003 7:01 am

RE: Spotterbase

Thu Mar 10, 2016 10:31 pm

That looks pretty cool! Well done!
 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

RE: Spotterbase

Fri Mar 11, 2016 4:39 pm

Thank you very much. Happy to hear that.
 
User avatar
dvincent
Posts: 1593
Joined: Mon Jan 01, 2007 9:53 am

RE: Spotterbase

Fri Mar 11, 2016 9:44 pm

Well done! Now we just need to get an iOS port and cloud/dropbox integration so we can have it everywhere on the go. Save that for version 2.0.  
 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

RE: Spotterbase

Fri Mar 11, 2016 9:54 pm

Hehe yea. There might will be an online version but we will se waht the future holds... and how many people actually are interested in it.
 
User avatar
ihsanushshabri
Posts: 14
Joined: Mon Nov 17, 2014 12:36 pm

RE: Spotterbase

Sat Mar 12, 2016 9:33 am

great tools bro, downloaded, really helpfull
 
User avatar
kulverstukas
Posts: 1101
Joined: Wed Jan 02, 2013 11:58 am

RE: Spotterbase

Sat Mar 12, 2016 9:34 am

Can you add russianplanes.net as a source of information?
 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

RE: Spotterbase

Sat Mar 12, 2016 11:31 am

Happy to hear that.

I will try to add russianplanes.net i the next update in a few days. Shouldnt be a problem.
But only on the same level as Airframes org etc.

As the automatic auto-fill needs the agreement with the website.
 
dcaviation
Posts: 487
Joined: Thu Aug 25, 2011 12:26 am

RE: Spotterbase

Sat Mar 12, 2016 6:40 pm

Can you import data to your database?
 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

RE: Spotterbase

Sat Mar 12, 2016 6:55 pm

The database file is the mainbase.accdb
You can open it with some programs, for example MS Access or (free) MDB Plus. (just google it)

You can import data. Just make sure no double IDs, and the format of the airports are similar. Otherwise I can't gurantee that there wont be any problem.

Contact me via email (info on website) if you need any more help.
 
User avatar
Bruce
Posts: 4951
Joined: Tue May 18, 1999 2:46 am

RE: Spotterbase

Fri Mar 18, 2016 7:02 am

I am getting errors when I try to add an entry - Unhandled Exception. I tried to use the reporting feature on the Testing window but I got an error there too - protocal violation. So I can copy & paste the data from the error box on the Unhandled Exception here:

************** Exception Text **************
System.Data.OleDb.OleDbException (0x80040E07): Data type mismatch in criteria expression.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Spotterbase.Form1.rgcmdadd_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Spotterbase
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/Bruce/Desktop/spotterbase/Spotterbase/Spotterbase.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1068.2 built by: NETFXREL3STAGE
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1067.0 built by: NETFXREL3STAGE
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Windows.Forms.DataVisualization
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.DataVisualization/v4.0_4.0.0.0__31bf3856ad364e35/System.Windows.Forms.DataVisualization.dll
----------------------------------------
System.DirectoryServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.DirectoryServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.mshtml
Assembly Version: 7.0.3300.0
Win32 Version: 7.0.3300.0
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
 
nicolasxp
Topic Author
Posts: 7
Joined: Thu Nov 25, 2010 7:13 pm

RE: Spotterbase

Fri Mar 18, 2016 12:21 pm

I will send you an e-mail for support. Don't want to fill this thread with personal troubleshooting.  
 
dreamflight
Posts: 118
Joined: Sat Jan 22, 2005 5:56 pm

RE: Spotterbase

Mon Mar 28, 2016 2:31 pm

Great idea - Also looking for the iOS port - I hope you go for this challenge  
 
User avatar
reffado
Posts: 563
Joined: Fri Feb 03, 2012 12:47 am

RE: Spotterbase

Sun Apr 10, 2016 6:18 am

I am, for the first time, sad that I have a Mac and not a PC. Looks like great software!

Who is online

Users browsing this forum: No registered users and 10 guests

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos