Import Wizard

Question

Question

Andre Wessels · Oct 27, 2020

#Business Operation #Data Import and Export #Management Portal #Tools #InterSystems IRIS

I find the Data Import Wizard very handy. Has anyone thought of enabling the form in the application where it can be adapted for application user requirement?

csp/sys/exp/UtilSqlExImWizardContent.csp?Wizard=Import&$NAMESPACE=

Discussion (4)1

Log in or sign up to continue

Benjamin De Boe · Oct 28, 2020

Are you asking about the web interface or the underlying API?

We are currently working on a new all-SQL loader that would be easy to use from any application or prompt (or to build a GUI on :-) )

0 0

score 0 · Answer 1 · 2020-10-29T13:19:55-04:00

Henrique Dias · Oct 29, 2020

Great news!

0 0

score 0 · Answer 2 · 2020-11-05T07:03:41-05:00

Hi Benjamin,

Yes the Wizard as found under the SQL in Management Portal is very powerful - It is possible to replicate the csp page, but the methods that are used to do the processing and provide the options are not known. Is it possible to expose that detail ?

Looking forward to the SQL loader - is there any indication of release date? We would look forward to testing BETA version in IRIS

Kind regards
Andre

score 0 · Answer 3 · 2020-11-05T07:37:11-05:00

Hi Benjamin,

There is more to it.

The purpose is to give 'power users' the ability to import data into 'holding classes' and then be able to process the data as required.

We have developed functionality for users to import regular imports, but sometimes the user just wants to analyse random data, which does not warrant defining the data structure. Also these users can not be granted access to SQL for security reasons. So we need to control what they are able to do.

Not being close enough to the action, I suspect there might be alternative ways of enabling this, of which I am unaware of.

Kind regards
Andre