main

main@lists.alug.org.uk

10372 discussions

Excel/Open Office to SQLite
by Chris Walker 15 Jun '11

15 Jun '11

I have a spreadsheet which is currently in OpenOffice ods format but obviously can easily be saved in another format should I need to. The spreadsheet holds roughly 6200 rows with 8 columns. I'd like to import 6 of those columns into an SQLite database and more to the point, do it automatically/programmatically rather than by hand. There is another difficulty (it's difficult for me, it might not be for you!) is that I want the tables to be created from the names in column 3. Some of those columns are numerical and SQLite doesn't appear to like that. The columns look like this :- Name1 Number Name2 Y/N Where Notes Unwanted1 & Unwanted2 For Name2, the rows repeat so there might be half a dozen of the same names, like 1648, 8Sail, Abbeydale against the rows in Name1. Is there somehow I can run a program, Perl, Python or whatever to extract the data and automatically squirt it into a database? I've searched online for something to help and did grab a Python script but it doesn't work for me and as my Python skills, like all my other programming skills amount to zero, I'm stuck, hence the question here. I'd appreciate any help or pointers you could give. -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:cdw_alug@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

4 16

Re: [ALUG] Bring Your Own Server
by Krishna Birth 14 Jun '11

14 Jun '11

On Tue, Jun 14, 2011 at 9:00 PM, Krishna Birth <krishnabirth(a)gmail.com> wrote: >> Message: 1 >> Date: Mon, 13 Jun 2011 21:06:02 +0100 >> From: Wayne Stallwood <ALUGlist(a)digimatic.co.uk> >> To: main(a)lists.alug.org.uk >> Subject: Re: [ALUG] Bring Your Own Server . . >> I think you are all missing the point a bit. I could be wrong but I >> think the objective is to make the server water cooled with some holy >> water as a kind of marketing gimmick. . . . Not gimmick. Regards Meeku p.s. double posted because subject line needed correcting

1 0

Re: [ALUG] main Digest, Vol 72, Issue 13
by Krishna Birth 14 Jun '11

14 Jun '11

> Message: 1 > Date: Mon, 13 Jun 2011 21:06:02 +0100 > From: Wayne Stallwood <ALUGlist(a)digimatic.co.uk> > To: main(a)lists.alug.org.uk > Subject: Re: [ALUG] Bring Your Own Server . . > I think you are all missing the point a bit. I could be wrong but I > think the objective is to make the server water cooled with some holy > water as a kind of marketing gimmick. . . . Not gimmick. Regards Meeku

1 0

Re: [ALUG] Could you build a water cooled PC?
by Krishna Birth 13 Jun '11

13 Jun '11

> > Message: 9 > Date: Sun, 12 Jun 2011 16:03:03 +0100 > From: Wayne Stallwood <ALUGlist(a)digimatic.co.uk> > To: main(a)lists.alug.org.uk > Subject: Re: [ALUG] Could you build a water cooled PC? > Message-ID: <4DF4D527.6090709(a)digimatic.co.uk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 12/06/11 12:43, David Crisp wrote: > >> >> Mineral-free ultrapure water has a resistivity of 18.2 megaohm . cm. I'd >> call that "pretty damn non-conductive", personally. >> >> Of course, eighteen megaohm water is capable of leaching sodium ions out >> of glass, so... > > Yeh this is kinda my point...it is possible to make water fairly non > conductive (although domestic grade distilled water is unlikely to be at > the purity you define) but it is damn near impossible to keep it like that. > > I have access to Reverse Osmosis systems that can produce water that > achieves something like 0.06 microsiemens/CM of conductivity (which > equates roughly to 18meg/CM resistance) but the only way they can do > that is by keeping the water in the RO loop in constant cycle through > the filters let it stop doing that and it will quickly go up. > Wayne, You have access to Reverse Osmosis systems then could you filter a few litres holy river water from India, what are the costs and procedures for doing this? Regards Meeku

2 1

Bring Your Own Server
by Krishna Birth 13 Jun '11

13 Jun '11

I am not a techie and thus could any expert please say if there are any data centres in GB offering inexpensive, 'Bring Your Own Server' service with possibility to set up the India holy river water cooled PC into a server for hosting websites? Sorry if this mailing list post is a bit different to the what you are used to. Regards, Meeku

4 3

Re: [ALUG] Could you build a water cooled PC?
by steve-ALUG＠hst.me.uk 13 Jun '11

13 Jun '11

