0

can I launch import wizard (for .csv) via script?

I can't find any reference to this anywhere including Ninox docs. I want to create a button on my dashboard ("home" page) that takes me to a specific table (StagingImport) and launches the import wizard with the wizard's Import Table preset to StagingImport. Is this even possible?

5 replies

null
    • Dave_Airel
    • 2 days ago
    • Reported - view

    To clarify, I guess what I should be asking is how to create a scripted button at the table level, not the form/field level. A button that would be vislble regardless of which view I'm using on a given table?

      • Fred
      • 2 days ago
      • Reported - view

       There is no "Table level". A table has records that can be displayed in many views (table, form, etc).

      One way to do what you want is to create a Page where you will create a UI for users. This way your users never interact with raw data directly.

      Another way is to create a table above StagingImport that only has 1 record. You can name this new table StagingImport then rename the old StagingImport as Data. Then make the Data table a child of StagingImport. Now you can create a form view at StagingImport, then get rid of the table view, and when a user opens StagingImport they will only see the form view.

      • Dave_Airel
      • 2 days ago
      • Reported - view

       Thanks. I decided to keep it simple and leave the action in a blank record on StagingImport. It's pretty simple and I've written up more detailed instructions to supplement this. Thanks for all your help.

    • szormpas
    • 2 days ago
    • Reported - view

        Hi,

    You can't launch the Ninox import wizard via scripting, but you can make your own custom import wizard to automate the whole process.

    I just had a feeling that you wanted to get there 😎. That's why I sent you to this post in our previous thread

      • Dave_Airel
      • 2 days ago
      • Reported - view

       Hah. You really did see that coming, even before I did. As I mentioned early on, I really struggle with all but the most basic scripts, so this is more than I want to tackle. Since I already have the script working to process the import in a button sitting in the form for the StagingImport table, if I can move that button to the table level (so the user can see it without opening the blank form), then I'll create another button on the other tables with openTable("StagingImport") & call that good enough. Can you point me at how to create a scripted button at the table level? I can't find any documentation on that.

      (I have another open post on that from earlier this morning just FYI)

Content aside

  • 2 days agoLast active
  • 5Replies
  • 33Views
  • 3 Following