Re: Exporting/importing address books

[Jack S. LaRosa]

Hello MFPA,

On Friday, February 16, 2018 you wrote:

M> Hi

M> On Friday 16 February 2018 at 1:34:58 AM, in
M> , Jack S. LaRosa wrote:-

>> Over the years I have somehow managed to create three
>> address books. I wanted to
>> export them to a file I could edit and so chose to
>> export all three to comma
>> separated (.csv) files. 

M> Why not copy all entries from each address book directly to a new one 
M> within TB! and delete the duplicates there?

Well, mainly because I didn't know you could do that. When I looked at the
export options I saw that I could export as .csv files, and I knew I could
import those files into Excel and edit them from within Excel. That seemed to be
the way to go.

I tried what you suggested and of course it worked perfectly. Even where an
entry was duplicated in all three books, it only pasted the ones with distinct
email addresses. So it did the work for me.

My apologies for being so tardy in replying but this operation had several
"gotchas", mainly because I wasn't paying attention. It turned out to be an
invaluable lesson in how address books are managed in TB!.

M> Is there any possibility that you didn't delete the whole line when 
M> deleting the duplicate entries? A long shot, but all I could think of.
M>

Although it's moot now, the answer to your question is no. When you select an
entire line in Excel, every cell on that line is selected all the way out to the
absolute last column in the spreadsheet, whether those cells contain data or
not. So by deleting that line, you delete everything that line may have
contained.

Once again, my sincere appreciation for your help.

-- 
Regards,
Jack LaRosa
Central Alabama USA

Using TB! 6.0.12
OS: Win 10 v6 Build: 9200


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



Current version is 8.0.18 | 'Using TBUDL' information:
http://www.silverstones.com/thebat/TBUDLInfo.html

Re: Exporting/importing address books

[MFPA]

Hi


On Friday 16 February 2018 at 1:34:58 AM, in
, Jack S. LaRosa wrote:-


> Over the years I have somehow managed to create three
> address books. I wanted to
> export them to a file I could edit and so chose to
> export all three to comma
> separated (.csv) files. 

Why not copy all entries from each address book directly to a new one 
within TB! and delete the duplicates there? (If you use address book 
groups that have "hide items if not specifically selected" checked in 
their options, you would need to either copy members of these groups 
separately or remove this checkmark before selecting all entries in 
the address book to copy.)



> What am I missing?  

Is there any possibility that you didn't delete the whole line when 
deleting the duplicate entries? A long shot, but all I could think of. 

-- 
Best regards

MFPA  

A picture is a poem without words

Using The Bat! v7.4.16.14 (BETA) on Windows 10.0 Build 16299  



Current version is 8.0.18 | 'Using TBUDL' information:
http://www.silverstones.com/thebat/TBUDLInfo.html

Exporting/importing address books

[Jack S. LaRosa]

Hello TBUDL'ers,

Over the years I have somehow managed to create three address books. I wanted to
export them to a file I could edit and so chose to export all three to comma
separated (.csv) files. I then used the DOS COPY command to combine all three
into one .csv file. I could then double-click on the combined file and Excel
would launch and load the combined file. So far so good. I then edited (deleted
duplicate addresses) and saved the file.

When I imported the combined file back into a newly created (empty) address
book, I found that many entries at the top of the book were completely empty. As
I scrolled down, text began to appear in the NAME column but it was punctuation
marks followed further down by street addresses then ultimately by what appeared
to be legitimate entries. However, upon checking these entries I found that
information that should have been in an entry was in fact some of the
aforementioned punctuation and street addresses at the top of the book.

I tried saving the Excel file several different ways all to no avail.

What am I missing?

-- 
TIA,
Jack LaRosa

Using TB! 6.0.12
OS: Win 10 v6 Build: 9200


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



Current version is 8.0.18 | 'Using TBUDL' information:
http://www.silverstones.com/thebat/TBUDLInfo.html