Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. reinhard (~reinhard@M1271P030.adsl.highway.telekom.at) joined #gnuenterprise. hello hi Arturas you ever see M? Hello Derek yes, tomorrow will see him anilp (~tell_anil@202.144.91.253) joined #gnuenterprise. Hi I am new to gnu enterprise Can any body help me Is anybody there im here getting ready to go to bed thanks derek you have a quick question? :) Arturas: tell him i said hello derek: ok :) I am new to gnu enterprise. I have so many questions. let me ask you this quick one anilp: so go ahead :) we can at least try to help you :) I have a pc with win2000 is it possible to get involved in the gnu enterprise development yes :) of course :) currently windows native usser interface is under development and naturally it's possible to use gnue under windows with other interfaces I would like to know more about the development environment and the technologies used hm, python as a main language databases... Action: Arturas anyone else know some magic words? :) I do development in java and oracle is the database I use :) suny (~zll_sy@210.83.202.175) left irc: java status i'm afraid is not very good my knowledge might be a bit outdated but java is basically stopped ok so the entire development happens only in python and oracle seems to be supported (personally i use postgresql and haven't tried oracle, so can't say about it for sure) user interface is for curses, gtk2, qt, win32 and wx some of them work not perfectly, but it's only a question of time If I want to install the gnu enterprise and use it where can I get the binaries basic www is: http://www.gnuenterprise.org http://www.gnuenterprise.org/downloads/current.php I am there :) the ones that are lowest in the page Is it just one file GNUe-Tools-0.4.3-setup-debug-on.exe I am downloading the one for which debug is off hm, there should be at least two of them - with debug-on and debug-off do you have an IDE hm, if IDE stands for Intergrated Development Environment, then no so you use a simple text editor :) I have downloaded GNUe-Tools-0.4.3-setup-debug-on.exe what to do next what's the size of a file? 9737Kb Is there any thing which I need to do before I install it then you shouldn't need any dependencies let me install it Help me to make a connection I have an "Editor for Connection string" you have some time? tell me i'll download the file for myself Sure and run the install Sure because i just can't tell what is the thing for ok a minute or so anilp: in what place do you get the question about Editor for Connection string? i have run the setup and it hasn't asked me this after you run go to menu menu => Start menu? I mean start -> GNUe Yes ok you click on gnue connections? yesw this is to define your connection to the database Is there a place where I can find the db scripts to create the necessary schemas hm, you create database yourself that is you use gnue forms to connect to your database and to Nick change: SachaS -> SacaS_away But how... Is it documented any where work with already existing there data Yes you are right Where can I get the db documentation sorry to tell so, but documentation for this probably is in db ok, how can I access it :) ra3vat__ (~ds@ics.elcom.ru) left irc: Read error: 60 (Operation timed out) mm, let me start for the other side - if you know what you need you can manually create base schema and then connect gnue to it then work with data gnue is not the tool to create db schemas (maybe some of the main leaders could be more informative at this point) for oracle there is something like sql plus (i don't remember the name exactly) in start menu that allows you to connect to the db and the you use usual sql to create tables assume if I already have the db with sample tables then I can just connect to it yes :) then you will probably need to create some form to display the data in these tables ok I have a database whose SID is say "testsid" and the host is say "testhost" and on port "1521" Then how will I make a connection at first you'll have to give some name for this connection (Connection name) then it's oracle db? ok if it's oracle - choose something about oracle in Provider feeld there are two possible options (or maybe more, if i missed some) I have choosen oracle (oracle) ok then you'll need host and port ok What to give for encoding and RPC Type and Transport encoding - you can leave empty ok and both rpc type and transport are for appserver (just say 'ok' :) you won't need it for now btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. ok how to submit this I don't see a ok button :) hm you do see menu yes and a bit lower - row of icon and a bit lower - row of icons the first one, with floopy on it is 'Save' or it should be so :) It says save the record to the db I want to connect to the db any way I pressed it nothing happened one moment it did save you can look at pure source in program files\gnue\etc\connections.conf yes it is done :) What is the next step fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: "Client exiting" you can run gnue forms client to see some sample form but basically you'll need to create a form for your db and open it - it will be able to connect to your db and work with contents I have opened the GNUe Forms editor I don't see a menu option to connect to the database one moment File-> Connect to database or something like that - i see localised version I don't have that option in File you just have save, clear form, print, exit you have launched forms client or forms designer? ok let me launch the designer :) I said connect to test the connection which I made nothing seems to happen :) try to open tools->datasource editor one min It is blank hm ok in tools menu you should see ok object navigator via it it should be possible to add new datasource with right mouse click on data sources yes I have opened it and also in tools there is schema navigator it should clearly show whether it's possible to connect to your db one min, let me try :) Can you help me creating one datasource, here it does not take any thing except for the db name i can try, but are you trying to create a datasource in desiger? Is there any place where I can find documentation. I can just go through i it Action: Arturas feels a bit lost 1 :) from designer you only show what database you connect to this database is called datasource and connection to it is defined in the form we discussed in the same beginning gnue connections 2 documentation one moment there is some in program files\gnue\doc other can be found in http://www.gnuenterprise.org/project/docs-all.html I think I need to go through this documentation. thanks for the help hi Arturas, anilp I would like to have some general informtion about this project i'v just read the log if i read correct, anilp tries the packaged win wersion it doesn't contain any drivers to Oracle hi Bajusz i didn't know that :( they are not gpl-ed, or what anilp have to go and download it where can I get it wait a min... there is DCOracle at http://www.zope.org/Members/matt/doc2 or cxOracle at http://www.computronix.com/utilities/ i typed this from gnue/common/README.databases i'v never tried this links I am not able to access this link http://www.zope.org/Members/matt/doc2 I am not able to access either http://www.computronix.com/utilities/ try http://www.zope.org/Products/DCOracle there is nothing like products I am able to access http://www.computronix.com/utilities.shtml http://www.zope.org/Products/DCOracle/DCOracle-1.3.2.tgz/view looks like it requires python 2.3 I am afraid, I need to leave now.... Can I have your email ids. A little introduction also -:) use gnue@gnu.org list (http://mail.gnu.org/mailman/listinfo/gnue) ok thanks for the help I will get in touch with you later ok anilp (~tell_anil@202.144.91.253) left #gnuenterprise. heh, i'v made the typo, the correct lnk is http://www.zope.org/Members/matt/dco2/ a bit too late :) :( don't worry - i hope he will return :) i hope so :) Arturas (~arturas@gsk.vtu.lt) left irc: "Bye :)" johannes (~johannes@M691P030.adsl.highway.telekom.at) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) left irc: "Bye :)" anilp (~tell_anil@202.144.91.253) joined #gnuenterprise. anilp (~tell_anil@202.144.91.253) left #gnuenterprise. ra3vat (~ds@ics.elcom.ru) joined #gnuenterprise. Nick change: Remosi -> Isomer Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) left irc: Remote closed the connection ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. Remosi (dahoose@port-219-88-246-23.jet.net.nz) joined #gnuenterprise. siesel (jan@xdsl-213-168-119-188.netcologne.de) joined #gnuenterprise. hi Isomer (dahoose@port-219-88-247-133.jet.net.nz) left irc: Read error: 113 (No route to host) hi siesel jamest (~jamest@leibniz.math.ksu.edu) joined #gnuenterprise. havoc (~havoc@mke-65-31-168-36.wi.rr.com) left irc: Read error: 104 (Connection reset by peer) havoc (~havoc@mke-65-31-168-36.wi.rr.com) joined #gnuenterprise. dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. hi Jason morning hey home slice I've a "short" question about passing parameters to db drivers. ok parameters which are too "variable" to put them in the connection.conf file but it don't make sense to add them into a special crafted table name like the odbc and the oracle driver do do they need to change dynamically or are they hardcoded to the specific .gfd? It would be ok to make them hardcoded in the .gfd Action: jcater is confused about what's special about these I need to pass a lot of parameters to the ldap db driver. ldap heirarachy does lookups differently especially some rules how to create new instances. Action: jamest has rusty ldap knowledge though the main difference between ldap and sql is that ldap is a tree, and sql is "just" tables. so I just take one level out of that tree. can't the levels change too can't it be like cn.ou.person or cn.person and why could that not be the format for the table name? or cn.ou.foo.person i.e. tablename="ou_People" means that I access everything below ou=People. thats what I've done. but there is still some info missing. If I have the record (uid=siesel, cn=jan) then I could store it with the FQDN uid=siesel,ou=People and cn=jan,ou=People so I could use tablename="cn_%_ou_People" to choose the later case for new records wouldn't cn be a field? yes its a field and it can be part of the FQDN FQDN = the unique identifier of an record but using that kind of tablename, schema discovery would be very difficult to implement so your if your form was accessing people entries from an ldap database then the people could exist at various levels and the form would need to find them all? yes. that sounds more like a primary key than a table name but to find them is no problem, because I'm doing a subtree search. the problem is: where should new persons go. yes the FQDN is a kind of primary key. ah so you need to specify where to insert new records a default location BTW is it possible to pass primary key information in the tag at the moment? yes great, so I can use that to pass something like "cn=%s,ou=%s" which would allow to store a record like cn=jan ou=sinologie into cn=jan,ou=sinologie,ou=People and cn=jamest ou=mathematics into cn=jamest,ou=mathematics,ou=People great. I'll try that. thx yea, what he said jbailey (~jbailey@atlas.fundserv.com) joined #gnuenterprise. jamest (~jamest@leibniz.math.ksu.edu) left irc: Remote closed the connection jamest (~jamest@leibniz.math.ksu.edu) joined #gnuenterprise. fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. Action: jbailey is away: lunch Rossz (~censored@adsl-66-127-241-68.dsl.sntc01.pacbell.net) joined #gnuenterprise. dsmith_ (~dsmith@borg.altus.cc) joined #gnuenterprise. dsmith (~dsmith@borg.altus.cc) left irc: Read error: 104 (Connection reset by peer) havoc (~havoc@mke-65-31-168-36.wi.rr.com) left irc: Read error: 104 (Connection reset by peer) Nick change: dsmith_ -> dsmith havoc (~havoc@mke-65-31-168-36.wi.rr.com) joined #gnuenterprise. dsmith (~dsmith@borg.altus.cc) left irc: Client Quit dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. dsmith (~dsmith@borg.altus.cc) left irc: Read error: 60 (Operation timed out) Action: jbailey is back (gone 00:41:12) esv (~esv@dsl-200-67-32-146.prodigy.net.mx) joined #gnuenterprise. Action: esv confused by its printer s/its/his/ anyone know to to get gnue designer to connect to mysql on another system? you have to add an entry in the connection.conf file I did I'll paste, one moment you have to add the right entry, then. =) prayer...please don't flood... [Testing] comment = Testing mysql connection host = 192.168.2.19 provider = mysql port = 3306 dbname = testdb it lists it in "connect to" but does nothing no error message of any sort can you try to change "Testing" to lower case will do, one moment the best solution is to start designer with --debug-level=12 then you get all the info ok, got it to prompt for my password interesting that it doesn't like mixed case I should have installed the debug version shouldn't it be listing my connection in "data source editor" ? dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. esv (~esv@dsl-200-67-32-146.prodigy.net.mx) left irc: "Leaving" Rossz (~censored@adsl-66-127-241-68.dsl.sntc01.pacbell.net) left #gnuenterprise. dsmith (~dsmith@borg.altus.cc) left irc: "later.." dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. reinhard_ (~reinhard@M1271P030.adsl.highway.telekom.at) joined #gnuenterprise. reinhard (~reinhard@M1271P030.adsl.highway.telekom.at) left irc: Read error: 111 (Connection refused) Nick change: reinhard_ -> reinhard guys if you have a table that has a reference to another one (and not using postgres with its cool REFERENCES keyword) how the heck do you make sure that when you enter a row that it gets properly referenced in another table? erm, assuming you enter both these entries at the same time (or hel even from your sql file with test data in it) i.e., create table Foo (BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT primaryKey, ...) create table Bar (BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT primaryKey, fooKey BIGINT UNSIGNED ZEROFILL...) erm wrong order i.e., create table Foo (primaryKey BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT primaryKey, ...) create table Bar (primaryKey BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, fooKey BIGINT UNSIGNED ZEROFILL,...) bah messed it up again ;P i.e., create table Foo (primaryKey BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, ...) create table Bar (primaryKey BIGINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, fooKey BIGINT UNSIGNED ZEROFILL,...) how do I make sure I get the primaryKey of Bar into the foo entry? jbailey (~jbailey@atlas.fundserv.com) left #gnuenterprise ("Client Exiting"). erm, I mean the primary key of foo into the bar entry gosh my sql is rusty ;) chillywilly: triggers? erm...I don't think that would be a nice way Action: chillywilly doesn't want to say what db he is using Action: dsmith thinks chillywilly is using "YourSQL" Action: chillywilly hides night all reinhard (~reinhard@M1271P030.adsl.highway.telekom.at) left irc: "War doesn't solve problems. War creates problems." make code, not war! :) ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" esv (~esv@dsl-200-67-32-146.prodigy.net.mx) joined #gnuenterprise. havoc (~havoc@mke-65-31-168-36.wi.rr.com) left irc: Read error: 54 (Connection reset by peer) havoc (~havoc@mke-65-31-168-36.wi.rr.com) joined #gnuenterprise. dsmith (~dsmith@borg.altus.cc) left irc: "later.." ToyMan (~stuq@170-215-206-157.glv.frontiernet.net) joined #gnuenterprise. jamest (~jamest@leibniz.math.ksu.edu) left irc: Remote closed the connection jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "home" esv (~esv@dsl-200-67-32-146.prodigy.net.mx) left irc: "Leaving" jamest (~jamest@adsl-64-216-111-42.dsl.tpkaks.swbell.net) joined #gnuenterprise. Nick change: SacaS_away -> SachaS siesel (jan@xdsl-213-168-119-188.netcologne.de) left irc: Read error: 104 (Connection reset by peer) siesel (jan@xdsl-213-168-108-153.netcologne.de) joined #gnuenterprise. lupo (~lupo@pD95428AE.dip.t-dialin.net) joined #gnuenterprise. good whatever lupo (~lupo@pD95428AE.dip.t-dialin.net) left irc: "using sirc version 2.211+KSIRC/1.1" jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. punk it is almost amusing to read the gnucash list Remosi: modularity and such Action: derek is away: library heh, nick completion bug bites ya right on the ass havoc_ (~havoc@mke-65-31-168-36.wi.rr.com) joined #gnuenterprise. Nick change: havoc_ -> havoc_lt dsmith (dsmith@oh-strongsvillecadent1-1c-181.clvhoh.adelphia.net) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "home" suny (~zll_sy@210.83.202.175) joined #gnuenterprise. sigh anyone know of a way to get python to render a ps file? there's no sighing in GNUe heh there is always sighing in GNUe i normally just do it in private ok, marcusU sigh that is chillywilly is getting a feel for commercial development now ;) jamest: I'll be awaiting your python ps rendering library :) sigh i'm adding image support to forms I need a way to view incoming faxes and have a user assign them to a specific job along w/ a description about the only formats I can get faxes in are that hacked up tiff thing faxes some in, ps, and pdf I can't find anything in python to deal w/ any of these formats did you ask the all knowing jcater? and I'm open to suggestions my donut budget is shot HEH you have to bribe him? ;) anyone know how to turn fricken outfill off? in emacs chillywilly: "outfill"? suny (~zll_sy@210.83.202.175) left irc: Action: derek is back (gone 01:43:28) jamest: i suspect there is a pdf somethign somewhere Action: derek notes if you use windows its there via activeX control windows? windows?!?! Action: derek wonders why reportlab didnt work havoc_lt: woops, autofill Action: jamest looks for chillywilly's trout i need to render to the screen not a printer or does it only do generation and not viewing ToyMan (~stuq@170-215-206-157.glv.frontiernet.net) left irc: "Client Exiting" Action: derek thinks this might be 'stupid' Action: chillywilly beats derek senseless with a frozen WI lake trout but for a quick hack why not just call xpdf or gv via external call? ggv! this is for incomming faxes kghostview I'm currently on the overflow line and getting 10 a day i'd hate to have a .gfd launching a new instance of gv on each down arrow ouch it'd be hard to maintain the association between which record opened what Action: derek understands now the 'down arrow' thting makes the difference :) they want to assign faxes to the proper account jamest: did you say: "show me the money" ;) I'm going to hack hylafax to insert the faxes in format (foo) into a specific location and insert an entry into the db then forms or a java app will be used to assign them to the right accoutn i'm leaning toward forms they really have some lame ass shows on TV these days java app "married by america" wtf Action: derek goes to get the shotgun to put the 'old horse down' Action: chillywilly works some sql magic jamest: it might be a little overhead but could you use one of the python pdf2html type libraries to convert it to html and then 'display' the html in an html widget? Action: jamest looks at his forms support hmmmmm i may have to go that route have you tried http://piddle.sourceforge.net/ heh, what a name chillywilly: i think its python image display, does little else Because of the not-so-positive connotations of the name "piddle", I have put together a a development version with the same functionality and interface under the the name "SPING" (Simple Platform Independent Graphics) that may be what I needed i'll look in a bit, thanks no problem hope it works ToyMan (~stuq@170-215-206-157.glv.frontiernet.net) joined #gnuenterprise. ToyMan (~stuq@170-215-206-157.glv.frontiernet.net) left irc: "Client Exiting" jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise. there is donut boy ask him glazed those are the best (was that the question?) you know of a python redering lib for ps/pdf documents i'm dealing w/ multipage faxes so png isn't really an option :) why not tiff? faxes are not real tiff they are tiff-f the tiff is a fax tiff to do the page breaks right the tif image handler in wx doesn't deal with it right does PIL support tiff-f nor does the gimp but we aren't concerned about wx we are concerned about PIL, right? i didn't see it in pil's supported types either ghostscript is only free ps/pdf rendering I'm aware of off top of my head jason@jcater:~/cvs/gnue$ apt-cache show python-imaging File Formats: o Full (Open/Load/Save): BMP, EPS (with ghostscript), GIF, IM, JPEG, MSP, PDF, PNG, PPM, TIFF, XBM. o Read only (Open/Load): ARG, CUR, DCX, FLI, FPX, GBR, GD, ICO, IMT, IPTC, MCIDAS, MPEG, PhotoCD, PCX, PIXAR, PSD, TGA, SGI, SUN, TGA, WMF, XPM. o Save only: PDF, EPS (without ghostscript). jamest (~jamest@adsl-64-216-111-42.dsl.tpkaks.swbell.net) left #gnuenterprise. jcater: good job scare him off :) Action: Vee2d2 plops down welcome back, Vee2d2 decent trip? it was fun jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) left irc: "Client Exiting" --- Tue Mar 18 2003