Mesut Kahraman
Oct 28, 2020 12:06 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
Hello, I want to take exchange rates of Georgia Bank.But I didn't find URL.What is the XML Url of Georgia Bank?
Profile
Aleksandr Biryukov
Oct 30, 2020 09:44 AM
Administrator
Points:: 0
Joined:: Oct 3, 2019
Hello Mesut, can you give a link to the website of the bank with which you want to make an exchange?
Profile
Samir Muqimov
Oct 30, 2020 10:36 AM
Active user
Points:: 0
Joined:: Aug 28, 2015
Hello. Here's the link. Go to this link and you will find all the rates from National Bank of Georgia.https://www.nbg.gov.ge/rss.php
Profile
Mesut Kahraman
Oct 30, 2020 03:19 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
There is a function for Turkey Bank.I have changed Url with Georgia Bank.How can I set date part in the URL. Function GetValidResult(Val CurrDate) // "https://www.tcmb.gov.tr/kurlar/" + str1 + "/" + str2 + ".xml" While True Do str1 = Format(CurrDate ,"DF=yyyyMM"); str2 = Format(CurrDate ,"DF=ddMMyyyy"); StrFullAddres = "https://www.nbg.gov.ge/rss.php"; XMLFile = GetFilesFromInternet.DownloadFileToTempStorage(StrFullAddres); If XMLFile.Status Then BinaryData = GetFromTempStorage(XMLFile.Path); XML = GetStringFromBinaryData(BinaryData); mXml = New XMLReader; mXml.SetString(XML); Result = XDTOFactory.ReadXML(mXml); mXml.Close(); DeleteFromTempStorage(XMLFile.Path); Return Result; EndIf; CurrDate = AddDay(CurrDate, -1); EndDo; EndFunction
Profile
Samir Muqimov
Oct 30, 2020 03:44 PM
Active user
Points:: 0
Joined:: Aug 28, 2015
Profile
Samir Muqimov
Oct 30, 2020 03:53 PM
Active user
Points:: 0
Joined:: Aug 28, 2015
For more info you can contact their tech support. I guess they'll help you.
Profile
Mesut Kahraman
Oct 30, 2020 05:04 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
Okey thank you very much!
Profile
Mesut Kahraman
Nov 23, 2020 05:45 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
You said a link about exchanges rate of Georgia Bank.But it is not What I want.I need an address that I can send date parameters and I can take data in order to dates. I have searched it and also send a email to Georgia Bank but, Both I didn't find it and Georgia Bank has not reply the email.Can you help me please?
Profile
Mesut Kahraman
Dec 23, 2020 01:58 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
Hello, I want to take exchange rate from Georgia Bank using this XML(https://www.nbg.gov.ge/rss.php ).And then I want to save its date and rates in an information register.How can I write this code?
Profile
Aleksandr Biryukov
Jan 14, 2021 03:01 PM
Administrator
Points:: 0
Joined:: Oct 3, 2019
Hi Mesut, you need to parse this XML file - the structure of this file is very simple (please see screenshot 1). After that you can find the currency you are interested in, for example, the Turkish lira and its rate in relation to the Georgian currency (screen 2). Aleksandr
Profile
Mesut Kahraman
Jan 14, 2021 03:23 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
I dont know how to take rates from XML or parsing.Have you any examples or courses about this topic.
Profile
Aleksandr Biryukov
Feb 18, 2021 05:34 PM
Administrator
Points:: 0
Joined:: Oct 3, 2019
Hello Mesut, we have posted a small example of how you can get currency rates from the website of the Bank of Georgia: https://1c-dn.com/blog/parsing-a-site-using-1c/ If you have any questions, please ask.
Profile
Mesut Kahraman
Feb 19, 2021 04:41 PM
Interested
Points:: 0
Joined:: Sep 30, 2020
Thank you very much.You must be work very hard.I am going to try to get exchange rates using this link.
Profile
Subscribe