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 →

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 →

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 →

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!

fmSimpleCalendar is likely to be released

Hello.
I am Teruhiro Komaki of frudens Inc.

As I mentioned earlier, I am developing a solution fmSimpleCalendar as the title suggests., It had been announced previously, but has developed a solution that as the title fmSimpleCalendar .

It is likely to be released as it has finally become a form., It is likely to be released because we have more and more in the form.

Introduction of fmSimpleCalendar

Drag and drop

Switch display

Continue reading →

fmOAuth v0.0.3 has been released

Hello.
I am Teruhiro Komaki of frudens Inc.

fmOAuth v0.0.3 has been released.

Please check the Release Notes for detail.

As a result of updating the client ID of fmOAuth, selecting “Use fmOAuth” in v0.0.2 or earlier sample file results in an error.

Regarding updating the client ID, you can dynamically manage files by placing files on S3 etc, always downloading the latest files …

This time, we have not fixed it.

Also, as I received an inquiry that “fmoauth.fmp 12 is hosted on the server, I can not cooperate well,” I confirmed it.
In my environment, I could confirm that I can cooperate.

In the next version upgrade, I would like to cover all Gmail APIs.
You can also send HTML mails.

Please look at the sample file and ask questions if there are unknown points such as scripts.

If you have an API etc. that you would like to collaborate, I hope that you can request.

To developers who used fmOAuth

Thank you for always using it.
If possible, it would be greatly appreciated if you could give us your impressions (both good and bad).

Nice to meet you.

2 Comments

developing fmSimpleCalendar

Hello.
I am Teruhiro Komaki of frudens Inc.

I am developing the solution called fmSimpleCalendar although it is as the title.

It is a solution using FullCalendar you all know.

It’s a man like this.

developing-fmsimplecalendar1

As the name suggests, I will try to make it easier to understand by looking at the file without complicated things.
It is the general purpose developer to customize it and incorporate it into your custom app.

I am releasing it as soon as it is under development.

fmOAuth v0.0.2 has been released

Hello.
I am Teruhiro Komaki of frudens Inc.

fmOAuth v0.0.2 has been released.

Please check the Release Notes for detail.

Personally, I think that it is great that you can use the API using any client!

By logging in to Google Cloud Platform with your own account, You created a client to use the API, and You made it available by passing the created client information as a script argument.

You login to Google Cloud Platform with your google account, create a client to use the API, and make it available if you pass the created client information as a script argument.

In addition, you can now download Gmail (via Gmail API).
If you run it on the server side, I think that you can sync Gmail.
I think that it is easy to incorporate it because it implements it only by Insert From URL without using a plug-in or the like.

Please look at the sample file and question if there are unknown points such as script!

Although story changes…

Currently, I create a template file that can easily incorporate FullCalendar that can be used in FileMaker Web Viewer.

I might like to sell it at the Web store, so it may be cheap, but it may be sold for a fee!

In that case, I think that you can purchase by all means m(__)m

If you have an API etc. that you would like to integrate, I hope that you can request.

checked the calendar library used in FileMaker Web Viewer

Hello.
I am Teruhiro Komaki of frudens Inc.

Since fmOAuth integration with Google Calendar, I thought that I wanted to implement it with a UI similar to Google Calendar.

So when I displayed the calendar with the Web viewer, I examined libraries that seemed to be good, so I would like to introduce it.

Please check the license etc. when using it.

FullCalendar

https://fullcalendar.io
https://github.com/fullcalendar/fullcalendar

filemaker-webviewer-calendar-library1

In FileMaker, speaking of the calendar, I think that it is a classic as FullCalendar.

Although I actually used it, since it is easy to use and there are also a lot of information, I think that it can be implemented relatively easily if it examines a little.

Because the document is easy to understand, I think that you can understand by reading.

License

MIT License

https://en.wikipedia.org/wiki/MIT_License

FullCalendar Scheduler

https://fullcalendar.io/scheduler/

filemaker-webviewer-calendar-library7

This is the FullCalendar add-on I mentioned earlier.

Since the license is different from FullCalendar, please check it when using.

License

https://fullcalendar.io/scheduler/license/

Continue reading →

tried integration between FileMaker and Google Calendar and downloaded Gmail using the function of fmOAuth (0.0.2)

Hello.
I am Teruhiro Komaki of frudens Inc.

Recently I wrote two simple articles.

developing Gmail API (download and send) to fmOAuth (0.0.2)

In fmOAuth (0.0.2), OAuth authentication (Google) implements a function that can use arbitrary applications

I thought that it would not be transmitted, and I tried moving the movie the first time.
I think that you can see what you can do when you watch the video.

This time, the sample file has been greatly modified.
I hope you will download it after release.

we will continue to develop!

After that, I would like to implement a calendar using the web viewer.