Export Work From Home Application Records
Home > Management Mode > Application Records > Export Work From Home Application RecordsAdministrators can click Application Records on the Home page of Management Mode, then select Export Work From Home Application Records to enter the Export Work From Home Application Records page. Administrators can export approved and pending Work From Home application records submitted by users (employees) within a specified time range.
Exported Application Record Data Format
In the exported CSV file, all column names are displayed in English, including User ID, Employee ID, Employee Name, Date, Start Time, End Time, Hours, Status, Reason, Manager Name, Submit Time, and Comments. The Chinese names listed above are provided for administrators as a reference for comparison.
The exported application record data fields are in English. The corresponding Chinese field names are listed below:
| No. | English Field | Chinese Field | Description | Example |
|---|---|---|---|---|
| 1 | User ID | Employee ID | The unique identification ID of the user (employee). | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | Personnel Number | The personnel number of the user (employee). | 1 |
| 3 | Employee Name | Employee Name | The name of the user (employee). | Lin Xiaoming |
| 4 | Date | Date | The date of the user’s (employee’s) Work From Home activity, in year/month/day format. | 2025/11/20 |
| 5 | Start Time | Start Time | The start time of the Work From Home period, in hour:minute format. | 09:00 |
| 6 | End Time | End Time | The end time of the Work From Home period, in hour:minute format. | 12:45 |
| 7 | Hours | Hours | The total number of hours calculated based on the start and end times. | 3.75 |
| 8 | Status | Status | The current review status of the application. “approved” indicates approved, “pending” indicates pending review, “declined” indicates rejected, and “canceled” indicates canceled. | approved |
| 9 | Reason | Reason | The reason or description filled in by the employee when submitting the application. | Working from home due to illness |
| 10 | Manager Name | Reviewer | The reviewer of this Work From Home record. | Zhang Xiaoya |
| 11 | Submit Time | Submit Time | The exact time when the user (employee) submitted this application, in year/month/day hour:minute format. | 2025/11/20 16:04 |
| 12 | Comments | Reviewer Response | The response left by the reviewer when approving or rejecting the application. | OK |
Export Data Description
The SwipePoint system permanently stores Work From Home application records in the cloud. However, export permissions and time ranges are subject to limitations based on the organization’s subscription status.
Export Function Categories and Limitations
Based on whether your organization subscribes to the Organization Ad-Free plan, export permissions are divided into the following two categories:
| Subscription Status | Export Scope Limitation | Time Range Limitation |
|---|---|---|
| Not Subscribed to Organization Ad-Free | Limited to individual export only, the “Export All” function is not available. | Can export up to 2 months of data only. |
| Subscribed to Organization Ad-Free | Can choose to export individual records or export all records. | Can export up to 1 year of detailed data. |
How to Resolve Garbled Text in Exported Work From Home Application Records
When opening a Work From Home application record CSV file in Excel on a Windows computer, garbled text may appear. This is usually caused by a mismatch between the CSV file encoding format and Excel’s default encoding format. By default, Excel prefers ANSI (such as Big5) or UTF-16 encoding, while many systems or programs export CSV files using UTF-8.
Method 1: Save the CSV File in a Compatible Encoding Format
- Open the CSV file with a text editor (such as Notepad++ or VS Code).
- Select
Save As. - In the encoding options, choose ANSI (for Traditional Chinese environments, Big5 is recommended) or UTF-8 with BOM.
- Save the file and reopen it in Excel.
Method 2: Use Excel’s “Text Import Wizard”
- Open Excel and create a blank worksheet.
- Select
Data > Get Data > From Text/CSV(or choose “Import Text File” depending on the version). - Browse and select the administrator’s CSV file.
- During the import process, select the correct encoding format (such as UTF-8 or Big5).
- Click Finish to correctly import the data.
Methods for Sharing Files from Mobile Phone to Computer
When exporting Work From Home application records, administrators can perform subsequent operations more effectively 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
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):
- Download Google Drive from the Play Store or App Store.
- Open Google Drive and log in.
- On the Home page of SwipePoint Management Mode, click Application Records, then click Export Work From Home Application Records.
- On the page, select Google Drive to save the file to Google Drive.
Method 2: Transfer Using Messaging Apps
Administrators can send files from their mobile phones using messaging apps such as LINE one-person groups or Facebook Messenger. The steps are as follows (using LINE as an example):
- Open the LINE app on your mobile phone.
- On the LINE Home page, tap the Add Friends icon at the top.
- On the Add Friends page, select Create Group.
- On the Select Friends page, directly tap Next in the top-right corner.
- Enter a group name and tap Create in the top-right corner to complete the creation of a one-person group.
- On the Home page of SwipePoint Management Mode, click Application Records, then click Export Work From Home Application Records.
- On the page, select LINE, then choose the one-person group you just created to save the file in LINE.
Frequently Asked Questions
Q1: Where is the function to export Work From Home application records?
A: You can find the Export Work From Home Application Records function by clicking Application Records on the Home page of Management Mode.
Q2: Who can use the function to export Work From Home application records?
A: Only users (administrators) with Management Mode permissions can export Work From Home application records.
Q3: What fields are included in the exported Work From Home application records?
A: The exported data includes User ID, Employee ID, Employee Name, Date, Start Time, End Time, Hours, Status, Reason, Manager Name, Submit Time, and Comments.
Q4: Why does garbled text appear when opening the exported CSV file?
A: This is usually caused by a mismatch between the CSV file encoding format (UTF-8) and Excel’s default encoding format (ANSI or Big5). It is recommended to save the file using UTF-8 with BOM via a text editor, or to use Excel’s data import function to resolve the issue.
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.