3 Replies Latest reply: Oct 21, 2010 5:25 PM by Community Administrator RSS

    How to accumulate website-data in a .qvw

    SebastianL

      Hey,

      I still use a demo version and can call myself proud a "real beginner".

      I managed to read the german stockmarket-index DAX from the website of the "Deutsche Börse", with the coresponding time/date in a field.

      Each time I run the script (as attached), I "overwrite" the value.

      How can I "accumulate"/ ass the values to the qvw each time I run the script and the date-time-field changes?

      Is it possible to run the script every minute or though?

      best wishes,

      S., happy with his first step, hoping to do the second now :)

      --

      SET ThousandSep='.';
      SET DecimalSep=',';
      SET MoneyThousandSep='.';
      SET MoneyDecimalSep=',';
      SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
      SET TimeFormat='hh:mm:ss';
      SET DateFormat='DD.MM.YYYY';
      SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
      SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
      SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';


      TabelleDax:
      LOAD [Letzter Stand],
      [Datum, Zeit]
      FROM
      [http://deutsche-boerse.com/bf4dbag/DE/export/export.aspx?module=priceinfo&isin=DE0008469008&navpath=http://deutsche-boerse.com/dbag/dispatch/de/isg/gdb_navigation/home]
      (html, codepage is 1252, embedded labels, table is @1, filters(
      Transpose()
      ));