natgillin/translations-raw huggingface dataset:
SQLite does not operate on a client/ server model; each database is held in a regular file, local or remote, accessed using the normal methods supplied by the underlying operating system. In this case, therefore, there is only one software package and the driver to install. Also, some of the following information, particularly that related to administration, may not apply to SQLite.
mitte sees a server andmebaas on asukohas a fail kohalik või võrgus kasutamine normaalne x süsteem on üks pakett kuni mingi / info kuni haldus mai mitte kuni
Looking after databases is a little more complex than dealing with regular files. Each system has different methods for performing those necessary administrative tasks such as creating databases, assigning permissions to various users, producing backups, & etc;. Describing these tasks is outside the scope of this manual, but all of the supported products provide comprehensive reference documentation, and a quick search of the web will point you at many tutorials on the subject.
Otsimine on a rohkem järgnevaga failid süsteem tingimusel ülesanded kui loomine kuni on / käsitsi kõik / dokumentatsioon ja a otsing / punkt at sees subject.
Creating the database
andmebaas
Code has been included to create an initial database to hold your data if one does n't exist. However, it is strongly recommended that you pre-create a database, because most of the products provide a number of options which may be relevant. One that may be of particular importance to some would be the designation of the character set (eg;, UTF-8) to be used for text fields.
Kood kuni andmebaas kuni kui üks on a andmebaas / a arv / options mai Üks mai / kuni mingi / g kuni tingimusel tekst.
At this time, you will also need to specify permissions for various users to perform different operations on the database. In most systems, the user who creates the database will be automatically assigned all permissions, but this is an area in which the documentation should be consulted.
Mina at aeg kuni tingimusel kuni sees andmebaas kasutaja andmebaas kõik on piirkond asukohas dokumentatsioon.
For your first use of the database, and occasionally at other times when the database layout changes, you will need permission (also called privileges) to create and alter tables and views (see next paragraph). There may be different names for the permission/ privilege in different systems, but something like CREATE and ALTER should be commonplace. For normal running, you will need to be able to read and write records; these are normally defined in SQL as SELECT, INSERT, UPDATE, and DELETE permissions.
kasutusala / andmebaas ja at muu andmebaas paigutus kuni ja tabelid ja vaated järgmine lõik mai tingimusel asukohas nagu ja normaalne töötab kuni kuni lugemine ja write asukohas SQL kui ja.
Creating Tables
Tabelid
On your first use, & kappname; will attempt to create the necessary table structures. In order to achieve the maximum compatibility between various database types, only a subset of common data types are used. There may nevertheless be situations where a particular type is not supported, and in this case, provision has been made to generate the SQL code necessary to create tables. This code can then be modified as required and used to create the tables outside of & kappname;. Should you find yourself in this situation, help can usually be obtained from & devlist;. See Manual Database Creation for more information.
Sees kasutusalakappname; kuni tabel kuni maksimum vahel andmebaas a / common mai where a tüüp on mitte ja asukohas kuni SQL kood kuni tabelid kood muudetud kui nõutav ja kuni tabelid / & kappname; otsimine asukohas abi & devlist;.
Creating a Database
andmebaas
Using & kappname;, open or import an existing data file, or create a new one. Then select Save as Database from the File menu. This will present the following dialog:
& kappname; open või import fail või a uued üks Salvesta kui Andmebaas Fail menüü:
This box lists all & Qt; SQL drivers installed on your system. Select the driver for your database type. If the one you want is not in the list, you need to install the appropriate driver. See your distribution documentation, or visit the Qt; software web site and search for'SQL drivers'.
kast nimekirjad kõik Qt SQL paigaldatud sees süsteem Vali tingimusel andmebaas tüüp üks on mitte asukohas list kuni dokumentatsioon või ja otsing tingimusel SQL.
SQLite has one database per file so enter the file name in which you wish to create the database. To browse the file system, click the icon to the right of the file name. For SQLite databases, the Host name, Username, and Password fields are not relevant. The SQLite file must have the appropriate read/ write permissions set by the underlying file system to enable the appropriate access for the currently logged-in user.
Masin nimi Kasutaja nimi ja Parool mitte fail lugemine write x fail süsteem kuni tingimusel asukohas kasutaja.
Database name (others)
Andmebaas nimi
The default database name is KMyMoney, but you may choose some other name if you like. For some database types, & kappname; may not be able to create the database, so it must be pre-created using the appropriate administrative procedure. However, & kappname; will usually be able to create all table structures where necessary. If not, you can create them yourself. See Manual Database Creation for more information.
vaikimisi andmebaas nimi on mai mingi muu nimi kui nagu üks andmebaas fail valimine open Ava Fail a fail mai või mingi andmebaaskappname; mai mitte kuni andmebaas kasutamine haldus protseduurkappname; kõik tabel where.
For the average user, the default name of localhost, being the machine you are currently using, is correct. For networked databases, enter the connected host name.
kasutaja vaikimisi nimi / localhost kasutamine on ühendatud masin nimi.
User name and password
Kasutaja nimi ja parool
Check the permissions set up on your database, or contact the database administrator, for the correct values to use here. The user name must be capable of selecting, inserting, updating, and deleting records. If the user name is the same as your login name, a password is not normally required.
Kontrolli sees andmebaas või andmebaas tingimusel kuni kasutaja nimi / valimine kustutamine lisamine ja uuendamine kasutaja nimi on kui sisselogimine nimi a parool on mitte nõutav.
Table design
Tabel
To access your data in & kappname;, use the Open Database entry in the File menu. This will open a dialog similar to the above.
Kellele asukohaskappname; Ava Andmebaas entry asukohas Fail menüü open a kuni.
To access your data in other formats, you will need to know a little about how it is held in relational databases. By far the easiest way to get a feel for this is to open the database in a front-end such as OpenOffice. org. This provides a list of the various tables which make up the database, and enables you to see the layout of each of them.
Kellele asukohas muu kuni a on asukohas kuni a tingimusel on kuni open andmebaas asukohas a eest lõpp kui org tekitab a list / tabelid liigu kuni make andmebaas ja kuni paigutus / /.
To extract data, & eg;, into a spreadsheet or external file, it is almost invariably necessary to select linked data from more than one table. This is done by'joining 'the tables, using a field which is common to each. You can find a lot more information about how this is done from the online database tutorials mentioned above. The following table lists the fields used to define these inter-table relationships.
Kellele g a või väline fail on kuni üks või rohkem tabelid on tehtud x tabelid kasutamine a väli on common kuni Mina otsimine a rohkem info on tehtud võrgus tabel nimekirjad kuni tabel.
Institutions and Accounts
ja Kontod
Accounts Parent/ Child
Kontod Parent Järglane
Transactions and Splits (see Note 1)
ja Märkus
Accounts and Splits
Kontod ja
Payees and Splits
ja
Schedules and Transactions
Ajakavad ja
Transactions and Currencies
ja Rahaühik
Accounts and Securities (see Note 2)
Kontod ja Märkus
Securities and Prices
ja
kmmPrices. fromId or kmmPrices. toId
või
Currency Rates
Rahaühik Kiirused
1 & #x2013; txType = & #x201C; N#x201D; for normal transactions, & #x201C; S#x201D; for scheduled transactions
& # x2013; # x201C; N# x201D; tingimusel normaalne# x201C; S# x201D; tingimusel
2 & #x2013; if kmmAccounts. isStockAccount = & #x201C; Y#x201D;
& # x2013; kui# x201C; Y# x201D;
Field formats
Väli
Several of the data fields are held in an internal format which may not be immediately useful to external programs. In these cases, the information has been duplicated in both internal and external formats.
/ asukohas vormindamine mai mitte kuni väline programmid info asukohas ja väline.
Monetary amounts and share values are shown both in numerator/ denominator format, and, with a field name suffixed with'Formatted ', in the form as shown on your screens.
ja asukohas nimetaja vormindamine ja järgnevaga a väli nimi järgnevaga asukohas vorm kui sees.
Similarly, some fields, such as account type appear both as a numeric code, and in a field suffixed'String 'in the form and language of the application.
mingi kui konto tüüp kui a kood ja asukohas a väli String asukohas vorm ja keel / rakendus.
Updating your data
Uuendamine
Having data in an industry standard format does give you the ability to modify it outside the & kappname; application. DO NOT DO IT unless you really know what you are doing, and always be certain to make a backup copy of your data first. If you get it wrong, & kappname; may not be able to access your data, and you could even end up losing it altogether. You have been warned!
asukohas vormindamine kunikappname; rakendus T ja alati kuni make a koopiaõigus / & kappname; mai mitte kuni ja lõpp Mina!
Most database systems allow you to store commonly used queries and procedures, and in some cases, these may be held as tables or other objects within your database itself. As you will have guessed from the above, all the tables used by & kappname; begin with the lowercase letters'kmm '. This standard will be maintained, and only tables beginning with these letters will be updated. Thus, provided you avoid these in the naming of your queries & etc;, you should not experience any problems.
andmebaas kuni ja ja asukohas mingi mai kui tabelid andmebaas kõik tabelid xkappname; järgnevaga tahaplaanile saatmine tähte ja tabelid järgnevaga tähte asukohas / mitte iga.
Generating the SQL
Genereeri SQL
If this fails, it is possible to generate the basic SQL commands needed to create the various tables, views and indexes required by the application. Select Generate Database SQL from the Tools menu. This will present the following dialog:
& kappname; open või import fail või a uued üks Salvesta kui Andmebaas Fail menüü:
Encryption of data in your database is not currently supported.
Krüptimine / asukohas andmebaas on mitte.
Caution when using the database
kasutamine andmebaas
At the time of writing, the software described in this chapter is still in an experimental stage, and loss of data is possible. Please ensure that you have an alternative backup copy of your data before committing to database usage.
aeg / asukohas peatükk on asukohas eksperimentaalne ja / on koopiaõigus / kuni andmebaas kasutusala.
Due to limitations in prior releases, only version 3 of SQLite is supported. Unfortunately, the release of the & Qt; toolkit used by & kappname; does not provide a driver for this version. However, an unofficial, extensively tested, driver is available; if you wish to use SQLite, ask on & devlist; for further information.
Tähtaeg kuni asukohas versioon / on / Qt xkappname; mitte a tingimusel versioon on kui kuni küsitakse seesdevlist; tingimusel info.
Initialisation
nupp käsud kuni a tekst fail mai kui asukohas käsud mitte tingimusel andmebaas süsteem lõik.
KMyMoney Files
Failid
Your. KMY data file
fail
All of your financial information that & kappname; knows about is stored in a file ending in. KMY. You may have as many of these files as you like, each named differently. When you launch the program, it will automatically load the file you had open last time you exited.
Kõik / info on asukohas a fail asukohas Mina mai kui / failid kui nagu programm load fail open aeg.
Hacking the. KMY data file
fail
The. KMY file is a gzipped XML file. If you wish to learn about the structure of the file, you can gunzip it and load it in your favorite text editor.
fail on a XML fail kuni õpi / fail gunzip ja load asukohas tekst redaktor.
Making an Anonymous data file
Anonüümne fail
If you should encounter a bug, it's sometimes useful for the developers to have your data file in order to reproduce it and fix the problem. Obviously, this presents a problem because you do not want to send the developers your private financial details.
a sek vahel tingimusel kuni fail asukohas kuni ja a mitte kuni.
To solve this, & kappname; allows you to save an & quot; anonymizedquot; version of your data. This removes all personal information from the file, but keeps the structure intact.
Kellele kuni savequot; quot; versioon / kõik info fail.
To save a copy of your file in this way, open the File menu from the application menu bar, and choose & quot; Save as... quot;. For the file type, choose & quot; Anonymous (. ANON. XML)quot;. This will save off a copy of your data in anonymous form.
Kellele save a koopiaõigus / fail asukohas open Fail menüü rakendus menüü jaquot; Salvesta kuiquot; fail tüüpquot; Anonüümne XMLquot; save väljas a koopiaõigus / asukohas anonüümne vorm.
Next, you will need to verify that the problem still exists with your file in this form. Not all problems still occur with an anonymous file. Close your file, and load the anonymous file. Try the same actions that caused the problem initially. Hopefully the problem still happens.
Järgmine kuni järgnevaga fail asukohas vorm EI kõik järgnevaga anonüümne fail Sulge fail ja load anonüümne fail Proovi toimingud.
If it does, you can now report the problem to the developer's list, and mention that you have anonymous file that reproduces the problem. When requested, send the anonymous file via private e-mail to whichever developer requests it.
nüüd kuni arendaja sek list ja anonüümne fail anonüümne fail kuni arendaja.
What is a Forecast?
Mis on a Ennustus?
In & kappname;, a Forecast is a prediction of the balances of Accounts during a specified future period of time.
& kappname; a Ennustus on a / / Kontod a / aeg.
Forecasts can be predicted using one of two methods.
kasutamine üks / kaks.
& kappname; uses a combination of future transactions already entered into the ledgers and the entries in the Schedule.
& kappname; a / ja asukohas Schedule (ajasta).
& kappname; uses values from past transactions in the ledgers to predict future transactions.
& kappname; asukohas kuni.
The forecast method and forecast period can be set in the & kappname; Settings, in the Forecast pane.
method ja asukohaskappname; Seadistused asukohas Ennustus.
& kappname; Forecast provides a summary, showing the predicted balances at account cycle dates and the expected difference between the starting and ending balances. The length of the account cycle can be set by the user. The summary also displays messages about significant predicted changes to the accounts during the forecast period.
& kappname; Ennustus tekitab a kokkuvõte at konto ja eristuv osa vahel ja pikkus / konto x kasutaja kokkuvõte kuni.
As well as the summary, & kappname; Forecast also allows you to view day-by-day balances and view the minimum and maximum balances for each forecast account cycle.
kui kokkuvõtekappname; Ennustus kuni päev x päev ja ja maksimum tingimusel konto.
By default the Forecast is created for 90-days, with 30-day account cycles using Scheduled and Future Transactions.
vaikimisi Ennustus on tingimusel päeva järgnevaga päev konto kasutamine Ajastatud ja Tulevik.
You can view a Forecast by clicking the appropriate icon in the navigation pane at the left hand side of your & kappname; window.
Mina a Ennustus x suur ikoon asukohas at vasakult / & kappname; aken.
The Forecast window is split into five tabs
Ennustus aken asukohas kolm
Summary Tab
Kokkuvõte Tabeldusmärk
The Summary tab is split vertically into two halves.
Kokkuvõte on püstiselt kaks.
Account Summary
Konto Kokkuvõte
The Account Summary contains a grid displaying a row of information for each Asset and Liability.
Konto Kokkuvõte sisaldab a a rida / info tingimusel ja.
The following columns are displayed:
veerud:
The name of the Asset or Liability account
nimi / või konto
Current Balance (Current)
Aktiivne Balanss Aktiivne
The current balance of the account is displayed.
aktiivne / konto on.
Account Cycle Balance
Konto Balanss
The Forecast period is split into account cycles. The default account cycle length is 30 days, but can be set by the user.
Ennustus on konto vaikimisi konto pikkus on päeva x kasutaja.
The first account cycle date is the first Forecast date. By default this is the current date plus one account cycle, but can change depending on the "Day of Month to start Forecast" setting.
konto kuupäev on Ennustus kuupäev vaikimisi on aktiivne kuupäev üks konto sees Päev / Kuu kuni start Ennustus.
Remaining account cycle dates are determined by adding the account cycle length to the previous account cycle date. This is continued until the calculated account cycle date would be beyond the Forecast period.
Jäänud konto x lisamine konto pikkus kuni konto kuupäev on konto kuupäev Ennustus.
For each account cycle date the predicted balance is displayed.
konto kuupäev on.
Total Variation
Kokku
The rightmost column displays the predicted difference in value between the balances at the start and end of the forecast. If the predicted end value of the account (in terms of net worth) is less than the start value the whole row is highlighted in red.
eristuv osa asukohas väärtus vahel at start ja lõpp / lõpp väärtus / konto asukohas / net on vähem start väärtus rida on asukohas punane.
Key Summary Information
Võti Kokkuvõte Info
The bottom half of the Summary tab displays noteworthy information about accounts. This includes:
alt / Kokkuvõte info:
A message is displayed for any asset for which the value starts or will drop below zero during the forecast period.
A teade on tingimusel iga tingimusel väärtus või.
A message is displayed for any liability for which the value starts or will rise above zero during the forecast period. Note that the value of a liability is the negative of its ledger balance, since a positive balance indicates money owed.
A teade on tingimusel iga tingimusel väärtus või Märkus väärtus / a on negatiivne / a positiivne.
Details Tab
Üksikasjad Tabeldusmärk
The Details tab contains a grid displaying a row of information for each Asset and Liability.
Üksikasjad sisaldab a a rida / info tingimusel ja.
For each date in the Forecast period a column displays the predicted balance of the account on that date. The date columns are in ascending order from left to right.
kuupäev asukohas Ennustus a / konto sees kuupäev kuupäev veerud asukohas vasakult kuni paremalt.
The Advanced tab contains a grid displaying a row of information for each Asset and Liability. The information is split into columns as follows:
Muud sisaldab a a rida / info tingimusel ja info on veerud kui:
Minimum Account Cycle Balance
Miinimum Konto Balanss
For each account cycle number & lt; ngt; in the Forecast period the following columns are displayed:
konto arvlt; gt; asukohas Ennustus veerud:
Minimum Balance (Min Bal & lt; ngt;)
Miinimum Balanss Minlt; gt;
The minimum predicted balance during the account cycle
konto
Minimum Balance Date (Min Date & lt; ngt;)
Miinimum Balanss Kuupäev Min Kuupäevlt; gt;
The date on which the balance reaches its predicted minimum.
kuupäev sees.
Maximum Account Cycle Balance
Maksimum Konto Balanss
Maximum Balance (Max Bal & lt; ngt;)
Maksimum Balanss Makslt; gt;
The maximum predicted balance during the account cycle
maksimum konto
Maximum Balance Date (Max Date & lt; ngt;)
Maksimum Balanss Kuupäev Maks Kuupäevlt; gt;
The date on which the balance reaches its predicted maximum.
kuupäev sees maksimum.
The average balance of the account during the forecast period
/ konto
Chart Tab
Kokkuvõte Tabeldusmärk
This chapter describes the formats in which & kappname; stores its data in permanent form on the user's storage device. In general, & kappname; stores its information in form of an & XML; document. Depending on the actual format, this & XML; document will be written
peatükk asukohaskappname; asukohas vorm sees kasutaja sek seade üldinekappname; info asukohas vorm / XML sees vormindamine XML
as a plain text file encoded in UTF-8,
kui puhas tekst fail asukohas
as a compressed file using GZIP compression,
kui fail kasutamine tihendamine
as an encrypted file using GPG encryption, or
kui fail kasutamine GPG krüptimine või
as an anonymous plain text file encoded in UTF-8 but with all your personal data scrambled.
kui anonüümne puhas tekst fail asukohas järgnevaga kõik.
Plain text file
Tavaline tekst fail
This is the most space consuming format supported, as no compression is performed. It is not intended for normal use, and is provided to support debugging purposes and the capability to modify the file manually. If you end a filename in. xml, the file will be stored in this format.
on vormindamine kui ei tihendamine on on mitte tingimusel normaalne ja kuni ja kuni fail lõpp a failinimi asukohas fail asukohas vormindamine.
Manual modification of the file is not recommended to the normal user, and should only be performed if the internal working of & kappname; is fully understood or if instructions from the developers tell you what to do. Do n't blame the & kappname; developers if you screw up your data: You have been warned!
Käsitsi / fail on mitte kuni normaalne kasutaja ja kui töötamas / & kappname; on või juhised kuni Donkappname; kui Mina!
GZIP-compressed file
fail
This is the normal format used by & kappname; when you store a file with the extension. kmy.
on normaalne vormindamine xkappname; a fail järgnevaga laiend
If encryption has been selected, the file will be stored encrypted.
krüptimine fail.
If you want to look at the contents of a GZIP compressed file, rename it to a filename ending in. gz (eg;, rename myfinances. kmy to myfinances. kmy. gz), then use gunzip to uncompress the file and look at it. You do n't have to compress it before loading it into & kappname; the next time, because & kappname; can read the uncompressed data as well. Nevertheless, if you save it thereafter, it will be saved compressed again. Use the. xml extension to write it in uncompressed format.
kuni at a fail kuni a failinimi asukohas g gunzip kuni fail ja at Mina kunikappname; järgmine aegkappname; lugemine kui kui save Kasuta laiend kuni write asukohas vormindamine.
GPG-encrypted file
GPG fail
Using the GPG-encrypted file format is a very secure method of storing your personal finance data on your storage device. When & kappname; has been instructed through the settings dialog to store your data encrypted, it will cipher the data using GPG and the key you provided before actually storing it. When opening an encrypted file, you have to provide the passphrase necessary to open your keyring. The encrypted file itself will be stored in GPG's ASCII armored format.
GPG fail vormindamine on a method / sees seadekappname; kuni seadistused kuni kasutamine GPG ja võti avamine fail kuni kuni open fail asukohas GPG sek vormindamine.
When using GPG encryption, GPG also compresses the file, so no extra compression is necessary.
kasutamine GPG krüptimine GPG fail ei tihendamine on.
GPG-Keys
GPG Võtmed
If you have not done so already for mail encryption, you need to generate a key-pair in order to use the GPG encryption feature of & kappname;. Also, GPG must be installed on your system.
mitte tehtud tingimusel krüptimine kuni a võti paar asukohas kuni kuni GPG krüptimine / & kappname; GPG paigaldatud sees süsteem.
The details about how to generate a key-pair and how to take care of it are beyond the scope of this document. A Mini Howto on this subject can be found at http: / /www. gnupg. org/ documentation/ howtos. en. html.
kuni a võti paar ja kuni / / A Howto sees subject at http: // www. gnupg. org/ documentation/ howtos. en. html.
Setting the keys in & kappname;
Seadistus asukohaskappname;