Tag: MPG
Gasmate RC .42b
by Daniel on Aug.07, 2009, under GasMate
This is just a quick bugfix for those of you with square screens. Ed Thompson found the bug where square screens were not displaying correctly. I had set anchors when I shouldn’t have, and it should now be fixed. In doing this, I also fixed the landscape(rotation) bug.
Cab: http://www.lulzsoft.com/installers/gasmate_rc.42b.CAB
.Net CF 3.5 https://www.lulzsoft.com/wordpress/2009/08/07/net-cf-3-5-cab/
SQLCE: https://www.lulzsoft.com/wordpress/2009/06/07/sqlce-cab-files-for-ppcs/
Errors
by Daniel on Aug.03, 2009, under GasMate
As I have opted to respond by email to errors posted, I thought I would give an overview of what certain errors mean, and what to do about them.
If you do not have SQLCE installed, you will get this error:
Gasmate.exe
MissingMethodException
File or assembly name
’system.data.sqlserverce,
version=3.5.0.0 culture=neutral,
publickeytoken=3be235df1c8da2d3′,
or one of its dependencies, was not
found.
The solution to this is to install the SQLCE cabs I have hosted or download it from Microsoft.
If you have an old version of GasMate, you might get an error similar to this:
GasMate.exe
SqlCeException
[ cost ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResult s(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryP lan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteComman d(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader (CommandBehavior behavior)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbData Reader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at GasMate.GasMateDataSetTableAdapters.maintTableAdap ter.Fill(maintDataTable dataTable)
at GasMate.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form._SetVisibleNotify(Boolea n fVis)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.Run(Form fm)
at GasMate.Program.Main()
The solution to this is to either delete the database, or export your data and modify it to re-import it.
If you have a smartphone(WM Standard), you will get this error:
NotSupportedException
at
Microsoft.AGL.Common.MISC.HandleAR(PAL_ERROR.ar)
at
System.Windows.Forms.Control._InitInstance(WNT wnt, UInt32 dwStyle)
at
System.Windows.Forms.Control..ctor(WNT wnt)
at
System.Windows.Forms.TabControl.ctor()
at GasMate.Form1.InitializeComponent()
at GasMate.Form1..ctor()
at GasMate.Program.Main()
Unfortunately at this time, WM Standard does not support some of the form elements I am using in GasMate. Later on there is the possibility of a fork that will work on WM Standard.
GasMate RC .41b
by Daniel on Jul.25, 2009, under GasMate
This is a bugfix version with a few features added:
- Decimal separator is now pulled from localization info
- Dollar sign($) is also pulled from localization info
- Last gas type used is remembered
- Added an extra digit to gals and price
- CAB file is now compressed to make it smaller, I will work on the EXE’s next
Grab it here: http://www.lulzsoft.com/installers/gasmate_rc.41b.CAB
GasMate Beta .26b
by Daniel on Jun.25, 2009, under GasMate
PLEASE NOTE – THERE ARE SPECIAL INSTRUCTIONS FOR UPDATING!!!!!!!
For those of you who have an old version(not this one) of GasMate you must follow the instructions in order to upgrade to the new version. I have made a change to the database(added cost in maintenance table) and therefore you must export the data and re-import it.
- Export your current data that is in GasMate.
- Open the CSV file in a text editor(openoffice/excel break it by adding/removing quotes) and make the following change:
Change: M,”234″,”Oil Change”,”2009-06-25 21:32:57″,”notes”
To: M,”234″,”Oil Change”,”2009-06-25 21:32:57″,”COST”,”Notes”
where cost must be a number
PLEASE NOTE!!!!!!!!!!!!!!
I have used quotes for the data to make sure nothing bad happens. The quotes are ONLY on the data, and not on the headers. Adding or changing the quote format WILL break stuff. - Go to the directory where GasMate is installed(Program Files/GasMate) and delete the file GASMATE.SDF (database).
- Download the new cab
- Install the new cab
- Import the old data(modified csv) into GasMate
If you do not wish to keep your data, you can just delete the sdf file then install the new version.
If you do not have GasMate installed, you do not need to worry about this.
As always, .NET CF3.5 and SQLCE are required.
-Daniel
GasMate Beta .25c
by Daniel on Jun.21, 2009, under GasMate
Ok everyone…..import is working! However, I have changed the format slightly to make this easier to parse, so exports must be done from this version or higher to be re-imported. They will NOT overwrite current entries, but if there is a match a message will come up and it will not be entered. The format for the CSV is as follows:
======
Export from GasMate Beta .25b
,Date,ODO,Gallons,Price/Gal,Fuel Type,Total Cost,MPG,Gal/100mi
G,”2009-06-21 12:43:53″,”2345234″,”23″,”23″,”Premium(91)”,”529″,”First”,”First”
,ODO,Work Done,Date,Notes,
M,”23423″,”Oil Change”,”2009-06-21 12:43:53″,”notes lulz”
==========
The G and M in front tell the program that it is a gas or maint row. The last two values in the gas table are NOT necessary in that the program calculates them when it runs, so if you are importing from other data you do not need to worry about them.
Other notes:
- Changed Date format to yyyy-MM-dd HH:mm:ss (fixes bugs when people override date in NLS)
- Added warning before nuking full table
Cab: http://www.lulzsoft.com/installers/gasmate_b.25c.CAB
Please let me know how it works out!
-Daniel
GasMate Beta .24e
by Daniel on Jun.19, 2009, under GasMate
Changelog:
- New update screen with details when there is an update
- Warning before backdated or back-mileage input, but allowed. Don’t be stupid, but I had this before you could delete rows…..so now if something screws up you can just delete the offending row
- Re-disabled import button because it isn’t done…planned for this weekend
Those of you with .24a or b will be able to update right from GasMate.
GasMate Beta .24a
by Daniel on Jun.14, 2009, under GasMate
There is only one major change that I have done in this version…..
INTEGRATED UPDATE!!!!
You can check the box to have it check for updates on every start or you can click the button to manually update.
Cab: http://www.lulzsoft.com/installers/gasmate_b.24a.CAB
-Daniel