The main idea is to be able to do online feed export from Chanel to Access Data base. There is no sample to do this on your help system. I assume this would be usefull future also for many other Awasu users. I bought Awasu professional Edition mainly becouse of your keywords seek and hook control! These two functionalities makes Awasu World top RSS reader at least for me! The questions are as followes:
1.) In case feed provide additional metadata: Is it possible to use all additional metadata in feed export to Access? For Example beside standard data: Title, Desription and URL I would also like to export stock ticker which is stored in column »category«.
Let's try feed bellow in MC Explorer (enter the link bellow to MC Exporer URL) you will see on the right of the screen categories. I would like to use this data in Awasu Export too..
http://new.marketwire.com/rss/BreakingN ... nglish.xml
You replied that bellow can be set:
http://www.awasu.com/help/2.3/hh_start. ... dules.html
a.) In case above is selected: Are all those fields can be used also in a hook?
b.) In case there are other matadata not listed on the link above: Is possible to use these additional fields in a hook - ini file data store?
2.) According to Awasu userguide, hook data exports using ini file philosphy. The question is: What is the name of the file and Where on file system the file is stored? I would like to open the file with Wordpad to see what is inside. Of course I need also to specify in vb code the name and location of that file.
In your Pyton example sys.argv is used. I can not find anything with such name on my PC.
# get the name of the INI file
configFilename = sys.argv
In short what should be written in vb code (look bellow configFilename=) to open the file Awasu is using for Data Exports.
Regarding Awasus file system you provided the file locations list:
http://www.awasu.com/help/2.3/hh_start. ... ayout.html
However I can not locate ApplicationData directory (XP). What needs to be done to come to this (probably some file filtering is on)? Plus which file there is so called ini for data transfer?
Your software is great. Not being able to master hook functionality is not acceptable as this is realy cool thing! I DO HOPE we will finally beat the problem. The quickes will be if you directly amand the code bellow and let me know where ini file can be find to be able to open it with Notepade..
Dim configFilename As String
Dim NAME As String
Dim DESCRIPTION As String
Dim URL As String
Dim PUBLISHED As String
Dim CATEGORY As String
Dim ConfigFilename As String
'Function for reading data from INI file
Declare Function GetPrivateProfileSection Lib "kernel32" _
Alias "GetPrivateProfileSectionA" _
(ByVal sSectionName As String, _
ByVal sReturnedString As String, _
ByVal lSize As Long, _
ByVal sFileName As String) As Long
' get the name of the INI file
configFilename = sys.argv
' get channel parameters
NAME = GetprivateProfileSection("ChannelParameters","Name",100,configFilename)
DESCRIPTION = GetprivateProfileSection("ChannelParameters","Description",10000,configFilename)
URL = GetprivateProfileSection("ChannelParameters","URL",1000,configFilename)
PUBLISHED = GetprivateProfileSection("ChannelParameters","Published",50,configFilename)
CATEGORY = GetprivateProfileSection("ChannelParameters","Category",50,configFilename)
set MyDB = CreateObject("ADODB.Connection")
SQLString ="INSERT INTO TBL_StockNews (Title,Description,Link,PublishTime,Ticker) VALUES ('" & NAME & "','" & DESCRIPTION & "','" & URL & "','" & PUBLISHED & "', '" & CATEGORY & "')"
set Action = MyDB.Execute(SQLString)
DisplayName=Export Data to Access.mdb
Notes=Export News to Access plus run sub vbcode for further stock data checking
Description=News Stock Ticker