How can I edit the NDJSON?

[hayvan96]

Hi, I'd like to edit the ndjson in order to correct some lines in the SMS database. As a matter of fact, some entries corrupted, and the sender phone number appears as "33686...." instead of "+3386". This leads to errors when replying to that contact because the number is misformatted (the only app working is the stock lineageos sms app).
So I'd like to correct the lines in the ndjson, I've searched and replaced all "338601" by "+338601", but when I try to import the modified zip file, I get an error saying "XXXX bytes expected but YYY bytes found".
What am I doing wrong, and what should I do to correct the database (by wiping the database and importing a modified archive) ?
Thank you !

[DJCrashdummy]

to collect all related things in one place (although i've stated it already in the related QUIK issue quik-sms/quik#117 (comment)):
the only messages i found in my ndjson without an international number format are messages with a "pseudo number" (just 3 or 4 digits) from my carrier itself or some companies which even not show a number at all but only a name.

---

although i have no idea, i just start by asking the obvious to be on the safe side: have you made sure that you didn't alter the new line character resp. that also the program you used didn't do it automatically?

are the expected and found bytes completely different or not that far off? or even always off be the same number?

does the error occur immediately or do some messages get imported?

[tmo1]

What am I doing wrong, and what should I do to correct the database (by wiping the database and importing a modified archive) ?
Thank you !

I'm not quite sure what you've actually done, but the correct procedure to modify the NDJSON is the following:

1. Unzip the ZIP archive (e.g., unzip messages-xxxxxxxx.zip)
2. Edit messages.ndjson as desired
3. Create a new ZIP archive (e.g.,zip messages-xxxxxxxx-edited.zip messages.ndjson if the original ZIP archive contained only messages.ndjson, or zip -r messages-xxxxxxxx-edited.zip messages.ndjson data/ if it contained a data/ directory as well)

[hayvan96]

Hi, that's what I did, except I didn't rename the (re)zipped file.

[tmo1]

Hi, that's what I did, except I didn't rename the (re)zipped file.

If you post a redacted MRE, I can try to take a look and figure out what's going on.

[tmo1]

Closing due to inactivity.