12-04-2019 12:55 PM - edited 12-08-2019 05:26 PM
Using: Geomedia v16.5.0 Build 4108
First approach was:
Result: everything seems to work fine(no error or warning) but unfortunately some rows appeared duplicated.
Result: everything seemed ok (no error or warning) but unfortunately some of the columns disappeared (it seems that Geomedia doesn't know how to deal with same column names)
Any suggestion on how to successfully import a excel file to Geomedia?
Other related topics:
Although, I can't suggest this as a new idea. I would consider this only as a bug as the functionality is there but is not working properly.
Also I wonder if this is covered on Geomedia Desktop 2020
Thank you for your assistance on this.
12-08-2019 05:02 PM
Check https://community.hexagongeospatial.com/t5/GeoMedia-Release-Information/GeoMedia-Desktop-2020-Releas... - a new Excel Data Server is part of GeoMedia 2020 release that came out October 2019.
The old attach table capability is dependent on underlying .mdb attach table.
You might want to open the .mdb that has the attached table in Microsoft Access and see if it is behaving there.
Also GeoMedia gernerally has certain rules around column names such as no spaces or special characters.
Finally also check out https://community.hexagongeospatial.com/t5/GeoMedia-Q-A/Problems-using-Attach-Table-in-GeoMedia-to-a... though that does not seem to be directly releated here.
12-08-2019 05:25 PM
Hi Shaun, thank you for your attention on this,
The data on my access database is perfectly fine. Only the datawindows shows duplicated values.
that's good to know that the problem should be solved on the newest version.
Although I had some issues because I thought that the values on Datawindow were ok as no error/warning was displayed. I took a while to understand that some values were actually duplicated. I expect to try the latest version as soon as I can.
I will let you know if there is any different behaviour in the newest version (Geomedia Desktop 2020).
12-08-2019 05:49 PM
Sounds good. Also keep in mind you can log support calls and supply data for replication. That can assist us identifying and remedying issues with the system.