Data not updating

[mikeydoggy]

When I try to get updated data, keep getting "no results found."

[cezary4]

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

[mikeydoggy]

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 <[email protected]> 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>.

[mikedrawback]

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

[cezary4]

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

[mikeydoggy]

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 <[email protected]<mailto:[email protected]>> 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>.

[mikedrawback]

Any updates on this?

[mikeydoggy]

Nope

…

Sent from my iPhone On Jun 30, 2017, at 9:54 AM, mikedrawback <[email protected]<mailto:[email protected]>> 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>.

[henrythefifth2]

Dudes - what's going on here? The only truth to be found and ... it's down???

[mhkeller]

Sorry for the delay, we are looking into it along with another option for making the service more robust in the future.

[JoeSchulte]

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

[cezary4]

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

[cezary4]

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 <[email protected]> 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

[hydrosquall]

Hi @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.

[cezary4]

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

[hydrosquall]

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

[cezary4]

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