[R] Pull data from Tally 9.1 to R studio

[Marc Schwartz]

Hi,

Inline below.


> On Aug 24, 2017, at 5:22 AM, John Kane via R-help <r-help at r-project.org> wrote:
> 
> 
> IIt might help to read the material at one or both of these links http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
> 

<snip>

In this case, had Jagan spent about 30 seconds Googling for the application developer's site, he would have found that Tally software has a support page here:

  https://tallysolutions.com/support/ <https://tallysolutions.com/support/>

and that using the online help that they provide, searching for "export data":

  https://help.tallysolutions.com/tallyweb/modules/pss/crm/kb/search/CKBTallyHelpSearchWIC.php#searchPage=1&searchString=export%20data <https://help.tallysolutions.com/tallyweb/modules/pss/crm/kb/search/CKBTallyHelpSearchWIC.php#searchPage=1&searchString=export data>

he would find the following article in the initial set of returned hits that appears to describe the export file formats that Tally supports:

  https://help.tallysolutions.com/article/te9rel60/Data_Management/Export_of_Data_Intro.htm <https://help.tallysolutions.com/article/te9rel60/Data_Management/Export_of_Data_Intro.htm>

One of which is CSV files, which can then be imported into R, using ?read.csv.

He might have also been able to quickly obtain similar guidance from his own IT support folks who presumably support the Tally ERP installation or from Tally directly. The initial step is less about R specifically and more about how to get data out of Tally's database in an industry standard format.

If Tally supports any kind of direct API or other interface (e.g. ODBC or similar), Jagan would need to pursue that conversation with his IT folks and/or Tally and to see if there would be a way for R to interface with that path. Also, importantly, whether or not under any restricted IT access policies, that would even be allowed. Many companies restrict such access for security reasons.

Another Google search would suggest that Tally uses a proprietary database engine and language, but that some interfaces (e.g. ODBC) may exist, if enabled locally.

  http://www.tallysolutions.com/website/html/tallydeveloper/architecture-series-a.php <http://www.tallysolutions.com/website/html/tallydeveloper/architecture-series-a.php>


On the R side, there is the R Data Import/Export Manual here:

  https://cran.r-project.org/manuals.html <https://cran.r-project.org/manuals.html>

which provides additional general insight into R's import/export capabilities.


The R Posting Guide, as has been mentioned, is a good resource, as is the Getting Help With R page, linked on the main R Project page:

  https://www.r-project.org/help.html <https://www.r-project.org/help.html>


Regards,

Marc Schwartz




> 
> On Thursday, August 24, 2017, 6:19:25 AM EDT, John Kane <jrkrideau at yahoo.ca> wrote:
> 
> 
> 
> 
> On Thursday, August 24, 2017, 1:50:13 AM EDT, David Winsemius <dwinsemius at comcast.net> wrote:
> 
> 
>> On Aug 22, 2017, at 11:31 PM, jagan krishnan via R-help <r-help at r-project.org> wrote:
>> 
>> Hi all,
>> This is Jagan.i have been provided a task of analyzing sales data of a company in R programming...Just wanted to know,how can I pull Tally 9.1 software data into R programming dataframe.
>> Waiting eagerly for your inputs.
>> With Regards,Jagannathan Krishnan
>> Sent from Yahoo Mail on Android 
>> 
>>   On Tue, Aug 22, 2017 at 10:47 AM, jagan krishnan<jagan.krishnan at yahoo.co.in> wrote:  Hi all,
>> This is Jagan.i have been provided a task of analyzing sales data of a company in R programming...Just wanted to know,how can I pull Tally 9.1 software data into R programming dataframe.
>> Waiting eagerly for your inputs.
> 
> Are we supposed to know what "Tally 9.1 software data" might look like?
> Of course. Just download Tally 9.1, stick in some data  and you're away.
> A quick google shows it is accounting software.
> 
> 
>> With Regards,Jagannathan Krishnan
>> 
>> Sent from Yahoo Mail on Android  
>> 
>>     [[alternative HTML version deleted]]
> 
> A Posting Guide was prepared for you. I suggest that you should read it.
> 
>> 
>> ______________________________________________
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
> 
> David Winsemius
> Alameda, CA, USA
> 
> 'Any technology distinguishable from magic is insufficiently advanced.'  -Gehm's Corollary to Clarke's Third Law


	[[alternative HTML version deleted]]