I need to convert tally data which may be kept in files with extensions such as .001 etc to csv format. Which FOSS software can help do that? Any ideas.
On Sun, Mar 6, 2011 at 9:21 AM, Shamit Verma subs.linux.mum@vshamit.comwrote:
Have you tried accessing this data via ODBC? I think tally can expose the data via an ODBC driver.
With that, you can access data from OpenOffice Base/Calc or write your own Perl/Python utility. You can save as CSV from any of these.
-Shamit
I will try, and come back if it did not work out. Will take me some time though. Thank you for the idea. Had not thought in that direction.
Kussh
On Sun, Mar 6, 2011 at 10:02 AM, Kussh Singh kussh.singh@gmail.com wrote:
I need to convert tally data which may be kept in files with extensions such as .001 etc to csv format. Which FOSS software can help do that? Any ideas.
On Sun, Mar 6, 2011 at 9:21 AM, Shamit Verma subs.linux.mum@vshamit.comwrote:
Have you tried accessing this data via ODBC? I think tally can expose the data via an ODBC driver.
With that, you can access data from OpenOffice Base/Calc or write your own Perl/Python utility. You can save as CSV from any of these.
I will try, and come back if it did not work out. Will take me some time though. Thank you for the idea. Had not thought in that direction.
Circa 2007, a potential client had a similar requirement. In my research, I came across a Tally partner that has a DLL to export/import Tally Data in XML format (over TCP/IP also). Sorry cannot recall the name of the company, they are based off in Amhedabad, GJ.
-- Arun Khan
On Sunday 06 March 2011 10:02 AM, Kussh Singh wrote:
I need to convert tally data which may be kept in files with extensions such as .001 etc to csv format. Which FOSS software can help do that? Any ideas.
Since the person is using Tally already, it has an export feature.
http://forums.techarena.in/windows-software/1179110.htm
You can put his 'data' folder into someone else's Tally too and then export. Backup that person's 'data' folder first.
On Mon, 2011-03-07 at 12:46 +0530, Rony wrote:
Since the person is using Tally already, it has an export feature.
http://forums.techarena.in/windows-software/1179110.htm
You can put his 'data' folder into someone else's Tally too and then export. Backup that person's 'data' folder first.
you can export to another tally - you cannot export to a csv or any other database format
On Monday 07 March 2011 02:18 PM, Kenneth Gonsalves wrote:
On Mon, 2011-03-07 at 12:46 +0530, Rony wrote:
Since the person is using Tally already, it has an export feature.
http://forums.techarena.in/windows-software/1179110.htm
You can put his 'data' folder into someone else's Tally too and then export. Backup that person's 'data' folder first.
you can export to another tally - you cannot export to a csv or any other database format
The link tells about the xls format. After that converting from xls to other formats using OpenOffice should not be very difficult.
On Mon, 2011-03-07 at 23:54 +0530, Rony wrote:
you can export to another tally - you cannot export to a csv or any other database format
The link tells about the xls format. After that converting from xls to other formats using OpenOffice should not be very difficult.
the point is that you cannot get *all* the raw data - you can only get processed data which you have to manually enter into the new system.
the point is that you cannot get *all* the raw data - you can only get processed data which you have to manually enter into the new system.
With ODBC< you should be able to get all your data out of Tally and convert it to a format that is understood by new system. Its trivial to capture it in Excel/Calc/Base and convert it to CSV and similar formats.
-Shamit
Tally9 has XML formats to which it can dump data to. You may use any scripting language to dump this to CSV.
http://mirror.tallysolutions.com/Downloads/TDL%20Developer/Tally.ERP%209%20-... http://mirror.tallysolutions.com/Downloads/TDL%20Developer/Tally.ERP%209%20-%20Integration%20Capabilities.pdf
On Tue, Mar 8, 2011 at 8:37 AM, Shamit Verma subs.linux.mum@vshamit.comwrote:
the point is that you cannot get *all* the raw data - you can only get processed data which you have to manually enter into the new system.
With ODBC< you should be able to get all your data out of Tally and convert it to a format that is understood by new system. Its trivial to capture it in Excel/Calc/Base and convert it to CSV and similar formats.
-Shamit
-
Arun Khan -
Kenneth Gonsalves -
Kussh Singh -
Piyush Ranjan -
Rony -
Shamit Verma