DSM/Mitsubishi CAPS: Difference between revisions

From Jane Hacker Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
==Database Files==
==Subpages==


{| class="wikitable"
* [[DSM/Mitsubishi_CAPS/Database_Files]]
!Filename
!Table Name
!Desc
! colspan="3" |Translation
!Note
|-
!
!
!
!Kana
!Kanji
!English
!
|-
!BUBAN_A.DAT
|
|Part Numbers A
|ぶばん
|部番
|Part Number
|Data
|-
!BUBAN_A.IDX
|```BUBAN_A IDX```
|Part Numbers A
|ぶばん
|部番
|Part Number
|Index
|-
!BUBAN_B.DAT
|
|Part Numbers B
|ぶばん
|部番
|Part Number
|Data
|-
!BUBAN_B.IDX
|```BUBAN_A IDX```
|Part Numbers B
|ぶばん
|部番
|Part Number
|Index
|-
!BUKYOU.DAT
|
|
|ぶきょう
|武侠
|chivalry-chivalry?)
|Data
|-
!BUKYOU.IDX
|```BUKYOU  IDX```
|
|ぶきょう
|武侠
|chivalrychivalry?
|Index
|-
!CD_ID.DAT
|
|
|
|
|
|
|-
!COLOUR.DAT
|
|Color?
|
|
|
|
|-
!HLP_MDL.DAT
|
|Help Modal?
|
|
|-
!HLP_MDL.IDX
|```HLP_MDL IDX```
|Help Modal?
|
|
|
|
|-
!HLP_RUI.DAT
|
|Help terms?
|
|
|
|
|-
!HLP_RUI.IDX
|```HLP_RUI IDX```
|Help terms?
|
|
|
|
|-
!HLP_TOK.DAT
|
|Help Token?
|
|
|
|
|-
!HLP_TOK.IDX
|```HLP_TOK IDX```
|Help Token?
|
|
|
|
|-
!HLP_TOKC.DAT
|
|Help Token C?
|
|
|
|
|-
!HLP_TOKC.IDX
|```HLP_TOK_CIDX```
|Help Token C?
|
|
|
|
|-
!ILLUST.IMG
|
|Illustrations?
|
|
|
|Image?
|-
!ILLUSTX.DAT
|
|Illustrations X?
|
|
|
|Data
|-
!ILLUSTX.IDX
|```ILLUSTX IDX```
|Illustrations X?
|
|
|
|Index
|-
!ILST_NWS.IMG
|
|Illustration Something??
|
|
|
|Image?
|-
!KATARUI.DAT
|
|
|かた
|語る
|word class? Construction class?
|Data
|-
!KATARUI.IDX
|```KATARUI IDX```
|
|かた
|語る
|word class? Construction class?
|Index
|-
!KAT_SEQ.DAT
|
|
|
|
|Construction sequence?
|Data
|-
!KAT_SEQ.IDX
|```KAT_SEQ IDX```
|
|
|
|Construction sequence?
|Index
|-
!KIGOD.DAT
|
|Language Dutche
|
|
|
|Data
|-
!KIGOE.DAT
|
|Language English
|
|
|
|Data
|-
!KIGOF.DAT
|
|Language French
|
|
|
|Data
|-
!KIGOG.DAT
|
|Language German
|
|
|
|Data
|-
!KIGOP.DAT
|
|Language Portuguese
|
|
|
|Data
|-
!KIGOS.DAT
|
|Language Spanish
|
|
|
|Data
|-
!KIGOU.DAT
|
|Language ?Universal?
|
|
|
|Data, same as KIGOE.DAT (English)
|-
!KOYUU.DAT
|
|
|
|
|Public?
|
|-
!KOYUU.IDX
|```KOYUU  IDX```
|
|
|
|Public?
|
|-
!NAMSEQD.DAT
|
|Names - See index notes
|
|
|
|Data, same as NAMSEQE.DAT
|-
!NAMSEQD.IDX
|```NAM_FRA IDX```
|Names - See notes
|
|
|
|Index,
same as NAMSEQE.IDX,
table name suggests it is supposed to be French,
filename suggests Dutche
|-
!NAMSEQE.DAT
|
|Names - English
|
|
|
|Data
|-
!NAMSEQE.IDX
|```NAM_ENG IDX```
|Names - English
|
|
|
|Index
|-
!NAMSEQF.DAT
|
|Names - French
|
|
|
|Index, same as NAMSEQE.DAT
|-
!NAMSEQF.IDX
|```NAM_FRA IDX```
|Names - French
|
|
|
|Index, same as NAMSEQE.IDX
|-
!NAMSEQG.DAT
|
|Names - German
|
|
|
|Data,
the ONLY NAMSEQ file that differs from NAMSEQE,
actually contains German language!
|-
!NAMSEQG.IDX
|```NAM_GER IDX```
|Names - German
|
|
|
|Index, same as NAMSEQE.IDX
|-
!NAMSEQP.DAT
|
|
|
|
|
|
|-
!NAMSEQP.IDX
|```NAM_FRA IDX```
|
|
|
|
|Index, same as NAMSEQE.IDX
|-
!NAMSEQS.DAT
|
|
|
|
|
|
|-
!NAMSEQS.IDX
|```NAM_FRA IDX```
|
|
|
|
|Index, same as NAMSEQE.IDX
|-
!NAMSEQU.DAT
|
|
|
|
|
|
|-
!NAMSEQU.IDX
|```NAM_ENG IDX```
|
|
|
|
|Index, same as NAMSEQE.IDX
|-
!NAM_KATA.DAT
|
|Bridge Table?
|
|
|Bridge Table?
|Data, model numbers?
|-
!NAM_KATA.IDX
|```NAM_KATAIDX```
|Bridge Table?
|
|
|Bridge Table?
|Index, model numbers?
|-
!NAM_RUI.DAT
|
|Drop Table?
|
|
|Drop Table?
|Data, empty
|-
!NAM_RUI.IDX
|```NAM_RUI IDX```
|Drop Table?
|
|
|Drop Table?
|Index, empty
|-
!OPC.DAT
|
|Options Catalog ?
|
|
|
|Data, contains options names in strings
|-
!OPC.IDX
|```OPC    IDX```
|Options Catalog ?
|
|
|
|Index
|-
!OPTION.DAT
|
|
|
|
|
|Data, Empty
|-
!OPTION.IDX
|```OPTION  IDX```
|
|
|
|
|Index, Empty
|-
!PN_KATA.DAT
|
|PartNumber Katakana?
|
|
|
|Data, Katakana for part numbers?
|-
!PN_KATA.IDX
|```PN_KATA IDX```
|PartNumber Katakana?
|
|
|
|Index, part numbers
|-
!SEIBI.DAT
|
|
|
|
|maintenance?
|Data, some fields?
|-
!SEIBI.IDX
|```SEIBI  IDX```
|
|
|
|maintenance?
|Data, empty?
|-
!SEISAN.DAT
|
|
|
|
|production?
|Data, empty
|-
!SEISAN.IDX
|
|
|
|
|production?
|Index, empty
|-
!SEQ_KATA.DAT
|
|
|
|
|
|
|-
!SEQ_KATA.IDX
|
|
|
|
|
|
|-
!SHARYO.DAT
|
|
|しゃりょう
|車両
|Car/Vehicle
|Date
|-
!SHARYO.IDX
|
|Contains vehicle VIN as primary key
|しゃりょう
|車両
|Car/Vehicle
|Index
|-
!SIRYO.DAT
|
|
|
|
|
|
|-
!SPCNO.DAT
|
|
|
|
|
|
|-
!SPCNO.IDX
|
|
|
|
|
|
|-
!TANGO2D.DAT
|
|
|
|
|
|
|-
!TANGO2D.IDX
|
|
|
|
|
|
|-
!TANGO2E.DAT
|
|English glossary
|
|
|glossary
|Data
|-
!TANGO2E.IDX
|```TAN_ENG IDX```
|English glossary
|
|
|glossary
|Index
|-
!TANGO2F.DAT
|
|
|
|
|
|
|-
!TANGO2F.IDX
|
|
|
|
|
|
|-
!TANGO2G.DAT
|
|
|
|
|
|
|-
!TANGO2G.IDX
|
|
|
|
|
|
|-
!TANGO2P.DAT
|
|
|
|
|
|
|-
!TANGO2P.IDX
|
|
|
|
|
|
|-
!TANGO2S.DAT
|
|
|
|
|
|
|-
!TANGO2S.IDX
|
|
|
|
|
|
|-
!TANGO2U.DAT
|
|
|
|
|
|
|-
!TANGO2U.IDX
|
|
|
|
|
|
|-
!TANGOD.DAT
|
|
|
|
|
|
|-
!TANGOD.IDX
|
|
|
|
|
|
|-
!TANGOE.DAT
|
|
|
|
|
|
|-
!TANGOE.IDX
|
|
|
|
|
|
|-
!TANGOF.DAT
|
|
|
|
|
|
|-
!TANGOF.IDX
|
|
|
|
|
|
|-
!TANGOG.DAT
|
|
|
|
|
|
|-
!TANGOG.IDX
|
|
|
|
|
|
|-
!TANGOP.DAT
|
|
|
|
|
|
|-
!TANGOP.IDX
|
|
|
|
|
|
|-
!TANGOS.DAT
|
|
|
|
|
|
|-
!TANGOS.IDX
|
|
|
|
|
|
|-
!TANGOU.DAT
|
|
|
|
|
|
|-
!TANGOU.IDX
|
|
|
|
|
|
|-
!TANPNC2D.DAT
|
|
|
|
|
|
|-
!TANPNC2D.IDX
|
|
|
|
|
|
|-
!TANPNC2E.DAT
|
|
|
|
|
|
|-
!TANPNC2E.IDX
|
|
|
|
|
|
|-
!TANPNC2F.DAT
|
|
|
|
|
|
|-
!TANPNC2F.IDX
|
|
|
|
|
|
|-
!TANPNC2G.DAT
|
|
|
|
|
|
|-
!TANPNC2G.IDX
|
|
|
|
|
|
|-
!TANPNC2P.DAT
|
|
|
|
|
|
|-
!TANPNC2P.IDX
|
|
|
|
|
|
|-
!TANPNC2S.DAT
|
|
|
|
|
|
|-
!TANPNC2S.IDX
|
|
|
|
|
|
|-
!TANPNC2U.DAT
|
|
|
|
|
|
|-
!TANPNC2U.IDX
|
|
|
|
|
|
|-
!TANPNCD.DAT
|
|
|
|
|
|
|-
!TANPNCD.IDX
|
|
|
|
|
|
|-
!TANPNCE.DAT
|
|
|
|
|
|
|-
!TANPNCE.IDX
|
|
|
|
|
|
|-
!TANPNCF.DAT
|
|
|
|
|
|
|-
!TANPNCF.IDX
|
|
|
|
|
|
|-
!TANPNCG.DAT
|
|
|
|
|
|
|-
!TANPNCG.IDX
|
|
|
|
|
|
|-
!TANPNCP.DAT
|
|
|
|
|
|
|-
!TANPNCP.IDX
|
|
|
|
|
|
|-
!TANPNCS.DAT
|
|
|
|
|
|
|-
!TANPNCS.IDX
|
|
|
|
|
|
|-
!TANPNCU.DAT
|
|
|
|
|
|
|-
!TANPNCU.IDX
|
|
|
|
|
|
|-
!TOKTBL.DAT
|
|Token Table?
|
|
|
|Data
|-
!TOKTBL.IDX
|
|Token Table?
|
|
|
|Index
|-
!UNKATA.DAT
|
|
|うんかた
|
|
|
|-
!UNKATA.IDX
|
|
|うんかた
|
|
|
|-
!YOUGO.DAT
|
|
|ようご
|用語
|Term
|Data
|-
!YOUGO.IDX
|
|
|ようご
|用語
|Term
|Index
|-
!YOUGOB.DAT
|
|Term B
|ようご
|用語
|Term
|Data
|-
!YOUGOB.IDX
|
|Term B
|ようご
|用語
|Term
|Index
|-
!YPCNO.DAT
|
|
|
|
|
|
|-
!YPCNO.IDX
|
|
|
|
|
|
|}


