LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: quattro_junkie

Hi All,

I have searched the forum but was unable to find anything on .DBF files. Does anyone know if it is possible to read .DBF files with BRE?

Thanks in advance.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

Yes it is, using python node that you would have to customize to be able to read in dbf file. For reference you can use this link

http://code.activestate.com/recipes/...er-and-writer/

and also on this forum you can find simple python node example. With basic programming skills you should be able to merge these two solutions together.

Marek

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi,

as an update to the question, here is a node that leverages the Power R node and the CRAN library 'foreign' package to read .dbf files. Note, due to the prerequisite CRAN package being Open Source licensed it needs to be downloaded directly from a CRAN mirror site if it is not already installed on your machine. When using a Windows machine, the node will attempt to download and install the package provided you have agreed to this by accepting the agreement (see the node's 'License' tab for further details). The 'foreign' package cannot read all versions of .dbf files.

You will need to have the relevant node pack license installed to use the Power R node.

Adrian

Power_R_Node_Read_DBF_File_Example.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

For customers who would like to use and Open Source R server, the attached node will leverage the R server to read a .dbf file. As noted for the Power R version of this node, the 'foreign' CRAN package is used to convert the file. The foreign package must be installed on the machine hosting the R server. In the case where a Windows machine is used to host both the LAE Server and the R Server (e.g. a desktop installation) the node will download and install the foreign package provided you have accepted the agreement.

Rserve must be running on the R Rerver and the R Server must be accessible from the machine hosting the LAE Server. The connection details for the R Server can be configured in the node - by default, the node will attempt to connect to an R Server on the local machine.

Adrian

R_Node_Read_DBF_File_Example.brg