---
title: "EPC Import Format Maintenance"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28409322/EPC%20Import%20Format%20Maintenance"
format: markdown
---
# Overview

From **EPC Import Format Maintenance**, you have the option to add, view, and manage EPC import formats.

> ⚠️ These customisable EPC configuration options can be used instead of ETM. To run the EPC without ETM, disable the **EPCviaETM** flag in **Miscellaneous Table Maintenance**.

# Accessing the EPC Import Format Maintenance Screen

To access the **EPC Import Format Maintenance** screen, complete the following:

1. Click the **Frameworks Menu Icon** then navigate to **Inventory** > **Electronic Product Catalogue** > **EPC Import Format Maintenance **from the navigation tree.
2. Click **Find **to return a list of all EPC import formats. The search can be refined by the **Format **ID.

# Navigating the EPC Import Format Maintenance Screen

The **EPC Import Format Maintenance **screen is made up of 3 main sections:

1. EPC Import Format Search
2. EPC Import Format Details
3. Action Buttons

![image-20250326-010007.png](media://bc2de1c5-7580-4a7b-9682-118653a1f286)

## 1. EPC Import Format Search

Click **Find** to return a list of EPC import formats that match your search criteria. The **Format** field is available to customise your search.

## 2. EPC Import Format Details

From here, you can customise the following:

- Enter or change the **Format **ID.
- Add or change a **Description **of the import format.
- Select a **File Type**; either **fixed **or **delimited**.
- When the delimited file type is selected, select an available **Delimiter**; **comma**, **semicolon**, **tab** or **space**.
- Enter the number of **Header Rows **of your import file to be ignored.
- Click **Add **to add a new fieldname classification.

- Click **Remove** to delete the selected line.

<details>
<summary>To learn more about the EPC Import Format Details, click here.</summary>

**Fieldname**

Enter the fieldname ID or use the search icon.

---

**Description**

The field name.

---

**Column #**

Displayed when the file type **delimited** is selected. Enter the respective column number. 

> ℹ️ If data is required on an EPC import that is not provided within the imported field. enter **0** (zero) in the **Column #** field and the required **Default** parameter.

> 📝 **For example**, if the **Order Type **for **Supplier Volume Discounts **must always be set as a **Daily **volume discount when importing a specific EPC file, but the **Order Type **is not included in the import file, then the **type_order_volume_disc** field should have a **Column # **value of **0** (zero) and a **Default **value of **D**.

---

**Start **/ **End**

Displayed when the file type **fixed **is selected. Enter the starting column and end column beneath the **Start** and **End** headers respectively. 

---

**Default**

If the field is to have a default value for each empty field in the EPC import, enter the value here. Otherwise, leave empty.

> ⚠️ A **Default value **is required when the **Column # **is set to **0 **(zero)

---

**Formula**

If a formula is to be applied to the value within the field, enter here ("*****" for multiplication and "**/**" for division for example). Otherwise, leave empty.

> 📝 **For Example: **To hard code a 4% discount to the incoming cost from the supplier, for a supplier volume discount quantity break (up to 6 can be defined) enter *** 0.96** into the **Formular **field. This will change an incoming cost of $5 from the suppliers to be imported as $4.80.

---
</details>

## 3. Action Buttons

Each button here has a different function and will become active at different stages. Expand the sections below to learn more:

### 1. New Button

Click **New** to create a new EPC import format.

> ⚠️ Any changes made to an existing import format must be saved beforehand.

### 2. Save Button

Click **Save** to finalise any changes made to an existing import format.

### 3. Cancel Button

Click **Cancel** to cancel any changes you have made to the current existing import format.

### 4. Delete Button

Click **Delete** to delete the currently selected EPC import format.

### 5. Close Button

Click **Close** to close the **EPC Import Format Maintenance** screen.

> ⚠️ Make sure to save or cancel any changes before closing the screen.

# Additional Information

> ✅ Refer to the [Electronic Product Catalogue (EPC) ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391542)user manuals for more information.

<details>
<summary>Related System Settings - Flags/Numeric/General</summary>

The below system settings may be used to customise the functionality of your Frameworks instance.

**EPCviaETM: **EPC is processed via ETM

> ✅ Refer to [Inventory Related System Settings](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409406) for more information.

**FWPurchaseType: **enables the use of order types in purchase orders and requisitions.

**FWPurchaseDfST: **allows you to set a default order type for purchase orders.

**FWReqDefST: **allows you to set a default order type for purchase requisitions.

> ⚠️ Note that **FWPurchaseDfST** and **FWReqDefST** can only be used if **FWPurchaseType** is enabled.

> ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401318](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401318) for more information.
</details>