nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy.TableToGeodatabase_conversion losing text values

AndrewL

I am using the arcpy.TableToGeodatabase_conversion to convert a comma-separated .txt file that I download daily to a table in a geodatabase.

arcpy.TableToGeodatabase_conversion("2013daily.txt", "C:/Users/smith/Desktop/test/all_observations.gdb")

One of the fields in the .txt file contains numbers and text. The above code works in my python script if I am just using the python shell on my PC. It works in that in creates a field in the geodatabase that is text. Therefore it keeps all the values.

However, if I run my python script on the ArcGIS Server VM, it just converts the text values into null. It creates an integer field, and all the text values are lost. I am not sure why this happens on the VM. I am using the same set of data. Thank you.

Find more posts tagged with

Accepted answers

All comments

mvolz47

I ran the script on a desktop v10.0 machine and got the same results of blank values, 0 values, and other miscellaneous values from 0.1 to 14.5. There must be some configuration setting on your desktop that is different from all the other machines, at least that's what I'm thinking.

AndrewL

Yes that is correct. That is what is happening on my VM. I am running the scipt on my PC using v10.1, and it does not produce blank values.

mvolz47

I have just run your script on a desktop machine with v10.2. The fields SnowFall and PrecipTotal are being created as Data Type Double and there are blank values, 0 values, and other miscellaneous values from 0.1 to 14.5. Do those values sound correct from the data you let me test with?

AndrewL

The SnowFall and PrecipTotal fields.

Those fields contain text values 'M' and ' T', but they are lost once I do the tabletogeodb conversion. If I run the script on my VM and look at the geodatabase table, those are now number fields and the values of M and T are now replaced with blank space.

Thanks!

mvolz47

Andrew:

I changed some paths for my specific environment and ran your script successfully. What field is not getting populated correctly?

AndrewL

Hi I have attached the python script and the data file (zip). Thank you for your help! Basically the script extracts the files from the zip file then looks for the .txt file that contains "daily" in the file name, and converts that to geodb table.

obs.py.zip

QCLCD201401.zip

AndrewL

Hello. I can try. Most of the script was written by a private vendor, so I am not sure if I feel comfortable with that. I will try to work up something though.

Also, a schema.ini file is created when running the script on the VM, and not on my PC. It's contents is here. Col 1 and 2 only contain integers. Columns 3,5,7,11,13,15, 17 all have a mix of text and integer values, but only the integer values come through on my VM. Thank you.

[201312daily.txt]
Col3=Tmax Text
Col5=Tmin Text
Col7=Tavg Text
Col11=DewPoint Text
Col13=WetBulb Text
Col15=Heat Text
Col17=Cool Text

mvolz47

Would you be able to send the data and script in a post so I can try it on both a desktop and server?

AndrewL

There is some error logging. I did not create this script from scratch. I'm doing some modification of an older script my company uses. I am not getting an error. It runs fine.

mvolz47

Do you have any error logging included in your python script that could help to identify the problem?

AndrewL

No in the windows command prompt. I call the loader.bat file which calls the .ini config file and .py file. Thanks!

mvolz47

Are you running your scripts through IDLE?

AndrewL

Hello.

No they are both running 64-bit. Thanks.

mvolz47

Could you be running the script in a 32-bit environment on your PC and in a 64-bit environment on your VM server?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.