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 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 and 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 and 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. In the preview, confirm that the file origin or encoding is UTF-8 and 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 Notepad++ 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

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 Schedule, then click Export Schedule.
  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 single-person group.
  6. On the Home page of SwipePoint Management Mode, click Schedule, then click Export Schedule.
  7. On the page, select LINE and then choose the single-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: 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, and 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 Notepad++ or VS Code, change the encoding to UTF-8 with BOM, and 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 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 single-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 Schedule > Export Schedule, 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 LINE account. LINE ID: @nka7729y | Contact us

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.