How to import csv files in xgeocoding

Method/Steps

Step

Step: Find out what the structure of the CSV file generated by Wandoujia (or other mobile auxiliary software) is. After connecting your mobile phone to Wandoujia on your computer, you can export a csv file and open it with office software. As shown in the picture. The first column

is SMS. The second column deliver refers to the "short" message received, and submit refers to the "short" message sent. The third and fourth columns refer to the other party’s mobile phone number. If this row refers to a "short" message received from (deliver), the mobile phone number is in the third column and the fourth column has no content; if it is a "short" message sent (submit), then The mobile phone number is displayed in the fourth column, and the third column has no content.

The fifth column has no content. The sixth column represents the date, the order is year.month.day

Hour: minute (Note: There is a half-width space between the day and the minute. If the month or day or the hour or minute are single digits, then in Add a space in front of each, which means that we usually use 09 to represent 9, but here

it is represented by

9 (a space plus a 9)) . The seventh column should represent seconds. But the columns of the exported CSV all have the same numbers, so it’s probably a loophole. The eighth column is the specific content of the displayed information. The picture below is a "short" message conversation I exported from Pea Pod for your reference. Comparing it with the csv above, I found that the style is completely different, so it is understandable that it cannot be imported.

Step 2: Edit the CSV file you want to import. To change this CSV file into Wandoujia’s dedicated CSV internal module, open the CSV file with Notepad for editing. "," (quotation marks, commas, and quotation marks, all require half-width) indicates the meaning of column separation.

Editing follows three principles:

1. Add the three symbols "," between columns.

2. The entire content of each line must be enclosed in "".

3. After editing, use the spreadsheet software to open the module exactly the same as the first step.

Step 3: After the above processing, please see the picture below after opening the modified csv file with Notepad. In fact, it is just to reorganize and rewrite the code. Copy the modified content, put it in a new notepad, and delete the original CSV. Change the notepad to its original name and change the suffix from txt to csv. Comparing the diagram opened with spreadsheet software and the diagram exported by Wandoujia, are the modules the same?

Step 4: Create a new Excel table and delete sheet2 and sheet3. According to my practice, not creating a new table will eventually lead to import failure, so it is recommended that you do not skip this step. Sheet2 and sheet3 were deleted because CSV files do not support multiple workbooks.

Step 5: Open the csv file modified in step 3 with spreadsheet software, and copy the content area to the new table. This is a bit like what was described in step three. The third step is to create a standard txt format file, and here we are going to create a standard xls table file.

The sixth step is to save book1 as a file in csv format. This book1.csv can be directly imported into Wandoujia.

/article/49711c614ead70fa441b7cfd.html