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.
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 or Access database when One2OneMileage is loaded
This is a side-effect of the Office drivers. You may have to exit One2OneMileage in order to view the workbook or database. The solution is to switch to a proper relational database such as SQL Server.
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.