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