Replies posted by LUKE_PL

2 Replies

M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Data Migration

Migration Job - Export to none-DB machine

Hi, yes it is possible.  Use Oracle directories - You have to have access on operating system level where you have oracle DB to folder where You want save file. I've created quick sample see attached file. Best RegardsLuke 

2
M
Sidekick (Customer)
1 year ago
B
Sidekick (Partner)
BRSASidekick (Partner)
asked in Finance (Financials)

Currency update - UK

Hi @alackas, We have solution for autoupdate currency rates in IFS not UK but for Polish currency rate.The Polish National Bank publishes exchange rates as XML:=>https://www.nbp.pl/kursy/xml/LastA.xmlthen we use google spreadsheet  to import datewe use standard functionality:=IMPORTXML("https://www.nbp.pl/kursy/xml/LastA.xml?0.9803928828938182";"//pozycja")=IMPORTXML("https://www.nbp.pl/kursy/xml/LastA.xml?0.9803928828938182";"/tabela_kursow/data_publikacji")xml is changed to flat file  then CVS is generated : =TEXTJOIN( ;True;(Kursy_auto_update_XML!F1&";"&Kursy_auto_update_XML!I1&";");Kursy_auto_update_XML!$H$1+1)google tools script   / script is scheduled to update currency function getData() {  var queryString = Math.random();  var cellFunction1 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('A1').getValue() + '?' + queryString + '";"'+ SpreadsheetApp.getActiveSheet().getRange('A2').getValue() + '")';  SpreadsheetApp.getActiveSheet().getRange('D1').setVal

6
C
Do Gooder (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings