Data not being imported from ArcPad

[MatthewVance]

Over the past year I've been doing some field data collection.  I import all my new records weekly but this week when I go to import the report tells me zero records will be added.  I can verify that the records do exist as I am able to access them in ArcPad, yet they still won't import.  Any advice on how I can rectify this issue?

[TimHopper]

If you know the features are there (by verifying in ArcPad) but yet see 0 new feature created - odds are you started an editing session, checked in your features, stopped your editing session but did NOT save your edits.  The changes to the geodatabase were reverted, yet the axf file still thinks that it has been checked in.

The only way around this is (a) hopefully you have an original copy of the data that wasn't checked in or (b) you need to use ArcPad Studio and SQL statements to update the values in the AXF_STATUS column of the newly created features to trick those records into thinking they've never been checked in.

The following blog posts don't directly show how to update the AXF_STATUS column, but you would use the same theory to do so.

How to use SQL for working with data in ArcPad �?? Part 1

How to use ArcPad with SQL - Part 2

1. Open your axf file in ArcPad Studio.
2. Expand "Feature Layers" and right-click the problematic layer > select "Show Data".
3. Write a SQL statement in the top box to select all of your features from a certain date, date range, or any other selection method to select the rows which need to be checked in.

fyi... clicking the red exclamation mark in the top toolbar will execute your SQL statement

4. Write an UPDATE statement to update the AXF_STATUS column of the returned records from your select statement to set them to "1". 

This will make those records in the AXF file appear as if they haven't been checked in.  Then you can just go back through your normal "Get Data From ArcPad" workflow.

If you're not SQL savvy, a quick search on the interconnecting webs should lead you towards the simple statements you can use to accomplish this.  A little trial and error via the "show data" dialog and you should get what you need.

I suppose that your other option would be to open the axf file in ArcPad Studio, right-click your feature class and export to a shapefile.  You can then bring the shapefile into ArcMap and copy / paste your features into your existing feature class, or use the simple data loader via ArcCatalog.

Hope this helps.