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?
Solved! Go to Solution.
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
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
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
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
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!
you may as well just create your tables in Arc* then, there is nothing wrong with that... I do it all the time
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
thought this sounded familiar, I posted in your modelbuilder question