exporting all news articles in all languages via SQL

Posted by talal on 26-Dec-2018 19:43

i have SiteFinity 6

I need to export all latest version of each published news article.

I have articles in multiple languages.

the least needed:

- id (for future reference)

- language

- subject

- Summary

- article body (content)

Would be super if the URL links are converted to full links (absolute) for images and pdf

Help would be very appreciated. I am very stuck

Sitefinity - General Discussions

All Replies

Posted by talal on 02-Jan-2019 18:26

any help would be VERY appreciated. stuck for a month here :'(

Posted by talal on 08-Jan-2019 22:30

plz help

Posted by mujji on 09-Jan-2019 04:55

Brother check if you can get any help from this link

Link:  success.scribesoft.com/s/article/Exporting-Data-From-SQL-Server-Into-A-Script-File

Posted by talal on 09-Jan-2019 05:53

Thank you for the link but it's not what i needed. I was looking for the sql statement to get the latest version of all news in all languages. For example:

Subject, summary, content, language, id

Posted by talal on 20-Jan-2019 19:50

anyone?

This thread is closed