A. 変わりません。現在の現場ID(QRコード)が維持されたまま、サーバー側の登録データのみが上書き更新されます。そのため、掲示済みのQRコードを貼り替える必要はありません。
Q. 復元ボタンを押すと「該当する現場データが見つかりません」とエラーが出ます
A. 入力した現場IDが間違っている(スペースが含まれているなど)か、あるいは入力した現場IDに対してまだ一度も 登録する ボタンが押されておらず、サーバー側にマスタが作成されていない可能性があります。IDに間違いがないか確認し、初回は必ず「登録する」を実行してください。
Q. 作業員が「退坑」を押し忘れて帰宅してしまい、現在入坑中リストに残り続けています
A. 現在入坑中を確認する ボタンでリストを表示し、該当作業員の行にある「退坑させる」ボタンを押すことで、管理者が手動で退坑記録をつけることができます。次回該当の作業員が「入坑」または「退坑」を打刻したタイミングでも最新の状態に自動更新されます。一度その現場全体のログを整理したい場合は、画面最下部の この現場の記録データを全消去する ボタンで記録をリセットすることも可能ですが、その場合は同日の他の正しい記録も消去されますのでご注意ください。
Q. 現場IDを紛失し、メモ等にも控えていませんでした。元に戻せますか?
A. ブラウザのキャッシュ(LocalStorage)が残っていれば画面上部に表示されますが、端末故障やブラウザ履歴の削除等で完全に紛失した場合は、セキュリティの仕様上、古いIDを外部から特定して復元することはできません。その場合は、諦めて 新しい現場を作成する(現場IDリセット) を行い、新しい現場IDでQRコードを再発行し、掲示し直してください。
Q. CSVファイルが文字化けする
A. 本システムが出力するCSVには、Excelでの文字化けを防ぐためのBOM(Byte Order Mark)コードを自動で付与しています。それでも文字化けする場合は、Excelの「データ」タブから「テキストまたはCSVから」を選択し、文字コード「UTF-8」を指定して取り込んでください。
👨💼 For Site Managers: Initial Setup & Operation Steps
Managers perform the following initial configuration using setup.html when a new site is established.
Step 1: Enter Site Information
1. Site Name (現場名)
Enter the exact name of the construction project in the "現場名" field.
2. Prime Contractor (元請会社名)
Enter the name of the prime contractor company in the "元請会社名" field.
3. Register First-tier Subcontractors (一次下請け会社名)
Enter the first subcontractor's name in the initial field. If there are more companies, click the + 下請け会社を追加 button to increase the input fields. Enter all first-tier subcontractors entering the site.
* "Prime Staff", "Inspector", and "Guest" are automatically added by the system, so there is no need to enter them here.
Step 2: Master Registration & QR Code Generation
Once all inputs are complete, click the 登録する button.
What happens after clicking:
An alert saying "マスタを登録しました。" (Master registered.) will appear.
A dedicated QR code for workers to access the entry screen will be generated at the bottom of the screen.
The entered Site Name and Prime Contractor name are auto-saved in the browser (LocalStorage) and retained for the next launch.
Preparation for Posting:
Print the generated QR code and post it at the "Entry/Exit Gate" where workers can scan it safely.
[Important] Once the QR code is generated, it will not change even if you add or register more first-tier subcontractor names. There is no need to replace the posted QR code.
Step 3: Site ID Management & Recovery (Important)
A unique "Site ID" is issued for each site and displayed at the top of the screen.
■ Saving the Site ID
Please note down this Site ID in a memo or email. This is necessary in case of device failure or if you need to operate/edit the management screen (setup.html) on another PC or tablet.
■ Editing on Another Device (Recovery)
When opening setup.html on a new device, enter the noted Site ID in the recovery field and press the 復元 (Restore) button to take over the management of that site.
Step 4: Operations During Construction (Verification & Data Output)
■ Check Currently Active Workers & Manual Exit
Click the 現在入坑中を確認する button to display a real-time list of workers who have recorded "Entry" but not "Exit". If a worker forgets to record their exit, the manager can manually process their exit by clicking the "退坑させる" (Force Exit) button on the right side of the list.
■ Download Recorded Data
Specify the period (Start Date - End Date) and click the 記録をCSVでダウンロード button to fetch logs for the specified period. It downloads as a CSV file which can be opened directly in Excel. *If no dates are specified, the logs for the past month will be downloaded.
Step 5: Reset Processing for Site Closure or Troubleshooting
The two buttons at the very bottom of the screen involve data modification or deletion. Ensure you understand their functions before use.
1. 新しい現場を作成する(現場IDリセット)
Purpose: Recreate the site entirely from scratch (Complete Reset).
What is deleted: The "Master" data in the spreadsheet, and local storage data (such as Site Name inputs).
Result: A new Site ID is generated, breaking connection with previous data. The input fields will be completely emptied.
2. この現場の記録データを全消去する
Purpose: Keep the site settings, but delete only the daily "History".
What is deleted: Only the "Logs" and "Currently Active" data in the spreadsheet.
Result: The Site Name, subcontractor list, and current Site ID are maintained.
💡 For Workers: Daily Steps
Step 1: Scan QR Code
Scan using the smartphone's standard "Camera app" (e.g., standard Camera on iPhone, standard Camera or Google Lens on Android).
[Important] Scanning with built-in QR code readers within apps like LINE prevents the page from opening in standard browsers (Safari/Chrome), making it impossible to add the icon to the home screen. Therefore, always use the standard camera app, and immediately add it to your device's home screen as an icon (App registration).
Step 2: Enter Info (First time only)
Fill in Name, Employing Company, and select the First-tier Subcontractor. Data is saved automatically for future use.
Step 3: Record
Press 入坑する (Enter) or 退坑する (Exit).
⚠️ Important: Internet Connection
This system requires an internet connection. If you are in an offline area, your entry/exit will NOT be recorded. Please ensure you have a connection and wait for the confirmation alert.
Step 4: Check Currently Active Workers
Tap the 現在の入坑者を確認する button at the bottom of the entry screen to open the read-only page (view.html). You can check the real-time list of active workers inside the site, which helps in safety management and monitoring personnel.
📱 About PWA (App Installation)
This system supports PWA. By adding the icon to your home screen, you can use it just like a native app.
Benefits
Fast Launch: No need to open the browser; one tap opens the screen.
Stability: Full-screen experience without the address bar.
Offline Display Support: App screens are cached for offline access (※An internet connection is required to record/send data).
❓ Troubleshooting for Managers (FAQ)
Q. I misspelled a subcontractor name, or want to add/change companies.
A. Enter the correct or updated information on the setup screen and click the 登録する button again. The master data will be overwritten and updated while maintaining the existing Site ID.
Q. If I modify the Site Name or Prime Contractor, or add new subcontractors, will the Site ID or QR code change?
A. No, they will not change. The current Site ID (QR code) is maintained, and only the registered data on the server side is overwritten. Therefore, there is no need to replace the posted QR code.
Q. When I click the restore button, I get an error saying "該当する現場データが見つかりません" (No matching site data found).
A. The entered Site ID might be incorrect (e.g., contains spaces), or the 登録する button has never been pressed for this Site ID, meaning no master data exists on the server. Please verify the ID and ensure registration is completed at least once initially.
Q. A worker forgot to press "Exit" before going home, and remains on the active list.
A. The manager can manually process the exit by displaying the list with the 現在入坑中を確認する button and clicking the "退坑させる" (Force Exit) button for that worker. The list will also automatically adjust to the correct state the next time the worker records an "Entry" or "Exit". Alternatively, you can reset the history using the この現場の記録データを全消去する button at the bottom of the screen, but note that this will clear all other valid records for that day as well.
Q. I lost the Site ID and did not write it down. Can it be recovered?
A. If the browser cache (LocalStorage) is still intact, it will appear at the top of the screen. However, if it is completely lost due to device failure or clearing browser history, the old ID cannot be retrieved from the outside due to security specifications. In this case, use 新しい現場を作成する(現場IDリセット) to generate a new ID, reissue the QR code, and repost it.
If you would like to use your own spreadsheet, please donate 500 yen to ID "papa58" via PayPay remittance chat and ask about the method in the remittance chat.