If Quiet is what you want, I've had stuff from QuietPC that's made a tremendous difference. Not particularly cheap though. (Satisfied customer, otherwise, no connection) On 10/06/11 15:39, Matthew Green wrote: > Why do you want one? > > If you're looking to build something to help overclocking the inexpensive > kits are generally worse than high end air-cooling. > > If you're thinking about reducing noise then passive air cooled heatsinks > and maybe a large slow system fan would be a better direction. > > Matt > > -----Original Message----- > From: main-bounces(a)lists.alug.org.uk [mailto:main-bounces@lists.alug.org.uk] > On Behalf Of Krishna Birth > Sent: 07 June 2011 19:39 > To: main(a)lists.alug.org.uk > Subject: [ALUG] Could you build a water cooled PC? > > I am interested also in having a water cooled PC. I am on a budget. > Thus it should not be expensive. The watercooling kit should be open > not closed / sealed unit because it should allow me to put the > distilled water. > > Regards, > > > Meeku > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! > > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above!

1 0

PDF manipulation, how to print a misconfigured booklet with 'two pages per page'?
by Chris G 13 Jun '11

13 Jun '11

I have a PDF document downloaded where the (landscape) pages are actually delivered as two pages per 'page'. Thus if you print it in the normal way you get two landscape pages across each sheet of paper. Is it possible, relatively easily, to tell Acrobat Reader (or any of the alternatives) to print each 'page' of the downloaded PDF as two pages on the printer? -- Chris Green

2 2

Re: [ALUG] Could you build a water cooled PC?
by James Bensley 13 Jun '11

13 Jun '11

On 10 June 2011 15:39, Matthew Green <matthew.j.green(a)ntlworld.com> wrote: > If you're looking to build something to help overclocking the inexpensive > kits are generally worse than high end air-cooling. I agree... > The watercooling kit should be open > not closed / sealed unit because it should allow me to put the > distilled water. Unless I have miss-understand, this is a bad idea. In the event of a leak you want to be using non-conductive coolant liquid. $friend had water cooling, it sprung a leak 'thankfully' over only one part, one of this graphics cards, which after being drained and dried still worked. -- James. http://www.jamesbensley.co.cc/ There are 10 kinds of people in the world; Those who understand Vigesimal, and J others...?

5 7

Re: [ALUG] Bring Your Own Server
by Krishna Birth 12 Jun '11

12 Jun '11

n.b. I am re-posting with subject line corresponding to the original post, is that the way to respond to mailing list digests? There was an item quite interesting. This was from: eweekeurope.co.uk http://www.eweekeurope.co.uk/news/liquid-cooling-gets-sun-co-founders-backi… "Liquid Cooling Gets Sun Co-Founder’s Backing" Regards Meeku

2 1

Re: [ALUG] main Digest, Vol 72, Issue 9
by Krishna Birth 12 Jun '11

12 Jun '11

There was an item quite interesting. This was from: eweekeurope.co.uk http://www.eweekeurope.co.uk/news/liquid-cooling-gets-sun-co-founders-backi… "Liquid Cooling Gets Sun Co-Founder’s Backing" Regards Meeku

1 0

Re: [ALUG] Could you build a water cooled PC?
by David Crisp 12 Jun '11

12 Jun '11

On 11 Jun 2011, at 20:11, Matthew Green wrote: >>> >> Distilled water *is* virtually non-conductive. It's only the salts >> and >> impurities in tap water (and/or river water etc.) that make it >> moderately conductive. > > > It's not only the salts. There is some natural ionisation that will > result in free H+ and OH- ions. You can't really escape that so even > mineral free ultra pure water in a perfectly sealed sterile container > (of a material that won't release minerals as the water desperately > tries to leach them) will still be *slightly* conductive. Mineral-free ultrapure water has a resistivity of 18.2 megaohm . cm. I'd call that "pretty damn non-conductive", personally. Of course, eighteen megaohm water is capable of leaching sodium ions out of glass, so... DC.

2 1

Re: [ALUG] Could you build a water cooled PC?
by Ricky Bruce 11 Jun '11

11 Jun '11

