fbexport | exporting data and executing SQL statements | SQL Database library
kandi X-RAY | fbexport Summary
kandi X-RAY | fbexport Summary
FBExport is a tool for importing/exporting data and executing SQL statements on Firebird , FBCopy is a tool to copy and compare data accross Firebird databases. export and import data from Firebird databases command line and GUI version runs on Windows and Linux export to comma separated values (CSV) format export as INSERT statements use exported data in DML statements handles NULLs and BLOBs properly ability to execute sql scripts from a file. copy and compare data between Firebird databases runs on Windows and Linux automatically loads tables and compares their fields uses Foreign Keys and Checks to determine the correct order of tables can create ALTER TABLE and CREATE TABLE scripts needed to update the destination database HTML overview of differences in data and metadata.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of fbexport
fbexport Key Features
fbexport Examples and Code Snippets
Community Discussions
Trending Discussions on fbexport
QUESTION
I have already written a bit on this in https://superuser.com/questions/1389657/backup-access-sms-on-nokia-3310-3g-2017-from-linux-pc ; basically, I'm trying to back up SMS messages on a Nokia 3310 3G onto a Ubuntu 18.04 PC; note that hardware system-on-chip and OS differs by version for a Nokia 3310 (2017):
System on chip / Operating system:
- MediaTek MT6260 / Nokia Series 30+ (2G)
- Spreadtrum SC7701B / Java-powered Smart Feature OS (3G)
- Spreadtrum SC9820A / Yun OS (4G, CMCC)
I have the 3G, so I have a "Smart Feature OS" which apparently is a version of KaiOS (Is there any difference between KaiOS and 'Smart Feature OS'? : KaiOS), which apparently (KaiOS – A Smartphone Operating System | Hacker News) is a fork of Firefox OS.
When you hit Menu > Storage > Create backup (https://www.nokia.com/phones/en_int/support/nokia-3310-3g-user-guide/create-a-backup) on this phone, it generates a folder with files in it, named like this:
...ANSWER
Answered 2019-Jan-08 at 03:53The phonebook.ib
is a proprietary file format. I did some analysis and got to the point where I am able to extract names and phones numbers from it.
- Header is 580 bytes and doesn't seem to contain anything interesting.
- Entries appear to begin with the entry length, encoded as 3 4-bit decimal nibbles followed by another digit (version number maybe?).
In my sample file all entries were 940 bytes and therefore had 94 03
as their first two bytes. Other field entries I identified at different offsets:
- entry+0x12a [1 byte]: Number of bytes representing phone number.
- entry+0x12b [1 byte]: Seems like a two-digit decimal coded flag. If high nibble is set (e.g.
10
) then phone number begins with+
. - entry+0x12c: Phone number, decimal coded. For example,
123456
would appear as21 43 65
. Special digits:a
is*
b
is#
f
is ignored (seen as a last digit when the number of digits is not even).
- entry+0x16c [1 byte]: Name length.
- entry+0x16e: Name in UTF-16 (i.e. 2 bytes per char).
Taking your snippet as an example:
- 0x36e is the phone length, 4 bytes.
- 0x36f is the extra flag, high nibble is
0
so no+
prefix. - 0x370 is where the phone number begins,
07 12 80 88
translates to70210888
.
A simple reference parser can be found at my repo: https://github.com/yossigo/phonebook_ib_export
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install fbexport
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page