topic Re: Hyperlink in a Datatable in State & Local Government Questions

Hyperlink in a Datatable

CameronCole1 — Tue, 12 Jul 2016 18:33:47 GMT

I am trying to bring a .CSV file into arcmap that has a hyperlink to a .pdf in one of the fields. When I convert the .csv to a .dbf the hyperlink is lost. How can I keep the "attachments" I want? Or do I have to reattach the image afterwards in the .gdb to the feature class?

Re: Hyperlink in a Datatable

DanPatterson_Retired — Tue, 12 Jul 2016 20:50:12 GMT

I would get the table into the final form you want, then establish hyperlinks. Did the link information not carry forward to dbf properly? try a featureclass table, in case it is a field length issue or data formatting issue

Re: Hyperlink in a Datatable

CameronCole1 — Tue, 12 Jul 2016 20:57:53 GMT

Dan,

Ok so the link didn't carry through. It had the text that was there but no link ability.

I am trying to have data (in excel) with a pdf hyperlink file attached to each row or data point, then bring in the stand alone table to arcmap as a .dbf, then join the information based off the id field to a feature in a GDB.

Does that clarify my problem?

Thanks Cameron

Re: Hyperlink in a Datatable

DanPatterson_Retired — Tue, 12 Jul 2016 21:03:20 GMT

Yes, although I hate it when excel is used as a database manager, I do understand the need.

I would skip the intermediary dbf problem, but working with excel and Arc directly using esri's tools

An overview of the Excel toolset—Help | ArcGIS for Desktop and

Excel To Table—Help | ArcGIS for Desktop

perhaps some of the issues can be dispensed with. give it a try

Re: Hyperlink in a Datatable

CameronCole1 — Tue, 12 Jul 2016 22:56:27 GMT

Dan,

Yes I agree excel isn't the best manager. We are trying to get away from it and put all of the data into arc.....its a process.

Thank you for the help! I will just upload the excel file into my feature layer via the tool you described. I cant believe I forgot that tool.

CHEERS!

Re: Hyperlink in a Datatable

DanPatterson_Retired — Tue, 12 Jul 2016 23:24:54 GMT

you may as well just create your tables in Arc* then, there is nothing wrong with that... I do it all the time

Re: Hyperlink in a Datatable

CameronCole1 — Wed, 13 Jul 2016 15:27:37 GMT

I am trying to move to that protocol but some people don't have the want to switch things to arc. If you know what I mean.

Anyways next question........

I am using model builder to join the excel table I have with a parcel layer based on an ID field. However, every time I update my excel file and re-run the tool the data doesn't overwrite what was already in the parcel table. it just adds all of the fields to it.

Do I need to pull it out to python and add an overwrite function or is there a easy tool I can just drag into model builder to overwrite what is in the table?

Thanks

Re: Hyperlink in a Datatable

DanPatterson_Retired — Wed, 13 Jul 2016 17:51:32 GMT

thought this sounded familiar, I posted in your modelbuilder question