OpenERP Technical and Functional Training : India September-October 2012 in India

Dear Aspirants,

We feel proud to announce that Serpent Consulting Services is organizing a Functional and Technical Training for Aspirants. Serpent Consulting Services successfully completed 11 Training sessions of OpenERP Technical and OpenERP Functional Trainings for the year 2012. It is a tremendous achievement for any company.

Our Facebook Profile shows all pictures.

Serpent Consulting Services feels immense pleasure to announce back to back OpenERP Technical and Functional Trainings Respectively.

Special attention this time is discounted Training Fees :-
1. Single ( Individual Trainee) : 700 USD per trainee.
2. Group between 5 to 9 Trainees : 550 USD per trainee.
3. Corporate 10 and more Trainees : 3500 USD for 5 days.

OpenERP Functional Training Sept 2012 :- 10th Sep to 14th Sep 2012
OpenERP Functional Training Oct 2012 :-  8th Oct to 12th Oct 2012

This Training is dedicated to partners, integrators and end-users who want to get a better functional understanding of OpenERP. This training is meant to give an overview of the OpenERP features allowing for a general understanding of the software.

The 12th Training programme will be OpenERP Functional Training version 6.1 to be held on 8th Oct to 12th Oct 2012. Aspirants join us for Training, and come out as expert after the completion of Training.

Our Facebook Profile shows all pictures.

Training Outlines can be found at :-

OpenERP Functional Training

OpenERP Technical Training Sept 2012 :- 17th Sep to 21st Sep 2012
OpenERP Technical Training Oct 2012 :-  15th Oct to 20th Oct 2012

The technical training is a unique opportunity for anyone, who wants to develop and customize his own modules! This Training is exclusive to partners, integrators and new developers who need to gain knowledge of the OpenERP development process and also for IT professionals eager to learn more about the OpenERP technical aspects.

The 12th Training programme will be OpenERP Technical Training version 6.1 to be held on 15th Oct to 20th Oct 2012. It brings occasion for you to attend in India. We come with various new additions to the normal Training.

Training Outlines can be found at :-

OpenERP Technical Training

Duration : -
Both Training will be 5 days training. 8 hours each day.
Facilities:
Daily drinks (tea / coffee) and lunch;
Training material

Both of these Trainings are very important who are new to OpenERP world. SerpentCS organizing OpenERP Technical and Functional Trainings every month with a good success ratio resulting in confident smiles of attendees.
We will be pleased to welcome you at this training!

You can also Contact Us for Remote and Onsite Training, OpenERP Support, OpenERP Offshore,OpenERP Migration and Tryton Services.
Register your seat at contact@serpentcs.com.

Recent News :-

1. OpenERP : Parent_left, parent_right Explained!

2. Graph View in OpenERP 7.0

3. How to Change Language in OpenERP
4. Training Sessions
5. Code Analysis using Pylint on Eclipse
6. POS for Restaurant/Cafe Shop

7. Tryton : New DB installation, company configuration, google map!

8. OpenERP Advance Invoice
9. OpenERP v6.1 Point of Sale
10. OpenERP Multiple Image Light box
11.OpenERP: Indian currency Added by Proposal of SerpentCS
12. GNU Health won the Award for Projects of Social Benefits at FSF

For any news and updates Regarding Serpent Consulting Services visit,here.

Maula mere le le meri jaan - keep the faith in the religion and the country!

I am writing this because I cried today, no really there is no pain however. This is just a sense of Patriotism !

The religion of humanitarianism...food for thought.

No no no, I am not writing this because its an Independence day today. To be honest, having holidays on Independence day for me does not make any difference. It has been just a one more NULL day in life. I hope majority of you agree. I believe work should be done with double integrity on such days. And I know a very very few will agree.

Anyways, I was just having a last bite of my dinner now and I switched a channel and moved to Sony Max and my remote had to be put aside and I forgot I was eating something. Guys, I was listening 'Maula mere le le meri jaan……..' from Chak De India, truly a superb movie, one of my favourites. Fantastic, emotional, number one,- whatsoever best objectives to be applied - song this is.

This song is one of the very very very rare things which have made me cry...O boss, what a meaning is displays. And the voice of Krishna, truly saddening.

It talks about the relationship between a patriot and his country and how he chooses to fight back to prove his love. The feel of this song is truly something else when watched in the movie.

