>
> sorry if i am off topic, i am abit stuck
>
i got the model
db.define_table('t_stck_issue',
Field('f_name', type='reference t_items',
label=T('Name')),
Field('f_stck_client', type='reference t_clients',
label=T('Client Assgn')),
Field('f_stck_quantity', type='in
how can i import excel row into a web2py sqlite table
On Wednesday, 2 February 2011 16:30:26 UTC+3, Neveen Adel wrote:
>
> Hello,
>
> Is there a library that can be used to import an excel file that
> insert records in a specific table ?
>
> If there is no a library how can i do that ?
>
> T
On Wednesday, July 26, 2017 at 12:18:17 AM UTC-7, kesh wrote:
>
> sorry if i am off topic, i am abit stuck
>>
>
What is your question?
/dps
> i got the model
>
> db.define_table('t_stck_issue',
> Field('f_name', type='reference t_items',
> label=T('Name')),
> Field('f_stck_
On Wednesday, July 26, 2017 at 2:30:11 AM UTC-7, kesh wrote:
>
> how can i import excel row into a web2py sqlite table
>
>
If the excel data is in CSV format, you can import that directly.
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data>
hello sir
i hope you are ok, well i have been having a problem with some code here
and have searched all over the internet but i was not able to get a solution
MODEL
db.define_table('t_stck_issue',
Field('f_name', type='reference t_items',
label=T('Name')),
Field('f_stck_client',
Note, if you have a new question, it is better to simply create a new topic
rather than adding to a thread that is several years old.
On Wednesday, July 26, 2017 at 5:30:11 AM UTC-4, kesh wrote:
>
> how can i import excel row into a web2py sqlite table
>
> On Wednesday, 2 February 2011 16:30:26 U
Is detail_coa the same or nearly the same for all of these tables? If so,
do you really need separate tables, rather than a single table that simply
includes an extra field on which to partition it?
On Tuesday, July 25, 2017 at 11:12:34 PM UTC-4, 黄祥 wrote:
>
> let say i have table that will crea
I'm trying to expose a form with 2 SQLite tables behind it. I read the
documentation,
did as recommended and got the following error:
Traceback (most recent call last):
File "/home/joao/Desktop/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
File "/home/joao/
Hi all,
since updating from 2.14.6 to 2.15.2 I have a problem with accessing a
remote MS-SQL Database. It does not recognize certain fields and always
gives me an "incorrect syntax" error.
This is the test with the "old" gluon:
>>> from gluon2146 import DAL, Field
>>> py =
DAL("mssql://DRIVER={
So I've noticed that every few days my scheduler task appears to be frozen.
New tasks are put into the queue, but are not being processed. When I
look at the status of the single worker process in the system the
db.scheduler_worker.status = 'PICK'.
I don't see this in the web2py docs anywhere.
Hi
I am looking for web2py example code of a maintenance form for a
master-detail tables (module, view and controller for learning)
An example to share?
Thanks in advance
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
Have a look at
http://www.web2pyslices.com/slice/show/1542/manage-users-and-memebership-in-the-same-form.
You might also consider using SQLFORM.smartgrid.
Anthony
On Wednesday, July 26, 2017 at 10:42:04 AM UTC-4, Jota wrote:
>
> Hi
>
> I am looking for web2py example code of a maintenance form
Please open a Github issue (linking to this thread), as this is a bug that
was recently introduced. Field objects must now be cloned, but the new code
does not take into account that arguments to SQLFORM.factory can also be
tables (which do not have a .clone() method).
Anthony
On Wednesday, Ju
On Tuesday, July 25, 2017 at 8:32:55 PM UTC-4, Seth J wrote:
>
> I have a similar problem with maxtextlengths and I do have the "represent"
> attribute set like so:
> Field('f_last_change', type='text',
> label=T('Latest Changes'),
> defa
There's already a fix for this by Tim Nyborg waiting to be merged:
https://github.com/web2py/web2py/pull/1692
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
-
On Wednesday, July 26, 2017 at 7:41:58 AM UTC-7, Brendan Fox wrote:
>
> So I've noticed that every few days my scheduler task appears to be
> frozen. New tasks are put into the queue, but are not being processed.
> When I look at the status of the single worker process in the system the
> db
yes, the new tables same for all which is base on detail_coa.
the idea is to separate it is base on the case
e.g.
user input data on chart_of_account table e.g. :
-cash
-bank a
-bank b
the same thing goes for account table that automatically create
chart_of_account table to maintain the data of
It's even worse than I imagined.
Leaving off the T() operation, I find that my field labeled "LCM >" is
actually sanitized at some point into:
LCM >:
Yes, something in the process has *recognized* the character ">" and
changed it to ">" But the field "LCM ≤" was sanitized into:
LCM ≤:
On Wednesday, July 26, 2017 at 7:43:14 PM UTC-4, Joe Barnhart wrote:
>
> It's even worse than I imagined.
>
> Leaving off the T() operation, I find that my field labeled "LCM >" is
> actually sanitized at some point into:
>
> id="event_join_lcm_gt__label">LCM >:
>
> Yes, something in the process
Versión: web2py.exe para windows 2.15.2
When entering data in the autocomplete field, the candidate values are not
displayed.
When you enter, it indicates an invalid value.
And an image in transparent format appears and disappears from the first
part of the displayed panel.
The panel, is to inse
Hi Anthony --
The problem is that I don't want "LT" but rather "LE", i.e. "less than or
equal to."
As far as my table comment, I meant that when I used the SQL table and its
Fields to create an SQLTABLE, the labels "just worked" and produced a
column header with the desired symbol instead of p
Not sure it will make a difference, but did you update web2py.js along with
the framework?
On Wednesday, July 26, 2017 at 8:18:31 PM UTC-4, dome wrote:
>
> Versión: web2py.exe para windows 2.15.2
>
> When entering data in the autocomplete field, the candidate values are not
> displayed.
> Wh
I did not clarify it in my post; That I had updated all the js in the app
with those of the 2.15.2 of Welcome.
The post is still open Anthony.
El miércoles, 26 de julio de 2017, 21:18:31 (UTC-3), dome escribió:
>
> Versión: web2py.exe para windows 2.15.2
>
> When entering data in the autoco
Actually I've thought a little more about it and I think this construction
is better.
elapsed_time_field("lcm_gt",label=XML(T("LCM %s",(">",,
elapsed_time_field("lcm_le",label=XML(T("LCM %s",("≤",,
elapsed_time_field("scm_gt",label=XML(T("SCM %s",(">",,
elapsed_time_field("scm_le",lab
>
> As far as my table comment, I meant that when I used the SQL table and its
> Fields to create an SQLTABLE, the labels "just worked" and produced a
> column header with the desired symbol instead of printing "≤" in the
> column heading. So SQLTABLE behavior differed from SQLFORM in this man
I suppose it must have been this commit:
https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a02518de7eb8c5c99f2.
Please post an issue on Github.
Anthony
On Wednesday, July 26, 2017 at 8:18:31 PM UTC-4, dome wrote:
>
> Versión: web2py.exe para windows 2.15.2
>
> When entering data
Ok. I will try it and then confirm.
El miércoles, 26 de julio de 2017, 22:56:53 (UTC-3), Anthony escribió:
>
> I suppose it must have been this commit:
> https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a02518de7eb8c5c99f2
> .
>
> Please post an issue on Github.
>
> Anthony
>
> On Wed
That array (# 1571) is contained in version 2.15.2 that I have.
I'll post the problem on Github.
Thank Anthony.
El miércoles, 26 de julio de 2017, 22:56:53 (UTC-3), Anthony escribió:
>
> I suppose it must have been this commit:
> https://github.com/web2py/web2py/commit/7a5f611e7694016889e33a0251
Thank you for your help, Anthony.
-- Joe
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Goog
29 matches
Mail list logo
