POST
|
10-13-2015
12:17 PM
|
0
|
3
|
395
|
POST
|
Hi When I right click on a field in the Field Mapping zone, I notice that there is a difference and perhaps it is the source of my problem. please take a look to the following:
... View more
10-13-2015
12:01 PM
|
0
|
5
|
893
|
POST
|
I want just do what is possible in Merge tool. In the FieldMapping Zone, We can rename fields, change their format length, type. And after those changes are preserved in the interface before running the tool. Any Help please Thanks
... View more
10-13-2015
09:47 AM
|
0
|
6
|
893
|
POST
|
Whatever change I made with Output Field Properties (right click) on whatever non reserved field, It does not work. All my changes disappear Thanks
... View more
10-13-2015
09:23 AM
|
0
|
7
|
893
|
POST
|
Hi Thanks. I was looking in the FieldMapping help. My problem is how from my manual changes in FieldMapping Zone, I can keep the changes. i mean, after right clicking on a field, make changes and see that those changes are kept (as what we can do with merge tool) Here what I did in validation : def updateParameters(self): if self.params[1].altered: self.params[3].value = None tfms = arcpy.FieldMappings() tfms.addTable(self.params[1].value) self.params[3].value = tfms.exportToString() return Thanks
... View more
10-13-2015
08:28 AM
|
0
|
11
|
893
|
POST
|
Hi all I create an arctoolbox using field mapping in the code. I was able to add my table to the field mapping object. I remember that in the merge tool, I can change the field names, formatting, etc. from the field mapping zone. I believe that there is code behind that. I tried but unfortunately I was not able. When I change for example my field name and click in other place, my changes are not kept and i got only my original field names. I know that perhaps I have to use the FiledMap object. My problem is that I don't know how to link the manual changes I make in field mappings zone and a code that can take those changes and show them in the field mapping zone. In reality, I don't know how to program this link? Any help Thanks Message was edited by: Dan Patterson I shortened your title...there is no need to repeat the title multiple times to try and draw attention to it. I also added some tags so it won't languish in the questions section.
... View more
10-13-2015
08:02 AM
|
0
|
14
|
3134
|
POST
|
Hi I tried this example: sql = "SELECT * FROM sys.tables" sde_return = sde_conn.execute(sql) after I retreive the first value of sde_return[ 0] = [u'SDE_GEOMETRY3320', 223997, None, 45, 0, u'U ', u'USER_TABLE', u'20/03/2014 10:32:12 AM', u'27/09/2015 8:55:24 AM', 0, 0, 0, 1, None, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, u'TABLE', 0] Do you know please how can i get the signification of each value (field names of sys.tables) Thanks
... View more
10-01-2015
10:22 AM
|
0
|
0
|
293
|
POST
|
Hi Christian I tried your code before and it worked well. Not I got kind of error. Here is what I did: gdb = r'Database Connections\GKMI.sde' owner = 'sde' I let it as sde table='GKMIGeodatabase.ATLR.CH_ATL_PipingPlover" hre is the name of my table or feature class I run the script. Unfortunatly, the dates was just boolean and = True I don't know what I did wrong? Could you please give me more explanation on the owner and table variable significations? Thankd
... View more
10-01-2015
07:12 AM
|
0
|
0
|
293
|
POST
|
Hi I try this but the same Error. The problem is in the duplication Excel table name in the input table as showen in the ERROR message. I don't know why this error happen Thanks
... View more
09-25-2015
08:15 AM
|
0
|
1
|
980
|
POST
|
Hi all, Sorry I use the image link because I have trouble to copy/paste in this website. So here is the code and th message erro. You can see that the priblem is in the input table. Thanks for your help
... View more
09-25-2015
06:24 AM
|
0
|
5
|
979
|
POST
|
Hi Thanks I used this TableToTable as you mention (the same way). but I still having the same error. As I mention before, the problem is the duplication of the Excel file name (...xlsx) in the valeur variable (please see my first message) Thanks
... View more
09-23-2015
07:38 AM
|
0
|
0
|
979
|
POST
|
Hi all I realize just right now that in the message error, the name of the file contain 2 times the Excel file name which is i believe the source of the error. I Tried all combinaison, but the error happen all the time Any Idea Thanks
... View more
09-22-2015
09:00 AM
|
0
|
4
|
979
|
Title | Kudos | Posted |
---|---|---|
1 | 07-03-2015 05:20 AM | |
1 | 07-14-2015 05:30 AM | |
1 | 12-02-2015 05:41 AM |
Online Status |
Offline
|
Date Last Visited |
12-01-2020
08:56 AM
|