Export Fieldwork Business Trip Application Records
Home > Management Mode > Application Records > Export Fieldwork Business Trip Application RecordsAdministrators can click Application Records on the Home page in Management Mode, then select Export Fieldwork Business Trip Application Records to enter the Export Fieldwork Business Trip Application Records page. On this page, administrators can export fieldwork business trip application records of users (employees) within a specified time range, including records that have been approved and those pending review.
Exported Application Record Data Format
In the exported CSV file, all column names are displayed in English. These include User ID, Employee ID, Employee Name, Date, Start Time, End Time, Hours, Status, Reason, Manager Name, Submit Time, and Comments. The Chinese names above are provided for administrators’ reference.
The exported application record data fields are in English. The corresponding Chinese fields 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) fieldwork business trip, year/month/day. | 2025/11/20 |
| 5 | Start Time | Start Time | The start time of the fieldwork business trip, hour:minute. | 09:00 |
| 6 | End Time | End Time | The end time of the fieldwork business trip, hour:minute. | 12:45 |
| 7 | Hours | Hours | The total hours calculated based on the start and end time. | 3.75 |
| 8 | Status | Status | The current review status of the application. approved means approved, pending means pending review, declined means rejected, and canceled means canceled. | approved |
| 9 | Reason | Reason | The reason or description filled in by the employee when submitting the application. | Going out to meet clients |
| 10 | Manager Name | Approver | The approver of this fieldwork business trip record. | Zhang Xiaoya |
| 11 | Submit Time | Submit Time | The exact time when the user (employee) submitted this application, year/month/day hour:minute. | 2025/11/20 16:04 |
| 12 | Comments | Approver Comments | The comments left by the approver when approving or rejecting the application. | OK |
Export Data Description
The SwipePoint system permanently stores fieldwork business trip application records in the cloud. However, based on the organization’s subscription status, the permissions and time range for exporting data are subject to certain limitations.
Export Function Categories and Restrictions
Depending on whether your organization has subscribed to the Ad-Free Organization plan, export permissions are divided into the following two categories:
| Subscription Status | Export Scope Restriction | Time Range Restriction |
|---|---|---|
| Not Subscribed to Ad-Free Organization | Only individual export is allowed; the “Export All” function is not available. | A maximum of 2 months of data can be exported. |
| Subscribed to Ad-Free Organization | You can choose to export individual records or export all records. | Up to 1 year of detailed data can be exported. |
Solution for Garbled Characters in Exported Fieldwork Business Trip Application Records
When opening a fieldwork business trip application record CSV file in Excel on a Windows computer, garbled characters may appear. This usually occurs because the encoding format of the CSV file does not match 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 “Import Text File” depending on your version). - Browse and select the administrator’s CSV file.
- During the import process, choose the correct encoding format (such as UTF-8 or Big5).
- Click Finish to correctly import the data.
Methods to Share Files from Mobile Phone to Computer
When exporting fieldwork business trip 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: Use Cloud Storage for Transfer
Administrators can upload files from their mobile phone to cloud storage services such as Google Drive or Dropbox. The steps are as follows (Google Drive is used as an example):
- Download Google Drive from the Play Store or App Store.
- Open Google Drive and sign in.
- On the Home page of SwipePoint Management Mode, click Application Records, then click Export Fieldwork Business Trip Application Records.
- On the page, select Google Drive to save the file to Google Drive.
Method 2: Use Messaging Applications for Transfer
Administrators can send files from their mobile phone to a LINE single-person group or messaging applications such as Facebook Messenger. The steps are as follows (LINE is used as an example):
- Open the LINE application 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 upper-right corner.
- Enter a group name and tap Create in the upper-right corner to complete the creation of a single-person group.
- On the Home page of SwipePoint Management Mode, click Application Records, then click Export Fieldwork Business Trip Application Records.
- On the page, select LINE, then choose the single-person group you just created to save the file in LINE.
Frequently Asked Questions
Q1: Where can I find the function to export fieldwork business trip application records?
A: You can find the export function by clicking Application Records on the Home page in Management Mode to enter the Application Records page.
Q2: Who can use the function to export fieldwork business trip application records?
A: Only users (administrators) with Management Mode permissions can export fieldwork business trip application records.
Q3: What fields are included in the exported fieldwork business trip application record data?
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 do garbled characters appear when opening the exported CSV file?
A: This usually occurs because the CSV file encoding format (UTF-8) does not match Excel’s default encoding format (ANSI or Big5). It is recommended to use a text editor to save the file again in UTF-8 with BOM format, or 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.