Open Office excels where Excel doesn’t

Posted by | Websites | No Comments
I don't use Excel except as a crude database for names. Macros and the like are a mystery to me; simple formulas are as good as I get. Today I installed the excellent Connections plugin on a new website I'm building for Ryde Business Forum. It's going to be the member directory. As well as using the free plugin I bought an add-on which allows me to upload a .csv file of names, addresses and the like into the database. How hard can it be? Even I can create a .csv from Excel. But that's where it all started to go pear-shaped. I use Excel 2008 for Mac, and while it can create a .csv file it didn't create it with quote marks around each cell content, which is what Connections needs. Nor could I find a way to make the program do it. I looked glumly down the barrel at manually putting quote marks around membership details for 150+ members. Not only would it take hours, I'd have RSI at the end of it. A web search found me a macro that would create a .csv with quote marks, so I stopped swearing for a bit. Only to find that - guess what! - it doesn't work on Excel 2008 for Mac as Microsoft decided this particular version wouldn't support Visual Basic macros. Earlier versions do (but I don't have an earlier version) and later versions do (but I don't want to pay hundreds right now just for the privilege).  I started swearing again. Sometimes I really hate technology. Sometimes I really hate Microsoft. Well, most of the time I really hate Microsoft; with Word in particular it has made what was once a decent WP program into a clunky monster and PowerPoint has got worse rather than better in usability. More searching pointed me in the direction of Oracle's Open Office, which is free and which, with a mere click or two, can produce a .csv file complete with quote marks. I simmered down and had a cuppa while OO downloaded and installed. True to its promise I got my .csv as I needed it in less than twenty seconds. Another minute later and I had a database mapped to Connections. There is still some work to do - loading logos, social media links and company descriptions, which have to be handled manually. Unfortunately the current version of Connections doesn't support the very important fields of Contact First Name and Contact Last Name in the .csv import but I understand this will be rectified in a later one. When I have some time over the next couple of days I'll explore OO more fully to see how it compares with the accepted standard, Microsoft Office. I am already using Mac's Pages as a rival to Word for some small client jobs. It's quicker to use, actually, and much better for adding images and creating DTP jobs for the web and email (but not pro print), even if you have to go through the fiddly step of loading them into iPhoto first. Right now though, it's wine o'clock on a Friday, I still have a headache from my sweary session earlier in the day, and it's quittin' time.

I love books so much I’m selling them

Posted by | News | No Comments
I've always been a reader. I learned to read when I was about two I think. Books have always been my best friend; I have one or more on the go at any one time and love re-reading old favourites. Like many voracious readers I've dreamed of running a bookshop over the years. However I think I'd gravitate between acting like Bernard Black of Black Books (that's him on the right) or simply dreaming the day away reading the stock! So I've found a compromise. I'm selling books over the net as an Amazon Affliliate. At the moment my bookshop concentrates on:
  • Business books - marketing, sales, motivational, computers, software and internet/web
  • Kindle e-books - the entire Amazon stock so there's something for everyone, fiction and non-fiction
  • Photography - a personal interest which many people I know share
  • Books on writing - for when we need inspiration and a nudge in the right (or write) direction
  • Murder mysteries - because I love them. Specifically I love British mysteries and if I have to narrow it down, I tend towards relishing some of the marvellous Golden Age writers like Josephine Tey. But here, at the House of Arion, you can buy any mystery by any author Amazon has in stock.
  • And lastly, software. Any and all. By all the suppliers.
As you can surmise I'm not doing this as a volunteer. I genuinely hope people will buy from me as I do get a minor cut of everything I sell. I'll be upfront about that. Look around you and you'll find a lot of people branching out and monetizing their website. I don't mean the shonks who ask you to spend thousands on, let's say, a diet plan that doesn't work, but genuine people expanding their avenues of income. It's a good thing. And like I said, I always wanted to own a bookshop.