[SELL] ★★★ DataGrid UI Plugin ★★★ ➜ Professional Looking DataGrid In Your Main Window

[Pete_UK 9]

With fundamental issue like Dan has shown it sort of puts me off buying the plugin  

[Bot-Factory 602]

With fundamental issue like Dan has shown it sort of puts me off buying the plugin

Pete, the plugin itself works great. This is just a special usecase I need for one of my bots. 

You can still use Ui buttons for that instead of the context menu. And Aymen is a great guy who fixes serious issues like that very quickly.

So this issue shouldn't hold you back.

 

Cheers

Dan

[Gogetta 263]

Can we run normal commands in the content menuitem? Mine will freeze the bot when I try to do something other than a datagrid command. For example if I right click and try to do an alert it just freezes.

 

Edit: It does show up when I force close the program through task manager so it's there it just freezes until I force quit.

 

If we could change individual cell color as well and sort the datagrid by column that would be nice!

 

This problem hasn't been fixed yet.

[Bot-Factory 602]

This problem hasn't been fixed yet.

I think that's similar to what I have reported here:

http://www.ubotstudio.com/forum/index.php?/topic/16658-sell-%E2%98%85%E2%98%85%E2%98%85-datagrid-ui-plugin-%E2%98%85%E2%98%85%E2%98%85-%E2%9E%9C-professional-looking-datagrid-in-your-main-window/page-4&do=findComment&comment=104339

[Gogetta 263]

Aymen, there is a bug or a problem with the "data grid color" command. If you check my video you will see random rows become highlighted when the user scrolls through the grid.

[orbital 15]

Any chance we could get an "auto scroll" feature. This would always keep the current working row visible.

[cob007 19]

If I scrape a lot of information, how do I get them to show up in the data grid cells directly, which command I have to use for that? For example just like the video here below which uses the data grid plugin, so as soon as the user searches for the info, the information shows up in data grid plugin.

 

http://imautobots.com/downloads/competition-checker/

 

 

Also if you see in the video, we are also able to right click on the table cells and go to other URL's, how is that possible using this plugin, couldn't see that in the demo video.( is that a function of file management plugin?)

[Bot-Factory 602]

If I scrape a lot of information, how do I get them to show up in the data grid cells directly, which command I have to use for that? For example just like the video here below which uses the data grid plugin, so as soon as the user searches for the info, the information shows up in data grid plugin.

 

http://imautobots.com/downloads/competition-checker/

 

 

Also if you see in the video, we are also able to right click on the table cells and go to other URL's, how is that possible using this plugin, couldn't see that in the demo video.( is that a function of file management plugin?)

 

If you look through the commands and functions of the plugin you will probably get some of the answers already.

The names are relatively self-explanatory. 

 

You can use the context menu command to add a right click option to the datagrid.

You can convert a table to a datagrid to show your scraped data. 

 

Dan 

[cob007 19]

Hi dan,

 

Thanks for the quick reply, yeah, agreed table to datagrid is the way to do it. But what if my table has 100 rows and columns, and there are many results. Is there a limit to how many grids we can show inside data grid? Moreover what if I want the user to select how may results he wants to see on page (50 results or 100 results) and then he has to click Next and the next 100 results show up, is that possible?

[Pete_UK 9]

I purchased the datagrid plugin the other week and just got round to trying it out.

DataGrid - Styler:
The first thing I tried with this is changing the Column Header Text Color and Background Color. Neither option did anything. The header colors just remained the same. Sort Columns / Resize Columns don't seem to do anything either.

datagrid to csv: Works
csv to datagrid: Doesn't work.

So... do others see the same issues ?

[Aymen 385]

just done testing , everything seems to be working (except the known bugs)!

Did you make sure you used everything correctly ?

[HelloInsomnia 1103]

If I scrape a lot of information, how do I get them to show up in the data grid cells directly, which command I have to use for that? For example just like the video here below which uses the data grid plugin, so as soon as the user searches for the info, the information shows up in data grid plugin.

 

http://imautobots.com/downloads/competition-checker/

 

 

Also if you see in the video, we are also able to right click on the table cells and go to other URL's, how is that possible using this plugin, couldn't see that in the demo video.( is that a function of file management plugin?)

 

