Importing From Table Within the Current File Using PSOS

[Ron Cates]

Hi All. I am trying to do a scripted import using PSOS. The import is importing from one table in my file to another. The source table is a table occurrence in the current file with an external data source from another file hosted on the same server.

It fails with an error of 100 file missing

Is this not possible with PSOS? I saw where PSOS could only import from the documents folder on the server but I wasn't sure if that also eliminated importing from one table to another in the same file. Just wanting to know if it's just not doable or if there is something else I should be looking for?

[Wim Decorte]

No it is not possible with PSoS, just like it is not possible with a server-side script schedule.  Both use the same engine.

You'll need to export to a temp file and import from there.

[Ron Cates]

Thanks Wim