IMPORT.ASCII (OpenInsight 64-bit)
At 25 MAR 2021 09:22:40AM Jason Leach wrote:
We have a few older processes that use import.ascii to import data. Before OI10 these imports were setup in database manager. Where can we set these up in OI 10?
At 26 MAR 2021 08:44AM bob carten wrote:
Hi Jason,
I don't see the ASCII import on the menu. We will add it to the next release. In the meantime you can EXEC RTI_IMPORT_ASCII, that should let you define / run an import.
At 26 MAR 2021 11:29AM Jason Leach wrote:
Thanks Bob.
Is the call on the code side the same?
CALL IMPORT.ASCII("IMPORT.ASCII.PO_INVENTORY") works in OI9 but hangs in OI10.
At 26 MAR 2021 12:57PM bob carten wrote:
Yes. The calling syntax is unchanged.
At 26 MAR 2021 02:43PM Donald Bakke wrote:
I seem to recall this being one of the tools Mike posted a survey question about whether people were still using it. I don't recall anybody saying they did, so I think it's absence was expected.
At 30 MAR 2021 09:59AM Jason Leach wrote:
When calling CALL IMPORT.ASCII("IMPORT.ASCII.PO_INVENTORY") we get the message "# rows imported".
Clicking ok on that message throws the fatal runtime error below.
SYS1000: Error loading program "IMPORT.ASCII_SUB".
Any thoughts?
At 31 MAR 2021 08:25AM D Harmacek wrote:
In oi 9 there is RTI_ParseCSV function. If in OI 10 would this help you?
Dave Harmacek - Harmacek Database Systems - near Boston, MA USA
At 31 MAR 2021 09:12AM Donald Bakke wrote:
In oi 9 there is RTI_ParseCSV function. If in OI 10 would this help you?
Dave Harmacek - Harmacek Database Systems - near Boston, MA USA
Yes, it is in OI 10 as well.