MassEditing Feature in OpenERP by Serpent Consulting Services!

Hello OpenERP Community,

As it is said by someone,’Never Leave a chance to Thank anyone’. Let SerpentCS take a privilege to thank the OpenERP community for keeping the world of OpenSource Alive.

Here we represent one of the most useful features in ERPs, called Mass Editing. The aim is simply to edit/remove some values of more than one records at the same time, on the fly.

By the time we are typing this, hopefully http://apps.openerp.com should have the module called ‘mass_editing’ as we name it. The complete video is available to see at Youtube.

Few Screens:

1. Mass Editing Menu Location


2. Mass Editing Config


3. Mass Editing Action


4. Mass Editing Screen



The module is 6.0 compatible too as we believe in same treatment to everyone. I have not tested with 5.0 personally, but I am sure of this module to work on 5.0 too. Needless to say, this is 6.1+ compatible originally.

You might download the code from:
1. Extra Addons 6.0
2. Extra Addons Trunk(as on date, its trunk)
3. Community Addons

Any feedback/suggestion/queries are welcomed at contact@serpentcs.com

Many Thanks,

Serpent Consulting Services.

ચાલો લખીએ ઓડિટનોટ !

આજ નો તો દિવસ ભારે હોં ભાઇ, જાણે વમળ માં તરતી બોટ,
એક પછી એક કામ સમેટવા, કેવી મૂક્વી પડતી દોટ!

સવાર પડી ને વાહન હાંક્યું, ભટકાણાં sheap ને ગોટ,
પડ્યો, આથડ્યો મુઢમાર વાગ્યો, જાણે સેહવાગ નો શોટ!
કામ માં મન આખો દી ભડકે બળે, હોય AC કે હોય હોટ,
જે શિખ્યો ભણ્યો એ ઉતારવાને, ચાલો લખીએ ઓડિટનોટ.

છાપું આજ્કાલ એ જ વંચાવે, કૌભાંડો, હત્યા ને નકલી નોટ,
નેતા કાઢે રથયાત્રા ને, આમ આદમી ને મોંઘવારી ની ચોટ!

લે લાકડું ને કર મેરાયું, એમ થોડું કાંઈ થાય ભંભોટ?
લાલો તો લાભ વગર ન લોટે, હસવુંય છે ને ફાંકવો પણ છે લોટ?
એમ ઉતાવળે આંબા નો પાકે, તું માને એમ On the સ્પોટ,
સફળતા તો 'પાણી' માંગે,ન હોય મહેનત નાં ખાતર ની ખોટ!

જીવન તો દરિયા જેવું જીવ, ભલે આવે ભરતી ને ઓટ,
મોત તો હમણાં હાથવગું છે, દલીલ નઈ ચાલે કાળો કોટ,
પાપ નો ફોડ ઘડો મગતરા, ભરવા માંડ પુણ્ય નો પોટ!
હસો - હસાવો જગ ને 'જય' કરવા, બનીએ શાંતિ ના મેસ્કોટ!

- જય વોરા

સપ્ટેમ્બર માં ચોમાસું અને ક્લાયંટ નો બબડાટ!

એક તો આ પ્રોજેક્ટ ની ડેડલાઈન ગભરાવે,
અને બીજો આ વરસાદ નો પડછંદ ઘઘડાટ,
આગ લાગે ત્યારે જ કૂવો ખોદવાની આદત છે ઊભરાટ,
સપ્ટેમ્બર માં ચોમાસું અને ક્લાયંટ નો બબડાટ!

- જય વોરા ( Thoughts at the time of Project submission

) !

My Journey of Python, OpenSource, OpenERP moves onto the 6th year

                             The clock ticks and moves on, doesn't really stop atleast for a second! Why would it ? I know very well that it does not tick only for me, so sticks on ticking on and just while you reading this, it had already moved few more seconds.

Naturally, when some one becomes a little idle or tired or goes to sleep, one becomes a little nostalgic, refreshes the day spent and remembers whether its anyone's birthday today or something special related to the current date.

And yes, here it comes my turn and its September 10, 2012 and it shows that I have completed 5 years. OF??? yes, 10 sep 2007 is the date ever since I came to know about OpenSource, Python and OpenERP. It is to mention that it too was a Monday. I am quickly moved to my laptop now and sharing my old memories and having a pleasure to thanks to the builders of the career so far. Well yes, NEVER LEAVE A CHANCE TO THANK ANYONE. I am here to thank to the names you will read below.

By the time I write this, I am into the old times 5 years back while I was just a fresher and working for Anish Information Technology,working on Microsoft Technologies (now acquired by Thomson Reuters). On one usual day or better to say as a part of routine I went for a usual meet to my close friend Akash Oza(It does not happen now a days more often as we are busy in our married lives, he is legally married and I am to Serpent Consulting Services). While having a usual talk, I happen to discuss with his elder brother Navrang Oza, the owner of IntellectSeed Technologies about his current job and I was impressed by the discussion in which he talked about a new concept, new technology and about new opening into the firm TinyERP India Pvt. Ltd. run under the Belgian label led by Mantavya Gajjar.

I kept in my mind that doesn't matter whatever happens, I am going to take this new challenge. Interesting to share that I had my current salary X and my new salary if I take the job was gonna be 20% less, yes you read it right, TWENTY % less !!! Which dumb and blind fresher will take this decision, and I was Qualified enough to label these tags and took the decision for the sacrifice of Money to get a new challenge to know about.

I decided and met once again to Navrang and Dharmesh Rathod, the Managing Director of Axelor India.  I knew few more things about python,future and about the job. Then with the grace of Luck, Navrang introduced me to Mantavya who was/is the director of TinyERP India Pvt. Ltd. He powered me with the opportunities and gave a glimpse of the environment to work on and the future. I then honestly asked them about the background I would need to have to be qualified for the job, they helped me understand the concepts of MVC, OOPs being used in the technology and boosted me for the next coming thing!

I sent the resume and was given a date for the interview. I was interviewed by Hardik Joshi, the Manager and Husen Daudi, the Support Leader. ( Later on Husen sir told me that I was neither selected nor rejected by any of the two interviewers, was just put in pending state. Was later recommended by the names mentioned above and now into the team... Mixed feelings )

I was selected and joined the team of TinyERP Technical architects from 10 sep 2007 (really they were/are/will be) which includes Miss Dhara Shah, Mr. Dhaval Patel, Mr. Husen Daudi, Mr Pritesh Modi, Mr. Hardik Joshi, Mrs. Kundan Patel,Mr. Mustufa Rangwala, Mr. Harshad Modi, Mr. Harsh Kohli and Mr. Ashishsingh Bhatia. I got the offer letter from Mrs. Anar Patel, one of the very confident, strong and powerful ladies I've ever met.

DO What you LOVE and LOVE what you DO. Within the span of 15 days I learnt Technical basics and started working on the OpenSource ERP Called TinyERP (is now called OpenERP). I am still learning and working on it. Learning always has to be a continuous process. If you don't be a student, you cannot make a progress!


Thanks to everyone including the personnels mentioned who have come around my journey and yes its ON! You are the builders and all credits go to you!

You bless yourself,

Thanks,
Jay Vora.

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();

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

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

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

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

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

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

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

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

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

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

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

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

- સુરેશ દલાલ