オーバータイム出口申請記録
ホーム > 管理モード > 申請記録 > オーバータイム出口申請記録管理者s can click 申請記録 on the ホーム page in 管理モード, then select オーバータイム出口申請記録 to enter the オーバータイム出口申請記録 page. 管理者s can export overtime application records for users (employees) within a specified time range, including approved, pending, 及び declined overtime applications.
Exported Application Record Data Format
内部 exported CSV file, all column names are displayed in 英語. The columns include 使用r ID, 従業員 ID, 従業員の名前, 日付, 開始時間, End Time, 時間, 状態, 理由, 管理者の名前, 提出時間, 及び 意見. The Chinese names listed above are provided for administrators as a reference.
The exported application record fields are in 英語. The corresponding Chinese descriptions are listed below:
| No. | 英語 Field | Chinese Field | Description | Example |
|---|---|---|---|---|
| 1 | 使用r ID | 従業員 ID | The unique identification ID of the user (employee). | dReHKiseggH3kiOlhnj876fheKle |
| 2 | 従業員 ID | 従業員 Number | The employee number of the user (employee). | 1 |
| 3 | 従業員の名前 | 従業員の名前 | The name of the user (employee). | Lin Xiao-Ming |
| 4 | 日付 | 日付 | The date of the employee’s overtime, in year/month/day format. | 2025/11/20 |
| 5 | 開始時間 | 開始時間 | The start time of the overtime, in hour:minute format. | 18:00 |
| 6 | End Time | End Time | The end time of the overtime, in hour:minute format. | 20:45 |
| 7 | 時間 | 時間 | The total hours calculated based on the start 及び end time. | 2.75 |
| 8 | 状態 | 状態 | The current review status of the application. approved means approved, pending means pending, declined means declined, 及び canceled means canceled. |
approved |
| 9 | 理由 | 理由 | The reason or description ente赤 by the employee when submitting the application. | Work not finished |
| 10 | 管理者の名前 | Reviewer | The reviewer of this overtime record. | Zhang Xiao-Ya |
| 11 | 提出時間 | 提出時間 | The exact time when the user (employee) submitted this application, in year/month/day hour:minute format. | 2025/11/20 16:04 |
| 12 | 意見 | Reviewer 意見 | The comments left by the reviewer when approving or rejecting the application. | OK |
Export Data Description
The SwipePoint system permanently stores overtime application records in the cloud. However, depending on the organization’s subscription status, the permissions 及び time range for exporting data are subject to certain restrictions.
Export Function Categories 及び Limitations
Based on whether your organization has subscribed to the Ad-Free 組織 plan, export permissions are divided into the following two categories:
| Subscription 状態 | Export Target Limitation | Time Range Limitation |
|---|---|---|
| Not Subscribed to Ad-Free 組織 | Limited to exporting individual records only, the “Export All” function is not available. | Up to 2 months of data can be exported. |
| Subscribed to Ad-Free 組織 | Can choose to export individual records or export all records. | Up to 1 year of detailed data can be exported. |
How to Fix Garbled Text in Exported オーバータイム申請記録
When you open a UTF-8 overtime application 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
- Open Excel 及び create a blank workbook.
- Select Data > Get Data > From File > From Text/CSV. Some versions display Data > From Text/CSV directly.
- Select the exported CSV file, then select Import.
- 内部 preview, confirm that the file origin or encoding is UTF-8 及び the delimiter is a comma.
- After confirming that the preview is correct, select Load.
Method 2: Save the CSV File as UTF-8 with BOM
- Open the CSV file in a text editor that supports encoding conversion, such as 記号pad++ or VS Code.
- Change the file encoding to UTF-8 with BOM or UTF-8 BOM.
- 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.
How to Share Files from a Mobile Phone to a Computer
When exporting overtime application records, administrators can perform follow-up tasks more efficiently on a computer. Below are several methods for administrators to export files from a mobile phone to a computer:
Method 1: 使用 Cloud Storage for Transfer
管理者s can upload files from their mobile phones to cloud storage services such as Google Drive or Dropbox. The steps are as follows (Google Drive is used as an example):
- ダウンロード Google Drive from the Play Store or App Store.
- Open Google Drive 及び log in.
- On the SwipePoint 管理モード ホーム page, click 申請記録, then click オーバータイム出口申請記録.
- On the page, select Google Drive to save the file to Google Drive.
Method 2: 使用 Messaging Apps for Transfer
管理者s can send files from their mobile phones via messaging apps such as ライン or Facebook Messenger. The steps are as follows (ライン is used as an example):
- Open the ライン app on your mobile phone.
- On the ライン ホーム page, tap the Add Friends icon at the top.
- On the Add Friends page, select Create グループ.
- On the friend selection page, directly tap Next in the upper-right corner.
- Enter a group name 及び tap Create in the upper-right corner to complete the creation of a single-person group.
- On the SwipePoint 管理モード ホーム page, click 申請記録, then click オーバータイム出口申請記録.
- On the page, select ライン, then choose the single-person group you just created to save the file in ライン.
よく聞かれる質問
Q1: Where can I find the function to export overtime application records?
A: You can find the export overtime application records function by clicking 申請記録 on the ホーム page in 管理モード.
Q2: Who can use the function to export overtime application records?
A: Only users with 管理モード permissions (administrators) can export overtime application records.
Q3: What fields are included in the exported overtime application records?
A: The exported overtime application records include the following fields: 従業員 Number (従業員 No.), Name, 開始時間, End Time, 余分時間 時間 (時間), Request 日付, 状態, 余分時間 理由 (理由), 及び Manager.
Q4: Why does garbled text appear when opening the exported CSV file?
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. Import the file using Data > Get Data > From File > From Text/CSV 及び confirm that the encoding is UTF-8及び save it as UTF-8 with BOM before reopening it. Do not convert it to ANSI or Big5.
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
この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。