Litt flaut det her glemte -t (--table). Men en ./dump.py -t netbox gir f?lgende:
#roomid:ip:orgid:catid:[ro:serial:rw:function:subcat1:subcat2..] Traceback (most recent call last): File "./dump.py", line 258, in ? main() File "./dump.py", line 255, in main handler() File "./dump.py", line 69, in netbox categories = box.getChildren(manage.Netboxcategory) File "/usr/local/lib/python2.2/site-packages/forgetSQL.py", line 895, in getChildren return forgetter.getAll(whereList, orderBy=orderBy) File "/usr/local/lib/python2.2/site-packages/forgetSQL.py", line 763, in getAll ids = cls.getAllIDs(where, orderBy=orderBy) File "/usr/local/lib/python2.2/site-packages/forgetSQL.py", line 825, in getAllIDs cls._sqlPrimary, orderBy=orderBy) File "/usr/local/lib/python2.2/site-packages/forgetSQL.py", line 562, in _prepareSQL raise """ERROR: No fields defined, cannot create SQL. ERROR: No fields defined, cannot create SQL. Maybe sqlPrimary is invalid? Fields asked: ('id',) My fields: {'category': 'netboxcategory.category', 'netbox': 'netboxcategory.netboxid'}
?vrige opsjoner virker fin; untall --all selvsagt pga. feilmeldingen over.
mvh Odd Arne
-----Original Message----- From: Stian S?iland [mailto:stain@itea.ntnu.no] Sent: Mon 16-Aug-04 09:13 To: Hauge Odd Arne Cc: nav-users@itea.ntnu.no Subject: Re: dump.py
On 2004-08-16 09:01:23, Hauge Odd Arne wrote: > Hei. > > F?r ikke dump.py til ? virke skikkelig. Har installert Optik, men n?r jeg kj?rer f.eks. python dump.py location > You must select a valid table. Valid tables are: > location > netbox > org > prefix > product > room > service > subcat > type > usage > vendor > > Jeg f?r dette resultatet uansett tabellnavn. Hva kan v?re galt ? Pr?v: ./dump --help Feilmeldingen er tydeligvis ikke spesifikk nok.. Du m? si: ./dump.py --table=location eller ./dump.py -t location Du har ogs? --all for ? dumpe alle tabellene. Jeg har patchet dump.py til ? skrive ut hjelpen ved feil: : stain@isbre ~/navme/subsystem/dbTools;./dump.py usage: dump.py [options] Dumps NAV database to importable files. options: -h, --help show this help message and exit -sSEP, --seperator=SEP use SEP to seperate fields in output, [default :] -tTABLE, --table=TABLE dump data from TABLE -oFILE, --output=FILE dump data to FILE instead of stdout -a, --all dump all tables to files named TABLE.txt ERROR: You must select a valid table. Valid tables are: location netbox org prefix product room service subcat type usage vendor : stain@isbre ~/navme/subsystem/dbTools; -- Stian S?iland Men vi andre klarer ikke ? kalle ITEA systemdrift, NTNU varmen tilbake i peisen. [Jagland] orakel@ntnu.no Tlf: 735 91500 =/=