Directory export as vcard in new.lds.org

Discussions about the Directory Tool on lds.org. Questions about the Directory on the classic site should be posted in the LUWS forum.
AArnott
New Member
Posts: 13
Joined: Sun Feb 04, 2007 4:25 pm

Directory export as vcard in new.lds.org

Postby AArnott » Sun Dec 19, 2010 12:47 pm

The vcard export of the ward directory in classic lds.org is perfect for Gmail import. The other options result in a very poor (almost useless) import.

Can you please make sure to recreate this export capability on the new directory web site before deleting the old one?

User avatar
rbeede
Member
Posts: 201
Joined: Sat Apr 02, 2011 12:33 pm
Contact:

Postby rbeede » Sun Jun 12, 2011 12:51 pm

I just wrote a Perl script that can take the new CSV export format from the new Directory tool and converts it to vCard format.

This works much better when importing into Google Contacts for example.

You can find it at http://www.rodneybeede.com/downloads/LDS%20Directory%20CSV%20to%20vCard.7z licensed under the GNU GPL.

AArnott
New Member
Posts: 13
Joined: Sun Feb 04, 2007 4:25 pm

Postby AArnott » Mon Jun 13, 2011 6:13 am

Thanks for sharing.

ajdemille
New Member
Posts: 1
Joined: Fri Feb 11, 2011 9:45 pm

Thanks!

Postby ajdemille » Sun Jul 31, 2011 9:00 pm

It worked great with Cygwin after doing the following:

1. Installing File::Slurp using CPAN .
2. Commenting out the perl version requirement line (#require 5.012_003;)
The version provided by my Cygwin is only 5.10.1, but it worked fine.

Thanks for sharing.

mattuhrich
New Member
Posts: 1
Joined: Tue Oct 04, 2011 11:13 pm

Postby mattuhrich » Tue Oct 04, 2011 11:30 pm

After much trial and error, I finally figured out which columns must be included to import the unit directory from the new LDS website into Google contacts. This seems to work for Gmail and Google apps contacts. Just use the following column headers, instead of the default column headers you receive when using "Export Households" feature. Replace the first row of the .CSV file with the following:
--
Family Name,Name,Phone 1 - Value,E-mail 1 - Value,Address 1 - Formatted,HeadofHouseName,HeadofHousePhone,HeadofHouseEmail,SpouseName,SpousePhone,SpouseEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,Given Name,Additional Name,E-mail 1 - Type,Address 1 - Type,Phone 1 - Type
--

If in doubt, copy/paste the above list into Notepad, or other text editor, and save as CSV. Then open this new file and your ward list in Excel and copy/paste the new headers over the first row of your ward directory CSV. Save and import to Google. You may want to delete a lot of the ChildName, ChildPhone, ChildEmail columns to cut down on extra detail showing up in the contact details. Most of the other columns, however, even if blank, are required and shouldn't be deleted.

russellhltn
Community Administrator
Posts: 20779
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Postby russellhltn » Wed Oct 05, 2011 1:25 am

IIRC, the number of columns depends on the maximum number of children in a family group in your unit. (Wow, 16?)
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

volzmike
New Member
Posts: 11
Joined: Tue Jan 10, 2012 10:25 am

Re: Directory export as vcard in new.lds.org

Postby volzmike » Mon Dec 17, 2012 2:12 pm

wow, I have no idea what you all just said. I have no idea what to do with a "script" that someone in this forum supposedly made, and I have still no clue how to correctly import all of the lds.org imports into my google account. Any help please? For a layman?

User avatar
aebrown
Community Administrator
Posts: 14693
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Re: Directory export as vcard in new.lds.org

Postby aebrown » Mon Dec 17, 2012 2:53 pm

volzmike wrote:I have still no clue how to correctly import all of the lds.org imports into my google account. Any help please? For a layman?

Here are the steps:
  1. Go to http://lds.org
  2. Click on Sign In/Tools at the top of the page, near the upper right corner
  3. Click on Directory in the menu that appears
  4. Sign in using your LDS Account; you should see the Directory application
  5. Click on Export Households on the left-hand side
  6. In the popup that appears, click the Download button.
  7. The next steps vary quite a bit depending on your browser. But basically you need to find the file that was just downloaded and open it into a text editor such as Notepad. If you have trouble with this step, reply to this post and let us know just what browser you are using (including version if it is Internet Explorer), and which text editor.
  8. The first row will look something like

    Code: Select all

    "Family Name","Couple Name","Family Phone","Family Email","Family Address","Head Of House Name","Head Of House Phone","Head Of House Email","Spouse Name","Spouse Phone","Spouse Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email","Child Name","Child Phone","Child Email"
  9. Replace that first row with this:

    Code: Select all

    Family Name,Name,Phone 1 - Value,E-mail 1 - Value,Address 1 - Formatted,HeadofHouseName,HeadofHousePhone,HeadofHouseEmail,SpouseName,SpousePhone,SpouseEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail,ChildName,ChildPhone,ChildEmail
  10. Save your file (it's best to use Save As to save it to a new name just in case something goes wrong -- you'll still have the original file so you can start over)
  11. In GMail, go to your Contacts
  12. Under the More menu item, choose Import
  13. Click the Browse button and find the file you saved above
  14. Click the Import button
  15. The imported contacts will all be in a group called "Imported 12-17-2012" (if you do the import today)

volzmike
New Member
Posts: 11
Joined: Tue Jan 10, 2012 10:25 am

Re: Directory export as vcard in new.lds.org

Postby volzmike » Mon Dec 17, 2012 5:31 pm

I did what you said exactly, and all the names and emails look good, but none of the phone numbers got transferred over to google. Any idea why? Thanks very much for your help.

volzmike
New Member
Posts: 11
Joined: Tue Jan 10, 2012 10:25 am

Re: Directory export as vcard in new.lds.org

Postby volzmike » Mon Dec 17, 2012 5:33 pm

so i opened one of the contacts and it turns out that the emails were the only thing that transferred successfully, and everything else was in the notes section of the contact, with all the text editing jargon as well. Any thoughts?


Return to “Directory”

Who is online

Users browsing this forum: No registered users and 1 guest