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 at maastrichtuniversity.nl> > Sent: Wednesday, December 12, 2018 11:21 AM > To: PIKAL Petr <petr.pikal at precheza.cz>; r-help <r-help at 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 at 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 PikalOsobn? ?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/
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 at 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 at maastrichtuniversity.nl> > > Sent: Wednesday, December 12, 2018 11:21 AM > > To: PIKAL Petr <petr.pikal at precheza.cz>; r-help <r-help at 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 at 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 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. >-- 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]]
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 at r-project.org> On Behalf Of Hasan Diwan > Sent: Wednesday, December 12, 2018 8:21 PM > To: R Project Help <r-help at 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 at 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 at maastrichtuniversity.nl> > > > Sent: Wednesday, December 12, 2018 11:21 AM > > > To: PIKAL Petr <petr.pikal at precheza.cz>; r-help > > > <r-help at 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 at 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 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. > > > > > -- > 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 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.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/