dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

MySQL-->Siard: lob-Type and folder in metadata, but not in content-folder

Open ibbenz opened this issue 1 year ago • 0 comments

Description: A database with tables is exported from MySQL into .siard with dbptk. The table "Employees" contains the column "HireDate" and "Photo". In the metadata.xml of the .siard-file of the export "HireDate" and "Photo" are of type "Character Large Object", in each case with a lob-folder.

However, in the content-folder of the table "Employees" there are no lob-Folders containing the data of "HireDate" and "Photo" The data of "HireDate" and "Photo" is part of the table3.xml-file

--> Why does metadata.xml reference to lob-folders and data, when there is no lob folders and no lob-Data?

Steps required to reproduce the bug:

  1. Import 0_1-3_Northwind_simple_2022_07_10_dbptk_V06.zip as a .siard file in MySQL with dbptk
  2. Export the data from MySQL into 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.zip
  3. Compare the metadata.xml of "HireDate" and "Photo" with the content-folder of the table "Employees"

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

The import-file: 0_1-3_Northwind_simple_2022_07_10_dbptk_V06.zip

The export-file 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.zip

Visualisation of "HireDate" and "Photo" before export: TypeOfHireDate_before_Export TypeOfPhot_before_Export

Visualisation of "HireDate" and "Photo" after export:

FolderOfTableEmployees_after_Export TypeOfHireDate_after_Export TypeOfPhoto_after_Export

ibbenz avatar Aug 22 '22 13:08 ibbenz