What is the definition of DBF? Addendum dbf

dbf- file format, creations for robots with data bases, sounds and spreadsheets. This structure is formed from the heading, in which it is described together, that main part, where all the content of the tabular view is located. The peculiarity of this extension is the possibility of interoperability with more database management systems.

Let's look at the software that supports the revision of this format.

Method 1: DBF Commander

DBF Commander is a richly functional processing program DBF files different coding, which allows you to carry out basic manipulations with documents. Expanded for a fee, but may be a trial period.

For feedback:

Method 2: DBF Viewer Plus

DBF Viewer Plus tool for review and editing DBF, simple and manual view interface on English. May create a table creation function that does not require installation.

For review:

Method 3: DBF Viewer 2000

DBF Viewer 2000 is a program with a simpler interface that allows you to process files larger than 2 GB. May Russian language and trial period win.

Schob vіdkriti:

Method 4: CDBF

CDBF is a hard way to edit and review databases, and also allows you to create calls. You can expand the functionality with the help of add-on plugins. Russian language, expanding for a fee, proto maє trial version.

For review:

Method 5: Microsoft Excel

Excel is one of the components of the package Microsoft software Office, kindly see more koristuvachiv.

Schob vіdkriti:

Visnovok

We looked at the main ways to open DBF documents. 3 extensions are seen less than DBF Viewer Plus - mostly cost-free software, on the other hand, as rozpovsyudzhuyutsya on a paid basis and may be more than a trial period.

Bezkoshtovny universal DBF editor that allows you to create new data bases. May even be small, you can run from a flash drive and if you can put a lot of tools for working with DBF files, among them you can get a SQL feed!

Screenshots.

Sound on the site of our visvitlyuyemo program, as it will be a clique to a wide range of readers, but today there are no crossovers :). I pratsyuvav such a sobi " computer specialist» A number of state-owned offices and there often had to deal with different programs that work on the basis of FoxPro.

The main problem of all these programs was those that a simple koristuvach could easily close the data base in such a way that it was impossible to open it later by staff he had to twist, to turn її to life (which did not always happen, vrahovoyuchi "buildings" of "wild users").

І axis, after a few years, as I no longer work there, they sent us a mail to add a new cost-free program for editing DBF-databases, so I can simply name it. Sdbf. Let's talk about her :)

Comparison with paid analogue

Sdbf, regardless of its portability (maybe use a flash drive!) And a little expansion, do it with a database editor that allows you to create, edit and export whether it’s a basic DBF format, start with the xBaseIII specifications, and finish with the current xVisualPro! The functionality of Sdbf is similar, with the capabilities of one of the most advanced editors of this DBF Commander Professional:

From the above-mentioned plate, I’m bachimo, that the programs are slightly concerned about the functionality, but Sdbf, first, is portable necessary programs on a flash), but in a different way, I’ll do it without a cost!

First run of Sdbf

To run the program її it is enough to unpack the archive in any place and open the EXE file. Before us appear empty of an offensive sight:

Drag & Drop, unfortunately, is not supported, so for the beginning of the work we need to click on the "File" menu and there already select one of the two available ones: "Create" a new database or "Vidkriti" I know. Vіdkriєmo іsnuyuchu base:

We see before us the selected data base as a table. At the “zero” row, the names of fields are displayed, and starting from the first row, he himself. At the bottom there is a toolbar and a status row.

In the rest, you will be asked to complete a lot of basic service information, including a number of entries in the database, coding, the date of creation, and automatically assigning a format. 3 Sdbf formats are not supported anymore early versions xBase (I і II) and allows you to create DBF files of advanced types:

• xBase III-VII;
• xClipper;
• xFoxPro;
• xVisualFoxPro.

Tools to search and filter data

The Sdbf program allows you to edit without interruption, whether it's a data base, however, you need to know more… As the database is small and simple, you can do it manually. However, if you record a few dozens, or even a hundred, then you can still do it well.

But it’s not the same problem, the shards in Sdbf are a lot of tools that allow you to enter data and imagine less than what is needed!