On the subject of mineral oils, i am sure most people have already seen this, but it is still cool, especially if you like Bioshock http://imgur.com/a/jYv3X Ricky On Sat, Jun 11, 2011 at 8:11 PM, Matthew Green <matthew.j.green(a)ntlworld.com> wrote: > Yeah, you can go for cooling fluids which are basically distilled water with > additives (Which is what I've gone for). But the only options for proper > non-conductivity are mineral oils (which can be a bit viscous) or another > option is Fluronert by 3M which was used by Cray, but that's more expensive > than fine champagne. > > > -----Original Message----- > From: main-bounces(a)lists.alug.org.uk [mailto:main-bounces@lists.alug.org.uk] > On Behalf Of Wayne Stallwood > Sent: 11 June 2011 17:36 > To: main(a)lists.alug.org.uk > Subject: Re: [ALUG] Could you build a water cooled PC? > > >>> >> Distilled water *is* virtually non-conductive. It's only the salts and >> impurities in tap water (and/or river water etc.) that make it >> moderately conductive. > > > It's not only the salts. There is some natural ionisation that will > result in free H+ and OH- ions. You can't really escape that so even > mineral free ultra pure water in a perfectly sealed sterile container > (of a material that won't release minerals as the water desperately > tries to leach them) will still be *slightly* conductive. > > Also pretty much as soon as it came into contact with the guts of a PC > it will absorb enough minerals to become conductive rather quickly if it > hadn't already done so in the cooling loop of a cheap Watercooling system. > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! > > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! >

1 0

CSS question about using float
by Chris G 11 Jun '11

11 Jun '11

I have a little CSS conundrum. I want to have a heading (H1 or H2) followed by some small and different coloured text on the same line. I can't do much manipulation of the headings because they are generated by a Wiki, but I can apply CSS to them as well if necessary. So, I have got as far as something like:- <html><div class="textright">&nbsp Text on right</div></html> <html><h1>Heading 1</h1><html> with CSS:- .textright { margin-top: 1em; margin-bottom: 0px; padding-bottom: 0px; float: right; } This works to an extent, the 'Text on right' does appear on the same line as the H1 heading as I want. However it's right across on the RHS and I really want it nestled up against the H1 text. Is there any reasonably easy way to get what I want? I'd really prefer not to have to make the heading 'float: left;' as this causes all sort of other fun and games, mainly because there's no easy way to 'clear: both;' afterwards. What I want is a box that occupies the whole width of the page the the right of the heading and then place the 'Text on right' within that box aligned to the left, but how do I get a box to place itself like that? -- Chris Green

7 17

Could you build a water cooled PC?
by Krishna Birth 10 Jun '11

10 Jun '11

I am interested also in having a water cooled PC. I am on a budget. Thus it should not be expensive. The watercooling kit should be open not closed / sealed unit because it should allow me to put the distilled water. Regards, Meeku

2 1

Could you change the fonts on Bios via the video card?
by Krishna Birth 08 Jun '11

08 Jun '11

I want to change the font on the Bios which is separate from the operating system. Have any LUG members experience with changing the font on Bios via the video card? Regards, Meeku

2 1

Re: [ALUG] (no subject)
by Dalibor Zeman 07 Jun '11

07 Jun '11

I am really sorry for last e-mail from me. Somebody spoofed my e-mail box lately. @Scott, sorry I didn't opent that link. Dali On 7 June 2011 14:48, Dalibor Zeman <dalibor.zeman(a)gmail.com> wrote: > I am really sorry for that. Somebody spoofed my e-mail box lately. > > BTW. It doesn't matter what OS you have when you use browser based e-mail > account. Unfortunately spoofing picked main(a)lists.alug.org.uk e-mail > address. > > Thank you. > > Dali. > > > On 7 June 2011 14:10, Alex Scotton <alex.scotton(a)gmail.com> wrote: > >> Don't click the link.. >> >> It's another joyous Fake AV Malware app.. >> >> Hilarious this has been sent to a Linux mailer group :P >> >> Alex >> >> On Mon, Jun 6, 2011 at 11:28 PM, Dalibor Zeman <dalibor.zeman(a)gmail.com>wrote: >> >>> <http://shop.graphicplanet.net/images/mysite.html> >>> >>> _______________________________________________ >>> main(a)lists.alug.org.uk >>> http://www.alug.org.uk/ >>> http://lists.alug.org.uk/mailman/listinfo/main >>> Unsubscribe? See message headers or the web site above! >>> >> >> >> >> -- >> *Alex Scotton* >> mob: 07950 524744 >> home: 01603 768361 >> * >> * >> Web Design | Graphic Design *|* MySQL Design and Optimization *| *SEO, >> advertising and Marketing Services | Computer Repairs | Network, Active >> Directory and Streaming Services | NLB and Bandwidth Shaping >> * >> * >> *http://goo.gl/FIbia* >> >> >> >> >

1 0

(no subject)
by Dalibor Zeman 06 Jun '11

06 Jun '11

http://shop.graphicplanet.net/images/mysite.html

1 0

[ALUG Announce] ALUG Norwich Pub Meet Thursday 9th June
by Viperfang 06 Jun '11