Each time I hear the song, it touches a chord. Initially I didn't get the word, till I realized its significance.

The Lyrics go as:

  

[Teeja tera rang thaa mai toh
Teeja teraa rang thaa mai toh
jiya tere dhang se mai toh
tu hi thaa maula tu hi aan
Maula mere le le meri jaan ] 2

I am adorned by your colors
I have lived by your traditions
You are my Lord, my pride
Take my life its yours, My Lord

Tere sang kheli holi
Tere sang ki diwali
Tere angno ki chhaya
Tere sang saawan aaya
Fer le too chaahe nazre
Chaahe yeh chura le
Laut ke too aaega re shart laga le

With you I have played Holi
And with you celebrated Diwali
In your courtyard I found shade
In your company the rains arrived
Now you can turn away from me if you want
But you will return, I am certain

Teeja tera rang thaa mai toh
Teeja tera rang thaa mai toh
jiya tere dhang se mai toh
Tu hi thaa maula tu hi aan
Maula mere le le meri jaan ...!

Mitti meri thi bhoori
Wohi mere ghee aur choori
Wohi raanjhe mere wo heer
Wohi sevaiyaan wahi kheer
Tujhse hi roothnaa mujhe hi manaana
Teraa mera naata koi dooja naa jaana

You are my earth
You are my Ghee and Churi(sweet)
You are my Ranjha and you are my Heer(star crossed lovers)
You are my sevaiyaan and my kheer (sweet)
You are the one I get angry with and the one I makeup with
No one else can understand our relationship

Teeja tera rang thaa mai toh
Teeja tera rang thaa mai toh
Jiya tere dhang se mai toh
Tu hi thaa maula tu hi aan
Maula mere le le meri jaan ! 

I was just looking for the meanings of each line. I remember It was Kapil Devani, who made me aware about the lyrics when he shared them on orkut.

Teeja rang, the third colour of the flag, the green in our flag that connotes the Indian farmer or as many say the Indian muslim. Our founding fathers chose our flag with care. Our politics is based on subtle messages, we as a nation hate being direct so if peace was the white then the saffron and the green symbolized the two communities that make the largest part of the nation, and the white probably was a hope for relations between both communities to be peaceful. Or so I feel.

Basically, the world hasn't collapsed yet and never will because rational thinkers, humanitarians, exist. One's religion should be one's personal affair, but people hardly ever think over things - they mostly go with the flow.

I am not Muslim so I just see those things. Others who are, I know, must feel very bad actually experiencing these circumstances. I am seeing the festival of Ramadan closely since very long. I am just growing up and I have begun to see differences in society - that never existed till I was in school/ college... strange! But I think if we are better thinkers, we can win over the lesser thinkers and shouters and short-term-self-gainers. I won't name those friends of mine, but they are experiencing many difficulties in getting their own homes just because they are Muslims, what a crap is this!

Please, Love and respect everyone. I can write pages and pages in such a topic, but I don't want to raise questions and thus heading to long discussions.

My religion is: 1. My Duty 2. Law 3. My Passion 4. Making someone smile and motivate !

Jay Hind.


GOD bless you!

ADO.NET SQL database connection strings for SQL Server

Please go through this for a reference.

SQL ODBC connection strings

Standard Security: 

 "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection: 

 "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;" 

SQL OLE DB connection strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" 

SQL OleDbConnection .NET strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" 

SQL SqlConnection .NET strings

Standard Security:

1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:

1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

Connection Strings for Oracle with connection of C#!

Do you have a hard time remembering database connection strings?  You are not alone!  Here is an easy-to-use reference of connection strings for Oracle!

// ODBC DSN

using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open();

// ODBC -- New Microsoft Driver

using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =            "Driver={Microsoft ODBC for Oracle};" +            "Server=OracleServer.world;" +            "Uid=UserName;" +            "Pwd=Secret;"; conn.Open();

// ODBC -- Old Microsoft Driver

using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =     "Driver={Microsoft ODBC Driver for Oracle};" +     "ConnectString=OracleServer.world;" +     "Uid=UserName;" +     "Pwd=Secret;"; conn.Open();

// ODBC -- Oracle Driver

using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =     "Driver={Oracle ODBC Driver};" +     "Dbq=myDataBase;" + // define in tsnames.ora     "Uid=UserName;" +     "Pwd=Secret;"; conn.Open();

