topic Re: Re-check in AXF in ArcPad Questions

Re-check in AXF

RobertGoodwin — Wed, 29 Sep 2010 16:43:56 GMT

I have several .AXF files that were previously checked in to a Personal Geodatabase successfully. Unfortunately, the GPS data had not yet been corrected. The edited database has been lost as well.

At this point I have a blank geodatabase that I need to check the data into again. However, when I try to do this, the AXF knows that it has already been checked in.

Is there a way to tell the AXF to forget that it has been checked in already so I can check it in again?

One othe note: I have been able to get to where it recognizes the data and am allowed to select for modifications. However, the modifications will not apply - principally, the updated/corrected geography.

Any help would be greatly appreciated.

BGOOD

Re: Re-check in AXF

IvanKautter — Wed, 20 Oct 2010 21:20:42 GMT

First, I would make a safe copy of all your axf files before you begin altering any of them in this manner just to be safe.

If you have ArcPad Studio, open up any of your axf files in ArcPad Studio. Right-click on a layer definition, and click Show Data. You will now have a SQL command interface and a pane that shows your data. You are now going to run an UPDATE query against your data that alters the value in the AXF_STATUS field. Currently, it should have a value of 16777217 for all records that were checked-in. If you want the edits in the axf file to modify existing features in your geodatabase, change the value to 2 in the AXF_STATUS field. If the data in your axf file are new data (i.e. new features), change the value of 1 in the AXF_STATUS field.

Type a SQL query with this syntax in the space provided:

UPDATE table_name SET AXF_STATUS=value; (Don't forget the semi-colon. It is required.)

where table_name is the name of the feature class in caps (e.g. REACHES) and value is either 1 or 2 depending on whether you are creating new data or updating existing data in your geodatabase.

Now hit the red exclamation point in your toolbar which is the Execute tool and it will execute the SQL command. You should then get a message that X number of records were updated. If you get an error, you have likely used the wrong syntax.

To view the changes, close the axf file and reopen in ArcStudio, and do Show Data again or you may just be able to run this SQL query:

SELECT * FROM table_name;

Be aware that if you have edited any of these features in your geodatabase that you are checking-in via the axf, your edits will be lost.

Now, check-in your axf file as usual. Repeat the process for each axf file.

This has worked for me, but I was not using data that had integrated GPS data, so it may not work for you. This is entirely at your own risk to use the solution I have suggested.

Re: Re-check in AXF

StaceMaples — Thu, 04 Nov 2010 13:09:27 GMT

Ivan, this posting saved my life. Thank you.

Re: Re-check in AXF

roemhildtg — Wed, 26 Jun 2013 19:37:45 GMT

This saved my data, I didn't even know you could run sql queries on the axf from Arc Studio.

Re: Re-check in AXF

AnthonyBedogne — Tue, 04 Nov 2014 21:18:25 GMT

saved my hide too. thank you!!

Anthony

Re: Re-check in AXF

MarkShibuta — Tue, 05 Jul 2016 06:53:47 GMT

You are a saviour Ivan!!