06 Jun '11

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- Hello Aluggers, Our monthly ALUG Norwich social meeting will be held this Thursday, 9th June at The Coach and Horses (82 Thorpe Road, Norwich, NR1 1BA). The meeting officially starts at 8pm, although some people may arrive earlier. More information on those people can be found on the list and the IRC channel. If you are unsure if you will recognise us then make yourself and your intent to attend known by either posting on list or visiting us on IRC so we can look out for you rather than hiding in the corner. Optionally you could ask at the bar if they know where the geeky computer weirdos are and they'll point you in the right direction (seriously!). Another possibility is look for heaps of electronics on a table that may possibly look like movie props that would used for detonating explosives. Feel free to bring electronics/laptops/gadgets to the meet, you will by no means be alone. Ben Bewick aka Viperfang NB: This mail is automated, please refer to the usual sources for more information. ALUG Contact Details: Website : http://www.alug.org.uk/ IRC : #alug on irc.alug.org.uk List : http://lists.alug.org.uk/mailman/listinfo Twitter : http://twitter.com/anglianlug Identica: TBA Facebook: http://www.facebook.com/group.php?gid=2381613902 ----- Send discussion replies to main(a)lists.alug.org.uk (Reply-To set) Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce

1 0

Re: [ALUG] Could you build a linux distro?
by Krishna Birth 05 Jun '11

05 Jun '11

On Sun, Jun 5, 2011 at 7:37 PM, Krishna Birth <krishnabirth(a)gmail.com> wrote: > I want a linux distro. Could you tweek an existing distro e.g. Ubunto or > Fedora? > > Please tell me if I wanted a logo installed, put fonts, remove other fonts > at console/terminal, verbose, gui, apps and perhaps put a keyboard app, > startup browser with specific website, what would you charge for live or > install distro and also for regular maintenance? > > > Best, > > > Meeku Press Release “onlliinnee” is meant to be an opensource foss operating system. It is meant to be free os and a linux based distro. What is meant to be different and planned about onlliinnee is: only unique fonts, software, development, a specific website home page on the browser, startup screen connects to video website/s, related with model railroad / railway, diecasting and ‘automation over internet protocol’ (AOIP) especially Rail Model AOIP (RMAOIP) and is for Srila Prabhupada: the always on eternal spiritual initiating and education guru. Regarding any questions about this, send message to: identi.ca/onlliinnee (after joining identi.ca) www.onlliinnee.net copyright 2011 onlliinnee. all rights reserved worldwide.

1 0

Postfix (Sendmail) problem
by Barry Samuels 03 Jun '11

03 Jun '11

I sent this mail directly to Brett by mistake - sorry Brett. Here it is again: On 02/06/11 20:16:25, Brett Parker wrote: > I'd almost bet if you google for the address it's already out there, but > meh. It's not. > > All emails sent, using my standard mailer (Balsa), are directed > > through my ISP i.e relayhost= in the Postfix main.cf file and don't > > give any errors/problems. This current problem happens only when using > > /usr/sbin/sendmail directly which of course is what procmail does when > > forwarding a copy. > Which won't (neccessarily) send from a valid e-mail address, and the > relayhost is (correctly) rejecting it. > > So, you want to make sure that the sending address is correctly > qualified, the server is checking that, and then going "hang on, that > address doesn't resolve". > -- > Brett Parker You are quite right of course. I discovered that when using sendmail directly with the -f option it does work. I've now engineered a procmail recipe involving sendmail -f that also works. So all is now back to working the way it did before. Thanks for your help and if I ever come across a chocolate teapot you'll be the first to know. -- Barry Samuels

1 0

Re: [ALUG] Blackberry vs Cyrus
by Stuart Bailey 03 Jun '11

03 Jun '11

On Thursday 02 June 2011 18:20:27 Wayne Stallwood wrote: > On 02/06/11 10:44, Brett Parker wrote: > > They'll then complain that "my mail on my blackberry and thunderbird > > aren't in sync! I deleted that! ARGH!" instead. > > I think this is one of the reasons I hate crackberry. > > For me having a full and complete state sync of email on my phone is > important. So if I read an email on the phone I want it marked as read > on the desktop mail client. If I respond I want the response in Sent > items on the desktop client and certainly if I delete a mail I want it > deleted on the desktop. > > This way I know I only need to look in one (either) place to get a full > and complete picture of what emails I have dealt with and how I > responded to them. > > I guess to get around the 3rd party password problem I'd have to run a > local BES and last time I looked at that it looked pretty evil and > overcomplicated. > I have found an alternative to BES - funambol. I haven't yet installed it for this customer, but I've heard good things about it. Stuart Stuart Bailey BSc (hons) CEng CITP MBCS LinuSoft (Managing Director) Linux Specialist & Software Developer ~~~~~~~~~~~~~~~~~~~~~~~ Phone: (0845) 658 3563 Direct: +44 (0)1953 878162 Fax: +44 (0) 1603 858583 ~~~~~~~~~~~~~~~~~~~~~~~ http://www.linusoft.co.uk http://www.bluetoothadvertising.org.uk __________ Information from ESET Mail Security, version of virus signature database 6175 (20110602) __________ The message was checked by ESET Mail Security. http://www.eset.com

