CONTAONEPRO00 HELP ver 10.00
1 INTRODUCTION
2 REFERENCE MANUAL
2.1 THE MAIN WINDOW
2.2 THE RECORDS EDITING WINDOWS
2.2.1 THE ACCOUNT RECORDS EDIT WINDOWS INCOMES AND EXPENSES
2.2.2 THE CONTACTS RECORDS EDIT WINDOWS
2.2.3 THE activities RECORDS EDIT WINDOWS
2.3 THE LISTS RECORDS WINDOWS
2.4 THE SELECTION RECORDS WINDOWS
2.4.1 THE SELECTION RECORDS WINDOWS OF THE ACCOUNT TABLES INCOMES AND EXPENSES
2.4.2 THE SELECTION RECORDS WINDOWS OF THE CONTACTS TABLES
2.4.3 THE SELECTION RECORDS WINDOWS OF THE activities TABLES
2.5 THETOTALS WNDOWS
2.5.1 INCOMES OR EXPENSES TOTALS WNDOWS
2.5.2 CONTACTS AND ACTIVITY TOTALS WINDOWS
2.6 THE EXPORT AND IMPORT DATA WINDOWS
2.6.1 THE IMPORT RECORDS WINDOW BETWEEN TWO CONTAONEPRO00 FILES
2.6.2 THE IMPORT RECORDS WINDOW FROM ONE CONTAONE00 FILE TO ONE CONTAONEPRO00 FILE
2.6.3 THE IMPORT RECORDS WINDOW FROM ONE TEXT FILE (100% compatible with microsoft windows, office, words, excel etc.) TO ONE CONTAONEPRO00 FILE
2.6.4 THE EXPORT RECORDS TO TEXT FILE WINDOW (100% compatible with microsoft windows, office, words, excel etc.)
2.7 THE CREATE AND START USING ACCOUNTANCY CONTAONEPRO00 FILES WINDOW
2.8 THE VIEW FILE WINDOW
1 INTRODUCTION
CONTAONEPRO00 is an accountancy personal and professional program. CONTAONE00 stores in a database file the accountancy notes that you insert. You can insert any kind of accountancy note. From the usual personal expenses to the accountancy notes of any economic activity, hobby etc.
The accountancy notes are called records. The records are stored in a SQLlite database file. The file name is micontapro00.db . The file is stored in your phone hard drive. You can copy the file to your pc or to any hard drive. The file is stored in the following directory of your telephone hard disk
"/sdcard/Android/data/contaonepro00/files/micontapro00.db"
Contaonepro00 can work with different accountancies. Each accountancy is stored in one of the files created in the Create accountancy files window. As is further explained, in the Import records window, you can import records between similar tables and consequently between two Contonepro00 files.
CONTAONEPRO00 stores seven account data fields in each record or account annotation. The date, one amount, two optional data fields, the activity, the contact and the explanation.
There are two tables of records. The incomes table and the expenses table. The easier is to use both tables. But you also can use negative values in the amount field, if you prefer to use only one table for incomes and expenses. Usually use the incomes table if you are going to use only one table.
Fields of the account records editing windows incomes and expenses.
The date.
You have to insert the dates in an strict format used commonly in the accountancy. This is YYMMDD . Two digits for the year. Two digits for the month. And two digits for the day. In this order and without separators. For example 111231 (31 of December of the year 2011).
When the program prints the date in any window it will always do it with the standard YYYY-MM-DD . This is with the following format 2011-12-31 (31 of December of the year 2011).
You can use future dates. For example to know when you will have an expense or an income in the future months. You can make a records selection with dates of the next months and know the incomes or expenses you are going to have.
The amounts
The Amount 1 is the main amount. Is the amount used for the calculations and the records selection. In the amounts you can use any currency. But use the same currency or type of annotation in each amount field.
Amount format - Use always the format specified in the Configuration menu of the main window.
Write always the number of decimals specified for each file, in that window.
Examples :
0 decimals - for the number 1,000 introduce 1000
1 decimal - for the number 1,000.0 introduce 10000
2 decimals - for the number 1,000.00 introduce 100000 \n
The amount is inserted always without thousands or millions separators. And without decimals separator.
The Activity
The Activity is a data needed to link the different groups of account records. In the general accountancy are used for the codification of the accounts (like your bank account number) and the description of the codification.
You can use any kind of data that helps you to link groups of account records. For example in a shop accountancy it could be the groups of articles that are for sale. In a home it could be the different types of expenses ( food, clothes, school, transportations, insurances etc.)
You can insert any data in each record. Anyway there is a table in the data base called activities where you can store all the activities for the accountancy. Using the table you will avoid to write the same information each time. Click the Activity button and select one of the options that you have inserted in the activities table before. The text of the activity option will be updated in the Activity field of the account records editing table window.
There are examples for the accounting books activities. One is similar to the US individual Self-employment type (described in the Form 1040-SS). The second is similar to the Spain Self-employment. This activities will be optionally included when creating a new accounting file.
The contact
The contact is a data of a person or entity linked with one account record. This is a name of a person, company or organization etc.
You can insert any data in each record. Anyway there is a table in the data base called CONTACTS where you can store all the contacts for the accountancy. Using the table you will avoid to write the same information each time. Click the Contacts button and select one of the options that you have inserted in the CONTACTS table before. The text of the contacts option will be updated in the Contacts field of the account records editing table window.
The explanation
Is a short comment up to 120 characters. You can insert any information. Try to use as less characters as possible. The less characters you use the fast you will finish. Using the shorter number of characters is also useful to make faster records selections. Record selections are explained later.
Try to use organized memory rules. If you are explaining a food expense. Start with the word food and then the rest of the explanation if needed. If you are inserting an income from a clothes selling of your shop. Start with the word shirt for example and then any explanation if needed.
2 REFERENCE MANUAL
2.1 THE MAIN WINDOW
The main window is the first window you can see. You will find fourteen options.
INCOMES EDIT – Will show the incomes account records edit window.
INCOMES LIST – Will show the incomes account list window.
INCOMES CONTACTS – Will show the contacts records editing windows, related to the incomes table.
INCOMES LIST CONTACTS – Will show the contacts list records window, related to the incomes table.
INCOMES activities – Will show the activities records editing windows, related to the incomes table.
INCOMES LIST activities – Will show the activities list records window, related to the incomes table.
INCOMES TOTALS – Will show the incomes totals window. The totals are calculated summing the value of the Amount 1 field, of each record of the incomes accounts records table that are included in the selection.
EXPENSES EDIT – Will show the expenses account edit window.
EXPENSES LIST – Will show the expenses account list window.
EXPENSES CONTACTS – Will show the contacts records editing windows, related to the table.
EXPENSES LIST CONTACTS – Will show the contacts list records window, related to the table.
EXPENSES activities – Will show the activities records editing windows, related to the table.
EXPENSES LIST activities – Will show the activities list records window, related to the table.
EXPENSES TOTALS – Will show the expenses totals window. The totals are calculated summing the value of the Amount 1 field, of each record of the table expenses that are included in the selection.
2.2 THE RECORD EDITING WINDOWS. INCOMES ACCOUNT RECORDS, INCOMES CONTACTS, INCOMES CONTACTS, INCOMES activities, EXPENSES ACCOUNT RECORDS, EXPENSES CONTACTS AND EXPENSES activities.
All the edition records windows are the same. They will be explained just once. Anyway each window has some differences that are further explained.
In the records edition window you have to insert the information of each record. The edition window shows at the start, all the records of the table. The records are shown in the same order that have been inserted.
When you come from the main window, the last record inserted is the first presented. If you make a records selection with the SELECTOR button. The records will be ordered by the date, name or activity starting from the minor one. The minor record will be presented the first one. The record selections are explained later.
When you make a record selection, only the selected records will be accessible in the editing window. If you want to select all the records again, you can return to the main window and start again the editing window. You can also go back to the selection window and make a new record selection.
ADD BUTTON (RECORDS)
To insert a new record click the button ADD and then complete the fields. When the fields are completed then click always the UPDATE button in order to write the record in the table of the database file.
UPDATE BUTTON (RECORDS)
If you want to change any field of a record. First look for the record in the editing window with the buttons UP and DOWN. If there are many records then you should make a record selection. The less records you have in the selection, the faster you will find the desired record. Once you have find the record change the fields and click the button UPDATE. The new information will be written to the table of the database file. Remember that the UPDATE button is used also to save the new records after clicking the button ADD.
DELETE BUTTON (RECORDS)
If you want to delete a record. First look for the record in the editing window with the buttons UP and DOWN. If there are many records then you should make a record selection. The less records you have in the selection, the faster you will find the desired record. Once you have find the record click the button DELETE . The record will be deleted in the table of the database file.
UP AND DOWN BUTTONS
With this buttons you can move through the records of the table or through the selection of records.
SELECTION BUTTON
The SELECTION button shows you the record selection window. Complete a selection conditions in the selection window. When you come back to the edition window there will be available only the selected records.
2.2.1 THE ACCOUNT RECORDS EDITING WINDOWS INCOMES AND EXPENSES.
Both windows are the same. One for incomes and the other for the expenses. The fields of this windows have been explained in the introduction. If you have any doubt, read again the introduction.
2.2.2 THE CONTACTS RECORDS EDITING WINDOWS.
There are two CONTACTS tables. One for the incomes and one for the expenses.
The contact is a data of a person or entity linked with one account record. This is a name of a person, company or organization etc. You can insert any data in each record.
The fields are well known so it is not necessary to explain them ( Name, Address, Estate, Zip Code, Telephone, Email and Explanation. The Name field is the one used to link the information of this table with each account record of the incomes and expenses tables. When you edit records in one of the account records editing windows (incomes or expenses). Click the Contacts button and select one of the options that you have inserted in the CONTACTS table before. The text of the contacts option will be updated in the Contacts field of the account records editing table window.
In the CONTACTS editing windows menu, there are the options to export and import records from the tel contacts records utility.
2.2.3 THE activities RECORDS EDITING WINDOWS.
There are two activities tables. One for the incomes and one for the expenses.
The Activity is a data needed to link the different groups of account records. In the general accountancy are used for the codification of the accounts (like your bank account number) and the description of the codification.
You can use any kind of data that helps you to link groups of account records. For example in a shop accountancy it could be the groups of articles that are for sale. In a home it could be the different types of expenses ( food, clothes, school, transportations, insurances etc.)
There are two fields in the ACTIVITIES table. The Activity field and the Explanation field. Both of them have been explained before. We will remember that the Explanation field ia short comment up to 120 characters. You can insert any information.
When you edit records in one of the account records editing windows (incomes or expenses). Click the Activity button and select one of the options that you have inserted in the activities table before. The text of the activity option will be updated in the Activity field of the account records editing table window.
2.3 THE RECORD LIST WINDOWS. INCOMES ACCOUNT RECORDS, INCOMES CONTACTS, INCOMES CONTACTS, INCOMES activities, EXPENSES ACCOUNT RECORDS, EXPENSES CONTACTS AND EXPENSES activities.
All the list records windows are the same. They are explained just once. In the list window the records of the each table, are shown in a list one after the other. In the list window, all the records have a field with a number, used by the program as the current number of the record in the database file. After this number you can find the rest of fields of the record.
The MENU button use to be located out of the window of your phone and in the left side. It usually shows a menu symbol. If you don't find the button MENU then look for it because it must be there necessarily. The MENU button will show you an menu with three options.
SELECTION
The SELECTION button shows you the record selection window. Complete a selection conditions in the selection window. When you come back to the edition window there will be available only the selected records.
DELETE ALL THE SELECTION
This option will delete all the records of the selection in the table of the database file. Be careful with this option because it delete many records at the same time. It can even delete all the records of the table if you have not made any selection.
CANCEL
This option will show the MAIN window.
2.4 THE RECORD SELECTION WINDOWS. INCOMES ACCOUNT RECORDS, INCOMES CONTACTS, INCOMES CONTACTS, INCOMES activities, EXPENSES ACCOUNT RECORDS, EXPENSES CONTACTS AND EXPENSES activities.
The records selection window shows all the information and the data fields needed to make a record selection. The record selection windows are launched from the records edit windows, the list windows or the export and import windows.
All the selection records windows are the same. They are explained just once. Anyway each window has some differences that are further explained.
When you click one record selection button, in one of records edit windows, the list windows or the export and import windows. It will be shown one of the records selection window. Depending on the table where we are going to make the selection there will be shown some or some others fields.
In the windows it can be set conditions for a record selection. In a selection you can use all the group of fields, some of them or just one. As you need.
Once you have finished all the conditions for the selection. Click on the button OK to show again the edit windows, the list windows or the export and import windows. The current selection will be in use until you make a different selection or you return to the MAIN window. The button CANCEL finish the record selection without changing the selection that is in use.
2.4.1 THE SELECTION RECORDS WINDOW OF THE INCOMES AND EXPENSES ACCOUNT RECORDS EDIT WINDOWS.
This window shows the following fields in order to set the conditions for a record selection Date, Amount 1, Contact, Activity and Explanation.
DATES
The conditions with dates must specify two dates. First the older one and then the newer one. Both dates could be the same. For example between the 2011 January 01 and the 2011 January 31, this means all the January month of the year 2011. Then in the field
DATE 1 we insert 110101
and in the field
DATE 2 we insert 113101
Now we have the condition by date finished.
AMOUNTS
The conditions with amounts must specify two amounts (only are used for calculations the values of the field Amount 1). First the smaller then the bigger. Both amounts could be the same. For example between 1000 and 2000. Then in the field
AMOUNT A we insert 1000
and in the field
AMOUNT B we insert 2000
Now we have the condition by amount finished.
CONTACT
The conditions by the field Contact must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word Mary, Peter , Tom or any other one in the field Contact. You should insert the used words to set the condition that is used to make the record selection. For example the word Mary , will select all the records with that word included in the words of the field Contact. This means that the selected records could have also other different words in the field Contact.
The Contacts button lets you select one of the options that you have inserted in the CONTACTS table before. The text of the contacts option will be updated in the Contacts field of the account records editing table window.
ACTIVITY
The conditions by the field Activity must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word Food , Clothes or any other one in the field Activity. You should insert the used words to set the condition that is used to make the record selection. For example the word Mary , will select all the records with that word included in the words of the field Activity. This means that the selected records could have also other different words in the field Activity.
The button lets you select one of the options that you have inserted in the ACTIVITY table before. The text of the contacts option will be updated in the field of the account records editing table window.
EXPLANATION
The conditions by the field Explanation must be specified with words or characters. This words or character have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word investments, bank, food or any other one in the field Explanation. You should insert the used words to set the condition that is used to make the record selection. For example the word bank , will select all the record with that word included in the words of the field Explanation. This means that the selected records could have also other different words in the field Explanation.
2.4.2 THE SELECTION RECORDS WINDOW OF THE CONTACTS RECORDS EDIT WINDOWS.
These windows shows the group fields Contact range, Name, Zip code and Explanation, in order to to set the conditions for a record selection.
CONTACT RANGE (NAME FIELD)
The conditions in one contact range must specify two characters or words. First the smaller then the last one (alphabetically). Both letters or words could be the same. For example between the A and the Z . Then in the field
CONTACT 1 we insert A
and in the field
CONTACT 2 we insert Z
Now we have the condition by date finished.
NAME
The conditions by the field Name must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word Mary, Peter , Tom or any other one in the field Name. You should insert the used words to set the condition that is used to make the record selection. For example the word Mary , will select all the records with that word included in the words of the field Name. This means that the selected records could have also other different words in the field Name.
ZIP CODE
The conditions by the Zip code must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. This means that the selected records could have also other different words in the field Explanation.
EXPLANATION
The conditions by the field Explanation must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word investments, bank, food or any other one in the field Explanation. You should insert the used words to set the condition that is used to make the record selection. For example the word bank , will select all the record with that word included in the words of the field Explanation. This means that the selected records could have also other different words in the field Explanation.
2.4.3 THE SELECTION RECORDS WINDOW OF THE activities RECORDS EDIT WINDOWS.
These windows shows the group fields Activity range, Activity and Explanation, in order to to set the conditions for a record selection.
ACTIVITY RANGE
The conditions in one Activity range must specify two characters or words. First the smaller then the last one (alphabetically). Both letters or words could be the same. For example between the A and the Z . Then in the field
ACTIVITY 1 we insert A
and in the field
ACTIVITY 2 we insert Z
Now we have the condition by date finished.
ACTIVITY
The conditions by the field Activity must be specified with words or characters. This words or characters have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word Food , Clothes or any other one in the field Activity. You should insert the used words to set the condition that is used to make the record selection. For example the word Mary , will select all the records with that word included in the words of the field Activity. This means that the selected records could have also other different words in the field Activity.
EXPLANATION
The conditions by the field Explanation must be specified with words or characters. This words or character have necessarily be used previously in the records. Insert those words in the field WORDS with blank spaces between the words. For example if you have used the word investments, bank, food or any other one in the field Explanation. You should insert the used words to set the condition that is used to make the record selection. For example the word bank , will select all the record with that word included in the words of the field Explanation. This means that the selected records could have also other different words in the field Explanation.
2.5 THE TOTALS WNDOWS
2.5.1 INCOMES OR EXPENSES TOTALS WNDOWS
The totals window calculate the sum of the values inserted in the field Amount 1. The total will include the amount of each selected record of the table (incomes or expenses). Both TOTAL windows are the same. They are explained just once. It is also a similar window to the SELECTION window. Because this reason the explanation to make a record selection is the same. If you have any doubt about how selecting records, all the information will be available in the previous section 2.4 THE RECORDS SELECTION WINDOW of this manual. Once you have set the conditions of the record selection click the OK button. The calculate sum of the amounts will be shown in the field TOTAL.
2.5.2 CONTACTS AND ACTIVITY TOTALS WINDOWS
The contacts and activity totals windows have the following particularity. One contacts or activity selection in required (depends on the window). The selection is called range. The range is refereed to the records of the contacts or activity corresponding table. This means that the totals list will include one total for each record of the contact or activity table included in the selected range.
The rest of the selection options (previously explained in the record selection windows) are optional (not required). This options are used in the calculation of the values included in each record or the selected range.
In the totals list windows menu, there are the options to export the corresponding totals list to a text file (with extension .TXT).
Text files are 100% compatible with most of the office programs in the market ( word processors, spread sheets, data bases etc. ) . Specifically there is compatibility with Microsoft Windows programs like Wordpad, Notepad, Word, Excel etc. . Text files are compatible with all the programs of SunMicrosystem Open Office. With most of the Android programs which use text files like Txt Pad lite etc. Usually text files are compatible with Apple.
The text files always finish the name with the extension .TXT (this is a point and the letters TXT). As it is explained as well in the Export file window.
2.6 THE EXPORT AND IMPORT DATA WINDOWS
The directory used to manage files. This is to create contaonepro00 files, export or import data is:
"/sdcard/Android/data/contaonepro00/files/"
Copy the files from and to this directory in order to work with them. When working with contaonepro00. To work with files (copy, move, delete etc.) you can use the Ms Windows file utility or the utility used in the Operative system that you are connected to. To work with files in the telephone you can use the file browser programs from the Android Market. For example the Android program Blackmoon File Browser.
2.6.1 THE IMPORT RECORDS WINDOW BETWEEN TWO CONTAONEPRO00 FILES
In this window it is possible import records between two similar tables. This means between two Contaonepro00 files. The files created in the Files create window can be can be edited as a new independent accountancy. If you need to import data from a file, use this window.
It is important to remember that the accountancy Contaonepro00 files have a name always ending with the extension .DB (one point and the letters DB):
The window is very easy to use. First select the table or tables that you want to import. Set the selection options for each selected table. Select the names of the files (source an target) and click the Import records button. The selection windows have been explained before.
THE IMPORT RECORDS WINDOW OPTIONS
INCLUDE TABLE : ACCOUNT RECORDS, INCOMES CONTACTS, INCOMES CONTACTS, INCOMES activities, EXPENSES ACCOUNT RECORDS, EXPENSES CONTACTS AND EXPENSES activities.
There is a check button for each table (six tables). If it is selected (with a green checker), the records of the selected tables will be imported in the target file. The Select button shows the corresponding record selection window. If you don´t make any record selection, all the records of the table will be imported.
FIELDS TO SET THE SOURCE FILE NAME AND THE TARGET FILE NAME
Specify the file names with the View files utility, further explained. You can also write the name in the field directly. In the View files utility you can select a file or write a file name. Contaonepro00 files have a name always ending with the extension .DB (one point and the letters DB). The information of the source file ( the records selections of each table selected) will be added to the target file. Click the button START IMPORT RECORDS to make the import.
Remember that Contaonepro00 files have a name always ending with the extension .DB (one point and the letters DB)
START IMPORT RECORDS
When you have selected the tables, and made the records selection if needed. When you have set the file names (source and target). Click the button START IMPORT RECORDS and the import of records will start. If there are many records to import, be patient because it takes about one second for each record imported.
2.6.2 THE IMPORT RECORDS WINDOW FROM ONE CONTAONE00 FILE TO ONE CONTAONEPRO00 FILE
This window is for import records from one CONTAONE00 file to one CONTAONEPRO00 file. This window is similar to the last one (2.6.1) just explained. It is possible to set record selections of the tables tha will be imported. It is possible to set one contact, and one activity for all the records that will be imported.
2.6.3 THE IMPORT RECORDS WINDOW FROM ONE TEXT FILE (100% compatible with microsoft windows, office, words, excel etc.) TO ONE CONTAONEPRO00 FILE
This window if for import records from a text file (extension .TXT). Text files are 100% compatible with most of the office programs in the market ( word processors, spread sheets, data bases etc. ) . Specifically there is compatibility with Microsoft Windows programs like Wordpad, Notepad, Word, Excel etc. . Text files are compatible with all the programs of SunMicrosystem Open Office. With most of the Android programs which use text files like Txt Pad lite etc. Usually text files are compatible with Apple.
The text files always finish the name with the extension .TXT (this is a point and the letters TXT). As it is explained as well in the Export file window.
This window is similar to the last two (2.6.1 and 2,6.2) just explained.
THE IMPORT RECORDS TEXT FILES
The text files are used in most of the word process, spread sheets and data base programs of the market. The records included in a text file (with extension .TXT), that will be imported to a contaonepro00 file (witch are data base files with extension .DB) must have one strict format.
Usually the data base and spread sheets programs, export to text files in different formats. The format used in contaonepro00 is named :
Fields separated with tabs (tab character). Records separated with line breaks (new line character).
In Windows programs is normal to add a carriage return (carriage return character) after the line breaks. Which will work too.
The text files have different codifications. Android uses the character codification called Unicode UTF-8. This means that the text files that will be imported in contaonepro00 must have this codification.
Ms Excel or Oracle Open Office spread sheets, export and import text in Unicode UTF-8 format. However actually both of them have bugs (errors). They have little problems with some characters. When this happens it is necessary to open the text file with programs like the Ms Note Pad or the Ms Word. Then copy the file to the clipboard (select all the text and copy it ). Then paste the text in the spread sheets. This can be done in the inverse way as well.
When you create one spread sheet with data that will be imported to contaonepro00. Usually it is possible to save the spread sheet to text format directly. It is not necessary to specify any thing about tabs or line breaks. But it is usually needed when you open a text file in the spread sheet program directly.
Data bases, spread sheets and word process programs use to export and import directly to text files. The text file is an universal format.
In the spread sheets the editing records for contaonepro00 it is very fast (account records, contacts or activities). On the other hand it is very fast and useful to work with this data in the telephone. If you are going to develop the activities of an extensive accounting layout, one budget with many activities or you have to edit a great group or contacts. You can use the spread sheet and then export the the records to contaonepro00 through a text file. Or in the inverse way.
The spread sheets place the fields of the records in the same line and in different columns contiguous from left to right. The records are placed in contiguous lines one following the other. When the spread sheet is saved as a text file or copied to the clipboard. The spread sheets programs insert automatically the tabs between the fields and the line breaks at the end of the records.
FIELDS OF THE CONTAONEPRO00 TABLES
INCOMES AND EXPENSES
Date - date with format YYYY-MM-DD example 2011-05-31
Amount 1 - numeric with format 100000 (no separator)
Data 1 - alphanumeric (120 characters maximum)
Data 2 - alphanumeric (120 characters maximum)
Activity - alphanumeric (120 characters maximum)
Contact - alphanumeric (120 characters maximum)
Explanation - alphanumeric (120 characters maximum)
CONTACTS
Name - alphanumeric (120 characters maximum)
Address - alphanumeric (120 characters maximum)
City - alphanumeric (60 characters maximum)
Estate - alphanumeric (60 characters maximum)
Zip code - alphanumeric (60 characters maximum)
Tel - alphanumeric (60 characters maximum)
Email - alphanumeric (60 characters maximum)
Explanation - alphanumeric (120 characters maximum)
ACTIVITIES
Activity - alphanumeric (120 characters maximum)
Explanation - alphanumeric (120 characters maximum)
If you have any doubt about the format of a text file for export records to contaonepro00. Just export some records of a contaonepro00 file to one text file and the open it with the spread sheet. This process is very simple.
2.6.4 THE EXPORT RECORDS TO TEXT FILE WINDOW (100% compatible with microsoft windows, office, words, excel etc.)
In this window it is possible to export the account records of the tables incomes and expenses. The records will be exported to a text file. Text files are 100% compatible with most of the office programs in the market ( word processors, spread sheets, data bases etc. ) . Specifically there is compatibility with Microsoft Windows programs like Wordpad, Notepad, Word, Excel etc. . Text files are compatible with all the programs of SunMicrosystem Open Office. With most of the Android programs which use text files like Txt Pad lite etc. Usually text files are compatible with Apple.
The text files always finish the name with the extension .TXT (this is a point and the letters TXT). As it is explained as well in the Export file window. When you name a text file in the View files window it is very important to finish always the name with the corresponding extension .TXT .
The window is very easy to use. First select the table or tables that you want to export. Make the selections of records for each selected table. Complete the file name and click on the Export records button. The selection windows have been explained before.
THE EXPORT RECORDS WINDOW OPTIONS
INCLUDE INCOMES TABLE
First there is a check button for the incomes table. If it is selected (with a green checker), the records of the incomes table will be included in the created file. The Select button shows the corresponding record selection window. If you don´t make any record selection, all the records of the table will be exported.
INCLUDE INCOMES TABLE
First there is a check button for the expenses table. If it s selected (with a green checker), the records of the expenses table will be included in the created file. The Select button shows the corresponding record selection window. If you don´t make any record selection, all the records of the table will be exported.
FIELDS TO SET THE FILE NAME
Specify the file name with the View files utility, further explained. In the View files utility you can select a file or write a new file name (finish always the name file with .TXT ). If you select a file or write a file name of an existing file, the information of that file will be deleted and overwriten with the exportation information. Click the button EXPORT TO A TEXT FILE to make the export.
2.7 THE CREATE AND START USING ACCOUNTANCY CONTAONEPRO00 FILES WINDOW
Contaonepro00 can work with different accountancies. Each accountancy is stored in one of the files created in the Create accountancy files window. As explained, in the import records window, you can import records between similar tables and consequently between two Contonepro00 files.
The Contaonepro00 files always finish the name with the extension .DB (this is a point and the letters DB). When you name a Contaonepro00 file in the View files window it is very important to finish always the name with the corresponding extension .DB . When working with files it is necessary to use always the correct file extensions.
Once created one accountancy file. It is necessary to set the file as the new file in use, if you want to work with it. in this window you can set the file in use.
Remember that Contaonepro00 files have a name always ending with the extension .DB (one point and the letters DB).
CREATE CONTAONEPRO00 ACCOUNTANCY FILES
In order to create contaonepro00 files it is necessary to name the new file. Use the View files utility to view the existing files and set the new name file.
Remember that Contaonepro00 files always finish the name with the extension .DB (this is a point and the letters DB). When you name a Contaonepro00 file in the View files window it is very important to finish always the name with the corresponding extension .DB .
When you have set the new file name. Click the button CREATE CONTAONEPRO00 ACCOUNTANCY FILE and the file will be created. The process of creating a new Contaonepro00 file takes a few seconds.
USING DIFERENT ACCOUNTANCY CONTANONEPRO00 FILES
To start using a new file, specify the file name (of course it must be already created) in the corresponding field of this window. Use the View files utility to view and select files.
Remember that Contaonepro00 files always finish the name with the extension .DB (this is a point and the letters DB). When you name a Contaonepro00 file in the View files window it is very important to finish always the name with the corresponding extension .DB .
Once you have set the name of the new file that will be edited. Click the button START USING CONTANONEPRO00 FILE. The file will be in use until you change it.
2.8 THE VIEW FILE WINDOW
The View file window shows all the existing files in the following directory of your telephone hard drive
"/sdcard/Android/data/contaonepro00/files/"
Remember that Contaonepro00 files should always finish the name with the extension .DB (this is a point and the letters DB). The text files create to export files should always finish the name with the extension .TXT (this is a point and the letters TXT). If you have any doubt read again the corresponding sections.
The utility shows a list of the existing files and a field to write file names. If you select a file, the name of the file will appear in the field to write file names. Once you have selected a file or written a name. Click the OK button.
If you have selected a file or written a name of one existing file the utility will remember it to you. This only happen if you are in a file creating process. This is because if you select file name of one existing file. That file will be deleted and created a new one with the same file name ( only if you are in a file creating process).
If you want to cancel the process click the Cancel button.
