similar to: Bringing dbf Data With SQL

Hello.. I am currently working on running random forest to make predictions. For that I have a bunch of .dbf files from shapefiiles. Earlier I was running random forest on those dbf files individually but now I have >1,000 such files and procesisng one by one is not an option. I started by trying to read multiple dbf files as: >setwd (..) >a=list.files() > for (x in

Hi there, This is summary and patch for a bug in read.dbf, demonstrating in Message-Id: <20050818150446.697835cb.stanimura-ngs at umin.ac.jp>. After consulting Rjpwiki, a cyber-community of R user in Japan, the cause was found, and the patch of solution was proposed. Overflowing occurs when we use read.dbf for reading a dbf file having a field of longer signed integer. For example, $

Hi I know that it is very easy to import data from a dbf file to R, by saving the data as csv, for instance. However, I have several hundreds of files to do that. So, I thought of using RODBC to read the dbf files and save it as data.frame. However, I cannot even start (this is my first time using such package): > library(RODBC) > bdades <- odbcConnect("prova.DBF") Warning

Hello, I'm newbie in R and I have a problem exporting a table with many columns to a dbf file. I found an error when I open the result DBF file on other software and also importing it on R again. Here a example snippet of the problem (on a GNU/Linux OS): http://pastebin.com/0SMJqqwb Is it a bug? Thank you, Nacho V [[alternative HTML version deleted]]

Dear UseRs, I did not have any answer to my previous message ("Is there a way to define "manually" columns width when using write.dbf function from the library foreign ?"), so I tried to modify write.dbf function to do what I want. Here is my modified version : write.dbfMODIF <- function (dataframe, file, factor2char = TRUE, max_nchar = 254, width = d) {

Dear all, I am basically a GIS user and am new to R. I am trying to write a data frame to a dbf file. *n.simulations <- 999 binomial <- kulldorff(geo, cases, population, NULL, pop.upper.bound, n.simulations, alpha.level, plot) cluster <- binomial$most.likely.cluster$location.IDs.included df <- data.frame(ID=seq(1,n.simulations,by=1), simloglkhd=binomial$simulated.log.lkhd)

Hello Arnaud, You posted this question a long long time ago, however I found your answer so I decided to post it anyway in case somebody else have the same problem as you and me. You were actually very close in finding your solution. The function DoWritedbf is an internal function from the foreign package. To access it outside of the package just do: foreign:::DoWritedbf so in your line:

good morning This question is not a stats question per say but a data management and lattice plotting problem. I apologize now if I'm asking an inappropriate question to this gracious group. I'm need to bring in approximately 100 *.dbf files into R but I'm having difficultly understanding several examples I've tracked down regarding this procedure and could benefit from your

Hi - I need to export data to openoffice base, where one of the elements is a long character vector (>255 characters.) write.dbf exports it as varchar, truncating the data. Any idea how to do this? thanks, -eduardo

For several days, I try to run an Windows- Application on an Ubuntu 7.04 System through wine 0.9.58. In detail, it's a tool for supporting a change of food and sports behavior. The tool is freeware, named "Di?t- Tagebuch" (diet diary or diet day book) and downloadable at: http://www.diet-daybook.de/DTBInstall2.exe (unfortunately it's only in german) The DTBInstall2.exe is an

Hello. I am trying to acces to a software in a network, from a terminal. This terminal works on Windows, so I use Wine. I could execute the software, but some errors appear. It seams that it couldn't create in the right way the indexes in the data base (.dbf and cdx files). I think that the software was programed with Visual Fox Pro (but I am not sure) I will appreciate yours comments and

Hi List, Second attempt to get this issue diagnosed and solved. Samba Version 3.0.28el4 CentOS 4.7 The behavior is as follows when accessing Fox Pro dbf files. Users can access the files through the Fox Pro command interface without issues,when they choose a graphical environment (windows explore of the windows file open gui) the system returns an access denied message on the first

Estimados: Tengo un directorio con varios archivos Excel quiero importarlos todos y grabarlos en un único archivo .dbf. Haciendolo uno por uno lo logro de la siguiente manera (solo tomo 2 archivos): archivos <- list.files(pattern = 'xls') a1 <- read.xls(archivos[1], perl="C:\\strawberry\\perl\\bin\\perl.exe",skip=12,dec=",",header=F,as.is=T) a2 <-

Hi, I have these BMIMS .dbf/.cdx/.fpt files. I have no longer BMIMS. I would like to transfers theses files to another visible format. I tried opening them with Monarch 4.0, but it does not give me a proper format. what do i do? thankx

having a problem with ocfs. device /dev/sdd mounted on 2 nodes, node 0 and node 1 tried to create file /u01/oracle/prod/proddata/temp01.dbf from node 1 (ALTER TABLESPACE TEMP ADD TEMPFILE...) caused oracle server process to hang in a "D" state apparently trying to create the file. the file has not been created yet. If I type "ls" from node 2 in directory /u01/oracle/prod

I want to read data from a number of files into R. Reading individual files one by one requires writing enormous amount of code that will look something like the following. **************** maptools:::dbf.read("wb-01vc.dbf")->dist1 maptools:::dbf.read("wb-02vc.dbf")->dist2 maptools:::dbf.read("wb-03vc.dbf")->dist3

A Windows 2000 Server is a member server of the domain. The domain server is CentOS 4.5 with all updates and Samba 3.0.24 built using the packaging/RHEL/makerpms.sh script. The W2k server is opening this file on the samba server. This problem started several versions of CentOS and Samba ago, and I did the upgrades thinking it would fix it. It did not. It seems to be "locking" or

Hello, I've been working with a xBase database (similar to dBase) in a multiuser application. There are like 40 users working on the database on the same time reading and like 10 writing information. Sometimes the CDX files (Index Files) get corrupted and is it's necessary to pack the tables (rebuild the indexes). I have notice using the smbstatus -B command the following Pid

an ocfs-volume was nearly full (only 800MB free). i deleted some datafiles to free space: $ df -h . Filesystem Size Used Avail Use% Mounted on /dev/sdp1 10G 5.3G 4.8G 53% /db/DPS so there are more than 4GB available. $ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights

Hi to everyone, Since last week I am trying to fix following problem: I have a DOS application, operating on DBF databases. I've set up a Samba 3.0.14a-2 server running as a PDC on Fedora Core 4 (in fact, Samba server was a part of FC4 distribution). I've set up a share and then I've moved all data for this application on to that share. The problem is that the application hangs