The number of tools is stashed on the lower panel of the tools. There are 8 navigation buttons in a row, which allow you to move around the base (arrows), add / change entries, and also confirm or change changes. The necessary functions start from the ninth button - "Search":

When the button is activated, we see a small one at the end with the form of a joke. We need to indicate the text that we need to know and select the field from the list, according to which the search will be made. Now the "Find Distance" button is pressed and the program automatically sees the row that follows the current vision, in which case the text that you are joking about. Pressing the button again, see the row below the flow line, in which case you can see data, etc.

Sometimes in the databases there is a non-standard formatting of the middle: enter the gaps, tabs and other characters that are not visually displayed, but add a hint to the result. As soon as we got stuck with such a temper, then for normal work Functions It will be enough for you to take the ensign “For the improved format” at the lower central part of the window to ask and shuffle the rows to begin to reappear.

The function is randomly useful, if it is necessary to know the single entry of specific data. Ale trapleyayutsya vpadki, if it would be easier to see the sprat of rows, as if to avenge the same information. AT to this particular type help us another function (button Ide next to the button ask) - "Filter":

To set up filtering, we need to correctly add the request and enter yoga in a specially entered field (right behind the button in the central part of the toolbar). The principle of folding the bill is simple, but not obvious. We need to start by entering the name of the field, after which we need to filter the data base table, and then we will equate the filter value to a specific text, so that we need to know all the rows.

The values ​​are taken in a single foot, after which the “Filter” button itself is embossed (it becomes squeezed) and we take the table, which will avenge the data only with the values ​​\u200b\u200bassigned to us in the indicated fields (in the butts, all rows with the values ​​\u200b\u200bof “U.S.A” in the field were filtered ”(Register of the entry can not name the value)). You can rotate the table to the correct view by simply pressing the Filter button again (it will become redundant).

The filtering field can be as simple as "and" (for specifying the number of fields) and "or" (for an alternative selection of data from different fields). Unfortunately, Sdbf does not accept all-inclusive requests (like "not"), but it can be done in another way, which can go a little lower.

Before speaking, if you don’t manually enter the filtering request, you can quickly use the next trick: see whether there is a record in the field, after which you filter and press the Alt + F keys (but not F4 :))). The request will be automatically formed, and in the value there is a sign “*”, which is a mask for a joke that shows whether there are any number of symbols.

Unfortunately, the only type of masks that can be wicked in Sdbf and, even more summarily, one can only quench one mask: (. Therefore, as you need to filter the same field for decal parameters, you will have to win the “and” operator (Shvidke shaping the press "CTRL + ALT + F") or "or" ("SHIFT + ALT + F").

Winning SQL queries to database tables

Poshuk that filtering - tse, bezperechno, good, prote do not start manually. If the number of records is large, we can easily use it for the respect we need to give us an hour to analyze the tables. However, for the most part, Sdbf has an external function - a support for SQL queries!

For the help of such requests from Sdbf, we can:

1. Dynamically format our table, creating a selection only after the required fields (SELECT and SELECT TOP statements);
2. Copy data from one base to another (INSERT FROM and INSERT INTO);
3. Change and see in the same rows (UPDATE and DELETE, obviously);
4. Group parallel drinking (UNION);
5. Formuvati table links(PIVOT).

For the beginning of the work with requests, we need to press the “SQL-request” button at the right end of the toolbar. However, the result of such a task will be worthless: instead of a randomly edited data base, data will disappear, and on top of the working window, another empty one will appear at the end with two fields (in the mountains - the field of data viewing, and below - the introduction).

Lykatisya not varto :). You just need to immediately enter the required SQL query in the bottom field from the specified name of the required data base. If you don’t remember your name, you can activate the Sdbf front panel (I’ll press on the right-handed vertical female), all the bases appear on the list that you see, as you saw earlier.

Also, to speed up the work, it is necessary to remember the hot keys, which you can look over, calling out how to press the F1 key. Less than three, but they allow you to significantly speed up the process of making the right drinks.

