|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] problem integrating comma-delimited db file |
| Date: |
06/03/2004 03:40:01 PM |
| From: |
Jaclyn_LaMotta .. akrf.com |
|
|
FYI - just a quick thing I picked up along the way. When working with .dbf
files in excel you sometimes loose data especially when adding additional
fields at the end. To stop that from happening, go to Insert - Name -
Define and select the little table button on the bottem right hand corner,
then select ALL the cells that contain data, hit Enter, then OK. This tells
excel which fields contain data and to save them. Haven't had the problem
of losing data since.
"RICK GRAY"
<RGRAY@ridgetownc
.uoguelph.ca> To
Sent by: <gislist@lists.thinkburst.com>,
gislist-bounces@l <coastgis@mcn.org>
ists.geocomm.com cc
Subject
06/03/2004 04:01 Re: [gislist] problem integrating
PM comma-delimited db file
I bring my text file through Excel, set the format of the cells in each
column,
then save as a dbaseIV file. By doing this, you "preformat" the columns to
match your attribute table.
If someone knows a better way, I'm all ears.
Rick Gray
GIS Specialist, Ontario Weather Network
http://www.ownweb.ca
GIS Instructor
Ridgetown College, University of Guelph
http://www.ridgetowncollege.com/
Tel. 519-674-1554
E-mail: rgray@ridgetownc.uoguelph.ca
Ridgetown: -81.883 W, 42.450 N
>>> Rixanne Wehren <coastgis@mcn.org> 6/3/2004 3:53:05 PM >>>
Hello listers,
I hope someone with database knowledge can help me with this.
AV 3.2
I have to export the DB from a shapefile (2000+ points) to a web server as
a comma-delimited file, where it is used to display the points over a
static map. OK so far. Then various people add points through the web,
using attributes checkboxes to populate the same fields as the original
shapefile.
This new DB file is then sent back to me as a comma-delimited file, and I
am supposed to merge the new points back into the original shapefile. (or a
new copy :-)
The problem comes in now. When the comma-delimited file comes back to me I
can enter it as an events theme (using UTM coordinates included) BUT. . . .
the resulting shapefile does not have the same field characteristics as the
original file. Specifically, the fields do not have the same number of
characters. They only have as many characters as the comma-delimited file
actually used.
Such as, a field that had 6 character spaces originally now has only 1
space if the file only had a one-letter entry in it.
These files will merge, but do not fill in the fields that are now
incompatible. The names are OK, but the character spaces are not right.
Is there any way that I can get the new data to go back into a shapefile
that has the correct field characteristics?
Anxiously awaiting any hints, will sum,
Rixanne
Rixanne Wehren
GeoGraphics / Coast GIS Lab
PO Box 340, Albion CA 95410
707-937-2709 M-F 8-3
Clients include: Mendocino County Resource Conservation District,
Coastwalk, Ridge to River, Coastal Land Trust, E-Center.
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
This message has been scanned by Mcafee Anti-virus Software and is
certified virus free.
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
Th
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
