Microsoft , Tata , KVAT and Me

54 views
Skip to first unread message

Parameswaran D

unread,
Jan 2, 2009, 11:42:07 PM1/2/09
to ilug...@googlegroups.com
Anybody visited the www.keralataxes.in for VAT e-filing ?
From 1st of Jan 2009 onwards e-filing of VAT returns is compulsory for all the dealers in Kerala.
Please go through the site and see the documentation and procedures for e-flining..  Site is developed for and by the Microsoft Community. 
 
Govt has arranged e-filing from Akshaya Centers for dealers who have no internet facility at "Free Of Cost" (Thanks to "Microsoft Unlimited Potential Programme")
 
My Problem
 
I request OpenSource community of Kerala to (just forget about the FSFS Conference conducted by Govt  last month and)
address my issue
 
Details of Sales and Purchase needs to be updated in MS Excel format. Template file  "SALES_PURCHASE_INVOICE.XLS" is available for download in the site.  The data then needs to be validated with the excel macro , and macro will create a Text File (sales.txt without headers)  in "C:\KVATS" folder,  for Upload .
 
This macro will not work in OpenOffice Calc 3 .   In Calc I  can save the data as a Text file,  but it is not coming in the required format .    As e-TDS preparation and validation utility (freely available) , KVAT return validation and preparation utility needs to be developed. but immediately OOO Calc  file with macro to be released.
 
In this recession period a solution for the above  will be helpful for Traders.
 
Regards,
Parameswaran D

.Keralafarmer

unread,
Jan 3, 2009, 2:16:44 AM1/3/09
to ilug...@googlegroups.com
ഇത് ശരിയായ സര്‍ക്കാര്‍ തീരുമാനമല്ലല്ലോ. എന്റെ പ്രതിഷേധം രേഖപ്പെടുത്തുന്നു.

2009/1/3 Parameswaran D <pa...@param.net.in>



--
__________________________________________
മണ്ണിരകളെ കൃഷിയിടങ്ങളില്‍ സംരക്ഷിക്കൂ പ്രകൃതിയും ആരോഗ്യവും സംരക്ഷിക്കപ്പെടട്ടെ!
Thank you
എസ്.ചന്ദ്രശേഖരന്‍ നായര്‍,
ശ്രീരാഘവ്, പെരുകാവ്, പേയാട്-പി.ഒ,
തിരുവനന്തപുരം. 695 573
Ph. 0471 2283033
Mob. 91 9447183033 OR 91 9495983033
Blog: http://keralafarmeronline.com

.Keralafarmer

unread,
Jan 3, 2009, 2:19:51 AM1/3/09
to ilug...@googlegroups.com
This site is designed to view in 1024 X 768 resolution and IE 6.0 and above
It is the bottom line

2009/1/3 Parameswaran D <pa...@param.net.in>

ashik salahudeen

unread,
Jan 3, 2009, 11:54:41 PM1/3/09
to ilug...@googlegroups.com

V. Sasi Kumar

unread,
Jan 4, 2009, 2:15:00 AM1/4/09
to ilug...@googlegroups.com
What do you think about FSUG drafting a letter to the FM and CM about
changing this situation? They could either specify a text format that
the traders can fill in or in some way support all platforms. We can get
signatures from our members and even the public.

Best
--
V. Sasi Kumar
Free Software Foundation of India
http://swatantryam.blogspot.com

Abilash kp

unread,
Jan 4, 2009, 11:51:01 PM1/4/09
to ilug...@googlegroups.com
ഇതിനെതിരെ ശക്തമായ പ്രതിഷേധം ഉയരണം

സി.എം. നും എഫ്.എം.നേയും ശശികുമാര്‍ സാറടക്കമുള്ള പ്രധാന പ്രവര്‍ത്തകര്‍ നേരിട്ട് കാണണം.
ഈ വിഷയം മാധ്യമങ്ങളുടെ ശ്രദ്ധയിലും കൊണ്ടുവരണം.

ashik salahudeen

unread,
Jan 4, 2009, 11:53:06 PM1/4/09
to ilug...@googlegroups.com
How do we go about doing this ? What about a meeting on this ?

V. Sasi Kumar

