kenuk110
asked on
Create D/B records that are entered from files saved in directories
Hi,
I have files which are delivered through DropBox to my file server, what I'd like to do it when a file is 'dropped', something scans the directories, finds the latest saved file, enters a record in the DB which points to this file.
Is this possible? The naming convention of all the files is the same so the format won't change, the directory it resides in though is the differentiator.
So, the filename is like this:
IMG00001-201109024-1441.jp
the length of each part won't change, so the first part IMG00001 will always be IMG003432 for example, the format will never change.
The directories are similar:
\\photos\02\006-S\AA12
the second and third part of the structure will never change from a 2 digit/5 digit structure, the last part could be 2-4 alphanumerics.
I know this is probably impossible but thought I'd ask the question anyway!!
Any help would be much appreciated.
Regards,
Ken
I have files which are delivered through DropBox to my file server, what I'd like to do it when a file is 'dropped', something scans the directories, finds the latest saved file, enters a record in the DB which points to this file.
Is this possible? The naming convention of all the files is the same so the format won't change, the directory it resides in though is the differentiator.
So, the filename is like this:
IMG00001-201109024-1441.jp
the length of each part won't change, so the first part IMG00001 will always be IMG003432 for example, the format will never change.
The directories are similar:
\\photos\02\006-S\AA12
the second and third part of the structure will never change from a 2 digit/5 digit structure, the last part could be 2-4 alphanumerics.
I know this is probably impossible but thought I'd ask the question anyway!!
Any help would be much appreciated.
Regards,
Ken
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you nrbreen!
Let me try this on my system, I really appreciate it, I'm not a programmer and haven't also used VB, the limited stuff I have done has been on C Sharp but let me change the parts you have suggested.
Really appreciate it.
Cheers,
Ken
Let me try this on my system, I really appreciate it, I'm not a programmer and haven't also used VB, the limited stuff I have done has been on C Sharp but let me change the parts you have suggested.
Really appreciate it.
Cheers,
Ken
ASKER
Hi nrbreen,
Right, I have gone through the file, it all came in in one long string so I had to press enter a load of times, hence taking a little time to get back to you!
It all seems to be trying to do what it should but I have an issue where it requires the username and password for our SQL Server. Is there a way to add this information to the connection string as the message I get back is:
Login failed for user''.
Any ideas?
Right, I have gone through the file, it all came in in one long string so I had to press enter a load of times, hence taking a little time to get back to you!
It all seems to be trying to do what it should but I have an issue where it requires the username and password for our SQL Server. Is there a way to add this information to the connection string as the message I get back is:
Login failed for user''.
Any ideas?
ASKER
Hi again,
It works!!! I found the additional info on the net so added it and it works like a dream!
I really appreciate your help on this.
Best Regards,
Ken
It works!!! I found the additional info on the net so added it and it works like a dream!
I really appreciate your help on this.
Best Regards,
Ken
what approx number of folders and files need to be catered for?