Jump to content
Sign in to follow this  
Answers

fmp17 Filemaker interacting with Photo Software

Recommended Posts

I have a customer that has 3TB of photos in the program Picasa. They use it to edit images and then put some in Filemaker. Currently the images are on a NAS. The problem is it seems to be getting slower and slower. Picasa is discounted so I'm looking for a replacement that can handle the large amount of images they take on the job site and interact with Filemaker, seamlessly. they run on a windows platform but would like to perhaps introduce iPads to the mix in the future.

Not sure if this is the right place to post this question but I thought I'd give it a go.

Any guidance on the matter would be greatly appreciated. 

Edited by Answers

Share this post


Link to post
Share on other sites

What is getting slow? FileMaker? Picasa? Editing? NAS?

There are plenty of apps out there (ie Photoshop, The Gimp, Affinity Photo, ...) that can do all the editing you want. But without knowing what sort of editing is done (light edit I would assume considering Picasa was good enough), it's hard to make a recommendation.

How would the editing software need to interact with FileMaker? Or are they just taking photos, cropping them and uploading some into FileMaker? That could easily be done using iPads, FileMaker can do that natively and store images in containers straight from the camera.

For just cropping and other light edits, Irfanview, XNView, Paint.net might be suitable.

 

Share this post


Link to post
Share on other sites

Thank you for replying to my topic. I got sidetracked with other issues. So whats getting slow is Picasa and the NAS. So we are looking for a central location for the photos, and that it's easy enough to edit (annotations, light edits)

And correct they are basically taking the edited photos to upload some into FileMaker. As simple a a drag and drop. The customer does fireplaces and chimneys so the images are used to guide the technicians and also for before and after history. 

On 11/15/2018 at 3:48 AM, OlgerDiekstra said:

What is getting slow? FileMaker? Picasa? Editing? NAS?

There are plenty of apps out there (ie Photoshop, The Gimp, Affinity Photo, ...) that can do all the editing you want. But without knowing what sort of editing is done (light edit I would assume considering Picasa was good enough), it's hard to make a recommendation.

How would the editing software need to interact with FileMaker? Or are they just taking photos, cropping them and uploading some into FileMaker? That could easily be done using iPads, FileMaker can do that natively and store images in containers straight from the camera.

For just cropping and other light edits, Irfanview, XNView, Paint.net might be suitable.

 

 

Share this post


Link to post
Share on other sites

