Currently Being ModeratedFeb 10, 2013 9:31 AM (in response to Lengerke)
Currently Being ModeratedFeb 12, 2013 12:39 AM (in response to Barney-15E)
Thank you all for your reactions. After 30 years of cpm > Msdos > Windows I turned 2 months ago to the Mac, so Automator is for now a step to far for me.
I found an app Adress Book Extractor, it can convert to CSV. I think I will try that.
Currently Being ModeratedJan 29, 2014 7:22 PM (in response to Barney-15E)
I know it's a bit late but can I drag and drop my VCF cards into automator and then export those cards to a CSV file? If so what would be the steps to accomplish this? Truly appreciate your help in any way.
Currently Being ModeratedFeb 7, 2014 10:42 AM (in response to Barney-15E)
Thank you for providing what seems to be a very useful answer.
However I am not too familiar with Automator. I opened it up and got to the same screen you showed above but after that, I am stuck. Where do I input my vCard file? (At least I assume I have to export a vCard file out of Contacts first, right?). I kind of did that somehow (not too sure how...) where I end up with a window that says "Get specified Finder items".
Then I double clicked on "Get contact Information" which got me to the window shown above where I selected just Name and Home Email.
Then I clicked Run. But nothing much happened except for a message in the log saying "Workflow Completed". But where is the new tab-deliniated file that (I assume) just got written?
Maybe I need a bit of a step by step... Sorry if this seems a bit dense. But it doesn't seem completely obvious to someone not familiar with Automator.
Thank you for any help.
Currently Being ModeratedFeb 8, 2014 8:34 AM (in response to Bmachine)
It's not immediately obvious here, to be sure.
You have to have Address Book OPEN and have selected the contacts or groups you want to export.
So, I have Address Book open, and I've selected the "Holiday" group, and then in the Contacts pane, Select All
(Apparently just selecting the Group does not work, although one would think it should, if you were to change the option in the "Get Selected" tool)
Once all your contacts are selected, you can run the workflow, as shown and get a text doc with all the data as a tab-separated (spreadsheet) or text formatted (data per line) file.
So, it does not convert vcf FILES but converts the DATA for you.
In other words, don't bother exporting the vcf files from Address Book!
Hope this helps!
& Thanks to Barney for the tip!
Currently Being ModeratedFeb 8, 2014 10:20 AM (in response to Bmachine)
I think pfraterdeus has mostly covered this, but
First, you don't use a vcf file, but you get the information directly from Contacts.
In the workflow I displayed, you need to Add the contacts you want to use. You could use a Get Selected Contacts Items action instead. In that case, select the Contacts you want to export and then run the workflow.
Now, to get a file, drag in New TextEdit Document to the bottom of the workflow. The output will then go to a new document that opens and is ready for you to save.
Currently Being ModeratedFeb 8, 2014 11:52 AM (in response to Barney-15E)
Thank you pfraterdeus and Barney.
I am slowly getting the hang of this. So a step by step would be:
- Open Contacts.app and select the name you want to work on
- Open Automater, and select "Workflow"
- Click on the Contacts app on the left and double clikc on Get Selected COntact Items.
- This should open a first action on the right
- Double click on Get contact information. This should open a second action on the right.
- Check the boxes that you want to export. Check Labels if desired as well as Export format.
- Click on the Text app on the far left and double click on New Text FIle. Enter name for file.
- Click on the RUN icon at top right to execute all three actions.
- Open the txt file to verify.
Currently Being ModeratedFeb 8, 2014 11:56 AM (in response to Bmachine)
Now I want to export a file with just First Name, Last name, and Email address.
Everyting works but one thing I noticed is that some emails are under Home email, some are under Work email and some are under "Other". Not sure how that happened. Probably when adding email to Contacts from within Mail.app or something.
how can I make one "catch all" paramter that includes all three of these possible email fileds in the Get Contact Information action? I can select Home email and Work email but not "Other".
Thank you very much.
Currently Being ModeratedFeb 8, 2014 4:40 PM (in response to Bmachine)
I don't think you can. It is somewhat limited in what it can do. I believe there are some third-party apps that will export from Contacts, but I've never used any. Just remember that people have suggested such a thing.