SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 10 of 10
  1. #1
    Member
    Join Date
    Mar 2007
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    How can i get name of all items of a weblist.

    How can i get name of all items of a weblist.

  2. #2
    Senior Member
    Join Date
    Feb 2006
    Location
    Bangalore
    Posts
    593
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    GetROProperty("all items")
    Vengat Ramanan.R

  3. #3
    Member
    Join Date
    Mar 2007
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    Thanks Vengat

    how can i send these names in result.

  4. #4
    Senior Member
    Join Date
    Feb 2006
    Location
    Bangalore
    Posts
    593
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    "how can i send these names in result. ?"

    I believe this is what you need.


    x=obj.GetROProperty("all items")
    Reporter.ReportEvent micPass,"Test Pass","The result--->"&x
    Vengat Ramanan.R

  5. #5
    Member
    Join Date
    Mar 2007
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    Exactly Vengat

    but in my case x contians values like

    Select Movie;BHEJA FRY;Cheeni Kum;Ek Chalis Ki Last Local;Good Boy Bad Boy;Life in a Metro;ShootOut At Lokhandwala;Spiderman 3 Hindi;Ta Ra Rum Pum

    how can i remove Select Movie from result.

  6. #6
    Senior Member
    Join Date
    Feb 2006
    Location
    Bangalore
    Posts
    593
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    y="Ek Chalis Ki Last Local;"

    If InStr(x,y)<>0 Then
    MyStr=Replace(x,y,"")
    End If

    Use MyStr in Reporter obj
    Vengat Ramanan.R

  7. #7
    Senior Member
    Join Date
    Feb 2006
    Location
    Bangalore
    Posts
    593
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    str="Select Movie;BHEJA FRY;Cheeni Kum;Ek Chalis Ki Last Local;Good Boy Bad Boy;Life in a Metro;ShootOut At Lokhandwala;Spiderman 3 Hindi;Ta Ra Rum Pum"
    r=Replace(str,"Ek Chalis Ki Last Local;","")
    Msgbox r
    Vengat Ramanan.R

  8. #8
    Member
    Join Date
    Mar 2007
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    Thanks a lot...Vengat

  9. #9
    Member
    Join Date
    May 2007
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    How do i export this to excel.for example if i get a;c;v; thro GetROProperty("all items").I need to get "a" in one excel cell, "c" in another excel cell and "v" in another excel cell.

  10. #10
    Member
    Join Date
    Jun 2007
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How can i get name of all items of a weblist.

    I hope this can be used to write the values from web list to local sheet

    strAllitems = obj.GetROProperty("all items")
    arrEachitem = Split(strAllitems, ";", -1)

    For i=0 to Ubound(arrEachitem)-1
    datatable.setcurrentrow(i+1)
    datatable.Value("itemname", dtlocalsheet) = arrEachitem(i)
    Next

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 6.67%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 11:53 PM.

Copyright BetaSoft Inc.