Friday, 11 May 2018

User Role and permission

https://erpnext.org/docs/user/manual/en/setting-up/users-and-permissions/user-permissions

How to set Role permission in ERP

https://erpnext.org/docs/user/manual/en/setting-up/users-and-permissions

Server setup

https://github.com/frappe/bench/wiki/Multitenant-Setup

Friday, 4 May 2018

how to import csv file into mysql table

LOAD DATA INFILE 'c:/tmp/discounts.csv'
INTO TABLE discounts
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

How to convert dictionary to list in python

def demo():
     dict = {"a":1,"b":2,"c":3}
     lis = []
    temp = []
    for k,v in dict.items():
             temp = [k,v]
            lis.append(temp)
     return lis

How to generate Random question from database in mysql

select question from `tabQuestion` order by rand() limit 2;

Django rest api - filter

views.py from django_filters.rest_framework import DjangoFilterBackend class PollList(viewsets.ModelViewSet):     queryset = X.objects...