[R] Pull data from Tally 9.1 to R studio

[jagan krishnan]

Hi,
Really appreciate your guidance...I tried google searches before posting here, but may be I am wrong...that's why I thought of getting this forum's guidance...
Going through the links shared here..I think I can take up my first task in R with some confidence...
Really this is not a sarcastic mail without comic scan font and smileys..
Could not believe you guys will be this much tough in your words when somebody is just starting something in R...
With Regards,Jagannathan Krishnan

Sent from Yahoo Mail on Android 
 
  On Thu, Aug 24, 2017 at 10:36 PM, Marc Schwartz<marc_schwartz at me.com> wrote:   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/
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
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
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

On the R side, there is the R Data Import/Export Manual here:
  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

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]]