unread,
Jan 5, 2009, 1:00:04 AM1/5/09
to ilug...@googlegroups.com

നമ്മള്‍ ഇപ്പോള്‍ ദേഷ്യപ്പെടുകയോ വെപ്രാളപ്പെടുകയോ ചെയ്യേണ്ടതില്ല.
സര്‍ക്കാര്‍ നയം മാറ്റിയതായി നമുക്കറിവില്ല. അതുകൊണ്ടു് നമ്മളിപ്പോള്‍
ചെയ്യേണ്ടതു് ഇക്കാര്യം ബന്ധപ്പെട്ട മന്ത്രിയെ അറിയിക്കുക എന്നുള്ളതാണു്. ഈ
ഗ്രൂപ്പിനു തന്നെ ഒരു കത്തു് തയാറാക്കി മന്ത്രിയ്ക്കയയ്ക്കാവുന്നതാണു്.
ഗ്രൂപ്പിലുള്ളവര്‍ക്കെല്ലാം ഒപ്പിട്ടയയ്ക്കാം. ബന്ധപ്പെട്ട മന്ത്രി ഒന്നും
ചെയ്യുന്നില്ല എങ്കില്‍ മുഖ്യമന്ത്രിയ്ക്കു് എഴുതാം. എന്നിട്ടും ഒന്നും
സംഭവിച്ചില്ലെങ്കില്‍ നമുക്കു് മന്ത്രിമാരെ കണ്ടു സംസാരിക്കാം. ഇടതുപക്ഷം
ഇതുവരെ നമ്മളെ അനുകൂലിച്ചിട്ടുണ്ടല്ലൊ. നമുക്കു് ശുഭപ്രതീക്ഷയോടെതന്നെ
നീങ്ങാം.

i.p.murali

unread,
Jan 5, 2009, 1:06:52 AM1/5/09
to Free Software Users Group, Trivandrum
+1

Anivar Aravind

unread,
Jan 5, 2009, 2:52:08 AM1/5/09
to ilug...@googlegroups.com

തീര്‍ച്ചയായും. അതുപോലെ പത്രാധിപര്‍ക്കുള്ള കത്തുകള്‍ വഴിയും മറ്റും ഇതു
കൂടുതല്‍ പേരുടെ ശ്രദ്ധയില്‍ കൊണ്ടുവരണം.

vipin kumar

unread,
Jan 5, 2009, 3:04:13 AM1/5/09
to ilug...@googlegroups.com
Team,


Is there anybody else faced this issue ?


VIPIN KUMAR.V


2009/1/5 Anivar Aravind <ani...@movingrepublic.org>



--
rEgArDs,

vIpIn kUmAr.V
TrIvAnDrUm
iNdIa

Sebin Jacob

unread,
Jan 5, 2009, 4:08:32 AM1/5/09
to ilug...@googlegroups.com, fsf-friends
Found this posting in Boycott Novell website.

Sebin

--
...if I fought with you, if i fell wounded and allowed no one to learn of my suffering, if I never turned my back to the enemy: Give me your blessing! (Nikos Kazantzakis)

Rajkumar S

unread,
Jan 5, 2009, 4:26:01 AM1/5/09
to ilug...@googlegroups.com
Quoting "V. Sasi Kumar" <sasi...@gmail.com>:

> What do you think about FSUG drafting a letter to the FM and CM about
> changing this situation? They could either specify a text format that
> the traders can fill in or in some way support all platforms. We can get
> signatures from our members and even the public.

In the mean time is there any hacker who can provide an open office
equivalent macro?

raj

Aneesh A

unread,
Jan 5, 2009, 4:53:14 AM1/5/09
to ilug...@googlegroups.com
Yes. A strong protest should be organised, if this is not changed.

Mani A

unread,
Jan 5, 2009, 8:01:55 AM1/5/09
to Principal Support List of FSF-India, ilug...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Jan 3, 2009 at 12:44 PM, Sebin Jacob wrote:
> Here is a mail that appeared in fsug-tvm. Its better to stop the argument
> From: Parameswaran D


> Anybody visited the www.keralataxes.in for VAT e-filing ?
> From 1st of Jan 2009 onwards e-filing of VAT returns is compulsory for all
> the dealers in Kerala.

