Export Fieldwork ビジネス旅行のアプリケーション Records
ホーム > 管理モード > 申請記録 > Export Fieldwork ビジネス旅行のアプリケーション Records管理者s can click 申請記録 on the ホーム page in 管理モード, then select Export Fieldwork ビジネス旅行のアプリケーション Records to enter the Export Fieldwork ビジネス旅行のアプリケーション 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 及び those pending review.
Exported Application Record Data Format
内部 exported CSV file, all column names are displayed in 英語. These include 使用r ID, 従業員 ID, 従業員の名前, 日付, 開始時間, End Time, 時間, 状態, 理由, 管理者の名前, 提出時間, 及び 意見. The Chinese names above are provided for administrators’ reference.
The exported application record data fields are in 英語. The corresponding Chinese fields 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 personnel number of the user (employee). | 1 |
| 3 | 従業員の名前 | 従業員の名前 | The name of the user (employee). | Lin Xiaoming |
| 4 | 日付 | 日付 | The date of the user’s (employee’s) fieldwork business trip, year/month/day. | 2025/11/20 |
| 5 | 開始時間 | 開始時間 | 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 | 時間 | 時間 | The total hours calculated based on the start 及び end time. | 3.75 |
| 8 | 状態 | 状態 | The current review status of the application. approved means approved, pending means pending review, declined means rejected, 及び canceled means canceled. | approved |
| 9 | 理由 | 理由 | The reason or description filled in by the employee when submitting the application. | Going out to meet clients |
| 10 | 管理者の名前 | 承認する | The approver of this fieldwork business trip record. | Zhang Xiaoya |
| 11 | 提出時間 | 提出時間 | The exact time when the user (employee) submitted this application, year/month/day hour:minute. | 2025/11/20 16:04 |
| 12 | 意見 | 承認する 意見 | 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 及び time range for exporting data are subject to certain limitations.
Export Function Categories 及び Restrictions
Depending on whether your organization has subscribed to the Ad-Free 組織 plan, export permissions are divided into the following two categories:
| Subscription 状態 | Export Scope Restriction | Time Range Restriction |
|---|---|---|
| Not Subscribed to Ad-Free 組織 | 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 組織 | 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 ビジネス旅行のアプリケーション Records
When you open a UTF-8 fieldwork business trip application 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 及び 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.
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: 使用 Cloud Storage for Transfer
管理者s 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):
- ダウンロード Google Drive from the Play Store or App Store.
- Open Google Drive 及び sign in.
- On the ホーム page of SwipePoint 管理モード, click 申請記録, then click Export Fieldwork ビジネス旅行のアプリケーション Records.
- On the page, select Google Drive to save the file to Google Drive.
Method 2: 使用 Messaging Applications for Transfer
管理者s can send files from their mobile phone to a ライン single-person group or messaging applications such as Facebook Messenger. The steps are as follows (ライン is used as an example):
- Open the ライン application on your mobile phone.
- On the ライン home page, tap the Add Friends icon at the top.
- On the Add Friends page, select Create グループ.
- On the Select Friends 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 ホーム page of SwipePoint 管理モード, click 申請記録, then click Export Fieldwork ビジネス旅行のアプリケーション Records.
- 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 fieldwork business trip application records?
A: You can find the export function by clicking 申請記録 on the ホーム page in 管理モード to enter the 申請記録 page.
Q2: Who can use the function to export fieldwork business trip application records?
A: Only users (administrators) with 管理モード 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 使用r ID, 従業員 ID, 従業員の名前, 日付, 開始時間, End Time, 時間, 状態, 理由, 管理者の名前, 提出時間, 及び 意見.
Q4: Why do garbled characters appear when opening the exported CSV file?
A: Excel may interpret a UTF-8 CSV file without a BOM using another encoding. 使用 Data > Get Data > From File > From Text/CSV 及び select UTF-8及び save a copy as UTF-8 with BOM. Do not convert it to ANSI or Big5, because characters may be lost.
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
この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。