maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   MeeGo / Harmattan (https://talk.maemo.org/forumdisplay.php?f=45)
-   -   [Announce] EasyList for N9/N950 (https://talk.maemo.org/showthread.php?t=75894)

Willem Liu 2011-12-13 11:02

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by aegis (Post 1136958)
Willem,

Well done on EasyList/EasyNote.

Is it possible to run our own EasyList web service? ie. is the code running on http://easylist.willemliu.nl/ open and available to run on our own servers?

Some people may not want their lists on someone else's server and possible also someone might want to write a desktop/symbian/iOS/Android version of EasyNote/EasyList that worked with the same service protocol.

The web code is not publically available. But that's because there is not much to see there. EasyList virtually isn't using any protocol to retrieve the online list. It polls the getList with a username and hashed password as URL parameters. The webservice returns plain text if validation is correct.

There might be a protocol in the future, but that comes with multiple list synchronization. It will take a while till that comes into the picture though.

Willem Liu 2012-01-19 20:39

Re: [Announce] EasyList for N9/N950
 
EasyList PHP website:
The PHP code is now attached in the zip file to the OP. The ZIP file includes all the PHP files and a SQL file which creates two empty tables: lists and users.

DarkSkies 2012-01-25 00:44

Re: [Announce] EasyList for N9/N950
 
Excellent project, thanks!

Willem Liu 2012-01-26 07:56

Re: [Announce] EasyList for N9/N950
 
easylist (0.0.23) unstable; urgency=low

* Fixed Settings view height. Save button would not fit on screen.
* Added Terminal theme. Black background for battery saving.
* Added multiple online list support.

It will be available in Ovi Store soon. When it's available in Ovi Store I'll also update the http://easylist.willemliu.nl website to enable the multilist support.

For now you can download it from the project website.

Willem Liu 2012-01-28 11:23

Re: [Announce] EasyList for N9/N950
 
The new EasyList is now available in Ovi Store. I've now also updated the EasyList website to support multiple list management.
The new EasyList app can now sync with all the lists you've created online.

When you sync your lists it will only do that once until the online list changes again or when you've deleted the offline list which also exists online. Also it will only overwrite the same named list.

I haven't changed the prompt messages yet, because I didn't have the proper translations for all languages yet.

I want to ask the community for help on translating the following lines into the following languages: French, German and Russian.

======
Do you really want sync your current lists with the online lists?

Your lists will be overwritten if:
- The list is never synced before.
- Only lists with the same name are synced.
- The online list has changed since the last sync.
======

======
When you've setup your synchronization account then you'll be able to
synchronize your lists with your online lists.

You can create your online account on http://easylist.willemliu.nl.
Default sync URL is: http://easylist.willemliu.nl/getList.php
======

Many thanks!

Willem Liu 2012-01-29 09:44

Re: [Announce] EasyList for N9/N950
 
I've received the German translation. Now I just need the French and Russian ones. I'd be grateful if you can help me translate the following lines.

======
Do you really want sync your current lists with the online lists?

Your lists will be overwritten if:
- The list is never synced before.
- Only lists with the same name are synced.
- The online list has changed since the last sync.
======

======
When you've setup your synchronization account then you'll be able to
synchronize your lists with your online lists.

You can create your online account on http://easylist.willemliu.nl.
Default sync URL is: http://easylist.willemliu.nl/getList.php
======

Many thanks!

Willem Liu 2012-01-29 09:45

Re: [Announce] EasyList for N9/N950
 
I've received the German translation. Now I just need the French and Russian ones. I'd be grateful if you can help me translate the following lines.

======
Do you really want sync your current lists with the online lists?

Your lists will be overwritten if:
- The list is never synced before.
- Only lists with the same name are synced.
- The online list has changed since the last sync.
======

======
When you've setup your synchronization account then you'll be able to
synchronize your lists with your online lists.

You can create your online account on http://easylist.willemliu.nl.
Default sync URL is: http://easylist.willemliu.nl/getList.php
======

Many thanks!

Willem Liu 2012-01-29 20:39

Re: [Announce] EasyList for N9/N950
 
Only the Russian language translation of the sentences needed now.

======
Do you really want sync your current lists with the online lists?

Your lists will be overwritten if:
- The list is never synced before.
- Only lists with the same name are synced.
- The online list has changed since the last sync.
======

======
When you've setup your synchronization account then you'll be able to
synchronize your lists with your online lists.

You can create your online account on http://easylist.willemliu.nl.
Default sync URL is: http://easylist.willemliu.nl/getList.php
======

Many thanks!

Willem Liu 2012-02-02 22:01

Re: [Announce] EasyList for N9/N950
 
EasyList 0.0.25.

Just a few minor changes.
* Changed a prompt message for synchronisation.
* Changed a help message in Settings view.

The messages are new for all supported languages except Russian. As there was no one who could translate it for me.

You can download it from the project page or wait for it to arrive in Ovi store.

Willem Liu 2012-02-06 21:02

Re: [Announce] EasyList for N9/N950
 
EasyList 0.0.26.

* Added Swedish translation. Thanks to Jan-Eric Lindh.
* Position when checking or deleting items is now fixed and will no longer scroll to top of list.

You can download it from the project page or wait for it to arrive in Ovi store.

Willem Liu 2012-02-24 15:30

Re: [Announce] EasyList for N9/N950
 
Already more than 300 accounts are activated on http://easylist.willemliu.nl.

This means that more than 300 users are able to sync with their online shopping/todo lists.

Thanks everyone for using my app.

itsnotabigtruck 2012-04-25 03:24

Re: [Announce] EasyList for N9/N950
 
Given that EasyList is open source, have you looked into uploading it to Apps for MeeGo? It's in need of polished apps such as this one.

Willem Liu 2012-04-26 09:18

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by itsnotabigtruck (Post 1197303)
Given that EasyList is open source, have you looked into uploading it to Apps for MeeGo? It's in need of polished apps such as this one.

Hi,

Thanks for the tip. I might give it a try. I hope it's not too complicated to get an app build by the automated builder.
One question though, what is the purpose of apps for meego?

Regards,

Willem Liu

Willem Liu 2012-04-26 14:59

Re: [Announce] EasyList for N9/N950
 
EasyList has been downloaded over 10k times from the Nokia Store.
http://easylist.willemliu.nl has over 400 activated accounts now.

Thanks for the support!

itsnotabigtruck 2012-04-26 16:20

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by Willem Liu (Post 1197809)
Hi,

Thanks for the tip. I might give it a try. I hope it's not too complicated to get an app build by the automated builder.
One question though, what is the purpose of apps for meego?

Regards,

Willem Liu

It's an alternative app store for open source apps - something sort of like extras, but for Harmattan.

In order to get started, sign up for a meego.com account, then get on IRC (Freenode #meego or #harmattan) and pester lbt or X-Fade to enable your account for Community OBS. Make sure you follow the packaging guidelines, then build a Debian source package out of your project and upload it to your OBS "home project". Once that's done, you can then submit into Apps for MeeGo. (If that sounded really complicated, it isn't actually all that bad)

The tricky part is building the source package, which Qt Creator won't do for you. :( phako wrote this script, which might be a good starting point - run it from a clean source tree and it should produce the needed package.

ajalkane 2012-04-28 20:44

Re: [Announce] EasyList for N9/N950
 
I have one request... this thing drives me occasionally crazy with rage. If I have commas (',') in the item, EasyList creates separate entries for all the comma separated strings. I'd want to be able to create, for example TODOs, which have commas.

I know this comma separation is a user requested feature, but I think it's annoying. How hard can it be to hit enter to separate the entries? Is it possible to put this into settings so that comma separation is optional?

nichael 2012-05-05 01:08

Re: [Announce] EasyList for N9/N950
 
I really like this app. Would be great if there were possibly an easier way to re-order list items (without needing to cut-and-paste in the edit view).

munozferna 2012-05-05 01:34

Re: [Announce] EasyList for N9/N950
 
This could be vulnerable to SQL injection (it depends on server settings):

Code:

if(isset($_GET['delete_id']))
  {
    DBConnect();
    $query = "DELETE FROM users WHERE id='" . $_GET['delete_id'] .
    "' AND username='" . $_GET['username'] .
    "' AND password='" . $_GET['password'] .
    "' AND email='" . $_GET['email'] .
    "'";
    DBQuery($query);
    $alertMsg .= "Account deleted.";
    DBDisconnect();
  }


Willem Liu 2012-05-05 07:32

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by munozferna (Post 1202080)
This could be vulnerable to SQL injection (it depends on server settings):

Code:

if(isset($_GET['delete_id']))
  {
    DBConnect();
    $query = "DELETE FROM users WHERE id='" . $_GET['delete_id'] .
    "' AND username='" . $_GET['username'] .
    "' AND password='" . $_GET['password'] .
    "' AND email='" . $_GET['email'] .
    "'";
    DBQuery($query);
    $alertMsg .= "Account deleted.";
    DBDisconnect();
  }


You are right. I'll try to fix this asap.

Willem Liu 2012-05-07 18:15

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by nichael (Post 1202074)
I really like this app. Would be great if there were possibly an easier way to re-order list items (without needing to cut-and-paste in the edit view).

Hi nichael,

Although it's a nice feature to have. I don't know how to implement it. And my constant lack of time prevents me to research the possibility.
I'll leave this to other skilled developers out there who want to add this feature.

Regards,

Willem Liu

judhaz 2012-06-08 17:03

Re: [Announce] EasyList for N9/N950
 
I am very happy with this app, and am trying to install the database on my own server to do syncing there. I have downloaded the files given in the zip file in the first post, and have php and mysql running on my server.

On my first try, I got the following error when accessing index.php:
Code:

PHP Parse error:  syntax error, unexpected '<' in /var/www/easylist/dbconnection.php on line 2
I guess I need to do some slight modifications to the .php files, like changing these lines:
Code:

        $_SESSION['dbUsername'] = <USERNAME>;
        $_SESSION['dbPassword'] = <PASSWORD>;

Do you have a simple step-by-step guide to what I need to do?

PS: Where can I donate to you?

ajalkane 2012-06-08 17:14

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by judhaz (Post 1219563)
I guess I need to do some slight modifications to the .php files, like changing these lines:
Code:

        $_SESSION['dbUsername'] = <USERNAME>;
        $_SESSION['dbPassword'] = <PASSWORD>;

Do you have a simple step-by-step guide to what I need to do?

Put there the username and password of the database you use for EasyList:

Code:

        $_SESSION['dbUsername'] = 'judhaz';
        $_SESSION['dbPassword'] = 'easilyguessablepassword';


judhaz 2012-06-08 18:14

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by ajalkane (Post 1219565)
Put there the username and password of the database you use for EasyList:

I think these entries are more like username and password for the mysql database, not easylist passwords.

I guess I need to create a mysql database and grant access for a username with password and put in those values. I'll send an update if I succeed.

ajalkane 2012-06-08 18:38

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by judhaz (Post 1219585)
I think these entries are more like username and password for the mysql database, not easylist passwords.

I guess I need to create a mysql database and grant access for a username with password and put in those values. I'll send an update if I succeed.

Umm... I think that's exactly what I said.

I'm sorry if I wrote it unclearly.

judhaz 2012-06-08 23:07

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by ajalkane (Post 1219594)
Umm... I think that's exactly what I said.

I'm sorry if I wrote it unclearly.

Indeed, it was me that misread it - sorry! :o

Anyway, this is what I've done so far:
- Recover my root password for mysql
- Create a new database for easylist:
Code:

# mysql -u root -p
    create database easylistdb;
    create user 'easylist'@'%' identified by 'easylist';
    create user 'easylist'@'localhost' identified by 'easylist';
    set password for 'easylist'@'%' = password('easylist');
    set password for 'easylist'@'localhost' = password('easylist');
    connect easylistdb;
    grant all privileges on *.* to 'easylist'@'%' with grant option;
    grant all privileges on *.* to 'easylist'@'localhost' with grant option;
    flush privileges;
    exit;

- Create tables for easylist ('willemliu_ezlist.sql' was included in the .zip file, outside the easylist/ directory):
Code:

# mysql -u root -p
mysql> connect easylistdb;
mysql> source /tmp/willemliu_ezlist.sql;

- Successfully sign up and log in, create a persistent list from the web interface.

PROBLEM: I have setup up my server to do https only (http will be redirected to https) with authentication, and the app itself doesn't seem to cope with this. Is this a "missing feature" or should it in fact work? (I am am able to authenticate and log in using the web app of my Nokia N9).

judhaz 2012-06-09 08:20

Re: [Announce] EasyList for N9/N950
 
I have now disabled https on my server and do pure http. Still, it doesn't work when I try to "sync" from the app.

I can see in the server log that my phone is accessing
Code:

/easylist/getList.php?username=USERNAME&password=SOMEHASH&xml=v2
but I get a message saying "Can't synchronize. Unable to synchronize with online list. Please make sure you've correctly setup your sync account in settings."

If I paste that very same adress into my browser, I do get the list as XML in return.

Maybe there is something I don't quite understand with "syncing" with the online list. What will be the name of this list? I have created a list called "Test" in the app, and try to sync from within that list. On the web interface I have created a few items, but don't really know the name of that list.

Also, I understand that it is not really synchronization, but rather overwriting with wichever list is the freshest, right?

Willem Liu 2012-06-09 11:23

Re: [Announce] EasyList for N9/N950
 
I have never tested with HTTPS myself so I don't know if the QML HTTP connection supports HTTPS or not.

Anyway I've updated the easylist.zip with the latest PHP files. You can download it from the first post now. Those files are now exactly the same as the ones I use on http://easylist.willemliu.nl.

The error you get might be that the latest N9 EasyList doesn't work correctly with the older webservice.

You are correct that the "syncing" isn't really a sync. It downloads the list if that list is newer and ignores it if it's not.

Willem Liu 2012-06-09 11:26

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by judhaz (Post 1219791)
If I paste that very same adress into my browser, I do get the list as XML in return.

This means that the webservice is working correctly and the problem probably lies in the communication between EasyList app and the webservice. It could be a change in the protocol causing an error.
Download the latest easylist.zip from the first post and try those files. Don't forget to edit dbconnection.php again with your username, password and database name.

Willem Liu 2012-06-09 11:28

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by judhaz (Post 1219791)
Maybe there is something I don't quite understand with "syncing" with the online list. What will be the name of this list? I have created a list called "Test" in the app, and try to sync from within that list. On the web interface I have created a few items, but don't really know the name of that list.

You are not required to create any list in the app. If you create the list on the website then those lists will be downloaded to the app.

Do mind that the username and password in the app is not the database username and password but rather the account username and password which you've created on the list webservice.

judhaz 2012-06-09 16:57

Re: [Announce] EasyList for N9/N950
 
Thanks for updating the zip file!

I see that the web interface has changed, and it seems it supports a dropdown list of available lists. However, the dropdown is always empty for me, even though I seemingly manage to create a new list in the web interface, as I get "List test4 saved." when I press the Save button.

However, when I check the mysql database, the list is not saved.

I have updated dbconnection.php with the mysql username and password and database name.

I use lighttpd, and have noticed the following errors/warnings after updating the .php files:
Code:

2012-06-09 18:28:03: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Notice:  Undefined index: username in /var/www/easylist/loginFunctions.php
 on line 19
PHP Notice:  Undefined index: password in /var/www/easylist/loginFunctions.php on line 20

and

Code:

2012-06-09 18:24:17: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/easylist/listFunctions.php on line 40
PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/easylist/index.php on line 88

which is a bit strange, 'cause the syntax seems correct.

Any suggestions on how to proceed on this highly appreciated!

Willem Liu 2012-06-09 17:00

Re: [Announce] EasyList for N9/N950
 
As I'm currently watching football I can't help you right now.

wout.martens 2012-06-09 21:24

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by Willem Liu (Post 1219950)
As I'm currently watching football I can't help you right now.

better luck next time :) (football)

Willem Liu 2012-06-12 18:25

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by judhaz (Post 1219948)
Thanks for updating the zip file!

I see that the web interface has changed, and it seems it supports a dropdown list of available lists. However, the dropdown is always empty for me, even though I seemingly manage to create a new list in the web interface, as I get "List test4 saved." when I press the Save button.

However, when I check the mysql database, the list is not saved.

I have updated dbconnection.php with the mysql username and password and database name.

I use lighttpd, and have noticed the following errors/warnings after updating the .php files:
Code:

2012-06-09 18:28:03: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Notice:  Undefined index: username in /var/www/easylist/loginFunctions.php
 on line 19
PHP Notice:  Undefined index: password in /var/www/easylist/loginFunctions.php on line 20

and

Code:

2012-06-09 18:24:17: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/easylist/listFunctions.php on line 40
PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/easylist/index.php on line 88

which is a bit strange, 'cause the syntax seems correct.

Any suggestions on how to proceed on this highly appreciated!

You could ignore the NOTICES, but they may cause problems if it's indeed not possible to set the session variables.
I suggest you test if the session variables are being set, properly by logging the values.

I've looked at the SQL file in the zip file in the first post and noticed there was a column missing when compared to my active database. I've now updated that file as well. I hope that fixes the errors. And if it does I apologize for the inconvenience I've caused.

skyleth 2012-06-12 21:25

Re: [Announce] EasyList for N9/N950
 
could you add the option to sync with google tasks?

Willem Liu 2012-06-12 21:52

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by skyleth (Post 1221090)
could you add the option to sync with google tasks?

I'm sorry but that's not within the scope of this app.

Schturman 2012-06-13 07:36

Re: [Announce] EasyList for N9/N950
 
2 Attachment(s)
Hi I translated your app to hebrew...
Please, can you create for me the tested version with my files, I want to check if this work correctly (it should be viewable from right to left).
Thanks

P.S. remove ".txt" extension...

scoobertron 2012-06-13 08:01

Re: [Announce] EasyList for N9/N950
 
Hi, thanks for this great app. I just wanted to feed back a couple of things.

When I create a new list and am prompted to input the list name, the text field contains (I think) the last active list name. This is highlighted, but the keyboard doesn't appear, meaning that you need to tap the input field to focus it, then highlight the name, then add the new list name. It would be better if we could just start typing the new list name.

Also, this might just be my use case, usually when I create a new list, the first thing I want to do is put things in it, so it would be useful if we were taken to the view where we input items, rather than back to the 'all lists' when we create a new list. At the moment, after adding a new list, we have to select it, and then click the input button before we can start typing.

Also, it would be nice to be able to have the option of being taken to the 'lists' view (rather than a particular list) when you open the app. Or to be able to choose a list to be the default one that opens. I have a 'current tasks' list which I would always prefer to see first, rather than the most recent list.

Willem Liu 2012-06-13 08:49

Re: [Announce] EasyList for N9/N950
 
Quote:

Originally Posted by scoobertron (Post 1221215)
Hi, thanks for this great app. I just wanted to feed back a couple of things.

When I create a new list and am prompted to input the list name, the text field contains (I think) the last active list name. This is highlighted, but the keyboard doesn't appear, meaning that you need to tap the input field to focus it, then highlight the name, then add the new list name. It would be better if we could just start typing the new list name.

This has always been my intention, but back then I was unable to realise this. I've forcefully set the keyboard focus in the textfield, but still the keyboard will not open. I'll look into this again when I have the time. Maybe I can find a solution.

Quote:

Originally Posted by scoobertron (Post 1221215)
Also, this might just be my use case, usually when I create a new list, the first thing I want to do is put things in it, so it would be useful if we were taken to the view where we input items, rather than back to the 'all lists' when we create a new list. At the moment, after adding a new list, we have to select it, and then click the input button before we can start typing.

Although it sounds very nice to have the app do all that for you. It would make the interaction quite a bit hard to follow. If after creating a new list you'd be presented with the edit list screen then after a minute of editing and you save the list you'd pop back to the Lists view which wasn't the last view you've visited, because that would be the create new list view. But returning the user back to the create new list view would also be weird.
Returning the user to the list items view might work, but then the user would be going from Lists->new list->edit list->list items view.
Which to me is a bit confusing.
Maybe in the end it would prove a better user experience, but for me personally I'd rather think for myself and decide for myself where I'm in the app rather than having the app decide all that for me. And as the most important end-user, which I consider myself ;), I'd rather stick to the current app flow.

Quote:

Originally Posted by scoobertron (Post 1221215)
Also, it would be nice to be able to have the option of being taken to the 'lists' view (rather than a particular list) when you open the app. Or to be able to choose a list to be the default one that opens. I have a 'current tasks' list which I would always prefer to see first, rather than the most recent list.

Setting a default list is indeed a nice feature to have and I'll consider adding this functionality.
However I'm not a fan of the open default view function. For instance: lets say you've selected the Lists view then what should the Back button do?

Willem Liu 2012-06-15 13:45

Re: [Announce] EasyList for N9/N950
 
1 Attachment(s)
@Schturman

Here is the EasyList app with Hebrew translation added. Can you test if it works correctly?

Let me know.

@everyone else. Don't install this version as it only has the Hebrew language added and nothing else.
When I've added the features I want I'll release the proper 0.0.29 version.

Schturman 2012-06-15 20:13

Re: [Announce] EasyList for N9/N950
 
3 Attachment(s)
Quote:

Originally Posted by Willem Liu (Post 1222282)
@Schturman

Here is the EasyList app with Hebrew translation added. Can you test if it works correctly?

Let me know.

@everyone else. Don't install this version as it only has the Hebrew language added and nothing else.
When I've added the features I want I'll release the proper 0.0.29 version.

Thank you..
I checked, the translation is ok, but have some problems:
1. See this pics, some stuff should be on the right side (maybe I need to adding something in this .ts file ? something like "right to left", but where and how I don't know) ?
2. When I installed new version the synchronization is stopped to work. I tried to reinstall back to 0.0.28, but synchronization is still not working...
3. when I reinsalled all my settings is here, also when I uninstalled and reinstalled again. Where this files saved in the phone ?
4. Also, maybe you now a trick, that I can stay on english system UI, but using hebrew EasyList UI ? I tried rename the qml-translations.he.qm and qml-translations.he.ts to qml-translations.en.qm and qml-translations.en.ts , but it's not change anything...

Thanks for help and your useful app.


All times are GMT. The time now is 08:10.

vBulletin® Version 3.8.8