1 0

Re: [ALUG] Blackberry vs Cyrus
by Stuart Bailey 03 Jun '11

03 Jun '11

On Thursday 02 June 2011 10:44:34 Brett Parker wrote: > On 02 Jun 10:29, Stuart Bailey wrote: > > I have a customer running Cyrus IMAP and Postfix. They have users with > > Thunderbird clients on their desktops and some Blackberries using the BIS > > service. > > > > They are complaining that sometime emails appear on the Blackberry 10 > > mins before they appear in their mailbox on Thunderbird. > > > > Apparently the BB is polling every 5 mins, and Thunderbird every minute > > Any ideas what may be causing this delay? > > Simples - if the blackberry poll hits at the time that the mail comes > in, it'll mark things as having been grabbed, and so the Recent flag > stops being relevant and thunderbird won't notice until it does a full > proper check (usually, I'd guess that it asks for a status from the imap > connection, notes there's nothing Recent and carries right on, and > probably doesn't check Unread). > > Simple, easy test: set the blackberry to check a different mail account > and set postfix to deliver mail to both accounts - see if they then stop > complaining about it... > > They'll then complain that "my mail on my blackberry and thunderbird > aren't in sync! I deleted that! ARGH!" instead. > > Also, BIS stores passwords in plain text on their end (have to so that > they can auth with the mail server)... I Really Don't Trust RIM to get > this right consistently, so I tended to make it so that RIM had a > different account and password to the main user (damage limitation!). > > Cheers, Thanks Brett. that is helpful. I have found that turning off polling in Thunderbird and using IDLE instead may help. I'm evaluating this at the moment. Stuart Stuart Bailey BSc (hons) CEng CITP MBCS LinuSoft (Managing Director) Linux Specialist & Software Developer ~~~~~~~~~~~~~~~~~~~~~~~ Phone: (0845) 658 3563 Direct: +44 (0)1953 878162 Fax: +44 (0) 1603 858583 ~~~~~~~~~~~~~~~~~~~~~~~ http://www.linusoft.co.uk http://www.bluetoothadvertising.org.uk __________ Information from ESET Mail Security, version of virus signature database 6175 (20110602) __________ The message was checked by ESET Mail Security. http://www.eset.com

1 0

Postfix (Sendmail) problem
by Barry Samuels 02 Jun '11

02 Jun '11

Debian Testing/Wheezy, kernel 2.6.38, Postfix I've had a procmail receipe in place for a few weeks now and it's been working well. :0 * ^(TO|FROM):.+@mydomainname.* { :0c # Send a copy to the other email account. ! someone(a)anotherdomainname.com # File the original as normal :0 foldername } Then a few days ago, probably after some OS updates, it fails with: status=deferred (host mail.*******.*****.com[000.00.00.0] said: 451 4.4.0 DNS temporary failure (chkuser) (in reply to MAIL FROM command)) (I've removed the data identifying the destination) I have also tried sending an email directly using /usr/bin/sendmail and that produces the same result, whatever the emails destination, so I'm assuming it must be my setup. I can't explain why it worked before but doesn't now though. I have really no idea what this means as Postfix configuration is a series of magical incantaitions which I don't understand. Some help would be much appreciated. -- Barry Samuels

2 3

Blackberry vs Cyrus
by Stuart Bailey 02 Jun '11

02 Jun '11

I have a customer running Cyrus IMAP and Postfix. They have users with Thunderbird clients on their desktops and some Blackberries using the BIS service. They are complaining that sometime emails appear on the Blackberry 10 mins before they appear in their mailbox on Thunderbird. Apparently the BB is polling every 5 mins, and Thunderbird every minute Any ideas what may be causing this delay? Many thanks, Stuart __________ Information from ESET Mail Security, version of virus signature database 6172 (20110601) __________ The message was checked by ESET Mail Security. http://www.eset.com

3 2

Java woe
by Bev Nicolson 27 May '11

27 May '11

I'd like to test my broadband speed but the BT test page says I don't have Java installed. I do. I've got sun-java6-jre. I don't seem to be able to enable it though via Firefox (or Chrome for that matter.) Have I missed something blindingly obvious? Help. Bev.

5 7

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

main