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_schwa...@me.com> wrote: Hi, Inline below. On Aug 24, 2017, at 5:22 AM, John Kane via R-help <r-help@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 <jrkrid...@yahoo.ca> wrote: On Thursday, August 24, 2017, 1:50:13 AM EDT, David Winsemius <dwinsem...@comcast.net> wrote: On Aug 22, 2017, at 11:31 PM, jagan krishnan via R-help <r-help@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.krish...@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@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]] ______________________________________________ R-help@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.
