Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

problems following instructions on vignette #54

Open
nicholasjhorton opened this issue Aug 11, 2016 · 2 comments
Open

problems following instructions on vignette #54

nicholasjhorton opened this issue Aug 11, 2016 · 2 comments

Comments

@nicholasjhorton
Copy link
Collaborator

nicholasjhorton commented Aug 11, 2016

I'm running the github versions of etl and airlines.

When I ran:

library(airlines)
db <- src_mysql(host="localhost", user="root", password="XX", dbname="airlines")
ontime <- etl("airlines", db = db, dir = "~/dumps/airlines")
ontime %>%
etl_init() %>%
etl_update(years = 2015:2016)

I got the following error message when it got to 2016_06:

trying URL 'http://tsdata.bts.gov/PREZIP/On_Time_On_Time_Performance_2016_5.zip'

Content type 'application/x-zip-compressed' length 23829775 bytes (22.7 MB)

downloaded 22.7 MB

downloaded 0 bytes

Error in (function (url, destfile, method, quiet = FALSE, mode = "w", :
cannot download all files
In addition: Warning message:
In (function (url, destfile, method, quiet = FALSE, mode = "w", :
URL 'http://tsdata.bts.gov/PREZIP/On_Time_On_Time_Performance_2016_6.zip': status was '404 Not Found'

I'm on a Mac.

@nicholasjhorton
Copy link
Collaborator Author

ontime %>%
etl_init() %>%
etl_update(years = 2013:2015)
ontime %>%
etl_update(years=2016, months=1:5)

worked for me.

@beanumber
Copy link
Owner

Yes, the June file doesn't exist and currently it does not fail gracefully.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants