# Import Export Function

<span lang="EN-US">Import Export Function can be found across the system.</span>

<span lang="EN-US">Import Export button facilitates the transfer of data between Huge ERP and external files or data from other system.</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-12/scaled-1680-/cxUimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-12/cxUimage.png)

<table border="1" id="bkmrk-export-you-can-click" style="width: 100%; height: 181.6px;"><colgroup><col style="width: 18.4132%;"></col><col style="width: 81.562%;"></col></colgroup><tbody><tr style="height: 46.4px;"><td style="height: 46.4px;">**Export**</td><td style="height: 46.4px;"><span lang="EN-US">You can click the Export button which will return the existing data listing into the required template for import</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">**Import Using ID**</td><td style="height: 29.6px;">Using this option allows one to export with the internal ID.

This means one can change the code of the item

Once you click Import ID. You will receive a warning.

The import using ID refers to including the system ID which should not be changed at any given time.

</td></tr><tr style="height: 46.4px;"><td style="height: 46.4px;">**Select &amp; Upload File**</td><td style="height: 46.4px;"><span lang="EN-US">Click the **Select File** Button to open your file explorer: search and select the import file you saved in the above step.</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">**Verify**</td><td style="height: 29.6px;"><span lang="EN-US">Click the Verify button to check for any errors on the import file</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">**Import**</td><td style="height: 29.6px;">Allows you to be able to import debtors/ Customers to the system</td></tr></tbody></table>

![](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2023-12/embedded-image-pjbr5bll.png)

<table border="1" id="bkmrk-1.-once-you-have-the" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 6.09881%;"></col><col style="width: 94%;"></col></colgroup><tbody><tr><td>**1.**</td><td><span lang="EN-US">Once you have the worksheet populated with the respective new information details, save the file as a normal Excel file.</span>

</td></tr><tr><td>**2.**</td><td>You should get a successful result returned. If not, correct the file, resave the file and retry the Verify

</td></tr><tr><td>**3.**</td><td>If there are any errors when you click verify then you can click on report to see what is causing issues

</td></tr><tr><td>**4.**</td><td>Once Verify is successful, click the Import Button

</td></tr><tr><td>**5.**</td><td>Then click the report button below import to check if all the information were loaded accordingly

</td></tr><tr><td>**6.**</td><td>When all results are successful and you are happy with the report

</td></tr><tr><td>**7.**</td><td>Your New data will be loaded into the system and you can search for it in the normal manner.

</td></tr></tbody></table>

---

#### Verify Errors

When Verifying the data and an error comes up, check the Report of the Verify

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/11Zimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/11Zimage.png)

Open up the report and handle any issues in the Excel file

Line No corresponds with the Excel row line

When in Excel use Crtl + G to enter the Line number with A9952

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/128image.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/128image.png)

Find the corresponding line in Excel to fix or find where the issue is

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/sffimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/sffimage.png)

After all the errors have been sorted, save and close your Excel file

Close the Import Export window to re-upload

Verify the data again

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/JIKimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/JIKimage.png)

Once the Verify is successful, move to importing the data

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/Eh0image.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/Eh0image.png)