Error updating User Story and Linking to Requirement

[Bryan McKay]

Hi folks...

Awesome product! I'm working on a new install of Agilo for a project
we are implementing. For all intents and purposes we are about to go
live. I am setting up our data (Requirements, Stories, Tasks etc.) by
importing CSV files and trying to set the links. I ran a test
importing a User Story with the i_links field in the CSV set to the
ticket number of a Requirement. Below is the test from the file...

id summary reporter owner description type status resolution keywords
rd_points sprint story_priority o_links
16 test story bryan bryan test2 story new test 100 Mandatory 3

Note - ticket #3 does exist and was created by importing a CSV file.


The error message and system settings are below...

Trac detected an internal error:

OperationalError: no such column: o_links

Python Traceback
Most recent call last:

File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 435, in
_dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 205, in
dispatch
resp = chosen_handler.process_request(req)
File "build/bdist.linux-i686/egg/agilo/csv_import/web_ui.py", line
235, in process_requestFile "build/bdist.linux-i686/egg/agilo/
csv_import/web_ui.py", line 267, in process_fileFile "build/
bdist.linux-i686/egg/agilo/csv_import/web_ui.py", line 292, in
process_all_rowsFile "build/bdist.linux-i686/egg/agilo/csv_import/
update_performer.py", line 78, in commitFile "build/bdist.linux-i686/
egg/agilo/ticket/model.py", line 645, in save_changesFile "/usr/lib/
python2.5/site-packages/trac/ticket/model.py", line 273, in
save_changes
(self[name], self.id))
File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in
execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py",
line 58, in execute
args or [])
File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py",
line 50, in _rollback_on_error
return function(self, *args, **kwargs)

System Information:

User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.10) Gecko/
2009042700 SUSE/3.0.10-1.1.1 Firefox/3.0.10
Trac: 0.11.4
Python: 2.5.2 (r252:60911, Jun 6 2008, 23:32:27) [GCC 4.3.1 20080507
(prerelease) [gcc-4_3-branch revision 135036]]
setuptools: 0.6c9
SQLite: 3.5.7
pysqlite: 2.3.2
Genshi: 0.5.1
Agilo: 0.7.3.3-r1417-20090313
Subversion: 1.5.0 (dev build)
jQuery: 1.2.6


Is importing and linking using CSV working in 0.7.3.3 r1417?

Thanks

Bryan

[Felix Schwarz]

Bryan McKay schrieb:

> Is importing and linking using CSV working in 0.7.3.3 r1417?

Unfortunately we did not have the time to rework the import so far.
Adding it should not be too hard if you modify the csv import module
which is quite separate from the rest of Agilo. Patches (+ tests welcome)

fs

[Bryan McKay]

Hi Felix...

Ok... Where do I find the module? Just need to know the path and file
name... I'll make the changes in the module, test and post the updated
module for everyone's benefit... I've seen a few other postings so
I'll ensure both i_links and o_links work... Thanks!!

Bryan

[Felix Schwarz]

Bryan McKay schrieb:

> Ok... Where do I find the module? Just need to know the path and file
> name... I'll make the changes in the module, test and post the updated
> module for everyone's benefit...

Have a look at agilo/csv_import

fs