123 Sync Filemaker
Everything FileMaker 19 Ready!!!
123sync is an add-on to your ApparelMagic ERP (desktop) solution to help you integrate your accounting with QuickBooks Desktop (versions 2016 and later), avoiding double-entry and creating efficiency for your team. MAINLY UNIDIRECTIONAL Please note that 123sync is mainly un-directional and is designed to PUSH data from FileMaker® to QuickBooks. Lists are PULLED from QuickBooks into 123sync for the integration manager to know what already exists in QuickBooks.
“360Works are the go to FM vendor of choice when you need your solution to work perfectly.” — Robert Ponzo, CTO of Allen Health Care Services
“We use 360Works plug-ins with our clients without hesitation. They’re easy to implement, and work dependably, and KEEP working dependably. Their excellent support is just the icing on the cake.” — Scott Love, Soliant Consulting
360Works Portfolio License
360Works Portfolio Bundle The Portfolio Bundle combines seventeen of our most popular plugins and products for one low price to extend the functionality of FileMaker for your solutions.
Featured FileMaker Products
360Deploy is a tool for FileMaker which allows you to rollout development changes painlessly. At the click of a button, deploy development environment onto production server while keeping data intact.
MirrorSync MirrorSync is a synchronization tool that links FileMaker Server to FileMaker Go and FileMaker Pro. With MirrorSync, users can make changes offline and simply sync their data to and from FileMaker Server when connected.
123 Sync Filemaker Software
Zulu lets you sync FileMaker calendars with Google Calendar, Exchange and iCal. Turn any FileMaker Server into a shared calendar server in a few clicks.
CloudMailsends and tracks emails using Amazon Web Services. It will send a dozen or a hundred thousand emails quickly and efficiently, and track the resulting views, clicks, unsubscribes, and bounces.
Scribe is the ultimate text processing plug-in. Use it to read and write text from Microsoft Office and PDF files, find what changed in a text field, and highlight text matching any criteria.
ScriptMaster is a free, general-purpose, modular plugin. It comes out of the box with modules for file manipulation, URL and network utilities, Web Services, shell scripting, event/script triggering, and many others
All FileMaker Plugins and Products
360Works SafetyNet is your low cost FileMaker remote backup solution. Now you can rest assured, knowing that your essential FileMaker databases are backed up securely and easily retrievable at any time.
360Works Web Services Manager publishes your FileMaker scripts as XML Web Services which can be accessed by any SOAP compatible software. Internally, this puts FileMaker on a level playing field with 'big iron' IT systems in a large organization. Externally, this can be used to power public Web Services and enable seamless B2B integration with your customers and vendors.
360Works FTPeekis a Universal Binary FTP Plugin for FileMaker that supports encrypted transfers, scheduled server operation, and uploads/downloads directly to FileMaker text and container fields.
123 Sync Filemaker Password
360Works Email lets you send and receive e-mail messages directly from FileMaker Pro. It supports SMTP for sending, and POP and IMAP for receiving. It will also run in FileMaker Server to allow you to send nightly scripted emails from FileMaker Server. It is also the perfect solution for sending e-mails from Instant Web Publishing.
360Works Plastic is a credit card processing plugin for FileMaker Pro. It supports Authorize.net and Verisign/Paypal Payflow. It is also compatible with Custom and Instant Web Publishing using FileMaker Server.
360Works SuperContainer is a Java web servlet which allows you to upload, view, and download images and files from a web server. In conjunction with the FileMaker Web Viewer feature, it is an effective replacement for container fields in solutions which require users to read and store files associated with records in FileMaker.
360Works Charts is a simple and powerful charting plugin for FileMaker Pro. This is the easiest way possible to quickly add bar charts, pie charts, and line graphs to your solution.
360Works JDBC lets you use JDBC to access any database from within FileMaker Pro or FileMaker Server.
360Works WebAssistant lets you POST and GET URLs directly from FileMaker. Perfect for filling out online forms, downloading web sites into FileMaker, or grabbing an image from the web and storing it into a container field.
360Works RemoteScripter allows you to trigger FileMaker scripts from an HTTP request. This means that you can have web pages which trigger FileMaker scripts, and also lets you trigger scripts between two copies of FileMaker! This is also a perfect way to run scripts from Instant Web Publishing that are not web compatible - just put them on a copy of FileMaker running Remote Scripter, and then you can trigger that script from FileMaker Server Advanced.
360Works AdminAnywhere is a FileMaker server plugin which allows you to remotely administer your FileMaker server from your web browser or browser-equipped mobile phone.
Tools
Auto-Update downloads and installs the latest version of 360Works plugins.
SOAP Client is a development tool designed to allow you to view and test SOAP Services.
WooF7 is a free JDBC driver for accessing FileMaker Server from Java applications. Compared to the standard JDBC driver that ships with FileMaker, it is smaller, more standards-compliant, and open source.
Many users work with a single FileMaker Pro database, copy the database to a mobile device, make changes and then copy it back to the desktop computer. If the database is small it can easily be copied between the desktop computer and the iOS device using iTunes, mail, or whatever. If the database is big it can be to time-consuming to copy the whole database back and forth. I spent some time earlier this year to develop a solution (well, ”hack” might be more accurate) where I import/export only part of the data, exchange only the updated information between the main database and a small local copy at a iOS device, using Dropbox as an intermediate storage.
With this kind of solution you don’t need a FileMaker Server, you don’t need to connect the iOS database to your desktop database, you bring only the data you need to your iOS device, and you can even use a FileMaker Runtime solution on your desktop. You work locally on your iOS device and you don’t need any internet connection except when importing or exporting changes, which can be done when you have WiFi access. Dropbox is a free service, at least for small amount of data.
The idea is to keep track of all changed (and deleted) data in the desktop database and click an Export button when you want to save the changed information to a Dropbox file. In your local iOS database you then click an Import button to get the data from Dropbox, run a script to update the relevant records, and also remove the file from Dropbox when imported. And, of course, vice versa.
123 Sync Filemaker App
With this very simple import/export strategy it is not possible to change the same record on both places, and you can only have 2 databases exchanging information. The point is that the two databases is never connected to each other, all communication is through files saved in Dropbox, and it is easy for a single user to keep a desktop database and a local iOS database in sync.
I made a small sample to demonstrate the functionality. It is more like a ”proof-of-concept”, it lacks features like error handling etc. The demo is simple, it is only one table with a few fields. I have made a short video, you can watch it below.
The demo is made up by the following techniques:
- a Dropbox App, you make one in the Dropbox App Console. Choose the App Folder permission. You will need the App key (client id) and a redirect url for OAuth 2 authentication. The redirect url can be to a very small and simple html file (it only needs to say ”Hello”), but it needs to be available on the internet. I put mine on Dropbox and made a public Dropbox link to it, it works fine,
- a web viewer to authenticate the FileMaker database with my Dropbox account. You will get the access token from the url parameters when authenticated by the user, I use the function GetLayoutObjectAttribute ( ”dropbox”; ”source” ) to get the url including the access token. The access token is saved in the database and used for all other Dropbox communication,
- web viewers executing Javascripts, I use AngularJS (I am a little bit addicted to it), ngDropbox, and some minor javascripts to write files to Dropbox, get a listing of all files in a folder from Dropbox, and remove imported files from Dropbox. Almost all the ”magic” happens here,
- the fmp protocol to get Dropbox file listings from a web viewer to FileMaker,
- the Insert from URL script step to import data from Dropbox,
- scripts in FileMaker for exporting and updating,
- no plugins, the same technique works on both OS X, Windows and iOS.
In the video below I have FileMaker Pro to the left and a iPhone device to the right. Both are using a local database, the only connection is the Dropbox folder which is down to the right.
(There is no demo file.)