The finance department still uses proprietary stuff. They seem to be
holding on to licensed proprietary material from earlier years. The
website http://www.finance.kerala.gov.in and many other things have
been done with GNU-GPLed s/w, but the fact is the department staff has
never been reformed (apparently).

It seems they use Adobe distiller, Pagemaker and more.

Are there no FOSS based solutions for all the other central tax forms?


Best

A. Mani


--
A. Mani
Member, Cal. Math. Soc


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFJYgaLoIK4BlImohYRAihLAKCaNNr0KLBWc3EKGpaciawjb2zy0wCfeDMK
HwvDY/9tsKeorN1cnW5w8/k=
=/5iZ
-----END PGP SIGNATURE-----

Param

unread,
Jan 5, 2009, 8:44:25 PM1/5/09
to Free Software Users Group, Trivandrum
Request submitted for providing Open Office Calc Template through
http://www.keralataxes.in/postQueries.aspx
Let them address the issue professionally

Parameswaran D
.

V. Sasi Kumar

unread,
Jan 5, 2009, 11:25:57 PM1/5/09
to ilug...@googlegroups.com
On Mon, 2009-01-05 at 17:44 -0800, Param wrote:
> Request submitted for providing Open Office Calc Template through
> http://www.keralataxes.in/postQueries.aspx
> Let them address the issue professionally

Thank you for your initiative.

I think we can also initiate drafting a letter to the Minister. What do
others think?

ashik salahudeen

unread,
Jan 5, 2009, 11:29:07 PM1/5/09
to ilug...@googlegroups.com

V. Sasi Kumar

unread,
Jan 5, 2009, 11:45:22 PM1/5/09
to ilug...@googlegroups.com
On Tue, 2009-01-06 at 09:59 +0530, ashik salahudeen wrote:
> http://fci.wikia.com/wiki/An_Open_Letter_To_Kerala_CM
>
Took a quick look at the letter. I think it is better to point out
specific issues, rather than making general statements like "Government
agencies are purchasing proprietary software widely." Let us write, for
instance, something like "We understand that KSEB is opting to use
Oracle, a proprietary software, when there are Free Software options
like PostgreSQL". This will make it easier for the concerned people to
identify where the problem is and take corrective action.

Manilal K M

unread,
Jan 6, 2009, 12:10:44 AM1/6/09
to ilug...@googlegroups.com
2009/1/6 V. Sasi Kumar <sasi...@gmail.com>:

>
> On Tue, 2009-01-06 at 09:59 +0530, ashik salahudeen wrote:
>> http://fci.wikia.com/wiki/An_Open_Letter_To_Kerala_CM
>>
> Took a quick look at the letter. I think it is better to point out
> specific issues, rather than making general statements like "Government
> agencies are purchasing proprietary software widely." Let us write, for
> instance, something like "We understand that KSEB is opting to use
> Oracle, a proprietary software, when there are Free Software options
> like PostgreSQL". This will make it easier for the concerned people to
> identify where the problem is and take corrective action.
>

+1
We should also provide proofs for all the facts(URL or press reports).
--
Manilal K M : മണിലാല്‍ കെ എം.
http://libregeek.blogspot.com

V. Sasi Kumar

unread,
Jan 6, 2009, 12:29:08 AM1/6/09
to ilug...@googlegroups.com
On Tue, 2009-01-06 at 10:40 +0530, Manilal K M wrote:

> We should also provide proofs for all the facts(URL or press reports).

At least, as far as possible. Where we cannot, we can say, something
like, "We understand that ...."

Praveen A

unread,
Jan 6, 2009, 12:58:30 AM1/6/09
to ilug...@googlegroups.com
2009/1/5 V. Sasi Kumar <sasi...@gmail.com>:

>
> On Tue, 2009-01-06 at 09:59 +0530, ashik salahudeen wrote:
>> http://fci.wikia.com/wiki/An_Open_Letter_To_Kerala_CM
>>
> Took a quick look at the letter. I think it is better to point out
> specific issues, rather than making general statements like "Government
> agencies are purchasing proprietary software widely." Let us write, for
> instance, something like "We understand that KSEB is opting to use
> Oracle, a proprietary software, when there are Free Software options
> like PostgreSQL". This will make it easier for the concerned people to
> identify where the problem is and take corrective action.
>

