The fallowing are python file not php. By mistake i write php
On Thursday, 27 June 2013 10:52:46 UTC+5:30, Rohitraj Sharma wrote:
>
> This is for fetching data from database
>
> def im():
> task=db(db.mydb).select()
> return dict(rows=task)
>
>
>
> For importing file from database
> def import_table():
> form = SQLFORM.factory(Field('table',requires=IS_IN_SET(db.tables)),
>
> Field('csvfile','upload',uploadfield=False))
> form.process()
> if form.accepted:
> try:
>
> db[form.vars.table].import_from_csv_file(request.vars.csvfile.file)
> except: form.errors.csvfile = 'invalid file'
> return dict(form=form)
>
> The View part
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
> http://www.w3.org/TR/html4/loose.dtd";>
> <html>
> <head>
> <link rel="stylesheet" type="text/css" href="
> http://www.jeasyui.com/easyui/themes/default/easyui.css";>
> <link rel="stylesheet" type="text/css" href="
> http://www.jeasyui.com/easyui/themes/icon.css";>
> <link rel="stylesheet" type="text/css" href="
> http://www.jeasyui.com/easyui/demo/demo.css";>
> <script type="text/javascript" src="
> http://code.jquery.com/jquery-1.6.min.js";></script>
> <script type="text/javascript" src="
> http://www.jeasyui.com/easyui/jquery.easyui.min.js";></script>
> <script type="text/javascript" src="
> http://www.jeasyui.com/easyui/jquery.edatagrid.js";></script>
>
>
>
> <script type="text/javascript">
> $(function(){
> $('#dg').edatagrid({
> saveUrl: 'save_user.py',
> updateUrl: 'update_user.py', I am not able to perform these
> function
> destroyUrl: 'destroy_user.py'
> });
> });
>
> </script>
> </head>
> <body>
> <h2>CRUD DataGrid</h2>
> <div class="demo-info" style="margin-bottom:10px">
> <div class="demo-tip icon-tip"> </div>
> <div>Double click the row to begin editing.</div>
> </div>
> <table id="dg" title="My Users"
> style="width:700px;height:250px"toolbar="#toolbar" pagination="true"
> idField="id"rownumbers="true" fitColumns="true" singleSelect="true">
> <thead>
> <tr>
> <th field="firstname" width="50"
> editor="{type:'validatebox',options:{required:true}}">Name</th>
> <th field="lastname" width="50"
> editor="{type:'validatebox',options:{required:true}}">Phone</th>
> <th field="phone" width="50" editor="text">Email</th>
> <th field="email" width="50"
> editor="{type:'validatebox',options:{required:true}}">Mobile</th>
> </tr>
> </thead>
> <tbody> {{for i,row in enumerate(rows):}}
> <tr>
> <td>{{=row.name}}</td>
> <td >{{=row.phone}}</td>
> <td >{{=row.email}}</td>
> <td >{{=row.mobile}}</td>
> </tr> {{pass}}
> </tbody>
> </table>
> <div id="toolbar">
> <a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true"
> onclick="javascript:$('#dg').edatagrid('addRow')">New</a>
> <a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true"
> onclick="javascript:$('#dg').edatagrid('destroyRow')">Destroy</a>
> <a href="#" class="easyui-linkbutton" iconCls="icon-save" plain="true"
> onclick="javascript:$('#dg').edatagrid('saveRow')">Save</a>
> <a href="#" class="easyui-linkbutton" iconCls="icon-undo" plain="true"
> onclick="javascript:$('#dg').edatagrid('cancelRow')">Cancel</a>
> <a href="{{=URL('default','import_table')}}" class="easyui-linkbutton"
> iconCls="icon-undo" plain="true" >Import</a>
> </div>
>
> </body>
> </html>
>
> Anthony if u can do some thing on that then it is very great for me thanks
>
> On Thursday, 27 June 2013 10:42:00 UTC+5:30, Rohitraj Sharma wrote:
>>
>>
>> Hi Anthony
>>
>> I am not able to get your question. I have one form controller with one
>> view. http://127.0.0.1:8000/tracker/default/form when i run this url its
>> show 404 error.
>> Actually what is my requirement, I have one csv file. which i have to
>> upload. Before saving the file in database, i want to edit in browser.
>> After editing i want to save in database. Is there any method to do.
>> Thanks
>>
>> On Wednesday, 26 June 2013 19:09:00 UTC+5:30, Anthony wrote:
>>>
>>> Using the browser developer tools, what URL gets requested when the ajax
>>> call is made?
>>>
>>> On Wednesday, June 26, 2013 2:44:18 AM UTC-4, Rohitraj Sharma wrote:
>>>>
>>>> I want to select some particular table from database in a drop dowan.
>>>> Then import csv file. edit that file and update. . Can Any one can help me
>>>> plz
>>>>
>>>> i am using the fallowing code for that
>>>>
>>>>
>>>> View
>>>>
>>>> <script>
>>>> jQuery(function() {
>>>> jQuery('#table').change(function() {
>>>> web2py_component("{{=URL('default', 'form.load')}}" + "/" +
>>>> jQuery(this).val(), target='form')
>>>> })})</script>
>>>> {{=SELECT('Select a table', *db.tables, _id='table')}}<div id="form"></div>
>>>>
>>>>
>>>> Controller
>>>>
>>>> def form():
>>>> if request.args(0) in db.tables:
>>>> response.generic_patterns = ['load']
>>>> return dict(form=SQLFORM(db[request.args(0)]).process())
>>>> else:
>>>> raise HTTP(404)
>>>>
>>>>
>>>> every time it toll else part.
>>>>
>>>>
>>>> can any one help me.
>>>>
>>>>
--
---
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://groups.google.com/groups/opt_out.
