Fake timestamp to migrate content from other messengers

Mutual Help
4

For others who might want to solve this “quick and easy” and don’t want to mess around with blob storage and manual management of images:

  • Migrate the messages over through the GUI (especially for images) and start every message with a “meta header” like I posted in the screenshot above
    • The “GUI way” is much simpler because a programmatic approach would mean you have to get all param values of the image manually and enter it into the message then:

image
image439×190 12 KB

  • Let your script automagically edit the table msgs for the respective account and parse the “meta header”, generate a unix timestamp from it, overwrite the unix timestamp in field timestamp and remove the meta header from the message fields afterwards (txt and txt_normalized)
  • You don’t need to touch the timestamp_sent and timestamp_rcvd fields so you are always able to determine the date when the message was created in Delta.Chat by right-clicking the message and opening “Info”:

image
image974×1057 93.3 KB

Voila – timestamp manipulation succeeded :wink:

Don’t forget to either do this kind of manipulation on every multi-device client or remove all the devices, do it on your “master device” and re-add the others after you have finished.