locked Download member list question with Windows
Hi All, Someone is having an issue with the downloaded member list. They're running Windows, and I'm on Mac, so unfortunately I can't help. They would like to bring the member list into Notepad or Wordpad to edit (they just want the email addresses out of the file), but they're having problems because Windows doesn't think the .csv file is plain text. Does anyone have any experience with this and could offer some suggestions? Thanks, Mark
|
|
Judy F.
I open CSV files in Excel. Once they edit it they can save it again to CSV.
Judy F. SW Florida - USA
From: Mark Fletcher [mailto:markf@corp.groups.io]
Hi All,
Someone is having an issue with the downloaded member list. They're running Windows, and I'm on Mac, so unfortunately I can't help. They would like to bring the member list into Notepad or Wordpad to edit (they just want the email addresses out of the file), but they're having problems because Windows doesn't think the .csv file is plain text.
Does anyone have any experience with this and could offer some suggestions?
Thanks, Mark
|
|
rajmund <brajmund2000@...>
Hi Mark,
toggle quoted messageShow quoted text
Generally, based on file types, I would rename the CSV to txt, and open it in notepad. Sent from a BrailleNote
----- Original Message -----
From: "Mark Fletcher" <markf@corp.groups.io To: beta@groups.io Date sent: Tue, 8 Sep 2015 21:58:41 -0700 Subject: [beta] Download member list question with Windows Hi All, Someone is having an issue with the downloaded member list. They're running Windows, and I'm on Mac, so unfortunately I can't help. They would like to bring the member list into Notepad or Wordpad to edit (they just want the email addresses out of the file), but they're having problems because Windows doesn't think the .csv file is plain text. Does anyone have any experience with this and could offer some suggestions? Thanks, Mark
|
|
Linda
Hi Rajmund,
Will you please try that and advise. I’m looking for a
list of my members’ email addresses – only.
If anyone is familiar with the way Yahoogroups members
Download used to be, that’s what I want. (Things have changed since
Neo.)
I do not have Windows Office but even if I did, the result
would be unsatisfactory for my purposes. There is way too much
information. (In Yahoogroups what we have used to be called members
Export.)
Thanks,
Linda
From: rajmund
Sent: Wednesday, September 9, 2015 4:34 AM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Hi
Mark, Generally, based on file types, I would rename the CSV to txt, and open it in notepad.
|
|
rajmund <brajmund2000@...>
Hi Linda,
toggle quoted messageShow quoted text
You shouldn't need office to open a CSV file. I would try my advice, but I don't own a list. Although, I have worked and with, and have opened CSV files, I can manage with them.. If you would like, I could help with CSV generally off list. Sent from a BrailleNote
----- Original Message -----
From: "Linda" <lindon@... To: beta@groups.io Date sent: Wed, 9 Sep 2015 08:10:09 -0400 Subject: Re: [beta] Download member list question with Windows Hi Rajmund, Will you please try that and advise. I�셫 looking for a list of my members�� email addresses �� only. If anyone is familiar with the way Yahoogroups members Download used to be, that�셲 what I want. (Things have changed since Neo.) I do not have Windows Office but even if I did, the result would be unsatisfactory for my purposes. There is way too much information. (In Yahoogroups what we have used to be called members Export.) Thanks, Linda From: rajmund Sent: Wednesday, September 9, 2015 4:34 AM To: beta@groups.io Subject: Re: [beta] Download member list question with Windows Hi Mark, Generally, based on file types, I would rename the CSV to txt, and open it in notepad.
|
|
Linda
Sorry Rajmund, I wanted YOU to see the result. I had
already done what you suggested. Too much information for my
purposes.
Thanks,
Linda
From: rajmund
Sent: Wednesday, September 9, 2015 8:12 AM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Hi
Linda, You shouldn't need office to open a CSV file. I would try my advice, but I don't own a list. Although, I have worked and with, and have opened CSV files, I can manage with them.. If you would like, I could help with CSV generally off list.
|
|
There are several options that I've tried. Changing the extension to .txt allows me to open it in Notepad, but removing all the extraneous information is a pain.
Opening the file in Excel or Open Office Spreadsheet lets me delete the other columns easily. Then I can save it as a text file with just the first column. The procedure is a bit different for each program, but not too difficult to figure out. I can also do any other manipulation I might want, say email and user name only or sorting on a column. I remember Yahoo having the option available to download only email addresses and could never figure out why it might be needed. I've always wanted at least the username along with it. Duane
|
|
rajmund <brajmund2000@...>
Hi Linda,
toggle quoted messageShow quoted text
Ah, OK, that's why. I use speech, so by moving word by word, I can get the email addresses, or whatever I want to at the time, out of it. Or, better yet, import it to my address book, and go from there. Sorry that it didn't work for you. Sent from a BrailleNote
----- Original Message -----
From: "Linda" <lindon@... To: beta@groups.io Date sent: Wed, 9 Sep 2015 08:27:28 -0400 Subject: Re: [beta] Download member list question with Windows Sorry Rajmund, I wanted YOU to see the result. I had already done what you suggested. Too much information for my purposes. Thanks, Linda From: rajmund Sent: Wednesday, September 9, 2015 8:12 AM To: beta@groups.io Subject: Re: [beta] Download member list question with Windows Hi Linda, You shouldn't need office to open a CSV file. I would try my advice, but I don't own a list. Although, I have worked and with, and have opened CSV files, I can manage with them.. If you would like, I could help with CSV generally off list.
|
|
Steph <hsrsp@...>
I have not tried downloading any lists of my
group members but last time I tried that on a groups server I had to remove
extra greater thans, quotation marks, and put them all on their own line.
And I would have to manually fix the file where it would just say the
following.
Their Name as it appears in the members
section,
Email Address,
& Message Delivery Status.
Steph
From: Linda
Sent: Wednesday, September 09, 2015 7:10 AM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Hi Rajmund,
Will you please try that and advise. I’m looking for a
list of my members’ email addresses – only.
If anyone is familiar with the way Yahoogroups members
Download used to be, that’s what I want. (Things have changed since
Neo.)
I do not have Windows Office but even if I did, the result
would be unsatisfactory for my purposes. There is way too much
information. (In Yahoogroups what we have used to be called members
Export.)
Thanks,
Linda
From: rajmund
Sent: Wednesday, September 9, 2015 4:34 AM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Hi
Mark, Generally, based on file types, I would rename the CSV to txt, and open it in notepad.
|
|
Probably late on this - but the easiest thing I can think
of is to open Notepad or Wordpad, then use File->Open and find the *.csv file. Works for me (Win 7). Other is to open it in Excel, then use Save As - or if you are on Office 365, it has an Export -> change file type -> choose whatever is needed to upload wherever it needs to go. dg
|
|
Jim Ruby <jim@...>
One other thing if it was not already mentioned is to right click on the file and choose open with and choose notepad. Note be sure that always use this program is unchecked with in this dialog box if you don't want to always open these files with the program you are choosing.
toggle quoted messageShow quoted text
-----Original Message-----
From: Diana Gregory [mailto:diana@...] Sent: Wednesday, September 09, 2015 10:45 AM To: beta@groups.io Subject: Re: [beta] Download member list question with Windows Probably late on this - but the easiest thing I can think of is to open Notepad or Wordpad, then use File->Open and find the *.csv file. Works for me (Win 7). Other is to open it in Excel, then use Save As - or if you are on Office 365, it has an Export -> change file type -> choose whatever is needed to upload wherever it needs to go. dg
|
|
On 8 Sep 2015 at 21:58, Mark Fletcher wrote:
Someone is having an issue with the downloaded member list. They'reSomething else is going on. Windows handles the csv from groups.io just fine. Notepad will open the csv, or you could rename to txt. It shouldn't be the encoding. I think the file is UTF-8, but that shouldn't cause a problem. My guess is that when opening a file within Notepad, it filters all the files to show only txt "Text Documents (*.txt)". A csv will not show up. There's a pulldown to select "All Files (*.*)" Wordpad's similar in that the Open File dialog filters for "All Wordpad Documents". To show all files, just pull down to "All Documents". But as has been said already, a spreadsheet or database manager will be the easiest to deal with the column formats. -- Jim Poston@... << Pegasus Mail - best e-mail client, and it's free! >>
|
|
Mark,
Someone is having an issue with the downloaded member list. ... TheyIt has been so long since I've run a Windows machine without Office installed that I'm not entirely sure of this, but it may be possible that their Windows system does not have a file association set up for the .csv extension. If Office were installed, files with that type would be associated with (automatically open in) Excel. As Jim Ruby said, there ought to be a "Open With" button either in the download, or as a right-click on the downloaded file, which will allow the user to select Notepad or Wordpad. With that should be a checkbox to "Always use this program" for this type of file. Checking that (or leaving it checked) should set up the file association for future handling of .csv files. Or, failing that, if you're trying to open the downloaded .csv from within Notepad you need to change the file type filter to *.* so that it will show you the .csv (and all other files). Then there is the separate issue of extracting just the info you need from the file. I'll agree with those who've said that using a spreadsheet program is the easiest way, if you have such a program (and I can't imagine life without one). Once you've got the file open in Notepad, the first problem with Groups.io's export is that it uses the unix-style line termination: just a LineFeed (U+000A). Notepad doesn't recognize those as new lines, so the rows of the export get mashed together. This should be taken as a bug report (or feature request) - the export should use (or offer) ASCII standard line termination - aka CRLF (U+000D, U+OO0A) for broadest interoperability. Fortunately Groups.io's export has the email address as the first column, and the display name as the second. Which (had it not been for the line termination issue) would have made it relatively easy for the Notepad user to go down from line to line, deleting the unneeded information from the end of each line. -- Shal
|
|
Linda
Shal, you’ve hit the nail on the head!
Thanks very much, Linda ---------------------------------- Once you've got the file open in Notepad, the first problem with Groups.io's export is that it uses the unix-style line termination: just a LineFeed (U+000A). Notepad doesn't recognize those as new lines, so the rows of the export get mashed together. This should be taken as a bug report (or feature request) - the export should use (or offer) ASCII standard line termination - aka CRLF (U+000D, U+OO0A) for broadest interoperability. Fortunately Groups.io's export has the email address as the first column, and the display name as the second. Which (had it not been for the line termination issue) would have made it relatively easy for the Notepad user to go down from line to line, deleting the unneeded information from the end of each line.
|
|
Linda,
Shal, you’ve hit the nail on the head!In that case, you might try WordPad. It seems to accept the newline format of groups.io's export. Then you have only the normal CSV formatting to deal with (lots of quote marks and commas). In WordPad you can also use the Save As command to save it as a "Text Document - MS-DOS Format". That will give it the CRLF style of new line so that Notepad will open that file as one line per member. -- Shal I wrote:
|
|
Linda
Thanks Shal. I will do it because my lists are quiet
today. However, I don’t think that list owners, previously from
Yahoogroups, will be pleased at having to go through all those hoops to get
what, prior to Neo, had been available with a single click (download).
Just my opinion... Thanks again, Linda
From: Shal Farley
Sent: Wednesday, September 9, 2015 3:57 PM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Linda, > Shal, you’ve hit the nail on the head! In that case, you might try WordPad. It seems to accept the newline format of groups.io's export. Then you have only the normal CSV formatting to deal with (lots of quote marks and commas). In WordPad you can also use the Save As command to save it as a "Text Document - MS-DOS Format". That will give it the CRLF style of new line so that Notepad will open that file as one line per member. -- Shal I wrote: > > Once you've got the file open in Notepad, the first problem with > Groups.io's export is that it uses the unix-style line termination: just > a LineFeed (U+000A). Notepad doesn't recognize those as new lines, so > the rows of the export get mashed together.
|
|
Linda,
... I don’t think that list owners, previously from Yahoogroups, willHaving a "lite" version of the Members list export, which gives only the email addresses one per line (as in the Y!Groups classic "Download") is certainly a feature request Mark can consider. I'd like to find a better way to describe it though, as "Export" versus "Download" was not very intuitive for many people (though it became pretty obvious once you tried it). The other difference here, versus Y!G classic, is this business of having to download the file to open it, rather than having the plain text simply appear in a browser page (where you could copy/paste or use Save As, per your own preference). I'm not sure what the technical considerations are, and certainly for groups with thousands of members a copy/paste could be problematic, but for smaller groups it is nice to remove the extra steps. That said, I'm of the "but why would you ever want just the email addresses?" camp. Because I don't understand it, I may not be the best at describing what you want. -- Shal
|
|
Linda
Hi Shal,
I used to save both versions (Download and Export) – just to
have them (security blanket). As far as the members’ names go, it would be
great to have them. However, the vast majority have not entered their
names in their subscriptions. I’ve been doing it for them when they post
and sign their messages – but in one list, signatures are not required and many
members prefer not to sign (support group).
I used your method to download with Wordpad, Save As Text
Document - MS-DOS Format, and when I opened it with Notepad it was readable
enough (one line per member) that I decided not to go to the trouble of removing
all the gibberish I don’t need – especially since I’m hopeful that Mark will
come through when he has the time.
Thanks again,
Linda
From: Shal Farley
Sent: Wednesday, September 9, 2015 4:50 PM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows Linda, > .... I don’t think that list owners, previously from Yahoogroups, will > be pleased at having to go through all those hoops to get what, prior > to Neo, had been available with a single click (download). Just my > opinion... Having a "lite" version of the Members list export, which gives only the email addresses one per line (as in the Y!Groups classic "Download") is certainly a feature request Mark can consider. I'd like to find a better way to describe it though, as "Export" versus "Download" was not very intuitive for many people (though it became pretty obvious once you tried it). The other difference here, versus Y!G classic, is this business of having to download the file to open it, rather than having the plain text simply appear in a browser page (where you could copy/paste or use Save As, per your own preference). I'm not sure what the technical considerations are, and certainly for groups with thousands of members a copy/paste could be problematic, but for smaller groups it is nice to remove the extra steps. That said, I'm of the "but why would you ever want just the email addresses?" camp. Because I don't understand it, I may not be the best at describing what you want. -- Shal
|
|
On 9 Sep 2015 at 16:19, Linda wrote:
> However, I don’t think that list owners, previously from Yahoogroups,
> will be pleased at having to go through all those hoops to get what,
> prior to Neo, had been available with a single click (download).
Well, they could always go back to Y!G, where they can download their
member list in exactly the same way (CSV). The single click download
isn't available there anymore.
It is pretty trivial to clip out the email addresses from the CSV file. If you
don't have Excel or another spreadsheeet program, you can try these
online tools:
--
Jim
Poston@...
<< He who sees everything, sees nothing. >>
|
|
Hi Jim,
Member lists change over time. An old member list isn’t
very useful. So has Yahoo changed since Neo, as I noted.
Thankfully some of us are savvy enough never to use an online
tool from an unknown entity to subject our members to a lifetime of spam and
much worse.
Linda
From: Jim Poston
Sent: Thursday, September 10, 2015 1:31 AM
To: beta@groups.io
Subject: Re: [beta] Download member list question with
Windows On 9 Sep 2015 at
16:19, Linda wrote:
> However, I don’t think that list owners, previously
from Yahoogroups,
> will be pleased at having to go through all those
hoops to get what,
> prior to Neo, had been available with a single
click (download).
Well, they could
always go back to Y!G, where they can download their member list in exactly the
same way (CSV). The single click download isn't available there
anymore.
It is pretty
trivial to clip out the email addresses from the CSV file. If you don't
have Excel or another spreadsheeet program, you can try these online
tools:
--
Jim
Poston@...
|
|