# Weekly off Import

### 1. How to remove weekly off?

To remove weekly offs in bulk there is no other option than replacing the existing weekly offs. To remove the weekly off in bulk you need to upload the updated weekly off list.

**Path**: Cloud Portal>Attendance>Import>Weekly Off Import>enter details>map components to Excel column>Save Settings>Import Template>Upload

**Step 1**: Log into the cloud portal, go to the ‘Attendance’ menu and under the ‘Import’ submenu click on the ‘Weekly Off Import’ option.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FMVUpTAvZADBL5ATUaF6Y%252F0.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=67311edc&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 2**: Download the ‘Sample Week Off Import’ file from the upper right-hand corner of the screen and prepare the Excel sheet accordingly.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FTFVD9gRbZ0JBDwiHgmFD%252F1.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=9a8f77ba&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 2**: ‘Select Settings’ and fill in the details such as, Starting-Ending Row, From Date and To Date in the respective fields.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FbOQ1vsicy0BJj2o1k6t1%252F1st%2520%281%29.png%3Falt%3Dmedia%26token%3D8b63fae6-9d81-4d9f-8d9c-1b95e21a04b4&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=47a06557&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 3**: Map the Section Name components to the Excel Column according to the sheet you prepared to upload.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FVONCjaob8QvyLLIujW7N%252F3.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=bb7d7ad6&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 4:** Unselect the check box of 'Insert without replacement' to remove old weekly off and upload updated weekly off and click on the ‘Save Settings’ button.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FWR5nbnnyCpy3cvYfsFGH%252F2nd.png%3Falt%3Dmedia%26token%3Def68bf89-1358-419b-8f79-c405a5dabed7&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=e5b8dff5&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Note**: If the settings are employee wise, the employee codes should be in the ‘Column A’ of the Excel sheet.

**Step 5:** Upload the file in the ‘Import Template’ field and click on the ‘Upload’ button. The weekly off details will be uploade&#x64;**.**

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252Fp0GfdpdZLEwCHELoflZ4%252F3rd.png%3Falt%3Dmedia%26token%3Dd231c72a-56d1-46b0-8234-a7cc19f59ef0&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=d370bd71&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Note**: Before you upload a file for import in the Pocket HRMS, you need [to format the columns with a date to ‘Text to Column’ in Excel](https://docs.pockethrms.com/faqs/cloud-portal#id-11.-what-to-do-if-the-system-shows-error-while-uploading-excel-file-for-import) sheet.

**Link**: <https://cloud.pockethrms.com/Leave/Setting/LeaveImport?import=41>

For any queries, contact <support@pockethrms.com>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pockethrms.com/faqs/cloud-portal/attendance/import/weekly-off-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.