Insert news in feeds.db

5 posts / 0 new
Last post
Sheldon

Hi, ,

to import data for my individual feeds I use a local
RSS 2.0 formatted XML as well as an
insert in table news in feeds.db. That all works fine.
But I face a small problem with the insert where I would appreciate your help.

The insert takes place before the QuiteRSS app is launched.
After the launch I always face the problem that the feed I inserted
the data for isn't marked to contain new unread news, the news counter equals 0 and the just inserted news are not displayed.
After I clicked on the feed it is marked to contain new unread news, the new data is displayed and the news counters are set properly. So everything is updated and fine.

So which fields in which table do I have to set how for the insert
to make QuiteRSS display the data correctly after the launch?
.
You can provide SQL if you like and if it's easier for you.

Kind regards,

Sheldon

Funcy-dcm
Hi,

Hi,

Table "news": set value in column "new = 2", "read = 0" for new news. Table "feeds": update value in column "unread", "newCount", "undeleteCount"  

Sheldon
Thanks!

Thanks!

The settings for table "news" are as I did it.

The settings for table "feeds" are what i expected already but what are the values?

Field "unread":
Is it a flag (0 or 1): or is it the count of unread news?

Field "newCount"
Which count is expected here? Count of new news records or count of unread news records? Currently I don't set the new flag in table news.

What about parent feeds?

.

Sheldon
Now it works!

Now it works!

After setting the flag "new" to 1 for the inserted news and updating "unread" with the new count of unread news and "newCount" with the new count of new news in the feed and all its parents the numbers are displayed correctly!

Thanks!

Sheldon
Just for my understanding!

Just for my understanding!

What is the difference between setting "new = 1" and "new = 2" in table news?
If i set "new = 1" everything works fine. Setting "new = 2" causes problems.

Currently I don't set "undeleteCount" in table feeds without any problems.
I guess it contains the count of news.with setting "deleted = 0".
Due to me handling the deletion of records myself I guess I can ignore it..