Newbies Pierre-Hugues Posted July 2, 2014 Newbies Share Posted July 2, 2014 I am a regular user of FileMaker. However in my job I currently need to build a database of a few thousand invoices from different firms plus additional invoices. My situation to insure the quality of my work I need to write in File maker what is each invoice but I also need to keep a copy of the invoice as a picture. ATM I use drag and drop. So far everything is good. The problem is that I want to create some safety feature that will keep 2-3 copies at all time in case the database would become corrupt. Still no problem EXCEPT the SIZE of 2000-3000 and growing pictures of invoices. So here is my question. I know it is possible to script the pictures so you can save them some where with the # ex:# record-NAME-A (A-B-C-D depending on the amount of pages for the invoice), however I can't find a way to automatically linking them without them staying as part of FileMaker. So what I would like is that if I go get my record 1, Filemake go get my picture 1-name-A and post them in my template at the A spot WITHOUT leaving it there after I left this record. Thanks you for your assistance. Pierre-Hugues Link to comment Share on other sites More sharing options...
Brooks Posted July 4, 2014 Share Posted July 4, 2014 I'm not following your explanation, but a few thousand pictures is not that large if you keep the sizes in check. Use the get thumbnail step to resize them to 2000 x 2000 then keep daily backups of your filemaker solution. Then use a 3rd party backup to keep a copy of your backup ( not your live file! ) everything will then Be redundant 2 levels deep. Link to comment Share on other sites More sharing options...
Newbies Pierre-Hugues Posted July 4, 2014 Author Newbies Share Posted July 4, 2014 ok I understand. the problem is I will start with around 2.5 thousand and should increase by 30 a week... What I want is to able to "LINK" the pictures from a specific folder on my computer rather then to have them in the FileMaker itself. Sadly for the file size since they are invoices pictures, I need to be able to read them. Link to comment Share on other sites More sharing options...
Brooks Posted July 4, 2014 Share Posted July 4, 2014 You just need to use external container storage then. http://help.filemaker.com/app/answers/detail/a_id/10244/~/storing-container-field-data-externally Link to comment Share on other sites More sharing options...
Newbies Pierre-Hugues Posted July 4, 2014 Author Newbies Share Posted July 4, 2014 I think this might be very helpful Thank you for the help and happy 4th of July Link to comment Share on other sites More sharing options...
bruceR Posted July 4, 2014 Share Posted July 4, 2014 I take it this is NOT a multi-user system? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3584 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now