Recording data to call upon again.

[ReconX]

I have a small program I am working on to store physical copy blu-rays in a database. What happens so far is that you input, "Name" and "Year", press a button, and it creates a file in the format of "Name (Year).mkv". These files are stored in a folder that my Plex server can see, and that creates a list in Plex of the copies that I have. But, I also want to add "UPC" to that information without affecting the filename. I have a listview that sees the folder, and displays it in the GUI. 

Would it be best for me to record this data in a txt file in the format of; "Name|Year|UPC", and have the listview call the information that way? How do I update the txt file if I delete or change a file? 

I'm not looking for anyone to write and provide me the code I need, I just want to be pointed in the correct direction.

[Danp2]

UPC as in Universal Product Code? Can you share why you would need that information?

As far as where to place it, how about in the file itself? Looks like the file spec supports tags and comments.

[ReconX]

2 minutes ago, Danp2 said:

UPC as in Universal Product Code? Can you share why you would need that information?

As far as where to place it, how about in the file itself? Looks like the file spec supports tags and comments.

Yes, Universal Product Code. I want to store this information so that I can revisit it later. Some movies have many variations of releases such as the movie, "Uncle Buck". It comes in a single release blu-ray, but also as a double feature including "Fletch". 

[JockoDundee]

42 minutes ago, ReconX said:

I want to store this information so that I can revisit it later.

But if you can scan the UPC can’t you skip the data entry of the title/year altogether?

[ReconX]

25 minutes ago, JockoDundee said:

But if you can scan the UPC can’t you skip the data entry of the title/year altogether?

Plex unfortunately doesn't pick up UPC codes. My initial plan was to just input the UPC code and have the other information generated from a source. bluray.com has the feature where I can type in the UPC code and it finds the exact copy that I have. But, wouldn't bluray.com need an API for me to get that information? 

Uncle Buck \ Fletch - UPC = 025192193392

[Danp2]

1 hour ago, ReconX said:

But, wouldn't bluray.com need an API for me to get that information? 

You could screen scrape it with the built-in IE commands or with Webdriver.There's also this --

https://www.barcodespider.com/025192193392

and they offer an API, but it's not free.

[jchd]

For storage and flexible querying of such data, I'd recommend looking at SQLite. See help. There's a small learning curve but it's worth the burden in many, many cases.