topic Import DSN Oracle Table to ArcLogistics 9.3 in Transportation Questions

Import DSN Oracle Table to ArcLogistics 9.3

Anonymous User — Wed, 23 Feb 2011 20:57:57 GMT

Original User: njennings

I have a connection to an Oracle table that contains the information that I want to import to ArcLogistics. When I do this I see the attributes of the table repeated 2 times. 1 full set of attributes and then a second set of attributes. I looked at my source table in SDE through catalog and the attributes only show up one time, so I assume the data fields are ok.

I do not see this issue when importing the same table through the same method in ArcLogistics 3.

Any insight would be appreciated. I have attached screen shots of both 9.3 and 3. You will see where SPID is shown twice indicates where the attributes are beginning to duplicate. Notice ArcLogistics 3 only shows the attributes 1 time. The import table is from the exact same source.

Thank you,
Nate

Re: Import DSN Oracle Table to ArcLogistics 9.3

Anonymous User — Thu, 24 Feb 2011 15:18:41 GMT

Original User: jwickstrom

Hello Nate,

We have not seen that problem. Odd. I would blame it on the database driver had you not preempted that with the 3.x test! It would also be interesting to try this DSN from some other app (i.e. Excel or Access).

Does it make a difference whether you are using a saved import profile or using a new one?

So what happens when you do the import? Does it work?

If not, please add a support incident for it. If it works anyway, perhaps add a support incident with a lower urgency factor on it.

Thanks,
Jeff

Re: Import DSN Oracle Table to ArcLogistics 9.3

NathanJennings — Thu, 24 Feb 2011 20:48:29 GMT

The data does import, but this is something I noticed as an anomaly and could not determine why this would be the case. This being said, I may not worry too much about it.

Thanks,
Nate