How to import iphone SMS into Huawei mobile phone?

In daily life, many friends don't know that Apple SMS is imported into Huawei tutorials, so Bian Xiao will share with you something about my childhood today, hoping to bring you help.

Turn on step reading mode

operational approach

0 1

I. What do I need to prepare?

1. Synchronization Assistant

2. Huawei Mobile Assistant

3. Familiar with the basic functions of Excel

02

Second, the main process

1. Synchronization Assistant exports the SMS of iphone →→→→ xxx.csv file (synchronization assistant format).

2, use excel to xxx.csv file (synchronous assistant format) →→→→ XXX. CSV file (Huawei assistant format).

3. Import xxx.csv file (Huawei Assistant format), and you're done!

The most difficult thing is the second step, which is also the focus of this post.

Because my synchronization assistant can connect to iphone, but not mate 10pro (I have tried many computers), so I can only export, not import. If I can import it, I should be able to solve this problem with a software.

03

Third, the specific steps

1. Download the synchronization assistant and export the phone address book.

The exported file can be opened as follows:

There are four columns, namely status, contact, date and content.

04

2. Convert the csv file in synchronous assistant format into Huawei assistant format.

The format of the csv file of Huawei Assistant is as follows (you can use Huawei Assistant to export several short messages at will to see the format):

The correspondence between the two formats

Source →→→→ Status

Change "receiving" to "sender" and "sending" to "recipient"

(excel's if statement gets a blank column. After generating FROM or TO in batches, paste it, paying attention to pasting "value". )

Number →→→→→→→ Contact person

Content →→→→ Content

Time →→→→ corresponding date

ConversationID→→→ should be SMS code. This can be arranged by yourself. If you back up 5000 messages, you can queue them from 1 to 5000 (that's what I did, no problem).

SIM card →→→→→→→ I filled in all zeros, and I don't know how to fill in the dual SIM card.

Adjust the contents of each column through the copy and paste function of Excel to ensure that the first two lines are in Huawei format English. The revised document is as follows:

This looks like Huawei format, and the next few steps are crucial, otherwise it is still impossible to import Huawei assistant.

05

Key 1: Select the number in column # and change the cell format to "Numeric" with 0 decimal places.

The modified form is as follows:

The number of $ NUMBER columns has changed from scientific notation to ordinary numbers.

(If you don't do this, the last few digits of the imported phone number will be 0, so you can't recognize the number normally after importing the phone. )

06

Point 2: put double quotes in English before and after the content column, not in Chinese.

I don't have a particularly good idea about this step, I can only tell you the successful steps of the experiment.

Enter = char (34) in the blank column to the right of C3 cell. C3 & amp； CHAR(34)

This verification code is only used to log in to your WeChat or change the binding.

→→→

"This verification code is only used to log in to your WeChat or change the binding."

Where CHAR(34) is ",and C3 is the cell of the first content of the column corresponding to the content;

The effect after two steps is as follows:

07

The third point: save the file in CSV (comma separated) format;

The fourth point: open the csv file with notepad and edit it;

The opened document is as follows:

At this time, it is necessary to change the ""in the content part into ""and change the three quotation marks into single quotation marks (all English symbols, so it is not clear why it is ""here). The effect after replacement is as follows:

08

Point 5: Notepad saves files as UTF-8 coded csv files.

It should be noted that

A. Yes, save as

B. Save as "All Files"

C. the suffix of the file name should be. csv。

D, the encoding format is UTF-8.

3. Import csv file with Huawei assistant.

At this point, you're done!

09

These are the keys to introducing the Apple SMS brought by Bian Xiao into Huawei's tutorial. I hope you like it. If you like it, you can like it or express your opinion.