MA4Producteev for BlackBerry

MA4Producteev is the first and the only one mobile application for BlackBerry © smartphones that using the Producteev ©'s API let you manage your tasks and sub-tasks on the go!

There are not other apps for blackberry that support the sub-tasks feature!

MA4Producteev is still in beta version and it's absolutely free! You can install it from AppWorld or scanning this QR Code

Use with caution. I will not answer for any failure or data loss.

Here you can see some screenshots of the app.

Concepts

MA4Producteev is a native WebWorks client that uses the REST API offered by Producteev.com .

So you must have an account on that site to use my app MA4Producteev!

MA4Producteev has been projected and realized by keeping in mind that not all mobile users have flat-rate data plans so the application's cache stores every data step by step: only what you have requested to Producteev.com 's web services and no other stuff.


By default BlackBerry WebWorks SDK for Smartphones 2.3.1 builds applications that can be run on OS5, OS6 and OS7.

This app is not for BlackBerry PlayBook.

What is Producteev?

Producteev is a
simple and versatile task management tools help keep you organized and on the ball. Labels, deadlines, reminders, sub-tasks,
notes and files.

What are sub-task

Sub-tasks is a recent feature that the Productvee.com's Dev Team has implemented.

Thanks to sub-tasks now it's easy to manage large tasks by dividing those into smaller bricks.

Thanks to MA4Producteev now you can use that feature also on your blackberry smartphone while you're on the go and not only through the Producteev.com's site.

Version 1.0.4.7

Great Improvement in this release.

It completes the important improvement that got started with the previous release.

Within this deployment there're new features that have been developed, both layout and usability have been improved and some small issues have been fixed.

First of all, MA4Producteev is now available only for OS6 devices!
That's because I've introduced bbUI.js to make the app to get native BlackBerry look&feel.

Now the list of the new features.
Changelog 1.0.4.7:

New features developed:

• BlackBerry native look&feel;
• Better cache I/O: more efficient and quick;
• Possibility to flag Auto Login;
• Possibility to download and to view task notes's attachment;
• Improved usability and organizzation;
• Improved menu
• Added the Support page
• Some bugs fixed;

In this beta version, all the data cached are always available while the application is running: so don't close it but get it in the background mode.

New releases soon, stay tuned ;)

Bye
MA

MySQL : import-export files CSV

In questo breve articolo mostrerò come poter importare ed esportare files CSV da e verso un database MySQL tramite comandi e sintassi SQL.

Premetto che è possibile svolgere questi task in differenti modi.
In questo post saranno proposti gli script SQL che io preferisco utilizzare.

Al fine di documentare meglio gli esempi, farò riferimento ad una semplice ed ipotetica tabella di nome TABLE_EX composta dalle colonne id(INT), nome(VARCHAR), cognome(VARCHAR).

Import di un file CSV

E' bene ricordarsi di rimuovere dal file CSV la prima riga se questa contiene le intestazioni di colonna.

Di seguito lo script che io utilizzo per importare i record da un file CSV:

LOAD DATA LOCAL INFILE 'c:\path\to\file.csv' INTO TABLE TABLE_EX
FIELDS TERMINATED by ';'
ENCLOSED BY '"'
LINES TERMINATED BY '\n\r';

Mi sembra tutto facilmente intuibile, ad eccezione dell'argomento dell'ultima linea dello script: come potresti aver notato, l'esempio fa riferimento ad un ambiente Windows.

In DOS e Windows, una nuova linea all'interno di un file di testo viene indicata dalla sequenza '\n\r', che dovrebbe simulare le vecchie stampanti che dopo aver aggiunto una nuova riga eseguivano anche il carriage-return.

In un ambiente Linux/UNIX dovrebbe essere sufficiente solo il carattere '\n'.

Export di una tabella MySQL in file CSV

Al termine dell'export il file CSV prodotto non conterrà la riga con le intestazioni di colonna.

SELECT * 

  INTO OUTFILE 'file.csv'
  FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n\r'

FROM  TABLE_EX       
WHERE cognome LIKE 'A%';

Come per l'import, mi pare tutto molto intuitivo e semplice: direi che non c'è bisogno di alcun commento.

Questi due semplici script SQL sono essenziali a mio avviso, spero possano tornare utili.

Alla prossima,
MA.