After Uploading File

[johnfletchertt]

I am using the 'Upload File' functionality of Alpha12 to send information on an excel file to a table A. Works fine. However I have a trigger on that table A that first of all enforces referential integrity by deleting any rows that were entered, once the key did not exist as a foreign key in lets say table C. Secondly in that same trigger I insert all these missing keys so to speak into another table table B. Right after the upload I want to display a modal window that shows all the keys that did not get inserted into Table A. So I would run a simple select * on table B and output those results to the modal window.

How do I do that?

[TheSmitchell]

Re: After Uploading File

Define a javascript function in the Code - Javascript Functions section to call in the Upload File's Client-Side After Upload event. From there, you can create an action javascript and use the "Open a pop-up Ajax Window/Overlay" to show your message.

[johnfletchertt]

Re: After Uploading File

Okay. So I can go to 'Client Side Events' and for the 'OnGridRenderComplete' use normal java script to open a new a5 page that will have the grid component that selects all the data from Table B. I'll put an 'Ok' button on this grid that closes it. Does that sound viable?

[TheSmitchell]

Re: After Uploading File

Only if you want to display the grid component every time OnGridRenderComplete fires.

There's already an "After Upload" event in the Upload File action you can define to make a call to a javascript function.
fileUpload1.png

You can put the Action Javascript in the function you specify in the Upload File's After Upload event.

fileUpload5.png

You can use the Open a Grid component action if that makes more sense than an .a5w page. The way you phrased the OP, it sounded like you just wanted to do a sql_records_get() or something similar and display a text listing.

You want this to happen after the upload, right? Or am I misunderstanding what you're trying to do?

[johnfletchertt]

Re: After Uploading File

Okay, I understand up to specifying the javaScript function in the Upload File's After Upload event. I have done that. But the second screenshot, are you calling the name of the grid there?? No need to put in the a5wcmp extension?

[TheSmitchell]

Re: After Uploading File

In the second screen shot, it's running a user-defined action javascript:

1. Click the "Action Javascript" button
2. Click "Add New Action" -- give it a name
3. Select your new action (it will have a red dot next to it) and click "Edit Action"

This will present you with Edit Unbound Event editor that you see when you edit, like, the click or onBlur event for a text box or button. You can add the Action Javascript to open the grid you want to view here.

Don't forget to save everything. When you're done, you can use the same "Action Javascript" button to insert the code to run the script you just created.

[johnfletchertt]

Re: After Uploading File

So after putting the 'ShowMsg' JavaScript function in the Upload File's After Upload, where did you go or what did you click to be able to input the Action Java Script to define 'ShowMsg'?

[TheSmitchell]

Re: After Uploading File

So after putting the 'ShowMsg' JavaScript function in the Upload File's After Upload, where did you go or what did you click to be able to input the Action Java Script to define 'ShowMsg'?

The Javascript Functions section:
inst.png

[johnfletchertt]

Re: After Uploading File

Brilliant. I thank you for your patience and will one day become an alphaholic like yourself.

[johnfletchertt]

Re: After Uploading File

Okay, I have a small problem. The Upload File's After Upload event is called showUnregisteredTasks. The JavaScript works when I use something basic like

function showUnregisteredTasks() {
	window.alert("sometext");
}

The JavaScript warning windows pops up fine showing 'sometext'. The name of the grid I am trying to call is advanced_task_UploadEntry2. This is a separate read only grid. And so my JavaScript Action changed to

function showUnregisteredTasks() {
	{grid.object}.runAction('advanced_task_UploadEntry2');
}

Nothing happened though. What am I missing?

[TheSmitchell]

Re: After Uploading File

Have you created an Action named "advanced_task_UploadEntry2"? Can you post an image of its definition?

[TheSmitchell]

Re: After Uploading File

I located a video that explains how to create your Action Javascript to open your grid (I don't think my words & pictures are working): http://www.ajaxvideotutorials.com/V1...iptActions.swf

[johnfletchertt]

Re: After Uploading File

The nice thing about Alpha is that sometimes there is more than one way to do something. So I achieved the end product but neither using the video nor what was suggested. I simply specified a JavaScript function called showUnregisteredTasks in the Upload File's After Upload as shown here.
1.png

Then I come out of everything and went into the JavaScript functions that did not have that button 'Action Javascript' but I defined the function I just placed in the Upload File's After Upload by simply calling an a5w page in a new window. So I saved the component to a a5w page and called it using standard javascript to define my function as shown here.
2.png

Things are working fine now. But the video was productive.