Free VCF file to CSV or Excel converter / Tickets / #11 Can't handle a list of over 10k contacts

Greg Hadlock - 2019-08-11

So sorry to hear that you are having trouble; I’ve seen several instances where people have 12K contacts without issue, and the subscript out of range generally refers to an issue within a single contact when special characters or escape characters are encountered and the program treats them incorrectly. I’d like to debug this to make the program better and there are several ways I might do this:

1) I could run through the same large VCF file you have if you wanted to share it via Dropbox or some other sharing method
2) You could click on “Debug” when this occurs and send me a screenshot of what you are seeing, and then perhaps you are able to determine which contact is causing the problem and send me that contact and the few before and after it…
3) We could share screens with TeamViewer and I could troubleshoot in front of you, or at least collect the information I need for next steps.

This is probably a quick fix if you’d like to help me find the issue. Thanks for reporting it, I greatly appreciate it!

Greg Hadlock

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Greg Hadlock - 2019-08-11

So sorry to hear that you are having trouble; I've seen several instances
where people have 12K contacts without issue, and the subscript out of range
generally refers to an issue within a single contact when special characters
or escape characters are encountered and the program treats them
incorrectly. I'd like to debug this to make the program better and there
are several ways I might do this:

I could run through the same large VCF file you have if you wanted
to share it via Dropbox or some other sharing method

You could click on "Debug" when this occurs and send me a screenshot
of what you are seeing, and then perhaps you are able to determine which
contact is causing the problem and send me that contact and the few before
and after it.

We could share screens with TeamViewer and I could troubleshoot in
front of you, or at least collect the information I need for next steps.

This is probably a quick fix if you'd like to help me find the issue.
Thanks for reporting it, I greatly appreciate it!

Greg Hadlock

From: Savas savas101@users.sourceforge.net
Sent: Sunday, August 11, 2019 5:52 AM
To: Ticket #11: Can't handle a list of over 10k contacts
11@tickets.bulkvcftocsv.p.re.sourceforge.net
Subject: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k contacts

