Is there any existing way to Open/Read/Extract information from rssengine.fdb file?
I am looking for a way to use the rssengine.fdb file in another .NET app that I am developing. Will you allow such use? If not, is there a way to export feeds to CSV or Excel or some other file type from FeedReader program?
Thanks for your reply.
It was my mistake! I was querying All Rows WHERE DELETED = 1. The thing is, all rows that are marked for DELTED(=1) do not have any TITLE text. That's why I was getting empty string.
Anyway, if my finding helps anyone, I will be happy.
By the way, I have created a small .NET application that would delete orphan or other articles. If anyone interested feel free to email me : Mehdi.Anis@gMail.Com
Regards,
Mehdi Anis
Sorry, for the late replay
Yes, you are correct, valid articles are, where deleted field = 0
Those deleted(marked) records will be removed after some. Those records are empty (body,title,summary = ''), only guid, md5 is preserved.
Why this delete record is preserved?
For example you take some feed, todays news there are some items that you don't like. You will delete them. But tomorroy those articles are still in the feed, FR must keep track, ok those articles are in feed, but they are deleted.
If we delete those records, then you may receive again deleted records as "new" articles.
Best way to keep DB small, is to run FR backup utility. (Tidy up database) this will remove deleted records (that are safe to delete).
If you do also fullbackup and restore, then you have clean(unfragmented) DB.
Also feed and article title db field is varchar(512) utf8 collation.
But, every new FR utility is welcome;)))
Ingmar
------
FR dev
Hi,
Now, I understand why the articles were saved without Title - I guessed something like that too.
About "Best way to keep DB small, is to run FR backup utility. (Tidy up database) this will remove deleted records"
I think: I am using FR from 3.08 to 3.11. I have merged/imported OPML files several times. Moreover, i have experienced DB corruption few times. So some how Backup/TidyUp was not clearing old deleted articles. Once I used my app to clean those orphan articles Backup/Tidyup is working just fine - making my app obsolete :(
My guess is, if Backup/Tidyup is not reducing DB size then there is some problem. It is necessary to delete the orphan articles manually for once. I hope not too many people are in this situation. Thanks.
Mehdi Anis
"Backup/Tidyup is working just fine - making my app obsolete :("
No sad faces;)
You can always create new utilities that are working better then FR's:))
We decided, that we'll include in FR3.12 new feature,
when computer is onidle (no keyboard, mouse activity - for example 30 min),
then once in a day cleaning is triggered. Maybe also automatic backup.
So we are trying to give our best;)
Ingmar
------
FR dev
Hi,
I made a mistake in my earlier post. The TITLE filed is varchar(2048), but the LINK filed is varchar(4000)
So, LINK field which is 4000 char max is being read by the .NET adapter. But TITLE field, which is 2048 char max long, is not being read. So, definitely it is not the MAX length issue. By the way, none of TITLE or LINK has any value that is that LONG.
So, I am at a loss now. Why can't my .NET app show the TITLE field?
Any help will be appreciated. Thanks.
Regards,
Mehdi Anis
Cool reader...
but why i cant use export options? xml or html or csv...
or better get ac?ess to data base using working login and password...
(not SYSDBA and masterkey)?
Username for database is SYSDBA and password is MASTERKEY. This is standard Firebird SQL Server username.
Thanks for UserName/Password. Now I could open the database in my .NET app. I can read the ARTICLES table. Unfortunately, for some reason I can't get the TITLE field. Title Field for all rows returns Empty.
I am using: FirebirdSql.Data.FirebirdClient.dll
Ver: 2.5.0.0
Code part:
======================================
Dim CmdString As String = "SELECT ARTICLES.ID AS ID, FEEDS.TITLE AS FEED, ARTICLES.CREATED AS CREATED, " & _
"ARTICLES.TITLE AS TOPIC, ARTICLES.LINK AS LINK FROM ARTICLES LEFT JOIN FEEDS on ARTICLES.FEED_ID " & _
"= FEEDS.FEED_ID WHERE " & WhereClause
Dim FdbCmd As New FbCommand(CmdString, FdbConn)
Dim myDataAdapter As New FbDataAdapter(FdbCmd)
Try
Dim custDS As DataSet = New DataSet
myDataAdapter.Fill(custDS, "ARTICLES")
==========================================
I get ID, Created, Feeds, Link but no text for TITLE. If I use, Marathon software I can see the Text for TITLE column. Title field is nvarchar(4000), is it too big for .NET provider?
It's not a FeedReader's bug or problem. But if some one can help me as volunteer basis that will be great. Thanks for your time.
Regards,
Mehdi Anis
How can I get UserName and PassWord to conenct to FeedReader's Database, 'rssengine.fdb' ?
Is there any default username/password that I can use from a .NET app?
OPML export or read directly from DB
http://www.firebirdsql.org/index.php?op=files&id=netprovider
Ingmar
Thanks for sharing the link
http://www.firebirdsql.org/index.php?op=files&id=netprovider
which helps opening a FireBird database from .NET and other application. I tried the .NET plug-ins and ODBC driver. It works with a FireBird database.
But the FeedReader's database 'rssengine.fdb' is password protected. I can not access the FeedReader database with the Default FireBird username/password.
I do not know the UserName/Password to conenct to FeedReader's database.
Advance thanks for ideas.
bjtoglg
zasunza