Author: Teruhiro Komaki

/ Teruhiro Komaki / 3 Comments

Published fmSimpleCalendar to Github

published-fmsimplecalendar-to-github-1

Here is the overview

fmSimpleCalendar ( Calendar solution for FileMaker developers )

Explanation

Please wait for a while as we have prepared an explanation article of the solution.

click here to download

Please clone.

We will update README.md later.

https://github.com/frudens/fmsimplecalendar

Operation check

Since I have not confirmed the operation, please understand.

About FullCalendar version

This time, I use FullCalendar Ver3 for the file which I made public.

Because Ver3 depends on jQuery, coding is difficult, but Ver4 is easy to code.

Therefore, in the future I would like to update using Ver4.

If there are people who will fix it, I’d love to hear from you.

I hope to be able to update it together.

Continue reading →

/ Teruhiro Komaki

goFMDataMigration (CLI tool for easy execution of FMDataMigration) has been released

Hello.
I am Teruhiro Komaki of frudens Inc.

When developing FileMaker, I think it is common to prepare the development environment separately from the production environment.

Also, after releasing the initial version of the system, the developer will modify the development environment and release it to the production environment at an arbitrary timing.

Therefore, when releasing, it is necessary to migrate the data in the production environment to the Clone file of the development environment (Data Migration).

About DataMigration

In the past, it is probable that many developers themselves create data migration tools themselves, rehearse in advance, and do release work.

Or you may be using RefreshFM etc.

However, as you can see in this title, I think that there are more cases to use the CLI tool FMDataMigration from now on.

About FMDataMigration

FMDataMigration is a CLI tool available when subscribing to FileMaker Developer Subscription (FDS).

For details, it is good to look at the link below.

FileMaker Developer Subscription
https://store.filemaker.com/product/FDS

Introducing FileMaker 17’s FMDataMigration Command Line Tool
https://www.soliantconsulting.com/blog/fmdatamigration-command-line-tool

FileMaker Data Migration Tool Guide
https://fmhelp.filemaker.com/docs/edition/en/migration/index.html

Continue reading →

/ Teruhiro Komaki

Published fmOAuth(v0.0.4) to Github

Hello.
I am Teruhiro Komaki of frudens Inc.

As stated in the title, we released fmOAuth to GitHub.

This time I will write about the announcement and “why did it published to GitHub?”

Announcement

Please download from the link below.

https://github.com/frudens/fmoauth

Please see the image below for usage.

If you have any requests or questions, please feel free to contact us at Gitter!

https://gitter.im/frudens-com/fmoauth

Wish

I am glad that you can tell me when you use it.

Why did it publish to GitHub?

Simply put, I decided that it is better not to call the API from FileMaker, which is no longer necessary for me.

And it is unnecessary to me, but I thought that it might be useful for someone.

Why has it become unnecessary for me …

That’s because it began to develop with Golang.

People who can develop not only in Golang but also in Python, Javascript, PHP, etc, I think that I think the same way as I do.

Also, since there are convenient libraries and packages in any language, compared with FileMaker, it can be developed quite efficiently.

As FileMaker developers also learn general programming languages, the possibility of problem solving will expand, so it is recommended!

It is an image like the following.

Call API directly from FileMaker

published-fmoauth-to-github-1

Call the API via GAE/Go

published-fmoauth-to-github-2

Continue reading →

/ Teruhiro Komaki

tried the FileMaker 17 Data API from the terminal

Hello.
I am Teruhiro Komaki of frudens Inc.

The other day, FileMaker 17 has been released, the neighborhood is very exciting.
Many developers write articles related to 17.
Therefore, I will write about FileMaker 17 Data API with less information this time.

As the title suggests, I use a terminal but I try to use it with Copy, so feel free to try it.

First of all, about the document.

About the FileMaker Data API

The FileMaker Data API was available from 16, but it was a trial period.
The trial period ended at 17 and it was officially released.

If you have time, please see the help.

FileMaker 16 Data API
https://fmhelp.filemaker.com/docs/16/en/restapi/

FileMaker 17 Data API
https://fmhelp.filemaker.com/docs/17/en/dataapi/

About FileMaker Data API Reference

After installing FileMaker Server, you can see the reference at the following URL.

https://your-domain.com/fmi/data/apidoc/

If you look at help it is properly written, so let’s see.

When you installed FileMaker Server, you installed the FileMaker Data API reference files. This reference provides detailed information about all of the calls supported by the FileMaker Data API.

Note:To view the reference information, check that FileMaker Data API access has been enabled in Admin Console. See FileMaker Server Help.

  • To view the reference in a browser window on the master machine, enter the URLhttps://localhost/fmi/data/apidoc/
  • To view the reference in a browser window on a remote machine, enter the URLhttps://host/fmi/data/apidoc/where host is the IP address or host name of the master machine running FileMaker Server.
  • On a Windows server, the reference files are in the folder
    [drive]:\Program Files\FileMaker\FileMaker Server\Documentation\Data API Documentationwhere [drive] is the drive on which your FileMaker Server deployment resides.If you install using a non-default location on Windows, your installation location replaces the beginning of the default installation path[drive]:[installation_location]\FileMaker\FileMaker Server\Documentation\Data API Documentation
  • On a macOS server, the reference files are in the folder/Library/FileMaker Server/Documentation/Data API Documentation

Notes

The reference files show variables in the URLs by using a keyword preceded by a colon (:). For example: :database
This guide shows variables in the URLs by using an italic font. For example: database-name

Environment

macOS High Sierra (10.13.4)
curl 7.54.0
jq 1.5 (Please install with brew!)

For windows, please do it with cygwin etc.
If I have time, I’ll try to verify.

Continue reading →

/ Teruhiro Komaki

implemented “HTML mail” and “attached file” transmission from FileMaker using the Gmail API

Hello.
I am Teruhiro Komaki of frudens Inc.

I recently started using Vim.
I try to live with Terminal.app as much as possible, not as a GUI application.

I am used to living with terminals as the main, and I gradually delete GUI applications that are no longer needed.

Although it may be serious at first, I am comfortable when I get used to it, so I recommend you to everyone!
First of all let’s get used to package management at brew while tmux, screen etc …

Since I write blogs such as “Recommended command!” If you can afford it!

—

I was developing fmOAuth and wanted to cover most of what I can do with the Gmail API.

And I tried implementing HTML mail sending and sending mail with attached file etc.

I tried sending “HTML mail” and “attached file” using Gmail API from FileMaker

I think we can implement it in the next version of fmOAuth!
Also, we are thinking about deploying to another product using the function here.
(I do not know yet, but …)

Afterword

Since fmOAuth is implemented with “insert from URL” only, plugins etc are not used.
The API is really wonderful!

If you have trouble with API cooperation, please contact us!