|
POST
|
There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago. You might look at that, and then see if you can figure out a way to automate importing that into access. Certainly you could import it manually... Good Luck! Joe- Thanks mentioning that tool. I was able to develop a workflow as follows. Import policies to my DB and have a query run that selects only the new policies. I have a model that uses that query to geocode and return an ASCII file to a specific location. I then import the ASCII file into DB and a query appends the new records to my previously geocoded policies. There are a few manual steps but better than geocoding hundreds of thousands of records monthly. I may be able to even update this weekly.. Thanks again!!
... View more
04-07-2011
04:48 AM
|
0
|
0
|
1743
|
|
POST
|
Donna - Good news. It did actually work. I had the old add-in stuck in cache and my updated code didn't go through. Thanks for your help.. searchCriteria.WhereClause = "File_Numbe LIKE'%" & SrchTxt & "%'" Try Dim rows As RowCollection = layer.Table.Search(searchCriteria)
... View more
04-06-2011
08:46 AM
|
0
|
0
|
1544
|
|
POST
|
Donna- That did not work for me. It allows me to search for an exact match put does not work for a partila match. ie- I can search for 1234 and find the file but if i try 12 it does not find 1234. Thanks. Brian
... View more
04-06-2011
05:01 AM
|
0
|
0
|
1544
|
|
POST
|
Thanks Joe. I probably could have worder that better. I will keep digging to see what i can come up with.
... View more
04-04-2011
12:04 PM
|
0
|
0
|
1743
|
|
POST
|
Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb?
... View more
04-04-2011
11:35 AM
|
0
|
0
|
1743
|
|
POST
|
Probably not your issue but i figured I would share. I had a computer where the My Documents was pointed to a location I did not have permissions to. The application will crash in this isntance as it is trying to create and ArcGIS Explorer folder somewhere where it can't.
... View more
04-04-2011
09:48 AM
|
0
|
0
|
401
|
|
POST
|
I encountered same problem. Because, I have already added add-in to ArcGIS Explorer. Error message said that the assenbly '***' has already loaded from a different location. When I delete the add-in that is already added, I can load add-in. Your computer already has add-in? Please look at the following on your computer. C:\Documents and Settings\<User Name>\Application Data\ESRI\arcgis explorer\AddIns ArcExplorer can only load your add-ins once. If you manually add the add-in to your application and then try to load it from a config you will get the error. If you will be using the app config with the add-ins already added just remove them from your ArcExplorer Resouces - Manage Add-ins.
... View more
04-04-2011
09:46 AM
|
0
|
0
|
1200
|
|
POST
|
You need to place your add-in on a tab to reference it. Here is how I usually do it. Go in and modify your config. Click customizations in the left column (right above add-ins). Click "Tabs" and click "Add New" from the menu on the right. Name it whatever you want. Click that new tab and the click "New Group" Name that whatever you want. Click that new group and select "Add Custom Control" from the right hand column. Click "Choose File" to select your add in. You should then be able to see your tools under the tab you created. There are also options available to set when and where you see the tab but you canplay around with that later. Let me know if you have any questions.
... View more
04-04-2011
09:43 AM
|
0
|
0
|
1200
|
|
POST
|
So i have roughly 500K policies that I geocode monthly from an access database. The access database is populated from a Microstrategy report as I do not have direct access to the policy server. Most of the policies have previously been geocoded. The geocoded results are currently saved in a file geodatabase. I would like to create a workflow where I would only have to geocode new policies and not all policies every month. Any ideas? Can ArcCatalog geocode back to an access database? PS. I only have an ArcView license. Thanks in advance.
... View more
04-04-2011
05:38 AM
|
0
|
7
|
1876
|
|
POST
|
Donna- Actually this thread started yesterday. I think you were looking at my "joined date". Anyhow, I have still not found a solution and am still investigating.
... View more
03-31-2011
07:39 AM
|
0
|
0
|
1544
|
|
POST
|
I am having an issue searching using VB.NET. I am using the following to search a file number but it needs to be entered exactly as in the table. Dim SrchStr As String = "File_Numbe = " & SrchTxt I want to be able to enter a patial number and give me the matching results. I have tried the following with no success. Any ideas? Dim SrchStr As String = "File_Numbe LIKE % " & SrchTxt & "%" Dim SrchStr As String = "File_Numbe LIKE '% " & SrchTxt & "%'"
... View more
03-30-2011
08:05 AM
|
0
|
12
|
2522
|
|
POST
|
If you are familiar with the .NET SDK, I use the following code in an add-in to export items from a data grid view. I implemented this in the Query Features sample provided with the SDK. Private Sub buttonExport_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles buttonExport.Click Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet Dim misValue As Object = System.Reflection.Missing.Value xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass xlWorkBook = xlApp.Workbooks.Add(misValue) xlWorkSheet = CType(xlWorkBook.Sheets("Sheet1"), Worksheet) For Each col As DataGridViewColumn In dataGridView1.Columns xlWorkSheet.Cells(1, col.Index + 1) = col.HeaderText For Each rowa As DataGridViewRow In dataGridView1.Rows xlWorkSheet.Cells(rowa.Index + 2, col.Index + 1) = rowa.Cells(col.Index).Value Next Next xlApp.Visible = True End Sub
... View more
03-30-2011
08:01 AM
|
0
|
0
|
882
|
|
POST
|
I modified the query features add-in sample that came with the SDK. I essentially added an export button which will export the points that were selected to an excel spreadsheet. This will only work with a point layer from a shapefile or geodatabase. Hopefully that is what you are looking for.
... View more
03-29-2011
09:01 AM
|
0
|
0
|
882
|
|
POST
|
I am looking to build off of the Query Features sample. Instead of drawing a polygon so select, I am looking to use the polygons inside a shape file. The issue I am having is I am not sure how to identify the contents of a shape file as a point, line, or polygon. I can identify the layer type with the following but not the shape types. For Each item As MapItem In fold.ChildItems If TypeOf item Is Layers Then Any help is appreciated.
... View more
03-23-2011
12:05 PM
|
0
|
2
|
1131
|
| Title | Kudos | Posted |
|---|---|---|
| 4 | 03-12-2025 11:01 AM | |
| 3 | 01-08-2025 09:26 AM | |
| 1 | 01-08-2025 07:19 AM | |
| 1 | 12-06-2024 04:52 AM | |
| 2 | 03-19-2024 04:36 AM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|