So, CTRL+Problem - display the merging window with the list of available database names (so that it doesn't appear in the web panel), CTRL+F - display the list of functions for the streaming operator, and CTRL+Enter start the process of retrieval. In addition, if you click on the entry field with the right mouse button (click on the context menu), then we will take a list of operators that are supported by Sdbf.

Let's turn to our front screenshot and marvel at the simplest request, which is stored there. Win is based on the SELECT statement, which means it turns the choice to us. As the selection parameter is set to "*", which means the display of any data, the prote mi could enter there through whom the names of any fields in the database tables.

Vibirka, as we have seen more, the simplest, prote Sdbf allows you to win more and more. On the next screenshot, we see a selection, a dynamically formed table, which is added up from watering, so that the names of clients, places, children live and live in the country. Moreover, the filtering of clients is the same by country of residence (U.S.A) and the results are displayed in alphabetical order:

Yakshcho rosebrothers Danish zapit, then we should already guess the way I choose by the fields, which are shown through whom after the SELECT statement. They gave all those same instructions to the name of the base of the data, but now the request does not end on what.

Coming soon, the functions of the main operator will be redistributed, as the responsibilities will appear as a result of the processing of the request. Here are two.

The first - "where" may be similar to the filter, we will look at it earlier, and vikonu similar to the diy - allowing you to select those records, as if they speak to the mind.

Another function - "order by" sorts out the results for one of the fields (for this sort by the field with the client's name - "NAME") in alphabetical (parameter "asc") or inverted ("desc") order.

It’s obvious that the butt of the butt can also be pointed out to be primitive, ale win the heart of the matter creation of that SQL query processing. If you want to learn more about them, please read the manuals: http://dimonchik.com/insert.html or https://www.sql.ru/articles/articles.aspx?g=SQL&s=0 .

By the way, plus Sdbf є mozhlivіst eksportuvati otrimana as a result will feed the table as a new database or in HTML, RTF or CSV-file! For which it is enough to click the context menu of the field to display tables and select the appropriate item.

Added functions of the menu bar

With the main possibilities of Sdbf, we have dealt with you, but everything will not end. A whole series of brown and create unique functions to have a menu row, the very one that we have chosen for the data base display :) So, a lot of brown possibilities (which sometimes allow you to do without SQL queries) can be in the "Table" menu:

Among the other "korisniki" type of change coding and data bases at the very bottom, we can know the item "Change the structure". This item needs to be added at the end, in which case we can change all the fields in the crit table again, add new ones, or add more non-necessary parts (it will always be opened when the data base is created from scratch).

We can change the number of fields, their names, tipi, rozmіri (number of signs in the middle) and accuracy (size - it sounds automatically according to the field type).

The only thing that needs to be remembered when editing (and especially created) bases, so those that for the dermal type of base are to establish their own sets of types of watering and stench often (so do not take the main N, C, D to respect) are reviewed. For example, xClipper databases don't support image fields (P, B), and xBase doesn't support auto-increment fields (+) until the current version. Tobto it is necessary to keep the memory of summіsnіst :).

While we are looking at the menu row, do not forget to look at the "Field" menu:

There are only two functions here, but the stench is even more brown! Especially persha - "Replace". Vaughn allows shvidko in automatic mode Please change the value of the entire column of the designated field, or specific words and symbols for all data bases!

The “Calculate” function is an analogue of Excel's formulas and gives us the ability to carry out such mathematical and statistical operations, as the value of the auto sum of the field, the calculation of the arithmetic mean, as well as the maximum and minimum values. Naturally, for the viconann, the types of fields can be numbered (N, F, I, O, B).

The rest of the function, if it's not obvious, but you can also use the HEX editor:

Vіn allows you to correct the data, be it in the middle. For whom it is enough to see in the place, which is necessary to change and in context menu vibrati rest item- "Enter in hex". That's all - you can edit and save or see the result!

Advantages and shortcomings of the program

• portability and small size;
• support for all types of DBF files;
• the ability to create data bases from scratch;
• subtrimka of SQL-requests;
• a system for searching, filtering and editing data has been introduced.

• do not allow to set more than one mask for the filter;
• there are no functions to tell.

Visnovki

