<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Hi Peter,</p>
<p><br>
</p>
<p>Hm, well the problem is you can't have line breaks in a CSV file, because that would make a new row in the CSV.
</p>
<p><br>
</p>
<p>The fix would probably be to convert the FMPro line breaks into something like a vertical line bar then customize the CSV importer to convert vertical bars into line breaks.
</p>
<p><br>
</p>
<p>Does that make sense? </p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Peter MacDonald
<pmacdona@hamilton.edu><br>
<b>Sent:</b> Thursday, January 8, 2015 5:46 PM<br>
<b>To:</b> Archivesspace_Users_Group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] FileMakePro to ArchivesSpace migration</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">I have managed to design a procedure to import FMPro date into AS through CSV import.<br>
<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">But I'm not sure how to handle carriage returns within fields in the FMPro data.<br>
<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">Do I need to remove them all before importing? If I don't remove them, they end up in AS represented as a weird-looking HEX character. Is that okay to leave these in or should I remove
all these carriage returns before importing the CSV file?<br>
<br>
Thanks,<br>
Peter<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br clear="all">
</div>
<div>
<div class="gmail_signature">Peter MacDonald<br>
Library Information Systems Specialist<br>
Hamilton College Library<br>
315 859-4493<br>
Skype: pmacdona-hamilton<br>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>