|
 |
2008-07-08 14:56:07 | Kexi to ODS |
 |
 |
 |
|
|
After reading the headers for kspread which showed me where I was going wrong, I now have Kexi reports able to output to an ODS (Opendocument Spreadsheet) file by utilising the excellent KSpread libraries. Fields in a report are ordered based on horizontal position, and the text saved into a Cell based on the order. As a test I generated a 20000 row sheet, and openened it up in OO.o, see it here, and download it here. |
|
|
|
 |
comments (1) |
 |
|
|
2008-06-19 09:44:25 | HTML Reports in Kexi |
|
|
|
|
|
After some initial work, a re-think and re-design, and a re-implementation you can now get quite nicely formatted reports from Kexi in HTML form using some CSS magic.
Only text is implemented atm, so images, charts, barcodes are still to come, but the output is pretty close to the original page based version, as you can see at http://www.piggz.co.uk/kexi/htmlcss3.png and http://www.piggz.co.uk/kexi/htmlcss4.png.
There will also be a simplified table based version as an option.
Some samples are at http://www.piggz.co.uk/kexi/product_list.html (its 1.9mb representing 10000 records, so be warned ;) and http://www.piggz.co.uk/kexi/rainfall.html.
Enjoy. |
|
|
|
|
comments (3) | link |
|
|
|
2008-04-23 12:56:33 | Now i remember why I dont use Windows |
|
|
|
|
|
My mum pops round last night with her laptop. Earlier it had displayed a message saying the battery was going to run out, and then turned off. It wouldnt turn back on.
I tested the power supply with a multi-meter and it seemd OK. I asked if it had been dropped...'No' was the reply, shortly followed by 'Well, it did fall off the little table but was still working OK'
I decided it was best to get a new laptop, as this one clearly wasnt getting power from the mains. But this particular machine is the one with the entire shop inventory and sales history in it and it would be handy to get it off and onto another machine.
No problem, I whipped out the HD, and installed it in my own laptop.
Windows proceeded to boot and got the the 'Activation' screen. No problem I thought, a quick call to Microsoft will have us running in no time, and I can transfer all the data/documents to a USB stick.
I entered the 60! digit number, and was told to change the license key, which I did, and then entered a new 60 digit number, I must have done it too fast because I got transferred to an operator.
I explained the situation and that i was temporarily using my mums HD in my laptop to recover some data from it. I was quite shocked when I was told that because Windows had been pre-installed on the original laptop, the license couldnt be transferred to another machine. After a short agrument where I told him I thought it unfair as we needed the data and it was clearly a temporary situation as I run Linux he gave me the activation key, and all seemed good.
In went the USB disk......and.......nothing.
Device manager suggested drivers needed re-installed, fair enough as it was another machine (though im sure a linux kernel would have reconfigured itself a bit better), so I reinstalled the usb drivers which got rid of the exclamation marks, rebooted and was sure it would work this time.
The screen resolution was even right now......but shortly after starting up it all went horribly wrong.....BSOD, for no aparent reason.
A cycle of rebootss commenced, along with disk checking...nothing would work, not even safe mode.
'Ah' I though.....i'm being stupid, why not boot off a Linux live CD and copy the files?
In went Ubuntu, the USB drive worked OK and I went to mount the NTFS drive.
Catastrophe!! the drive wouldnt mount....errors suggesting a bad/missing MFT, and I should run chkdsk.
I rebooted again, but this time Windows wouldnt even attempt to load, the partition seems totally corrupt. I eventually got a 'Windows Recovery Console CD' and attempted to run chkdsk from it, but it told me the drive had unrecovereable errors :(
As a last resort I left 'photorec' running over night scanning for .mdb files, and it managed to find some which may reduce the strain of re-entering all orders and transactions for the last year from paper copies.
Ive also left 'testdisk' running to see if it can find an MFT, but I dont hold much hope.
Motto? BACKUP BACKUP BACKUP.... she had even bought a USB stick to backup the shop database to, but she clearly hasnt got the hang of it.....I bet she does it tonight though! |
|
|
|
|
comments (10) |
|
|
|
2008-04-17 19:30:57 | Look out Microsoft, here we come ;) |
|
|
|
|
|
Ok, so we're maybe not quite there yet,but our own office DB app kexi is slowly gaining features. You will shortly be able to create charts directly within a reports. You can already see what it will look like from the designer, it just isnt saved or rendered yet, but because it looks quite cool, i think its worth showing off (atleast the others in #kexi think so). Check it out here. To get an idea on how it evolved, have a look at the 6 prior snaps also.
|
|
|
|
|
comments (3) |
|
|
|
2008-03-14 12:34:47 | Script your reports |
|
|
|
|
|
So you have a report to produce, no problem for kexi these days, but your asked to highlight certain conditions...what do you do?
Script it!
Write something like this. And get results like this.
I would have made those text boxes transparent, if it didnt crash when i selected them...but thats something to fix tonight ;) |
|
|
|
|
comments (1) |
|
|
|
|
![[Valid RSS]](images/valid-rss.png "Validate my RSS feed")
