Error importing CSV

[dankitchen]

I am using Tactic 4.7.0.b02 and am receiving the following stack trace when trying to import a csv.  Seems to be some sort of issue in the file.  I have attached a 2 line example file that fails for me


  cpi-table_oo3.zip (Size: 262 bytes / Downloads: 2)

[b]Error: expected string or bytes-like object[/b]

  File "/opt/tactic/tactic/src/pyasm/prod/service/api_xmlrpc.py", line 5401, in get_widget
    html = widget.get_buffer_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 480, in get_buffer_display
    buffer = self.get_buffer(cls)
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 471, in get_buffer
    self.explicit_display(cls)
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 438, in explicit_display
    widget = child.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 438, in explicit_display
    widget = child.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 438, in explicit_display
    widget = child.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/web/html_wdg.py", line 807, in get_display
    super(HtmlElement,self).get_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 459, in get_display
    widget.explicit_display()
  File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
    child = self.get_display()
  File "/opt/tactic/tactic/src/pyasm/widget/input_wdg.py", line 1508, in get_display
    current_values = self.get_values(for_display=True)
  File "/opt/tactic/tactic/src/pyasm/widget/input_wdg.py", line 442, in get_values
    new_value = NamingUtil.eval_template(value)
  File "/opt/tactic/tactic/src/pyasm/biz/naming.py", line 803, in eval_template
    temp_list = expression.findall(template)


thanks
-Dan

[Celton McGrath]

Hi Dan,

Thanks for submitting this bug! The bug is caused my an empty cell in the first non-title row of the csv.

The workaround is to have a dummy row as the first-non title row, or choose a row without an empty cell (ATOM_V41693242)

This bug has probably always been in the CsvImportWdg, which has been around for quite some time!

I'll try to have this fixed in the next version of 4.7.

Best,

Celton

[dankitchen]

Hey Celton, that was it :-) I'm surprised I never ran into that bug before. I just in a 0 for that field

thanks
-Dan