|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] problem integrating comma-delimited db file |
| Date: |
06/03/2004 04:05:01 PM |
| From: |
Emily Smith |
|
|
Good idea. To avoid losing extra columns or data formats with a .dbf that
I was working with in Excel, I used to just copy all the data and paste
values and formats into a new blank excel sheet--then save as a .dbf (IV)
file. This took care of any formatting issues with excel.
-Emily Smith
GIS Analyst
At 04:21 PM 6/3/2004 -0400, Jaclyn_LaMotta@akrf.com wrote:
>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
>
>
>___________________________________
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
