Export 予定表

ホーム > 管理モード > 予定表 > Export 予定表

管理者s can click 予定表 on the ホーム page under 管理モード, then select Export 予定表 to enter the Export 予定表 page. 管理者s can export user (employee) schedules within a specified time range on this page.

予定表 Record Data Format Description

内部 exported CSV file, all field names are displayed in 英語. The fields include 使用r ID, 従業員 ID, 従業員の名前, スケジュール名, Check Point, 開始時間, End Time, Cross Day, 時間, Breaks, 及び Create Time. The Chinese names above are provided for administrator reference 及び comparison only.

The exported schedule record fields are in 英語. The corresponding descriptions are as follows:

No. 英語 Field Chinese Field Description Example
1 使用r ID 従業員 ID The unique identification ID of the user (employee) dReHKiseggH3kiOlhn876fheKle
2 従業員 ID 従業員 Number The employee number of the user (employee) 1
3 従業員の名前 従業員の名前 The name of the user (employee) Lin Xiaoming
4 スケジュール名 スケジュール名 The name of the schedule Day Shift
5 Check Point Check Point The check-in point name of the schedule Central Branch Company
6 開始時間 開始時間 The start time of the schedule, Year-Month-Day Hour:Minute 2025-11-20 09:00
7 End Time End Time The end time of the schedule, Year-Month-Day Hour:Minute 2025-11-20 18:00
8 Cross Day Cross Day Whether the schedule crosses days, YES indicates yes, blank indicates no
9 時間 労働時間 The total working hours of this schedule record 8
10 Breaks Break Time The break time 及び duration of this schedule record, Time(Duration) 12:00(1h)
11 Create Time Create Time The creation time of this schedule record, Year-Month-Day Hour:Minute 2025-11-18 10:34

How to Resolve Garbled Characters in 予定表 Records

When you open a UTF-8 schedule record CSV file directly in Excel for Windows, text may appear garbled if the file does not contain a byte order mark (BOM) or Excel interprets it using another encoding. We recommend importing the file 及び selecting UTF-8. Do not convert the file to ANSI or Big5, because characters that those encodings cannot represent may be lost.

Method 1: Import the UTF-8 CSV File in Excel

  1. Open Excel 及び create a blank workbook.
  2. Select Data > Get Data > From File > From Text/CSV. Some versions display Data > From Text/CSV directly.
  3. Select the exported CSV file, then select Import.
  4. 内部 preview, confirm that the file origin or encoding is UTF-8 及び the delimiter is a comma.
  5. After confirming that the preview is correct, select Load.

Method 2: Save the CSV File as UTF-8 with BOM

  1. Open the CSV file in a text editor that supports encoding conversion, such as 記号pad++ or VS Code.
  2. Change the file encoding to UTF-8 with BOM or UTF-8 BOM.
  3. Save it as a new file, then open the new file in Excel.

For more information, see Microsoft: Opening CSV UTF-8 files correctly in Excel.

Methods to Share Files from Mobile Phone to Computer

When exporting schedule records, administrators can perform subsequent operations more efficiently on a computer. Below are several methods for administrators to export files from a mobile phone to a computer:

Method 1: Transfer Using Cloud Storage Services

管理者s can upload files from their mobile phones to cloud storage services such as Google Drive or Dropbox. The steps are as follows (using Google Drive as an example):

  1. ダウンロード Google Drive from the Play Store or App Store.
  2. Open Google Drive 及び log in.
  3. On the ホーム page of SwipePoint 管理モード, click 予定表, then click Export 予定表.
  4. On the page, select Google Drive to save the file to Google Drive.

Method 2: Transfer Using Messaging Applications

管理者s can send files from their mobile phones using messaging applications such as ライン or Facebook Messenger. The steps are as follows (using ライン as an example):

  1. Open the ライン application on your mobile phone.
  2. On the ライン ホーム page, tap the Add Friends icon at the top.
  3. On the Add Friends page, select Create グループ.
  4. On the Select Friends page, directly tap Next in the upper-right corner without selecting any friends.
  5. Enter the group name, then tap Create in the upper-right corner to complete the creation of a single-person group.
  6. On the ホーム page of SwipePoint 管理モード, click 予定表, then click Export 予定表.
  7. On the page, select ライン 及び then choose the single-person group you just created to save the file to ライン.

よく聞かれる質問

Q1: Where can administrators run the schedule export function?

A: 管理者s should enter the ホーム page under 管理モード, click 予定表, 及び then select Export 予定表 to enter the page 及び export employee schedules within a specified time range.

Q2: What specific schedule record fields are included in the exported CSV file?

A: The file includes the following fields: 使用r ID, 従業員 ID, 従業員の名前, スケジュール名, Check Point, 開始時間, End Time, Cross Day, 時間, Breaks, 及び Create Time.

Q3: Why do garbled characters appear when opening the exported CSV file in Excel?

A: SwipePoint exports CSV files in UTF-8. If Excel does not detect UTF-8 correctly when opening the file directly, Chinese text may appear garbled.

Q4: What methods are available to fix garbled character issues?

A: There are two main methods:

  1. Excel import: Open a blank Excel workbook, select Data > Get Data > From File > From Text/CSV, 及び confirm in the preview that the encoding is UTF-8.

  2. Save as a new file: Open the CSV in a text editor such as 記号pad++ or VS Code, change the encoding to UTF-8 with BOM, 及び save it as a new file. Do not convert it to ANSI or Big5.

Q5: How should the “Cross Day” field in exported data be interpreted?

A: This field indicates whether the schedule crosses days. If the field displays YES, it means the schedule is a cross-day schedule. If it is blank, it means no.

Q6: What is the format of the “Breaks” field in schedule records?

A: This field displays the break time 及び duration in the format Time(Duration), for example, 12:00(1h).

Q7: If I want to send files from my phone to a computer via ライン, how do I create a group for file transfer?

A: You can create a single-person group. On the ライン Add Friends page, select Create グループ, do not select any friends on the Select Friends page, 及び directly tap Next. Enter the group name 及び tap Create. Then, when exporting schedule records, select sharing to ライン 及び choose this group.

Q8: How can I transfer schedule files from my phone to a computer using Google Drive?

A: First, download 及び log in to the Google Drive app. On the ホーム page of SwipePoint 管理モード, click 予定表 > Export 予定表, then select Google Drive to save the file. After completion, you can open Google Drive on your computer to download the file.

Subscribers receive faster support. If you encounter an error or have trouble using SwipePoint, contact the SwipePoint team through the official ライン account. ライン ID: @nka7729y | Contact us

この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。