Export Schedule

Home > Management Mode > Schedule > Export Schedule

Administrators can click Schedule on the Home page under Management Mode, then select Export Schedule to enter the Export Schedule page. Administrators can export user (employee) schedules within a specified time range on this page.

Schedule Record Data Format Description

In the exported CSV file, all field names are displayed in English. The fields include User ID, Employee ID, Employee Name, Schedule Name, Check Point, Start Time, End Time, Cross Day, Hours, Breaks, and Create Time. The Chinese names above are provided for administrator reference and comparison only.

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

No. English Field Chinese Field Description Example
1 User ID Employee ID The unique identification ID of the user (employee) dReHKiseggH3kiOlhn876fheKle
2 Employee ID Employee Number The employee number of the user (employee) 1
3 Employee Name Employee Name The name of the user (employee) Lin Xiaoming
4 Schedule Name Schedule Name The name of the schedule Day Shift
5 Check Point Check Point The check-in point name of the schedule Central Branch Company
6 Start Time Start Time 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 Hours Working Hours The total working hours of this schedule record 8
10 Breaks Break Time The break time and 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 Schedule Records

When opening exported schedule record CSV files in Excel on Windows computers, garbled characters may appear. This is usually caused by a mismatch between the CSV file encoding and Excel’s default encoding. By default, Excel prefers ANSI (such as Big5) or UTF-16 encoding, while many systems or programs export CSV files in UTF-8.

Method 1: Save the CSV File in a Compatible Encoding Format

  1. Open the CSV file using a text editor (such as Notepad++ or VS Code).
  2. Select Save As.
  3. In the encoding options, choose ANSI (for Traditional Chinese environments, Big5 is recommended) or UTF-8 with BOM.
  4. Save the file and reopen it in Excel.

Method 2: Use Excel’s Text Import Wizard

  1. Open Excel and create a blank worksheet.
  2. Select Data > Get Data > From Text/CSV (or Import Text File, depending on the version).
  3. Browse and select the administrator’s CSV file.
  4. During the import process, choose the correct encoding format (such as UTF-8 or Big5).
  5. Complete the process to correctly import the data.

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

Administrators 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. Download Google Drive from the Play Store or App Store.
  2. Open Google Drive and log in.
  3. On the Home page of SwipePoint Management Mode, click Leave, then click Export Schedule Records.
  4. On the page, select Google Drive to save the file to Google Drive.

Method 2: Transfer Using Messaging Applications

Administrators can send files from their mobile phones using messaging applications such as LINE or Facebook Messenger. The steps are as follows (using LINE as an example):

  1. Open the LINE application on your mobile phone.
  2. On the LINE Home page, tap the Add Friends icon at the top.
  3. On the Add Friends page, select Create Group.
  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 one-person group.
  6. On the Home page of SwipePoint Management Mode, click Leave, then click Export Schedule Records.
  7. On the page, select LINE and then choose the one-person group you just created to save the file to LINE.

Frequently Asked Questions

Q1: Where can administrators run the schedule export function?

A: Administrators should enter the Home page under Management Mode, click Schedule, and then select Export Schedule to enter the page and 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: User ID, Employee ID, Employee Name, Schedule Name, Check Point, Start Time, End Time, Cross Day, Hours, Breaks, and Create Time.

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

A: This usually occurs because the CSV file encoding (typically UTF-8) does not match Excel’s default encoding (ANSI or UTF-16).

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

A: There are two main methods:

  1. Save As: Open the CSV file with a text editor (such as Notepad++), select Save As, and change the encoding to ANSI (Big5) or UTF-8 with BOM.

  2. Excel Import: Open a blank Excel worksheet, select Data > Get Data > From Text/CSV, and choose the correct encoding (such as UTF-8 or Big5) during the import process.

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 and 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 LINE, how do I create a group for file transfer?

A: You can create a one-person group. On the LINE Add Friends page, select Create Group, do not select any friends on the Select Friends page, and directly tap Next. Enter the group name and tap Create. Then, when exporting schedule records, select sharing to LINE and choose this group.

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

A: First, download and log in to the Google Drive app. On the Home page of SwipePoint Management Mode, click Leave > Export Schedule Records, then select Google Drive to save the file. After completion, you can open Google Drive on your computer to download the file.

This manual strives for accuracy and completeness, but we do not assume any liability for errors, omissions, or updates. The content may be modified at any time without prior notice. We are not responsible for any damages arising from the use of this manual or downloading its contents, including but not limited to system failures, data loss, or infringement of rights. Users assume full responsibility and risk.