The Sdbf program, with its modest dimensions, is system wimogs allows you to work with DBF-databases, even if not all, then more and more richly ... And the implementation of SQL-request support in the beginning allows you to run the robot from editing the database to a new level! With this help, you can easily compensate for a lot of shortfalls in robots through a graphical interface.

The biggest disappointment, in my opinion, was the presence of the most trivial function “Say the rest of the day” at the “CTRL + Z” light: impossible :(

For this, you can state that the program has a functional plan - more low distance, but before working with it, always follow the old admin rule - CREATE BACKUP! I will be happy for you :)

P.S. It is allowed to freely copy and quote this article for the understanding of the inscription of an active message sent to the savings by Ruslan Tertishny.

Tables in dbf format date back to the distant 1980s. Since then, the dBase format has evolved, developed, dBase II, dBase III and dBase IV have appeared, until what hour it was divided richly popular programs, which is used with databases, in which dbf tables are found in the i format until the next day. The dbf table format is old, but it is still victorious for creating both large and ambitious, and for small projects, the dbf tables are victorious in illuminating purposes, for the knowledge of that event basic knowledge that organization of data bases. DBFNavigator no-cost program for revisiting that editing tables in dbf format, that simple utility is simple.

With the DBFNavigator program you can view dbf tables, edit tables - change, add and view records. Using DBFNavigator you can change the structure of tables, add, change and see fields of tables, squeeze dbf tables to clear them of remote records (selection), change the encoding of a Windows->DOS table and in addition. The program can sort table records, copy records and other fields, display rows of tables on other pages, search and stop filter table records before revisiting, change parameters for opening dbf files.

Screenshots of DBFNavigator

The biggest problem is often caused by the problem, because they cannot open the file, because the program is incorrectly recognized. To correct it in Windows, you need to right-click on the files, in the context menu, point the mouse at the item "Call for help", and from the menu select the item "Select a program ...". As a result, you will get a list installed programs on your computer, and you can choose what you need. It is also recommended to check the box next to the item "Write this program for all DBF files".

Another problem, for which our koristuvachs also need to file often - a DBF file of bugs. Such a situation can be blamed for rich vipadkas. For example: the file of interest will not be correct in the result server pardons, file buv poshkodzheny spochatku i n. For the solution of this problem, hurry up with one of the recommendations:

• Try to find the required file in another dzherel on the Internet. May I please you to know the best version. Butt of a Google joke: "File filetype:DBF" . Just replace the word "file" with a name you need;
• Ask to send you the output file again, possibly, without any delays during transmission;

DBF Viewer 2000®- Addendum for revision and editing DBF of all types - Clipper, dBase, FoxPro, Visual FoxPro, Visual dBase.

The program allows you to change the difference: request, remove duplicates, or export in a different format - quicker, lower, check!

DBF editor dynamically creates visual forms based on the structure of DBF files for editing and input. The program also allows you to review and edit the fields of the following formats: dBase III, dBase IV, FoxPro, VFP and dBase Level 7.

The program will again support changing the command line for future operations: import, export, removal of duplicate records or data replacement in DBF files. works independently from different DBMS - everything you need to review that DBF file editing and install the program!

Why DBF Viewer 2000
unique?

Simple and intuitive interface

The program interface is simple and handy, allowing you to save a lot of time with a little work.

Manually modifying the structure of DBF files in DBF Viewer 2000

You can add, see, rename, change the order of fields and optimize the structure of DBF files.

Import of data from different formats with the help of DBF Viewer 2000

DBF Viewer 2000 allows you to import data from the following formats: TXT, CSV, Excel (XLS, XLSX), DBF and Paradox. Import data may be subject to looking ahead or from the command row.

DBF Viewer 2000 offers extended export capabilities

The program allows you to export DBF files to Excel (XLS, XLSX), CSV, TXT, SQL, SDF, XML, HTML, PRG, and MS SQL, MySQL, Oracle, PostgreSQL scripts.

DBF Viewer 2000 helps you to see duplicates

Viewing records that are duplicated is easy like 1-2-3.

Works on all platforms

DBF Viewer 2000 runs on all Windows versions vіd 95 to XP, Vista, 7/8/10 and Server Editions (32/64-bit)