exporting all news articles in all languages via SQL - General Discussions - General Discussions - Progress Community
 General Discussions

exporting all news articles in all languages via SQL

  • 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

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

  • plz help

  • 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

  • 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