Topics

locked Download member list question with Windows


 

Mark,

I just pushed a change to the site so that downloading the member list
should now have proper linefeeds on Windows machines (ie. all the lines
won't run together). I also removed a bunch of unnecessary quotes around
the numeric fields. Please let me know what you think.
Much cleaner look, I like it (even though I immediately paste the list into Excel and the look doesn't really affect me).

-- Shal


Linda
 

Hi Mark,
I think you’re the greatest! 
Thank you so much. 
Linda
 

Sent: Thursday, September 17, 2015 8:11 PM
Subject: Re: [beta] Download member list question with Windows
 
I just pushed a change to the site so that downloading the member list should now have proper linefeeds on Windows machines (ie. all the lines won't run together). I also removed a bunch of unnecessary quotes around the numeric fields. Please let me know what you think.
 
Thanks,
Mark


 

I just pushed a change to the site so that downloading the member list should now have proper linefeeds on Windows machines (ie. all the lines won't run together). I also removed a bunch of unnecessary quotes around the numeric fields. Please let me know what you think.

Thanks,
Mark


Linda
 

Hi Shal,
My mistake - it was a plain text web page that I saved to a file.  One click, Save As.  Perfect!
Thanks!
Linda
 

Sent: Friday, September 11, 2015 10:21 PM
Subject: Re: [beta] Download member list question with Windows
 
Linda,

> After Mark made the change, I got the same result as Steph.

All the members run together, rather than separated one per line? I
wonder what the difference is.

> Yahoo’s (old) Download list that was Text File, not a web page.

Actually, it was a plain text web page, which you could then save to a
file. Here's a screen shot showing the Download list in Firefox:
https://www.flickr.com/photos/shalf/10130182725/in/album-72157636272401705/
(pardon the blurs for privacy)

And here's one showing the Export list:
https://www.flickr.com/photos/shalf/10130180605/in/album-72157636272401705/

The second looks very much like I see with Mark's update, except that
Yahoo had the ID first and the email address second, had used
apostrophes rather than quote marks, and had spelled out the field
content rather than using numeric codes for most.

-- Shal



 

Linda,

After Mark made the change, I got the same result as Steph.
All the members run together, rather than separated one per line? I
wonder what the difference is.

Yahoo’s (old) Download list that was Text File, not a web page.
Actually, it was a plain text web page, which you could then save to a
file. Here's a screen shot showing the Download list in Firefox:
https://www.flickr.com/photos/shalf/10130182725/in/album-72157636272401705/
(pardon the blurs for privacy)

And here's one showing the Export list:
https://www.flickr.com/photos/shalf/10130180605/in/album-72157636272401705/

The second looks very much like I see with Mark's update, except that
Yahoo had the ID first and the email address second, had used
apostrophes rather than quote marks, and had spelled out the field
content rather than using numeric codes for most.

-- Shal


Linda
 
Edited

Hi Shal,
After Mark made the change, I got the same result as Steph. 
 
Yahoo’s (old) Download list was Text File, not a web page. 
 
Linda
 

Sent: Friday, September 11, 2015 9:44 PM
Subject: Re: [beta] Download member list question with Windows
 
Steph,

> It is like that all through the document without any kind of
> separation between each person. Has allot of quotation marks, comas,
> and other things.

Odd. I get a page with one member per line, the email addresses neatly
lined up on the left. Yes, surrounded by quote marks and separated by
commas.

I'm using Firefox, other browsers may vary. Or if you haven't tried it
since Mark changed it from a mandatory download to a page that just
opens in the browser, you should try it again.

-- Shal



 

Steph,

It is like that all through the document without any kind of
separation between each person. Has allot of quotation marks, comas,
and other things.
Odd. I get a page with one member per line, the email addresses neatly lined up on the left. Yes, surrounded by quote marks and separated by commas.

I'm using Firefox, other browsers may vary. Or if you haven't tried it since Mark changed it from a mandatory download to a page that just opens in the browser, you should try it again.

-- Shal


Steph <hsrsp@...>
 

Hi Mark and everyone,
I am going to provide what it shows for me when I click on download.  I'm going to use my info as an example and then I'm going to give a suggestion.
 
"hsrsp@...","Steph","","6/9/2015","0","1","0","0","false","2","1"nextaddress","theirname etc. etc.
 
It is like that all through the document without any kind of separation between each person.  Has allot of quotation marks, comas, and other things. 
 
My suggestion would be having info for each person on their own line, and none of that extra stuff?  I don't know about other group owners and moderators but it sure would be easier on me.  Les of a headache.  Just a suggestion.  Steph

Sent: Friday, September 11, 2015 5:25 PM
Subject: Re: [beta] Download member list question with Windows

Ok, I've made the change so that when you download the member list, it will be sent as plain text. Let me know if this is better or worse.

Thanks,
Mark

On Thu, Sep 10, 2015 at 3:40 PM, Shal Farley <shal@...> wrote:
Mark,

> Would it help things if I changed the mime type of the returned page
> so that it's plain text instead of text/csv? That would mean when you
> click on the download link, instead of downloading a csv file, it'll
> just appear as text in the browser window?

I think that would be friendly for owners of small groups.

And I don't think it wouldn't adversely affect owners of large groups, they can use the browser's File | Save As function to create a .txt or ..csv file from it. Unless the list were somehow too big for a browser to handle this way - I have no idea if that's even a possibility.

-- Shal





 

Ok, I've made the change so that when you download the member list, it will be sent as plain text. Let me know if this is better or worse.

Thanks,
Mark

On Thu, Sep 10, 2015 at 3:40 PM, Shal Farley <shal@...> wrote:
Mark,

> Would it help things if I changed the mime type of the returned page
> so that it's plain text instead of text/csv? That would mean when you
> click on the download link, instead of downloading a csv file, it'll
> just appear as text in the browser window?

I think that would be friendly for owners of small groups.

And I don't think it wouldn't adversely affect owners of large groups, they can use the browser's File | Save As function to create a .txt or ..csv file from it. Unless the list were somehow too big for a browser to handle this way - I have no idea if that's even a possibility.

-- Shal





 

Mark,

Would it help things if I changed the mime type of the returned page
so that it's plain text instead of text/csv? That would mean when you
click on the download link, instead of downloading a csv file, it'll
just appear as text in the browser window?
I think that would be friendly for owners of small groups.

And I don't think it wouldn't adversely affect owners of large groups, they can use the browser's File | Save As function to create a .txt or ..csv file from it. Unless the list were somehow too big for a browser to handle this way - I have no idea if that's even a possibility.

-- Shal


Steph <hsrsp@...>
 

I think you could try that and we can test it to make sure that it works.
 
Thanks Mark for all that you do here on Groups.io.  We appreciate it.

Sent: Thursday, September 10, 2015 4:41 PM
Subject: Re: [beta] Download member list question with Windows

Would it help things if I changed the mime type of the returned page so that it's plain text instead of text/csv? That would mean when you click on the download link, instead of downloading a csv file, it'll just appear as text in the browser window?

Mark


 

Would it help things if I changed the mime type of the returned page so that it's plain text instead of text/csv? That would mean when you click on the download link, instead of downloading a csv file, it'll just appear as text in the browser window?

Mark


 

On 10 Sep 2015 at 3:20, Linda wrote:

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.
Just trying to offer you an option other than the simple ones that have
been suggested for you.

Thankfully some of us are savvy enough to do trivial manipulation of csv
files without needing to use online tools.

--
Jim
Poston@...

<< (horrified) 'No! Not the Knights who say Ni!' >>


Linda
 
Edited

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
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@...


 

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.                    >>
  


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
 

Sent: Wednesday, September 9, 2015 4:50 PM
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



 

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


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 
 

Sent: Wednesday, September 9, 2015 3:57 PM
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,

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
 

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.