Jump to content

Importing multiple photos with SuperContainer...linking to previously created records


 Share

This topic is 2581 days old. Please don't post here. Open a new topic instead.

Recommended Posts

So I am somewhat new to SuperContainer and to designing layouts in FileMaker.  I have a database for a film I am working on and in the database is a record for every clip we have in the movie.  We also have an image that matches the data for every clip that is in the movie.  What I would like to do is be able to batch import all of the photos (using the batch import option in the Super Container Sample) and link all of the files from that batch import to the web viewers I have setup in my film database.  I have toyed around with the address in web viewer, however since every record is a different filename I am getting confused how to link it to the batched photos I brought in with SuperContainer.  Is there an easy way to do this, so if I create new records in my film database and then subsequently batch import their matching photos, things will automatically link up?  I want to be able to use SuperContainer to speed up my database.  I am excited at the prospect of this product, just don't really understand how it works yet.  Any help would be greatly appreciated.

Link to comment
Share on other sites

The batch import script in the SuperContainer Example file creates records in the FileMaker demo database and adds files to SuperContainer. Since you already have records in your database, this example script may not be what you are looking for. If you aren't very familiar with FileMaker layouts and scripting, it may be more less time consuming in the end for you to just use the drag-and-drop feature of SuperContainer and add your images one by one.

 

I have some questions that may help me make a better suggestion:

- Which version of FileMaker are using, and are you using it with a server (and which version)?

- How are you looking to speed up your database? Is something performing slowly now, or are you looking to add information more rapidly?

- How many clip records currently exist that you need to add images to?

Link to comment
Share on other sites

Jayivan,

Thanks for replying.

 

- Which version of FileMaker are using, and are you using it with a server (and which version)?

I am using Filemaker 13 Advanced to design my database and I am hosting it on Filemaker Server 13.

 

- How are you looking to speed up your database? Is something performing slowly now, or are you looking to add information more rapidly?

I have previously just used a seperate photo database to link to container fields in my main database.  I try to use small images but with thousands of records and intermitent internet speeds depending on where I am working, the main database gets bogged down by trying to access these pictures.  I can continue to use this method, but read about supercontainer and thought it would be a better option for accessing this data over the internet.

 

- How many clip records currently exist that you need to add images to?

I am well into the thousands which is why drag and drop really isn't an option.

 

The records I have in my database are imported from a tab delimited file and I can reimport if need be.  I am recreating a database from the ground up so this is not an issue where I am concerned about migrating my infromation.  The thing that confuses me is the file structure SuperContainer creates.  If I could somehow make the Web Viewer address access the original file name, I could create a link between the filename (which is basically the clip name) and file itself.  That is what I am struggling with.  Hopefully that gives you more information into what I am looking to do.  Thanks in advance.

Link to comment
Share on other sites

From a FileMaker perspective, SuperContainer is essentially a mini-web server, and it is displaying the contents of a single folder. There is always one file in that folder. The name of the image/pdf/document within that folder is inconsequential. The URL within the web viewer on your layout is the path to the folder.

 

So the important part is to be able to connect some information within the filemaker table to the folder structure in SuperContainer. That path needs to be unique for each record, so for the path, I use the table name and a unique field value. For example, in a catalog, the Web Viewer path is:

"http://" & Get (HostIPAddress) & ":8020/SuperContainer/Files/CATALOG/" & CATALOG::ID

 

You could also use a text field, so long as you could be certain that text field would be unique. So in your case:

"http://" & Get (HostIPAddress) & ":8020/SuperContainer/Files/CLIPS/" & CLIPS::UNIQUECLIPNAMETEXT

 

 While the SuperContainer batch script example may not be the solution, you could automate the process depending on a few factors.

 

I suspect you could script the catalog building process, if let's say all your filenames did match a name in the clip record and all images were in a single folder: import the tab delimited file into an import table; then build the catalog by having a script go through each line of the import table to create the catalog record, search the image folder for a matching image name, and then use the SuperContainer plugin to import the image into the SuperContainer directory. Can't say specifically what the solution would be without getting many more details about your setup. 

 

Hope this helps.

 

360Works support is also an extremely helpful crew. I've found they are willing to make a little effort to help you be successful in using their products.

 

The new externally-stored container options in FileMaker Pro 13 could also improve performance. You wouldn't bloat your database or backup directory with a large database file, though I can't speak to how FileMaker's thumbnail display performance would compare to the performance of the SuperContainer web viewer. I use both solutions in different contexts.

Link to comment
Share on other sites

This topic is 2581 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By dataclip
      We have a webdirect app for customers. They can logon and see their account information. As part of this solution I use supercontainer to show customer files, for example pdf invoices.
      Recently we upgaded from FMS13 to FMS16. I reinstalled supercontainer. However ,after the update the files no longer show in the app.
      for example: https://ipaddress/SuperContainer/Files/528CD212-1951-D44C-AFEB-302ECE376F91/1018-1192-17664_0.pdf
      I see a message no file choosen.
      The folder and file do exist inside the Supercontainer fodler.
      Any ideas why the file is not displayed??
       
      Joost Kingma
    • By Aad V
      We have deployed SuperContainer in a large corporate set up. Upon upload, no problems for anyone. 
      Upon download some users (only!) are experiencing that the filename changes to a number (the number of the folder that SuperContainer stores the file in). How can I rectify that so that the file keeps it actual filename?
    • By Keawe
      Hello,
      I installed supercontainer on my Windows server at aws Amazon. I also installed the companion plug-in. It shows up on Filemaker Pro no problem. But it doesn't show on webdirect. Any idea?
      Here is my configuration:
      - FMS 15, Windows 2016 server. 
      - SuperContainer 2.94, build 9234.
      - I have the companion plugin put inside "..\FileMaker Server\Web Publishing\publishing-engine\cwpc\Plugins".
      - The plug-in I use is "SuperContainer_Companion_Plugin.fmx64".
      Thanks.
      P.S.: I will send an email to 360works. But just want to post it here so we can all share the solution. Thanks.
    • By drrehak
      greetings all!  A question for the network security gurus: I have Supercontainer running in standalone mode.  My router has port forwarding to the machine (Mac-mini).  My credit card vendor requires security IP address scans and I am failing due to the port forwarding on the router.  what is best practice?  I am using a router flashed with Tomato Shibby.
    • By kathylin
      I can install SuperContainer 2.93 for my FM Server 14 running on OSX Mavericks, and got it running fine. However I am not sure how to install the Companion Plugin.
      I copied the SuperContainer Companion Plugin 2.93 into different folders
      /Library/Filemaker Server/Web Publishing/publishing-engine/cwpc/Plugins /Library/Filemaker Server/Web Publishing/publishing-engine/wpc/Plugins /Library/Filemaker Server/Database Server/Extensions but I still get an error message when I start the SuperContainer Example.fmp12 file saying that the SuperContainer Companion plugin is not installed.
      I did restart FM. Tried rebooting the osx machine, and restarted FM Server and SuperContainer. Would appreciate some help!!
  • Who Viewed the Topic

    6 members have viewed this topic:
    Matt.C  comment  Laura Griffin Long  Stefano Parmeggiani  doughemi  Ocean West 
×
×
  • Create New...

Important Information

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