alephdata / cronodump

A Cronos database converter
MIT License
73 stars 18 forks source link

Issue with Retrieving Values of Related Fields from Bases #23

Open VelziDM opened 1 year ago

VelziDM commented 1 year ago

Hello!

Can someone, please, advise me on how to correctly retrieve the values of these related fields?

I have a Bank, that includes the "people" and "anketa" bases, which are related to each other through the "anketa_conn" field in the "people" base and the "people_conn" field in the "anketa" base.

strudump shows this bases like this

== Base004 ==
Warning: FieldDefinition Section 2 not marked with a 2
0,3<5,0,14>4  1,11 'address'  'AD'  [TableImage(0 bytes): none]
Type:  0  0    1,0       - 'Системный номер'
Type:  1 ( 1/ 1) 0000,(1-  20),1000d - 'id'                                     -- 0000000000000000000000000500001741070000
Type:  2 ( 2/ 2) 0800,(1-   2),1000d - 'country'                                -- 000000000000000000000000050000a3a80700000000
Type:  2 ( 3/ 3) 0800,(1-  16),1000d - 'area'                                   -- 000000000000000000000000050000c1a80700000000
Type:  2 ( 4/ 4) 0800,(1-  31),1000d - 'city'                                   -- 00000000000000000000000005000001aa0700000000
Type:  1 ( 5/ 5) 0800,(1-  20),1000d - 'index'                                  -- 000000000000000000000000050000d1c6070000
Type:  2 ( 6/ 6) 0800,(1-  50),1000d - 'address'                                -- 000000000000000000000000050000bd0b0800000000
Type:  1 ( 7/ 7) 0000,(1-  20),1000d - 'type'                                   -- 000000000000000000000000000000
Type:  1 ( 8/ 8) 0000,(1-  20),1000d - 'verify'                                 -- 000000000000000000000000000000
Type:  1 ( 9/ 9) 0000,(1-  20),1000d - 'priority'                               -- 000000000000000000000000000000
Type: 17 (10/10) 0040,(1-100000),1000d - 'people_conn'                            -- 00000000000000000000000002005045020031330001003100

And

== Base001 ==
Warning: FieldDefinition Section 2 not marked with a 2
0,3<5,0,3>1  1,20 'people'  'PE'  [TableImage(0 bytes): none]
Type:  0  0    1,0       - 'Системный номер'
Type:  1 ( 1/ 1) 0000,(1-  20),1000d - 'id'                                     -- 0000000000000000000000000500000100000000
Type:  1 ( 2/ 2) 0000,(1-  20),1000d - 'ecbID'                                  -- 0000000000000000000000000500007669000000
Type:  2 ( 3/ 3) 0000,(1-  12),1000d - 'login'                                  -- 00000000000000000000000005000000cf0000000000
Type:  2 ( 4/ 4) 0800,(1-  12),1000d - 'surname'                                -- 0000000000000000000000000500009b4e0100000000
Type:  2 ( 5/ 5) 0800,(1-  10),1000d - 'name'                                   -- 00000000000000000000000005000096a20200000000
Type:  2 ( 6/ 6) 0800,(1-  13),1000d - 'middlename'                             -- 00000000000000000000000005000020bd0200000000
Type:  1 ( 7/ 7) 0000,(1-  20),1000d - 'sex'                                    -- 00000000000000000000000005000061d0020000
Type:  4 ( 8/ 8) 0800,(1-  20),1000d - 'dateB'                                  -- 00000000000000000000000005000066d0020001
Type:  2 ( 9/ 9) 0000,(1-  24),1000d - 'key'                                    -- 0000000000000000000000000000000000
Type:  2 (10/10) 0000,(1-   2),1000d - 'nationality'                            -- 000000000000000000000000050000078c0400000000
Type:  1 (11/11) 0000,(1-  20),1000d - 'translate'                              -- 000000000000000000000000050000278c040000
Type: 17 (15/20) 0040,(1-100000),1000d - 'anketa_conn'                            -- 0000000000000000000000000200414e020031310001003100

During formatting, I am trying to retrieve the values of these related fields, but I am getting empty values.

Thank you for your assistance!

psychosys commented 1 year ago

I have the exact same issue, it creates one file but stucks