--- Log opened Tue Apr 01 00:00:01 2008 --- Day changed Tue Apr 01 2008 00:00 < perlmonkey2> or at least a vibrant solution 00:00 < perlmonkey2> project 00:00 <@preaction> not really. a lot of OSS projects do this same thing, not sure how they solve the upgrade / data problem though 00:01 < perlmonkey2> preaction: doh, I meant the JT being pretty easy about new stuff. 00:01 <@preaction> oh 00:01 <@preaction> also not really 00:01 <@preaction> but yeah, those projects don't last long 00:02 <@preaction> the early PHP CMS systems, for example 00:03 < perlmonkey2> Too bad any of them survived. 00:03 -!- topsub [n=topsub20@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 00:03 -!- topsub [n=topsub20@cpe-071-071-252-225.carolina.res.rr.com] has quit [Client Quit] 00:03 <@preaction> i think we're on the second generation of those things at least 00:06 < SynQ> http://www.webgui.org/etcetera/mssql---data-form-report languages are cool to play with :) 00:09 -!- jfluhmann [n=jfluhman@x172y028.angelo.edu] has joined #webgui 00:26 < perlmonkey2> If a survey editor selects to have questions show up on a section page. Should the section be shown for every question in that section? or if all the questions don't show up in the first page, just show the questions on the next reload? I'm thinking if they want questions to appear with a section's text, they want all the questions in that section to have that text? 00:27 <+perlDreamer> I'd think so 00:27 <+perlDreamer> I probably would have made it survey wide, too, instead of section by section 00:28 < perlmonkey2> hmm...some sections you might want questions to appear along with, others you might not? 00:29 < perlmonkey2> although I guess you could set it survey wide and then any sections you need to only show text and no questions, just don't put any questions in that section. 00:30 < perlmonkey2> when it has been 15 years since you've heard any Motley Crew and then you all of a sudden realize they are in your MP3 collection, then, and only then, do you really wish your amp went to 11. 00:32 <+perlDreamer> I thought your amp only goes to 11 if you listen to Spinal Tap? 00:39 < perlmonkey2> heh 00:41 -!- estiven [n=estiven@201.232.58.66] has quit [Read error: 113 (No route to host)] 00:41 < perlmonkey2> anyone bored want to answer this. Should I be using MySQL DateTimes or the BIGINT(20)'s I'm seeing in other tables? I just want a datetime for when a response was started and stopped. 00:41 < perlmonkey2> I ask because sometimes WGBP have changed, but old code hasn't caught up. 00:42 <+perlDreamer> preaction: aren't we using MySQL date/times in all new Assets? 00:42 -!- estiven [n=estiven@201.232.58.66] has joined #webgui 00:42 <+perlDreamer> perlmonkey2: certainly, refactoring old code is rare in wG. It's even rarer than writing tests :( 00:42 <@preaction> perlDreamer, we're trying to, but it is difficult to do because of the way the definition works 00:43 <@preaction> make sure the defaultValue is specified in the MySQL format 00:43 < perlmonkey2> perlDreamer: cool, thanks 00:43 < perlmonkey2> preaction: I just use a default of now() in the table def? 00:44 < perlmonkey2> well, for the start date, the end date I want to be nullable. 00:44 <@preaction> WebGUI::DateTime->now->toDatabase; should work 00:44 <@preaction> if you want it to be nullable, then you'll have to do post-processing in processPropertiesFromFormPost 00:44 <@preaction> (setting it to the right format) 00:46 < perlmonkey2> oh man....looking at that makes me think I don't know what I'm doing. 00:46 < perlmonkey2> $self->session->db->insert("insert into Survey_reponseId values(?,?,?,?,?,?,?,?)",[$self->getId(),$self->session->id->generate(),$id,$self->session->user->username,$ip,'now()',undef ]); 00:47 < perlmonkey2> whups, typo...that first insert is a write 00:50 <@preaction> $self->session->db->setRow would probably be easier to use 00:50 <@preaction> see WebGUI::SQL->setRow 00:55 < perlmonkey2> okay 01:01 < perlmonkey2> cool, I like that setRow helper. I'll have to move all my other stuff to it. 01:18 < SynQ> http://web.archive.org/web/20020530034348/http://www.plainblack.com/ 01:27 < CIA-22> WebGUI: jt * r5994 /translations/Spanish/Spanish/ (4 files): update_from_translation_server 01:39 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 01:49 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 01:50 < CIA-22> WebGUI: jt * r5995 /translations/Turkish/ (4 files in 2 dirs): update_from_translation_server 01:57 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 01:57 -!- mode/#webgui [+o Haarg] by ChanServ 01:58 <+perlDreamer> The new Turkish translation advanced from nothing to 3.5% today. If it continues at that pace, they'll overtake all but the Dutch and Arabic translations in a few weeks 02:00 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has joined #WebGUI 02:29 -!- Radix-wrk [n=Jesse@203.161.68.67] has joined #webgui 02:29 -!- mode/#webgui [+v Radix-wrk] by ChanServ 02:42 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has quit ["Download Gaim: http://gaim.sourceforge.net/"] 02:49 < CIA-22> WebGUI: jt * r5996 /translations/Turkish/ (13 files in 2 dirs): update_from_translation_server 03:39 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 03:45 -!- Dadok [n=tickitim@150.188.dsl.syd.iprimus.net.au] has joined #webgui 03:45 < Dadok> hey guys 03:47 <@preaction> hello 03:52 < Dadok> im having a small problem with finding the right version of perlmagick. im using windows XP and downloaded the imagemagick 6.4.0 binary, installed it and checked to add perlmagick on install. unfortunately it seems to install version 6.3.7 of perlmagick with it, so when i try to run any of the demos im getting a Image::Magick object version 6.3.7 does not match bootstrap parameter 6.4.0 at ... 03:52 < Dadok> i tried twice to clean out all old versions and reinstall and it does the same thing 03:53 < Dadok> perhaps you could just tell me where to get version 6.3.7 of image magick? or any downloadable pair of matching versions would be fine :P 03:53 <+Radix-wrk> cpan for latest perlmagick perhaps? 03:53 < Dadok> i tried that 03:53 < Dadok> it gives version 6.3.2 i think 03:53 <+Radix-wrk> I don't know I'm afraid.. I just use the WRE 03:55 < Dadok> shucks 04:00 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 04:02 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Read error: 110 (Connection timed out)] 04:21 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit [Read error: 104 (Connection reset by peer)] 04:21 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 04:31 -!- Dadok [n=tickitim@150.188.dsl.syd.iprimus.net.au] has quit [] 04:54 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 05:32 -!- Dadok [n=tickitim@150.188.dsl.syd.iprimus.net.au] has joined #webgui 07:38 -!- Radix-wrk [n=Jesse@203.161.68.67] has quit [Read error: 104 (Connection reset by peer)] 07:38 -!- Radix-wrk [n=Jesse@203.161.68.67] has joined #webgui 07:38 -!- mode/#webgui [+v Radix-wrk] by ChanServ 07:46 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit [Remote closed the connection] 08:10 -!- metanil [n=akhadka@137.48.138.72] has quit ["Leaving."] 08:32 < Dadok> does anyone have any experience installing imagemagick/perlmagick on windows? 08:38 <@preaction> Dadok, why not use the WRE? 08:49 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 09:44 -!- ryuu_ro_ [n=rory@194.171.50.69] has joined #webgui 09:44 -!- ryuu_ro [n=rory@194.171.50.69] has quit [Read error: 104 (Connection reset by peer)] 09:52 < Dadok> hmm. i dont really understand what you mean. Ithought I was using the WRE and that I needed to add imagemagick/perlmagick as a module for things such as thumbnails to work... 10:33 -!- BartJol [n=plainstu@host2.procolix.com] has joined #webgui 10:48 < Syn2> mogge 11:23 <+Radix-wrk> thinkgeek.com has some awesome new gadgets 11:23 <+Radix-wrk> the betamax to hd-dvd converter is just pure gold :) 11:26 < BartJol> whoa, that's cool, although betamax is better than dvd off course 11:33 <+Radix-wrk> did you watch the video? :) 11:34 <+Radix-wrk> on a similar note: http://www.youtube.com has some great featured videos :) 11:43 < BartJol> not yet 11:46 -!- Radix-wrk [n=Jesse@203.161.68.67] has quit ["Leaving"] 11:52 < GooeyOfSteel> Wiki: Table of Contents - Edited on 4/1/2008 3:40 am by bartjol http://www.webgui.org/community-wiki/table-of-contents 11:54 -!- arjancwidlak [n=arjan@a62-216-21-20.adsl.cistron.nl] has joined #webgui 11:55 < GooeyOfSteel> Wiki: Table of Contents - Edited on 4/1/2008 3:43 am by bartjol http://www.webgui.org/community-wiki/table-of-contents 11:56 -!- apeiron_ [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has joined #webgui 11:56 -!- mode/#webgui [+o apeiron_] by ChanServ 12:06 < GooeyOfSteel> Wiki: Add custom macro to RichEdit macro selection - Created on 4/1/2008 3:54 am by bartjol http://www.webgui.org/community-wiki/add-custom-macro-to-richedit-macro-selection 12:07 < GooeyOfSteel> Wiki: Add custom macro to RichEdit macro selection - Edited on 4/1/2008 3:55 am by bartjol http://www.webgui.org/community-wiki/add-custom-macro-to-richedit-macro-selection 12:11 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has quit [Read error: 110 (Connection timed out)] 12:25 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 12:59 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has joined #webgui 13:06 -!- Dadok [n=tickitim@150.188.dsl.syd.iprimus.net.au] has quit [] 13:07 -!- dapperedodo [n=dappered@194.171.50.69] has quit [] 13:14 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 14:03 -!- BartJol [n=plainstu@host2.procolix.com] has quit [Read error: 113 (No route to host)] 14:15 -!- BartJol [n=plainstu@host2.procolix.com] has joined #webgui 15:19 -!- apeiron_ is now known as apeiron 16:02 -!- af_ [n=getsmart@88-149-230-220.dynamic.ngi.it] has joined #webgui 16:02 < af_> hi to all 16:02 < arjancwidlak> hihi 16:11 < Syn2> hi arjan 16:11 < arjancwidlak> sorry, was just saying hi to af_ 16:14 -!- MrHairgrease [n=martin@194.171.50.69] has joined #webgui 16:14 -!- mode/#webgui [+v MrHairgrease] by ChanServ 16:25 -!- BartJol [n=plainstu@host2.procolix.com] has quit [Read error: 113 (No route to host)] 16:34 -!- arjancwidlak [n=arjan@a62-216-21-20.adsl.cistron.nl] has left #webgui [] 16:36 -!- ryuu_ro_ [n=rory@194.171.50.69] has quit [Remote closed the connection] 16:37 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 16:39 -!- af_ [n=getsmart@88-149-230-220.dynamic.ngi.it] has quit [Read error: 113 (No route to host)] 16:40 -!- af_ [n=getsmart@88-149-241-103.dynamic.ngi.it] has joined #webgui 16:46 -!- dapperedodo [n=dappered@194.171.50.69] has quit [Read error: 104 (Connection reset by peer)] 16:46 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 16:48 -!- estiven [n=estiven@201.232.58.66] has left #webgui [] 16:48 -!- estiven [n=estiven@201.232.58.66] has joined #webgui 16:50 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 16:55 -!- jfluhmann [n=jfluhman@x172y028.angelo.edu] has quit [Remote closed the connection] 16:58 -!- jfluhmann [n=jfluhman@x172y028.angelo.edu] has joined #webgui 16:59 < perlmonkey2> You all hear the news? MS is buying Redhat. 16:59 <+MrHairgrease> nice try 16:59 < perlmonkey2> :D 17:00 < jfluhmann> thanks for reminding me what today is 17:02 <+MrHairgrease> hey perlmonkey2: i see you joined the pbwg gang! 17:02 < perlmonkey2> I did? 17:02 <+MrHairgrease> http://www.webgui.org/webgui/campaigns/people/kaleb-murphy#LnmSZhHi3jQZvX864GKVqw 17:02 < perlmonkey2> hah, that is too cool :P 17:03 < perlmonkey2> Hah, I've already been rated -1 :D 17:04 <+MrHairgrease> I'm rated 12 17:04 <+MrHairgrease> must be the eurotrash look 17:04 < perlmonkey2> heh 17:05 <+MrHairgrease> but then again that took me over two years =) 17:06 < perlmonkey2> I can't find a MrHairgrease in the PBWG 17:06 -!- arjancwidlak [n=arjan@a62-216-21-20.adsl.cistron.nl] has joined #webgui 17:06 <+MrHairgrease> take a better look 17:07 <+MrHairgrease> the photo gives me away 17:10 < perlmonkey2> Hmm, the person with the most hair product in the pictures would be Martin. 17:10 < perlmonkey2> Or JT. 17:10 -!- BartJol [n=plainstu@host2.procolix.com] has joined #webgui 17:10 < perlmonkey2> But you aren't JT :P 17:10 <+MrHairgrease> hehe 17:10 <+MrHairgrease> better don't tell him that 17:10 <+MrHairgrease> =) 17:10 < perlmonkey2> Heh 17:15 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has quit [Read error: 104 (Connection reset by peer)] 17:15 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 17:18 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has joined #webgui 17:18 -!- mode/#webgui [+o apeiron] by ChanServ 17:31 -!- ryuu_ro [n=rory@194.171.50.69] has quit [] 17:31 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 17:31 -!- mode/#webgui [+o Haarg] by ChanServ 17:51 -!- topsub [n=josh@97.66.185.250] has joined #webgui 17:53 -!- abc [n=abc@fvec-nat.d214.org] has joined #webgui 17:54 < abc> i am having issues creating a database link to sql server 2003. any ideas? 17:59 <@preaction> do you have an error message or otherwise? 18:00 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has left #webgui [] 18:05 < abc> orignally just a blank screen. then when i changed it to DBI:Sybase:[server=10.24.1.250][database=BGHS] i get Error: Could not connect to the database. 18:07 <@preaction> shouldn't you be using the ODBC driver? 18:07 < abc> i am not sure that is setup on the server and my network guy is out 18:08 < abc> what would the DSN look like to test it 18:11 -!- abcd [n=abc@fvec-nat.d214.org] has joined #webgui 18:11 -!- abc [n=abc@fvec-nat.d214.org] has quit [] 18:12 -!- abcd [n=abc@fvec-nat.d214.org] has quit [Client Quit] 18:18 < perlmonkey2> My new laptop shipped......I'm so pumped. 18:19 < perlmonkey2> shipped 4 days early 18:21 < topsub> lol 18:21 < topsub> brand? Specs? 18:22 < perlmonkey2> hah, Dell Vostro 1700. 3GB of 667 ram, T8100. 18:23 < perlmonkey2> They had a deal for $500 off and I couldn't resist. 18:25 < perlmonkey2> had to upgrade the wirefi to intel to ensure linux wifi would work. Graphics are just an X3100. Upgraded the screen to 1600x1200 res (17"). I won't even boot the XP it came with and install Fedora immediately. 18:25 < perlmonkey2> Although F9 comes out in 1 month, so I'll be reinstall soon :P 18:26 < topsub> nice 18:26 < topsub> when i was in college i made the mistake of buying an alienware... blah! 18:26 < perlmonkey2> doh 18:26 < topsub> that was the thing when i was in college 18:26 < topsub> everyone dreamed of having one 18:26 < perlmonkey2> nice machines, but they take some $$ 18:27 < topsub> over 3grand 18:27 < perlmonkey2> This Vostro will be $800. 18:27 < topsub> mobo went out on it so its in my lenovo box in parts till i can find new mobo 18:27 < perlmonkey2> doh 18:27 < topsub> they are a pain to take apart 18:27 < topsub> it wouldn't keep clock time 18:27 < topsub> very annoying had to set it everytime 18:28 < perlmonkey2> you run XP on it? 18:28 < topsub> the alienware? ya it had xp cuz in college all software needed xp 18:28 < topsub> well most.. some were mac only.. video editing classes 18:28 < perlmonkey2> yeah, and an alienware is for gaming, and gaming means MS. 18:28 < topsub> ya 18:29 < topsub> sadly never really got to test the gaming on it.. think i had need for speed2 on it 18:29 < topsub> but that was it 18:29 < perlmonkey2> dang, that sucks 18:29 < topsub> no World of Warcraft or anything 18:29 < topsub> cuz was in college = 3 jobs = no time to play.. lol 18:29 < perlmonkey2> hah, shoudl probably consider yourself lucky.....like saying "I never got to try heroin" 18:30 < topsub> lol 18:30 < topsub> when i paying 3 grand for laptop i want to try out the gaming on it... lol 18:32 < perlmonkey2> heh, and when I think 3 grand, I think 2 machines with 8 cores and 16GB ram. 18:32 < topsub> lol 18:32 < topsub> nope overpriced laptops 18:32 < topsub> lol 18:32 < perlmonkey2> and how much data could be crunched 18:32 < topsub> now dell owns it 18:32 < perlmonkey2> hhahaha, absolutely 18:32 < perlmonkey2> they bought alienware? 18:32 < topsub> ya 18:32 <@preaction> 3 grand for apple hardware is the norm, no? 18:33 < topsub> that new one thats out.. 18:33 < perlmonkey2> for the good stuff 18:33 < topsub> that very thin one 18:33 < perlmonkey2> the air starts at 1800 I think 18:33 < topsub> SSD in it 18:33 < perlmonkey2> but to put the fun stuff in it, I think 3K 18:33 < topsub> lol ya 18:33 < perlmonkey2> and it woudl still be slower than my $800 dell :P 18:34 < perlmonkey2> although be 18x cooler and weigh 1/20th. 18:34 < topsub> ya 18:34 <@preaction> yeah, not a fan of the Air 18:34 < topsub> maybe to just web surf 18:34 < topsub> email.. 18:34 < topsub> minor stuff 18:35 <@preaction> but a MBP for 3grand will probably get you something that'll last for a bit 18:35 < topsub> i want to start building new gaming desktop 18:35 < topsub> even tho i reallly don't need it.. i just want it.. lol 18:36 < perlmonkey2> topsub: that is what I did and it was just a way overpriced terminal. 18:36 < perlmonkey2> but when my laptop shows up, it will be my new super-duper server. 18:37 < perlmonkey2> I think it was $600 for parts and then $200 more for the vid card that got to use its 3d acceleration maybe twice. 18:37 * perlmonkey2 does it on the cheap. 18:37 < topsub> ya i dropped waaay to much money on my gaming desktop 18:37 < topsub> but i also have worked from it 18:37 < topsub> think i got 2TB of space on it 18:37 < topsub> lol 18:37 < perlmonkey2> hah, NICE 18:37 < topsub> 2 - 19s and 1 - 24 inch 18:38 < perlmonkey2> wow, that sounds like the way to go. 18:38 < topsub> wouldn't mind my new rig having 4 widescreens 18:38 < topsub> or something crazy 18:38 < topsub> it is very helpfull when coding 18:38 < topsub> having all that desktop space 18:39 < perlmonkey2> I've only used two monitors before and just found I put all my email/IM/web on one screen and work on the other. 18:41 < topsub> email / im one screen.. | coding programing in one | web browser other 18:43 -!- arjancwidlak [n=arjan@a62-216-21-20.adsl.cistron.nl] has left #webgui [] 18:46 -!- af_ [n=getsmart@88-149-241-103.dynamic.ngi.it] has quit ["Ex-Chat"] 18:52 < CIA-22> WebGUI: martin * r5997 /branch/WebGUI_Commerce/docs/upgrades/upgrade_7.5.2-7.5.3.pl: Fixed upgrade script. 18:52 < CIA-22> WebGUI: martin * r5998 /branch/WebGUI_Commerce/ (3 files in 3 dirs): 18:52 < CIA-22> WebGUI: - Changed Cash plugin to use processTransaction 18:52 < CIA-22> WebGUI: - Added (as of yet empty) notification templates 18:52 < CIA-22> WebGUI: - Fixed a typo in sendNotification 18:52 < CIA-22> WebGUI: graham * r5999 /WebGUI/ (docs/changelog/7.x.x.txt lib/WebGUI/AssetBranch.pm): 18:52 < CIA-22> WebGUI: fixed: edit branch sends thread notifications 18:52 < CIA-22> WebGUI: fixed: changing style template with edit branch creates new revisions of assets that have no style template 18:52 < CIA-22> WebGUI: graham * r6000 /WebGUI/ (4 files in 2 dirs): 18:52 < CIA-22> WebGUI: fixed: Wiki attachments uploaded by non-Content Managers deleted by maintenance workflow 18:52 < CIA-22> WebGUI: fixed: Non-Content managers unable to paste assets even with edit privileges 18:52 < CIA-22> WebGUI: graham * r6001 /WebGUI/ (16 files in 10 dirs): 18:53 < CIA-22> WebGUI: use UTF8 JSON encoding and decoding universally 18:53 < CIA-22> WebGUI: fixed: Import/Export of packages with international text is broken 18:53 < CIA-22> WebGUI: graham * r6002 /WebGUI/docs/ (3 files in 3 dirs): fixed: CS rating links are exposed to site spiders 18:53 < CIA-22> WebGUI: graham * r6003 /WebGUI/ (4 files in 4 dirs): improved behavior of CS mail message filtering 18:53 < CIA-22> WebGUI: jt * r6004 /translations/Spanish/ (4 files in 2 dirs): update_from_translation_server 18:53 < perlmonkey2> JT knows Spanish? 18:53 <@preaction> no 18:53 <@preaction> not that i know of 18:53 <@preaction> JT is the one logged into SVN for the translation server 18:53 < perlmonkey2> oh 18:54 <@preaction> which isn't fair for our ohloh stats 18:54 < perlmonkey2> hahahahahahaha, that is EXACTLY what I was thinking :P 18:56 < BartJol> what, I don't know ohloh stats, but I'm sure I'm missing them too 18:57 <@preaction> http://www.ohloh.net/projects/103/contributors 18:58 < BartJol> well with almost every week a translation submission I might show on that list 18:59 < BartJol> darn 18:59 < BartJol> then I'm going home, bye 18:59 -!- BartJol [n=plainstu@host2.procolix.com] has left #webgui [] 19:09 -!- d214 [n=d214@fvec-nat.d214.org] has joined #webgui 19:11 < d214> i am the webmaster at a large school district in IL. i am trying to set up a demo as proof that this is the CMS we want. I have done several page layouts and sql reports but i am now stuck on a sqlreport connecting to a ms sql server. 19:11 < d214> i believe freetds is installed on the server but i keep getting the error Cannot connect to database 19:12 < d214> i have create a local odbc connection fine so i know my username and password work 19:12 < d214> i am not sure why the database link does not 19:12 < d214> DBI:Sybase:[server=virtual-sql][database=master] 19:12 < d214> can anyone help? 19:13 <@preaction> d214, if you're the person who was in here before, the [] isn't supposed to be here 19:13 < d214> when i remove the [] i get a blank page with nothing 19:14 < d214> what separates the server and db in the DSN line then 19:21 -!- dapperedodo [n=dappered@194.171.50.69] has quit [] 19:21 -!- knowmad [n=william@adsl-074-170-007-083.sip.clt.bellsouth.net] has joined #webgui 19:22 -!- MrHairgrease [n=martin@194.171.50.69] has left #webgui [] 19:25 < d214> what needs to be on the server for ODBC 19:27 < topsub> semi colons d214 19:27 < topsub> if i remember 19:27 < topsub> DBI:Sybase:server=virtual-sql;database=master 19:28 < topsub> think one at the end also, not sure 19:29 < d214> DBI:Sybase:server=virtual-sql;database=master; 19:29 < d214> returns a blank page 19:29 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has joined #webgui 19:29 -!- mode/#webgui [+v perlDreamer] by ChanServ 19:29 < d214> not even an error message or debuging 19:30 < topsub> look in the log 19:31 < topsub> look here - /var/wre/logs/webgui.log 19:42 <+perlDreamer> All answers are in /var/wre/log/webgui.log 19:43 <+perlDreamer> unless they're in the apache error log 19:43 <@preaction> d214, i was wrong when I asked you to use ODBC, Sybase is what you want 19:43 <@preaction> d214, if you get a blank page, you need to check the error log 19:44 < d214> apache error log or the webgui 19:44 <@preaction> webgui error log most likely 19:48 <@preaction> d214, http://webgui.pastebin.com <- if you paste the last hundred lines or so to that address we'll be able to see it and help you 19:53 <+perlDreamer> preaction: On your dev box can you duplicate the failing company macro test? 19:56 <@preaction> perlDreamer, no 20:01 < d214> sent the log but there is nothing for today other then a differnt log when i was testing changing a db link that worked 20:02 <@preaction> http://webgui.pastebin.com/m7dc7f0fa <- you should probably change your log level to something higher than ERROR 20:03 <@preaction> DEBUG or INFO would be good 20:03 <@preaction> edit WebGUI/etc/log.conf 20:10 < d214> does it need to be restarted to take effect 20:21 <@preaction> yes 20:33 -!- CIA-22 [n=CIA@208.69.182.149] has quit [] 20:43 -!- CIA-21 [n=CIA@208.69.182.149] has joined #WebGUI 21:01 < SynQ> perlbot tell 21:02 < SynQ> can I let perlbot say things 21:02 < SynQ> !perlbot help 21:04 <@preaction> perlbot tell synq about keywords 21:05 < SynQ> I see 21:05 -!- dapperedodo [n=dappered@ip56503e61.direct-adsl.nl] has joined #webgui 21:05 < SynQ> perlbot is not allowed to respond to my questions 21:05 < SynQ> http://www.webgui.org/community-wiki/irc 21:05 < SynQ> ok, dinner! 21:11 -!- dapperedodo [n=dappered@ip56503e61.direct-adsl.nl] has quit [] 21:23 -!- steveo_a1 [n=sno@adsl-76-234-133-88.dsl.sfldmi.sbcglobal.net] has left #webgui [] 21:24 -!- steveo_aa [n=sno@adsl-76-234-133-88.dsl.sfldmi.sbcglobal.net] has joined #webgui 21:50 -!- dummy [n=dummy@62.77.121.120] has joined #webgui 21:53 < dummy> Hello, I want to use XUL, xForms, xEvents, XHTML 2, WebForms 2, CSS 3 or some other new technology to create the website. Can you please tell me about any such available and cross-browser technology? It must work at least with the rendering engine of Opera and with GECKO. 21:53 <@preaction> uh... what do you mean? 21:56 < dummy> preaction, I'm asking you about any working new web technology 21:56 < dummy> ...or at least "new" one 21:57 <@preaction> most of CSS3 isn't near CR status yet. I didn't know xForms or xEvents or XHTML2 or WebForms2 were either 21:57 <@preaction> i guess my question is how does this pertain to WebGUI? 21:58 < CIA-21> WebGUI: jt * r6005 /branch/WebGUI_Commerce/ (9 files in 6 dirs): ems user experience mostly done 22:00 < d214> preaction - restarted and posted new log. looks like something is odd with spectre 22:00 <@preaction> d214, what's the link to the pastebin you created? 22:00 <+perlDreamer> perlmonkey2: what's your dev environment look like? 22:01 < d214> http://webgui.pastebin.com/m34aec54 22:02 < perlmonkey2> perlDreamer: My desktop is Fedora 8, where I open up a terminal with 5 screens connected to my Cent5.1 server. Open up mysql admin/querybrowser to the survey, and keep two tabs in firefox (with firestarter open) in the webgui instance, one window on the survey and the other in the assets. 22:03 <+perlDreamer> hm 22:03 < perlmonkey2> that is how I dev. 22:03 <+perlDreamer> definitely gonig to ping you on this YUI stuff 22:03 <+perlDreamer> but after the product stuff is done 22:03 < perlmonkey2> I guess the env, is just a month old svn snapshot of wg, on a cent 5.1 serve.r 22:04 < d214> when i click run on the workflow all i get is error on the next page 22:05 < perlmonkey2> perlDreamer: please do. But the secret sauce to my JS dev is firestarter. I don't know how I did JS dev without it. 22:05 < perlmonkey2> I mean firebug 22:05 < perlmonkey2> not firestarter 22:06 < perlmonkey2> that is a iptables gui :P 22:06 <+perlDreamer> Drew Barrymore vs Mitchell Baker 22:06 <+perlDreamer> hm 22:07 <@preaction> d214, your SyncProfilesToLDAP isn't compiling for some reason. have you run testEnvironment.pl? 22:08 -!- dapperedodo [n=dappered@ip56503e61.direct-adsl.nl] has joined #webgui 22:09 < d214> not that i am aware of, where is it 22:09 <@preaction> WebGUI/sbin 22:09 <@preaction> if you're running the WRE you probably don't need it 22:11 < d214> posted it, http://webgui.pastebin.com/m19f8d8d7 22:12 < perlmonkey2> I just bought 5,000 shares of Clinton to win the Penn primary at $8/contract (good contracts worth $10). 22:12 < perlmonkey2> I hope that wasn't a stupid thing to do. 22:13 < perlmonkey2> I mean 500 contracts, not 5000. 22:13 < perlmonkey2> heh 22:13 < perlmonkey2> (this is with Intrade's play money) :P 22:13 -!- Samus_Aran [n=ILL@about/linux/supportwhirlwind/SamusAran] has joined #WebGUI 22:14 < Samus_Aran> does WebGUI have a method of support for pages in multiple languages ? 22:15 <+perlDreamer> No 22:15 <+perlDreamer> No multilingual content, only labeling and editing interfaces are i18n'ed 22:15 <+perlDreamer> but if you look in the wiki and the forums, you'll see how people have done it in WebGUI 22:15 < Samus_Aran> darn. would be neat if content could have alternate versions 22:16 < Samus_Aran> thank you 22:16 <+perlDreamer> RFEs (and patches) are always welcome 22:16 <+perlDreamer> you're not the first person to ask for this 22:16 <+perlDreamer> if enough people start asking, then JT will start thinking about it 22:18 < dapperedodo> There are enough tricks to buld multilangual sites 22:18 < dapperedodo> You could rebuild the entire site in an alternate root 22:18 < Samus_Aran> perlDreamer: I will submit an RFE, or add a comment on an existing one then 22:19 <+perlDreamer> In the meantime, Samus_Aran, the multiple root trick that dapperedodo mentioned works well 22:19 <@preaction> d214, you need to run testEnvironment.pl as root so it can install all those dependencies for you 22:19 <+perlDreamer> you basically copy and paste your site into a new root using the Asset Manager 22:19 <+perlDreamer> then translate that "branch" of the site 22:19 <+perlDreamer> Syncing the two sites has to be done manually 22:20 <@preaction> d214, also, if you're using a source install, I would seriously reconsider moving to the WRE. source installs are not for the faint of heart 22:22 < Samus_Aran> dapperedodo: the way I visualise it is all Assets can have multiple versions, with a set tag such as -en or -fr. if a tag in the alternate form doesn't exist, it would use the default named Asset 22:22 < Samus_Aran> that way you can add new images as needed, the rest falling back 22:22 < Samus_Aran> if you moved content around, the translation would follow 22:24 <@preaction> but those assets wouldn't have the same URL or asset ID 22:24 <@preaction> the way i've been seeing it is an assetTranslation table with 22:24 <+perlDreamer> preaction, that's by design. Another design would look at the user's language pref's, choose the best language and then present that content to the user 22:25 <@preaction> then asset->get would get the correct content based on the user's preference 22:25 < dapperedodo> The mutilanguage option is indeed good for the pictures. But in my projects that was always a minor issue. You just copy the asset enad start translating. The translating is the biggest job. 22:25 <@preaction> i like this way because it could be done as a mixin instead of having to make all assets aware of multi-language by default 22:25 <+perlDreamer> I was thinking it would be done in new, rather than get since it's tied to a particular session 22:26 < Samus_Aran> it would be nice also if it would read the browser's default language setting, if set 22:27 < dapperedodo> You do not always want to see the language of your preference, and that is only true for Registered users 22:27 < dapperedodo> Also fro google you want different langages in different urls 22:29 <+perlDreamer> I didn't even think about the google and the search engines 22:29 <@preaction> also there's the Alternate HTTP header you'll probably want to send for those languages 22:29 <@preaction> so there will need to be some way to get at other translations via URL 22:30 <@preaction> ?lang=en perhaps? 22:30 <+perlDreamer> well, I guess that's why I fix bugs and write tests rather than building CMSes :) 22:30 < dapperedodo> you can do it with a form param, but it is ugly. 22:30 <@preaction> perlDreamer, there are days where i would prefer just some nice bugs or something new to test... 22:30 <@preaction> dapperedodo, how so? 22:30 < dapperedodo> That's why I never did an RFE for multilanguage:) 22:31 <+perlDreamer> There are CMSes that do multilanguage. Have we looked at them? 22:31 < dapperedodo> The ?lang=en thing is ugly 22:31 < dapperedodo> They mostly do the ?lang=en thing 22:31 <@preaction> this can't be worse than character encodings... i've been working two days on finding a way to fix character encodings because the newest WebGUI Beta forces UTF-8 for all mysql connections 22:31 < dapperedodo> I always make two roots 22:31 <@preaction> dapperedodo, why is that ugly? what could be done to avoid it? 22:32 <@preaction> is it just personal preference that makes it ugly? 22:32 <@preaction> or is there some good reason? 22:32 < dapperedodo> one is like /home and the other /en/home 22:32 <@preaction> theoretically, with URL handlers or Content handlers or somesuch you could translate /en/home to /home?lang=en 22:32 < dapperedodo> The url rewriting of webgui is done for a very good reason. Gppgle likes it. 22:33 < dapperedodo> of course you can also rewrite it:) 22:36 <@preaction> yeah, but as you said, webgui exists so we don't have to do rewrite rules 22:38 < dapperedodo> so you don't want an extra ?lang=en in yoururls and build the rewriting already in WebGUI 22:40 < d214> preaction, i believe i am running wre how can i tell 22:41 < Samus_Aran> you could also do sub-domains, www.foo.com for default language, es.foo.com for Spanish, fr.foo.com for French, etc. 22:41 < Samus_Aran> and fall back to content not translated on the original 22:42 < Samus_Aran> or support all three methods mentioned and let the user pick one. internally they would all be using the same code anyway 22:42 < Samus_Aran> just a different URL 22:43 < dapperedodo> The fall back thing is a good reason you want the multilanguage option in WebGUI. There is no trick I could think of that would do that trick in the existing WebGUI 22:44 <@preaction> i'm saying that ?lang=en is the default method. then we build a URL handler that handles, say ^/lang:([^/]+)/ and sets the session language to that (it doesn't rewrite the URL at all) 22:44 <@preaction> so if someone wants, they can change their config to add that URL handler and have different sections of the site with different languages liike that 22:45 <@preaction> but all the URLs in the assetData table will NOT have any lang:en or lang:es in the beginning of them 22:45 <@preaction> the end result is the same as rewriting, but it's more elegant 22:45 < dapperedodo> I can see your point. 22:46 <@preaction> there's another way we could do it: having multiple versions of an asset in the tree, but hiding all the ones that don't match the user's language preference 22:47 <@preaction> so we have two assets with URLs thing-en and thing-es, and both are on the page "things". going to "things" will show me thing-en (because i have en in my prefs), but will show someone else thing-es because that's what they have) 22:48 <+perlDreamer> I think that idea has been proposed before, and rejected by JT due to concerns with speed. 22:48 <@preaction> which one? 22:48 <@preaction> the multiple assets one? 22:49 <+perlDreamer> yes, your last suggestion 22:49 <@preaction> yeah, i don't like it either 22:49 <+perlDreamer> I don't remember the details, though 22:49 <@preaction> i like my /lang:en/ one 22:49 <+perlDreamer> maybe the xdanger archives would be a good place to look 22:56 -!- dummy [n=dummy@62.77.121.120] has quit ["Leaving"] 23:01 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 23:02 -!- topsub [n=josh@97.66.185.250] has quit [Remote closed the connection] 23:05 -!- knowmad [n=william@adsl-074-170-007-083.sip.clt.bellsouth.net] has quit [Read error: 110 (Connection timed out)] 23:07 < d214> preaction, do all have to be installed 23:07 <@preaction> d214, yes 23:07 <@preaction> that's what testEnvironment.pl is for 23:07 < d214> i get errors on a few 23:07 <@preaction> then you have to force install them 23:07 < d214> how 23:08 <@preaction> perlbot life with cpan 23:08 < perlbot> Information pertaining to the Comprehensive Perl Archive Network (CPAN) can be found at http://sial.org/howto/perl/life-with-cpan/ 23:08 <@preaction> open the cpan shell and do "force install Module" 23:09 <@preaction> have you considered using the WRE yet? 23:09 < d214> i thought i was using it. how can i tell 23:09 <@preaction> does /data/wre exist? 23:09 <@preaction> is that where you put it? 23:10 < d214> yes 23:10 <@preaction> then what probably is wrong is that you aren't using the WRE's environment when you're running testEnvironment.pl 23:11 <@preaction> do . /data/wre/sbin/setenvironment.sh (that's dot, space, slash) 23:12 < d214> done. now wha 23:12 < d214> whaty 23:12 < d214> sorry what 23:13 <@preaction> now you can do whatever it was you were doing that wasn't working 23:13 <@preaction> like testEnvironment.pl 23:13 <@preaction> but since you're using the WRE, testEnvironment.pl will probably pass 23:14 -!- dapperedodo [n=dappered@ip56503e61.direct-adsl.nl] has quit [] 23:15 < d214> yes it passed 23:18 < d214> still get SyncProfilesToLdap.pm error in the log 23:18 < d214> how is that related to a db link? 23:22 <@preaction> it's not 23:23 -!- arjancwidlak [n=arjan@widnet.xs4all.nl] has joined #webgui 23:23 < d214> ok so how do i debug the syncprofilestoldap, no running workflows and my blank sql report page 23:26 < d214> have to run for the day. thanks for the help but i am sure i will be stuck tomorrow 23:26 -!- d214 [n=d214@fvec-nat.d214.org] has quit [] --- Day changed Wed Apr 02 2008 00:10 < CIA-21> WebGUI: graham * r6008 /branch/WebGUI_7.4/ (2 files in 2 dirs): fixed: Syndicated Content asset tries too hard to get URLs returning errors 00:10 < CIA-21> WebGUI: graham * r6009 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/Asset/Event.pm): fixed: Event related links truncated on dashes 00:10 < CIA-21> WebGUI: graham * r6010 /branch/WebGUI_7.4/docs/ (changelog/7.x.x.txt upgrades/upgrade_7.4.30-7.4.31.pl): added: Database index on userSession.expires field to speed up workflows 00:10 < CIA-21> WebGUI: graham * r6011 /branch/WebGUI_7.4/ (3 files in 3 dirs): fixed: Collaboration System attachments follow site's max size instead of CS's 00:10 < CIA-21> WebGUI: graham * r6012 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/Form/HTMLArea.pm): fixed: Rich editor image uploader doesn't follow size limits 00:10 < CIA-21> WebGUI: graham * r6013 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/Asset/Wobject/Poll.pm): fixed: Poll question/answers with international text corrupted 00:10 < CIA-21> WebGUI: graham * r6014 /branch/WebGUI_7.4/ (2 files in 2 dirs): fixed: subscription group in CS edit has broken hover help 00:10 < CIA-21> WebGUI: graham * r6015 /branch/WebGUI_7.4/ (5 files in 5 dirs): fixed: profile photos don't obey max image size 00:10 < CIA-21> WebGUI: graham * r6016 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/Workflow/Spectre.pm): fixed: Unable to communicate with Spectre under alternate locales 00:10 < CIA-21> WebGUI: graham * r6017 /branch/WebGUI_7.4/docs/ (changelog/7.x.x.txt upgrades/upgrade_7.4.30-7.4.31.pl): fixed: Project Manager can't track non-integer durations 00:10 < CIA-21> WebGUI: graham * r6018 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/Asset/Post.pm): fixed: Unable to edit CS posts that were denied as a normal user 00:10 < CIA-21> WebGUI: graham * r6019 /branch/WebGUI_7.4/lib/WebGUI/Asset/Wobject/Survey.pm: removing useless www_editSave from survey 00:10 < CIA-21> WebGUI: graham * r6020 /branch/WebGUI_7.4/ (2 files in 2 dirs): added: Better error messages when SQL Report lacks a query 00:10 < CIA-21> WebGUI: graham * r6021 /branch/WebGUI_7.4/ (docs/changelog/7.x.x.txt lib/WebGUI/AssetBranch.pm): 00:10 < CIA-21> WebGUI: fixed: edit branch sends thread notifications 00:10 < CIA-21> WebGUI: fixed: changing style template with edit branch creates new revisions of assets that have no style template 00:10 < CIA-21> WebGUI: graham * r6022 /branch/WebGUI_7.4/ (4 files in 2 dirs): 00:10 < CIA-21> WebGUI: fixed: Wiki attachments uploaded by non-Content Managers deleted by maintenance workflow 00:10 < CIA-21> WebGUI: fixed: Non-Content managers unable to paste assets even with edit privileges 00:10 < CIA-21> WebGUI: graham * r6023 /branch/WebGUI_7.4/lib/WebGUI/Storage.pm: fixing warnings and Storage changing dir 00:10 < CIA-21> WebGUI: graham * r6024 /branch/WebGUI_7.4/lib/WebGUI/ (Asset.pm Storage.pm): minor module loading ans chdir issues 00:11 < CIA-21> WebGUI: graham * r6025 /branch/WebGUI_7.4/lib/WebGUI/Asset/Wobject/Article.pm: fixing article storage copying 00:11 < CIA-21> WebGUI: graham * r6026 /branch/WebGUI_7.4/ (8 files in 6 dirs): preparing for 7.4.31 release 00:11 < CIA-21> WebGUI: jt * r6027 /releases/WebGUI_7.4.31-stable: Release 7.4.31-stable 00:11 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has joined #webgui 00:12 <@preaction> holy hell 00:12 <+perlDreamer> yeah, Haarg is busting them up 00:13 <+perlDreamer> The bug list is down to 6 entries 00:14 <@Haarg> that's another merging 00:14 <@Haarg> those were all already fixed in 7.5 00:15 <+perlDreamer> still, it's a ton of good work 00:29 -!- MrHairgrease [n=martin@x032124.its-s.tudelft.nl] has joined #webgui 00:29 -!- mode/#webgui [+v MrHairgrease] by ChanServ 00:34 -!- TheSeparator [n=seppie@ip565f19be.direct-adsl.nl] has joined #webgui 00:39 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has joined #webgui 00:39 -!- Samus_Aran [n=ILL@about/linux/supportwhirlwind/SamusAran] has left #WebGUI ["onwards I go ..."] 00:39 < cap10morgan> can you add an asset to the list using the config file overrides? 00:39 < cap10morgan> or would you need to put the whole list in there and add your asset to it? 00:50 <+perlDreamer> If by list you mean the admin console? 00:50 <+perlDreamer> the yes, the config file is used to set some of the things in the admin bar 00:50 <+perlDreamer> Also, prototypes are listed in the admin bar 00:52 <+perlDreamer> the config file settings are called "assets" and "assetContainers" 00:52 < cap10morgan> yeah, the admin console 00:53 < cap10morgan> so i need to put in the whole "assets" section i want in my new sites' config files, right? 00:53 <+perlDreamer> right, the whole thing 00:53 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 00:53 < cap10morgan> ok, thanks pD 00:53 <+perlDreamer> no problem 00:53 <+perlDreamer> How's the OpenID? 00:53 < cap10morgan> oh, good question :) 00:53 < cap10morgan> we should check on that perl library again 00:53 < cap10morgan> we were waiting on them to get updated to openid 2.0 00:54 <+perlDreamer> That's probably a good idea, given the recent JSON fiasco :) 00:54 <+perlDreamer> There were some people in here about a week ago asking about single sign on, but I think they were really thinking LDAP integration. 00:54 < cap10morgan> heh, yeah, wouldn't want that right out of the gate 00:54 < cap10morgan> oh yeah 00:54 < cap10morgan> the thing i'm really excited about is making webgui an openid provider 00:55 < cap10morgan> so then w/ ldap integration 00:55 < cap10morgan> it can expose your ldap users as openids 00:55 < cap10morgan> which would be sweet 00:55 < cap10morgan> ldap -> web-wide sso. mmmmm... tasty. 01:00 <+perlDreamer> just write lots of tests for it :) 01:18 <+perlDreamer> Does anyone in the channel use Product Assets on their site? Note, it's only related to the Commerce System, so if you're using the Product macro it probably isn't the same thing. 01:21 -!- MrHairgrease [n=martin@x032124.its-s.tudelft.nl] has left #webgui [] 01:39 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 01:56 -!- arjancwidlak [n=arjan@widnet.xs4all.nl] has left #webgui [] 02:37 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has quit ["Download Gaim: http://gaim.sourceforge.net/"] 03:00 -!- TheSeparator [n=seppie@ip565f19be.direct-adsl.nl] has quit [Read error: 113 (No route to host)] 03:36 -!- Radix-wrk [n=Jesse@203.161.68.67] has joined #webgui 03:36 -!- mode/#webgui [+v Radix-wrk] by ChanServ 03:41 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit ["Exit- stage left"] 03:43 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 04:06 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has quit [Read error: 110 (Connection timed out)] 04:30 -!- CIA-21 [n=CIA@208.69.182.149] has quit [] 04:37 -!- CIA-23 [n=CIA@208.69.182.149] has joined #WebGUI 06:32 -!- CIA-23 [n=CIA@208.69.182.149] has quit [] 06:41 -!- CIA-21 [n=CIA@208.69.182.149] has joined #WebGUI 06:41 -!- Dadok [n=tickitim@224.163.dsl.syd.iprimus.net.au] has joined #webGUI 07:14 < CIA-21> WebGUI: colin * r6028 /branch/WebGUI_Commerce/t/Shop/loadProducts.pl: widget script for throwing Products into the db for testing upgrades 07:53 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 07:53 -!- mode/#webgui [+o Haarg] by ChanServ 08:03 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has quit [Read error: 113 (No route to host)] 08:10 -!- dapperedodo_ [n=dappered@ip56503e61.direct-adsl.nl] has joined #webgui 08:21 -!- dapperedodo_ [n=dappered@ip56503e61.direct-adsl.nl] has quit [] 08:47 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 08:51 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 08:57 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 09:00 -!- dappere-dodo [n=dappered@194.171.50.69] has joined #webgui 09:01 -!- dappere-dodo [n=dappered@194.171.50.69] has quit [Client Quit] 09:01 -!- dapperedodo [n=dappered@194.171.50.69] has left #webgui [] 09:01 -!- dappere-dodo [n=dappered@194.171.50.69] has joined #webgui 09:03 -!- dappere-dodo [n=dappered@194.171.50.69] has quit [Client Quit] 09:04 -!- dappere-dodo [n=dappered@194.171.50.69] has joined #webgui 09:04 -!- dappere-dodo [n=dappered@194.171.50.69] has quit [Client Quit] 09:05 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 10:25 -!- patspam [i=chatzill@ppp59-167-163-151.lns1.mel4.internode.on.net] has joined #webgui 10:52 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has joined #webgui 11:26 -!- patspam [i=chatzill@ppp59-167-163-151.lns1.mel4.internode.on.net] has quit ["ChatZilla 0.9.81 [Firefox 2.0.0.13/2008031114]"] 11:38 -!- BartJol [n=plainstu@194.171.50.123] has joined #webgui 11:55 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 11:55 -!- mode/#webgui [+o Haarg] by ChanServ 11:58 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit [Client Quit] 11:59 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 11:59 -!- mode/#webgui [+o Haarg] by ChanServ 12:29 -!- MrHairgrease [n=martin@194.171.50.69] has joined #webgui 12:29 -!- mode/#webgui [+v MrHairgrease] by ChanServ 12:49 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 13:03 < Syn2> oohm 14:12 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has quit ["Leaving"] 14:40 -!- Dadok [n=tickitim@224.163.dsl.syd.iprimus.net.au] has quit [] 15:25 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has joined #webgui 15:53 -!- SDuensin [n=Scott@84.sub-75-206-54.myvzw.com] has joined #WebGUI 15:55 < SDuensin> Morning. 16:18 -!- topsub [n=josh@97.66.185.250] has joined #webgui 16:35 < CIA-21> WebGUI: yung * r6029 /WebGUI/ (3 files in 3 dirs): fixed: Thingy: "cancel" -- cannot cancel when adding a thing 16:37 -!- perlmonkey2 [n=kmurphy@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 16:40 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 16:40 -!- mode/#webgui [+o Haarg] by ChanServ 16:58 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has left #webgui [] 17:00 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 17:00 -!- mode/#webgui [+o rizen] by ChanServ 17:01 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has joined #webgui 17:01 -!- mode/#webgui [+o apeiron] by ChanServ 17:01 -!- bopbop [n=kmccombs@71-82-214-154.dhcp.mdsn.wi.charter.com] has joined #webgui 17:01 <@rizen> MrHairGrease: one thing about payments...no hand building XML this time. Use XML::Simple instead 17:01 <+MrHairgrease> already did that 17:01 <@rizen> k 17:01 <@rizen> you rock 17:01 <+MrHairgrease> indeed 17:02 <+MrHairgrease> =) 17:02 <@rizen> jfluhmann: how many people will be at your texasoss.org conference? 17:02 <@rizen> nuba: how is the maps thing coming along? will it be done by the May 31st deadline for 7.5 17:04 -!- estiven [n=estiven@201.232.58.66] has quit [Remote closed the connection] 17:04 -!- estiven [n=estiven@201.232.58.66] has joined #webgui 17:04 -!- estiven [n=estiven@201.232.58.66] has left #webgui [] 17:06 * perlmonkey2 is finding the logic to determine the next question(s) in the survey with sections, randomizing, jumping, user set questions per page, to be near impossible without making like 15 DB calls. I'll be seriously put out if this turns out not to be fast enough for an AJAX app :P 17:06 <@rizen> it will be fast enough 17:06 <@rizen> perlmonkey2: the key is order of operations 17:07 <@rizen> determine what you can eliminate first in your lookup strategy 17:08 <@rizen> with a good logic structure, you can usually knock out more than half of the logic (and therefore lookups) 17:10 < perlmonkey2> I think I'm pegging my brain's CPU in deteremining the logic code. 17:10 < perlmonkey2> err, next question logic's code. 17:13 <@rizen> ok step back 17:13 <@rizen> get out an old fashioned piece of paper and a pencil 17:13 < perlmonkey2> I think I'm going to make a rule that an answer can not have a jump to a randomized section. 17:14 < perlmonkey2> Great minds think alike :) Right above my code is text walking through all the logic. 17:14 <@rizen> write down the different cases of how you can determine the next question, without caring about the relationship of how to get there 17:15 <@rizen> this works even easier if you have a flow charting program like dia, visio, or omnigraffle 17:15 < perlmonkey2> I think I've gone through all permutations, but I'm trying to A, expedite getting this done while B, not duplicating all my code. 17:16 <@rizen> then draw lines to represent the logic structure 17:16 <@rizen> then sort out the spaghetti 17:16 < perlmonkey2> hah 17:16 < perlmonkey2> I'll give that a go....Always fun to use Dia. 17:17 <@rizen> don't worry about code duplication. after you get it figured out you can always refactor the code into a bunch of subroutines 17:17 < perlmonkey2> premature optimization.....the bane of my existence. 17:17 < perlmonkey2> okay....I'll try putting together some dia-grams and see if that helps me organize the code. 17:18 < perlmonkey2> :) 17:18 < perlmonkey2> well....not organize, but figure out the logic. 17:18 <@rizen> no problem is to large if you break it into small enough pieces 17:18 <@rizen> s/to/too/ 17:19 < perlmonkey2> Will be sad if my grant ends up having to use Surveymonkey, while paying me quite a bit of on the clock time for this survey. 17:30 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has joined #webgui 17:30 -!- mode/#webgui [+v crythias] by ChanServ 17:30 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has left #webgui [] 17:35 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit ["Exit- stage left"] 17:51 <@rizen> why would they end up using survey monkey? 17:51 < perlmonkey2> They have a go live date coming up next Momnday 17:52 < perlmonkey2> if I can get *(something* working by tomorrow, they'll be testing and building surveys all weekend. 17:52 < perlmonkey2> if not, they'll have to go with surveymonkey 17:52 <@rizen> so why not just get it working? 17:52 <@rizen> do they really need random and everythign? 17:52 < perlmonkey2> hah, I'm working 12-14 hours a day since last wed to do that. 17:52 <@rizen> why not give them a build that gives them only wht they need 17:52 <@rizen> and then add the rest later 17:52 < perlmonkey2> they wanted everything 17:52 <@rizen> i didn't say want 17:52 <@rizen> i said NEED 17:53 <@rizen> for this weekend 17:53 <@rizen> for this survey 17:53 < perlmonkey2> but I am close....and I am cutting out a lot of stuff 17:53 <@rizen> what do they need 17:53 < perlmonkey2> I don't know. I understood it to be everything 17:53 < perlmonkey2> they already have a ton of extremely expensive closed source tools that don't do what they want. 17:53 <@rizen> i don't know is never a valid answer. 17:54 <@rizen> the answer is "i'll find out" 17:55 -!- ryuu_ro [n=rory@194.171.50.69] has quit [] 17:55 < perlmonkey2> I'll see what I can find out.....hopefully pear down the number of questions I need to implement 18:00 <@rizen> incidentally, if you don't want my advice on this stuff, feel free to tell me to shut the hell up. =) 18:03 <+MrHairgrease> rizen: what's the method to fetch the recur period from an item? 18:03 <+MrHairgrease> if there is such a thing 18:04 <@rizen> we need to add that to Sku 18:04 <@rizen> i didn't add any interface methods for recurring stuff except isRecurring 18:05 <@rizen> call it getRecurInterval 18:05 <+MrHairgrease> ok 18:05 <+MrHairgrease> another thing 18:05 <+MrHairgrease> TransactionItem doen't store isRecurring and recurInterval 18:05 <+MrHairgrease> I guess it should 18:06 <@rizen> why should it? 18:06 <@rizen> doesn't the payment gateway do the recurrence? 18:07 <@rizen> it does a postback on the interval, right? 18:07 <+MrHairgrease> b/c you want to be able to check if a transaction item recurring payment is due 18:07 <+MrHairgrease> it does 18:07 < perlmonkey2> rizen: no, I really appreciate your advice. The only software developers I have to sanity check myself are on IRC. All of my dev friends IRL are MS whores, there isn't one other software developer in myh building, let alone on my grant. The only place to talk shop is IRC. 18:07 <+MrHairgrease> but as it is it stores that in the ITransact_recurring table 18:07 <+MrHairgrease> or simething like that 18:07 <@rizen> fair enough. feel free to add those to the transaction item then 18:07 <+MrHairgrease> ok 18:13 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has joined #webgui 18:30 -!- perlmonkey2 [n=kmurphy@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 18:42 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has joined #WEBGUI 18:42 < elnino> hi 18:42 < elnino> since the upgrades I've made to 7.4.26, My user can't "change URL" when they are in asset manager. Any particular setting they need to have to be able to do this? 18:44 < elnino> Ah. I found out they have to be a guru. (process of elimination) any particlur place I can change this so they can do it at an "expert" level? 18:47 < bopbop> el nino: go to the user's user profile- you'll see the UI field towards the bottom- change to 9 18:48 < elnino> right, I don't want them to be an guru, I want them to be an expert, but still be able to change the url as they were able to do before I upgraded. Is there a way to change this? 18:49 < bopbop> ah, I see... 18:49 < bopbop> Haarg: do you know? 18:50 <@Haarg> there may be a config setting for it, i don't remember offhand 18:50 <+MrHairgrease> you can do it in the webgui.conf 18:50 <+MrHairgrease> but you'll have to do it per asset 18:50 < bopbop> el nino: try looking in the Permissions tab of Settings... 18:50 < bopbop> nope, nevermind :) 18:51 <+MrHairgrease> basically you do this: 18:51 <@rizen> that won't work for the change url function mrhairgrease 18:51 <@rizen> that's only for asset properties 18:51 <+MrHairgrease> "WebGUI_Asset_Wobject_Article_uiLevel" : { "url" : level# } 18:51 <@rizen> he's talking about the "Change URL" menu function i think 18:52 < elnino> yep 18:52 <+MrHairgrease> what is that? 18:52 <@rizen> elnino: are you a guy or a girl? elnino sounds like a guy, but on the site i see your name is "lauren" or something like that 18:53 < elnino> when you go into assets of an asset or wobject, you can change the url of that assett/wobject permanantly (and erase all previous urls it may have had) 18:53 <+MrHairgrease> yeah, I just found it 18:54 <+MrHairgrease> nice 18:54 <+MrHairgrease> didn't know webgui could do thta =) 18:54 <@rizen> it's a somewhat dangerous function 18:54 <@rizen> because it gets rid of all the old revisions 18:55 <@rizen> but it's also highly useful 18:55 <+MrHairgrease> what about the assetToolbarUiLevel options then? 18:55 < elnino> yes, but it's a nice feature. 18:55 < elnino> don't get rid of it. 18:55 <+MrHairgrease> "changeUrl" : 9 18:55 < elnino> please 18:55 <@rizen> i'm not thinking of getting rid of it 18:56 <@rizen> that would work mrhairgrease...i forgot that existed 18:56 < elnino> perfect thanks. 18:56 < elnino> rizen - to answer your question: wondering when someone as going to ask. depends on translation. I'm female. No hurt feelings here. I liked the anonymousity I had. =) shh. 18:56 <+MrHairgrease> just set the number to the correct level and restart 18:57 -!- perlmonkey2 [n=perlmonk@casr-dev.fwsm2ppuser.ou.edu] has joined #webgui 18:57 <@rizen> elnino: now it's a secret between the 25 of us. =) 19:01 -!- BartJol [n=plainstu@194.171.50.123] has left #webgui [] 19:03 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has joined #webgui 19:03 -!- mode/#webgui [+v perlDreamer] by ChanServ 19:03 < topsub> lol 19:06 -!- dapperedodo [n=dappered@194.171.50.69] has quit ["Leaving"] 19:09 < bopbop> perlDreamer: I'm editing your dev chapter, and I think a word is missing in the first part of this sentence: When the test, the contents of $TODO will be appended to the test comment and the test will be counted as passing. 19:09 < bopbop> runs, completes...? 19:09 < bopbop> can you fill in a blank for me/ 19:10 <@preaction> runs 19:10 < bopbop> thanks 19:10 <+perlDreamer> runs 19:10 < bopbop> thanks to you too:) 19:10 <+perlDreamer> that's the crying part that we discussed earlier 19:10 <+perlDreamer> Hopefully soon you'll get to the laughing part 19:10 < bopbop> I remember.. 19:10 <@preaction> you'll laugh? you'll cry? you'll eat humble pie? 19:10 < bopbop> I'm enjoying the hotdog-hamburger-pizza scenarios 19:10 <@preaction> when does she get to the pie? 19:11 < bopbop> can relate 19:11 <+perlDreamer> No pie, bad for the kids' teeth 19:11 < bopbop> wouldn't make wife happy 19:11 <+perlDreamer> I used a family motif for all my test examples 19:11 <+MrHairgrease> i usually use beer motifs 19:12 <+MrHairgrease> talking of which 19:12 <+MrHairgrease> it's time to go home 19:12 <+MrHairgrease> later 19:12 -!- MrHairgrease [n=martin@194.171.50.69] has left #webgui [] 19:18 <+perlDreamer> preaction: If you like, I can send you the raw, needing edits copy when I get home. 19:18 <@preaction> no need, i've still gotta finish my chapter. it needs more input 19:19 <+perlDreamer> cat /dev/null > preaction/chapter 19:19 -!- SquOnk [n=emhn@201.211.84.218] has joined #webgui 19:19 <@preaction> i wish 19:19 <@preaction> wait. don't you mean cat /dev/random > ~/chapter? 19:20 <@preaction> you can't read from /dev/null can you? 19:20 <+perlDreamer> yes 19:20 <@preaction> but it's null. 19:20 <@preaction> it's not 0 or random or 19:20 < SquOnk> rizen: Hi 19:21 <+perlDreamer> SquOnk: rizen is busy hacking. Do you need some help or want to volunteer some help? 19:22 < SquOnk> perlDreamer: I've been working to create webgui's Debian package. I uploaded 7.4.28 on my private repository last week, and just uploaded 7.4.31 after testing the automatic upgrades... 19:22 < SquOnk> perlDreamer: ...so I wanted to let him know that it was going ok and we'll soon see webgui being included as an official Debian package. 19:22 <+perlDreamer> cool. We really appreciate you doing that. 19:23 < SquOnk> perlDreamer: The package is up for download in my private repository (http://itverx.com.ve/debian/pool/main/w/webgui/webgui_7.4.31-1_all.deb 19:23 < SquOnk> (Debian users can use http://itverx.com.ve/debian directly, of course) 19:27 < elnino> hmmm. looking at surveys some more, sequencitla ordering of questions does it by the order of creating the questions, is there a way to get it to present them in the order that I ordered them using the arrows? 19:27 < SquOnk> The packages are for Debian Sid. I will backport to Debian Etch in three weeks time. 19:30 <+perlDreamer> We're probably going to find ourselves awash in new users soon, then :) 19:31 < SquOnk> perlDreamer: That's the idea... 19:31 <@rizen> SquOnk: nice job 19:31 < CIA-21> WebGUI: martin * r6030 /branch/WebGUI_Commerce/lib/WebGUI/ (4 files in 3 dirs): Adding the ITransact driver. Partly finished, not yet tested, but compiles. 19:32 <+perlDreamer> Is this like an unwrapped WRE, then, using Debian's native packages and new requirements? 19:32 < SquOnk> perlDreamer: After you do aptitude install webgui 19:32 <@rizen> sorry i didn't answer you before. i'm trying to limit my irc reading to specific intervals rather than doing it interactively so i can finish up the commerce system 19:32 < SquOnk> perlDreamer: You get a WebGUI install that complies with Debian Policy. 19:32 < elnino> yeah new users!! 19:32 < SquOnk> Briefly: 19:33 < SquOnk> You have modules in /usr/share/webgui 19:33 < SquOnk> You have the 'uploads', 'extras' and additional variable stuff in /var/lib/wegui 19:33 < SquOnk> You have logfiles in /var/log/webgui with _automatic_ rotation enabled. 19:33 < SquOnk> You get configuration files in /etc/webgui 19:33 < SquOnk> You get a standard Apache configuration that you simply have to symlink in place. 19:34 < SquOnk> You get /etc/init.d/webgui to start/stop/check on Spectre. 19:34 < SquOnk> In the current version, you must create the database by hand and/or run the upgrades script if needed. 19:35 < SquOnk> Once the package is approved, I will add debconf/dbconfig support; these are Debian tools to ask the user for configuration parameters and handle databases. 19:35 < SquOnk> From then on, when you do aptitude install webgui, it will ask you how do you want your webgui database to be named, user, password, server, etc. and the configuration file will be generated on the fly. If you _upgrade_ the package afterwards, those parameters are _automatically_ taken into account. 19:36 < SquOnk> debconf can use the console (line oriented), full-screen (curses oriented) or GUI interfaces, so it will choose the appropiate mean to communicate with the user regardless of where she's working at the time of install. 19:37 < SquOnk> I also plan on adding automatic upgrade facilites, by automatically running the upgrade scripts. 19:37 < SquOnk> The sbin scripts have been integrated into the system, so you don't have to say /usr/share/webgui/sbin/testEnvironment.pl, but simply wg_testEnvironment 19:38 < SquOnk> I am writing manpages for the sbin scripts (I'll send them once finished). Having manpages for supporting scripts is mandatory for any Debian package... 19:39 <+perlDreamer> most of the sbin scripts have POD or online usage statements (--help), that should give you a semi-decent start 19:39 < SquOnk> perlDreamer: That's what I'm using. 19:39 <+perlDreamer> if they all used POD, would that help with future updates? 19:40 < elnino> what does "no route to host" mean when trying to connect to a proxy site? 19:40 <+perlDreamer> then you could just run pod2man instead of writing the *roff by hand 19:40 < SquOnk> perlDreamer: Yes, as long as pod2man gets them out cleanly and no sections are missing Debian policy-wise. 19:40 <@preaction> there's a pod2man or somesuch probably 19:40 <@preaction> elnino, it means the proxy can't connect to where you want it to connect probably\ 19:41 < SquOnk> I have just one suggestion: 19:41 < SquOnk> All the sbin and upgrade scripts need to find out where WebGUI's Perl modules are, and also the configuration file... 19:42 < SquOnk> ...but they do it with things like use lib "../lib" or even WebGUI::Session->create("../..",$config) 19:42 <+perlDreamer> yes 19:42 <+perlDreamer> not very relocatable 19:42 < SquOnk> perlDreamer: Exactly 19:43 < SquOnk> perlDreamer: I'm coping with that problem by having the source patched. It works fine, but it would _definitely_ be nice if that was also parameterized. 19:43 < SquOnk> perlDreamer: Same thing goes with the mod_perl preload script 19:44 <+perlDreamer> SquOnk: We have the same problem with the test suite (which doesn't need to be installed by default, b.t.w). Do you have suggestions for making it better? 19:45 < SquOnk> perlDreamer: I'm thinking of a good one... so far I've came up with having a single WebGUI::Configuration module exporting $webGUIroot or something... 19:45 < SquOnk> perlDreamer: So there's only one thing to locate :-) 19:45 <+perlDreamer> ah, but where do you put WebGUI::Configuration? Is it /usr/lib/perl5... ? 19:46 < SquOnk> perlDreamer: That's a packaging question, so each distribution will choose the appropiate place. The first step is having a relocatable application by means of a parameterized application root. 19:47 < SquOnk> perlDreamer: Another thing, mostly cosmetic (but also along Debian Polciy) is that most of the scripts don't have a shebang line. 19:48 < SquOnk> perlDreamer: But I understand the reasoning for that, since your application could run on different OSes with Perl installed "who knows where" 19:48 <+perlDreamer> exactly 19:48 <@preaction> #!/usr/bin/env perl <- would work 19:48 <+perlDreamer> does that work on Windows? 19:48 < SquOnk> perlDreamer: Besides, It's a simple one-liner to fix that and it happens while packaging so it's no biggie 19:49 < SquOnk> However, being consistent in the use of $webGUIroot in every script is a good step into simplifying packaging and installation. 19:50 < SquOnk> So, ponder on it for a while. If I come up with a better solution I'll let you know :-) 19:50 <+perlDreamer> It's possible that those changes could be folded into 7.5. I would make a posting to the WebGUI Dev list with all of those suggestions and ideas. 19:56 < SquOnk> I _think_ I have a solution but it scares me :-) 19:56 < SquOnk> package WebGUI::Config 19:56 < SquOnk> $main::webguiroot = '/some/path' 19:56 < SquOnk> 42; 19:56 < SquOnk> Heh 19:56 < SquOnk> Haven't tested it. It's beautiful and scary :-) 19:59 <@rizen> the scripts use webguiroot to figure out what lib to include so that it can find WebGUI::Config 19:59 <@rizen> so that wouldn't work 20:00 < jfluhmann> rizen, the texasoss.org conference has just under 60 attendees currently registered. I was hoping for ~200, but it's likely to be around 100 20:01 -!- Netsplit orwell.freenode.net <-> irc.freenode.net quits: diakopter 20:02 <@rizen> jfluhmann: do you have any idea who your attendees are? Business owners? Students? IT Professionals? Software developers? etc? 20:04 -!- Netsplit over, joins: diakopter 20:05 < jfluhmann> it's a mix of students, business owners, IT professionals, K-12 and higher ed technology support 20:06 < jfluhmann> I was trying to get a good college crowd with the hopes of encouraging them to look at open source 20:07 < jfluhmann> My hope would be to encourage them to attend some of the summer conferences, such as YAPC, OSCON, and such 20:07 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has quit [Remote closed the connection] 20:07 < perlmonkey2> hmm....6 hour drive. 20:08 < jfluhmann> :-) There are a few people coming from Houston (~7.5 hour drive) 20:08 <@rizen> i see that you have a speaker slot open...if i can swing it would you like me to come speak? 20:09 < jfluhmann> rizen, that would be great! 20:09 < perlmonkey2> If rizen goes, I'll have to see if I can drive down and jeer from the audience. 20:09 < jfluhmann> I believe there are a few people wanting to do something on that following Sunday 20:10 < perlmonkey2> "perl is for lusers and webgui is so sorry i can't even run it on my $5 hoster!" 20:10 <@rizen> there's less than a 20% chance i can make it 20:10 <@rizen> so don't get your hopes up 20:10 < jfluhmann> Jeff Rush (Python) mentioned it and a few others said they could do some informal workshops/tutorials 20:11 < jfluhmann> rizen, I understand. It's a fair distance from there to here 20:11 <@rizen> that's not the issue 20:11 <@rizen> just 2 days before that i'm going to be doing another trade show 20:11 < jfluhmann> ah 20:11 <@rizen> which i'll be at for 4 days 20:12 < jfluhmann> Web 2.0? 20:12 <@rizen> so i'd have to rearrnage flights 20:12 <@rizen> and stuff 20:12 <@rizen> no, it's a manufacturers conference 20:12 <@rizen> too bad. the thing i was thinking about talking about is already covered: Making Money by Giving Things Away: Open Source as a Business Model for Technology Companies - John Wohn 20:13 < jfluhmann> ah, okay. I knew that O'Reilly's Web2.0 conference was that week. 20:13 < jfluhmann> yeah, should be an interesting talk 20:13 <@preaction> anyone here have experience with character encoding issues in mysql? i've got latin-1 data in a utf-8 column and i'm having difficulties changing that to utf-8 data in that utf-8 column in a way that will be portable and useful 20:14 <@rizen> mine would have been better. =) 20:14 < jfluhmann> rizen, :-) 20:14 <@preaction> this is due to the new 7.5.8 forcing all mysql connections to be in UTF-8, no matter how mysql is configured 20:14 <@rizen> preaction: i have problems with it all the time, but have no solutions 20:14 <@rizen> but you should talk to Haarg, cuz he's spending all day on this very topic 20:15 < perlmonkey2> preaction: have you tried pulling the data back down to perl, forcing and encode to latin-1, then encoding back to utf8? 20:15 < perlmonkey2> preaction: but that will likely be lossy as any latin-1 chars that don't fit nicely into utf8 will be munged. 20:15 <@preaction> for some reason, reading the data out during a Latin-1 connection and writing it back in a UTF-8 connection (no re-encoding) works 20:15 <@preaction> but I can only do that if I use key columns as references, which I can't rely on 20:15 <@preaction> i suppose i could make a temporary auto-increment column 20:16 <@preaction> perlmonkey2, tried that. i don't know why it didn't work, that was my first guess 20:18 <@preaction> basically i'm asking around because i'm tired of poking in the dark. i'd rather know what the hell is going on, even though that will take longer than just pushing through the hacky solution i have 20:18 < perlmonkey2> Mighten the damage already be done if you have latin-1 data in a utf8 column? any latin-1 chars that don't have the exact same codespace in both encodings will already be fudged. 20:18 -!- MrHairgrease [n=martin@x032124.its-s.tudelft.nl] has joined #webgui 20:18 -!- mode/#webgui [+v MrHairgrease] by ChanServ 20:19 < perlmonkey2> preaction: ask aroudn on #perl.....lots of encoding gurus there. 20:19 <@preaction> perlmonkey2, i thought of that, but why then does the data read out right when I use a latin-1 connection? 20:19 <@preaction> and, why does it convert when I write the same character data back using a utf-8 connection? 20:20 < perlmonkey2> sounds like something under the hood is doing a lot of leg work for you. 20:20 < perlmonkey2> DBI? 20:20 < perlmonkey2> maybe mysql? 20:20 < perlmonkey2> I never understood how that worked as it seems like it would require some sort of heuristic to determine encodings. 20:20 < perlmonkey2> Encoding::Magic 20:22 < perlmonkey2> hm.....Mysql{'latin1 data in utf8 encoding'}->perl{'latin1 in internalPerl econding'}->Mysql{'utf8'} is the problem, right? 20:22 <@preaction> exactly. i get that there's a difference between the binary and the character i see. i get that latin-1 means different binary for a character than utf-8. i just don't get how the hell NOT changing that encoding works but changing it just makes it worse 20:23 < perlmonkey2> preaction: hah, welcome to my world of data mining the web...... 20:23 <@preaction> that's all i can think it would be, but let's go broader 20:24 <@preaction> the CREATE TABLE statement for my table sets the table's charset to utf8, and does not override it in the column definition 20:24 < perlmonkey2> i woudl examine the original text for bad chars. if you don't see any, then you could (for some cases) safely call the text utf8... 20:25 <@preaction> there is bad chars, hence this whole rigamarole 20:25 < perlmonkey2> quotations and apostrophes? 20:25 <@preaction> the character_set_client is latin1, the character_set_results is latin1, so the data being sent to clients is in latin1 20:25 <@preaction> along with international characters 20:26 <@preaction> what if the problem wasn't mysql, but it was perl? 20:26 <@preaction> i mean, from all i've read, perl handles unicode and utf-8 silently and does the right thing 20:26 <@preaction> what if it didn't? 20:26 < perlmonkey2> could be....save soem data as text directly from mysql, then open in file readers using different encodigs. 20:27 < perlmonkey2> I've read nearly all of the perl utf8 docs, and I still dont' undestand how it works. 20:29 -!- perlmonkey2 [n=perlmonk@casr-dev.fwsm2ppuser.ou.edu] has quit ["survey survey survey"] 20:51 -!- SquOnk [n=emhn@201.211.84.218] has quit ["Yippie kay-ai-yay fudder muckers!"] 20:55 <+perlDreamer> I have a script that makes two Asset Products, and then makes a revision of one of them. 20:55 <+perlDreamer> When I look in the Products table, I see three entries 20:55 <+perlDreamer> When I try to join Product with wobject to see more data, I see 5 entries. 20:55 <+perlDreamer> Each of the entries for the asset with revisions is doubled 20:56 <+perlDreamer> this is the query that I used: 20:56 <+perlDreamer> select * from Product INNER JOIN wobject on Product.assetId=wobject.assetId; 20:57 <+MrHairgrease> don't forget the revisionDate 20:57 <+perlDreamer> why would it multiply the rows? 20:58 <+MrHairgrease> you get a copy of identical rows? 20:58 <+MrHairgrease> let me try that 20:58 <+perlDreamer> I checked in the script into t/Shop/loadProduct.pl 20:58 <+MrHairgrease> heh Empty set 20:58 <+MrHairgrease> let me try it on antoher table 20:59 <+perlDreamer> Run the loadProduct script to get some products to play with 20:59 <+perlDreamer> that way it's apples to apples 20:59 <+MrHairgrease> ok 20:59 <+MrHairgrease> hang on 20:59 <+perlDreamer> this is what I get: http://webgui.pastebin.com/m4db309c8 20:59 <+MrHairgrease> updating... 21:00 -!- perlmonkey2 [n=kmurphy@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 21:00 <+perlDreamer> perlmonkey2: Did you meet the Monday deadline, or are the natives restless? 21:00 <+MrHairgrease> yeah pd 21:00 < perlmonkey2> the natives are restless and started a fire under the man sized pot. 21:00 <+MrHairgrease> it's doing all permutations 21:00 <+MrHairgrease> add the revisionDate 21:01 <+perlDreamer> that means I can use mysql as a general purpose calculator :) 21:01 <+perlDreamer> select p.assetId, p.revisionDate, w.revisionDate from Product as p JOIN wobject as w on p.assetId=w.assetId and p.revisionDate=w.revisionDate; 21:01 <+perlDreamer> better 21:03 <+MrHairgrease> that works right 21:03 <+MrHairgrease> ? 21:03 <+perlDreamer> yes 21:04 <+MrHairgrease> you have to do that b/c inner join joins every row in table a with every row in table b matching the criteria you feed it 21:05 <+MrHairgrease> and since assets are not uniquely defined by assetId, you get N results for each assetId 21:05 <+perlDreamer> is there a better join to use, or is this just part of my sql education? 21:05 <+MrHairgrease> where N is the number of revisions of that asset 21:05 <+MrHairgrease> N^2 21:05 < perlmonkey2> holy crap.....assetId doesn't uniquely define an asset? 21:05 <+perlDreamer> no 21:05 <+MrHairgrease> inner is equivalent to , 21:05 <+perlDreamer> you need the revisionDate, too 21:06 <+MrHairgrease> well assetId is unique for an asset 21:06 < perlmonkey2> hmm....I'm not sure if that is a big deal with concern to my collaterals 21:06 <+MrHairgrease> but not the version of it 21:06 <+MrHairgrease> no it isn;t 21:06 <+MrHairgrease> versioning is for the asset properties 21:06 <+MrHairgrease> the crap you put in definition 21:06 < perlmonkey2> whew.....almost had give up my license to use a keyboard. 21:06 <+MrHairgrease> colateral usually doesn't need that 21:07 <+perlDreamer> collateral isn't versioned 21:07 <+perlDreamer> lineage isn't versioned 21:07 <+perlDreamer> parentId isnt' versioned 21:07 <+MrHairgrease> basically it's like this 21:07 <+MrHairgrease> all the properties that are equal for each revision 21:07 <+MrHairgrease> think lineage, className etc 21:07 <+MrHairgrease> are in the asset table 21:08 <+MrHairgrease> that one does not have a revisionDate since it has unversionable content 21:08 <+MrHairgrease> then,, for each class 'layer' you have a seprate table which is versioned 21:08 <+MrHairgrease> thos tables contain the definition fields of the 'layers' 21:09 <+MrHairgrease> what do i mean with 'layers'? 21:09 < perlmonkey2> ? 21:09 <+MrHairgrease> well 21:09 <+MrHairgrease> WebGUI::Asset => assetData table 21:09 <+MrHairgrease> WebGUI::Asset::Wobject => wobject table 21:09 < perlmonkey2> oh, I see 21:09 < perlmonkey2> that makes sense 21:10 <+MrHairgrease> WebGUI::Asset::Wobject::Article => article table 21:10 <+MrHairgrease> yeah 21:10 <+perlDreamer> WebGUI::Asset => assetData table (and asset table, too) 21:10 <+MrHairgrease> no 21:10 <+perlDreamer> that module handles both tables 21:10 <+MrHairgrease> that is for the unversionable data 21:10 <+MrHairgrease> sure it does 21:10 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has joined #webgui 21:10 <+MrHairgrease> but it's not storing the properties 21:11 <+MrHairgrease> it stores state information and hierarchy location 21:12 <+perlDreamer> Yes, I see your point now. 21:14 * perlDreamer heads to the gym 21:40 < topsub> created an accordian menu with jquery.. fun.. lol 21:41 < topsub> with an navigation object of course 21:43 < perlmonkey2> topsub: publicly available? 21:47 < perlmonkey2> Shoudl this: http://pastebin.com/d9a7c823 have really been so hard to write? 21:51 < perlmonkey2> The good news is a lot of those params I'm currently hitting the db for every time can be passed to the client as hidden params, so that the next time the db queries can be skipped. 22:01 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has quit [Read error: 110 (Connection timed out)] 22:06 < perlmonkey2> hmm, so table alias are not used in the keys of hash refs returned by SQL? 22:06 < perlmonkey2> so select s.*,q.* won't work if s and q share a column name. 22:06 < perlmonkey2> That is no gouda. 22:10 * perlmonkey2 prepares his fingers for a whole lot of select columnName as 'uniqueCname' 22:11 -!- Netsplit orwell.freenode.net <-> irc.freenode.net quits: SDuensin 22:14 -!- Netsplit over, joins: SDuensin 22:15 < topsub> perlmonkey2, i can add it to webgui addons 22:16 < perlmonkey2> topsub: oh, I just wanted to look at the code.....see if I liked it better than the YUI menus. 22:16 < perlmonkey2> also curious as to what a navigation object is. 22:18 < perlmonkey2> How about this for the hashref key issue in SQL selects. q.*, a.*, q.dupedColumnName as 'qDupedColumnName', a.dupedColumnName as 'aDupedColumnName'.....Eh? Not too shabby? 22:18 * perlmonkey2 ponders the lengths he will go to, to not have to type out all the column names in a select. 22:25 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has joined #webgui 22:25 -!- mode/#webgui [+v crythias] by ChanServ 22:34 -!- snapple42 [n=snapple4@h216-18-80-132.gtconnect.net] has joined #webgui 22:39 <+MrHairgrease> perlmonkey2: it's not SQL.pm that does that 22:39 <+MrHairgrease> but rather m,ysql itself 22:41 < perlmonkey2> Yeah, I didn't really figure it was SQL.pm, but in DBI or the specific driver. 22:41 <+MrHairgrease> no 22:41 <+MrHairgrease> it is also not in dbi 22:41 <+MrHairgrease> mysql does it 22:42 <+MrHairgrease> try the same query in the mysql client 22:42 <+MrHairgrease> putting the rows in a hash causes the overwrite 22:43 < perlmonkey2> just tested it and you are absolutely correc.t 22:43 <+MrHairgrease> i'm not sure if you can tell mysql to return column names prepended with table name 22:43 < perlmonkey2> oh well, easy enough to get around the duplicated column names. 22:43 <+MrHairgrease> yeah 22:44 <+MrHairgrease> that's what i do too when i have to 22:44 < perlmonkey2> and either way beats dealing with each row as an array. 22:44 <+MrHairgrease> indeed 22:50 -!- metanil [n=akhadka@137.48.138.72] has joined #webgui 22:53 < metanil> if what to execute a perl script that would access files uploaded through webgui.. and this script will return HTML that should appear in the body section... any hint?? ( i already write script..but i can only execute through "Operation" ) 22:54 < topsub> perlmonkey2 i used the webgui nav object for front end nad used jquery to show / hide layers 22:54 < topsub> i am taking off home so if i see you online i will post my code for you to see 22:54 < topsub> i have enjoy jquery very lightweight 22:54 < topsub> YUI to me just has more built in functions that you have to do with jquery 22:54 -!- topsub [n=josh@97.66.185.250] has quit [Remote closed the connection] 22:58 <+perlDreamer> perlmonkey2: The Navigation Asset is a front end for templating navigations in WebGUI. You tell it which Asset to start indexing and in which directions, how deep and what kind of relatives to return. 23:02 <+perlDreamer> Anybody know who the guy adding themes to wG is? ning? 23:02 <+MrHairgrease> ning is a girl 23:02 <+perlDreamer> Anybody know who the girl adding themes to wG is? ning? 23:02 <+MrHairgrease> and i'm not sure if she's adding stuff 23:02 <+perlDreamer> she's contributed 3 themes so far 23:03 <+MrHairgrease> yeah that's Ning 23:03 <+MrHairgrease> she works for Albert's company 23:04 <+MrHairgrease> but has a desk at Oqapi's at the momnet 23:04 <+perlDreamer> who is Albert? 23:04 <+MrHairgrease> since Oqapi and Pluton (Albert's company share office space 23:04 <+MrHairgrease> Albert is one of the three founders of Procolix 23:04 <+MrHairgrease> He was at the first two wucs 23:05 <+perlDreamer> So the original Procolix has split into 3 pieces? Procolix, Oqapi and Pluton? 23:05 <@rizen> Pluton is a testing company 23:05 <+MrHairgrease> yes 23:05 <+perlDreamer> Sounds like my kind of place :) 23:05 <@rizen> Albert is having Ning do stuff with WebGUI so she can write test cases 23:06 <@rizen> it's a training thing for her 23:07 < perlmonkey2> bah, didn't catch my new lappy in time....it booted to windows :( 23:07 < perlmonkey2> it has been defiled...I should just toss it. 23:08 <+perlDreamer> Just scrub that partition off the disk 23:08 < perlmonkey2> F8 anaconda is booting now....that's what I'm about to do :) 23:14 < metanil> how do we show data from either file or database in webgui??? 23:14 <+perlDreamer> from file, import it as a File. 23:14 <+perlDreamer> for Database, use the SQL Report or the SQL Form 23:14 < metanil> at runtime? 23:14 <+perlDreamer> or the Thingy 23:14 <+perlDreamer> at runtime? what do you mean? 23:14 < metanil> mean loading file from some path 23:15 < metanil> in machine 23:15 <+perlDreamer> how does the file get there in the first place? 23:15 < metanil> :D 23:15 <+perlDreamer> well, let me give you a few options 23:15 < metanil> i know my question is little dumb. 23:15 <+perlDreamer> There's not enough info in the question to really help you. It's not dumb. 23:16 < metanil> yes agree :) 23:16 <+perlDreamer> If the file is made by a program, have it update a Snippet inside of WebGUI instead. 23:16 < metanil> ok here's the situation 23:18 <+perlDreamer> go ahead, metanil, I'll wait for the whole scoop :) 23:18 < metanil> i have write some "script" that would process some local file (for now)..and i'll generate some HTML from them.. i can print that HTML in console as well.. but when i return it.. i should be shown in body part 23:18 < metanil> if do directly return.. it would only show that html.. 23:19 < metanil> i use Operation .. like ?op=blahblah.. (not a good though i guess) 23:19 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has joined #webgui 23:19 <+perlDreamer> No, not for this 23:19 < metanil> brb :( 23:19 <+perlDreamer> no problem 23:21 < metanil> is it a good way to do that 23:21 < metanil> ? 23:21 <+perlDreamer> no, you probably don't want to use an operation to do that 23:21 < metanil> i think opration is the best to run some method directly .. 23:22 <+perlDreamer> Here are some options to consider 23:22 <+perlDreamer> 1) Use the ^Include() macro to include your HTML into some Asset. 23:22 <+perlDreamer> 2) Change your script to insert the HTML into a db, and use the SQL macro, or the SQL Report to pull it out of the db and display it. 23:23 <+perlDreamer> 3) Change your script to add new versions to a Snippet inside of WebGUI. 23:23 < metanil> 2) --> thats why i ask question about db.. thinking about putting them into db.. 23:23 < metanil> ok.. sounds great.. 23:23 <+perlDreamer> But where does the original file come from? 23:23 < metanil> i put it locally for now. 23:24 < metanil> but later .. it should be uploaded.. 23:24 <+perlDreamer> What if it was just an Article asset that a user edits? 23:24 < metanil> still haven't think about how to get uploaded file within webgui 23:24 < metanil> umm.. i use Folder Asset to upload file. 23:25 < metanil> i modified the code a little bit .. and made browsing directly from the page without going to admin mode. 23:26 < metanil> i mean file browsing for uploading. .and save directly. 23:26 < metanil> anyway,, it will go into wegui db. 23:27 < metanil> i think its the second part.. first .. i need get done with the first one.. showing some HTML assuming i have input file already.. 23:28 < metanil> perlDreamer: u mean the HTML would directly put it in Article asset directly by user? 23:28 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has left #webgui [] 23:28 <+perlDreamer> sure, that's what it is for 23:29 <+perlDreamer> there is a WYSIWIG editor 23:29 <+perlDreamer> and a group system to control access 23:29 <+perlDreamer> WebGUI is designed to help save you time 23:29 < metanil> yes i should do a little bit processing before that.. 23:29 <+perlDreamer> that's why I asked where the file comes from in the first place 23:30 <+perlDreamer> is it a computer generated report, or some file from a user? 23:30 < metanil> yes.. agree.. the uploading put that data that should be internally processed 23:30 < metanil> uploading = uploading user 23:30 < metanil> file from a user.. 23:30 <+perlDreamer> where do they get the file from? 23:31 < metanil> they've got some wierd file.. basically csv.. so i need to parse it.. get the right element.. create some kind page with links.. and form as well. 23:32 <+perlDreamer> I see. It sounds like a db is the way to go then. 23:32 <+perlDreamer> Put the CSV right into the db with some script, and the do a simple query to get it via the SQL Report. 23:33 < metanil> how do i put that CSV "so called" into the db.. 23:34 < metanil> i read in webgui site that if want to get access to webgui db then i should create Asset for it.. (or sql form/report ) 23:34 <+perlDreamer> You write a small script that uses the WebGUI configuration file to open a WebGUI Session. Then you use $session->db method to put stuff into a separate table in the db. 23:35 < metanil> hmm.. sound good.. 23:35 < metanil> brb :( (damn!!!) 23:35 -!- MrHairgrease [n=martin@x032124.its-s.tudelft.nl] has left #webgui [] 23:35 <+perlDreamer> in the sbin directory there should be a skeleton file that you can use to start your script 23:36 <+perlDreamer> _utility.skeleton 23:40 < SynQ> hi there 23:40 <+perlDreamer> hello 23:40 < SynQ> can I check out a wre version from svn? 23:40 < SynQ> and if yes, how? 23:40 <+perlDreamer> in source format? 23:40 < SynQ> indeed 23:40 < SynQ> oh, and, good news! 23:40 < SynQ> Tessa is coming to the WUC! 23:41 <+perlDreamer> svn co https://svn.webgui.org/plainblack/wrebuild 23:41 <+perlDreamer> All right! Is she part of the invasion force? 23:41 < SynQ> yes 23:41 < SynQ> but not listed yet 23:41 < SynQ> and, we are going to have our holiday attached to the WUC too 23:42 < SynQ> how far is the cuskie's home from Madison? 23:42 <+perlDreamer> far 23:42 < SynQ> how far? 23:42 <+perlDreamer> 2013 miles 23:42 < bopbop> you'd want to invade the Smith, Dillon, or McCombs house from Madison...Kuskie is across country 23:43 <+perlDreamer> http://maps.google.com/maps?f=d&hl=en&geocode=&saddr=1025+SE+36th+Ave+Hillsboro+Oregon&daddr=Madison+Wisconsin&sll=37.0625,-95.677068&sspn=53.741627,91.230469&ie=UTF8&t=h&z=5 23:43 < bopbop> you could also invade the preaction house 23:43 <+perlDreamer> We should have rented out the Ruby Marie 23:43 <+perlDreamer> Stupid Madison food fest 23:43 <+perlDreamer> that's land miles, not air miles 23:43 < bopbop> is Taste of Madison that weekend? 23:43 <+perlDreamer> yes 23:44 <+perlDreamer> In air miles it's farther since you have to fly to Atlanta to get to Madison 23:44 < SynQ> ah 23:45 < SynQ> McCombs sounds nice 23:45 < SynQ> Smith is allready on the list 23:45 < SynQ> Dillon sounds good 23:45 < bopbop> come on over... Dillon is good too, we're in the same town 23:45 < bopbop> and we have more booze than Smith 23:45 < SynQ> man 23:46 < SynQ> perlDreamer: that is far 23:48 < SynQ> perlDreamer: now I have a checkedout wre source version revision 6030 23:48 < SynQ> how do I know what revision wre 0.8.3 was? 23:50 -!- SDuensin [n=Scott@84.sub-75-206-54.myvzw.com] has quit ["Leaving"] 23:50 <+perlDreamer> by browsing through the svn version history 23:50 <+perlDreamer> https://svn.webgui.org/svnweb/plainblack/log/wrebuild/ 23:50 <+perlDreamer> You should become friends with https://svn.webgui.org 23:50 <+perlDreamer> very, very helpful 23:51 <+perlDreamer> I started a wiki page with WebGUI commits versus version info, but it's lapsed 23:53 < SynQ> but https://svn.webgui.org/svnweb/plainblack/browse/wrebuild/ says it is at revision 5976 23:53 < SynQ> and I checked out version 6030 23:54 -!- jfluhmann [n=jfluhman@x172y028.angelo.edu] has quit [Remote closed the connection] 23:54 < SynQ> Last Changed Rev: 5976 23:54 < SynQ> Revision: 6030 23:54 < SynQ> hm 23:57 < SynQ> well, I guess that is not what I am after 23:58 <+perlDreamer> the whole repository is shared. You did check out 6030, but it's the same as 5976 23:58 < SynQ> ah ok 23:58 < SynQ> I'm going to suggest some enhancements to the utility scripts in /data/wre/sbin 23:58 -!- snapple42 [n=snapple4@h216-18-80-132.gtconnect.net] has quit ["Leaving"] 23:59 <+perlDreamer> excellent 23:59 <+perlDreamer> snapple42 was an internet consultant from Canada 23:59 < SynQ> and I figured the best way to suggest them is diff them against the current svn version 23:59 < SynQ> ah 23:59 <+perlDreamer> those are excellent suggestions --- Day changed Thu Apr 03 2008 00:00 < SynQ> ok 00:00 < SynQ> now I've got to focus on that for a while 00:00 < SynQ> be back later 00:15 -!- bopbop [n=kmccombs@71-82-214-154.dhcp.mdsn.wi.charter.com] has quit [] 00:16 -!- perlmonkey2 [n=kmurphy@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 00:22 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 00:33 < SynQ> I wonder, would JT have a script to download all the prereqs for the WRE and then especially for the perl modules 00:33 <@rizen> no 00:33 < SynQ> ah 00:33 <@rizen> download the source version of the wre from sourceforge 00:34 < SynQ> ah 00:34 < SynQ> I'm going to try and build a WRE with all the latest stable versions of the prereqs 00:34 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 00:34 <@rizen> copy the the "source" folder out of it and into your svn copy 00:34 < CIA-21> WebGUI: jt * r6031 /translations/Spanish/Spanish/ (Asset.pm WebGUI.pm WebGUIProfile.pm): update_from_translation_server 00:34 < SynQ> I've found out what versions they are for all but the enormous list of perl modules 00:35 <@rizen> having such a script probably wouldn't be a bad idea 00:35 <@rizen> just haven't gotten around to it 00:35 < SynQ> ok 00:35 < SynQ> I'll send you mine :) 00:35 < SynQ> hang on 00:35 < metanil> perlDreamer: you said, "You write a small script that uses the WebGUI configuration file to open a WebGUI Session. Then you use $session->db method to put stuff into a separate table in the db" 00:36 < SynQ> it's in your mailbox 00:37 < metanil> perlDreamer: do i have to use file/folder to get the file into webgui? 00:40 <+perlDreamer> metanil, no 00:41 < metanil> O:-) 00:41 <+perlDreamer> in your script, just use file I/O 00:41 -!- Netsplit orwell.freenode.net <-> irc.freenode.net quits: vayde, +Radix-wrk 00:42 < metanil> oh oh ... i'm sorry.. i should make it clear.. ... "user should be able to upload their own "csv" file" 00:42 <+perlDreamer> and then you want to take _that_ file, and convert pieces of it to HTML 00:43 < metanil> yes.. have to use other perl library for it 00:43 -!- Netsplit over, joins: vayde, +Radix-wrk 00:44 <+perlDreamer> metanil, this is slowly growing to a non-trivial script 00:44 <+perlDreamer> when they upload a file, what happens to the old ones? 00:44 < metanil> :) 00:44 < metanil> replaced.. (webgui have a version management if they want previous one) 00:44 < metanil> :D 00:44 <+perlDreamer> so it's always the same file URL? 00:44 < metanil> yes 00:45 < SynQ> jt: how did you download all those perl modules last time, one by one and manually? 00:45 <+perlDreamer> hm 00:45 <+perlDreamer> how soon does the file have to be converted into HTML? 00:45 <@rizen> yes i did 00:45 < SynQ> man 00:45 < SynQ> I do not evy you 00:45 <+perlDreamer> SynQ: He'd like one of those scripts, too ;) 00:46 < SynQ> I'm getting that script done too 00:46 < SynQ> perhaps I should start wearing my monk suit now 00:46 < metanil> perlDreamer: its as soon as it get the file.. but totally depends on the file size they uploaded. 00:46 <+perlDreamer> this could be a big CSV file? 00:47 < metanil> not that big... (but i cannot say it right now).. the sample that i have is quite small.. 00:47 <+perlDreamer> well, the "as soon as it gets the file" makes it easy. 00:47 < metanil> and my script can process it instantly 00:47 <+perlDreamer> There's no built in way to do it automatically with WebGUI 00:47 < metanil> oops 00:48 <+perlDreamer> you need a new Asset, or, an extension to the File Asset that calls a Workflow 00:49 < SynQ> I'm going to include the dutch aspell module too :) 00:49 < metanil> easy to hear.. hard implement.. is it? 00:49 < SynQ> that should be part of webgui 00:49 <+perlDreamer> SynQ: I agree, but it isn't right now 00:49 < SynQ> I know 00:49 < SynQ> just wait 00:51 < metanil> you mean using workflow to run the script? 00:51 <+perlDreamer> yeah, or putting the script contents into a Workflow 00:52 < metanil> why do we need an extension to File Asset? 00:52 <+perlDreamer> How does your script know when to run? 00:52 < metanil> oh to trigger the workflow.. 00:52 <+perlDreamer> right :) 00:53 < metanil> ok.. that mean.. i should be looking at wiki to read about workflow. 00:53 <+perlDreamer> yes 00:53 < metanil> thanks.. (woot) 00:57 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 01:00 < metanil> perlDreamer: one quick questions.. how do the workflow know the location of file that it is getting (though this is always constant) ... File Asset just triggers it.. it won't sent the file, will it.? 01:03 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has joined #WEBGUI 01:04 -!- Netsplit orwell.freenode.net <-> irc.freenode.net quits: vayde, +Radix-wrk 01:09 < elnino> howdy.. 01:10 < elnino> had an sql reprot that worked dandy till I upgraded from 7.3 to 7.4.36, noticed the database parameters were taken out, so I put those back in to the db connection settup area. But query still doens't work. it as a select/union query 01:10 < elnino> I removed the union statemnt and it works. 01:11 < elnino> So I'm a little confused as to whether sqlreport doesn't support unions, or if something else is going on here... 01:11 < elnino> no errors in the logs 01:19 <+perlDreamer> metanil, the new workflow would have to be passed a copy of the File asset. 01:21 < metanil> thnx 01:24 -!- Netsplit over, joins: vayde, +Radix-wrk 01:43 <+perlDreamer> elnino, turn on debug in the SQL Report and see if that has any hints. 01:45 < elnino> I do, there are simply no errors, and I misspoke, I'm trying other things here. I brought this up long ago, and am now just revisiting, I think it has to do with my union and the longreadlen 01:45 < elnino> I'm running the query in sqlstudio with no errors. 01:46 <+perlDreamer> maybe longreadlen has to be longer? 01:47 < elnino> I did a diff between 7.4.26 and the 7.3.21 and used those values. 01:47 < elnino> diff on the SQL.pm - there weren't many changes between the two files, so I'm baffled. 01:48 <+perlDreamer> try diff on DatabaseLink, instead 01:48 <+perlDreamer> and check the gotchas file 01:49 <+perlDreamer> LongReadLen: 512*1024 01:49 <+perlDreamer> LongTruncOK: 1 01:49 <+perlDreamer> is that an Oracle DB, or ODBC connector? 01:50 < elnino> yep, that's how I found out aobut this, is the gotcha file. i set the two parameters on different lines in the database connection just as you have there, execpt I have 524288 01:51 < elnino> dbi:MaxDB:servername: 01:52 < elnino> port:dbname 01:53 <+perlDreamer> elnino: You need to be talking to dbDreamer instead of perlDreamer :) 01:54 < elnino> =) yeah, I only know enough to be dangerous. I wonder if those variables are case sensitive. I'll check. 01:56 <+perlDreamer> perlbot 512*1024 01:57 <@preaction> perlbot math 512*1024 01:57 < perlbot> 524288 01:57 <@preaction> elnino, you're logging INFO level at least? 01:57 < elnino> yep. 01:58 <@preaction> how about debug level? find the query in the debug output and see if anything happens after that 01:58 <@preaction> last resort is you're going to have to start messing around in the SQLReport, because unfortunately I dont think reproducing your problem will be easy 01:59 < CIA-21> WebGUI: jt * r6032 /branch/WebGUI_Commerce/ (10 files in 7 dirs): 01:59 < CIA-21> WebGUI: added item and sku caching to cart 01:59 < CIA-21> WebGUI: ribbon discounts now work 01:59 < CIA-21> WebGUI: checklist form control works more like you'd expect 01:59 < CIA-21> WebGUI: added badge groups 01:59 <+perlDreamer> He could tunnel us a connection to his db server :) 01:59 < elnino> I dont' think so. --- Log closed Thu Apr 03 02:09:58 2008 --- Log opened Thu Apr 03 02:15:17 2008 02:15 -!- xdanger [i=xdanger@i.should.be.in.a.mentalhouse.net] has joined #webgui 02:15 -!- Irssi: #webgui: Total of 23 nicks [4 ops, 0 halfops, 3 voices, 16 normal] 02:15 -!- Irssi: Join to #webgui was synced in 3 secs 02:26 < elnino> hmm. tried 2 and it displays 2 records. I'm using the default SQL report. I looked around in the code, but didn't see anything obvious. Posted a bug report. Sorry. Thanks for your help. 02:29 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has quit [Read error: 110 (Connection timed out)] 02:31 <+perlDreamer> elnino, if you really only want 1 thing returned, just use LIMIT 1 to the end of your SQL query 02:31 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has quit ["Download Gaim: http://gaim.sourceforge.net/"] 02:36 < elnino> I tried, I looked at the doc for maxdb 02:37 < elnino> it doesn't seem to work even in sql studio. 02:37 < elnino> I don't know if it is because of the complexity of the statment or what. or maybe the version of our db. 02:39 < elnino> i'll just do it by two untill next time I can revisit this 03:01 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has quit [] 03:16 -!- cap10morgan_ [n=cap10mor@h19-afsc.ded.indra.com] has quit [] 04:20 -!- cap10morgan [n=cap10mor@206-124-31-140.denver.dsl.forethought.net] has joined #webgui 04:29 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has quit [Read error: 104 (Connection reset by peer)] 04:30 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has joined #WEBGUI 04:31 -!- elnino [n=elnino@user-38q49cv.cable.mindspring.com] has quit [Client Quit] 04:41 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has joined #WebGUI 05:26 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 05:26 < topsub> hi 05:54 < perlmonkey2> pong 06:49 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 07:07 < CIA-21> WebGUI: colin * r6033 /branch/WebGUI_Commerce/ (3 files in 3 dirs): more work on translating Asset Products to Sku Products 07:07 < CIA-21> WebGUI: colin * r6034 /branch/WebGUI_Commerce/lib/WebGUI/Shop/Cart.pm: fix typos in Shop/Cart.pm 07:09 -!- Radix_ [n=Radix@203.161.71.161.static.amnet.net.au] has quit [Read error: 104 (Connection reset by peer)] 07:09 -!- Radix_ [n=Radix@203.161.71.161.static.amnet.net.au] has joined #webgui 07:09 -!- mode/#webgui [+v Radix_] by ChanServ 07:12 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Read error: 104 (Connection reset by peer)] 07:17 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 07:30 < CIA-21> WebGUI: colin * r6035 /branch/WebGUI_Commerce/ (t/Shop/loadProducts.pl docs/upgrades/upgrade_7.5.2-7.5.3.pl): 07:30 < CIA-21> WebGUI: Finish database and config translation from Wobject/Product 07:30 < CIA-21> WebGUI: to Sku/Product. Now for the code. 07:58 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has quit [Read error: 110 (Connection timed out)] 08:13 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Read error: 110 (Connection timed out)] 09:49 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has joined #webgui 10:23 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has joined #webgui 10:23 -!- mode/#webgui [+o preaction] by ChanServ 10:38 -!- wgGuest30 [n=wgGuest3@195.116.30.251] has joined #webgui 11:02 -!- BartJol [n=plainstu@host2.procolix.com] has joined #webgui 11:07 < wgGuest30> s 11:07 -!- wgGuest30 [n=wgGuest3@195.116.30.251] has quit [] 11:19 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 11:19 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit [Read error: 110 (Connection timed out)] 11:41 -!- Radix-wrk [n=Jesse@203.161.68.67] has quit ["Leaving"] 12:06 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 12:06 -!- mode/#webgui [+o Haarg] by ChanServ 12:13 -!- CIA-21 [n=CIA@208.69.182.149] has quit [] 12:14 -!- jdanpl [n=jdanpl@195.116.30.251] has joined #webgui 12:21 -!- CIA-21 [n=CIA@208.69.182.149] has joined #WebGUI 12:24 < jdanpl> Anyone know how to build home forums page like http://www.webgui.org/forums ? 12:27 -!- BartJol [n=plainstu@host2.procolix.com] has quit [Read error: 113 (No route to host)] 13:26 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit [Remote closed the connection] 14:15 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has quit [Read error: 110 (Connection timed out)] 14:15 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has quit ["Leaving"] 16:14 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 16:17 -!- bopbop [n=kmccombs@71-82-214-154.dhcp.mdsn.wi.charter.com] has joined #webgui 16:42 -!- cap10morgan [n=cap10mor@206-124-31-140.denver.dsl.forethought.net] has quit [] 17:06 -!- jdanpl [n=jdanpl@195.116.30.251] has quit ["Leaving"] 17:13 -!- topsub [n=josh@97.66.185.250] has joined #webgui 17:16 -!- SDuensin [n=Scott@13.sub-75-207-182.myvzw.com] has joined #WebGUI 17:19 < SDuensin> Morning. 17:19 < topsub> hello 17:24 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 17:30 -!- ryuu_ro [n=rory@194.171.50.69] has quit [] 17:38 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 17:51 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has joined #webgui 17:54 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 17:54 -!- mode/#webgui [+o rizen] by ChanServ 17:54 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has joined #webgui 17:56 -!- cap10morgan_ [n=cap10mor@h19-afsc.ded.indra.com] has joined #webgui 17:56 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 17:56 -!- mode/#webgui [+o Haarg] by ChanServ 17:57 < CIA-21> WebGUI: jt * r6036 /branch/WebGUI_Commerce/lib/WebGUI/Asset/Sku/EMSTicket.pm: ribbon discounts now work with ribbons purchased previously 17:58 <@rizen> we cannot afford to have to cap10morgan's in this channel 17:58 <@rizen> it's too risky 18:00 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has quit ["Leaving."] 18:11 -!- cap10morgan [n=cap10mor@h19-afsc.ded.indra.com] has quit [Read error: 110 (Connection timed out)] 18:36 < CIA-21> WebGUI: graham * r6037 /WebGUI/ (docs/changelog/7.x.x.txt lib/WebGUI/Asset/Wobject/Survey.pm): fixed: unable to respond to poll multiple times in same session 18:36 < CIA-21> WebGUI: graham * r6038 /WebGUI/docs/ (4 files in 3 dirs): fixing database character sets 18:36 < CIA-21> WebGUI: graham * r6039 /WebGUI/lib/WebGUI/Workflow/Activity/GetCsMail.pm: typo 18:36 < CIA-21> WebGUI: graham * r6040 /WebGUI/ (docs/changelog/7.x.x.txt lib/WebGUI/Storage.pm): fixed: packages try to restore owner 18:39 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has joined #webgui 18:39 -!- mode/#webgui [+v perlDreamer] by ChanServ 18:40 -!- topsub [n=josh@97.66.185.250] has quit [Read error: 104 (Connection reset by peer)] 18:40 -!- topsub [n=josh@97.66.185.250] has joined #webgui 18:41 -!- wgGuest25 [n=wgGuest2@pool-68-160-17-155.bos.east.verizon.net] has joined #webgui 18:42 < wgGuest25> i need some major help 18:42 < wgGuest25> my site www.lynntimebank.org, was working on it, changed something on the left hand side 18:42 < wgGuest25> now all of a sudden when i try edit a page for example change the word she to he 18:42 < wgGuest25> the only option I have is HTML 18:43 <+perlDreamer> which version of WebGUI are you using? 18:43 <+perlDreamer> OSCON tutorial goodness: http://en.oreilly.com/oscon2008/public/schedule/detail/4219 18:44 < wgGuest25> Where can I find that 18:44 < wgGuest25> I just started this 18:44 < wgGuest25> I am an intern and this system was already in place when I got here 18:44 < wgGuest25> WebGUI Build Version: 5.5.4 18:45 <+perlDreamer> wow 18:45 <+perlDreamer> That is a really old version of WebGUI 18:46 < wgGuest25> we are a non profit organzation so they are never really intrested in upgrading anything 18:47 <+perlDreamer> well, WebGUI is free, so it doesn't cost you anything but time to upgrade 18:47 <+perlDreamer> In any case, I have no idea what would have caused your editing options to be only HTML 18:47 < wgGuest25> is there anyway to roll back in it? 18:47 <+perlDreamer> although it sounds like it works okay, just that you'd prefer not to use the WYSIWIG editor? 18:47 <+perlDreamer> Not in 5.5.4 18:47 < wgGuest25> they need it to be regular text 18:48 < wgGuest25> they edit the page alot so prefer it to be html 18:48 <+perlDreamer> You mean they want to edit the raw HTML, rather than a WYSIWIG? 18:49 < wgGuest25> Im sorry if Im not being clear, they want to log in, go to edit on a article, and just type john dow went to the market, they dont want to do (html( john doe (Font Size 11) 18:49 < wgGuest25> sorry how confusing this must sound 18:59 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has joined #webgui 18:59 -!- mode/#webgui [+o preaction] by ChanServ 19:12 <@apeiron> perlDreamer, OSCON would be nice if it wasn't for the $2k attendance price tag. =\ 19:13 <+perlDreamer> you can say that again 19:13 <+perlDreamer> it does make it nicer (less expensive) when it's in Portland 19:13 <@apeiron> For people *in* Portland. :) 19:14 <@apeiron> perlDreamer, Hey, by the way, I have a test question if you happen to have a moment? 19:14 <+perlDreamer> I'm on and off, but please feel free to ask 19:15 <@apeiron> Okie. I'm trying to write some tests for wG code that calls www_view and related methods. I'm using PseudoRequest, replaced $session->{_request} with the PR object, but it's still getting linker issues in the test. 19:16 <@apeiron> Also using getPage. As far as I know this should Just Work. Am I Doing It Wrong? Missing something? 19:19 <@apeiron> http://webgui.pastebin.com/m3ac369d3 is a pastebin containing the error if that'd help. 19:32 -!- wgGuest25 [n=wgGuest2@pool-68-160-17-155.bos.east.verizon.net] has quit [] 19:33 < bopbop> Haarg: is there an index of utility scripts anywhere that I can point readers to? 19:33 <@rizen> tell them to look in their WebGUI/sbin folder 19:33 < bopbop> ok, thx 19:36 <+perlDreamer> How 'bout WRE/sbin? 19:37 <+perlDreamer> apeiron, by default you should now always be getting a PseudoRequest object when you use WebGUI::Test (in 7.5) 19:37 <+perlDreamer> Can you paste the test code itself? 19:38 <@apeiron> I'll have to chop it down to something small, but yeah. 19:48 < bopbop> can someone give me a brief definition of WebGUI::Asset 19:48 <@apeiron> perlDreamer, http://webgui.pastebin.com/m6458c405 19:53 <@apeiron> Hm. Idea: since using getPage actually *does* produce the content I want, why not try to see if I can do what getPage does from within wG? 19:55 -!- jua1 [n=juangui@201.232.58.66] has joined #webgui 19:55 < jua1> hello 19:56 < CIA-21> WebGUI: graham * r6041 /WebGUI/docs/gotcha.txt: improving gotcha notice 19:56 < CIA-21> WebGUI: graham * r6042 /WebGUI/lib/WebGUI/Asset/Wobject/Article.pm: fixing article storage copying 19:56 < CIA-21> WebGUI: graham * r6043 /WebGUI/ (8 files in 6 dirs): preparing for 7.5.9 release 19:56 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has quit [] 19:57 < jua1> i have a collaboration system and i want to add a new field to it 19:57 < jua1> i am using default submission form 19:58 < jua1> the thing that i want is when i will add a new thread i can have an additional field to fill 19:59 < jua1> is it possible? is clear my question? 20:10 <@preaction> jua1, yes. alter the template to include a field with the name "userDefined1" or 2 - 5. there are 5 userDefined fields you can use 20:11 -!- Sebastian13 [n=sebastia@p57A722E1.dip0.t-ipconnect.de] has joined #webgui 20:11 < jua1> ok 20:12 < jua1> thanks, i am going to test 20:21 < jua1> preaction, I want to include in the collaboration system a new input text box 20:22 <@preaction> when someone creates a new thread, right? 20:22 < jua1> yes 20:22 <@preaction> so you have to add that input box to the template 20:23 <@preaction> and give it the name "userDefined1" 20:24 < jua1> ok 20:24 < jua1> i am going to try 20:29 <@apeiron> Ah. Seems this is the magic line I need: $session->http->{_http}->{noHeader} = 1; 20:36 <@preaction> that's what WebGUI::Test->getPage does 20:38 <@apeiron> Yeah, exactly. 20:40 -!- Sebastian13 [n=sebastia@p57A722E1.dip0.t-ipconnect.de] has quit ["Leaving"] 20:58 -!- cap10morgan_ [n=cap10mor@h19-afsc.ded.indra.com] has quit [] 21:00 -!- dionak_ [n=diona@97.66.185.250] has joined #webgui 21:45 * perlDreamer is colored confused 21:45 <+perlDreamer> if that's what getPage does, then why does apeiron get the apache request error? 21:45 <@preaction> because he wasn't using getPage 21:45 <@apeiron> perlDreamer, I'm not using getPage in the test. 21:46 <+perlDreamer> apeiron, you should use getPage in the test! 21:46 <@apeiron> The test is calling a www_ method but writing the contents of that method's output to disk. 21:46 <@apeiron> perlDreamer, ^^ It doesn't make altogether too much sense to getPage within WebGUI. :) 21:47 <@preaction> so it's not the Test that's calling the www_ method, but the method you're testing 21:47 <@apeiron> Yes. 21:47 <@apeiron> The test is making sure the right contents get spit out to disk. 22:02 -!- CIA-21 [n=CIA@208.69.182.149] has quit [] 22:11 -!- CIA-21 [n=CIA@208.69.182.149] has joined #WebGUI 22:16 -!- dionak_ [n=diona@97.66.185.250] has quit [] 22:28 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 22:31 < topsub> perlmonkey2, i put that accordian menu up on webgui.org under packages. if you would like to look at it 22:31 < perlmonkey2> cool thanks :) 22:32 < topsub> already got feedback for improvements Hopefully get to them today 22:41 -!- estiven [n=estiven@201.232.58.66] has joined #webgui 22:43 -!- SDuensin [n=Scott@13.sub-75-207-182.myvzw.com] has quit ["Leaving"] 22:53 <+perlDreamer> last night the smoke test picked up a syntax error in head. Did somebody already fix that? 23:24 < SynQ> trace - Module Reanmed to Devel::XRay 23:24 < SynQ> did you know that? 23:24 < SynQ> http://search.cpan.org/~jbisbee/trace-0.551/lib/trace.pm 23:24 < SynQ> J/JB/JBISBEE/Devel-XRay-0.941 23:24 < SynQ> zelfs 23:25 < SynQ> even 23:27 < SynQ> I wonder what 'to reanmed' is 23:27 < SynQ> I reanme 23:27 < SynQ> You reanme 23:27 < SynQ> We reanmed 23:31 < topsub> if i want to make a link to say edit a file then have it redirect to a certain page after can't i use the "proceed" in the link to do this? 23:31 < topsub> then it will redirect to the value of proceed after? 23:33 < GooeyOfSteel> Wiki: Override Core Modules - Edited on 4/3/2008 3:21 pm by knowmad http://www.webgui.org/community-wiki/override-core-modules 23:37 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 23:37 -!- mode/#webgui [+o rizen] by ChanServ 23:41 <+perlDreamer> topsub, afaik, proceed=screen will let you go to any www_screen in the asset. 23:41 < GooeyOfSteel> Wiki: WRE for Windows - Edited on 4/3/2008 3:29 pm by knowmad http://www.webgui.org/community-wiki/wre-for-windows 23:48 < topsub> perlDreamer, is there docs on that? 23:48 < metanil> perDreamer: one quick question....... can i do open (IN, $file); while () { .. }.... and $file is taken from storageID (that was uploaded into webgui)?? 23:52 <+perlDreamer> I would use the built-in storage methods for file I/O. getFileContentsAsScalar and so on 23:52 <+perlDreamer> perldoc WebGUI::Storage 23:52 <+perlDreamer> I don't know about docs for proceed. 23:52 <+perlDreamer> If not, I'll apply any POD patches you submit to both 7.4 and 7.5 23:53 < topsub> were can i find the www_screen i will look at the code 23:53 < topsub> in Asset.pm? 23:53 <+perlDreamer> "screen" would be any valid www_ method 23:53 < topsub> ooo 23:53 < topsub> hmm dunno if that will do what i thought it wold 23:54 <+perlDreamer> what do you want it to do/ 23:54 < topsub> i have a link on the front end of the website linking to edit a pdf, then after done editing the pdf threw the backend redirect back were tehy came from. 23:55 <+perlDreamer> I thought it went back to the parent's view method after editing a file by default? 23:56 < perlmonkey2> I'm trying to get my demo up and running on our centers webserver and keep getting this in http_erro "/data/domains/casr.ou.edu/public/extras/wobject/Survey" as part of a file does not exist error. Do I have my webgui config pointing at the wrong place for extras? 23:57 < topsub> hmm i have to look. perlDreamer 23:57 <@preaction> looks like 23:57 <@preaction> extrasPath should be /data/WebGUI/www/extras 23:58 -!- bopbop [n=kmccombs@71-82-214-154.dhcp.mdsn.wi.charter.com] has quit [] 23:58 < perlmonkey2> which is what I have in my casr.ou.edu.conf file. 23:58 < perlmonkey2> "uploadsURL" : "/uploads", 23:58 < perlmonkey2> "extrasPath" : "/data/WebGUI/www/extras", 23:58 <@preaction> are you using the ^Extras(); macro in your templates? 23:58 < perlmonkey2> no 23:59 <@preaction> ^/;extras/whatever should technically work though... but try it anyway 23:59 < perlmonkey2> it is even looking for the yui libs in the domain/public stuff --- Day changed Fri Apr 04 2008 00:00 < perlmonkey2> I don't want to put a macro in the template, I want to figure out why the config file is set correctly but webgui is looking in the domain dir for extras 00:00 < topsub> hmm not the result i am seeing 00:01 < perlmonkey2> vaary vaary peculiar 00:01 < GooeyOfSteel> Wiki: Customizing WRE Configuration - Edited on 4/3/2008 3:49 pm by knowmad http://www.webgui.org/community-wiki/customizing-wre-configuration 00:01 < topsub> i see it view the folder were the pdf file is 00:01 <@preaction> you have to use the ^Extras(); macro, because the "extrasURL" value may or may not be "/extras" 00:01 < topsub> hmm intresting 00:02 < perlmonkey2> how would extrasURL get changed from /data/WebGUI to /data/domain? 00:03 < perlmonkey2> I guess I could just copy all of extras to /data/domains/../extras 00:05 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has joined #webgui 00:05 -!- mode/#webgui [+v crythias] by ChanServ 00:05 -!- crythias [n=gyoung@fl-69-68-148-96.sta.embarqhsd.net] has left #webgui [] 00:08 <+perlDreamer> topsub: the folder is the parent of the PDF File. 00:09 <+perlDreamer> proceed will only redirect to any valid method in the current Asset, which in this case, is the File asset. 00:10 < topsub> ah 00:11 < topsub> hmm so iwould have to write a custom thing to have it redirect back to that certain url 00:17 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has quit ["Lost terminal"] 00:19 <+perlDreamer> topsub, the parent of the File asset does not have to be a folder. That's something to think about. 00:19 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has joined #webgui 00:19 -!- mode/#webgui [+o apeiron] by ChanServ 00:23 < CIA-21> WebGUI: graham * r6045 /WebGUI/ (4 files in 4 dirs): preparing for 7.5.10 dev 00:23 < topsub> how we have the folders organized they live inside folders.. 00:23 < topsub> unless i hacked it some to say if you look inside this folder redirect to this link 00:24 < topsub> but that might make it seem like a ghost in the system 00:24 <+perlDreamer> yeah 00:24 <+perlDreamer> after editing some PDF you want it to go to the top of the folder tree? 00:25 < topsub> basically the front end of the website were we have an admin portal 00:25 < topsub> like.. /admin/article-manager is the link 00:25 <+perlDreamer> So if you want to edit 2 PDF's you'd have to nav all the way back down? 00:26 < topsub> in the front end we have a list of the pdfs 00:26 < topsub> linking to edit each one 00:26 <+perlDreamer> hm 00:26 < topsub> so the client doesn't have to use the backend is our plan 00:26 <+perlDreamer> how about this 00:26 <+perlDreamer> make shortcuts to the PDFs as children of your article-manager page 00:26 <+perlDreamer> or vice-versa 00:27 <+perlDreamer> set the PDFs to be hidden as children of the page 00:27 <+perlDreamer> now, if you edit the PDF, you return to the parent, which is the article-manager 00:27 < topsub> might work but i have over 50 folders organized of pdfs 00:28 < topsub> so i would have to short cut each folder? 00:28 <+perlDreamer> each file in each folder 00:28 < topsub> whew 00:28 <+perlDreamer> yeah 00:28 < topsub> that would be alot of shortcuts 00:29 <+perlDreamer> it would work functionally, but practically... no 00:29 < topsub> lol ya 00:29 <+perlDreamer> might I suggest revisting the idea of not using the interface? 00:29 < topsub> might have to 00:29 < topsub> talk it up with william 00:30 < topsub> cuz we thought the procced would do it 00:30 < topsub> not realizing its just for like view, edit, manageAsset 00:30 <+perlDreamer> wait 00:30 <+perlDreamer> crud 00:30 <+perlDreamer> proceed=getDefaultAsset is close, but not quite right 00:30 <+perlDreamer> for 2 reasons 00:30 <+perlDreamer> 1) It's not a www_ method 00:31 <+perlDreamer> 2) it returns an asset, rather than viewing as asset 00:31 <+perlDreamer> if you added a www_viewDefaultAsset method, that would work 00:31 <+perlDreamer> and would be relatively clean to maintain 00:31 < topsub> so mod the core to add that ur saying? 00:31 <+perlDreamer> but you don't want to view the default asset, you want to view some other asset 00:32 <+perlDreamer> yeah, that's what I'm saying 00:32 <+perlDreamer> that's pretty much what you're down to 00:32 < topsub> ya. 00:32 < topsub> want to view the pagelayout vs the asset itself 00:32 <+perlDreamer> you could put a HTTP redirect in the File's view template 00:32 <+perlDreamer> but then it could never, ever be viewed 00:32 < topsub> from teh front end anyway 00:33 <+perlDreamer> right, only from the folder, or from the Asset Manager 00:33 <+perlDreamer> this is a file sharing setup, right/ 00:33 < topsub> cuz when the folder is like root>> home >> pdfs>> connections >> 2003 >> cn203.pdf 00:33 < topsub> connections being a category 00:33 < topsub> and year can range from 1987 to 2008 00:34 <+perlDreamer> nm, the template idea doesn't work either 00:34 <+perlDreamer> www_view is the download method for a file 00:34 < topsub> cuz when i edited a pdf it took me back to the 2003 folder 00:34 <+perlDreamer> right, back to it's parent 00:34 < topsub> yep 00:42 -!- vsd [n=rbw@83.212.57.47] has joined #webgui 00:42 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has joined #WebGUI 01:00 -!- vsd [n=rbw@83.212.57.47] has left #webgui ["Leaving"] 01:02 -!- alperyilmaz [n=alper@osbc-141.osbc.ohio-state.edu] has joined #webgui 01:03 < alperyilmaz> Hi.. Is it possible to run CGI scripts inside WebGUI? Am I allowed only using HTML when creating page content? 01:04 <@preaction> you can add modules to WebGUI, or you can use CGI scripts in a pass-through 01:04 <@preaction> but not inside of WebGUI itself 01:04 <@preaction> the HTTPProxy asset can also help with running CGI scripts 01:05 <+perlDreamer> you can also create non-HTML content, like XML or most anything else 01:06 < alperyilmaz> i have a perl-based site and i was considering migrating it to WebGUI 01:06 < alperyilmaz> but it looks like it will be difficult 01:06 <+perlDreamer> how much content is there? 01:07 <@preaction> depends on how the CGI scripts work. if you can migrate them into WebGUI Assets, it could be very easy 01:07 < alperyilmaz> not too much.. 10-15 pages with MySQL connections/queries 01:07 <+perlDreamer> well, we have a SQL Report asset that might handle those right out of the bag 01:07 <+perlDreamer> have you tried playing with a demo site yet? 01:08 <+perlDreamer> demo.plainblack.com will give you a 24 hour demo 01:08 < alperyilmaz> yes, i tried 01:08 < alperyilmaz> i saw SQL assets 01:08 <@preaction> perhaps you could re-build your application with Thingy 01:08 <+perlDreamer> those are the ones 01:08 <@rizen> so one of our clients just asked me if Thingy is like WaveMaker (http://www.wavemaker.com/) 01:09 <@preaction> or, if you're up to it, making WebGUI applications (Assets) is not difficult if you already know perl 01:09 <@rizen> I said "Um, no." 01:09 <@rizen> have you guys seen wavemaker? 01:09 <+perlDreamer> just now 01:09 <@rizen> it's unbelievably cool, but also scary hard to use 01:09 < alperyilmaz> okay.. I'll try to use the assets 01:10 < alperyilmaz> thanks.. 01:10 <+perlDreamer> you're welcome 01:10 <@rizen> there's no way that my mom will ever use wavemaker, but there is a chance she could use Thingy 01:10 <+perlDreamer> I don't know, you mom seems pretty savvy 01:28 -!- topsub [n=josh@97.66.185.250] has quit [Remote closed the connection] 01:42 -!- alperyilmaz [n=alper@osbc-141.osbc.ohio-state.edu] has left #webgui [] 01:48 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 02:06 -!- estiven [n=estiven@201.232.58.66] has quit ["Leaving."] 02:06 -!- jua1 [n=juangui@201.232.58.66] has left #webgui [] 02:48 < CIA-21> WebGUI: jt * r6046 /branch/WebGUI_Commerce/ (6 files in 5 dirs): the badge/ticket relationships through badge groups now work 02:49 -!- rizen [n=rizen@71-86-227-90.static.mdsn.wi.charter.com] has quit [] 02:51 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has quit ["Download Gaim: http://gaim.sourceforge.net/"] 02:58 -!- danny_mk [n=chatzill@68.15.55.161] has joined #webgui 02:59 < danny_mk> Hello everyone 03:01 < danny_mk> Have you ever seen these errors in the error_log? 03:01 < danny_mk> Hmmm... the pastebin link did not show up. 03:02 -!- acklenx [n=webgui_c@cpe-071-075-022-166.carolina.res.rr.com] has joined #webgui 03:03 < acklenx> is the a good place to get a quick comparison of webgui vs postnuke? 03:03 < danny_mk> http://webgui.pastebin.com/m1ea1aceb 03:03 <@preaction> acklenx, cmsmatrix.org 03:03 < danny_mk> probably cmsmatrix.org 03:03 < acklenx> (googling retunrns a lot places to get bad comparisons 03:03 <@preaction> danny_mk, those are warnings 03:04 < acklenx> will do thanks 03:04 <@preaction> as in Perl warnings, as in you have some code that turns on warnings globally 03:04 < danny_mk> I know, however the log keeps on growing like heck and the site seems a little slow 03:04 <@preaction> use warnings shouldn't be in any of the code shipped with WebGUI 03:05 < danny_mk> alright, maybe I missed something 03:05 <@preaction> grep -R "use warnings" /data/WebGUI/lib will tell you quickly 03:05 <@preaction> but also check preload.perl 03:05 < danny_mk> right 03:05 < danny_mk> will do 03:07 < danny_mk> hah! Asset_Calendar.pm,Storage.pm, and about 3 more modules have "use warnings" 03:10 <@preaction> if they're like that in SVN HEAD then i would file bugs 03:10 <@preaction> but use warnings is lexical 03:10 <@preaction> it shouldn't turn it on globally 03:11 < danny_mk> right, I found the culprit 03:11 < danny_mk> thank you for your help. 03:21 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit [Read error: 113 (No route to host)] 03:35 -!- Radix-wrk [n=Jesse@203.161.68.67] has joined #webgui 03:36 -!- mode/#webgui [+v Radix-wrk] by ChanServ 03:40 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has quit ["Leaving"] 03:49 -!- danny_mk [n=chatzill@68.15.55.161] has quit ["ChatZilla 0.9.81 [Firefox 2.0.0.12/0000000000]"] 04:05 < CIA-21> WebGUI: jt * r6047 /WebGUI/ (2 files in 2 dirs): fix: Syntax error in GetCsMail 04:07 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has quit ["bbiab"] 04:12 -!- apeiron [n=apeiron@c-71-230-67-187.hsd1.pa.comcast.net] has joined #webgui 04:12 -!- mode/#webgui [+o apeiron] by ChanServ 04:24 < metanil> hello 04:25 < metanil> my code "http://webgui.pastebin.com/d6e380d7c" is giving me null. 04:25 < metanil> i did ->>> $csv_data    = $storage->getFileContentsAsScalar($filename); 04:25 < metanil> any suggestions? 04:32 < metanil> ? 04:32 -!- acklenx [n=webgui_c@cpe-071-075-022-166.carolina.res.rr.com] has left #webgui [] 04:52 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 04:56 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 05:09 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Remote closed the connection] 05:41 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 06:09 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Remote closed the connection] 06:47 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 06:54 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has joined #webgui 07:12 < topsub> i have updated my accordion menu if anyone could test it. Added the features someone reuqested 07:12 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit ["Exit- stage left"] 08:43 -!- topsub [n=josh@cpe-071-071-252-225.carolina.res.rr.com] has quit [Remote closed the connection] 09:11 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 10:56 -!- bartjol [n=bartjol@host2.procolix.com] has joined #webgui 10:58 -!- ryuu_ro [n=rory@194.171.50.69] has quit [Remote closed the connection] 10:58 -!- ryuu_ro [n=rory@194.171.50.69] has joined #webgui 12:09 -!- Radix-wrk [n=Jesse@203.161.68.67] has quit ["Leaving"] 12:32 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 12:32 -!- mode/#webgui [+o Haarg] by ChanServ 12:52 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has joined #webgui 12:56 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 14:23 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has joined #webgui 14:35 -!- SDuensin [n=Scott@12-226-44-250.client.mchsi.com] has quit ["Leaving"] 15:35 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 15:36 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has left #webgui [] 15:36 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has joined #webgui 15:57 -!- jdanpl [n=jdanpl@xdsl-461.lubin.dialog.net.pl] has joined #webgui 16:12 -!- MrHairgrease [n=martin@wlan-145-94-223-71.wlan.tudelft.nl] has joined #webgui 16:12 -!- mode/#webgui [+v MrHairgrease] by ChanServ 16:12 -!- topsub [n=josh@97.66.185.250] has joined #webgui 16:17 -!- SDuensin [n=Scott@89.sub-75-204-45.myvzw.com] has joined #WebGUI 16:25 < SDuensin> Morning. 16:27 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has joined #webgui 16:28 -!- mode/#webgui [+o Haarg] by ChanServ 16:48 -!- vayde [n=vayde@c-24-118-227-55.hsd1.mn.comcast.net] has quit ["Exit- stage left"] 16:49 -!- Haarg [n=haarg@66-168-19-128.dhcp.mdsn.wi.charter.com] has quit ["This computer has gone to sleep"] 17:01 < topsub> hi 17:02 < perlmonkey2> hi 17:08 -!- perlmonkey2 [n=perlmonk@wsip-70-164-69-210.ok.ok.cox.net] has quit ["Leaving."] 17:08 -!- Haarg [n=haarg@71-86-227-90.static.mdsn.wi.charter.com] has joined #webgui 17:08 -!- mode/#webgui [+o Haarg] by ChanServ 17:13 < bartjol> hi 17:13 < Syn2> ha 17:15 < jdanpl> hi 17:16 < Syn2> honden... 17:16 -!- jfluhmann [n=jfluhman@x171y247.angelo.edu] has joined #webgui 17:50 -!- dapperedodo [n=dappered@194.171.50.69] has joined #webgui 18:00 -!- lisette [n=liraos@201.232.58.66] has joined #webgui 18:00 < lisette> hello 18:01 < lisette> I can tell a survey which is the score for each question? 18:03 < bartjol> lisette, there is a scale of correctness for your answers? 18:06 < lisette> mmm i don't know 18:06 < lisette> i do a new survey 18:06 < lisette> and i wants to do this 18:06 < bartjol> well, that depends on how you design your survey 18:08 < lisette> i want to do in mode quiz 18:09 < bartjol> so you can 1 answer as the correct one 18:09 < bartjol> you can assign 1 answer etc 18:12 -!- preaction [n=doug@static-72-1-4-143.ntd.net] has joined #webgui 18:12 -!- mode/#webgui [+o preaction] by ChanServ 18:16 -!- estiven [n=estiven@201.232.58.66] has joined #webgui 18:22 -!- MrHairgrease [n=martin@wlan-145-94-223-71.wlan.tudelft.nl] has left #webgui [] 18:23 -!- ryuu_ro [n=rory@194.171.50.69] has quit [Read error: 110 (Connection timed out)] 18:25 -!- AMH_bob [n=bob@alphamega-dmp.xs4all.nl] has left #webgui [] 18:33 -!- perlDreamer [n=ckuskie@nat039.mxim.com] has joined #webgui 18:33 -!- mode/#webgui [+v perlDreamer] by ChanServ 18:35 < lisette> yes, but i want control the score by answer 18:37 < bartjol> hee perlDreamer it was strange, I couldn't find those namespaces you mentioned 18:37 < bartjol> maybe arjan did before i could do it