// OleDb -- Microsoft Driver

using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=MSDAORA;" +               "Data Source=ServerName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();

// OleDb -- Oracle Driver -- Standard Connection

using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=OraOLEDB.Oracle;" +               "Data Source=ServerName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();

// OleDb -- Oracle Driver -- Trusted Connection

using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=OraOLEDB.Oracle;" +               "Data Source=ServerName;" +               "OSAuthent=1;"; conn.Open(); // or using System.Data.OleDb; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=OraOLEDB.Oracle;" +               "Data Source=ServerName;" +               "User id=/" +               "Password=;"; conn.Open();

// .NET DataProvider from Microsoft // -- Standard Connection

using System.Data.OracleClient; OracleConnection conn = new OracleConnection(); conn.ConnectionString =               "Data Source=ServerName;" +               "User id=UserName;";               "Password=Secret;"; conn.Open();

// .NET DataProvider from Microsoft // -- Trusted Connection

using System.Data.OracleClient; OracleConnection conn = new OracleConnection(); conn.ConnectionString =               "Data Source=Servername;" +               "Integrated Security=Yes;"; conn.Open();

// .NET DataProvider from Oracle // -- Standard Connection

using Oracle.DataAccess.Client; OracleConnection conn = new OracleConnection(); conn.ConnectionString =               "Data Source=ServerName;" +               "User id=UserName;";               "Password=Secret;"; conn.Open();

// .NET DataProvider from Oracle // -- Trusted Connection

using Oracle.DataAccess.Client; OracleConnection conn = new OracleConnection(); conn.ConnectionString =               "Data Source=Servername;" +               "Integrated Security=Yes;"; conn.Open();

મરણ તો આવે ત્યારે વાત !

મરણ તો આવે ત્યારે વાત
અત્યારે તો જીવન સાથે ગમતી મુલાકાત.

ખીલવાનો આનંદ હોય છે,
ખરવાની કોઈ યાદ નથી.
સુગંધ જેવો ભીનો ભીનો
વરદાન સમો વરસાદ નથી.

સોના જેવો દિવસ, રૂપા જેવી રાત
મરણ તો આવે ત્યારે વાત

હરતા રહેવું, ફરતા રહેવું
ઝરણાની જેમ વહેતા રહેવું
મહેફિલને મનભરીને માણી
જલસા જલસા કહેતા રહેવું

જીવન અને મરણની વચ્ચે નહીં પ્રશ્નો, પંચાત.
મરણ તો આવે ત્યારે વાત.

મૃત્યુ જેટલું મોટું પૂર્ણવિરામ કોઈ નથી!

આંખ તો મારી આથમી રહી, કાનના કૂવા ખાલી.
એક પછી એક ઇન્દ્રિય કહે : હમણાં હું તો ચાલી.

શ્વાસના થાક્યા વણઝારાનો નાકથી છૂટે નાતો,
ચીમળાયેલી ચામડીને સ્પર્શ નથી વરતાતો.

સૂકા હોઠની પાસે રાખો ગંગાજળને ઝાલી,
એક પછી એક ઇન્દ્રિય કહે : અબઘડી હું ચાલી.

નસના ધોરી રસ્તા તૂટ્યા, લોહીનો ડૂબે લય.
સ્મરણમાં તો કંઈ કશું નહિ, વહી ગયેલી વય.

પંખી ઉડ્યું જાય ને ...પછી કંપે જરી ડાળી

- સુરેશ દલાલ

મરણનો માર્ગ શૂરો !

દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.
ક્યારેક ક્યારેક અહીં ઉગે છે ચંદ્ર પૂર્ણ, મધુરો.

આમ ને આમ આ શૈશવ વીત્યું
ને વહી ગયું આ યૌવન,
વનપ્રવેશની પાછળ પાછળ
ધસી આવતું ઘડપણ.

સ્વાદ બધોયે ચાખી લીધો : ખાટો, મીઠો, તૂરો.
દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.

હવે બારણાં પાછળ ક્યાંક તો
લપાઈ બેઠું મરણ,
એણે માટે એકસરખા છે
વાઘ હોય કે હરણ.

ઝંખો, ઝૂરો, કરો કંઈ પણ : પણ મરણનો માર્ગ શૂરો,
દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.

- સુરેશ દલાલ

OpenERP : Parent_left and parent_right explained!

Guys,

