mdc101
Fellow UBotter-
Content Count
119 -
Joined
-
Last visited
-
Days Won
2
mdc101 last won the day on March 7 2012
mdc101 had the most liked content!
Community Reputation
15 GoodAbout mdc101
-
Rank
Advanced Member
Profile Information
-
Gender
Not Telling
System Specs
-
OS
Windows 8
-
Total Memory
4Gb
-
Framework
v4.0
-
License
Developer Edition
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
OK figured this one out When you create the insert statement you must wrap the number with the FORMAT function example FORMAT(column_name,2)
-
HI guys I'm doing a simple insert into a database table from a ubot table using table cells. In the ubot table I see 13.2 as an example. Using set the insert statement is generated as seen two lines down. When I run the insert into mySql table the decimal is dropped and the value is rounded down to 13. #inset_record: INSERT INTO sometable ( sometable.profileid, sometable.theme_keywords, sometable.ID, sometable.Flag, sometable.kwSource, sometable.LARI, sometable.PPC_CostclickMonthly, sometable.PPC_clickMonthly, sometable.TrafficForecast, sometable.CompetingPages ) VALUES ( '5060', 'dysfunction'
-
@YuraB That worked perfectly, Thanks for all the help. Your a Legend. I was not aware one could place conditions within a scrape. (tagname="td" AND class="cluster-name") I am assuming this has to be hard coded?
-
Hi Thanks for the response The code is working 95%! What it does is it grabs the first row of the ignore list <td class="cluster-name" style="text-align: left"> <a href="http://subdomain.domin.com/blueprints/2088/nodes/40937">buy beer making kits online</a></td> Any idea why this is happening?
-
Hi Guys There is a number of rows in a table. How do I scrape the url into one list & the anchor text into another list The rows I want to scrape contain a <span title="Number of active keywords">(*)</span>. Rows to be ignored don't have the span <span title="Number of active keywords">(*)</span> (20) is a number that changes Scrape URL ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ <td class="cluster-name" style="text-align: left">
-
Thanks guys for the feed back Matt
-
Hi Guys Does anyone know how to insert a screenshot into a mysql database blob field? So basically the idea is ubot goes to page does the screen grab and then inserts it into the database. Is this possible?
-
Hi Guys thanks for the response The application is saas based and you need to login to access the page. So cant give reference url If you wrapped the <ol> her html head and body you will basically get the page output Oricoun I will try your suggestion. Ubotbuddy, would love to see what you do Regards Matt
-
Hi Guys Been knocking me head against a wall for a few days and cannot figure this out. I have the following page I want to scrape attached. There are 10 <li></li> tags holding ranking information I need. Each <li></li> tag is separated by a <hr> tag. I am wanting to scrape the following below form each <li></li> tag and want to add it to table highlighted in orange so I can insert into a database. How does one scrape this data so all rows stay precise and don't get mixed up? Thanks Matt <li> <b>www.clipinhair.co.za</
-
Found a work around I only used multiply. I removed the $eval() and it worked
-
Thanks for the reply. This is so annoying so why was it working before the update to 5.7. I working with competing pages and I use the the competing pages number x 10 as a ceiling for me to do analysis. I have never had this issue in the last 4 years and now that I need the functionality at a critical point in a project the update stuffs up the math functions. Is there a way to calculate the number I need using JavaScript?
-
Hi Kev Any work arounds?
-
Hi Guys Anyone having an issue with the eval multiply reults? I get odd results like "8.73e+006" The eval math function is not working. A basic math sum like 873000 * 10 = 8.73e+006 It should be 8730000 Im sure it not the code. Started happening since 5.7 update Is it just me or is there an actual bug? if($comparison($scrape attribute($element offset(<style="text-align: right">, 0), "innertext"), "=", $nothing)) { then { set(#Psys_ptkw_cmp, 0, "Global") set(#Psys_ptkw_cmp, 2000000, "Global") set(#Psys_ptkw_cmp, $replace($trim(#Psys_ptkw_cmp), ",", $nothing), "Global") set(#Psys
-
I figured out why things where running so slow. The logging was on and as soon as i turned logging off the bot flew as expected. Thanks blumi for the pointers earlier
-
The indexes and changes suggested shaved of 10 seconds, thanks for the tip