Image Upload/PhoneGap

[Rogers]

I am trying to do an image upload to a mysql table using phonegap

My Ux component image upload settings are:
PhoneGap build project settings.PNG

My Ux Component image upload settings:
Image upload setting.PNG

The alpha anywhere version 12.4.3.1, Build 3962

The phonegap version is 6.3.0

On an android phone running version 4.2.2, It brings up the camera but after I take a photo , the camera action is cancelled with message "error capturing image"
On an android running phone version 6.2.2 I am able to take the pic but after about 2 seconds an alert is shown "Image Upload failed"

Any Suggestions?

[Davidk]

Re: Image Upload/PhoneGap

Is your File Transfer plugin set specifically to version 1.5.1? Check the current set of release notes for more info on this.

[Rogers]

Re: Image Upload/PhoneGap

yes it is in xml file but still no success. I did see that in the release file and checked to make sure it was set.

[Davidk]

Re: Image Upload/PhoneGap

Your UX component security (if security is on) is set to always allowed
Your UX is published
Your URL for Ajax Callbacks is set correctly

I just rebuilt a UX I had for testing Image Upload and used the same settings you're showing and it works. Update images and add new images.

Can you post your UX? Or a sample UX?

[Rogers]

Re: Image Upload/PhoneGap

I back checked and the following are checked:

Your UX component security (if security is on) is set to always allowed
Your UX is published
Your URL for Ajax Callbacks is set correctly

Attached is a copy of my project.

[Davidk]

Re: Image Upload/PhoneGap

Is your Alpha Server at the same Build... 3962? It looks like this is a server issue. The error occurs after the server call is made to the component to save the image.

[Rogers]

Re: Image Upload/PhoneGap

It was but I already downgraded to 3922 but still no success.

[Davidk]

Re: Image Upload/PhoneGap

But both your Dev Env. and Server are the same build... right?

It looks to me like several issues going on. First, you used PumpJackPro as a template... that's a huge issue although it's probably not the cause of your image upload problem. But is it something for a later discussion.

Your Server-side onDialogInitialize event is broken because it is mis-named. You have...

ExecuteServerSideAction("Get Primary Keys for Parent Table::Load_Primary_keys_for_Parent_Table") but no such action exists.

The action name is...

Load_Primary_keys_for_Parent_Tab

So the action call should be...

ExecuteServerSideAction("Get Primary Keys for Parent Table::Load_Primary_keys_for_Parent_Tab").

Next, although not horrible... your Data Binding SQL connection string is actually the connection string. Change it to use your named connection string. Using it the way you have it is like hard coding your connection. It's like a hold you pre-dig to fall into later.

Next, I'm not sure that you're actually Data Bound to your Controls. Check the "Bind UX Component Controls to Table Fields" in Data Binding. When I checked nothing was bound. That may have been because I changed the connection string to use a named connection... but check yours.

Doing all this, with your table in my local SQL Server... a rebuild of the app works... no issues with image upload.

You're also using Container on-click events... I don't understand why you'd do that.

[Rogers]

Re: Image Upload/PhoneGap

Both server and development are running the same build 3922

When I put ExecuteServerSideAction("Get Primary Keys for Parent Table::Load_Primary_keys_for_Parent_Tab") on the dialogload component I get "no no such action exists"

I have made the other changes as you have suggested but still not able to save the image

See attached project with changes

[Davidk]

Re: Image Upload/PhoneGap

I'm assuming you changed the table id from SITET_id to SITETRACKING_ID. The original table you sent had SITET_id.

Another change you should make is in the Alpha PhoneGap Build Builder. Your current Application Id is a5w.http://www.ssbeservices.net/8080.login and it should be something like net.ssbeservices.sitetracker.

Attached is a new component. Go back to basics and see if this component works. Once you have this component in your project remember to set it's security to Always Allowed and publish it. Then open your Alpha PhoneGap Build Builder and change the UX Component.

Once built and installed, make sure you can navigate the records. If so, then try an Image Upload.

I think, overall, this is an issue with your server. Also attached is your pumpjackprossb component. There are a few other changes you need to make.

In your Javascript Functions you're testing the platform using this...

document.addEventListener('deviceready', function() etc.

But you don't need, or want, to do this. Delete this code and in the Client-side event onPhoneGapReady put this code...

var platform = device.platform;
switch (platform){
	case "Android":
		break;
	case "iOS":
		StatusBar.hide()
		break;
}

And... because you're using "device" you need that plugin... so in the Alpha PhoneGap Build Builder, turn on the Device plugin.

The changes I made to your setup were:

The "addEventListener" stuff
Turning on the Device plugin
Pointing the Ajax Callback URL to my server
Changing the Application Id

I think it's your server setup that's causing the issue.

[Rogers]

Re: Image Upload/PhoneGap

I am not sure what's happening. I followed all of your instructions.
I also loaded the two components you sent me but i still get the error message image upload failed.
I am lost. I am using the same build on the server and development. Is there a particular build that it definitely works on or is
there any specific server configuration that needs to be done?

I really wanted this to work, I have been at it for sometime.

[Davidk]

Re: Image Upload/PhoneGap

Can you navigate through the records in the test component?

[Rogers]

Re: Image Upload/PhoneGap

yes, I am able to navigate through the test records and the images are shown.

[Davidk]

Re: Image Upload/PhoneGap

That you can navigate through you records is a good sign. Communications to your server and data are open. I can't think of why the image update is failing.

[Rogers]

Re: Image Upload/PhoneGap

I am not sure what is happening either. I can save data to the table and if I run the application in a web browser it works fine. The images get uploaded.