dbptk-developer custom view

[mezeijozsef]

Description:
My goal would be to create SIARD using every single table inside the database and also to create a custom view. It ignores every single table then terminates.

Steps required to reproduce the bug:

1. Using command: java -jar "-Dfile.encoding=UTF-8" dbptk-app-2.10.4.jar migrate -i import-config --import-file=config.yml --export siard-2 --export-file=example.siard

Attach the dbptk-app.log.txt file below.

config.yml.txt remove .txt
dbptk-app.log.txt

I would like to ask for help because I might overlook something.

[hmiguim]

Hi,

schemas:
  sakila:
    custom:
      - name: "EGYEDI_NEZET"
        description: "Ez a nézet értelmezhetően és összeszedetten tartalmazza az adatcsomagban található információkat."
        query: "select * from BK01"
    tables:
    - name: "BK01"
      columns:
      - name: "B1"
      - name: "BKA"
      - name: "BKC"
      - name: "BKD"
      where: ""
      orderBy: ""

The schema you are trying to connect is the sakila?

[luis100]

That seems to be the issue, log reports:

Ignoring table BUR_SIARD.BK01

So, the schema is "BUR_SIARD" and not "sakila".

schemas:
  BUR_SIARD:
    custom:
      - name: "EGYEDI_NEZET"
        description: "Ez a nézet értelmezhetően és összeszedetten tartalmazza az adatcsomagban található információkat."
        query: "select * from BK01"
    tables:
    - name: "BK01"
      columns:
      - name: "B1"
      - name: "BKA"
      - name: "BKC"
      - name: "BKD"
      where: ""
      orderBy: ""

Note that a good practice is to first use the import_config as an export module. This create a template you can edit and use as an import module.