Search found 181 matches

by luis
Tue Mar 29, 2016 10:27 am
Forum: Bug - problem reporting
Topic: [Cyclos 4.5.3] Account balances not in sync after tx import
Replies: 3
Views: 1458

Re: [Cyclos 4.5.3] Account balances not in sync after tx imp

You can list the accounts which are not negative, but have a negative_since date with the following sql: select a.id, t.name, u.name, a.negative_since from accounts a inner join account_types t on a.account_type_id = t.id left join users u on a.user_id = u.id where balance_diff(a.id) >= 0 and a.nega...
by luis
Mon Mar 23, 2015 5:19 pm
Forum: Cyclos 4 Communities
Topic: Searching the "Keywords" field
Replies: 5
Views: 1589

Re: Searching the "Keywords" field

We don't have an official release date, but we are planning to release 4.4 between April and May.
by luis
Wed Mar 18, 2015 4:13 pm
Forum: Cyclos 4 Communities
Topic: Searching the "Keywords" field
Replies: 5
Views: 1589

Re: Searching the "Keywords" field

Allowing the custom profile fields available in user and ad searches works, but it also creates a problem. These fields now appear in the user search box, underneath the "keywords" search field. This is confusing for our members. We want to have just one search bar showing where people can type in ...
by luis
Mon Mar 16, 2015 10:03 am
Forum: Cyclos 4 Communities
Topic: Searching the "Keywords" field
Replies: 5
Views: 1589

Re: Searching the "Keywords" field

We use PostgreSQL's full text search for the users and ads search, however, with an user friendly query syntax. PostgreSQL's native query syntax requires connectors between words, and is very strict. For example: "car london" is translated to "car | london". The full text process has 2 steps, which ...
by luis
Wed Feb 25, 2015 8:27 am
Forum: Scripting & Webservices issues
Topic: Programmatically perform System -> User payment
Replies: 5
Views: 3956

Re: Programmatically perform System -> User payment

Yes, perfect.
I was writing the code in the forum post, which is not optimal :D
Has already edited the post.
Thanks for your feedback.
by luis
Mon Feb 23, 2015 2:18 pm
Forum: Scripting & Webservices issues
Topic: Programmatically perform System -> User payment
Replies: 5
Views: 3956

Re: Programmatically perform System -> User payment

First, I apologize, as I told you something wrong: it is a forward slash that separates internal names, not dot. So, this should work: def paymentType = entityManagerHandler.find(PaymentTransferType,"systemaccount/fleetvehiclefuelrecord") The other thing I think I didn't made clear is that you need ...
by luis
Wed Feb 11, 2015 9:01 am
Forum: Scripting & Webservices issues
Topic: Programmatically perform System -> User payment
Replies: 5
Views: 3956

Re: Programmatically perform System -> User payment

Scripts run under special condition where the session data still references the logged user, but with unrestricted permissions (it is the admin which writes the script who is responsible for what the script does). However, some methods are still influenced by the logged user. For example, there are ...
by luis
Wed Feb 11, 2015 8:22 am
Forum: Bug - problem reporting
Topic: Captcha image not visible
Replies: 8
Views: 2142

Re: Captcha image not visible

Hi. On this link http://stackoverflow.com/questions/21131855/could-not-initialize-class-sun-awt-x11graphicsenvironment-on-solaris there are some suggestions: Either you are using some java runtime which is not Oracle Java or OpenJDK You can try to pass in the -Djava.awt.headless=true parameter on th...
by luis
Mon Jan 26, 2015 1:05 pm
Forum: Bug - problem reporting
Topic: Error in NotificationService.search method
Replies: 2
Views: 864

Re: Error in NotificationService.search method

This is a bug in a migration from 4.2 or 4.1 to 4.3. That notification has changed, and we didn't correctly migrate the data for it. This will be fixed in 4.3.1. For now, you can remove such old notifications from the database by running the following commands in the database: delete from products_n...
by luis
Fri Jan 23, 2015 6:28 am
Forum: Cyclos 4 Communities
Topic: payment fields in search
Replies: 6
Views: 1877

Re: payment fields in search

Sorry, we were testing with an admin user. Everything works OK. Then i understand with the admin you can see all the filters and with the rest of the users, the permissions are set in the product in "Visible transaction fields". Even for admins there is the option in the permissions tab for visible...
by luis
Wed Jan 21, 2015 8:43 am
Forum: Scripting & Webservices issues
Topic: Paypal intergration script
Replies: 13
Views: 5470

Re: Paypal intergration script

Make sure that you also change the mode parameter in Cyclos script to live instead of sandbox.
If you can't make the script work, an option is to contact Paypal's support.
by luis
Tue Jan 20, 2015 6:25 am
Forum: Scripting & Webservices issues
Topic: Paypal intergration script
Replies: 13
Views: 5470

Re: Paypal intergration script

Does the paypal eligibility permissions have any impact on the script. In my country, I cannot perform direct credit card processing. I think direct credit card processing doesn't affect the hability to perform paypal payments, so the script can be used normally, unless there are some countries whe...
by luis
Wed Dec 10, 2014 7:30 am
Forum: Installation issues
Topic: Percona MySQL cluster suitable for Cyclos?
Replies: 11
Views: 9489

Re: Percona MySQL cluster suitable for Cyclos?

avf wrote:Does cyclos 3.7 have transaction retry?
Only when explicitly locking an account before a payment, when the locking fails.
But in general, no.
by luis
Sun Nov 09, 2014 9:03 pm
Forum: Scripting & Webservices issues
Topic: Webshop Ads Webservice
Replies: 3
Views: 3259

Re: Webshop Ads Webservice

Hi. Unfortunately, it is not an UserVO object which is passed in the parameters for new, but userId instead. You also need the type. Something like (you can omit the parameters array for a single parameter: { "operation": "getDataForNew", "params": { "userId": "<the id here>", "type": "WEB_SHOP" } }...
by luis
Thu Nov 06, 2014 2:46 pm
Forum: Scripting & Webservices issues
Topic: Webshop Ads Webservice
Replies: 3
Views: 3259

Re: Webshop Ads Webservice

Hi. You can use adService.getDataForNew(params), where params contains the ad type ('ADVERTISEMENT' or 'WEB_SHOP') and the owner user id (merchant). This data object will contain the DTO, plus other data you'll need (like categories or custom fields). Then you modify the DTO and pass it back to adSe...