I don't know whether you've fully solved your problem by now, but just in terms of understanding the error message, this part: 
Use of uninitialized value in concatenation (.) or string at parse_vot
+er_list.pl line 251

[download]
happened because of this logic in your code ("execute" call simplified for legibility): 
if(!defined($mlg_addr_id) && length($fields[20]) == 2){
    $sth_insert_mlg_addr->execute(@fields[17..23])
        or warn "While inserting new mailing address |$fields[17]|; |$
+fields[19]| |$fields[20]|, with id |$mlg_addr_id|: " . $dbh->errstr;

[download]
Note how you are including $mlg_addr_id in your error message, specifically on condition that it happens to be undefined. What's the point of that, and how does the undefined variable relate to the "insert_mlg_addr" query being executed in this condition?

I'm not sure I can comment coherently on the rest of your details, but if you haven't heard about "ON DUPLICATE KEY UPDATE ...", you might want to look that up, just in case it's relevant.

In reply to Re: duplicate key check isn't, why not? by graff
in thread duplicate key check isn't, why not? by hesco

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.