Data Transition Services

Sage 50 and Peachtree Quote Removal Service

An error occurred importing the file

Now what?  The problem could be caused by quotation marks (“) inside your CSV import file.

Most companies use quotes as an inch mark.  So your inventory product description like  4″ x 3″ Gasket, are what is causing the problems.

Why

The import files are CSV files, which means comma-separated-values.  So each field is separated by a comma.  But what happens if the field contains commas?  Like an address field, 123 East Main, #412.  This is where the quotes come in.  Quotes are put around alpha (String) fields so the comma will not separate the field into 2 fields.

But then this creates another problem.  What happens if the field like our gasket size above has quotes for inches?  You import stops with an error.

An error occurred importing the file
C:\xxxxxxx
This happened on:
Line Number 2 Field Name: xxxxxx

The process cannot continue. 

Sage 50 Quote Stripper Service
Sage 50 Import Error

So how do we resolve this problem?

You would need to edit the quotes out of your data.  If you have been using Sage 50 or Peachtree for a few years this option is not available to you.  You are unable to edit transactions in closed years.

The other option is to use our Data Transformation Service.  This service will remove or replace your quotes with either 2 single ‘ or with “in”.  If there is another replacement you would like just let us know.

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reduce file size increase program speed.

Data Transition

Many data-related services, which includes: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Get In Touch

In a world full of options, we wanted to take a moment and say thanks for choosing us.

Our Knowledgebase is available for your technical support questions. 

All Sage 50 and Peachtree Accounting support is provided for a fee.

Contact Us

Contact Info

Fort Lauderdale, Florida, USA
Minneapolis, Minnesota, USA

954 – 523 – 8570

s u p p o r t @ d s c o r p . c o m