---
title: Importing Data
description: "## Error Messages The following are error messages that you may encounter, what it means, and how to resolve it. ### Required **What it means** This means that the field specified for the column field is a required field.  **How…"
url: "https://resources.oojeema.com/docs/troubleshoot-import-data/"
updated: "2024-03-28"
category: Troubleshooting Guide
---

# Importing Data

## Error Messages

The following are error messages that you may encounter, what it means, and how to resolve it.

### Required

**What it means**
This means that the field specified for the column field is a required field. 

**How to resolve**
Make sure that the column field for the row being imported is not left blank

### Duplicate in database

**What it means**
There is already an existing record in the system

**How to resolve**
Make sure you are not re-uploading the same data or change the parameters of the record being uploaded 

### Parent is required if Type field is Child or Both

**What it means**
You are uploading a GL account where you specified that it is a child account or both *(meaning it is a child of an account and the account you are uploading is also a parent account)* you have to specify the parent account. 

**How to resolve**
Make sure you fill up the Parent column with the appropriate parent account.

### *[RECORD]* Not Found

**What is means**
When uploading transactions via a template and encountering an error message saying that a specific record is not found. It usually means one of the following:

- The record that the system is validating against is not existing yet.
- It may be existing but there are extra characters in the template that are not visible. This maybe be extra spaces in front or at the end of the record

**How to resolve**

- Make sure that record being referred to in the error message exists
- Check the record in your import template file and make sure there are no spaces in front or at the end.
- Try re-typing the data in the cell manually

### Invalid date.  Use YYYY-MM-DD format

**What is means**

The system reads the date format in a specific way to make sure it doesn't mix up the day and the month. In some cases, the spreadsheet you are using may have reformatted the date format you have entered.

**How to resolve**

- Make sure to set the correct date format
- You can add a single quote( ' ) in front of your date (ex. '2020-05-23). This will keep your spreadsheet software from changing the date format.