Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Tell HN: ChatGPT is fantastic for finding and solving issues in logs

news.ycombinator.com

Post reply on HN
Print view View original

151–160 of 184 posts

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#151

Post by ttul »

Rastonbury wrote: post #41
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

That's pretty cool and interesting, I wonder how it would know credit card statement lines items or if that's in training data. Do you have an example of a cryptic item, like how is it totally unrelated to the purchase

It’s so simple it’s embarrassing to admit. I think the prompt is “Here is a credit card statement item. Identify the company: ”

GPT-4 is just that good at one shot classification tasks.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#152

Post by ttul »

alphadog wrote: post #43
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

Did you use the API for this, or did you copy and paste into the GUI?

API for sure.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#153

Post by ttul »

haliskerbas wrote: post #95
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

How are you interfacing with gmail? I also wanted to clean up my inbox with some help and wasn’t sure the best touch point

Using the Gmail API. It uses OAuth to authenticate. Google Cloud lets you create a custom OAuth login box for your “app”. You download a JSON file and the Python client code reads that and sends the user to a web browser to go through the OAuth flow. Then some kind of bearer token is stored in a dot file and your code has access to your Gmail…

Releasing a public app that has Gmail access requires a very expensive security audit by Google. But for a private internal app, of course you don’t need the audit.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#154

Post by ttul »

jnsie wrote: post #74
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

You should turn this into a product (or open source it). I'd imagine this is a pain point for many, myself included.

Thanks for the feedback. I think I will just throw it up onto GitHub. It’s really a hastily thrown together dump of Python code. One of the ugliest things I ever produced from my keyboard.

Then again, it does work.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#155

Post by ttul »

ChikkaChiChi wrote: post #59
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

Are you triggering on email received? I'd love to see how you went about this so I can solve some of my own headaches!

No, the script just runs a Gmail search and iterates over the results. The workflow is as follows:

1. Send statement items to GPT to generate search queries for Gmail. (basically company names like “Adobe”)

2. Search Gmail using these queries and some search modifiers that are likely to winnow down the messages to those likely to contain invoices.

3. Send a snippet of the message to GPT and ask it whether the message seems like it might contain an invoice.

4. If so, parse the message and save any attachments or render the HTML body as a PDF and save that. Also grok the message for currency amounts so I can put the likely invoice total in the file name (this helps the accountants).

That’s the flow. GPT helped me write it all, of course.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#156

Post by ttul »

q7xvh97o2pDhNrh wrote: post #62
ttul wrote: post #33

I used it to transform cryptic credit card statement items into company names, which then allowed me to query my Gmail archives for receipts and invoices from these vendors, automating a manual process of accounting backup discovery that is the bane of my very existence. I even got GPT-4 to assess whether an email likely relates to an invoice or payment so that I could limit the amount of noise extracted from my emai…

I keep seeing anecdotes like this, and I wonder: How do you feel about the privacy aspect of this? To do this, you had to feed your email into GPT-4, right?

I’m only sending GPT message snippets, which Gmail’s API make available - probably using a language model (LoL). So there is very little PII in the API calls to GPT. That being said, I think OpenAI has a very large incentive to carefully destroy any query data sent through its APIs. The last thing they need is for some employee to quit and spill the beans about how Sam Altman stays up late at night laughing at all the API calls revealing the trivial problems of humans with an IQ of less than 140.

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#157

Post by qup »

tharkun__ wrote: post #132
s3p wrote: post #103

Earlier quoted context omitted.

200 lines @ 40 tokens per line equates to 8,000 tokens. That costs $1.60. for one query.

Someone making $100 per hour would be able to analyze those 200 logs for about 7 minutes for that cost. That's a person you pay over 200k of salary. I analyze logs at work all the time and I analyze way more than 200 lines and it takes way less than 7 minutes to analyze those 200 lines. Somehow I don't think it would be more cost effective to have an intern paste those into ChatGPT over and over and blow through a to…

$100 / hour = $1.67 per minute

7 minutes = $11.69

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#159

Post by bolanyo »

femto113 wrote: post #77
bolanyo wrote: post #45

Earlier quoted context omitted.

Parsley in carbonara?

I wouldn't put it in carbonara, but Marcella Hazan's recipe[1] includes it and she's about as big of a "pasta sauce authority figure" as you're likely to find. [1] https://www.latimes.com/recipe/marcella-hazans-spaghetti-car...

Why not just Google 'Marcella Hazan carbonara'? When I want a recipe I usually Google 'bbc food carbonara' - I want the site I trust rather than the one which has won the SEO race. I also might try "Carluccio carbonara" for the UK authority on pasta sauce.

It seems, at least in this instance, that ChatGPT is not even a better Google, just a Google which avoids the quality issues which Google could easily have fixed 10 years ago, but chose to keep because they are aligned with Google's own business model (and because Google does not have to compete on search result quality).

Re: Tell HN: ChatGPT is fantastic for finding and solving issues in logs

#160

Post by bolanyo »

inanutshellus wrote: post #76
bolanyo wrote: post #36

Earlier quoted context omitted.

I do have children. The thing is that I know what my children like to eat and don't like to eat, but ChatGPT does not. If I had to direct, say, a human servant who is very good at cooking, but who doesn't know my kids, to plan meals for my family, I would suggest 4-6 meals that we eat frequently, 7-10 that we eat a bit less frequently, and then maybe mention a couple of things that my kids don't like. And specific di…

We tried it to get meal ideas and help manage a new diet with restrictions on calories/fat/protein. Measuring each across meals and snacks each day and verifying each ingredient is time-consuming.

So it's a decent replacement for .. those free magazines that you get at the supermarket?
Post reply on HN