Data not updating #214
Labels
Comments
|
Thanks for noticing this. Can you please describe the issue a bit more?
What dates are you requesting data for, and are you usong the front-end
query builder or an API?
Cezary
On Sat, May 6, 2017 at 1:11 PM mikeydoggy ***@***.***> wrote:
When I try to get updated data, keep getting "no results found."
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#214>, or mute
the thread
<https://github.com/notifications/unsubscribe-auth/AC28VZ-_ueUfRlIOq9zjG_0reVQ_rL76ks5r3KnMgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
|
I am using the front end. I use this every week to update my own database.
So, for example, if I select, "What programs are making deposits and withdrawals?" (Table 2) And let's say I select Social Security Benefits under "withdrawal" and then I select the dates, "After, 2017-04-27" and "Before, 2017-05-05" and hit, "Query preview," it comes up, no results found.
________________________________
From: Cezary Podkul <notifications@github.com>
Sent: Saturday, May 6, 2017 3:00 PM
To: csvsoundsystem/federal-treasury-api
Cc: mikeydoggy; Author
Subject: Re: [csvsoundsystem/federal-treasury-api] Data not updating (#214)
Thanks for noticing this. Can you please describe the issue a bit more?
What dates are you requesting data for, and are you usong the front-end
query builder or an API?
Cezary
On Sat, May 6, 2017 at 1:11 PM mikeydoggy ***@***.***> wrote:
When I try to get updated data, keep getting "no results found."
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#214>, or mute
the thread
<https://github.com/notifications/unsubscribe-auth/AC28VZ-_ueUfRlIOq9zjG_0reVQ_rL76ks5r3KnMgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#214 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AbK32E_N9G5dcGvRa73ZCQLeovVeT3QQks5r3MNngaJpZM4NS1jk>.
|
|
I am seeing this also using the api in google docs. It appears the most recent available data is from April 19th, 2017. Example in this spreadsheet |
|
Thanks we've noticed that as well. We'll look into why the data collection
seems to have stopped and let you know when it's fixed.
Cezary
…On Fri, May 12, 2017 at 5:58 PM, mikedrawback ***@***.***> wrote:
I am seeing this also using the api in google docs. It appears the most
recent available data is from April 19th, 2017.
Example in this spreadsheet
<https://docs.google.com/spreadsheets/d/1Aoy1pxCjBeau0gSxhPiL5pF15ZBCFWI5j6vXA5b5wOE/edit?usp=sharing>
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#214 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AC28VYBQkxK5-zED6RA398jMYtShaPbOks5r5NYYgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
|
Thanks.
You may want to check with the Treasury and how they post their data. They changed something back in April and some browsers can't access.
…Sent from my iPhone
On May 16, 2017, at 2:10 PM, Cezary Podkul <notifications@github.com<mailto:notifications@github.com>> wrote:
Thanks we've noticed that as well. We'll look into why the data collection
seems to have stopped and let you know when it's fixed.
Cezary
On Fri, May 12, 2017 at 5:58 PM, mikedrawback ***@***.******@***.***>> wrote:
I am seeing this also using the api in google docs. It appears the most
recent available data is from April 19th, 2017.
Example in this spreadsheet
<https://docs.google.com/spreadsheets/d/1Aoy1pxCjBeau0gSxhPiL5pF15ZBCFWI5j6vXA5b5wOE/edit?usp=sharing>
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#214 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AC28VYBQkxK5-zED6RA398jMYtShaPbOks5r5NYYgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com<http://cezarypodkul.com>
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#214 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AbK32F8embRtU-EGWSmuLEfbm6xbKa-2ks5r6eamgaJpZM4NS1jk>.
|
|
Any updates on this? |
|
Nope
…Sent from my iPhone
On Jun 30, 2017, at 9:54 AM, mikedrawback <notifications@github.com<mailto:notifications@github.com>> wrote:
Any updates on this?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#214 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AbK32IjfogAkFMtC_z_VsULqyIXPQnpQks5sJP3_gaJpZM4NS1jk>.
|
|
Dudes - what's going on here? The only truth to be found and ... it's down??? |
|
Sorry for the delay, we are looking into it along with another option for making the service more robust in the future. |
|
Any update on this issue. I am not seeing any date newer than April 19th. Here is the URL I am hitting. |
|
Hi Joe,
Buton has created a branch where he refactored and simplified the code:
https://github.com/csvsoundsystem/federal-treasury-api/tree/burton-parser-fixup
Instead of just executing download_and_parse_fms_fixies.py to run
everything there is now a download_fms_fixies.py and a separate
parse_fms_fixies.py function. Running those two should build the DB as
before, hopefully with the additional dates restored.
I've been trying to test this out to see if it fixes the issue but Windows
(as usual) is having issues running the script so I'll need more time to
figure this out. In the meanwhile, feel free to test it out and let me know
if it works for you.
Cezary
…On Wed, Sep 6, 2017 at 1:11 AM, Joe Schulte ***@***.***> wrote:
Any update on this issue. I am not seeing any date newer than April 19th.
Here is the URL I am hitting.
http://api.treasury.io/cc7znvq/47d80ae900e04f2/sql/?
q=SELECT+%22close_today%22%2C+%22open_today%22%2C+%22date%
22%2C+%22is_total%22%2C+%22url%22+FROM+t3c+WHERE+%
22item_raw%22+%3D+%27Total+Public+Debt+Outstanding%27+
ORDER+BY+date+DESC+LIMIT+1 <http://url>
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#214 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AC28VQ6KH-2Y80K0hVjenOFrf2nioLvPks5sfimagaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
|
Hello,
Quick update: The fixies now download successfully through today if you
execute download_fms_fixies.py.
The parser query is still buggy, will need more time to figure that out
before I feel comfortable merging into master.
Cezary
On Thu, Sep 7, 2017 at 12:29 AM, Cezary Podkul <Cezary.Podkul@gmail.com>
wrote:
… Hi Joe,
Buton has created a branch where he refactored and simplified the code:
https://github.com/csvsoundsystem/federal-treasury-api/tree/burton-
parser-fixup
Instead of just executing download_and_parse_fms_fixies.py to run
everything there is now a download_fms_fixies.py and a separate
parse_fms_fixies.py function. Running those two should build the DB as
before, hopefully with the additional dates restored.
I've been trying to test this out to see if it fixes the issue but Windows
(as usual) is having issues running the script so I'll need more time to
figure this out. In the meanwhile, feel free to test it out and let me know
if it works for you.
Cezary
On Wed, Sep 6, 2017 at 1:11 AM, Joe Schulte ***@***.***>
wrote:
> Any update on this issue. I am not seeing any date newer than April 19th.
> Here is the URL I am hitting.
> http://api.treasury.io/cc7znvq/47d80ae900e04f2/sql/?q=
> SELECT+%22close_today%22%2C+%22open_today%22%2C+%22date%22%
> 2C+%22is_total%22%2C+%22url%22+FROM+t3c+WHERE+%22item_raw%
> 22+%3D+%27Total+Public+Debt+Outstanding%27+ORDER+BY+date+DESC+LIMIT+1
> <http://url>
>
> —
> You are receiving this because you commented.
> Reply to this email directly, view it on GitHub
> <#214 (comment)>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AC28VQ6KH-2Y80K0hVjenOFrf2nioLvPks5sfimagaJpZM4NS1jk>
> .
>
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319 <(708)%20228-1319>
Web: cezarypodkul.com
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
|
Hi @cezary4 : Which branch were you thinking of with the sentence below? |
|
This one:
https://github.com/csvsoundsystem/federal-treasury-api/tree/burton-
parser-fixup
…On Tue, Oct 10, 2017 at 2:50 PM, Cameron Yick ***@***.***> wrote:
Hi @cezary4 <https://github.com/cezary4> : Which branch were you thinking
of with the sentence below?
The fixies now download successfully through today if you
execute download_fms_fixies.py.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#214 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AC28VYj3-s8FFP8uPN99zoAVzWUFCob2ks5sq7xTgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
2 tasks
|
Hey treasury data fans! We at Enigma have rewritten the treasury.io parser with our internal ETL libraries based on the contents of this repo, and are currently keeping these tables up-to-date at the following link: https://public.enigma.com/browse/1ee6ce88-f5f8-4a2c-8190-445739beea31 |
|
Thanks Cameron! What do you think would be the best way to integrate this
into the website? We were just talking about it the other day, open to any
suggestions.
Cezary
On Sat, Mar 24, 2018 at 9:11 PM Cameron Yick ***@***.***> wrote:
Hey treasury data fans! We at Enigma have rewritten the treasury.io
parser with our internal ETL libraries based on the contents of this repo,
and are currently keeping these tables up-to-date at the following link:
https://public.enigma.com/browse/1ee6ce88-f5f8-4a2c-8190-445739beea31
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#214 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AC28VdvgEPqfvrFxRUmuiIwunNAfw4zwks5thu7CgaJpZM4NS1jk>
.
--
Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When I try to get updated data, keep getting "no results found."
The text was updated successfully, but these errors were encountered: