Select to view content in your preferred language

Transfering Data to a Database

573
11
05-22-2024 06:28 AM
Labels (2)
Ozan
by
New Contributor

Edit: Today I wrote two posts detailing what I tried, to solve the problem and the results (yes, unsuccessful). Both were deleted, no explanation, no reason, just gone. From my point of view, esri does not actually want to help me here.

 

0 Kudos
11 Replies
Ozan
by
New Contributor

I did write a long reply, but it seems it was deleted....

Long story short, I tried importing data or loading data without success. Even with a shapefile with only id and shape* columns, seperately with a polyline and a point data. Arcgis does create table but does not fill the table. Only, sometimes arcgis manages to enter a data or two with long objectid like 123246567. It was even a negative number sometimes.

0 Kudos
VinceAngelo
Esri Esteemed Contributor

Well, I don't know what happened, but Esri uses a third party app for Community, and it's possible something went wonky and a spontaneous rollback happened on the server; I very much doubt someone has maliciously removed content. 

I would note that this Community is not Esri Tech Support. If you want help from Esri, you should contact Tech Support according to the terms of your support contract. Community is a user engagement forum, in which some Esri employees also post, as fellow users.

Railing against Esri in the forums Esri provides for user interaction is probably not a good way to get help from staff contributors.  

I've loaded tens of billions of rows into thousands of PostgreSQL tables in the past decade (a couple hundred million in the past week alone -- dev migration), many of which with plain vanilla ArcPy scripts and Python toolboxes into PostgreSQL databases without enterprise geodatabases enabled. There is a trick to it, though, and without details on the exact database in use, and how you've configured the database, logins, and schemas, and the actual load procedure you used, it's difficult to guess what may have gone wrong.

Good luck.

- V

0 Kudos