[OPEN-ILS-DEV] MARC Record Import from txt

[Dan Scott]

On Wed, Dec 14, 2011 at 1:18 PM, Elliot Voris <evoris at slcconline.edu> wrote:
> Hi, Dan
>
> Thanks again for your help! I'm still having no luck. As a test measure, I removed any single-quotes (') from the MARC records before enclosing them in the format that your script was in: ('<MARC>'), so I'm sure my issue is something else.
>
> I'm wondering if PostgreSQL doesn't like the way I put the parenthesis and single-quotes to begin with. The only method I could figure out to put the necessary characters in place was using Notepad++. I did a find/replace with the regular expressions as follows:
>
> To place the "('" at the beginning, I found the regular expression "^(.*)$" (no quotes), and replaced with the regex "('\1" (again, no quotes)
> To place the "')," at the end, I found the regular expression "^(.*)$" (no quotes), and replaced with the regex "\1')," (again, no quotes)
>
> Could that have messed up encoding or something? Is there a better way to add the necessary parenthesis & single-quotes at the beginning/end of each line?

Elliot:

It might be easiest to debug if you could attach a small sample of
your import script - say, 10 lines - so that we can see what it
actually looks like.

Dan