==File Formats==
==File Formats==

Revision as of 17:41, 25 April 2023

Subpages

File Formats

VIN Lookup

SHARYO.IDX Lookup:

Read start Bytes read
0 2048
4096 2048
229376 2048
229376 4096
21,833,728 2048
21,831,680 4096

SHARYO.DAT Lookup:

Read start Bytes read
35,073,568 2048
35,069,952 8192

IDX - Index

Index files are broken up into 2048 byte chunks, which I will refer to as "pages". Index file must be at least 1 page in size, meaning the smallest IDX file will be 2048 bytes, filled mostly with null bytes(00h) if it has 1 or 2 indexes (there are 60 indexes per page in SHARYO.IDX for example).

Header

The first 32 bytes of each page is the "header". The header's first 8 bytes contain the filename, if the filename is less than 8 bytes the remaining bytes will be padded with 20h. After the name is "IDX", followed by 00h as a seperator.

Byte 13 (14th byte) is the "page number", starting with 01h and incrementing each page.

Bytes 14-32 appear to be other informational flags which have yet to be understood.

Byte # Description
0-7 Uppercase ASCII, matches file name, if name < 8 bytes it is padded with 20h
8-10 49h 44h 58h, literal: "IDX", Uppercase ASCII
11 Always 00h, separator or null byte for the string?
12 Always the same in all headers that are in the same file, often seen: 09h 11h, is this multiplier or record length?
13 The "page" count, starts at 01h increments by 1 every "header"
14-31 Other flags
15 00h or 01h or 02h, always set with byte 16? Always the same as byte 16?
16 00h or 01h or 02h, always set with byte 15? Always the same as byte 15?
18 Secondary counter, starts at 01h and increments by 01h, always used with bytes 15 and 16 set?
22 Number of records on this page