Yes. It is a draft with just the points we could list. Community
inputs like this is needed before we can finalise it.

folks,

Its a wiki, so participate.

- Praveen
--
പ്രവീണ്‍ അരിമ്പ്രത്തൊടിയില്‍
<GPLv2> I know my rights; I want my phone call!
<DRM> What use is a phone call, if you are unable to speak?
(as seen on /.)
Join The DRM Elimination Crew Now!
http://fci.wikia.com/wiki/Anti-DRM-Campaign

Manilal K M

unread,
Jan 6, 2009, 1:12:32 AM1/6/09
to ilug...@googlegroups.com
2009/1/6 V. Sasi Kumar <sasi...@gmail.com>:
>

Government websites using proprietary technology:

1. http://www.infokerala.org
2. http://www.lsg.kerala.gov.in
3. http://news.kerala.nic.in/ (Site optimised for IE)
4. http://ikm.gov.in
5. http://keralataxes.in/ (Site optimised for IE)
6. http://www.keralaculture.org
7. http://www.civilsupplieskerala.gov.in/
8. http://keralamvd.gov.in/ (all the services are developed using
proprietary technology)


Sites using non-standard technology. (Government insists unicode fonts
for electronic communication. But the following sites still use
proprietary fonts refer:
http://www.keralaitmission.org/web/updates/MalUnicode.pdf)
1. http://www.thalikkulampanchayat.in
2. http://www.vellanad.org
3. http://www.corporationofthrissur.net/
4. http://www.corporationofcochin.net
5. http://www.karshikakeralam.gov.in/

Praveen A

unread,
Jan 6, 2009, 1:24:22 AM1/6/09
to ilug...@googlegroups.com
2009/1/5 Manilal K M <libr...@gmail.com>:

> Government websites using proprietary technology:

Manilal, please add it to the wiki.

Manilal K M

unread,
Jan 6, 2009, 1:34:13 AM1/6/09
to ilug...@googlegroups.com
2009/1/6 Praveen A <pra...@gmail.com>:

> 2009/1/5 Manilal K M <libr...@gmail.com>:
>> Government websites using proprietary technology:
>
> Manilal, please add it to the wiki.

Done. I didn't included the standards issue(unicode compatibility),
because it's slightly off-topic.

V. Sasi Kumar

unread,
Jan 6, 2009, 1:52:54 AM1/6/09
to ilug...@googlegroups.com
On Tue, 2009-01-06 at 11:42 +0530, Manilal K M wrote:
>
> Government websites using proprietary technology:
>
> 1. http://www.infokerala.org
> 2. http://www.lsg.kerala.gov.in
> 3. http://news.kerala.nic.in/ (Site optimised for IE)
> 4. http://ikm.gov.in
> 5. http://keralataxes.in/ (Site optimised for IE)
> 6. http://www.keralaculture.org
> 7. http://www.civilsupplieskerala.gov.in/
> 8. http://keralamvd.gov.in/ (all the services are developed using
> proprietary technology)
>
>
> Sites using non-standard technology. (Government insists unicode fonts
> for electronic communication. But the following sites still use
> proprietary fonts refer:
> http://www.keralaitmission.org/web/updates/MalUnicode.pdf)
> 1. http://www.thalikkulampanchayat.in
> 2. http://www.vellanad.org
> 3. http://www.corporationofthrissur.net/
> 4. http://www.corporationofcochin.net
> 5. http://www.karshikakeralam.gov.in/

This is good. I think we can stress on government sites first. If there
are sites that are stated as designed for use with IE, we can include
them also. Another point is to see where all documents are made
available in, or required to be submitted in proprietary formats.

If we can gather even a good part of such information, it would be a
good to-do list for the government or IT department.

sajith kumar

unread,
Jan 6, 2009, 5:53:29 AM1/6/09
to ilug...@googlegroups.com
SPARK IS ALSO SUPPORTING INTERNET EXPLORER SETTINGS

Sebin Jacob

unread,
Jan 6, 2009, 9:40:18 AM1/6/09
to ilug...@googlegroups.com
A news item regarding this in the New Age Business Daily:

Syam Krishnan

unread,
Jan 7, 2009, 10:04:44 AM1/7/09
to ilug...@googlegroups.com
Some suggestions:
1. The issue of keralataxes.in can be brought first, as it is a more serious issue than websites hosted using proprietary software.

2. Split 'Issues of Concern' and specific cases/complaints to two different sections. The 'issues of concern' can have very general statements like 'Government agencies are purchasing proprietary software widely'.

3. The use of abbreviation 'IE' can be replaced with Internet Explorer (or define "IE" as Microsoft Internet Explorer). Using "IE" everywhere makes it look like geek speak :-)

