Data Manipulation:
The screen looks like this:
|
This screen allows a manipulation of the information in the database. The database has a number of so called tables of information, very much like a spreadsheet of rows and columns. There is a number of tables. The most important is the visits table that contains all the information about your visits to clients, vehicle changes, vehicle costs and toll gates. Second to this is the locations (waypoints) table with the client locations. Then there are the vehicle, clients info, tracks, notes and toll positions tables. |
There is five sections:
- Choose Options Here you choose the table you want to do an action on.
- Backup or Restore Location The place where want to backup to or restore from.
- File Type Select the file type you want to create, or restore from
- Options The only option is whether you want to add a time stamp to the name of the file that you want to backup. This makes it easier to find files later.
- The buttons After you made the above selections; you choose the action you want to perform with the above selections.
WARNING: Not all combinations of selections make sense.
- Waypoints or locations can be exported in CSV or GPX (XML) format. It can also be imported from a CSV or KML (XML) file. Before you try and import waypoints, create a few waypoints, export them and look at the format. The format is special especially as far as the client name and position is concerned. With the import of the KML file it is imperative that the format is CLIENT : POSITION If it is not, the application will reject it or worse, crash.
- Vehicle information is exported or imported as a CSV file.
- Tracks can only be exported. It is exported as GPX file which is a XML file type capable to be read by Google Earth. The application will ask for a start and end date. It will then generate the tracks from the first visit it finds for the start day and the tracks will be named the name of the visit i.e. the client's name. Tracks generate a huge amount of information, and it is necessary to export the tracks and clean it up on a regular basis, otherwise the data may become difficult to handle.
- Database The database is meant as the complete database with all the tables. If you are creating tracks, the database will be become huge very quickly. It will take a long time for it to backed-up or restored. All the other information together is much smaller than the tracks.
- Visits All the data of all the visits, toll gate visits, vehicle changes and vehicle costs are saved in this table. You can create a CSV file with partial information of this table. It can also be restored. The most important function here is to generate reports of your visits. I only do this once a month to invoice. Others will do this on a daily basis. The important thing is that that the application will ask for a start and end date for this report. The report will be generated by client. Here you have the choice of generating a CSV, XML or IIF file. Currently the IIF report is a work in progress. Different formats will be added here on request provided that the information about the format is available without cost and that help is available if difficulty arise. IMPORTANT: The application cannot take care of all types of eventualities as far as a visit is concerned. It is important that you check the data coming out of this report. This report uses information in the clients table to generate values. It does not take care of after hours work or Sunday work. The number of possibilities is huge, so your accounting system will need to take care of that.
- Clients You can export you client data or import it. There should be a record of every "CLIENT : POSITION" pair. It is very convenient to generate at least one client, export this information to see how this data looks like in a CSV file, and then to use the information from your waypoints report to generate the rest of all your other client information. This file can then be imported.
- Toll This will eihter allow you to import toll gate information or produce a report on vehicle cost and/or a TAX report of distance driven in a CSV format. The optional field in the client's table can here be used to distinguish between private and business use of your vehicles.
- Notes This will create a CSV file from the notes table.
The
Backup Location can at this moment in time be
Ftp,
Http, File and Mail. File is the default, and as a matter of fact, a file is first produced before it is uploaded to a server.
You can connect your android device to a computer and then copy the file/report to your computer. The files can be saved on your computer or changed and then be copied back to your android device. The data can then be restored. At this moment in time, the application does not allow data files to be restored / imported directly from a FTP or HTTP connection. You first need to download the file and the restore/import it. The mail option is meant to send reports conveniently to your computer for processing there. It is not really intended for backup purposes, but you could use it provided the database size is not too big for your mail systems maximum file size limit. No mail option exists for downloading files. The information required to upload and download files to the FTP and HTTP servers, needs to be entered in the setup part of this application.
With every file uploaded you have the option of adding a date stamp to the filename created by checking the Add Date Stamp option.
|
After you made your selection of what you want to backup/export, tapping this button will do the operation. If you selected FTP, Mail or HTTP, the file will also be transferred to the required destination. |
|
This will restore/import a file from the downloads folder of the device depending on your selections. If you restore the complete database, the application will lock. You first need to exit the program completely and restart it for save operation. Restoring/importing waypoints will also not take effect until you restart the application. |
|
Very much the same as backup, except that reports are generated where applicable. |
|
This will upload files in the downloads folder to a server with FTP, Email of HTTP protocol. |
|
You can download files from your FTP or HTTP server that was previously uploaded, and then restore/import them. |
There are two functions that is only available from the menu, that is to purge tracks and to delete visits. From the menu, you will find it under Maintenance. The visits table is small and can be kept for years without any problems. The track information grows at a tremendous rate because it records a position every second. Tracks are not recorded when you are at a valid location. Tracks should be uploaded to a server and purged on a regular basis.