AnsweredAssumed Answered

FileMaker "contained" File edit

Question asked by rbmn67 on Jul 1, 2013
Latest reply on Jul 1, 2013 by RubenVanDenBoogaard

Hi there,

 

I've have searched all discussions, and there does not seem to be a solution, not in discussions, nor in plug-ins.

 

Here's the case: One of my customers (FM Pro 12 Server, not advanced), has contracted me to re-engineer their administration. To advise them whether to develop all workflow supporting documents and forms in FileMaker, I am investigating possible solutions by integrating their current (mainly xls) files in a FileMaker solution.

 

Basic workflow will be:

  1. Creation:
    • Create xls from template, fill in default fields with FM data,
    • Create customer subject record,
    • Insert modified template into FM container field.
  2. Modify:
    • Read xls from container field,
    • Open in MS app (excel or word),
    • Modify content manually,
    • Save modified file, overwriting existing contained file.
  3. End process:
    • Read xls from container field,
    • Print xls pages/tabs to .pdf,
    • Replace contained xls with pdf.

 

One of the other requirements is secure, central storage. So far I have been looking at OLE discussions and 3d party FM plug-ins.

 

Anyone aware of a solution for the above scenario (besides exporting container contents to a temp path, with all the almost impossible "userproof" programming)?

 

Thanks in advance,

Ruud.

Outcomes