4. "order a judicial inquiry to ascertain facts on the concerns raised here" - A judicial inquiry?? Aren't we asking a bit too much? If we can point out a specific scandal or wrong-doing, then it's justified. But most of the points we raise are because of some officials being accustomed to proprietary software or ignorant of free software.

5. "fix responsibility on officials concerned and apportion blame" - I didn't like the "apportion blame" part. IMHO, that suits a rant than a formal serious letter.

6. The plural of software is just software.

7. "Recent purchase of laptops for secretariat full of M$" - should have better form and substitute M$ with Microsoft. Sounds more like a rant. And low availability of laptops with GNU/Linux (or FreeDOS followed by installation of GNU/Linux) is a fact.

8. I think we should also offer a translation in Malayalam.

regards,

Syam



Syam Krishnan

unread,
Jan 7, 2009, 10:11:04 AM1/7/09
to ilug...@googlegroups.com
Sebin Jacob wrote:
A news item regarding this in the New Age Business Daily:


ആണവച്ചില്ലുകളാണല്ലോ... :-(
പക്ഷേ, താങ്കളുടെ ഒരു കമന്റില്‍, ചില്ലുകള്‍ ശരിയായികാണിക്കുന്നുണ്ട്.

ശ്യാം

Sebin Jacob

unread,
Jan 7, 2009, 10:12:22 AM1/7/09
to ilug...@googlegroups.com
+1 Syam

and even if you know by yourself that the purchases in govt departments were in Microsoft platform, if you don't have valid evidence to prove it, better omit it. There should not be ambiguity and beating the bush.

Sebin

aashiks

unread,
Jan 6, 2009, 10:43:06 PM1/6/09
to ilug...@googlegroups.com
It is a wiki :) feel free to edit

Sebin Jacob

