Home › IT zone › Tools and Tips › A review of Mac OS X timesheeting/tracking applications: Billings vs iBiz (and now Studiometry) › Billings ›
Access stored timesheet data by SQL
[feature] Submitted by webel on Thu, 17/06/2010 - 18:40
4
Billings uses SQLite3, so you can easily get at your precious data by connecting to the Billlings .bex
output files (used for backups) with any good SQL client like Navicat or RazorSQL (the Netbeans SQL Plugin failed on this at the time of writing Jun 2010). It is easy to therefore create custom web reports using, for example, PHP.
- Printer-friendly version
- Login to post comments
Jakarta EE is out !
The new name for Java EE is Jakarta EE and it's officially out !

Zones
- IT zone
- Drupal CMS technology zone
- UML zone
- Java zone
- XML zone
- SysML zone
- C++ zone
- Eclipse zone
- Netbeans IDE zone
- Puredata synthesis zone
- Shibboleth zone
- Snippet-driven engineering: a meta-process for documentation-driven software and systems engineering
- Cascading Style Sheets (CSS) zone
- Tools and Tips
- JIRA zone
- A review of Mac OS X timesheeting/tracking applications: Billings vs iBiz (and now Studiometry)
- Billings
- (Option to enforce) only one timer runs at a time.
- Access contributing items and their property sheets directly from reports
- Access stored timesheet data by SQL
- CPU usage efficiency
- Column-delimited data export (easily imported into spreadsheet applications)
- Convenient and quick editing of job event title and notes
- Customisable reports
- Default currency choice known to all newly created timers
- Documentation easily navigable
- Easily select all job events within a subset of projects
- Easily start/pause/restart timers (without completing/closing job event)
- Easy access to start/stop timestamped logging of job sub-events
- Editable log of start/stop of job sub-events
- Export reports (not invoices) as PDF
- Filtering and sorting of job events by date across projects and/or client
- Financial information cent-accurate
- Generate invoice/report for a given fine-grained period (hh:mm accurate)
- Hyperlink job event to external resource as URL
- Job event groups with weighted time and service rate averages of sub-events
- Newly created timer knows project/client through context or selection
- Option to show unbilled items in reports (and/or invoices)
- Pie-charts and percentages of time spent by project/client.
- Reliable export of start/finish job event data to iCal
- Tag completed job event by completion state: like PASSED, FAILED, etc.
- Studiometry
- iBiz
- Billings
- Firebug
- Firefox
- Graphics tools zone
- MATLAB
- Mac OS X
Related sites
- Webel's SysML/MBSE videos on Vimeo
- Webel's Drancel videos on Vimeo
- Webel's photo channel on SmugMug
- The GreenSoft company site
- The GreenDesk tutorial site
- The GreenDesk video channel on Vimeo
- The GreenSoft Twitter stream
- Webel's Drupal7 info site (ARCHIVED)
Browse by content type
Keywords
animation
XML
air instrument
sound engineering
wrapper
Drancel
Drupal
network graphing
particle collider
object-relational mapping
signal processing
patch programming
acceleration
accelerometer music
video synthesis
light show
Wii
PHP
Cascading Style Sheets
air drums
ObjectDB
Unified Modeling Language
radiosynthesis
OPAL research reactor
GEM
UML2
Drupal7
CSS
radiotelescope
mathematics
ontology
JIRA
XML Schema
Java3D
JUNG
systems engineering
digital graphics
Java EE Container
LED
amplitude modulation
symbolic algebra
JSP
Java
Enterprise JavaBeans
gestural synthesis
audio synthesis
SQL
screenshot
MagicDraw UML
website
XSD
web services
web development
SysML Block
Enterprise Java
JSyn
RDBMS
CMS
air music
web site
distributed computing
visualisation
real-time synthesis
UML Parsing Analysis
Wiimote
audio engineering
JSF
MOST
Web Ontology Language (OWL)
UML
enterprise architecture
synthesis
JavaServer Faces
graphical user interface
UML Component
Drancing
SysML
Java EE
object-orientation
Shibboleth
mysql
Eclipse Modeling Framework (EMF)
UML1.x
visuals
accelerometer
accelerometer art
Java EE Server
DranceWare
Systems Modeling Language
port-based engineering
SysML Internal Block Diagram
PureData
radioastronomy
graphics editing
neutron beam instrument
particle physics
MD SysML
database
Mac OS X
Content Management System