index entry

Byte # Description

Examples

NU = NULL BYTE (00h)
PA = PADDING (20h)


SEIBI.IDX - 2048 bytes

Byte : 0  1  2  3  4  5  6  7  8  9  10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
Hex  : 53 45 49 42 49 20 20 20 49 44 58 00 09 01 00 00 00 00 00 00 01 00 01 00 00 00 00 00 00 00 00 00 39 39 39 39 39 39 39 39 39 01
ASCII: S  E  I  B  I           I  D  X                                                                 9  9  9  9  9  9  9  9  9

UNKATA.IDX - 2048 bytes

Byte : 0  1  2  3  4  5  6  7  8  9  10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
Hex  : 55 4E 4B 41 54 41 20 20 49 44 58 00 09 01 00 00 00 00 00 00 01 00 01 00 00 00 00 00 00 00 00 00 39 39 39 39 39 39 39 39 39 01
ASCII: U  N  K  A  T  A        I  D  X                                                                 9  9  9  9  9  9  9  9  9

SHARYO.IDX - bytes

#Header - 32 bytes:                            \/ Page (1)                  \/ Number of records
Byte : 0  1  2  3  4  5  6  7  8  9  10 11 12  13  14 15 16 17 18 19 20 21  22  23 24 25 26 27 28 29 30 31
Hex  : 53 48 41 52 59 4F 20 20 49 44 58 00 11  01  00 00 00 00 00 00 00 00  06  00 00 00 00 00 00 00 00 00
ASCII: S  H  A  R  Y  O        I  D  X
Data :                   PA PA          NU 11  1                            6

