[web2py] Re: I need a double entry accounting software ....

I have CRM background, very interested in ERPLibre especially using web2py. Thanks for sharing On Saturday, February 23, 2013 5:24:51 PM UTC-5, Massimo Di Pierro wrote: > > I had not seen this before. ERPLibre is impressive! > > Massimo > > On Saturday, 23 February 2013 12:58:35 UTC-6, Alan Etkin

[web2py] Re: New kid on the block web2py running on Action.io

This was a problem with my DNS never mind. On Saturday, 23 February 2013 14:52:37 UTC-6, Massimo Di Pierro wrote: > > I get: > > This webpage is not available > The webpage at *https://www.youtube.com/embed/7X6IvkgkC7k?hd=1* might be > temporarily down or it may have moved permanently to a ne

Re: [web2py] Re: New kid on the block web2py running on Action.io

Try it http://www.action.io 2013/2/23 Massimo Di Pierro > I get: > > This webpage is not available > The webpage at *https://www.youtube.com/embed/7X6IvkgkC7k?hd=1* might be > temporarily down or it may have moved permanently to a new web address. > Error 501 (net::ERR_INSECURE_RESPONSE): Unknow

[web2py] Re: I need a double entry accounting software ....

I had not seen this before. ERPLibre is impressive! Massimo On Saturday, 23 February 2013 12:58:35 UTC-6, Alan Etkin wrote: > > I cannot load the page. If you have other links to docs about how ERP >> works I could use them. > > > Mind that ERPlibre is still a work-in-progress. A working first

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

I changed the order as you suggested and no longer get this error: 'DAL' object has no attribute 'DictionaryType' thanks for that tip But the error below sill exists () takes exactly 2 arguments (1 given) thanks, Alex On Saturday, February 23, 2013 1:18:20 PM UTC-8, Jim S wrote: > > Does

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

Does it occur after the definition of db.DictionaryType in your model file? Sorry for the dumb questions, just going over mistakes I've made in the past... -Jim On Sat, Feb 23, 2013 at 2:09 PM, Alex Glaros wrote: > db.define_table('Word', > Field('wordName','string'), > Field ('definition', '

Re: [web2py] Re: Scheduler: new plugin cs_plugin_monitor

Not until beta at least... Graphs need a better look :-P -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more opti

Re: [web2py] Re: Error db._adapter

This is causing the problem. What if you remove the try... except? What ticket do you get? try: raw_rows = db.executesql('CALL sp_recursive_start(1);', fields=fields) except Exception, e: print 'ERROR NOW:', e db.rollback() On Saturday, 23 February 2013 12:58:4

[web2py] Re: New kid on the block web2py running on Action.io

I get: This webpage is not available The webpage at *https://www.youtube.com/embed/7X6IvkgkC7k?hd=1* might be temporarily down or it may have moved permanently to a new web address. Error 501 (net::ERR_INSECURE_RESPONSE): Unknown error. On Saturday, 23 February 2013 12:53:06 UTC-6, Ramos wrote:

[web2py] Re: Scheduler: new plugin cs_plugin_monitor

no screenshots? ;-) On Saturday, 23 February 2013 12:11:19 UTC-6, Niphlod wrote: > > Hi all, >here there's the first > implementation of a monitoring plugin for the embedded scheduler. > Shouldn't break anything but at least for the moment do no

[web2py] Re: ask about database and requires

a, i understand right now, thank you so much for your explaination and the test example niphlod. While update()ing fields are translated to column names, so you don't have > to fetch the record just to increment it. > > >>>db.define_table('myupdates', Field('quantity', 'integer')) > >>>db(db.my

[web2py] Re: ask about database and requires

> > Is it possible you already have duplicate data in that column (e.g., > perhaps multiple empty strings)? What happens if you start with a fresh > application and database? > thank you so much for your detail explaination, anthony, no duplicate data or multiple empty strings in that column,

[web2py] Re: ask about database and requires

yes, right now, after i realize my mistake 1. notnull=True is not work without requires=IS_NOT_EMPTY() i put requires, to validate user input in web form. 2. length is not work without requires=IS_LENGTH() i by pass it, because when i test the actual length of uuid is 47, and sometimes more than

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

db.define_table('Word', Field('wordName','string'), Field ('definition', 'string'), Field('languageID','reference HumanLanguage'), Field('dictionaryTypeID',*db.DictionaryType*), Field('wordReferenceModelID','reference WordReferenceModel'), Field('comments','string'), auth.signature) On Sat, Feb 23

[web2py] Re: ask about database and requires

thank you for your suggestion anthony, i've already tested it, both db( db.product.id==key).update(quantity=db.product.quantity - value) and db(db.product.id==key).update(quantity=db.product(key).quantity - value) is work well during update the quantity in product table. db(db.produc

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

