Text Importer: BUGs and background execution request

[Thies]

I use PL/SQL Dev Version 11.0.4.1774 on Windows 8 (64-bit) 6.2 Build 9200.
The Text Importer is quite fine but I detected some bugs:

• I have a CSV file with quoted text (like: data;"text with ; and so on";data;...") which is imported fine. But if the quoted text contains the quote character (" in this case) PSD hangs completely (no data written to DB anymore, PSD process must be killed).
  Bug fix idea: Stop parsing at line termination - or if line termination should be allowed in quoted texts - stop after a configurable number of lines and report lines with their line number which have a wrong syntax (not enough columns, not closed quoted text).
  Note: I have the option "General/End at line-end" activated.
• minor issue: "## records imported" in the status line gets updated at the beginning but stops counting after a few thousand lines. Import continues and the full number is correctly reported at the end.

Additionally, execution of the import in the background with abort-button (like SQL statements in SQL Window) would be very great. Currently, importing a large text file blocks whole PSD for the full import duration of several minutes.

 

[Marco Kalter]

We'll check it out.

I have added background execution to the list of enhancement requests.

 

[T-Gergely]

issue: "## records imported" in the status line gets updated at the beginning but stops counting after a few thousand lines. Import continues and the full number is correctly reported at the end.

I wouldn't say it's a minor issue. After a few hundred rows, it looks as if PSD were frozen for a long time. This SHOULD be fixed.