Hyperlink in a Datatable

3357
7
Jump to solution
07-12-2016 11:33 AM
CameronCole1
New Contributor III

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?

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

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

View solution in original post

0 Kudos
7 Replies
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
CameronCole1
New Contributor III

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

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
CameronCole1
New Contributor III

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!

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
CameronCole1
New Contributor III

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

0 Kudos
DanPatterson_Retired
MVP Emeritus

thought this sounded familiar, I posted in your modelbuilder question

0 Kudos