---
title: "Import issues with PCF fields from CSV"
canonical: "https://support.appfire.com/space/PSJ/1589020745/Import%20issues%20with%20PCF%20fields%20from%20CSV"
format: markdown
---
> ℹ️ For detailed information about CSV imports in Jira, see the [Atlassian Documentation](https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html).

## Import issues with PCF fields using JSON format

### **Prerequisites **

- CSV file containing with PCF data in JSON format.
- Appropriate permissions in the target Jira instance.
- Target Jira project with corresponding custom fields.

### Procedure

1. Clean your CSV file. Remove unnecessary columns and verify the PCF data is in valid JSON format.  
This is an example of a CSV file with a header column and data for a Summary field and three PCF custom fields:

```
Summary,Custom field (PCF_MS),Custom field (PCF_SA),Custom field (PCF_SS)
s2Import,"[{""label"":""MFP-4"",""value"":""10001""},{""label"":""MFP-2"",""value"":""10000""}]","[{""label"":""JIRAUSER10000"",""value"":""JIRAUSER10000""},{""label"":""Bulgaria"",""value"":""Bulgaria""}]"
s2Import,"[{""label"":""MFP-1"",""value"":""10000""},{""label"":""MFP-3"",""value"":""10002""}]","[{""label"":""JIRAUSER10000"",""value"":""JIRAUSER10000""},{""label"":""Greece"",""value"":""Greece""}]"
```

2. In Jira, press `gg` and type External System Import in the search field. This opens the Jira import wizard page illustrated below:
3. Click **CSV**.
4. Select the CSV file for upload.
5. Select the target Jira project.
6. Map the CSV fields to existing Jira custom fields.

> 📝 Field mappings must be accurate to ensure data integrity

7. Click **Begin Import**.

### What to do next

After the import completes, verify that all the PCF fields were successfully imported.

1. Check imported issues
  - Verify all PCF fields are populated correctly.
  - Confirm JSON data was parsed properly.
  - Review field values in different views (issue view, board view).
2. Address Missing Fields
  - If fields are missing, verify they exist in the target Jira instance.
  - Check field permissions and schemes.
  - Ensure field contexts are properly configured.


---

## Import issues with PCF fields using direct value

Some PCF fields use direct string values rather than JSON formatting during import. These include:

- PCF - Interval Field
- PCF - Regular Expression Custom Field

When importing these fields from CSV, use the raw value without any special formatting. 

### Examples

| **Field type** | **Data in CSV** |
| --- | --- |
| PCF - Interval Field | The value can be entered in two formats:<br>1. Standard Jira interval notation:<br>```
Summary,Custom field (interval_field)
pcf-interval-s1,"1w 2d 3h"
```<br>2. Seconds format (based on an 8-hour working day):<br>```
Summary,Custom field (interval_field)
pcf-interval-s1,"212400.0"
``` |
| PCF - Regular Expression Custom Field | ```
Summary,Custom field (regex_field)
pcf-regex-s1,"[a-z]+@[a-z]+\\.com"
``` |