Arabic text in VCF not shown correctly
Found the solution to that one after some digging in the code. It's probably too late for you, but I thought I'll post it for anyone needing it. Find this code: Case "TEL;" 'Telephone number followed by type …. 'If FieldType2 = "pref:" Then PrefPhone(ContactNum) = FieldValue 'Add to preferred phone number '****************NEW CODE ADDED V3.093 FOR HANDLING GOOGLE ITEM LABELS Select Case LCase(FieldType2) And change the last line to: Select Case LCase(FieldType) And then it works.
Found the solution to that one after some digging in the code. It's probably too late for you, but I hought I'll post it for anyone needing it. Find this code: Case "TEL;" 'Telephone number followed by type …. 'If FieldType2 = "pref:" Then PrefPhone(ContactNum) = FieldValue 'Add to preferred phone number '****************NEW CODE ADDED V3.093 FOR HANDLING GOOGLE ITEM LABELS Select Case LCase(FieldType2) And change the last line to: Select Case LCase(FieldType) And then it works.
Found the solution to that one after some digging in the code. Find this code: Case "TEL;" 'Telephone number followed by type …. 'If FieldType2 = "pref:" Then PrefPhone(ContactNum) = FieldValue 'Add to preferred phone number '****************NEW CODE ADDED V3.093 FOR HANDLING GOOGLE ITEM LABELS Select Case LCase(FieldType2) And change the last line to: Select Case LCase(FieldType) And then it works.
Currently this is only working on Windows machines, what operating system are you using? On Wed, May 5, 2021, 9:45 PM CarmenBolin carmenb@users.sourceforge.net wrote: I downloaded the converter. Selected my vcf file from the VCF Import v4.002 file. A macros window opened up. Nothing else happened. Where is my csv file supposed to be? Instructions page says, "- Once the macro completes, the converted data will be stored in an Excel XLS file, a regular ANSI text .CSV file, and a Unicode UTF-8 .CSV...
I downloaded the converter. Selected my vcf file from the VCF Import v4.002 file. A macros window opened up. Nothing else happened. Where is my csv file supposed to be? Instructions page says, "- Once the macro completes, the converted data will be stored in an Excel XLS file, a regular ANSI text .CSV file, and a Unicode UTF-8 .CSV file in the same directory as the VCF input file". No additional files are in that location. Help? I have attached a screenshot of what opened up.
I downloaded the converter. Selected my vcf file from the VCF Import v4.002 file. A macros window opened up. Nothing else happened. Where is my csv file supposed to be? Instructions page says, "- Once the macro completes, the converted data will be stored in an Excel XLS file, a regular ANSI text .CSV file, and a Unicode UTF-8 .CSV file in the same directory as the VCF input file". No additional files are in that location. Help?
Thanks a bunch for the feedback, JM. Also, after our exchange it occurred to me...why DOESN'T the debug file contain crash related data- it certainly should! That said, I've modified the code since the version I gave you so that when an error occurs that previously caused a crash, the program will now write the values of celltext and other pertinent variables to the debug file, then gracefully exit with a message box informing the user rather than dumping them into the VBA debug window. With a few...
Greg, New version, VCF Import v3.095 - Devel.xlsm, ran successfully and created files three files. Excellent! This utility program helps me with conversion to ProtonMail. Thank you so much! JM Reid ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Sunday, March 7th, 2021 at 8:08 AM, Greg Hadlock ghadlock@users.sourceforge.net wrote: Thank you John, that gave me the info that I needed! Please try out the latest version here: https://drive.google.com/file/d/1XXAg2rfTieea0pJJU6rr_gx05iIHYWcY/view?usp=sharing or here:...
Thank you John, that gave me the info that I needed! Please try out the latest version here: https://drive.google.com/file/d/1XXAg2rfTieea0pJJU6rr_gx05iIHYWcY/view?usp=sharing or here: https://www.dropbox.com/s/wkagio37m0rpcsa/VCF%20Import%20v3.095%20-%20Devel.xlsm?dl=0 Please let me know if this works for you...if so I'll get it posted to SourceForge as it solves some other new issues coming from Android devices. Greg Hadlock
Greg Hadlock ghadlock@gmail.com 7:53 AM (13 minutes ago) to jmreidmj Thank you John, that gave me the info that I needed! Please try out the latest version here: https://drive.google.com/file/d/1XXAg2rfTieea0pJJU6rr_gx05iIHYWcY/view?usp=sharing or here: https://www.dropbox.com/s/wkagio37m0rpcsa/VCF%20Import%20v3.095%20-%20Devel.xlsm?dl=0 Please let me know if this works for you...if so I'll get it posted to SourceForge as it solves some other new issues coming from Android devices. Greg Hadlock On...
Greg, The value in celltext is ... "X-ANDROID-CUSTOM:vnd.android.cursor.item/contact_event\;2019-07-24\;0\;Dakota James B-Day\;\;\;\;\;\;\;\;\;\;\;\;" ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Saturday, March 6th, 2021 at 5:38 PM, Greg Hadlock ghadlock@users.sourceforge.net wrote: Next steps are either to 1) send me the vcf file (fast and easy) or 2) have me troubleshoot on your computer via TeamViewer while you observe or 3) have me give you some instructions on specific variables for which I need the...
Next steps are either to 1) send me the vcf file (fast and easy) or 2) have me troubleshoot on your computer via TeamViewer while you observe or 3) have me give you some instructions on specific variables for which I need the values either by email or phone. For starters if you can find the value of the variable called celltext at the time of crash then I can likely determine the issue. On Sat, Mar 6, 2021, 5:04 PM John M Reid jmreidmj@users.sourceforge.net wrote: Hi Greg, thanks for super fast response...
Hi Greg, thanks for super fast response on my post! I tried with v3.095 and got same results. The DEBUG files are identical. Next steps?
Hi John- Thank you so much for reaching out to me; I appreciate you taking the time to do so. I've looked at the debug file (a new feature) and it does contain some unrecognized content that I'll appropriately parse in the next version, but it doesn't give me any insight into what caused the "hard" crash. That said, I may need more information, the easiest of which is sending me the VCF file via email, or secondarily, me asking for you to give me some variable values from the debug window when the...
I am trying to convert .vcf with 189 entries to .csv The input .vcf file is an export from Nextcloud Contacts. VCF Import v3.094 produced a DEBUG.txt file which I have attached. Thanks.
Issue handling contact file exported from Google Contacts v3.36.3.346104542 (Google Support Services Version 3.9.2) on a Google Pixel running Android 10: VCF Import v3.091.xlsm apparently doesn’t handle the X-ANDROID-CUSTOM feature: X-ANDROID-CUSTOM:vnd.android.cursor.item/relation;Willa;3;;;;;;;;;;;;;
Issue handling contact file exported from Google Contacts v3.36.3.346104542 (Google Support Services Version 3.9.2) on a Google Pixel running Android 10: In sections of ASCII encoded text, VCF Import v3.091.xlsm choked on line-feed, ‘0A.’ Example of a line that caused a problem: ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;=4D=74=2E=20=41=75=62=75=72=6E=0A=48=6F=73=70=69=74=61=6C=2C=20=53=74=
VCF Importo non funziona in Libreoffice 6.2.8.2. Eseguendo la macro risponde così : "Errore dello schema di scripting durante l'esecuzione dello script Basic VBAProject.VCFImport.DecodeVCFField. Messaggio: wrong number of parameters!" Why ?
Hi again! I just received the attached VCF file sample asking for help with the Hungarian characters and after finding this email I was able to test out against your final version of code and there are still issues with the character set. If you have time, can you test this VCF file with your version and let me know if you have any ideas? On Fri, Oct 19, 2018 at 3:12 PM gvp gvp gvp9000@users.sourceforge.net wrote: new link https://www.dropbox.com/s/tqa7ftq5y05yb91/VCF%20Import%20v13.xlsm?dl=0 Final...
Hi Mark- Thank you for reaching out to me! I'm not familiar with the AOL CSV Import process, but can tell you that with Google or Outlook import, the trick is to find out the field names (i.e. column headers) that Google or Outlook is looking for and then rename the columns to match that. Two things to get us started here: 1) Can you EXPORT a contact or two from AOL as CSV to see what columns are exported and what the headers are? If we match that, the import will likely work. 2) If #1 above doesn't...
Hey Greg, Thank you for creating the Free VCF file to CSV or Excel converter. It appears to be an excellent tool for converting vcf to csv files. Unfortunately, AOL mail did not import all the fields from the converted CSV file that your converter created. Only the names and email addresses. I exported the vcf file from my Roundcube webmail account. I assume that I need to map all the fields from the newly created csv so that AOL mail can import all the fields. If you post instructions on how to...
Will email you the .vcf file to review. Below are my comments on instructions: 1) Save the file to your computer in a location where you can find it Downloaded and saved as "VCF Import v3.085.xlsm" witout any manipulation from me. 2) Start Excel and open a new workbook Complete 3) Enable the Developer Tab on the Ribbon if not already enabled. Complete 4) Start Visual Basic by clicking on the Developer Tab and then the Visual Basic button Complete 5) Once in Visual Basic, import the file by clicking...
Oh it is on a Mac... are there any other options? I don’t have a Windows machine to use. Thanks, Kate On Apr 17, 2020, at 2:36 PM, Greg Hadlock ghadlock@users.sourceforge.net wrote: Are you on a Mac or a Windows machine? Mac is currently not working but if you are using Microsoft Office on a Microsoft Windows machine it should work just fine. On Fri, Apr 17, 2020, 3:08 PM Kate Felinski kfelinski1212@users.sourceforge.net wrote: hello-- this didnt work correctly, not sure why. I thought i saw an...
Are you on a Mac or a Windows machine? Mac is currently not working but if you are using Microsoft Office on a Microsoft Windows machine it should work just fine. On Fri, Apr 17, 2020, 3:08 PM Kate Felinski kfelinski1212@users.sourceforge.net wrote: hello-- this didnt work correctly, not sure why. I thought i saw an option to email? Not working https://sourceforge.net/p/bulkvcftocsv/discussion/troubleshooting/thread/080fec8339/?limit=25#049f Sent from sourceforge.net because ghadlock@gmail.com is...
hello-- this didnt work correctly, not sure why. I thought i saw an option to email?
hello-- this didnt work correctly, not sure why. I thought i saw an option to email?
Am using macOS 10.14.6 with Excel 16.35. When I ran the macro, got a messagebox "Unknown Operating System". I deleted the OS check code and put IsMac=True. Worked beatifully after that.
Thanks for the quick response, Greg. That would be great if you were able to debug the macro for Mac. Absolutely, please reach out if you need more info ... I'll most likely need to find an alternative before than, since I'd prefer to not wait until the weekend to make this process happen, but please do reach out and I'll help if I can. Best - Corey
Hi Corey- Unfortunately, the macro does not recognize that you are running an Apple operating system and instead is trying to send commands specific to a Windows operating system. This is a function on changes being made in office for Apple and the Apple OS, which I've not been able to keep up with as I don't have an Apple machine for development and testing. At this point, I'm unable to support Apple though I have a friend from whom I might borrow a machine to troubleshoot this specific issue this...
Mac Mohave 10.14.6 VCF Import v3.085.xlsm MS Exel for Mac 16.35 (20030802) Having a similar problem as JW above (and as other people posting on other trouble shooting threads), although I'm getting "Runtime Error 91". Is the error possibly a result of the macros not being enabled? I've selected "enable macros" when promted. Thanks in advance! Here's a screenshot once I click "Debug" ...
Application Operating System is Macintosh (Intel) Version 10.13.6 (Build 17G65) Application Version is 15.27 It looks like these versions of Excel and MacOS are in the range of those supposed to be supported? Loading the Maco stumbles with Runtime error 438, which appears to be right at the point where it would ask to open a file. Never gets there. Disappointing. I don't know how to get past this.
Hi, I have performed the conversion but many of my contacts are in Greek. So, they appear as gibberish in the resulting CSV file. If I open it with Notepad and use "SAVE AS" with same Fname/Ftype but UTF-8 encoding then everything appears correctly (only when opened with Notepad!). When opened with Excel (as CSV) the problem persists. Then, in Outlook (2007) when I import it (comma separated-Windows), it of course appears (Outlook contacts) with the same problem. Any ideas pls? Thank you!
Not picking up different TEL TYPEs
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-...
Runtime Error '9' Subscript Out of Range
How about some wine? support@vom.com 707.935.6316 From: Greg Hadlock ghadlock@users.sourceforge.net To: [bulkvcftocsv:tickets] 12@tickets.bulkvcftocsv.p.re.sourceforge.net Sent: 9/10/2019 4:13 PM Subject: [bulkvcftocsv:tickets] Re: #12 Runtime Error '9' Subscript Out of Range Nothing at all sir, glad that I was able to help out! From: Robert Thomas vomsupport@users.sourceforge.net Sent: Tuesday, September 10, 2019 7:00 PM To: [bulkvcftocsv:tickets] 12@tickets.bulkvcftocsv.p.re.sourceforge.net Subject:...
Nothing at all sir, glad that I was able to help out! From: Robert Thomas vomsupport@users.sourceforge.net Sent: Tuesday, September 10, 2019 7:00 PM To: [bulkvcftocsv:tickets] 12@tickets.bulkvcftocsv.p.re.sourceforge.net Subject: [bulkvcftocsv:tickets] Re: #12 Runtime Error '9' Subscript Out of Range Works great.. What do we owe you? support@vom.com support@vom.com 707.935.6316 From: Greg Hadlock ghadlock@users.sourceforge.net ghadlock@users.sourceforge.net To: [bulkvcftocsv:tickets] 12@tickets.bulkvcftocsv.p.re.sourceforge.net...
Works great.. What do we owe you? support@vom.com 707.935.6316 From: Greg Hadlock ghadlock@users.sourceforge.net To: [bulkvcftocsv:tickets] 12@tickets.bulkvcftocsv.p.re.sourceforge.net Sent: 9/10/2019 3:36 PM Subject: [bulkvcftocsv:tickets] #12 Runtime Error '9' Subscript Out of Range OK, I have a new version for you to try that should solve the issue for you and for others with iPhone OS 12.4. I've attached the file to this posting, and you may also download it from Dropbox using the link below....
OK, I have a new version for you to try that should solve the issue for you and for others with iPhone OS 12.4. I've attached the file to this posting, and you may also download it from Dropbox using the link below. If this works as expected then I'll update the project with this version. https://www.dropbox.com/s/mnx6e6m0s7b88lh/vcf%20import%20v3.087%20devel.xlsm?dl=0 Thank you for submitting this issue and providing the data so quickly- it makes it so much easier to troubleshoot the issue (which...
Oh I grabbed the VCF attachment, found the data I neded, and then deleted the original attachment so it wasn't accessible going forward. Sourceforge automatically sent out a notice...
I see in the .VCF file that the VCF files do not have discrete BEGIN and END statements, instead they are combined on a single line (the end of one VCF file and the beginning of another), so the file contains: END:VCARDBEGIN:VCARD between each two contact cards instead of END:VCARD BEGIN:VCARD so the program is unable to determine where one vcard ends and the next begins. I'll work on some code to parse this out so the program can accomodate. If you need this right now, you can use a program like...
Sorry do not understand..
Runtime Error '9' Subscript Out of Range
VCF to CSV converter is very useful tool which supports all size file conversion . It supports in window OS including XP , Vista , 8 and 10 also , you can save your file in local drive , It gives Error free conversion from VCF to CSV format , You can try this tool.
VCF to CSV Converter is recommendation by my brother, This is a software which is very fast and safe conversion tool , There is also no any size limitation . It supports in window OS including XP , Vista , 8 and 10 also , you can save your file in local drive , It gives Error free conversion from VCF to CSV format , You can try this tool.
Thank you for your recommendation, Wadejoy. Other users find this program to be useful also.
VCF to CSV Converter is recommendation by my brother, This is a software which is very fast and safe conversion tool , There is also no any size limitation . It supports in window OS including XP , Vista , 8 and 10 also , you can save your file in local drive , It gives Error free conversion from VCF to CSV format , You can try this tool. More info visit here:- https://www.softakensoftware.com/vcard-to-csv-converter.html
VCF to CSV converter is very useful tool which supports all size file conversion . It supports in window OS including XP , Vista , 8 and 10 also , you can save your file in local drive , It gives Error free conversion from VCF to CSV format , You can try this tool. More info visit here:- https://www.softakensoftware.com/vcard-to-csv-converter.html
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...
Hi Greg Here's the debugging you asked for. https://i.imgur.com/qDCqXoW.png https://i.imgur.com/FvpIncI.png
I use MS Office 365 on a Mac so I imagine my version of Excel should work here. I downloaded the VCF import file and opened it with Macros. It says Run Time error '91, Object variable or With block variable not set. End or Debug? I click Debug and get a yellow highlighted note and arrow pointing to: .AllowMultiSelect = False I can't click on anything else. What's next? I can close the box. Then what? I'm a novice but I imagine this should be easy. I have NO idea how to convert my VCF files to .CSV...
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...
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...
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...
Can't handle a list of over 10k contacts
LastName, FirstName etc. not filled in some cases
Slight error i Home address management
Slight issue with CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE
Hola, he descargado el archivo de excel para convertir .VCF a Excel en un ordenador MacBookAir, y al activar las macros, da un error que pide depurar, ni que decir que no funciona el archivo en cuestion, me podría ayudar con este error. muchas gracias. adjunto imagen del error.
Hi, I'm Ilva. I liked your project and I would like to contribute by writing the requirement document if it does not exist. I would like you to send me a detailed description of the operation, technical features and anything you would like to add to the document. My email is ilvazyl@gmail.com. I'll be happy to help you.
No, this is macro i use to convert my contact card. But seems it doesnt convert properly if more than 11 digits. i atttached 1 vcard file. You try open the macro then select the vcard. After it convert you see the result.
Error message
Hi Bruce- Were you able to try out the versions I placed in Dropbox for you? Those have been modified by other users to work on Mac, and should work without coding. Both files can be found here: https://www.dropbox.com/sh/amkfav82915sqrr/AAA8A-3Igf1-A1s-pqcQaFwra?dl=0 Alternatively, if anyone in your office has a Windows machine with Excel the tool will work without issue there. A final alternative is that I could convert the VCF file to CSV for you if desired. I apologize that you are having difficulties...
Dear Greg, Thanks for your reply. I am not familiar enough with coding to make the import tool work. Sincerely, Bruce Bruce D. Katz, Esq. Bruce D. Katz & Associates The Transportation Building 225 Broadway, 37th Floor New York, New York 10007 Office (212) 233-3434 Fax (212) 233-0506 * E-mail Confidentiality Notice* The information contained in this electronic message may contain attorney-client privileged and confidential information intended only for the use of the owner of the email address listed...
new link https://www.dropbox.com/s/tqa7ftq5y05yb91/VCF%20Import%20v13.xlsm?dl=0
Hi Bruce- I've unfortunately had to discontinue Mac support as the user who was helping me troubleshoot on the Mac has lost interest. That said, I have had other users send me their own versions of the tool, modified to work on a Mac that you may try if you wish. In this Dropbox folder, https://www.dropbox.com/sh/amkfav82915sqrr/AAA8A-3Igf1-A1s-pqcQaFwra?dl=0, there are two versions of the tool that were sent to me: VCF Import v3.085-mac.xlsm- This version was sent to me by a user that knows coding...
Using Mac 10.13.6 with Excel
Error message recieved
This is an Excel Macro, so before it will work and pop up requesting your file, you'll need to enable macos, depending on your version of MS Office it would be somethimg like this trail of commands: Office Button>Excel Options>Trust Center>Trust Center Settings>Macro Settings>disable/enable. or
This is an Exce Macro, so before it will work and pop up requesting your file you'll need to enable macos, depending on your version of MS Office it would be somethimg like this trail of commands: Office Button>Excel Options>Trust Center>Trust Center Settings>Macro Settings>disable/enable. or
As a quick update, I just noticed that any phone field that has a Custom name is ignored on the import. Instead of creating new fields, I though to try appending the custom name AFTER the phone number (like an alpha extension). I manually tried this in the VCF file and it imports and parses fine. We (read "you" ha ha) need to figure out how to parse the custom name and append it to the end of the phone number. For example: BEGIN:VCARD VERSION:2.1 N:Bob;Brown;-;; FN:Bob Brown TEL;X-Old_Nextel:090-877-44534...
As a quick update, I just noticed that any phone field that has a Custom name is ignored on the import. Instead of creating new fields, I though to try appending the custom name AFTER the phone number (like an alpha extension). I manually tried this in the VCF file and it imports and parses fine. We (read "you" ha ha) need to figure out how to parse the custom name and append it to the end of the phone number. I'd love to offer a hand, but VBA is WAY out of my ballpark. Cheers, MadDogDean
As a quick update, I just noticed that any phone field that has a Custom name is ignored on the import. Perhaps a method to group all other "Custom" phone entries into a "Misc" or something similar? Cheers, MadDogDean
Hi I am running LineageOS ver 14.1, Android version 7.1.2. First off, thanks for the dev - it helped me to easily pull over 1,000 contacts out of my phone :) However, I noticed that some of the phone fields didn't parse correct, even though they are in the VCF. The following will parse the data, but not add a phone record. On my phone it comes up as the "Main" field. BEGIN:VCARD VERSION:2.1 N:Sipalay;Police;-;; FN:Police - Sipalay TEL;PREF:090-877-44534 TEL;PREF:090-566-28411 END:VCARD If I change...