It loops for $datagridUI total rows and then it uses datagrid cell edit to update each cell like that. 

 

Oh and for the right click functions I use an on load and then code like this:

plugin command("DataGridUI.dll", "datagrid contextmenu add", "Open URL", "open_website()", "")

Which runs the command open_website who's code would look something like this:

define open_website {
    shell("cmd.exe /c start {$plugin function("DataGridUI.dll", "$datagridUI get value", $plugin function("DataGridUI.dll", "$datagridUI selected index"), "URL")}")
}

Hope this helps you.

[Gogetta 263]

just done testing , everything seems to be working (except the known bugs)!

Did you make sure you used everything correctly ?

 

Aymen, If you check a few post back you will see that I made a small video of a bug i spotted within 24 hours of purchasing this plugin. Can you let me know if I am doing something wrong, or maybe provide an example where the "data grid color" doesn't change to random rows when scrolling through the grid?

[cob007 19]

It loops for $datagridUI total rows and then it uses datagrid cell edit to update each cell like that. 

 

Oh and for the right click functions I use an on load and then code like this:

plugin command("DataGridUI.dll", "datagrid contextmenu add", "Open URL", "open_website()", "")

Which runs the command open_website who's code would look something like this:

define open_website {
    shell("cmd.exe /c start {$plugin function("DataGridUI.dll", "$datagridUI get value", $plugin function("DataGridUI.dll", "$datagridUI selected index"), "URL")}")
}

Hope this helps you.

 

 

HI,

 

Thank for your inputs and I am yet to buy this plugin, so as soon as I buy it will try it.

 

By the way aymen, will there be any christmas deal offers for your plugin, seems like I missed the black friday deas, I would also like to buy your http plugin as well.

[Pete_UK 9]

just done testing , everything seems to be working (except the known bugs)!

Did you make sure you used everything correctly ?

 

Made a short video Aymen... http://screencast.com/t/S4JyVWGG

[Gogetta 263]

Made a short video Aymen... http://screencast.com/t/S4JyVWGG

 

Hey Pete, after watching your video I tried fooling around with the datagrid styler. What I found out is that if you leave the column field blank the header text colors don't work.

 

What I added to the column field and it seemed to work was this.

 

300|300|auto

 

Maybe Aymen can add a default value to this field... Anyway, just wanted to let you know.

[Aymen 385]

Aymen, If you check a few post back you will see that I made a small video of a bug i spotted within 24 hours of purchasing this plugin. Can you let me know if I am doing something wrong, or maybe provide an example where the "data grid color" doesn't change to random rows when scrolling through the grid?

 

Seems like a bug , if you can post it to the bug tracker i'll give it few tests!

 

Made a short video Aymen... http://screencast.com/t/S4JyVWGG

 

Hey Pete , about the styler , like Gogetta said above , the columns width field is mandatory , i'll think about setting default value for that!

about the csv thing , the csv columns should match the datagrid columns!

 

Regards

[Pete_UK 9]

Seems like a bug , if you can post it to the bug tracker i'll give it few tests!

 

 

Hey Pete , about the styler , like Gogetta said above , the columns width field is mandatory , i'll think about setting default value for that!

about the csv thing , the csv columns should match the datagrid columns!

 

Regards

 

 

Got the Styler to work using column sizes. 

 

The csv => datagrid  still not working for me.  Video... http://screencast.com/t/1KIR5IfjvXU

 

Thanks

[orbital 15]

Not sure why this code isn't working. For some reason, the code that executes the datagrid cell edit isn't executing after the http get. When I manually right click on the 'if' and run node it fills in the cell. But does not finish out the command with the context menu click. 

