I have a MASSIVE database of uncategorized Private Label Products. I am talking about THOUSANDS! These files and folders are in alphabetical order. So it is a massive pain to attempt to sort them into topic/Niche collections. I have gone the route of trying different software, but none are doing what I need. I still need to manually sit and sort through it all. I need to build an app that can sort through all these files and folders, and then group them without me having to sit here and monitor the process.
I have no coding or programming experience, so I don’t even know if what I’m looking for is even possible. Any suggestions would be welcome.
Not sure if I’m giving the right response but in the product title is there a category each of them belong to? Like on the title if it’s like
Product name - engine
Product name 2 - alternator
Product name 3 - engine
And you want to categorize by the parts then we can make an if then else.
But for best understanding can you show a photo of how the data currently looks like and how you want it to look like
Another thing is to create an app that reads through the files and is able to determine what category they belong to. I think n8n can work it would cost you but it’s cheaper than make.
So the idea is to get a file send it through a sequence eventually we get chatGPT to read through the file and get the category then we send it (the file) to sheets and assign a category.
It would be way more complex than this but you get the idea.
Ok, so as shown on the inclosed pic, these are actual folders that need to be arranged. this is not even 0.001% of the list of folders. I dont want to sort the files in these folders, as each folder contains different media that all make up the product.
This is the issue with available apps, they sort the files, thus destroying the database, as it seperates doc from pdf, mp3 from mp4 etc…
Here’s my idea… it seems to sort them by category we could either take the file name or a content inside the file (not disorganing) like an image we send this to GPT then it reads the content and along with our list of category it assigns a category then moves the whole folder to that category.
Scenario:
Upload the files to a folder in drive - create a way for get the function I mentioned - move the file to a new main folder category (and also add the category name to the files(folders) )
End result: all media remains intact, and files remain untouched (just edit the names) and get moved to a category.
Easier said than done this would be crazy to pull of and some of what I said might have a different situation you’d have to work on.
Of course we’ll be using n8n, open ai, and Google drive as our storage unless you have one… depending on the total size you’ll have to upgrade to a workspace.
Someone could come up with a better solution but I work with n8n it just seems easier… haha.
Are you actually expecting a web based app to reach into your PC’s file system and rearrange files/folders (not going to happen)? Or do you have a spreadsheet or database of files/folders and you want Glide to organize it in a way that you can then use that result as a guideline for some other process to move around your files/folders on your PC?
I feel like you are looking for something like a Powershell script to actually work with your file system. Not a web based app.
I think you need to first clarify how you are expecting a web based Glide app to play a role in organizing files/folders on your physical PC.
Then, like others have pointed out, you need to specify what your criteria is to place a particular folder into a particular topic. That part is still unclear. Is it something AI should determine? Is it based on certain words in the folder name? Is it something based on the files inside the folder? Is it something else? How do you define a topic, and what determines if a folder fits in that topic?
From my viewpoint, If I were to build something on my PC to organize files/folders, I would definitely be using Powershell. Problem is, and like others have pointed out, you haven’t really specified the criteria to define a topic yet, so it’s unknown how it should work. ChatGPT and others are fantastic tool for building Powershell scripts that do all kinds of things. You just need to tell it what you need and how it should work. Get a script and run it against a small subset of files to test it.
If I’m making the correct assumptions, Glide may not be the tool for you. If I’m wrong, then we’ll need a lot more information about what you are trying to do.
