[general]
name=Attribute Table Studio
qgisMinimumVersion=3.40
qgisMaximumVersion=4.99
supportsQt6=True

description=Explore, summarise and compare vector attribute tables: Attribute Explorer, Pivot Table, and Geometry and Table Compare in one toolbar.
about=Attribute Table Studio is an advanced version of QGIS Attribute Table and can do more. This tool consist of three tools to one QGIS toolbar.
    <b>Attribute Explorer</b> - a fast attribute table with exact column statistics attached above every column (missing and distinct counts, top categories, histograms, date ranges), an always-visible typed filter under every heading, an editing mode sharing the layer's edit session (QGIS cell editors and forms, constraints, field calculator, quick update, multi edit, add / delete / clipboard, new and virtual fields), table and form views, scopes, expression filters, map selection sync, column layouts saved per layer, and CSV / Excel export with the scope recorded.
    <b>Pivot Table</b> - grouped summaries and cross tabs with multiple measures (count, count distinct, sum, mean, median, min, max, standard deviation), correct totals calculated from records, an explicit input scope (all, Explorer filtered or selected records) with stale detection, drill-through to the contributing records, saved layouts, and CSV / Excel / GeoPackage export.
    <b>Geometry and Table Compare</b> - visual OLD -> NEW comparison of two dataset versions: added, deleted, modified and unchanged features, field-level old -> new values, exact geometry comparison with review points for multipart features, validation, accept / reject review and Excel / CSV export.
    Every tool opens in its own window and can be docked into QGIS like the native attribute table; the look follows the QGIS light or dark theme.

version=1.2
author=Irene Jaya
email=irenejaya1@gmail.com

homepage=https://github.com/irenejaya/attribute-table-studio
repository=https://github.com/irenejaya/attribute-table-studio
tracker=https://github.com/irenejaya/attribute-table-studio/issues

category=Vector
tags=attribute table,attributes,statistics,stats,editing,field calculator,statistics,profile,filter,pivot,pivot table,cross tab,summary,compare,diff,change detection,data quality,QA,geometry,geopackage

icon=icon.svg

experimental=False
deprecated=False
hasProcessingProvider=no
server=False

changelog=
    1.2 - Visualize Statistics, Compare feature export, "not" filters, expression filter bar, Rename Field, Pivot List distinct
        * New: Geometry and Table Compare - Export > GeoPackage (.gpkg) - features: the features of the rows shown, one layer per kind (added, deleted, modified, unchanged) with the table's columns plus CHANGE, DECISION and CHANGED_FIELDS; each column holds the reviewed value (NEW, or OLD where the change was rejected) and a changed column also gets <name>_OLD; the layers are added to the map as a group
        * New: Attribute Explorer - "not" quick filters: is not, does not contain, is not one of (NULL records are kept)
        * New: Attribute Explorer - Quick update opens when editing starts, like the native attribute table (can be turned off in Settings)
        * New: Attribute Explorer - Advanced Filter (Expression) is an editable bar in the second toolbar row, with the expression builder and stored expressions; the scope and filter summary are now part of the status bar
        * New: Attribute Explorer - Rename Field from a column's right-click menu
        * New: Attribute Explorer - Join table: add a QGIS layer join from one window; choose the join layer (or drop a CSV, Excel, GeoPackage or shapefile from your files), see how many records will match before joining, pick the fields (custom field name prefix as in QGIS), and remove existing joins
        * New: Attribute Explorer - Field properties: every field in one grid (as QGIS's Fields tab and ArcGIS Pro's Fields view) to change visible, read only, name, alias, allow NULL, unique and default value; OK applies them together
        * Attribute Explorer - a click on a column name selects the whole column (Ctrl / Shift for more, Ctrl+C copies their values); a double-click sorts (ascending, descending, off)
        * Attribute Explorer - the menu entry Layer Field Properties is now Layer Properties and opens QGIS's own Layer Properties
        * Attribute Explorer - the record count at the top follows the table: the layer's records, then the records shown in brackets when fewer, e.g. 9,434 (484); it also updates while editing
        * Attribute Explorer - the Columns window selects several rows (Shift+click, Ctrl+click) and Space or Toggle Selection ticks them together; it shows the Columns icon
        * New: Attribute Explorer - Visualize Statistics: a full chart of a column (the chart icon beside Σ Summary, a column name's right-click menu, or Chart… in its statistics popup) for the records in the table, as a histogram or a bar chart for every field type (numbers in bins or one bar per value, text one bar or column per value, dates per day to year); bins, scale, sort (A → Z, Z → A, fewest or most records first, custom order), top values, intervals, mean / median / standard deviation / normal curve, Split by a second field or a QGIS expression (stacked or side by side), statistics with skewness and kurtosis, export as PNG, SVG, image copy or CSV; dockable
        * Attribute Explorer - Visualize Statistics: click a bar to select its records (Ctrl+click adds, drag for a range); selected records show in every bar in the project's selection colour, also for a map selection
        * Attribute Explorer - Visualize Statistics is built for big layers: records are read in the background into compact columns (about 25 bytes a record), so 10 million records chart without freezing QGIS
        * New: Pivot Table - List distinct operator; the Values row puts the operator first, with symbols and explanations
	1.1 - Bug fix and Add a search (Ctrl+F) and replace (Ctrl+H)
		* New: Ctrl+F now works like Excel workbook and Ctrl+H will show the replace bar
    1.0 - Attribute Table Studio
        * One plugin, one toolbar with three tools: Attribute Explorer, Pivot Table, Geometry and Table Compare
        * New: Attribute Explorer - column profiles attached above the table, permanent typed filters (AND across columns, OR within a value list), map selection sync, Selected only, layouts saved per layer, exact background statistics, CSV / Excel export with scope
        * Attribute Explorer editing mode: shared layer edit session, edit row with status, save / discard / undo / redo, QGIS cell editors with constraint checks, add / delete / cut / copy / paste, QGIS's Field Calculator, Quick update row (Update All / Filtered / Selected as in the native table), multi edit, new / delete / virtual fields, form view, View and Select menus (scopes, expression and form filters, stored expressions, sort by expression, selected to top, conditional formatting), close prompts that never discard edits, optional F6 / Shift+F6 / Ctrl+F6
        * New: Pivot Table - rows, optional columns, multiple measures, totals from records, input scope with stale detection, drill-through to Attribute Explorer, layouts, CSV / Excel / GeoPackage export
        * Geometry and Table Compare (from standalone v1.1) - comparison logic unchanged; interface restyled to the shared suite look
        * Every tool opens as its own window and can be docked (Dock button); Settings to open docked by default
        * Shortcuts registered with QGIS (Attribute Explorer proposes Ctrl+Alt+T when free); layer context menu entry
        * Native QGIS icons, uniform 16 px icons and control heights, light and dark theme support
        * QGIS 3.40 LTR+ (Qt5) and QGIS 4.x (Qt6)
    Standalone Geometry and Table Compare history
        * 1.1 - Interface redesign, Qt5 / Qt6, geometry review points, tolerance, multipart methods, Excel export
        * 1.0 - Initial release
