9/4/24

How ChatGPT Recommended Colab to Solve .PCAP to .CSV Problem

So I was trying to create an AI GPT bot that could take a Wireshark .PCAP "packet capture" file and help an IT engineer analyze the problem at hand that caused the engineer to run the packet capture in the first place.

I was engaged in a chat on the subject with OpenAI's ChatGPT winch you can review at this link, but as you can see from the first half of the chat, I was under the general impression that I could upload the Wireshark .PCAP file into an OpenAI custom GPT I was trying to build when it suddenly dawned on me that ChatGPT was trying to explain to me that ChatGPT can't read a .PCAP directly and the .PCAP needed to be converted to .CSV first since AIs generally only read TEXT based files & .CSV is a text based file.

I then queried "How do I convert .PCAP to .CSV" after learning that ChatGPT could also not do that for me as part of the custom GPT I was trying to build and that I could do it for free by just installing some program on my desktop computer called "Scapy" and maybe a couple other similar programs so I can fun "Python" and create my own .PCAP to .CSV desktop PC based file converter.

In trying to follow all this free advice I then discovered that the laptop I was using from my client was quite locked down and did not allow me to install downloaded computer programs all willy nilly and I was pretty sure I didn't want to put in a trouble ticket to have them install Scapy for me after I explained to them what I was doing & why I needed Scapy.

That's when the "magic AI moment" happened when I asked ChatGPT, "Can't his sort of stuff be done in the cloud?" to which ChatGPT replied, "Of course, just use Google's Colab!" (Like everyone's supposed to know that, right?!)


The alt text accurately describes the image's content, focusing on the core message of the blog post (using Colab as a solution for library installation issues). It also provides context for visually impaired users who rely on screen readers.
Documentation of one of Dan's many AI "Ah Ha" Moments! See the whole chat at https://chatgpt.com/share/42a76dc3-d6c5-4af5-9907-adc62ad10929

Ten minutes later I had created a free Google Colab account and was testing Python code supplied to me by ChatGPT in response to, "I don't know anything about Python, can you just give me whatever Python code I need to convert a .PCAP file to a .CSV file?

The Moral to This Story?

The magic of AI means you really don't need to know anything about solving a technology problem other than steps number one & four of the AI: bot building process which are: 1) What is your starter prompt & file? (in this case a .PCAP file) and, 4) What do you want to get out of the bot? (a .CSV file that exactly replicates the original .PCAP).

If all you know is what you're starting with & what you want to get at the end, the different AI platforms will explain everything you need to supply for steps two and three - which are what "knowledge documents" do you need and what "special instructions" need to be considered in addition to the original user prompt.


No comments:

Post a Comment

The AI Gold Rush: Why IT Network Engineers Can't Afford to Miss It

The WSJ reveals the massive AI investments shaping the future of IT - and your career. Click the following link to read the 9/5/24 Wall Stre...