Can you paste the table definition that choked on you? -Jim On Sat, Feb 23, 2013 at 1:34 PM, Alex Glaros wrote: > web2py doesn't seem to accept that format on my windows version. I get > > 'DAL' object has no attribute > 'DictionaryType' > The error below doesn't come up when there is no dat

[web2py] Re: I need a double entry accounting software ....

> I cannot load the page. If you have other links to docs about how ERP > works I could use them. > I have some basic questions I am trying to answer for example: > did you mean https://www.erpag.com/? please follow the tutorial in youtube : https://www.youtube.com/channel/UCjk9S6IyOMuYsBQXN

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

web2py doesn't seem to accept that format on my windows version. I get 'DAL' object has no attribute 'DictionaryType' The error below doesn't come up when there is no data: * () takes exactly 2 arguments (1 given)* The represent attribute works if there are two files in play instead of three

Re: [web2py] Re: Error db._adapter

After reading this thread, as Anthony suggested, I tried this: import MySQLdb from gluon.dal import MySQLAdapter MySQLAdapter.driver = MySQLdb After that, even commenting this block of code I get the result correctly because the print rows, but

[web2py] Re: I need a double entry accounting software ....

> > I cannot load the page. If you have other links to docs about how ERP > works I could use them. Mind that ERPlibre is still a work-in-progress. A working first alpha implementation is although available for download at http://code.google.com/p/erplibre/downloads/list It ships with web2py

[web2py] New kid on the block web2py running on Action.io

Hello guys i have web2py running on action.io check this link they gave me to share. https://www.action.io/?ref=QHso-NciEdY

[web2py] Re: Scheduler: help us test it while learning

resuming historic thread. Latest commits added a few features, and changed schemas a little (my fault, sorry). Now db schema complies with check_reserved=['all'], so should work in any RDBMS out there: - scheduler_run.output --> scheduler_run.run_output - scheduler_run.result --> scheduler_run.ru

[web2py] Scheduler: new plugin cs_plugin_monitor

Hi all, here there's the first implementation of a monitoring plugin for the embedded scheduler. Shouldn't break anything but at least for the moment do not use in production, it's in alpha stage. Please test it and report back bugs or new ideas

[web2py] Re: ask about database and requires

Good point. On Saturday, February 23, 2013 12:48:04 PM UTC-5, Niphlod wrote: > > While update()ing fields are translated to column names, so you don't have > to fetch the record just to increment it. > > >>>db.define_table('myupdates', Field('quantity', 'integer')) > >>>db(db.myupdates.id == 1)._

[web2py] Re: ask about database and requires

