import_script.py

import frappe
import cProfile

DATA_FILE = "data/MYDATA.txt"
DELIM = "|"
data_cols = {
  "0": "first_name",
  "1": "last_name",
  "2": "gender",
  "3": "date_of_birth"
}

frappe.init("my_site", "/home/linuxuser/frappe-bench/sites")

for line in open(DATA_FILE):
    if line.find("STCODE|") >= 0:
        continue
    parts = line.split(DELIM)
    entry = frappe.new_doc("My DocType")
    for index in data_cols:
        field = data_cols[index]
        index = int(index)
        entry.set(field, parts[index])
    print("Field with id=%s added." % parts[0])
    frappe.db.commit()