topic Re: ArcPad 7 Check In Redo in ArcPad Questions

ArcPad 7 Check In Redo

JohnSanborn — Tue, 17 May 2011 15:55:26 GMT

Using ArcPad 7.1.1 I checked in two layers to an ArcGIS 9.3.2 ArcMap, in an editing session, but failed to save the edits. When I try to do the check in again I get the message that there is nothing to check in from the axf file. Is there a way to clear something that will allow me to do the check in again?

Re: ArcPad 7 Check In Redo

DeniseKing — Wed, 18 May 2011 13:09:30 GMT

Hi John,

You may be able to perform a 'fake checkout' which will then allow you to, as you said, redo your checkin. You can follow the instructions in Knowledge Base article, HowTo: Perform a 'Fake' ArcPad Checkout, http://support.esri.com/en/knowledgebase/techarticles/detail/35524.

Cheers,
Denise

Re: ArcPad 7 Check In Redo

JohnSanborn — Wed, 18 May 2011 16:21:37 GMT

Thanks for the help, but after several tries using the fake check out, I still get the message that there are no edits to check in. The data is there on the ArcPad map. I can see it, I just can't get it. Too bad there's not a way to open an ArcPad map in ArcMap.

Re: ArcPad 7 Check In Redo

DeniseKing — Wed, 18 May 2011 18:15:15 GMT

John,

Do you have ArcPad Studio? If you do, open the AXF in ArcPad Studio and right-click on individual layer then select Export option to export the selected layers to shapefile format. You can then manually copy the edits to original geodatabase in an active ArcMap edit session.

Cheers,
Denise

Re: ArcPad 7 Check In Redo

GrahamW — Thu, 19 May 2011 00:25:40 GMT

jsanborn20's method is great! before this could be done... I had this happen a few times and found a way to save the data meaning I didn't have to drive out and recapture the data.

What happened was:
1. Checking AXF and SSF hung after 90 mins so I hit cancel.
2. Once successfully cancelled I restarted ArcMap and tried again
3. this time ArcMap wouldn't allow check in as it indicated 0 new features�?�(oh #$$%% I've deleted the data off the logger already.)
4. Insert 99 extra step of messing around with access and the ArcGIS MDB and other files.
5. Eventually I downloaded SQL Server Management Studio Express(limited free use) to edit the contents of the axf file
http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en
6. Connect to the AXF as such..

6. after playing around with an AXF for a while I found that AXF_STATUS field was what I was after.
Using:
select * from GPSSMAINTENANCEHOLE

7. I set this the AXF_STATUS field to 1 by using the query bellow:
(NB you will see some checked out data as well is null so the query has the option of " Where AXF_Status=16777217")

UPDATE GPSSMAINTENANCEHOLE SET AXF_STATUS=1 Where AXF_Status=16777217

Hoorah!!

Now you can check the file in again!

Re: ArcPad 7 Check In Redo

RobertFowler — Thu, 19 May 2011 12:59:04 GMT

I, of course, experienced this problem when I first started using AXF files. Luckily for me, I hadn't yet deleted the project from my handheld device and therefore had a backup of the unmolested AXF file. Although this may be stating the obvious, be sure and create a back up copy before attempting to import.

Regards,
Bob

Re: ArcPad 7 Check In Redo

JohnSanborn — Thu, 19 May 2011 15:28:57 GMT

I'm glad I managed to elicit some good information on a problem that I would imagine is fairly common. And a nasty one. And its great to learn that an axf file can be opened in Sql Server Management Studio.

Anyway, I did have access to ArcPad 10 and was able to follow Denise62's instructions. The ArcPad Studio quickly converted the axf file to shape files and I was able to then import them to the geodatabase and add them to the ArcMap. Thanks for all the help. Saved my life.

Re: ArcPad 7 Check In Redo

ColterSikora1 — Wed, 06 Jul 2011 13:20:23 GMT

jsanborn20's method is great! before this could be done... I had this happen a few times and found a way to save the data meaning I didn't have to drive out and recapture the data.

What happened was:
1. Checking AXF and SSF hung after 90 mins so I hit cancel.
2. Once successfully cancelled I restarted ArcMap and tried again
3. this time ArcMap wouldn't allow check in as it indicated 0 new features�?�(oh #$$%% I've deleted the data off the logger already.)
4. Insert 99 extra step of messing around with access and the ArcGIS MDB and other files.
5. Eventually I downloaded SQL Server Management Studio Express(limited free use) to edit the contents of the axf file
http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en
6. Connect to the AXF as such..

6. after playing around with an AXF for a while I found that AXF_STATUS field was what I was after.
Using:
select * from GPSSMAINTENANCEHOLE

7. I set this the AXF_STATUS field to 1 by using the query bellow:
(NB you will see some checked out data as well is null so the query has the option of " Where AXF_Status=16777217")

UPDATE GPSSMAINTENANCEHOLE SET AXF_STATUS=1 Where AXF_Status=16777217

Hoorah!!

Now you can check the file in again!

Refering to this method...I can't seem to find the AXF_STATUS field through Management Studio, though it will display when I open the HTM file in my browser. Any tips on finding/editing the AXF_STATUS field? Thanks!

Re: ArcPad 7 Check In Redo

TimHopper — Wed, 06 Jul 2011 23:27:52 GMT

1. Open the axf in ArcPad Studio.
2. In the tree under "Feature Layers" right-click on the feature class.
3. Select "Show Data"

You will be able to see the AXF_STATUS field on the right-hand side of the list of fields.

4. To modify the current value, remove the SQL statement that's in the top box already and replace it with the following:

UPDATE TABLENAME
SET AXF_STATUS='1'
WHERE AXF_OBJECTID >= 2

The "TABLENAME" is the name of your feature class, but in all upper-case letters.

The WHERE clause can be utilized to only change a portion of your data. If you wanted to change the value for every row in the feature class, just utilize the first two lines.

3. After you have the modified SQL statement, click the red exclamation mark button on the main toolbar to run the statement.

The following messages should be returned if you have written a valid SQL statement:

Command completed with # rows affected.
Command completed successfully.

After this you should be able to close the command window, right-click the feature class again, and select "Show data". You will now see that the value has changed for the records you specified. You can then check this data back into ArcMap.

Hope this helps.