The filename that I imported was named something like salmon-x.csv. The auto-suggested name would then be salmon-x which is not a legal R variable name and gets interpreted as a calculation with R complaining that object 'salmon' not found.

The workaround is simple enough, I just overwrote the suggested name.

It might be preferable to replace the '-' character by underscores in the suggested name. Of course there might be other characters such as '+' that are legal in filenames but might not be R-friendly.

Dear sirs,

I´m trying to import a single spreadsheet (attached) and it doesn´t parse at all.
The print screen is also attached.
Thanks for any help in advance!

sims_data.xlsx

Please take this suggestion with a grain of salt since I am the (co-)author of the package, but why not use rio to handle the file importing? This way you don't need to reimplement all of the complex handling of file types, etc. No pressure, of course.

• does the system() command run on windows?

The file explorer shouldn't be opened in the user home directory but in the current working directory. It is very likely that files relevant for the current project will be located there.

I've been trying GREA.
It works well with csv files,
but when importing SPSS SAV files I can't get the preview and when I press "Done" I get this error:

Listening on http://127.0.0.1:5670

1. Wrong options for generating df, or
2. Outcome is not a df (for Excel and SPSS reader functions)

Though, if I use haven or foreign to import it it works well.

I've tried installing this with MRO 3.3.0 64bit, R 3.3.0 64bit and 32bit all on Win7. It gives similar errors.
I also tried doing this in Rstudio and the R command prompt. Same errors.

devtools::install_github("Stan125/GREA")
Downloading GitHub repo Stan125/GREA@master
from URL https://api.github.com/repos/Stan125/GREA/zipball/master
Installing GREA
"C:/PROGRA1/R/R-331.0/bin/x64/R" --no-site-file --no-environ --no-save
--no-restore --quiet CMD INSTALL
"C:/Users/[user]/AppData/Local/Temp/Rtmp4Qvf49/devtools2bb019b06959/Stan125-GREA-8eb2b3f"
--library="\clus-file-01/userdirs/[user]/Documents/R/win-library/3.3"
--install-tests

• installing source package 'GREA' ...
  ** R
  ** inst
  ** tests
  ** preparing package for lazy loading
  ** help
  *** installing help indices
  ** building package indices
  ** testing if installed package can be loaded
  *** arch - i386
  Warning in library(pkg_name, lib.loc = lib, character.only = TRUE, logical.return = TRUE) :
  there is no package called 'GREA'
  Error: loading failed
  Execution halted
  *** arch - x64
  Warning in library(pkg_name, lib.loc = lib, character.only = TRUE, logical.return = TRUE) :
  there is no package called 'GREA'
  Error: loading failed
  Execution halted
  ERROR: loading failed for 'i386', 'x64'
• removing '\clus-file-01/userdirs/[user]/Documents/R/win-library/3.3/GREA'
  Error: Command failed (1)

Perhaps it's because my R lib folder is a network share?

I quickly tried installing it on my Ubuntu Mate box, and that worked fine. So I'm pretty sure it's something odd about the setup on my Windows machine.

There's a BI department at my work that stores data as QVD files. I would love to load them using R.

• Finish all the help pages first

Importing a CSV file with missing-value placeholders "-99, --"

Clearly, this only works for a single missing value placeholder.

na.strings needs to be string-split into a vector based on ","

After installed all require packages, I run this code:
devtools::install_github("Stan125/GREA")

Here's result

Downloading GitHub repo Stan125/GREA@master
from URL https://api.github.com/repos/Stan125/GREA/zipball/master
Installing GREA
"F:/Programming/R/R-3.3.1/bin/x64/R" --no-site-file --no-environ
--no-save --no-restore --quiet CMD INSTALL "D:/DATA/App
Cache/WindowsTemp/Temp/Rtmp4Aq6YN/devtools35b428f40be/Stan125-GREA-e80db34"
--library="F:/Programming/R/R-3.3.1/library" --install-tests

• installing source package 'GREA' ...
  ** R
  ** inst
  ** preparing package for lazy loading
  ** help
  *** installing help indices
  ** building package indices
  ** testing if installed package can be loaded
  *** arch - i386
  ARGUMENT 'Cache\WindowsTemp\Temp\Rtmpwh8yJW\Rin36a86eb36998' ignored

Error: unexpected symbol in "Microsoft DiskPart"
Execution halted
*** arch - x64
ARGUMENT 'Cache\WindowsTemp\Temp\Rtmpwh8yJW\Rin36a878dd7c2a' ignored

Error: unexpected symbol in "Microsoft DiskPart"
Execution halted
ERROR: loading failed for 'i386', 'x64'

• removing 'F:/Programming/R/R-3.3.1/library/GREA'
  Error: Command failed (1)

Hi Stan -

I followed the instructions to install this addin but got the following error. Can you please help resolve this?

devtools::install_github("Stan125/GREA")
Downloading GitHub repo Stan125/GREA@master
Error in packageVersion("curl") : package ‘curl’ not found

Can you please help resolve this?

Thanks!

Hi Stan125,

thanks a lot for building up this addin.
I'm wondering if you'd like to add one optional function to the seperator which enables one choosing the separator that is not included in your list? I think it would be very helpful for many users.

Best,
meged

Dear Stan,

I'd like to ask if you can make it possible to set the type per variable with simple drop-down menu, so I can easily set to date, character, numeric, factor, etc. This would be so helpful, as it takes me forever each time.
If additionally I could set the labels interactively aswell, that would be amazing.
Great Work
Best Wishes

I think it would be good if your package generated the appropriate code to open the file in a non-interactive mode.

This way, the user doesn't have to go through a interactive process every single time they want to re-run the code. Interactive is good for user experience, especially for novices, but it is more time consuming.