For storage I would recommend a NAS vendor that has reasonable presence in your region. If available, Synology and Qnap are good choices. I have no experience with Qnap, but they use the same approach as Synology. With Synology, and similar NAS vendors, you have a ton of options and apps you can run on the NAS. I have a pair of Synology NAS's here (2 NAS's with each 55TB and each NAS 2 shelves of 22 disks). We collect some 15TB annually in photos (we're a photography company). When a customer purchases images, those images are relocated in a separate folder on the NAS which is backed up to the other NAS, and from there backed up to an AWS S3 bucket for off-site backup. All this is automated and requires only occasional checks to ensure everything is working. Frees my time up for other things, such as FileMaker development.

We also use offshore editors for some of our editing and images that need to be edited are copied to a separate folder on the NAS, which is linked to a dropbox account to which the offshore editors have access. Our internal editors can manage that all themselves. Images are returned the same way which creates a nice workflow that I don't have to be part of.

The above is just to illustrate how a good NAS can be beneficial to business workflows.

image.png.edda2195456073a38ddc3fcd9bf75b62.png

This is what the interface of a Synology NAS looks like. It's just like working on a desktop.

Synology's, Qnap's and the like come in various sizes, from single disk units to multi shelf rack units. If your customer decides to go with multiple physical NAS's then make sure you get different disk vendors in each NAS, ie WD in one and Hitachi in another (personally I stay clear of Seagate, we had a very bad experience with them).

These NAS's generally also come with multiple GB or 10GB ports so plenty of network throughput. Naturally, you also need good switching gear in order to get good performance to the desktop.

Our editors load up to 15 images (each 10-15MB) at a time into Photoshop from the NAS, which takes about a minute or so to load. That's acceptable for us. Depending on the size images you customer has, that is likely to be quicker.

For annotating/small edits, Paint.net is free and quite capable. If the work is really just cropping and annotating images, have a look at Greenshot, it's a screen capture  software but comes with an editor that allows you to do basic edits very easily.

As for images for before and after history, that's something that can easily be built in FM Go.

Hope that helps!

Edited by OlgerDiekstra

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By flutegirl
      To try to explain the setup as succinctly as possible:
      Database is running on a FM17 Server (on a Windows virtual(?) machine... Our IT department handles that part).
      The FM database does a number of imports every morning from our primary (4D) database, using an ODBC driver, but I have not found a way to have those imports run successfully from the server, so I have them running on an instance on a secondary user account on my desktop computer.
      The scripts are triggered by adding a record to a table, which is checked every five minutes using an OnTimer script.  I run a separate instance of FM17 on my user account so that I can use the database even if there is an import running.
      This solution has been working (fairly) well for a number of years, but last week, my desktop computer was updated to Mojave (10.14.6), and since that upgrade, it seems that the imports on the secondary account will only run while that user account is active.
      1) Is anyone else doing anything similar, where they have an instance of FM running on a separate user account?
      2) If so, have you had any trouble with Mojave, or have suggestions on what may be going on?
      3) Any suggestions on how to fix this?  My initial thought is to just open the database using FMP on the Server system and try having the imports run from there, but am concerned that might also have problems.
      Any suggestions would be greatly appreciated.
       
    • By OneStop
      I have a field called Price. I need to create another field called calculated price that will add a percentage depending on the value of the original Price field.
       
      Example:
      If the Price is $100.00 or more Subtract 10% from the price
      If the price is $10.00 or less Subtract .25%
      If the Price is between $10 and $50.00 Subtract .5%
      If the Price is between $50 and %100.00 Subtract .75%
       
      and so on and so on...
      So if I have a record with a Price of $1.00 the calculation will fill in the Calculated Price field with $.75
    • By BAleiHi
      I have a layout calculation that looks like:
      Round(If($$NoGPABump = 1;Classes::GPANoBump; Classes::GPABumped);2)
      In most instances, this rounds the appropriate value to 2 decimals  and displays those two digits.  But on occasion, it displays only one decimal as in this one:
      .  Instead I want to see 4.20.  If I round to, say, 4 decimals, it works properly: .  Rounding to 3 digits gives 4.199.  How do I get the trailing zero to show up?  This seems to be consistent for all data that rounds to a last digit of zero.  Is this a bug?  Is there a workaround?  Thanks,
       
    • By vinnygi
      I have a layout with a number of button bars, all with the same style. Each button is set to have an inner shadow and a white fill on Hover. For any of the buttons that call a popover, after the popover is closed, the hover shadow no longer works, but the fill still changes to white.  I've tried adding a refresh object script trigger when closing the popover, but that doesn't work.
      Some of the buttons are currently placeholders, which just call a script that exits itself so I can test the hover state.  Those work fine.
    • By Will_Logic
      Hi, I am using the Base Elements plugin Execute SQL command to select SQL on a table in another FileMaker file. For a file with many fields and quite a lot data in some fields, this times as about 1 minute just for SQL SELECT command for 1,000 rows. I haven't used MBS (monkeybread software) plugin yet, but I wonder if anyone knows if it is significantly faster?
      I.e. BE_FileMakerSQL vs. MBS(FM.SQL.Execute..) - is one significantly faster?
      Here's the code to select 1,000 rows for reference, $timer_seconds comes as about 60 seconds here. If I export same table internally in FileMaker using the menu export to Excel, it takes 29 minutes for all 41,000 rows, so timing seems similar for the Base Elements SQL. (NB there is some flag going on here in the FileMaker database so internal export gets 41,000 rows but script SQL SELECT COUNT(*) gets 200,000 rows for same table, but I don't think that is relevant to my question).
       
      Set Variable [$time1; Value: Get(CurrentTimeUTCMilliseconds)] Set Variable [$part_ca; Value: BE_FileMakerSQL ( "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; "&≠≠&" ; "EOR≠≠EOR" ; "DataContacts11" )] Set Variable [$timer_seconds; Value: (Get(CurrentTimeUTCMilliseconds) - $time1) / 1000] MBS command I think would be something like:
      MBS( "FM.SQL.Execute"; "DataContacts11"; "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; ...delimiters here I'm assuming.. ) We only have base FileMaker here on machine I am using, which can run the Base Elements plugin, but to run MBS plugin, needs FileMaker Pro Advanced to install it I think, am getting several databases in roughly same FM format where script workspace disabled, hence need to use SQL select run from script in my own external FileMaker file. Might consider getting FMP Pro Advanced if MBS is faster.
      Tx any suggestions!
  • Who Viewed the Topic

    6 members have viewed this topic:
    Ron Cates  Lou  Ocean West  BruceR  Fitch  Steve Martino 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.