#VIN (02) - 21 bytes                                       \/-- Count Column (2)
       { 17 bytes                                        }
Byte : 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48  49  50 51 52
Hex  : 34 41 33 41 43 38 34 4C 33 59 45 30 35 31 32 36 31  02  00 00 00
ASCII: 4  A  3  A  C  8  4  L  3  Y  E  0  5  1  2  6  1
Data :                                                     2   NU NU NU

#VIN (03) - 21 bytes
Hex  : 34 41 33 43 53 34 34 54 58 4D 45 30 30 36 31 30 36  03  00 00 00
ASCII: 4  A  3  C  S  4  4  T  X  M  E  0  0  6  1  0  6
Data :                                                     3   NU NU NU

#VIN (04) - 21 bytes
Hex  : 4A 41 33 41 4D 36 34 4A 37 52 59 30 30 35 33 35 33  04  00 00 00
ASCII: J  A  3  A  M  6  4  J  7  R  Y  0  0  5  3  5  3
Data :                                                     4   NU NU NU

#VIN (05) - 21 bytes
Hex  : 4A 41 34 47 4A 33 31 53 31 4D 4A 30 31 33 39 31 34  05  00 00 00
ASCII: J  A  4  G  J  3  1  S  1  M  J  0  1  3  9  1  4
Data :                                                     5   NU NU NU

