Re: [chat] Some Technical people!

[Grant Parnell <grant@xxxxxxxxxxxxxxxx>]

Stuart, thanks for your reply. I was only joking about needing the help,
however your serious reply has amused me almost as much as the original
message.

Yes, the main point I was getting at is the "Technical Support Manager" is
more "Manager" than "Technical Support".

If I could be bothered I'd just do a proper mime encoded message with the
CSV file and maybe set Content-Type: application/ms-excel. You can do this
from shell scripts with the metamail program but in this case I'm using
Zope and it probably has a built-in function to do it nicely as well.


On Fri, 21 Dec 2001, Stuart Cooper wrote:

> Hi Grant,
>
> > Urgently needed, someone to help a Technical support manager to load a
> > comma delimited message into Excel :-)
>
> > The email this person's refering to had a simple list like so:-
>
> > login,password,company name
> > blah123,xyz123,The Blah Company
> > tFHS1243,abc123,The File Handle Service company
>
> > I didn't bother including it as an attachment.
>
> This is the most visual, yet Linux-based was I could think of doing it:
>
> Save your list to a file 'blah.csv' (rename blah as appropriate).
> Open it up with star office:
> $ soffice blah.csv
> (if you've already got Star Office running, choose File/Open and give the
> Linux pathname to blah.csv)
> Say 'yes' to any questions that Star Office asks you.
>
> Page through this spreadsheet and check that the fields look OK. If you
> have any commas in blah.csv that were part of the data and weren't comma
> separators your spreadsheet might be out of whack, you should be able to
> see this by inspection. If you had a comma inside a string like
> scooper,25,"Stuart Cooper, SLUG poster"
> it will be handled OK.
>
> Then use 'Save as' to save it in a Microsoft Excel format, it will become
> blah.xls.
>
> blah.xls is now an Excel spreadsheet that can be opened in Excel.
> You can email it as an attachment to the tech support manager.
>
> > Thankyou for your assistance
> > Unfortunately I am not as computer literate as some people expect me to be.
>
> > <censored name>
> > Technical Support Manager
> > <censored company name>
>
> Mmmm a technical support support manager who is not computer literate...
> a bit scary. Hopefully he is taking the time to learn stuff; hopefully he
> is also using his own technical support staff to help him out.
>
> Good luck,
> Stuart.
>

-- 
---<GRiP>---
Grant Parnell - senior consultant
For all your Linux Commercial quality support and consulting needs
Web: http://www.linuxhelp.com.au      Email: grant@xxxxxxxxxxxxxxxx
For retail sales see http://www.everythinglinux.com.au
or drop into 40 East Street, Five Dock, NSW 10:30am-4:30pm