define Check Available {
    set(#tumblrBlog,$plugin function("DataGridUI.dll", "$datagridUI get value", $plugin function("DataGridUI.dll", "$datagridUI selected index"), "URL"),"Global")
    set(#tumblrBlog,$replace($replace(#tumblrBlog,"\"",$nothing),"http://",$nothing),"Global")
    set(#get,$plugin function("HTTP post.dll", "$http get", "http://api.tumblr.com/v2/blog/{#tumblrBlog}/info?api_key=********************************************", $plugin function("HTTP post.dll", "$http useragent string", "Chrome 32.0 Win7 64-bit"), "http://www.google.com", "", 15),"Global")
    if($contains(#get,200)) {
        then {
            plugin command("DataGridUI.dll", "datagrid cell edit", $plugin function("DataGridUI.dll", "$datagridUI selected index"), "Available", "No")
        }
        else {
            plugin command("DataGridUI.dll", "datagrid cell edit", $plugin function("DataGridUI.dll", "$datagridUI selected index"), "Available", "Yes")
        }
    }
}
on load("Bot Loaded") {
    plugin command("DataGridUI.dll", "datagrid contextmenu add", "Check URL", "Check Available()", "")
}

[orbital 15]

Ubot is acting weird tonight. 

 

Now I'm getting a weird error that I can't duplicate except by running a loop. When I manually execute what is inside the loop I don't get the error and everything acts fine. 

define Delete Row {
    set(#curRow,0,"Global")
    loop($plugin function("DataGridUI.dll", "$datagridUI total rows")) {
        if($comparison($plugin function("DataGridUI.dll", "$datagridUI get value", #curRow, "PA"),"<=",#desiredPA)) {
            then {
                plugin command("DataGridUI.dll", "datagrid delete row", #curRow)
            }
            else {
                increment(#curRow)
            }
        }
    }
}

When I run the loop I get this. Here is the error:

Error: This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row.

I then click Continue and it deletes all but one row. Very weird.

 

I did some more digging and saw this:

 

http://screencast.com/t/ArayHPpif

 

Then I found the solution:

 

http://screencast.com/t/qukYRHquH1D

 

I needed to add a wait for the grid to catch up. 

 

Is this normal?

[Gogetta 263]

Are you guys not having problems while running the datagrid within threads? Even while using the STA thread container there's problems where columns aren't being updated. 

[Aymen 385]

Ubot is acting weird tonight. 

 

Now I'm getting a weird error that I can't duplicate except by running a loop. When I manually execute what is inside the loop I don't get the error and everything acts fine. 

define Delete Row {
    set(#curRow,0,"Global")
    loop($plugin function("DataGridUI.dll", "$datagridUI total rows")) {
        if($comparison($plugin function("DataGridUI.dll", "$datagridUI get value", #curRow, "PA"),"<=",#desiredPA)) {
            then {
                plugin command("DataGridUI.dll", "datagrid delete row", #curRow)
            }
            else {
                increment(#curRow)
            }
        }
    }
}

When I run the loop I get this. Here is the error:

Error: This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row.

I then click Continue and it deletes all but one row. Very weird.

 

I did some more digging and saw this:

 

http://screencast.com/t/ArayHPpif

 

Then I found the solution:

 

http://screencast.com/t/qukYRHquH1D

 

I needed to add a wait for the grid to catch up. 

 

Is this normal?

 

Yea it is all due to how ubot and the datagrid are built , Ubot threading system works in a way that it starts a task and sometimes doesn't wait for it to finish and jumps to the next one before it is fully closed! (we are talking milliseconds) so adding a small wait time can help your script to catch up!

 

Are you guys not having problems while running the datagrid within threads? Even while using the STA thread container there's problems where columns aren't being updated. 

 

Do you have something that i can reproduce ?

[Gogetta 263]

Do you have something that i can reproduce ?

 

There are two examples in this script. The second example is the workaround I will be using since it's more reliable when using threads.

 

Unless I am doing something wrong and not using the thread container correctly?

Datagrid Thread Test.ubot

[Macster (UBotter Labs) 112]

hey aymen just noticed that the "in new browser" and "in shared browser" do not work while the datagrid plugin is used. can you please confirm. also it would be great to allow the "in new browser" to be set as invisible while still using the datagrid.

 

Also can you please shoot me the latest version of the plugin when you have time. thank you.

[Aymen 385]

Datagrid UI v1.0.3 Update Released!

Changelog :

-Setting column width is no longer necessary for datagrid styler to work
-sorting fixed , you just need to add ':int' to the column name (for example : "name|password|age:int|country" )
-Added checkbox column , you just need to add ':bool' to the column name (for example : "check:bool|name|password|age:int" )
-Fixed bug when Ubot freezes and grid disappears when running show datagrid command twice