[R] R and factorytalk historian

[PIKAL Petr]

Hi

Yes, there should not be any problem with transfering data from Excel to R.

However my trust to Excel is not big, therefore I wanted to avoid such unnecessary intermediate step. But according to FTH lecturers they do not know about any option for direct export to csv or other suitable data format.

It seems that nobody has experience with direct connection FTH to R, so I would like to thank all for their answers and I would consider this topic closed.

Cheers
Petr

> -----Original Message-----
> From: R-help <r-help-bounces using r-project.org> On Behalf Of Hasan Diwan
> Sent: Wednesday, December 12, 2018 8:21 PM
> To: R Project Help <r-help using r-project.org>
> Subject: Re: [R] R and factorytalk historian
>
> Could you not script Excel to export automatically to CSV --
> https://stackoverflow.com/a/10803229/783412, for example -- and import the
> result into R? -- H
>
> On Wed, 12 Dec 2018 at 07:17, PIKAL Petr <petr.pikal using precheza.cz> wrote:
>
> > Hi
> >
> > Well, the final answer is that data from FTH could be transfered to
> > other software **only** through Excel.
> >
> > Regarding RetroEncabulator, readings could be enahanced by extensive
> > and elaborate use of nanoputian molecules chained together.
> >
> > Cheers
> > Petr
> >
> > > -----Original Message-----
> > > From: Viechtbauer, Wolfgang (SP)
> > > <wolfgang.viechtbauer using maastrichtuniversity.nl>
> > > Sent: Wednesday, December 12, 2018 11:21 AM
> > > To: PIKAL Petr <petr.pikal using precheza.cz>; r-help
> > > <r-help using r-project.org>
> > > Subject: RE: R and factorytalk historian
> > >
> > > Dear Petr,
> > >
> > > Sorry, no experience with the FTH, but related to this, has anybody
> > gotten R to
> > > interface nicely with the Retro Encabulator, providing live read
> > > outs of
> > the
> > > synchronizing cardinal grammeters?
> > >
> > > (my apologies, I just couldn't resist)
> > >
> > > Best,
> > > Wolfgang
> > >
> > > >-----Original Message-----
> > > >From: R-help [mailto:r-help-bounces using r-project.org] On Behalf Of
> > > >PIKAL Petr
> > > >Sent: Tuesday, 11 December, 2018 16:09
> > > >To: r-help
> > > >Subject: [R] R and factorytalk historian
> > > >
> > > >Hallo all
> > > >
> > > >Does anybody know if R could be used directly with FactoryTalk
> > > >Historian programme from Rockwell automation.
> > > >
> > > >It is probably possible to use Excel as interface but I would
> > > >prefer not to.
> > > >
> > > >Best regards.
> > > >
> > > >Petr Pikal
> > Osobní údaje: Informace o zpracování a ochraně osobních údajů
> > obchodních partnerů PRECHEZA a.s. jsou zveřejněny na:
> > https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information
> > about processing and protection of business partner’s personal data
> > are available on website:
> > https://www.precheza.cz/en/personal-data-protection-principles/
> > Důvěrnost: Tento e-mail a jakékoliv k němu připojené dokumenty jsou
> > důvěrné a podléhají tomuto právně závaznému prohláąení o vyloučení
> > odpovědnosti: https://www.precheza.cz/01-dovetek/ | This email and any
> > documents attached to it may be confidential and are subject to the
> > legally binding disclaimer: https://www.precheza.cz/en/01-disclaimer/
> >
> > ______________________________________________
> > R-help using 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.
> >
>
>
> --
> OpenPGP:
> https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1
> If you wish to request my time, please do so using
> *bit.ly/hd1AppointmentRequest <http://bit.ly/hd1AppointmentRequest>*.
> Si vous voudrais faire connnaisance, allez a *bit.ly/hd1AppointmentRequest
> <http://bit.ly/hd1AppointmentRequest>*.
>
> <https://sks-
> keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent
> from my mobile device
> Envoye de mon portable
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using 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.
Osobní údaje: Informace o zpracování a ochraně osobních údajů obchodních partnerů PRECHEZA a.s. jsou zveřejněny na: https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information about processing and protection of business partner’s personal data are available on website: https://www.precheza.cz/en/personal-data-protection-principles/
Důvěrnost: Tento e-mail a jakékoliv k němu připojené dokumenty jsou důvěrné a podléhají tomuto právně závaznému prohláąení o vyloučení odpovědnosti: https://www.precheza.cz/01-dovetek/ | This email and any documents attached to it may be confidential and are subject to the legally binding disclaimer: https://www.precheza.cz/en/01-disclaimer/