June 2011 - main - earth.li

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