topic Help! Can't check in an .axf! in ArcPad Questions

Help! Can't check in an .axf!

CaseyRagain — Tue, 27 Jul 2010 21:58:14 GMT

How can I extract the point data I collected in the .axf to an excel file?

Thanks!

Re: Help! Can't check in an .axf!

Anonymous User — Thu, 29 Jul 2010 17:52:34 GMT

Original User: e_hajek

Hi Casey,

The only way I know to do this is:

Open your .axf in ArcPad Studio.
Under "Feature Tables" right click on the feature class you want to extract to excel, and click Show Data.
Highlight all of it, copy, and paste into excel. It works perfectly for me in 2007, but you might have to do a "Paste Special..." and experiment with the options to get it to work.
You'll notice that the "Show Data" screen will only show you 1000 records at a time, so you have to alter the SQL statement at the top from:
SELECT * FROM [FEATURE_CLASS_NAME]; <-This will get the first 1000
to
SELECT * FROM [FEATURE_CLASS_NAME] WHERE AXF_OBJECTID BETWEEN 1000 AND 2000; <- This will get the next 1000
And click the red exclamation point on the right end of the toolbar along the top to execute the SQL command.

From there you can alter the data however you want in Excel for use in ArcMap via Joins based on ObjectID or whatever.

This was really helpful for me when I realized after the field work was over that the timestamps were needed for calibration.

Hope this helps,
Eric

Re: Help! Can't check in an .axf!

RuiGe — Thu, 29 Jul 2010 21:13:37 GMT

http://arcpadteam.blogspot.com/2010/07/export-axf-data-to-shapefile.html

Hope this helps.

Re: Help! Can't check in an .axf!

Anonymous User — Mon, 09 Aug 2010 14:05:23 GMT

Original User: KyleCollins

http://arcpadteam.blogspot.com/2010/07/export-axf-data-to-shapefile.html

Hope this helps.

That's great! For AP10 users...

Any way of getting this tool in an ArcPad 8.5 release?

We use a custom post-processing tool that looks for a dbf file. It does not reconize the AXF.

Re: Help! Can't check in an .axf!

RolfBroch — Tue, 10 Aug 2010 18:10:34 GMT

Since you obviously have ArcPad 8 and I would assume that you also are on the mandatory maintenance program, why not install ArcPad 10 as well as ArcPad 8 just to get the functionality you need?

Rolf