This Dart command-line package processes Woonzorg source CSV data, validates and normalizes it, and then rebuilds the target database tables with the resulting records. The CLI supports both legacy and modern CSV layouts and auto-detects the source format by header row unless --legacy is supplied.

Documentation

Versioned documentation for dart_woonzorg_source_file_parser 1.1.0:

• Manager documentation
• User guide
• Developer guide

Usage

Run the CLI from the repository root:

dart run bin/dart_woonzorg_source_file_parser.dart -s assets/Drukkerij.csv -t assets/complex_display_name_lookup.xlsx -m debug

To force the old wide CSV structure explicitly:

dart run bin/dart_woonzorg_source_file_parser.dart -s assets/Drukkerij.csv -t assets/complex_display_name_lookup.xlsx -m release --legacy

Changelog

1.1.1 - 2026-04-28

Changed

• Version bump from 1.1.0 to 1.1.1 (test -> 1.31.1 (was 1.31.0)).

1.1.0 - 2026-04-13

Changed

• Version bump from 1.0.33 to 1.1.0 (CLI now auto-detects legacy vs modern source CSV headers and adds --legacy to force the legacy format).

1.0.33 - 2026-03-23

Changed

• Version bump from 1.0.32 to 1.0.33 (test -> 1.31.0 (was 1.30.0)).

1.0.32 - 2026-02-27

Changed

• Version bump from 1.0.31 to 1.0.32 (test -> 1.30.0 (was 1.29.0)).

1.0.31 - 2026-02-02

Changed

• Version bump from 1.0.30 to 1.0.31 (lints -> 6.1.0 (was 6.0.0)).

1.0.30 - 2026-01-08

Changed

• Version bump from 1.0.29 to 1.0.30 (test -> 1.29.0 (was 1.28.0)).

1.0.29 - 2025-11-21

Changed

• Version bump from 1.0.28 to 1.0.29 (test -> 1.28.0 (was 1.27.0)).

1.0.28 - 2025-11-11

Changed

• Version bump from 1.0.27 to 1.0.28 (test -> 1.27.0 (was 1.26.3)).

1.0.27 - 2025-07-23

Changed

• Version bump from 1.0.26 to 1.0.27 (test -> 1.26.3 (was 1.26.2)).

1.0.26 - 2025-05-22

Changed

• Version bump from 1.0.25 to 1.0.26 (lints -> 6.0.0 (was 5.1.1)).

1.0.25 - 2025-05-22

Changed

• Version bump from 1.0.24 to 1.0.25 (test -> 1.26.2 (was 1.26.1)).

1.0.24 - 2025-05-20

Changed

• Version bump from 1.0.23 to 1.0.24 (test -> 1.26.1 (was 1.26.0)).

1.0.23 - 2025-05-13

Changed

• Version bump from 1.0.22 to 1.0.23 (test -> 1.26.0 (was 1.25.15)).

1.0.22 - 2025-04-02

Changed

• Version bump from 1.0.21 to 1.0.22 (test -> 1.25.15 (was 1.25.14)).

1.0.21 - 2025-03-13

Changed

• Version bump from 1.0.20 to 1.0.21 (args -> 2.7.0 (was 2.6.0)).

1.0.20 - 2024-12-23

Changed

• Version bump from 1.0.19 to 1.0.20 (test -> 1.25.14 (was 1.25.13)).

1.0.19 - 2024-12-23

Changed

• Version bump from 1.0.18 to 1.0.19 (lints -> 5.1.1 (was 5.1.0)).

1.0.18 - 2024-12-19

Changed

• Version bump from 1.0.17 to 1.0.18 (Support Apple silicon (arm64)).

1.0.17 - 2024-12-18

Changed

• Version bump from 1.0.16 to 1.0.17 (test -> 1.25.13 (was 1.25.12)).

1.0.16 - 2024-12-12

Changed

• Version bump from 1.0.15 to 1.0.16 (lints -> 5.1.0 (was 5.0.0)).

1.0.15 - 2024-12-05

Changed

• Version bump from 1.0.14 to 1.0.15 (test -> 1.25.12 (was 1.25.11)).

1.0.14 - 2024-12-04

Changed

• Version bump from 1.0.13 to 1.0.14 (test -> 1.25.11 (was 1.25.10)).

1.0.13 - 2024-12-03

Changed

• Version bump from 1.0.12 to 1.0.13 (test -> 1.25.10 (was 1.25.9)).

1.0.12 - 2024-11-27

Changed

• Version bump from 1.0.11 to 1.0.12 (test -> 1.25.9 (was 1.25.8)).

1.0.11 - 2024-08-22

Changed

• Version bump from 1.0.10 to 1.0.11 (SDK update 3.5.1).

1.0.10 - 2024-03-14

Changed

• Added some tests

1.0.9 - 2024-03-14

Changed

• Replaced the stdout for a 'printCallback'

1.0.8 - 2024-03-11

Changed

• Default in debug mode

1.0.7 - 2024-03-11

Changed

• Renamed some variables

1.0.6 - 2024-03-11

Changed

• split of in pkg and dart packages

1.0.5 - 2024-02-29

Changed

• In order of Woonzorg by error lines we take the first one

1.0.4 - 2024-02-20

Changed

• Refactored according to the comments of Ruud

1.0.3 - 2024-02-12

Changed

• Added modes and cascading of the "Centrale_verwarming" fields

1.0.2 - 2024-02-01

Changed

• Version bump from 1.0.1 to 1.0.2 (Resolve package version confusions).

1.0.1 - 2024-01-25

Changed

• Added the option for setting your own root in the "SqlQueryService" to fix the issue where you can't run this globally:
• SqlQueryService()..isPresent(ownRoot: '/Users/Shared/work_dart/pkg_sql_socket_connection');

1.0.0 - 2024-01-25

Changed

• First production draft
• Added the 'complex display name replacement' option.

0.0.2 - 2024-01-04

Changed

• Version bump from 0.0.1 to 0.0.2 (added 'executable' to pubspec.yaml).

0.0.1 - 2023-12-14

• Initial version.