topic Re: error merging shapefiles? in Geoprocessing Questions

error merging shapefiles?

ForrestEnglish — Fri, 29 Jul 2011 17:23:22 GMT

I'm trying to merge 3 shapefiles. They all have identical fields, came from the same source, they're just for different counties in my watershed.

I'm trying to combine them, and getting errors when using merge.
ERROR 000278: Failed on input OID 0, could not write value ' ' to output field NFADate

Any ideas what I'm doing wrong?

Re: error merging shapefiles?

ChristopherStorer — Fri, 29 Jul 2011 18:36:29 GMT

It sounds like you have a field that is restricted to non-null, which I don't believe is possible with a shapefile. Are you writing from shapefiles to a shapefile?

Re: error merging shapefiles?

ForrestEnglish — Fri, 29 Jul 2011 20:47:53 GMT

Yup, sure am merging shapefiles. The original data was from a spreadsheet that I plotted based on xy data in the spreadsheet, then I exported that to a shapefile. It's those shapefiles that I'm trying to merge.

Re: error merging shapefiles?

RaabRaab — Mon, 17 Oct 2011 11:39:28 GMT

Hi there,

I am facing the exactly the same problem. Merging shapefiles to a new shapefile, resulting in the Error mentioned in the thread.
Are there any solutions or workarounds?

thanks,
Eike

PS:Using ArcView 10.0 SP3

Re: error merging shapefiles?

ChristopherStorer — Mon, 17 Oct 2011 11:42:17 GMT

If there is a space in the ' ', perhaps you have a field formatted as non-text; '' and ' ' are not quite the same in that instance.

Re: error merging shapefiles?

RaabRaab — Mon, 17 Oct 2011 14:47:05 GMT

Ok,

the problem was caused by fields which share the same name but have different domains (in my case text and integer). And of course a text can not be merged into a integer field.

thanks,
Eike

Re: error merging shapefiles?

AissaFeldmann — Tue, 25 Oct 2011 19:44:05 GMT

I am having the same problem (trying to merge or append simple point shapefiles) and I think it's due to (text) fields that have identical names but different lengths. I did not have this problem in Arc 9.x. Is there a way to manage this in the Field Map or elsewhere?

My only solution seems to be to re-create the problematic fields in a template shape and make them at least as large as the largest record. Help!

(Am using ArcMap 10.0, SP 2, ArcInfo)

Re: error merging shapefiles?

ReneeThompson — Tue, 17 Jul 2012 14:04:32 GMT

Thanks for the responses to this thread, I was able to solve my issue. I worked around error 00278 by taking a closer look at the field map(optional) in the merge tool. You can expand the fields and find which ones may be the culprit. The field types need to match (string, text, double, long - there cannot be a combination under the same heading). In many cases, you may not need ALL the fields when you merge them. So simply "X" (delete) the fields that are causing the problem. If that is not possible...create a new field in each of the merging dataset and recalculate the values, making sure the new field has the same type of values in each dataset. Re-merge the datasets and do not use the old field (delete it from the field map). In my case the PDR (double) field had both double and text entries - I didn't need it so I deleted it. Also the County (text) field had one entry that was (short). See .jpg example.

-Good luck

Re: error merging shapefiles?

RosemaryScavotto — Mon, 28 Sep 2015 18:05:28 GMT

I just wanted to say thank you - I was having the same issue and this totally solved it!