Open Saved Import Operation in Design mode w/ XB?

[MoGrace]

I can't seem to find the way this might be done. In a saved Import operation, I want the user to be able to use the button to 'Suggest Field Mappings' since this will correct any field size differences in the text file he is preparing for import. I want all the defaults in place so this is the only task he will need to do before running it from this screen. If anyone knows what code that button may be using...perhaps I could script it.

[Stan Mathews]

Re: Open Saved Import Operation in Design mode w/ XB?

You can create a button with an action script to do that, right? Right click on the action script element and choose View Xbasic. There's your code.

operation_startup("import records","",.F.)

[MoGrace]

Re: Open Saved Import Operation in Design mode w/ XB?

Hi Stan,
Yes, it takes you there for a NEW import operation. I was hoping for a way to get into design mode for a saved operation. As a workaround, I am trying to give a timed access to the control panel and let the user do this. Once the import card is open then the control panel can be hidden again. But getting the control panel to open to the Operation tab seems unlikely however.

I could use sys_send_keys() IF I knew how to do this without a mouse! Any ideas for that? I tried using the control panel menu accelator keys - but first you have to have the correct tab active... Even limiting the display in the CP to not show any other tabs but Operations, still leaves the Tables tab available.

I was hoping to avoid the extra step of bringing up a text editor to format the file and then importing that into Excel to save as a dbf - because we don't all have the same skill levels for doing this, or the same version of Excel.

[Stan Mathews]

Re: Open Saved Import Operation in Design mode w/ XB?

ptr = Import.Load("your_import_name")
ptr.show()

Not sure about bringing the card to the front.

[MoGrace]

Re: Open Saved Import Operation in Design mode w/ XB?

Stan - how did you find that??? I waded thru 13 pages of Wiki and couldn't find it. But it works swell with ptr.show() and ptr.activate() - thank you very much!

[Stan Mathews]

Re: Open Saved Import Operation in Design mode w/ XB?

how did you find that???

Use the interactive and start typing.

a5_op

You'll see some things likely not in the documentation. Likewise

import.

the autocomplete will show you the methods available for the import object.

[MoGrace]

Re: Open Saved Import Operation in Design mode w/ XB?

Well I have my script now and have let the user set the timer for how long the Import Card stays open before it is closed automatically. I could not suppress the 'view result' at the end but was able to close that default browse if the user clicks that button and continue the script. I made a 'Step Menu' that takes the user thru the steps in order but leaves the options open to repeat a step or start over. The sub menus will take the user back to the opening list and set the default choice for the next option.

If anyone is interested...