While update()ing fields are translated to column names, so you don't have to fetch the record just to increment it. >>>db.define_table('myupdates', Field('quantity', 'integer')) >>>db(db.myupdates.id == 1)._update(quantity=db.myupdates.quantity + 1) 'UPDATE myupda SET quantity=(myupda.quantity +

[web2py] Re: web2py under GAE: disabling indexes

Scott, this is *completely* untested, but here's a proposal: - use the (undocumented) field.custom_qualifier property in GAE field definitions - if you want a field to be unindexed set custom_qualifier={'indexed':False} - for "properties that don't get listed explicitly"override those de

Re: [web2py] Re: Error db._adapter

Please... What i have to close after db.executesql() ??? If I try do it: print len(db(db.auth_user).select(limitby=(0,1))) In: def users_test(): try: raw_rows = db.executesql('CALL sp_recursive_start(1);') except Exception, e: db.rollback() raise e fields

Re: [web2py] Re: Error db._adapter

I commented the use of _adapter.parser, and the error no longer occurs, but the data of db.executesql('CALL sp_recursive_start(1);') bring nothing every other refresh. On Sat, Feb 23, 2013 at 1:36 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Ok... I removed every try/except

[web2py] Re: Form.process().accepted stops form (web2py + jquery mobile)???

OPS. thanks Il giorno sabato 23 febbraio 2013 16:43:17 UTC+1, Massimo Di Pierro ha scritto: > > You are doing it twice. The same call always fails. > >if request.args(0)>0: > ... > else: > form=SQLFORM(db.Nominativi).*process*() > > if form.*process*(

Re: [web2py] Re: Error db._adapter

Ok... I removed every try/except of my code to see the error logged by web2py. https://gist.github.com/pysI'm begginer in web2py...lan/5007364 The error occur every other refresh... 'NoneType' object is not iterable ... in this line: if db(db.auth_user

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

Just to be clear, he isn't asking just to remove quotes, but to specify your reference columns as: db.table_name instead of 'reference table_name' -Jim On Friday, February 22, 2013 7:14:18 PM UTC-6, Alex Glaros wrote: > > thanks for giving it a shot but depending upon whether I use quotes or

[web2py] Re: ask about database and requires

> > db(db.product.id==key).update(quantity=db.product.quantity - > value) Here you probably want: db(db.product.id==key).update(quantity=db.product(key).quantity - value) db.product.quantity is a Field object, but you want to get the value of that field for the particular rec

[web2py] Re: ajax choking on text - need help

web2py source starts with # -*- coding: utf-8 -*- Text being read from file was written encode('utf-8') so read().decode('utf-8') produces the unicode. Forcing it unicode() again doesn't change anything. But, thanks for the suggestions! Any other ideas? On Saturday, February 23, 2013 10:20:38

[web2py] Re: ask about database and requires

> 1. notnull=True is not work without requires=IS_NOT_EMPTY() > during my testing is on field note, i define notnull=True on field note, > but i forgot to define the requires, yet the data still can be insert > without note=null > If you leave the "note" text field empty, I think it will inser

Re: [web2py] Re: Error db._adapter

Moreover because the true cause of the problem is in a try/except the actual error is not logged by web2py. On Saturday, 23 February 2013 09:46:22 UTC-6, Massimo Di Pierro wrote: > > Have you removed the db statements inside tryexcept...? That's the > cause of the problem. if a db command fa

Re: [web2py] Re: Error db._adapter

Have you removed the db statements inside tryexcept...? That's the cause of the problem. if a db command fails, the db may close connection and your driver raises an exception. Your code catches the exception and pretends to continue execution but the database is telling you the connection w

[web2py] Re: Form.process().accepted stops form (web2py + jquery mobile)???

You are doing it twice. The same call always fails. if request.args(0)>0: ... else: form=SQLFORM(db.Nominativi).*process*() if form.*process*().accepted: ... On Saturday, 23 February 2013 07:27:11 UTC-6, Ivan Gazzola wrote: > > I've the action nomin

[web2py] Re: I need a double entry accounting software ....

I cannot load the page. If you have other links to docs about how ERP works I could use them. I have some basic questions I am trying to answer for example: 1) The account structure is a tree: Assets *BankAccount **Account0001 Asset:BankAccount:Account0001 is a leaf. Can one transfer to/from l

[web2py] Re: ask about database and requires

so, everything checks out correctly? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://g

Re: [web2py] Re: Error db._adapter

Hello everybody, I have not found a solution yet ... Does anyone have any idea how I could do? Thanks... On Fri, Feb 22, 2013 at 9:33 AM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Well... > > Sorry, but the information about the code comment is wrong... > > I uncomment

[web2py] Re: I need a double entry accounting software ....

On Saturday, 23 February 2013 07:04:33 UTC-6, Alan Etkin wrote: > > ... so I wrote this: https://github.com/mdipierro/pacioli > > > Maybe I can use the api with ERPlibre for > replacing the current accounting implementation. Is it possible to > include pacioli

[web2py] Re: asterik addition in fields of form CRUD

Why not do Field('myfield',, comment=SPAN('*',_class='mandatory')) then use jQuery to manipulate the raws that contain the jQuery('span.mandatory'). On Saturday, 23 February 2013 00:58:42 UTC-6, waqasiqb...@gmail.com wrote: > > i want to add asterik in front of all mandotry Why fields , but

[web2py] Re: ask about database and requires

hi niphlod, thank you for your detail explaination and examples, niphlod, yes, you are right, actually, i've test it on the web form not via console with SQLite as the database. 1. notnull=True is not work without requires=IS_NOT_EMPTY() during my testing is on field note, i define notnull=Tr

[web2py] How to update web app on server without change the data already in database

On Unix type systems you have rsync. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://g

[web2py] ajax choking on text - need help

Is your Web2py source file encoded UTF8? Have you tried prefacing the string with a lowercase 'u' for unicode? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email

[web2py] Form.process().accepted stops form (web2py + jquery mobile)???

I've the action nominativo, that works. When i add the if condition for checking form.process().accepted (is the code from to <) the form submit data but don't accept the variables. Any idea I need the conditional for redirection after form submission def nominativo(): re

[web2py] Re: ask about database and requires

> > > 1. in example above i didn't define requires=IS_NOT_EMPTY(), yet i still > can submit and get the data > you are not using any form to insert the data, so requires= won't get considered anyway. as for database constraints, The only field missing is grand_total, so the db should raise an

[web2py] Re: I need a double entry accounting software ....

> > ... so I wrote this: https://github.com/mdipierro/pacioli Maybe I can use the api with ERPlibre for replacing the current accounting implementation. Is it possible to include pacioli in an AGPLv3 package? -- --- You received this message because you a

[web2py] ajax choking on text - need help

I'm doing an ajax callback that's supposed to update a div with new text: # action ... return 'jQuery("#my-target").html("%s");' % clean_str(make_contents(filename )) def make_contents(filename): return open(filename, 'rb').read().decode('utf-8') def clean_str(text): return str(text).r