[tickets:#11] https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't
handle a list of over 10k contacts

Status: open
Milestone: Ticket Submitted
Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
Last Updated: Sun Aug 11, 2019 09:52 AM UTC
Owner: Greg Hadlock

Merged all my backed up contacts into one VCF file, over 15k contacts,
obviously mostly dups. It loads for about less than a minute and then gives
an error box:

Run-time error '9':

Subscription out of range

Option to end, debug, help.

Easily reproducable, if you just generate a large list.

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/bulkvcftocsv/tickets/11/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

Related

Tickets: #11

alternate
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Savas - 2019-08-13
  
  Hi Greg
  
  Thank you for your reply, I was busy with work so I did not have a chance to reply.
  
  As soon as I'm back home I'll rerun it and share with you the debugging information. I'd rather not share my contacts as it's not mine to share, ownership that I'd be sharing other people's private information. Hope you understand.
  
  Thanks
  
  Savas
  
  From: Greg Hadlock ghadlock@users.sourceforge.net
  Sent: Sunday, August 11, 2019 12:27:32 PM
  To: [bulkvcftocsv:tickets] 11@tickets.bulkvcftocsv.p.re.sourceforge.net
  Subject: [bulkvcftocsv:tickets] Re: #11 Can't handle a list of over 10k contacts
  
  So sorry to hear that you are having trouble; I've seen several instances
  where people have 12K contacts without issue, and the subscript out of range
  generally refers to an issue within a single contact when special characters
  or escape characters are encountered and the program treats them
  incorrectly. I'd like to debug this to make the program better and there
  are several ways I might do this:
  
  I could run through the same large VCF file you have if you wanted
  to share it via Dropbox or some other sharing method
  
  You could click on "Debug" when this occurs and send me a screenshot
  of what you are seeing, and then perhaps you are able to determine which
  contact is causing the problem and send me that contact and the few before
  and after it.
  
  We could share screens with TeamViewer and I could troubleshoot in
  front of you, or at least collect the information I need for next steps.
  
  This is probably a quick fix if you'd like to help me find the issue.
  Thanks for reporting it, I greatly appreciate it!
  
  Greg Hadlock
  
  From: Savas savas101@users.sourceforge.netsavas101@users.sourceforge.net
  Sent: Sunday, August 11, 2019 5:52 AM
  To: Ticket #11: Can't handle a list of over 10k contacts
  11@tickets.bulkvcftocsv.p.re.sourceforge.net11@tickets.bulkvcftocsv.p.re.sourceforge.net
  Subject: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k contacts
  
  [tickets:#11]https://sourceforge.net/p/bulkvcftocsv/tickets/11/ https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't
  handle a list of over 10k contacts
  
  Status: open
  Milestone: Ticket Submitted
  Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
  Last Updated: Sun Aug 11, 2019 09:52 AM UTC
  Owner: Greg Hadlock
  
  Merged all my backed up contacts into one VCF file, over 15k contacts,
  obviously mostly dups. It loads for about less than a minute and then gives
  an error box:
  
  Run-time error '9':
  
  Subscription out of range
  
  Option to end, debug, help.
  
  Easily reproducable, if you just generate a large list.
  
  Sent from sourceforge.net because you indicated interest in
  https://sourceforge.net/p/bulkvcftocsv/tickets/11/
  
  To unsubscribe from further messages, please visit
  https://sourceforge.net/auth/subscriptions/
  
  [tickets:#11]https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't handle a list of over 10k contacts
  
  Status: open
  Milestone: Ticket Submitted
  Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
  Last Updated: Sun Aug 11, 2019 11:06 AM UTC
  Owner: Greg Hadlock
  
  Merged all my backed up contacts into one VCF file, over 15k contacts, obviously mostly dups. It loads for about less than a minute and then gives an error box:
  
  Run-time error '9':
  
  Subscription out of range
  
  Option to end, debug, help.
  
  Easily reproducable, if you just generate a large list.
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/bulkvcftocsv/tickets/11/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  Related
  
  Tickets: #11
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Savas - 2019-08-24

Hi Greg

Here's the debugging you asked for.

https://i.imgur.com/qDCqXoW.png
https://i.imgur.com/FvpIncI.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Greg Hadlock - 2019-08-24
  
  Thanks Savas. That tells me that the issue is with the cell phone of that
  particular contact, but little else. When that happens, you should be able
  to click on the word ContactNum and get a number which will be the contact
  number in the file; even easier, you should be able to click on the word
  FieldValue and see the value there- that will be the phone number (or other
  data) in the cellphone field of the contact causing the problem. Armed with
  that specific information, you can open the original VCF file with an
  application like NotePad++, search for that string (phone number), find that
  contact, and then either correct the data or delete that contact and try
  running again.
  
  I'd like to know what the problem is so I can update my code to accommodate,
  but the above steps might at least get you through your conversion.
  
  From: Savas savas101@users.sourceforge.net
  Sent: Friday, August 23, 2019 10:31 PM
  To: [bulkvcftocsv:tickets] 11@tickets.bulkvcftocsv.p.re.sourceforge.net
  Subject: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k contacts
  
  Hi Greg
  
  Here's the debugging you asked for.
  
  https://i.imgur.com/qDCqXoW.png
  https://i.imgur.com/FvpIncI.png
  
  [tickets:#11] https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't
  handle a list of over 10k contacts
  
  Status: open
  Milestone: Ticket Submitted
  Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
  Last Updated: Sun Aug 11, 2019 11:06 AM UTC
  Owner: Greg Hadlock
  
  Merged all my backed up contacts into one VCF file, over 15k contacts,
  obviously mostly dups. It loads for about less than a minute and then gives
  an error box:
  
  Run-time error '9':
  
  Subscription out of range
  
  Option to end, debug, help.
  
  Easily reproducable, if you just generate a large list.
  
  Sent from sourceforge.net because you indicated interest in
  https://sourceforge.net/p/bulkvcftocsv/tickets/11/
  
  To unsubscribe from further messages, please visit
  https://sourceforge.net/auth/subscriptions/
  
  Related
  
  Tickets: #11
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Greg Hadlock - 2019-08-24
    
    Alternatively, if you do find that contact in your main VCF file, you can
    copy and paste everything from that specific contact VCF, edit the name,
    email address, phone numbers as you feel appropriate, and then send me the
    details so I can figure out what's going on.
    
    From: Greg Hadlock ghadlock@gmail.com
    Sent: Saturday, August 24, 2019 7:24 AM
    To: '[bulkvcftocsv:tickets] ' 11@tickets.bulkvcftocsv.p.re.sourceforge.net
    Subject: RE: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k
    contacts
    
    Thanks Savas. That tells me that the issue is with the cell phone of that
    particular contact, but little else. When that happens, you should be able
    to click on the word ContactNum and get a number which will be the contact
    number in the file; even easier, you should be able to click on the word
    FieldValue and see the value there- that will be the phone number (or other
    data) in the cellphone field of the contact causing the problem. Armed with
    that specific information, you can open the original VCF file with an
    application like NotePad++, search for that string (phone number), find that
    contact, and then either correct the data or delete that contact and try
    running again.
    
    I'd like to know what the problem is so I can update my code to accommodate,
    but the above steps might at least get you through your conversion.
    
    From: Savas savas101@users.sourceforge.net <mailto:savas101@users.sourceforge.net >
    Sent: Friday, August 23, 2019 10:31 PM
    To: [bulkvcftocsv:tickets] 11@tickets.bulkvcftocsv.p.re.sourceforge.net <mailto:11@tickets.bulkvcftocsv.p.re.sourceforge.net >
    Subject: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k contacts
    
    Hi Greg
    
    Here's the debugging you asked for.
    
    https://i.imgur.com/qDCqXoW.png
    https://i.imgur.com/FvpIncI.png
    
    [tickets:#11] https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't
    handle a list of over 10k contacts
    
    Status: open
    Milestone: Ticket Submitted
    Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
    Last Updated: Sun Aug 11, 2019 11:06 AM UTC
    Owner: Greg Hadlock
    
    Merged all my backed up contacts into one VCF file, over 15k contacts,
    obviously mostly dups. It loads for about less than a minute and then gives
    an error box:
    
    Run-time error '9':
    
    Subscription out of range
    
    Option to end, debug, help.
    
    Easily reproducable, if you just generate a large list.
    
    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/bulkvcftocsv/tickets/11/
    
    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/subscriptions/
    
    Related
    
    Tickets: #11
    
    alternate
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Greg Hadlock - 2019-09-11
      
      Hi Savas-
      
      Just as FYI I had another user experiencing the subscript out of range error
      that you experienced; he submitted his VCF file which was an export from
      "Apple Inc.//iPhone OS 12.4//EN", and it was writing the VCF file
      incorrectly such that instead of between VCF (contact) entries, it wrote
      "END:VCARDBEGIN:VCARD" and did not insert a Line Feed to properly delineate
      entries in the file.
      
      My program was picking up the END:VCARD statements at the beginning of the
      line but not the BEGIN:VCARD statements- it was therefore counting down
      until it got to contact number "-1" at which point the error occurred.
      
      I've updated the program to parse for this and accommodate this issue; if
      your VCF file was created on a contact I'd ask if you could please try this
      new version for me:
      
      https://www.dropbox.com/s/mnx6e6m0s7b88lh/vcf%20import%20v3.087%20devel.xlsm
      ?dl=1
      
      You can also find the updated version here:
      https://sourceforge.net/projects/bulkvcftocsv/files/ (VCF Import 3.087
      Devel), or here with the initial discussion:
      https://sourceforge.net/p/bulkvcftocsv/tickets/12/
      
      If you do have a few minutes to try it out please let me know if this
      resolves your issue.
      
      Best regards,
      
      Greg Hadlock
      
      From: Greg Hadlock ghadlock@gmail.com
      Sent: Saturday, August 24, 2019 7:38 AM
      To: '[bulkvcftocsv:tickets] ' 11@tickets.bulkvcftocsv.p.re.sourceforge.net
      Subject: RE: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k
      contacts
      
      Alternatively, if you do find that contact in your main VCF file, you can
      copy and paste everything from that specific contact VCF, edit the name,
      email address, phone numbers as you feel appropriate, and then send me the
      details so I can figure out what's going on.
      
      From: Greg Hadlock <ghadlock@gmail.com href="mailto:ghadlock@gmail.com" <a="">ghadlock@gmail.com >
      Sent: Saturday, August 24, 2019 7:24 AM
      To: '[bulkvcftocsv:tickets] ' 11@tickets.bulkvcftocsv.p.re.sourceforge.net <mailto:11@tickets.bulkvcftocsv.p.re.sourceforge.net >
      Subject: RE: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k
      contacts</ghadlock@gmail.com>
      
      Thanks Savas. That tells me that the issue is with the cell phone of that
      particular contact, but little else. When that happens, you should be able
      to click on the word ContactNum and get a number which will be the contact
      number in the file; even easier, you should be able to click on the word
      FieldValue and see the value there- that will be the phone number (or other
      data) in the cellphone field of the contact causing the problem. Armed with
      that specific information, you can open the original VCF file with an
      application like NotePad++, search for that string (phone number), find that
      contact, and then either correct the data or delete that contact and try
      running again.
      
      I'd like to know what the problem is so I can update my code to accommodate,
      but the above steps might at least get you through your conversion.
      
      From: Savas savas101@users.sourceforge.net <mailto:savas101@users.sourceforge.net >
      Sent: Friday, August 23, 2019 10:31 PM
      To: [bulkvcftocsv:tickets] 11@tickets.bulkvcftocsv.p.re.sourceforge.net <mailto:11@tickets.bulkvcftocsv.p.re.sourceforge.net >
      Subject: [bulkvcftocsv:tickets] #11 Can't handle a list of over 10k contacts
      
      Hi Greg
      
      Here's the debugging you asked for.
      
      https://i.imgur.com/qDCqXoW.png
      https://i.imgur.com/FvpIncI.png
      
      [tickets:#11] https://sourceforge.net/p/bulkvcftocsv/tickets/11/ Can't
      handle a list of over 10k contacts
      
      Status: open
      Milestone: Ticket Submitted
      Created: Sun Aug 11, 2019 09:52 AM UTC by Savas
      Last Updated: Sun Aug 11, 2019 11:06 AM UTC
      Owner: Greg Hadlock
      
      Merged all my backed up contacts into one VCF file, over 15k contacts,
      obviously mostly dups. It loads for about less than a minute and then gives
      an error box:
      
      Run-time error '9':
      
      Subscription out of range
      
      Option to end, debug, help.
      
      Easily reproducable, if you just generate a large list.
      
      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/bulkvcftocsv/tickets/11/
      
      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/
      
      Related
      
      Tickets: #11
      
      alternate
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Can't handle a list of over 10k contacts

Excel VBA Script to convert VCF file with multiple entries to CSV file

Milestone

Searches

Help

#11 Can't handle a list of over 10k contacts

Related

Discussion

Related

Related

Related

Related

Related