From release 1.17 there will be some changes in database structure:
TxPwr and RxPwr fields will be removed from newly deployed databases, and replaced with TxPwrDecimal and RxPwrDecimal (both fields will store DECIMAL fields). This limitation is due to the limitation in sqlite to REMOVE fields and CHANGE fields data structure (from INT to DECIMAL should be possible, but it's not supported).
They should not be used anymore.
New fields will be added (some are not used yet):
ClubLogQsoUploadDate
ClubLogQsoUploadStatus
HrdlogQsoUploadDate
HrdlogQsoUploadStatus
MyFists
MySotaRef
MyUsacaCounties
MyVuccGrids
AwardSubmitted
AwardGranted
Fists
FistsCc
QrzcomQsoUploadDate
QrzcomQsoUploadStatus
RxPwrDecimal
Skcc
SotaRef
SubMode
TxPwrDecimal
UsacaCounties
VuccGrids
QsoAwards
Database structure change from version 1.17
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Database structure change from version 1.17
Daniele Pistollato - IW3HMH
- G4POP
- Log4OM Alpha Team
- Posts: 10827
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Database structure change from version 1.17
I agree that the implementation of the latest changes to ADIF are awful although the new fields are sensible! its just the way it was re-designed that I object to.
However I think you have done a great job being able to incorporate these changes without major disruption to the program, even with the odd SQLite shortcoming.
However I think you have done a great job being able to incorporate these changes without major disruption to the program, even with the odd SQLite shortcoming.
73 Terry G4POP
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Database structure change from version 1.17
I will be forced to split the export in 2 different versions, 2.4 and 3.04 to be able to deal with the rest of the world that is working in 2.4
Also import will be made in 2 different formats.
Also using new "mode/submode" system will be a big mess. I will definitely leave ADIF data structure on database to be more flexible and being able to work in a better way keeping the compatibility and the user experience like the one we have right now
Also import will be made in 2 different formats.
Also using new "mode/submode" system will be a big mess. I will definitely leave ADIF data structure on database to be more flexible and being able to work in a better way keeping the compatibility and the user experience like the one we have right now
Daniele Pistollato - IW3HMH
- G4POP
- Log4OM Alpha Team
- Posts: 10827
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Database structure change from version 1.17
I have noticed that two or three other developers have done the same, they provided a choice for the user to decide what version of ADIF to import from or export toIW3HMH wrote:I will be forced to split the export in 2 different versions, 2.4 and 3.04 to be able to deal with the rest of the world that is working in 2.4 - Also import will be made in 2 different formats.
73 Terry G4POP