How can I improve the processing speed?
One2OneMileage has been written to take advantage of modern multi-core processors. However, some of this speed depends on a correct configuration. Here are some suggestions for speed:
•Make sure your database has a correctly defined index on the primary key (often called 'UID'). Note that indexes cannot be applied to Excel workbooks. Large datasets should be implemented using a proper relational database using Microsoft Access or via an ODBC connection.
•Try to run the database locally. The database is usually the bottleneck, so make sure all communications to it are fast, and the database is fast.
•Remove duplicate rows from the input data.
•Use a solid state drive (SSD) for the road pack, and the database. The database is the main bottleneck. Most of the road pack is stored in memory, but some of the indexes have to be kept on disk due to their size. A SSD will ensure they are read quickly.
One2One does not want to write numeric values to Excel
All output values, regardless of the database, are written in the format of the data field. Unlike a true relational database, Excel is weakly typed. Therefore it is possible for a cell or column to appear to be blank or un-typed, but Excel reports it as being text.
The solution is to clear the entire column, and then format it as a number with two decimal places. You may have to re-enter the column header (if there is one).
One2OneMileage does not recognize the Excel columns that store my location names
This usually occurs if your location names are numbers. Location names are often numbers if you are using your own numeric identifiers, or if you are using zipcodes. Excel is weakly-typed and will usually treat these as numbers. However, the locations must be text for One2OneMileage to recognize them properly.
It is strongly recommended that you use use a proper strongly-typed database (e.g. Access or an ODBC connection) for applications like this. However, if you must use Excel, format the entire column as text and precede each and every value with a quote (') character. The quote character tells Excel that the field is text and not a number. An alternative is to use text location names.
I cannot open my Excel workbook when One2OneMileage is loaded
This is a side-effect of the Excel database driver. You have to exit One2OneMileage in order to view the workbook. This is another reason to switch to a proper database such as Access.
One2OneMileage opens a table but cannot see any/all of the columns
One2OneMileage must have read/write access to both the table and the columns. This is also true for the location columns. The only exception is the primary key column, which can be read-only.