如何将短信备份文件（CSV格式）从Android导入到iPhone [英] How to import SMS backup file(CSV format) took from Android to iPhone

问题描述

我有一个从Android导出的SMS备份（CSV格式）文件，其中每个记录都是短信。我希望将此文件以编程方式导入到iPhone。谁能帮助我在iOS中执行此操作。

感谢您的帮助。

解决方案方案

最近，我成功地从iPhone备份中提取了消息记录。我通常了解iPhone备份的机制/设计。因此，我希望理论上可以给你一些提示。

可能的步骤：

1. 从iPhone到OS X设备创建未加密的备份
   这是10个数据库表。关键表是消息（文本，日期，handle_id等）和句柄（联系人列表）。




2. 现在是时候使用您的SMS CSV文件来导入到SQLite数据库中。为此，您需要具备以下知识：从csv文件向db插入数据，以及通过了解图片中显示的表来备份数据库架构。




3. 之后插入SMS CSV文件，然后在iPhone备份中替换3d0d7e5fb2ce288813306e4d4636395e047a3d28。最后，您可以使用iTunes从此备份中恢复iPhone。

上面的所有希望都会给您一些帮助。干杯！

I have a SMS backup(CSV format) file exported from Android where each record is the text message. I want this file to be imported to iPhone programmatically. Could anyone help me how to do this in iOS. I'm not getting any resource for doing this so for.

Any help is appreciated.

解决方案

Recently, I succeeded extracting message records from iPhone backups. I generally understand the mechanism/design of iPhone backups. So I hope I can give you some hints in theory to do it.

The possible steps:

1. Create a unencrypted backup from iPhone to your OS X devices through iTunes. But make sure DO NOT check the option "Encrypt iPhone backup" since you are going to update (import your SMS backup) the backup.

2. Find the backup you just have done. My OS X is 10.12.6, the directory is /Users/your user/Library/Application Support/MobileSync/Backup/

3. Then, go into the directory Backup/ and find the directory for iPhone Message. Mine is /Users/myusername/Library/Application Support/MobileSync/Backup/7aded5a6a493ac0b3c41cc930a5421ca035610b5/3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28 As I known, there is only one directory under Backup/, and the following path "3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28" is all the same for every backup. So hopefully you will find it without problems.

4. The file 3d0d7e5fb2ce288813306e4d4636395e047a3d28 is a SQLite DB. Copy and paste it to somewhere easier to reach for a SQLite visual tool called "DB Browser for SQLite". (If you prefer using command line just type sqlite to enter and use command ".open 3d0d7e5fb2ce288813306e4d4636395e047a3d28" to enter the DB)

5. After you open 3d0d7e5fb2ce288813306e4d4636395e047a3d28 with SQLite you should see: Here are 10 database tables. The key tables are message (text, date, handle_id etc.) and handle (contact list).

6. Now it's the time to use your SMS CSV file to import into the SQLite DB. To do this, you need the knowledge of inserting data to db from csv files, and the backup database schema by understanding the tables showing in the pic.

7. After inserting your SMS CSV file, replace the 3d0d7e5fb2ce288813306e4d4636395e047a3d28 in the iPhone backup. Finally you can use iTunes to recover your iPhone from this backup.

Hope all above will give you some ideas. Cheers!

这篇关于如何将短信备份文件（CSV格式）从Android导入到iPhone的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！