Search results

Hi @bastanu I've sent you a conversation mesaage, if you get some free time could you help me with an issue I had on this. Thanks Vlad.

Very in-depth explanation. Thanks Gemma. This will be my homework for the weekend. More than simply giving an organisation a product, I'm more so interested on a personal level to learn and improve my knowledge on databases and code. I've only been doing this for no more than 6 months, but the...

That's a good point. Thanks Arnel. Will update again tomorrow on my test. But things are promising. Thankyou.

Hi Arnel, I'm at home at the moment and testing it from some mock jpg and png files it seems to be working. When I head into work tomorrow to check on the TIF's, I'll see if all is good. So assuming all is well, is there a reason why: 'If Dict.Exists(MyFile.Path) = False And InStr(MyFile.Path...

Hi Arnel, it still isn't logging into "tblDirectoryExceptions". To test it out, all I did was import the directory fresh. It imports all the images metadata correctly into "tblDirectoryDefault". Then on one of the images, I rotated and saved it. Changing the last date modified,. Then re-run the...

Hi @arnelgp I ran some tests today. I deliberately manipulated an image so that the last date modified would change from the previous import, and then ran the import again. The import did not log the changed row into the "tblDirectoryExceptions". Just a thought, does the date/time format that...

Hmm, I guess I could, but how would I do that exactly? Is it like a yes/no column that gets unchecked?

Yep I will run some tests tomorrow morning and give @arnelgp the all clear when it all works. But you're completely on point Gemma. I will express this concern to my organisation. I also agree with you that we should only be processing the newest or highest version of a file. Sorry I didn't...

Thanks so much Arnel, I will run some tests throughout the day to see its functionality and report right back to you. Thanks for this!

Yeah Gemma you're making a lot of sense. I was instructed that only the supervisor of the project and the editor were going to be reviewing this database. So that's why I was trying to figure out how they could know if the change being made is required or not. To give you more context, I have...

Yeah I understand that @Pat Hartman so here is how things are working at the moment. So there will be some photoshop work done on the images. The person doing the edit work will quality check if the original image is good or not first of all. If the image wasn't camera captured correctly, then...

Sorry I should have clarified this before. So the files I want to import are either TIF's or JPEG's. The reason I wanted the second table was so that if the date modified had been changed (from the 1st import), I could see that and investigate the actual image in it's folder and the person who...

Sorry all for the late replies, I had some issues with internet last week. But I'm back now properly. Thanks for your responses. In regards to your replies @Pat Hartman & @gemma-the-husky my idea was that I wanted whoever ran the db to see all the files in a table and track the changes to the...

Ahhh! Yep that makes sense. I'll try to workout how to flag it and get back to you. Thanks Arnel.

My apologies What defines a new file? A unique file name? When the targeted folder location has a new file in it. So when I run the sub in my db, it will add a record into the table with the metadata for it. e.g. C:\Users\%USERNAME%\Documents had 8 unique files in it on Monday. Then when I ran...

@theDBguy so like add all the records and then have a FileDateTime to compare if the last modified date has changed? @arnelgp So with: If Nz(DLookup("FDateLastModified", mysql, "FPath = '" & MyFile.Path & "'"), #1/1/1890#) < MyFile.DateLastModified Then Does this add the record into the...

Hi all. I have a database that retrieves the metadata properties of a file: Path, Name, Size, Owner, Date Created, Date Last Modified, Date Last Accessed, Type. Now I'll be getting people to run imports on a directory every morning. The idea of that is to: 1) Import new files into the...

Thanks for the responses guys. Cheers for the code Arnel, that worked like a charm!

Hi all, I've got some code here for File Listing. Which will go into "tblMetadata". Now I've been trying to figure out how to incorporate the File Owner data into this, but a little stuck. After some browsing, I realized there are slightly different ways to do it. But not sure how to make any of...

Hey Vlad, Thanks this is working now. Just tested it on my end and all is working out great as I required. Cheers for that. And yes the Location_Copy and Location_Move are in different locations. So shouldn't be an issue. Thankyou!