By the time we are typing this down(1 AM crossing soon), Husen and Jay have been delivering Remote Training of the month and this has given us an idea to share a very nice topic which has been a ‘What’ for many.

It has been a busy set of months as have been busy managing Trainings. It is to share that we just finished July 2012 and preparing for the overwhelming response for Aug 2012 OpenERP Training in India.

I understand you might have a hard time understanding what is all about parent_left and parent_right!

Had you seen the code for account.account and product.category, you would better know what it looks like and what’s the importance! Basically, they have been added for faster execution of search call when you have lots of records on these models. In short, you can count them the agents of binary search!

The parent_left and parent_right are 2 special fields that are related to the parent_id field. The purpose of those fields is to make queries within the hierarchy execute efficiently: with parent_left and parent_right, you can retrieve all the descendants of a node without making recursive queries.

Consider two nodes A and B in the hierarchy. A and B can be partner categories, for instance. Their integer fields parent_left and parent_right are such that:
B is a descendant of A in the hierarchy (defined by parent_id)
if and only if

 A.parent_left < B.parent_left, B.parent_right and B.parent_left, B.parent_right < A.parent_right

So, imagine that you have six partner categories like below. You can assign parent_left and parent_right by traversing the tree. The result is show in parentheses next to each node. Note that the values there are optimal; in practice, you can leave gaps in the numbers.
- Customers (1, 10)
  – Consumers (2, 3)
  – Partners (4, 9)
  – Basic Partners (5, 6)
  – Gold Partners (7, 8)
- Suppliers (11, 12)

You can retrieve all the subcategories of Customers with a single SQL query. Note that the values 1 and 10 are the parent_left and parent_right of Customers; they can be retrieved as part of the query itself.

SELECT id FROM partner_category
WHERE parent_left > 1 AND parent_left < 10

The last remark is that parent_left and parent_right can be updated without traversing the whole hierarchy. Removing a node does not require any change.

For adding a node, you can adapt the parent_left and parent_right with two UPDATE queries: one to “make some space” between the parent_left and parent_right of the node’s ascendants, and one to shift the parent_left and parent_right of all the nodes “at the right” of the new position. So parent_left and parent_right can be maintained efficiently.


I hope this helps understanding how they work.
Thanks,

Serpent Consulting Services.

Idea : From the questions of many programmers!
Reference : Own study, understanding.
Contents : Thanks to Launchpad for some good contents.

If you face issues on them, having your records imported by CSV:
To fix on your db:
alter table account_account drop parent_left;
alter table account_account drop parent_right;
and restart the server with –update=account.

એના શમણા!

sorry , થોડો બીઝી હતો, કામમાં હતો હમણાં,
સાચું કહું તો જોતો હતો હું તો એના શમણા...!

એક તો મળતી છે નહિ ને એ હેરાન કરે છે,
નાહક માં મુજ જીવતા જીવ ને એ બેજાન કરે છે.

મળવું હોય તો પણ એ તો એવા ભાવ ખાશે!
એક દિ એ તો સાચે મુજને હાર્ટ-અટેક દઈ જાશે!

કાલે કાલે કરીને મળવાના પ્રોમિસ એ કરશે,
તોયે મળવા નહિ આવે ને સો બહાના ધરશે!

આમ જોઈએ તો હું પણ એનાથી છું કંટાળ્યો,
વિચાર પણ આવે કે આવો તે શું પ્રેમ પાળ્યો!

કંટાળીને બેસું લઈ ને હાથ ની વચ્ચે લમણા,
ત્યાં ફરીથી પ્રેમમાં ખેંચી જાય છે એના શમણા!

-વિરાજ રાઓલ

શાંતિ નો સનેપાત !

વાતાવરણ
અકળામણું, ભારે
શાંતિ ક્યાંથી?

ઘડી બે ઘડી
હાશકારા ની શોધ,
વૈભવ માંથી?

રાત દિવસ,
એક કરવા મથું,
દિવસ રાત!

જડ ચેતન,
પેટાળ, કણ-કણ;
અંતરિક્ષ માં!

દીવો લઈને,
કે સૂર્ય તળે શોધું,
તિમિર માંથી!

સાંધું એક તો,
તુટે તેર છેડલા,
સંબંધો માંથી.

જન્મ લઈને,
આ તો જાણે મેં બાંધ્યો,
સફેદ હાથી!

- જય વોરા