Moving a CRM project from FileMaker to LC?
Moderators: FourthWorld, heatherlaine, Klaus, robinmiller
-
- Posts: 16
- Joined: Tue Jun 19, 2018 8:50 am
- Location: DK/DE
- Contact:
Moving a CRM project from FileMaker to LC?
Some people will probably roll their eyes when I arrive with this long read, but on the other hand, I have the impression that this community has a high level of social competence and helpfulness :-)
I am currently faced with the decision of whether to migrate my project towards livecode. My app is a kind of minimal CRM for small offices, it is mainly an address book that is linked to corresponding tasks, invoices, projects, letters and articles. If you want to know details, you can find more informations and screenshots via "alfonsapp" (unfortunately in German only).
To date i have developed with FileMaker only, but lately with the killing of the runtime distribution and the pricing politics, i have to find something else.
I would just be interested in your experiences. I am "supporting" LC since some years with an Indy License, but did'nt find the time to really work with it. Also comments like "is feasible but you should consider XY" or "Better open a café" would be helpful :-)
Of course i'm aware of building something new from scratch. My most important topics/fears are:
- Multilingual UI
- Intensive use of relational DB
- Printing (Invoices, Letters, Reports …)
- Easy installation and updates for the users (Runtime hardening, including the DB …)
I already thank you for your time!
Jan
I am currently faced with the decision of whether to migrate my project towards livecode. My app is a kind of minimal CRM for small offices, it is mainly an address book that is linked to corresponding tasks, invoices, projects, letters and articles. If you want to know details, you can find more informations and screenshots via "alfonsapp" (unfortunately in German only).
To date i have developed with FileMaker only, but lately with the killing of the runtime distribution and the pricing politics, i have to find something else.
I would just be interested in your experiences. I am "supporting" LC since some years with an Indy License, but did'nt find the time to really work with it. Also comments like "is feasible but you should consider XY" or "Better open a café" would be helpful :-)
Of course i'm aware of building something new from scratch. My most important topics/fears are:
- Multilingual UI
- Intensive use of relational DB
- Printing (Invoices, Letters, Reports …)
- Easy installation and updates for the users (Runtime hardening, including the DB …)
I already thank you for your time!
Jan
Re: Moving a CRM project from FileMaker to LC?
I'd say : go for it.stoltenberg wrote: ↑Mon Mar 02, 2020 11:34 amTo date i have developed with FileMaker only, but lately with the killing of the runtime distribution and the pricing politics, i have to find something else.
You perfectly describe the insanity of FM model : pay, pay, repay and pay again. And pay more (for the next version).
Enough.
At one point, like the song : "Frankie says no more".
LC can do everything FM can do, and much, much more.
I know : I was a FM guy before. Exactly like you !
No problem, once you've got the "tricks".
Piece of cake of one simple reason : no link whatsoever... with LC
It's pure SQL. MySQL, PostGresql or SQLite.
LC talks to them,perfectly well. The magic is not in LC, but in SQL. You have to learn.
From my point of view: that's the tricky part. To be honest : i dont like it. But i manage to make it work.
Again.... no link with LC. Once you have your EXE, many tools exists to "install" it. Free or for a fee.stoltenberg wrote: ↑Mon Mar 02, 2020 11:34 am- Easy installation and updates for the users (Runtime hardening, including the DB …)
Regarding auto update ? With a few tricks, easy to do.
Take the leap. And tell FM to go to hell.
-
- Posts: 16
- Joined: Tue Jun 19, 2018 8:50 am
- Location: DK/DE
- Contact:
Re: Moving a CRM project from FileMaker to LC?
Wow, that was quick and extremely informative. I can see that I'm not alone. FileMaker has long annoyed their very loyal users,
but the runtime-decision will now jeopardize one or the other business model and existence - the FileMaker forum is full of it.
Your answer is not only very helpful, but also motivating for me. I don't know if I can close all the gaps in knowledge, but in any case
I really want to get to know SQl better. Last but not least, this knowledge can also be used again and again outside of LC, too.
A thousand thanks, you gives me courage
but the runtime-decision will now jeopardize one or the other business model and existence - the FileMaker forum is full of it.
Your answer is not only very helpful, but also motivating for me. I don't know if I can close all the gaps in knowledge, but in any case
I really want to get to know SQl better. Last but not least, this knowledge can also be used again and again outside of LC, too.
A thousand thanks, you gives me courage
-
- VIP Livecode Opensource Backer
- Posts: 2718
- Joined: Sat Dec 22, 2007 5:35 pm
- Location: Genève
- Contact:
Re: Moving a CRM project from FileMaker to LC?
Hi Jan,
viewtopic.php?f=8&t=19283&hilit=translat#p168491
Best regards
Jean-Marc
Here is a little stack with a way to translate text dialogs.Multilingual UI
viewtopic.php?f=8&t=19283&hilit=translat#p168491
Best regards
Jean-Marc
https://alternatic.ch
-
- VIP Livecode Opensource Backer
- Posts: 9729
- Joined: Wed May 06, 2009 2:28 pm
- Location: New York, NY
Re: Moving a CRM project from FileMaker to LC?
Hi.
You will have a learning curve to get running with LC. Use this forum often as you proceed.
Craig
You will have a learning curve to get running with LC. Use this forum often as you proceed.
Craig
-
- Livecode Opensource Backer
- Posts: 366
- Joined: Tue Apr 10, 2012 9:18 am
Re: Moving a CRM project from FileMaker to LC?
If you have a VPS or local office-server to use as a web/mysql/livecode server, there are some things you can do that will solve much of your requirements:
##Updates
This is a big one that LC can do in conjunction with using a server, and I am surprised it is not discussed more.
Basically, you can divide your app into two parts: A launcher, and the actual app which will reside on your server as a stack.
you distribute your Launcher to everyone. If you need passwords and such, that can be handled by the launcher which can then check against the server (via a database or some pre-configured script on the server)
Once the person has opened the Launcher (and put in their login info if that is what you need) then the Launcher opens the stack from the server. That stack loads into the memory of the machine they are using, so they are not actually modifying the stack on the server in any way.
By using this method, all you have to do for updates is replace the single stack on the server. When people open their Launcher, whatever version of your stack you have on the server will be what they get. You can update it every day if you need to. The people using the Launcher will always get the most recent version.
Richard Gaskin ( @FourthWorld ) guided me on how to do that. It is, to be honest, such a great feature that I cannot imagine having to use Filemaker ever again with its complicated (and very expensive) server relationship.
I have an example stack I have been working on for the last few months that I keep meaning to post on this forum, since it is a topic that comes up often enough. I will try and work on it enough to demonstrate the updating feature.
##Updates
This is a big one that LC can do in conjunction with using a server, and I am surprised it is not discussed more.
Basically, you can divide your app into two parts: A launcher, and the actual app which will reside on your server as a stack.
you distribute your Launcher to everyone. If you need passwords and such, that can be handled by the launcher which can then check against the server (via a database or some pre-configured script on the server)
Once the person has opened the Launcher (and put in their login info if that is what you need) then the Launcher opens the stack from the server. That stack loads into the memory of the machine they are using, so they are not actually modifying the stack on the server in any way.
By using this method, all you have to do for updates is replace the single stack on the server. When people open their Launcher, whatever version of your stack you have on the server will be what they get. You can update it every day if you need to. The people using the Launcher will always get the most recent version.
Richard Gaskin ( @FourthWorld ) guided me on how to do that. It is, to be honest, such a great feature that I cannot imagine having to use Filemaker ever again with its complicated (and very expensive) server relationship.
I have an example stack I have been working on for the last few months that I keep meaning to post on this forum, since it is a topic that comes up often enough. I will try and work on it enough to demonstrate the updating feature.
Re: Moving a CRM project from FileMaker to LC?
I like this idea. But in some cases could be a problem (large stack, internet problems).ghettocottage wrote: ↑Mon Mar 02, 2020 4:03 pmOnce the person has opened the Launcher (and put in their login info if that is what you need) then the Launcher opens the stack from the server. That stack loads into the memory of the machine they are using, so they are not actually modifying the stack on the server in any way.
Personally, I use the launcher method.... but with a local file.
It's only when there is an update available (I use a MySQL table for that, in which I store a simple version number that will be compared to the version number in the stack on the user's PC), that the launcher will fetch the updated stack (from a FTP server, on the local network) and then write it into the directory, on the user's PC.
Rince, repeat.
Very efficient.
Only one big regret : impossible to do that... on Android !
That sucks a lot. Each time the user has to desinstall and reinstall the new apk file... Boring.
If LC could work on this, it would be great.
-
- Livecode Opensource Backer
- Posts: 366
- Joined: Tue Apr 10, 2012 9:18 am
Re: Moving a CRM project from FileMaker to LC?
Interesting. I am curious why would you not just store it on the FTP Server since it is a local network? Is your stack really that large?bangkok wrote: ↑Tue Mar 03, 2020 4:21 am
I like this idea. But in some cases could be a problem (large stack, internet problems).
Personally, I use the launcher method.... but with a local file.
It's only when there is an update available (I use a MySQL table for that, in which I store a simple version number that will be compared to the version number in the stack on the user's PC), that the launcher will fetch the updated stack (from a FTP server, on the local network) and then write it into the directory, on the user's PC.
...
Re: Moving a CRM project from FileMaker to LC?
To save ressources.ghettocottage wrote: ↑Tue Mar 03, 2020 4:38 amInteresting. I am curious why would you not just store it on the FTP Server since it is a local network? Is your stack really that large?
It's my "old style" i guess.
If there is not update to be made... then why use the network ?
If the file is stored locally, the user can open then close the app ad nauseam. No bandwidth used.
-
- Posts: 16
- Joined: Tue Jun 19, 2018 8:50 am
- Location: DK/DE
- Contact:
-
- Posts: 16
- Joined: Tue Jun 19, 2018 8:50 am
- Location: DK/DE
- Contact:
-
- Posts: 16
- Joined: Tue Jun 19, 2018 8:50 am
- Location: DK/DE
- Contact:
Re: Moving a CRM project from FileMaker to LC?
Hi ghettocottage
and thanks a lot. I would like to keep the app independent/»offline« for different reasons, but the model is very interesting.
I've tried similar scenarios with FileMaker, but with the runtimes and the hardening process for the delivery to macos 10.14 and 10.15
there was no way. But i can see, that LC is just allowing more ways than FM and i will figure one out :-)
Best regards
Jan
and thanks a lot. I would like to keep the app independent/»offline« for different reasons, but the model is very interesting.
I've tried similar scenarios with FileMaker, but with the runtimes and the hardening process for the delivery to macos 10.14 and 10.15
there was no way. But i can see, that LC is just allowing more ways than FM and i will figure one out :-)
Best regards
Jan
ghettocottage wrote: ↑Mon Mar 02, 2020 4:03 pm##Updates
This is a big one that LC can do in conjunction with using a server, and I am surprised it is not discussed more.
Basically, you can divide your app into two parts: A launcher, and the actual app which will reside on your server as a stack.
Re: Moving a CRM project from FileMaker to LC?
Hi,
Directly "open stack" from a remote location gave me problems sometimes, so I prefer to download 'em & open locally. Saves a few MB of bandwidth anyways ;-)
Just double checked - the "modules.rev" that my apps depend of are definitively not in the APK!
Have fun!
That's what I do, too. I fetch the stack files ("modules" in my speak) from an FTP, in case there's a new version. I just don't use a local one. My "modules" typically have a specialized job & don't ever contain any data, so they're only 10 - 400kb.
Directly "open stack" from a remote location gave me problems sometimes, so I prefer to download 'em & open locally. Saves a few MB of bandwidth anyways ;-)
Ooops? I just save them to the documents dir ("/data/data/[identifier]/files/" on Android 6) & don't need to reload 'em - this one is permanent for this apk.
Just double checked - the "modules.rev" that my apps depend of are definitively not in the APK!
Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
Re: Moving a CRM project from FileMaker to LC?
What what ?
Thank you to give me details please.
You have a "launcher" method on Android ?
An APK that will download a stack ? And then open it ?????
Re: Moving a CRM project from FileMaker to LC?
Hi,
just stepped through, this should it be:
This is distributed over quite some handlers (and some parts are simplified), but it's the part that fetches & starts the stack. There's stacks that get "start using stack ...", too. It runs equally on mobile, development & standalone.
Have fun!
just stepped through, this should it be:
Code: Select all
put URL "ftp://[...]/myStack.rev" into myFile
...
put specialfolderpath("documents") & "/myStack.rev" into theTarget
...
put myFile into URL ("binfile:" & theTarget)
...
go stack (theTarget) in new window
Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!