blog.Dokuments.com - web apps, databases & reports made easy

Netbeans PHP IDE

I just started using NetBeans today for PHP development, and really like it.
I've got my codebase saved in a DropBox folder, which allows me to switch between Windows and OSX and keep things in sync.

Comments [0]

matrix/grid feature

Creating a grid, or matrix, in DOKUMENTS is simple.
For instance, here is some example FDL (Form Definition Language) code to create a 3-question survey: 

blank | blank | Employee Satisfaction 

blank | blank | Please rate each item
emp_sat | matrix | | yes | Poor,, Acceptable,, Excellent | horizontal | all | left | show
conditions | submatrix | Working Conditions | yes | radio
pay | submatrix | Pay | yes | radio
job_sat | submatrix | Job Satisfaction | yes | radio
endmatrix | endmatrix | end


which will produce the following form:

Comments [0]

shift/grow (parent/child relationships)

One of the coolest things about DOKUMENTS is the shift/grow feature.
Here is what it does:
- if you shift the code with a tab (as shown below), that section of your app can "grow" as needed.

For instance, if you wanted to create a form and allow someone to upload one or more files, you could either give them a static number of upload fields (1, 2, 3, 4, etc...), or you could use shift/grow and then they could upload 1 or more files; you don't need to predict how many they'll need to use.

Here is a sample of the code:
--------

customer_name | text | Your Name | yes | 15 | 255 | hide 
blank | Please upload any files that may help us understand your problem.

	Attachments | group_label
	attachment | upload | Attachment | no | 1200 | 1200 | 1200

comments | textarea | Comments | no | hide

--------

So, this would enable the end-user to upload one or more files.
This is useful anytime you have a part of your form that needs to be able to grow dynamically.

Please let us know if you have any questions or suggestions!

 

 

Comments [0]

Going Paperless > scanner and shredder

One of my friends recently asked for advice on going paperless, so I thought I'd share the techniques and tools that I've been using for the past few years.

I try to scan all of the paper I get (receipts, mail, etc...) and convert it to a searchable PDF using the Fujitsu ScanSnap S510M:
http://www.amazon.com/ScanSnap-S510M-Instant-Sheet-Fed-Scanner/dp/B000WJCX18/... 
I think I bought it in 2007, and have been very pleased with it.

Once I've scanned it, I shred it using this shredder:
http://www.amazon.com/Fellowes-32057-Powershred-P-57Cs-Shredder/dp/B000I8ZULI...
The nice thing about it is that it automatically shuts off when it detects a hand/fingers, which is especially nice because we have little kids in the house.

Soon DOKUMENTS will have a desktop app that will automatically upload files (like scanned documents) to your DOKUMENTS account, making it easy to organize and share them.

If you've got any tips or suggestions, please let me know!

Comments [0]

New Search Engine > DuckDuckGo.com

I started using http://duckduckgo.com/ as my default search engine this week, and have been very pleased thus far.
One of the reasons I started using it is that they don't store your IP address.  Ixquick.com is the only other search engine that I know of that does this, and I've used them also.  

I like giving the underdog a chance, and this is a one-man operation competing against Google, and he's doing a great job. 

Give it a try!

Comments [1]

Spreadsheets

I set out a few days ago to add spreadsheet functionality to DOKUMENTS, and am excited to say that it's here!  It doesn't yet have math functionality, but is great for quick data entry and does have the =now() function, which will insert the timestamp for you.

This is a really exciting development for the system, because soon you'll be able to create a new spreadsheet, and then say "convert to app", and it will build that into a web app for you.  How cool is that!

You can have anonymously editable spreadsheets, or you can set them to be view-only if the end-user is not logged-in, or you can block anonymous access completely.

I'll be adding more functionality to this feature in the coming days, but just wanted to mention that it's out there and free to use for anyone who wants to try it.  Just signup for a free account, and click on the "Doks" tab.

Comments [0]

Webmail

Another day brings another exciting feature; you can now send and receive email from DOKUMENTS.  I'll post some tips on how I got Postfix to pipe incoming emails to a php script soon.

 

Comments [0]

Custom domain names

I am excited to announce that we can finally accommodate custom domain names.  This means that you can point your domain name instead of your DOKUMENTS subdomain (for paid plans only).  For instance, we are able to point one of our domain names (autowebsys.com) to DOKUMENTS.com, and are able to use that instead of the subdomain (my.dokuments.com).

Comments [0]

GetClicky stats

I started using GetClicky web analytics today, and am really impressed thus far.

Comments [0]

InnoDB backups with Xtrabackup

I am excited to have setup and implemented Percona's Xtrabackup system to backup the InnoDB tables.  I currently only have a master database, but will soon setup a slave and then run the backups from that every hour or so. 

It took me awhile to figure out how to run the backups as a (root) cron job; adding the "PATH" to the cron job fixed the problem I was having.

Here is what I eventually used:

01 4 * * * PATH=/usr/local/bin:/bin:/usr/bin:/sbin:/usr/sbin /path/to/xtrabackup-1.0/bin/innobackupex-1.5.1 /mysql_backups/ -user=myusernamehere -password=mypasswordhere >> /home/myhomefolder/innobackupex.log 2>&1

This tells the system to run this backup at 4:01AM every day, and instead of sending the results via email, it stores them in a log file.

 

 

Filed under  //   backups   database   mysql  

Comments [0]



Clicky