#VIN (06) - 21 bytes
Hex  : 4A 41 37 4C 53 32 31 47 34 52 50 30 31 32 37 33 34  06  00 00 00
ASCII: J  A  7  L  S  2  1  G  4  R  P  0  1  2  7  3  4
Data :                                                     6   NU NU NU

#??? (07) - 18 bytes
Hex  : 5A 31 36 41 57 59 30 59 30 30 31 36 39 37 20 20 20  07 ... \
ASCII: Z  1  6  A  W  Y  0  Y  0  0  1  6  9  7               ... + 1893 Null Bytes (2048 byte total header space)
Data :                                           PA PA PA  7  ... /
                                             | Always 11??
#Header 2 (Start at 2048 Bytes) - 32 Bytes  \/  \/Page (2)                  \/ Number of records
Byte : 0  1  2  3  4  5  6  7  8  9  10 11  12  13  14 15 16 17 18 19 20 21  22  23 24 25 26 27 28 29 30 31
Hex  : 53 48 41 52 59 4F 20 20 49 44 58 00  11  02  00 01 01 00 01 00 00 00  60  00 00 00 00 00 00 00 00 00
ASCII: S  H  A  R  Y  O        I  D  X                                        '
Data :                   PA PA          NU  11  2      1  1     1            60     

#Indexes from page 2
       { 17 bytes                                        } \/-- Count Column (8)
Hex  : 32 36 41 58 4E 20 20 45 30 38 37 35 34 31 20 20 20  08  00 00 00
ASCII: 2  6  A  X  N        E  0  8  7  5  4  1
Data :                PA PA                      PA PA PA  8   NU NU NU

Hex  : 33 34 42 31 52 20 20 45 30 39 35 37 37 32 20 20 20  09  00 00 00 
ASCII: 3  4  B  1  R        E  0  9  5  7  7  2         
Data :                PA PA                      PA PA PA  9   NU NU NU

Hex  : 33 34 42 33 52 20 20 45 30 38 32 30 37 30 20 20 20  0A  00 00 00
ASCII: 3  4  B  3  R        E  0  8  2  0  7  0            
Data :                PA PA                      PA PA PA  10  NU NU NU
#Header 3
Byte : 0  1  2  3  4  5  6  7  8  9  10 11  12  13  14 15 16 17 18 19 20 21  22  23 24 25 26 27 28 29 30 31
Hex  : 53 48 41 52 59 4F 20 20 49 44 58 00  11  03  00 01 01 00 02 00 00 00  60  00 00 00 00 00 00 00 00 00
ASCII: S  H  A  R  Y  O        I  D  X                                        '
Data :                   PA PA          NU  11  3      1  1     2            60

#Indexes from page 3                                       \/-- Count Column (68)
Hex  : 34 41 33 41 43 38 34 4C 39 59 45 30 31 38 33 37 36  68  00 00 00 
ASCII: 4  A  3  A  C  8  4  L  9  Y  E  0  1  8  3  7  6   h
Data :                                                     68  NU NU NU

Hex  : 34 41 33 41 45 34 35 47 31 33 45 31 33 38 36 34 30  69  00 00 00
ASCII: 4  A  3  A  E  4  5  G  1  3  E  1  3  8  6  4  0   i
Data :                                                     69  NU NU NU

Hex  : 34 41 33 41 45 34 35 47 36 31 45 30 33 30 33 32 30  6A  00 00 00
ASCII: 4  A  3  A  E  4  5  G  6  1  E  0  3  0  3  2  0   j
Data :                                                     6A  NU NU NU

Hex:
ASCII:
Data:

DAT - ?Data?