WInCC Runtime advance - Write data to Excel file

Поделиться
HTML-код
  • Опубликовано: 18 сен 2024

Комментарии • 47

  • @hammadahmed1734
    @hammadahmed1734 3 года назад +1

    this video made my problem solved.. Thankyou

  • @arvindvashistha3337
    @arvindvashistha3337 Год назад

    really very informative video . thanks a lot sir

  • @tanquan1829
    @tanquan1829 Год назад +1

    Hi,
    For this export, can I create a new excel for new data?

  • @nisargjk1
    @nisargjk1 4 года назад +1

    Very helpful

  • @vikassharma-eb3cx
    @vikassharma-eb3cx 2 года назад +1

    Sir if i want next data record in same excel file next row than what will be the scrips

  • @luanmanh2602
    @luanmanh2602 4 года назад +1

    Very helpful ! how to auto creat file report every hour or day ...? thanks you.

    • @StableAutomation
      @StableAutomation  4 года назад +1

      Define in Scheduled Task of WinCC and set 'Trigger' as per your requirement.

    • @luanmanh2602
      @luanmanh2602 4 года назад

      @@StableAutomation thanks you verymuch ! that Trigger replace "timerrunning" in my code : Sub export_timedata(ByVal timerrunning) ?

    • @luanmanh2602
      @luanmanh2602 4 года назад +2

      I'm understand .I did it . thanks you verymuch !

    • @vpnautomation4108
      @vpnautomation4108 4 года назад

      this schedule task working but old valve not updating ... for example 1,2,3.... this format not working last mint only update ... 5 mini data logging last mint only logging ... how will log every mints logging

    • @danhthai1890
      @danhthai1890 4 года назад

      @@luanmanh2602 how to auto create report every time? please help me. Thanks you

  • @milosantovic682
    @milosantovic682 3 года назад

    Is it possible to insert data into tag logging DB with timestamp and value (like TLGInsertArchivData in WinCC v7)? Do you maybe have video for it?

    • @StableAutomation
      @StableAutomation  3 года назад +1

      if you log tags into sql using historical log then it logs the data with timestamp. in case you are doing with script , you can create two local tags for date and time and log them with your required tags.

  • @harry3925
    @harry3925 3 года назад

    I have an action prepared with VBS. I have defined a cyclic trigger for this action and it doesn't work at all.
    But when I write thie same script into a button click event, it works fine (within seconds).
    By the way, Global Script Runtime is enabled.
    I am stuck at this point and I really need some help.
    here is my code,same code work fine with button click cmd,but during cyclic tigger it shown Type mismatch: Error line 12

  • @vpnautomation4108
    @vpnautomation4108 4 года назад +1

    fine ... its working good sir but i need automatic logging 1 by one ????

  • @Ultrapromaxxgo
    @Ultrapromaxxgo 2 года назад

    Waiting for part 2 to read data from excel

  • @quyquy4817
    @quyquy4817 7 месяцев назад

    Please give me the code to export the excel file

  • @nobleparti
    @nobleparti 4 года назад

    Sir how write 5 nos plc write data in xl simultaneously

    • @StableAutomation
      @StableAutomation  4 года назад

      I assume you have 5 PLC in network with 1 wincc scada. then same script can be used. just tag number will be different.

  • @saedalhabbashi2790
    @saedalhabbashi2790 7 месяцев назад

    I have used exctly same script! It does not work for me? when I check the excel file says read only I press ok but no data is showing ( been writeen) ? can you help ?

    • @StableAutomation
      @StableAutomation  7 месяцев назад

      it is when you required to log in custom format.. code can be customized as required !

    • @saedalhabbashi2790
      @saedalhabbashi2790 7 месяцев назад

      @@StableAutomation i hope you can help

  • @jacobpronk8412
    @jacobpronk8412 4 года назад

    Thank you so much. This helpend me a great deal! Can you tell me how te make a new excel file everytime i click 'insert' with different (for example the date) name?

    • @StableAutomation
      @StableAutomation  4 года назад +1

      After inserting data , save excel file as new name instead of just save.

    • @РенатИскужин
      @РенатИскужин 3 года назад

      @@StableAutomation You best of the best!)

    • @РенатИскужин
      @РенатИскужин 3 года назад

      @@StableAutomation Can I write the date instead of the file name? I want to run the script once a day and save the file with a new date in the name.

    • @StableAutomation
      @StableAutomation  3 года назад

      @@РенатИскужин Yes..possible.just add the 'date' function in the line where file is getting saved

    • @StableAutomation
      @StableAutomation  3 года назад

      @@РенатИскужин thank you

  • @adelinasimanjuntak3032
    @adelinasimanjuntak3032 4 года назад

    Sir, can we do datalogging from a simulator (not using real PLC)? Thanks.

  • @TungNguyen-og4jh
    @TungNguyen-og4jh 3 года назад

    tks bro

    • @StableAutomation
      @StableAutomation  3 года назад

      Easiest way to do is by logging data into SQL and then export as per your requirement.
      I have ready made tool for that , check this : ruclips.net/video/tyOM2M1jCNM/видео.html

    • @TungNguyen-og4jh
      @TungNguyen-og4jh 3 года назад

      @@StableAutomation Thank you very much. your video very good but I don't know how to update data from Wincc RT Advance by time. Example 1 hour file Excel can auto-update data from Wincc RT. Thank you.

    • @TungNguyen-og4jh
      @TungNguyen-og4jh 3 года назад

      @@StableAutomation Now I can export my data to Excel-file but when I write new data, my new data will replace old data. I don't know how to fix it. I wanna when I update data it's auto down the line. thank you very much.

  • @mehdibessaad3388
    @mehdibessaad3388 4 года назад

    Can you give me. The script please

    • @StableAutomation
      @StableAutomation  4 года назад

      It's already there ,pause video and copy

    • @StableAutomation
      @StableAutomation  4 года назад

      Now you can download from link provided.

    • @dimav649
      @dimav649 Год назад

      @@StableAutomation i can download script only after pay?

  • @krishnaraopawar8037
    @krishnaraopawar8037 4 года назад

    CAN WE KEEP THIS WRITTEN DATA FILE SECURED WITH PASSWORD