This Dart commandline package takes the Woonzorg data file and split, checks and modify the data. After done that, it drops the database of the Mediabase (1) table end create a new one with the new data.

Features

• Validates the (csv) data
• Split it in two buckets (business and private)
• Renames the 'complexnaam' with the value of the complex number in the lookup file (if provided)
• Creates an error repport (if any) in JSON format
• Drops the curretn tables
• Create new tables with the new data

Getting started

Provide the "WoonzorgSourceFileParser" with the sourceFile, the translateFile and the mode and run it.

The "sourceFile" is a file provided by Woonzorg in csv format with hte modified data. (see 'Drukkerij.cvs' in the assets of the test folder)

The "mode" is optional and is one of these:

• debug
• release

If not set, the option 'debug' is the default and it writes the data to the database named 'test' in Darwin1

The "translateFile" file is optional, if given, the "complexnaam" wil be replaced by the value of the "complexnummer" key. If not given, the names of the complexes in the source file wil be taken and displayed in the template when creating a card in Darwin1. (see 'complex_display_name_lookup.xlsx' in the assets of the test folder)

Usage

final int resultCode = await WoonzorgSourceFileParser(
    sourceFile: File('test/assets/Drukkerij.csv'),
   //Optional
    mode: 'debug',
    translateFile: File('test/assets/complex_display_name_lookup.xlsx'),
).run();

A more detailed example can be found in /example folder.

Additional information

More info contact Rein...

Changelog

1.0.31 - 2025-07-23

Changed

• Version bump from 1.0.30 to 1.0.31 (test -> 1.26.3 (was 1.26.2)).

1.0.30 - 2025-05-22

Changed

• Version bump from 1.0.29 to 1.0.30 (lints -> 6.0.0 (was 5.1.1)).

1.0.29 - 2025-05-22

Changed

• Version bump from 1.0.28 to 1.0.29 (test -> 1.26.2 (was 1.26.1)).

1.0.28 - 2025-05-20

Changed

• Version bump from 1.0.27 to 1.0.28 (test -> 1.26.1 (was 1.26.0)).

1.0.27 - 2025-05-13

Changed

• Version bump from 1.0.26 to 1.0.27 (test -> 1.26.0 (was 1.25.15)).

1.0.26 - 2025-04-02

Changed

• Version bump from 1.0.25 to 1.0.26 (collection -> 1.19.1 (was 1.19.0)).

1.0.25 - 2025-04-02

Changed

• Version bump from 1.0.24 to 1.0.25 (test -> 1.25.15 (was 1.25.14)).

1.0.24 - 2024-12-23

Changed

• Version bump from 1.0.23 to 1.0.24 (collection -> 1.19.0 (was 1.19.1)).

1.0.23 - 2024-12-23

Changed

• Version bump from 1.0.22 to 1.0.23 (collection -> 1.19.1 (was 1.19.0)).

1.0.22 - 2024-12-23

Changed

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

1.0.21 - 2024-12-23

Changed

• Version bump from 1.0.20 to 1.0.21 (lints -> 5.1.1 (was 5.1.0)).

1.0.20 - 2024-12-19

Changed

• Version bump from 1.0.19 to 1.0.20 (Support Apple silicon (arm64)).

1.0.19 - 2024-12-19

Changed

• Version bump from 1.0.18 to 1.0.19 (collection -> 1.19.0 (was 1.19.1)).

1.0.18 - 2024-12-19

Changed

• Version bump from 1.0.17 to 1.0.18 (collection -> 1.19.1 (was 1.19.0)).

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-12

Changed

• Version bump from 1.0.14 to 1.0.15 (collection -> 1.19.0 (was 1.18.0)).

1.0.14 - 2024-12-05

Changed

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

1.0.13 - 2024-12-04

Changed

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

1.0.12 - 2024-12-03

Changed

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

1.0.11 - 2024-11-27

Changed

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

1.0.10 - 2024-08-22

Changed

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

1.0.9 - 2024-03-14

Changed

• Added some tests

1.0.8 - 2024-03-14

Changed

• Replaced the stdout for a 'printCallback'

1.0.7 - 2024-03-11

Changed

• Renamed some variables

1.0.6 - 2024-03-11

Changed

• Made a package of this project

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.