[Archivesspace_Users_Group] Migration error: character limit

[Holland, Andrew S]

I just removed a bunch of the text before I migrated. I can't actually remember if I tried adding it back in after the successful migration or not.

If you are on SQL server, you can run something like:
SELECT * FROM tblCollections_Collections WHERE (LEN(field_name) > 65000)

If LEN gives you an error, try DATALENGTH

I think on mysql you just swap out LEN for LENGTH.

-Andrew

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Colleen McFarland
Sent: Thursday, January 08, 2015 10:48 AM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Migration error: character limit

Good morning:

We're encountering migration errors of "must be less than 65,000 characters" (TEXT field) for fields in Archon which are MEDIUMTEXT and which are quite lengthy. So far in testing we've resolved these by deleting that data. One, is there a way to migrate these large text fields, given that we were allowed more space in Archon? Two, is there a query we can do on the Archon database to identify these large fields before finding them one-by-one as errors in the migration process?

Thanks in advance!

Best,
Colleen

Colleen McFarland, Director of Archives and Records Management, Mennonite Church USA
colleenm at mennoniteusa.org<mailto:colleenm at mennoniteusa.org>, 1700 S. Main St. Goshen, IN 46526, 574-523-3039 (direct), 1-866-866-2872 ext. 23039 (toll-free)
www.mennoniteusa.org<http://www.mennoniteusa.org/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150108/e111ffdb/attachment.html>