Dynamic excel mapping for creating XBRL with help of Python/elementTree/xlrd

Posted on Sat 14 July 2012 in XBRL • Tagged with excel, excel macro, python, python xbrl creation, xbrl creatiion, xlrd, xml/xbrlLeave a comment

Yesterday was a great day for me.. .After 3 months of development i got little bit success, i have created xbrl package from excel with help of python language.

I have developed my own mapping language which needs to be defined in excel which recognizes financial facts and their properties ...

Continue reading

Adding new line and encoding infomation while creating XML/XBRL with ElementTree/Python

Posted on Tue 10 July 2012 in XBRL • Tagged with elementTree, ElementTree/Python, encoding, new line, ProcessingInstruction, python, xbrl, xbrl creationLeave a comment

I am making xbrl files with python ElementTree/python module. But there is a problem while creating an xbrl file. It writes it into a single line, which creates confusion a lot.

So i have tried to modified the native ElementTree class which writes a xml  part. In windows it ...

Continue reading

working with pypm/python in internet proxy on windows

Posted on Wed 11 April 2012 in General • Tagged with easy_install, internet proxy, pypm, python, windowsLeave a comment

Well guys,

Currently I am working on PC in my company's development center.Its an Windows XP. This place is highly secured, you need to get all proxy setting for your internet use.

I want to install few python packages with pypm, but in DOS prompt it is not ...

Continue reading

Solution of "UnicodeEncodeError:'latin-1' codec can't encode character ..." while working with MySQLdb and Python.

Posted on Wed 28 March 2012 in General • Tagged with mysql, mysqldb, pythonLeave a comment

I got the error of "UnicodeEncodeError:'latin-1' codec can't encode character ..." while i was inserting data into mysql with MySQLdb/Python.

Below is the solution:

import MySQLdb as litefire
conx = litefire.connect('127.0.0.1', 'root', '' , 'litefire2' );
conx.set_character_set('utf8')
conr=conx.cursor()
conr.execute('SET NAMES utf8 ...

Continue reading

My first AI game of Credit/Debit

Posted on Wed 21 March 2012 in XBRL • Tagged with AI, credit/debit, NLTK, python, xbrlLeave a comment

I have created a game in python using Natural language Toolkit which is a library in python for processing of language.

I have used US GAAP 2011 taxonomy as base database, which later will be utilized to understand the meaning of input. SQLite will support me in doing that.

Results ...

Continue reading