unread,
Jan 7, 2009, 10:22:05 AM1/7/09
to ilug...@googlegroups.com
ആണവച്ചില്ലുകളാണല്ലോ... :-(
പക്ഷേ, താങ്കളുടെ ഒരു കമന്റില്‍, ചില്ലുകള്‍ ശരിയായികാണിക്കുന്നുണ്ട്.

ശ്യാം

ശ്യാമേ,

ഞാന്‍ യൂണിക്കോഡ് എഴുതുന്നതു് പഴയ ചില്ലുപയോഗിച്ചാണു്. ഇന്‍സ്ക്രിപ്റ്റാണു് ഉപയോഗിക്കുന്ന ഇന്‍പുട്ട് മെഥേഡ്. എന്നാല്‍ ലൈവ് സയന്‍സിലെ പോസ്റ്റുകള്‍ ഒരെണ്ണമൊഴികെ എല്ലാം പത്രത്തിനുവേണ്ടി എഴുതിയവയാണു്. (വിന്‍ഡോസില്‍ പേജ്മേക്കറില്‍.) ആസ്കിയിലുള്ളതു് വരമൊഴി ഉപയോഗിച്ചു് കണ്‍വേര്‍ട്ട് ചെയ്യുമ്പോള്‍ ആണവച്ചില്ല് കടന്നുവരുന്നു.

കണ്‍വേര്‍ഷനായി പയ്യന്‍സ് ഉപയോഗിച്ചു് നോക്കിയെങ്കിലും അക്ഷരങ്ങള്‍ മാറിപ്പോകുന്നുണ്ടു്. ആണവച്ചില്ലുണ്ടെന്നൊഴിച്ചാല്‍ വരമൊഴിയുടെ ഫോണ്ട് കണ്‍വേര്‍ഷന്‍ ഏറെക്കുറെ പെര്‍ഫെക്ട് ആണു്. (നല്ലതിനെ അംഗീകരിക്കണമല്ലോ) പിന്നെ ആണവച്ചില്ലിനെ പിടിച്ചു് പഴയ മട്ടിലുള്ള ചില്ലാക്കാന്‍ നിഷാന്ത് നസീര്‍ ദാ ഇവിടെ ഒരു ഫിക്സ് ഇട്ടിട്ടില്ലേ, ചുമ്മാ ഡൌണ്‍ലോഡെന്നേ...

സെബിന്‍

Param

unread,
Jan 8, 2009, 9:12:14 PM1/8/09
to Free Software Users Group, Trivandrum
Please see the Reply from the site owners. DataTypes for validating
the data and Text File format provided in the site.

Instructions .....

4. The file names used for uploading shall be 'purchase.txt' and
'sales.txt' respectively.
5. The files may be prepared by using any software including an
extension in their billing software.
6. For those who are interested, an Excel form for preparing these
files is available for downloading in the e-Filing home page. After
filling /populating data from any external systems, press VALIDATE
button to generate the 'purchase.txt' and 'sales.txt'.
7. More tools for preparing these annexure files will be published
shortly.


Regards,
Parameswaran D



----- Original Message -----
From: <brijes...@cmcltd.com>
To: "Inspg.Asst.Commissioner (IB)" <iaci...@gmail.com>
Cc: <pa...@param.net.in>; <dee...@cmcltd.com>; <itmc....@gmail.com>
Sent: Thursday, January 08, 2009 6:51 AM
Subject: Re: Fwd: MS Excel Template Query From from Keralataxes.in


> Sir,
>
> Pls see the instructions in the 'latest eFiling circulars' available in
> the home page. A tool in Open Office would be provided shortly, at present
> the data can be uploaded in the form of text files. Format provided in
> the
> 'latest eFiling circulars' .
>
>
>> ---------- Forwarded message ----------
>> From: <pa...@param.net.in>
>> Date: Tue, Jan 6, 2009 at 7:05 AM
>> Subject: MS Excel Template Query From from Keralataxes.in
>> To: vathe...@gmail.com
>> Cc: iaci...@gmail.com
>>
>>
>> I am using openoffice and the Excel Macro for validation and creation of
>> upload file is not working in OpenOffice Calc
>> Please provide template in OpenOffice Calc
>>
>>
>>
>> --
>> B.S.THYAGARAJABABU
>> INSPECTING ASSISTANT COMMISSIONER
>> INVESTIGATION BRANCH
>> COMMERCIAL TAXES DEPARTMENT
>> THIRUVANANTHAPURAM.
>>



**********************************************************************************************

Sebin Jacob

unread,
Jan 9, 2009, 1:34:07 AM1/9/09
to ilug...@googlegroups.com
Though it sounds to be a tactical position, it is a welcome move. Still there is another objectionable thing in that site. They are distributing an old version of Adobe Acrobat for free. Its given for download in the bottom of that page. Do they have legal right to do so? Adobe's license agreement normally does not allow the distribution of that software by third parties.

Sebin.

Syam Krishnan

unread,
Jan 9, 2009, 9:01:09 AM1/9/09
to ilug...@googlegroups.com
Sebin Jacob wrote:
> They are distributing an old version of Adobe Acrobat for free. Its
> given for download in the bottom of that page. Do they have legal
> right to do so? Adobe's license agreement normally does not allow the
> distribution of that software by third parties.

That shouldn't bother us, should it? Anyway, Adobe may have a
redistribution license for Adobe Reader. I had once acquired a
redistribution license for the Flash player (although then from
Macromedia). Considering the number of third party software CDs
containing Adobe Reader, that's very much probable.

Syam

aashiks

unread,
Jan 9, 2009, 9:14:04 AM1/9/09
to ilug...@googlegroups.com

Anoop John

unread,
Jan 9, 2009, 3:13:58 PM1/9/09