Marketing and Related Issues

==== Market research====
Need desk based Market research / admin support to Sales Agent with access to CreditSafe, FileMaker Pro, Goldmine.

==== Marketing Tasks:====
*Pursue ''delicious ''links labeled: Marketing - to find prospective customers
*Pursue ''Word Document ''"Potential Customers" - to find prospective customers
*Pursue FileMaker "BizRules" file - to find prospective customers
*Setup Potential customers in GoldMine (or the application that fills the function of GoldMine), link in with Salesperson position
*Setup New customers in QuickBooks / FileMaker
 *Link up FileMaker with CreditSafe: See http://www.creditsafeuk.com/getdatawebservice/WhatIsGetData.aspx *

====== Telephone Number ======
03 is another non-geographic number that gives organisations a single national phone number and usually costs less to call than 0870 and 0845 numbers.

Q & A for Finding out a Client's Needs - Part I

====== Q and A = ======
Q. What will the database be used for? ======
- Could you please confirm exactly how, and what for, the Filemaker database is or will be used?
Have you already implemented this database software, and what kind of data is stored in there?
A. If we're going to use FileMaker Pro v10, it will be to manage our business.
This would include:

ITIL compliance

Service Management

Service Delivery

Contact Management

Job Scheduling for Cyclical, Proactive and Reactive Maintenance and Inspection

Task-Based Routing

Real Time Updates

Field and Office based Voice, Data and other Communications

Document Management

Customer Relationship (See what others did and buy in their system or copy their idea, for example: http://www.evolvit.co.uk/databases

Experience and Service Management

Web Integration

Online Sales and a host of similar operations that we do (or would like to do) in our growing business.

====== CRM software ======
Q. We also spoke about a CRM software.
Could you please confirm the exact use of this software.
What type of information/data will this be used for?
A. We need to look after our customers (reasons for this are self-explanatory - I hope . . .) and this entails:
Acquiring, Keeping and Upselling customers
Analysing Prospective and Existing clients,
Continuously improving Customer Service
similar operations required to maintain a steady flow of new business from our customers.
undefined

===== Reference =====
*For Data Access, see: http://subsonicproject.com/
*Reference Sites: This would do exactly what we were discussing in the past (RFCs, Problem Reporting, Bug TRacking etc.) http://www.datadesignlabs.com/IGotIssues.html

 *[[Mobile s | Mobile Specifications]] *

[[Phase II | FileMaker Phase II]]

 *[[Web dev medium | Web Dev]]

* ===== Glossary =====
 - Combox = Dialogue Box
 - KeyComb = Key Combination

Development Programme

Link Certificate and other documents to related Data

====== Filing corgi certificates ======

====== Pink copy of CORGI certificate to be added to CORGI invoices by looking up the site address in QuickBooks or FileMaker and match invoice number for date on certificate. Original certificate are to be posted to customer with invoice. ======

Would it be possible to have files linked to Records? 
Example: We have a PDF that arrived by eMail as an attachment and belongs to Durban Road. 

Example: Similarly, all the Certificates that we receive from NICEIC and EPC guys should be linked with their respective Property Records

Is it possible to have Hyperlinks to records? 
Example: When I eMail Berish I want thim to be able to click on a Hyperlink so that he can go straight to the record in question that I'm trying to show him.  
Maybe this is only possible in the FileMaker Pro Server (hosted online) version?

CONFIRM AN INSPECTION

====== A – PHONING THE TENANT TO CONFIRM AN INSPECTION ======
====== Upon receipt of the blue and pink British Gas appointment letter, a phone call should be made to the tenant as follows: ======
• Find out the tenant’s telephone number by searching in FileMaker (Start→FileMaker Pro→Hosts→Dashboard→Open→Properties→Control+F and insert data e.g. road name) or in the ‘Tenants’ list – a spreadsheet in Excel (My Network Places→shared on Server1→All Documents→Pacedream Limited→S Abraham→3-Star→3-Star Spreadsheets→TENANTS→Control+F and insert data). If the telephone number is not there, see B below. ======
====== Call the tenant and say, ‘I’m _____ calling from Pacedream Property Safety regarding your annual gas safety inspection. Did you receive a letter from British Gas (BG) about your upcoming visit scheduled for _____________ between the hours of 8-1/12-6? Confirm that the time is OK with them and record this information on the appointment letter with the date. If the time is inconvenient visit will have to be re-scheduled with BG – see C below. ======
====== In the Microsoft Outlook Calendar, make a reminder to call the tenant a day before the visit to confirm it once again. Include the time of visit and tenant’s telephone number. ======

 ====== B – PHONING THE HOUSING ASSOCIATION ======
====== If the tenant’s telephone number is not in the Excel list, a further phone call to the Housing Association (HA) is necessary: ======
====== Find out the relevant Housing Association for the particular property concerned, which should be saved on the same Excel list (Control+F and insert data e.g. address) ======
====== Find the HA’s number in the ‘Housing Associations’ Excel spreadsheet ======
• Call the HA and, after introducing yourself and the company, say you are calling regarding a gas safety inspection for ____________. Do you have the tenant’s telephone number so I can contact them regarding their inspection? ======
====== Once they have given you the tenant’s telephone number (and name) install it into FileMaker (and the Excel spreadsheet) and proceed with A above. ======

 ====== C – CALLING BRITISH GAS TO REARRANGE AN INSPECTION ======
====== Dial 08459 500 400, (when menu is cited) press 3 and type our telephone number (when they ask for it) 08456 98 00 44. ======
====== Say you’re calling regarding a bulk contract, give them tenants’ address and postcode ======
====== Rearrange appointment for appropriate time 8-1/12-6, giving the engineer’s job sheet a further timing bracket if necessary e.g. preferably after 2. ======
====== Confirm with tenant - see A above. ======

 ====== When speaking to British Gas always take down the call centre, name and extension number of the person you speak to, as well as the job number for the inspection/repair as this will make following up on call-outs far more straightforward.

Software Protection

===== Integrate this Software Package into FileMaker:

http://uk.search.yahoo.com/search;_ylt=A1f4cfhG9PJKwhYA8n9LBQx.?p=filemaker+pro+development+%22anti+piracy%22+-mac&fr2=sb-top&fr=yfp-t-702&rd=r1&sao=1‎

===== OnTimer examples: =====

Work Scheduler to distribute the work evenly

http://www.filemakerworld.com/search/node/ontimer

===== Scheduler: =====

http://marineleisureuk.com/products/scheduler/

===== Management System: =====

http://marineleisureuk.com/products/servicemanagement/

===== Existing projects: =====
http://www.meritsolutions.co.uk/screens.htm

41. ontimer, see: http://fmpscripting.blogspot.com/search?q=ontimer.

42. See: http://fmpscripting.blogspot.com - might help you somehow?

43. See Inizar's entry in the following blog: http://sixfriedrice.com/wp/find-mode-dates-and-times/

44. See the Forum: http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_alp.php?p_new_search=1&p_search_text=ontimer

45. http://www.soliantconsulting.com/blog/2009/05/countdown-indicator-demo/

46. http://www.seedcode.com/cp-app/ste_cat/filemakercalendar

47. http://www.google.co.uk/search?source=ig&hl=en&rlz=&q=connect+outlook+with+filemaker

48. http://www.nabble.com/Scheduling-program-to634471.html#a634471 - the link to the sample website doesn't work

49. http://www.nabble.com/forum/Search.jtp?forum=734&local=y&query=ontimer

50. http://fmpug.org/
For your scripts, relationships and layouts: http://www.goya.com.au/baseelements

Hints and Tips: http://www.digitalpoint.com/tips/filemaker.html

Please have a look at the following url, whose eMail address appears on the top 10 in TechNet:
http://sixfriedrice.com/wp/the-secret-life-of-find-mode-symbols/
They seem to know what they're doing, see:
http://sixfriedrice.com/wp/deleting-duplicate-records-in-filemaker/

Re: GIF in FileMaker Container (or was it Global?) Field: eMail the problem to: CNSImage @ cnsplug-ins.com

http://www.eweek.com/c/a/Database/FileMaker-9-Bulks-Up-without-Adding-Complexity/

http://sourceforge.net/projects/scuttle/

http://faq.filemakermagazine.com/wiki/FileMaker_Links

Contacts

1. We should use a Layout in the FileMaker File "Contacts" that allows for entering pertinent details regarding the abilities, services, prices and coverage area of each and every contractor.

2. When I enter details of an engineer, there are details that need to be entered which are specific to every industry.  
For example, an EPC engineer has a "Assessor's accreditation number (i.e. NHER004856), a NICEIC has a register number and so on.  
Then there are the qualifications, which will help us decide what kind of jobs to send his way.  
Furthermore we need to know this engineer's pricing structure. 

3. Can we have a Field to save "Company Registration number 05182524"? This will become more urgent once we have regular need for checking Credit Rating.

Requests For Change

====== Compare: ======

Juwel Design ERP Brief
Start from the ground up, aiming for FIleMaker 9 or 10 for Windows, with target date to go global within 12 months, giving quarterly milestones. Goal is to enable users of existing ERP/other implementations to integrate with our ERP-Ready system in the sphere of Field Services, Planned maintenance, Periodic inspections, Facilities management etc.,

====== Options: ======

1. FileMaker: for all data driven tasks and needs, with feed to/from Accounting, ERP, PipeLine (GoldMine, Act! etc.), Unlimited users via Web Server, Easy Customisation, Implementation, Integration
2. Collect FileMaker-designed products from various developers (JobTracker, EasyContact from Holland, Outbound Sales Diary from @003 Expo @£60.00 per hour)
3. MYOB: Limited to only 2 users, Links to FileMaker, only on Windows
4. QuickBooks: Limited to 5 users (except enterprise version, which is not yet tested), limited with file size, limited with customised reporting, Problem with "pending" invoices.

 * Bill Items By Class ‎ ‎

5. SAGE: cumbersome, links to FileMaker on Windows,
6. Hansa: One "Super" seat with option to link in up to 6 FirstOffice users linking to FileMaker using data files

====== Links: ======

‎http://www.newmillennium.com/index.php?src=gendocs&link=Business_Software_Overview

‎FileMaker Accounting

Tweak existing FileMaker

*Tweak existing FileMaker / QB dichotomy
 *Start defining requirements *Look through possible existing OTS
 *Evaluate Demo's - put Questions to vendors
 *Ask for reference sites
 *Multi-User, Multi-Office, Multi-Tier, Multi-Language etc.

===== Embed PBX Web Interface within FileMaker: =====
http://www.digium.com/en/search/?q=filemaker&cx=000646719971617706768%3Avxxaa7il5o0&cof=FORID%3A10#778

http://www.24usoftware.com/PhoneCompanion http://www.24usoftware.com/PhoneCompanion

===== Platforms: =====

====== FileMaker - small company ======

 ====== Servoy - Medium company - ultra-thin client deployment platform ======

Office Communications Server 2007 R2

http://office.microsoft.com/en-gb/communicationsserver/FX101729111033.aspx?ofcresset=1

==== More Features '''''HERE'''''  ====
More Requests

List of contact types - add supplier, etc.

Add a notes field to the phone table

Change header for phone/email to contact details

Reduce phone table size to half and put in its place a search box

When creating a new order you should select a company staff who actually placed the order

And this info will appear when the orders table is displayed

Initial check tab change title to job address

Add access details to the first tab in the orders table

Products ordered add table containing existing orders for that property should show payment status of all these existing orders move bill to info to the first tab (initial check)

The payment details need to be on the same tab as the products ordered

Supplier tab add supplier details and notes about the supplier

Integrate with the To Do list on Trello Website

Proprietary system for website

*Proprietary system for website CMS, CRM, Estimating (tendering), order tracking / job ticketing and accounts (Purchase orders, sales & purchase invoicing).  Is there a system that does this?  I have recently been evaluating our companies procedures and looking at ways to improve and streamline our processes. There are lots of solutions (not necessarily FileMaker) that provide some of the above but I have seen anything that ties it all in together. In a perfect world the system I imagine would provide:

• CMS website - integrated with google analytics

• CRM - tied in with the analytics as above with the ability to extract customers details for email & direct mail campaigns.

eMail campaigns for fundraising, event registration etc.

• Estimating - We are print management Co so tender each project to a select few suppliers. This would ideally have the ability to run reports such as a conversion rate for a particular client / supplier.

• Job ticketing - book in successful estimates.

• Purchase orders - raise purchase orders that tie in with job ticket to send to suppliers.

• Other accounts requirements - It would be nice if the system had full accountability or tied in with an accounts package.
See: http://my.advisor.com/doc/RYLEG04

• All the above would need to be available online using FileMaker or a browser.

Are there any existing Filemaker (or other) solutions that provide this (or close).

If not what would a realistic budget be for a bespoke solution?
Francis Grogan grgprint Management Ltd Tel: 0113 383 3888  Email: francis@grgprint.com

*Francis Grogan Director at grgprint management:  In case it's not obvious it would also need to integrate a client and supplier database and have individual log ins for different users (users being employees).

Daniel Shanahan Database and Web Developer at New Leaf Data:

Can you say more about the CMS website portion? There are many available - Joomla!, Drupal, WordPress, etc. What is it you want to do with a web Content Management System?

Likewise, I'm curious what you have in mind for a CRM - what exactly do you want from it? Estimating and Invoicing (along with client management) can be done in FileMaker.

Job ticketing as well, though it depends what you want.

There are several web-based project management systems that allow clients to view the progress of jobs and submit tickets. I can send you a sample FMP database that I built for client management (invoices, payments, projects, etc.).

Contact me if you would like to see it.

Stephen Dolenski Certified FileMaker Developer: Another option is Expression Engine.

Mark Lemm Owner, Lemm Tech Enterprises and Computer Software Consultant:

I have built most of this sort of this (except for the web piece. Not sure why you need that exactly) for a client using fileMaker 9. It's feeds data directly into QuickBooks Pro Enterprise on the back end for accounting purposes.

You can definitely build something like this in FileMaker but you are in the 30 to 50k range USD for this sort of project. FileMaker is one of the few platforms that can tie everything together with a single technology versus using multiple web based technologies and a separate back end database to do the same thing. How many users are we talking here? -Mark

Jonn Howell President at DataExperience, Inc. and Owner, DataExperience, Inc.: Call this man. He is such a system professionally developed for FileMaker 11.  

Allen Imbarrato President, Ki Systems, Inc. 

800-946-2854 

http://www.kibizsystems.com

Skype: allenimb

Francis Grogan Director at grgprint management: Thanks to all for the responses so far. 

I'll try and address some of the queries...  First a bit more background to the company: We used to be print manufacturers, but are now a broker which means we are more service orientated. We deliver savings to buyers of print by using our network os print providers, each of which have their strengths and weaknesses and all of which offer us trade discounts for the volume of work we send to them. We in turn can apply a small markup and 'earn our crust' so to speak. The company is only a three man operation at this time so we are not a big concern.  On each estimate request from a client we compile the specification and enter this in our estimating system, choose 2-4 suppliers (from the suppliers list) who are the most suitable for the job and send them our price requests. All the prices are entered into our system, the best option chosen "for use" and a percentage markup applied before this quote is sent to the client.

The client then gives the instruction to proceed at which point we will mark the estimate as "won" and create a job ticket from the estimate details. From the job ticket we will raise a PO and send this to the supplier. 

The job will be produced and delivered and we will send a sales invoice. The CMS & CRM function is to help bring the company inline with modern technological sales and marketing techniques. 

We'd like to be able to update our website content, add special offers, capture the details of visitors, track their behavior on the site and utilise those contact details to follow up leads with emails, sms and direct mail marketing techniques. 

These campaigns and contact attempts would be tracked within the CRM and those details tied in against the customers account within the management side of the software. 

We would also like the ability to extend the website to using a shopping cart function. If the best way to run the accounts side is to plug it in to a existing package such as quick books or sage that wouldn't be a problem so long as it worked well. As for hardware I have two Linux servers here both running Red Hat that could be used or we could look at a hosting solution. 

Downside:  From some of the indicative costs I have received it would appear my idea's were a bit pie in the sky. I have no idea in what would be involved in starting this from scratch but had hoped that someone might have written something similar that they might adapt to our needs. 

As a small company our budget would no where near stretch to the £30k plus figure mentioned. £5k would be at the top end of our budget if we could get a solution to fit all our needs.

*Mark Lemm Owner, Lemm Tech Enterprises and Computer Software Consultant: 

Thank you for providing more details about your situation. Yes in my opinion you are dreaming but you may be able to find a prebuilt solution for a low price and then customize it yourself. At $100/hr for programming (just using that as a guide) $5K is just over a week of work and I don't think someone could adapt an prebuilt solution much less built one from scratch for you in just over a week. 

You could start slowly and over time built up your system with all the features you want to spread out the cost. I still think FileMaker is a good platform to go with because it can to pretty much everything you want but it sounds like you want a top of the line system (which is fine) but my not be realistic for a firm your size.

*Daniel Shanahan  Database and Web Developer at New Leaf Data: I agree with Mark. It may be beneficial to think of your "system" in phases. What do you need first? What can you live without for now? Also, it may be helpful to consider the value a particular phase might have. For example, say that the first phase needs to organize the data of print providers and print buyers with some CRM functionality (e.g. a dashboard showing who to call this week, tasks to do, etc.). What is the value of such a phase? When it is implemented, how efficient will your three person team be? Will this efficiency increase your revenue? This may help put the £30k in perspective.

==== FileMaker Integration ====

===== Integration =====

*FileMaker plugin to fulfill most/ all requirement listed below:

 *Bluetooth keyboard - hardware dependent; not FileMaker Pro related

 *App for integrating Contacts with calendar

 *NavelLab's ReadMore App. Should have a Built-in Daily Reading Schedule to set reminders for Reading What, When, Where and if with or without a learning partner

17/09/2009
Link shopping basket to FileMaker
We need to connect the Order ID, Invoice Number and Bazaar Reference all into FileMaker

 * Add from-postcode address finder

 * Shopping Gateways

 * Add the following Industry Standard Shopping Gateways, to maximise our sales turnover success rate

 * Google Checkout

 * Amazon Basket

 * PayPal verified

 * Authorize.Net

 * GoDaddy.Com Secure Site

 * Enter all our regular small customers into the eShop database - see separate entry for instructionson how to do this - who we decide should always prepay. Then we could accept orders whilst logging on with their details (that we have assigned to each one of them) thereby giving a seamless service to our customers and we save time in the office too.

 * (alternatively, use one generic Username and Password for ALL retail customers - this needs to be explored if this is possible as eventually we want to link into FileMaker so maybe we should keep all records separate after all)

FileMaker Discussions: List Management

=== previous records for reference ===
Sent: 06 May 2009 10:51
Is there a way in FileMaker to have records in a selection list (i.e. Engineers) whom we used in the past, we stopped using them – so now they are not to appear in the selection menu but still need to show in previous records for reference?

====== Database ======

*What is [http://searchsqlserver.techtarget.com/sDefinition/0,,sid87_gci542529,00.html FileMaker Pro] ? **See [[Start FileMaker|FileMaker]] **Does it make a difference what Hard disk is used for FileMaker **Data Centre : SearchVirtualDataCentre.co.UK provides a comprehensive online resource for IT professionals seeking cost-saving strategies and looking for help with creating, implementing, managing and updating UK data centres utilizing virtualisation technologies for server consolidation, disaster recovery, lab and test, desktop centralization or other production usage. **To look up version details of FileMaker Pro and its OS, see here: FMChecker - a "Get Info" for FileMaker® Pro Databases, Do you know what all the FileMaker Pro files on your hard disk are all about? ... On what System and FileMaker version has a file been used and when last? ... [http://www.fmchecker.com/ http://www.fmchecker.com/] *Scripts on FileMaker Pro [http://fmpscripting.blogspot.com http://fmpscripting.blogspot.com]

FileMaker Ideas

===== Ideas =====
We always try to keep FileMaker and QB up to date. This means that any new customer detail should be added so that it saves time for all users when they look for a telephone number/email address/etc.
Enter property details from incoming eMails into FileMaker
Enter job details from incoming eMails into FileMaker
Enter tenant details from incoming eMails into FileMaker
Enter Customer details from incoming eMails into FileMaker
*See [https://appiam.com/ https://appiam.com/] for the Vesk virtualisation - could be used to host our TimeWyze solution **

=== BizRules ===
Collate all ideas/suggestions/tips/references etc. from BizRules FileMaker Pro file on the server into here

====== Help the FileMaker Project
Defining Database needs
Adding to Database Design
Choosing best replacement for current setup
New System Features Grid/Chart
Topic: Finished Repairs Report - sorted by Invoice Number

====== Maybe the colour of the Row should change to green if the invoice number is present.  Can you run such a Script/Formula on the existing Data Set/ This way we can visually alert all users to outstandingjobs/invoicing

NB: all FileMaker data is currently in the [[FileMaker|FileMaker General]] page, and has not yet been split into the separate phase pages

If you want to delete a Record without bringing up the Confirmation Dialogue, press the CTRL+SHIFT+E Keys simultaneously.

See also:

https://community.filemaker.com/community/discussions/product-ideas/content?filterID=contentstatus[published]~objecttype~objecttype[idea]&sortKey=recentActivityDate

Plug Ins, Component and other Bolt On Listing

We should stop a for a couple of moments and see if we are not reinventing the wheel: *http://www.supershareware.com/info/contactgrabber.html and other plug-ins on the same website. *ContactGrabber and other plug-ins on the same website *[http://www.filetransit.com/view.php?id=3791 http://www.filetransit.com/view.php?id=3791]  list of FileMaker Utilities, Plug-Ins etc. *[http://www.phs2.net/cwi/L3/o4767i.htm http://www.phs2.net/cwi/L3/o4767i.htm] list of FileMaker Developers, Utilities, Plug-Ins etc. FMC-Outlook™ is a certified FMComponent™ that utilizes the FMConnector™ (learn more) to communicate between any FileMaker® Pro solution and Microsoft Outlook®. FMC-Outlook™ enables Outlook Contacts, Outlook eMails, Outlook Tasks, Outlook Appointments and Outlook Notes, to be created directly from a FileMaker® Pro solution, or retrieved to your FileMaker solution, and be fully synchronized both real-time or when returning to the office. [http://www.datavations.com/dvpages/Products/FMComponent_Outlook.cfm http://www.datavations.com/dvpages/Products/FMComponent_Outlook.cfm]

FileMaker Related Links II

Third Party Links:

allbusiness.com/3470945-1.html?query=filemaker

http://anvildataworks.com/

http://en.wikipedia.org/wiki/ACID

http://faq.filemakermagazine.com/wiki/FileMaker_Links

http://filemaker.463488.n4.nabble.com/ Bulletin Board

http://freshmeat.net/search?q=filemaker

http://software.forbes.com/search

http://sourceforge.net/projects/scuttle/

http://www.360works.com/  SuperContainer for Document Management

http://www.briandunning.com/

http://www.daniweb.com/search.php?q=filemaker

http://www.dbdsoft.com/portfolio.php?portfolio=legal.xml&id=1

http://www.dbservices.com/

http://www.excelisys.com/

http://www.filemakerdesign.com www.filemakerdesign.com

http://www.filemakerspecialists.com/filemaker.htm

http://www.filetransit.com/ - search for query=filemaker not macintosh

http://www.fmtouch.com/‎

http://www.foundationdbs.com/downloads.html http://www.foundationdbs.com/downloads.html

http://www.goya.com.au/baseelements?gclid=CLbF84_jq6ACFZJr4wodyH5IrQ] Base Elements and UpdateManager

http://www.kibizsystems.com/‎

http://www.lifesuccess.org/jacknife.html http://www.lifesuccess.org/jacknife.html

http://www.listsearch.com/FileMaker/Browse/index.lasso?-session=listsearch:574B1F59078be0B1D1xRv2A1DE6A

http://www.longtermsolutions.com http://www.longtermsolutions.com

http://www.mofeel.net/forum/244/index.aspx

http://www.oceanwest.net/

http://www.pointinspace.com/

http://www.productivecomputing.com/

http://www.redianalysis.com/Home.html http://www.redianalysis.com/Home.html

http://www.scodigo.com/products/smartpill-php www.scodigo.com/products/smartpill-php

http://www.worldcloud.com/

http://www.x2max.com/en/products/xmCHART/info.html

Leading Filemaker Pro developers, Sussex UK based Deskspace Limited http://www.deskspace.com/index.htm

www.fmwebschool.com

Searches: 

http://www.google.co.uk/search?hl=en&q=“Anchor-Buoy”+standards-based+methods+intuitive+design+conventions&meta=&aq=f&oq

http://www.google.co.uk/search?hl=en&q=“Anchor-Buoy”+standards-based+methods+intuitive+design+conventions&meta=&aq=f&oq]=

LinkedIn Links I

LinkedIn Links I

 * http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=109321&discussionID=10023050&sik=1262866827964&trk=ug_qa_q&goback=%2Eana_109321_1262866827964_3_1

 * http://www.linkedin.com/groupAnswers?viewQuestions=&gid=1916025&forumID=3&sik=1268250552853

 * http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=16561825&gid=109321&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=14454543&gid=109321&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA FileMaker Pro questions

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=14770152&gid=1345837&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA FileMaker Pro questions

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=15300222&gid=1916025&trk=EML_anet_qa_ttle-d7hOon0JumNFomgJt7dBpSBA FileMaker Pro questions

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=20654770&gid=109321&trk=EML_anet_qa_cmnt-cDhOon0JumNFomgJt7dBpSBA XML Support To Be Discontinued?

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=23054014&gid=109321&trk=EML_anet_qa_cmnt-cDhOon0JumNFomgJt7dBpSBA How to use portal records information to create an entry on a new record that is related table to the main table?

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=23177102&gid=109321&trk=EML_anet_qa_cmnt-cDhOon0JumNFomgJt7dBpSBA What are the practical limitations of FileMaker?

Layouts

http://www.scriptology.com/theme-library

====== Permission ======
http://www.scriptology.com/permissions
*Please see the links below, it could speed up development of our solutiuon immensely:
For our telephone system: http://www.linearblue.com/phone_companion.php or http://www.linearblue.com/phone_companion_download.php
 *[http://www.pdflib.com/products/ http://www.pdflib.com/products/]
 *Use the Items, Descriptions and Prices in the cpc website to integrate into the Estimating Module.
If we're looking for a particular tool, consumable or peripheral, the search tool should link into cpc's catalogue so that it can interrogate their product list and bring back the requested details. *See specifically about live feeds from Excel: [http://www.eweek.com/c/a/Midmarket/FileMaker-Pro-11-Adds-Charts-Productivity-Features-409554/ http://www.eweek.com/c/a/Midmarket/FileMaker-Pro-11-Adds-Charts-Productivity-Features-409554/]
 *Check what files your FileMaker database server is serving (including hidden files) as well as the server platform [http://www.digitalpoint.com/tools/fmserverprobe/ http://www.digitalpoint.com/tools/fmserverprobe/]
 *This utility can be used to test the security of your own FileMaker web server [http://www.digitalpoint.com/tools/fmdigger/ http://www.digitalpoint.com/tools/fmdigger/] 
*FileMaker Pro with Drupal [http://drupal.org/node/539346 http://drupal.org/node/539346]

Solutions to Queries in our RFC List

* Record 1124: How to cut down on the time spent typing addresses - http://contactgrabber.software.informer.com/

 * Record 1123: How to verify IP addresses and match them with Postcodes:
http://www.google.co.uk/search?hl=en&lr=&newwindow=1&q=%22dynamic+ip+address%22+locator+%22by+postcode%22&start=10&sa=N - to be used as a form of Order Confirmation

 * Record 1051:  [http://www.google.co.uk/search?hl=en&newwindow=1&q=%22order+confirmation%22+email+or+fax+&meta=&aq=f&aqi=&aql=&oq=&gs_rfai

 * Record 1135: See this url for a solution to the ever present problem of: "before typing, press Tab or click in a Field, or choose the New Record menu command" dialogue box that appears all the time.
http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/A-Tip-Prevent-Dialog-Before-Typing-press-Tab-or-Click-in-a-field/m-p/49652?nobounce
http://www.filemaker.com/company/contact/feature_request.html
http://forum-en.filemaker.com/t5/Provide-feedback/bd-p/fdbk2

Date: 16/09/2009
Script to Duplicate a Property Address Record for buildings with multiple Tenants in their individual units (Studios, flats, offices etc.)

Date: 30/10/2009
RFC #: 219
Each featur request should be implemented on a FIFO basis: First come, first Served.

FileMaker Related Links III

FileMaker's own links:

====== FileMaker Fora: ======

FM Forum

http://www.databasepros.com/message_board/FMPro?-db=Password.FP5&-Format=login.htm&-Lay=CGI&-View

*http://www.listsearch.com/FileMaker/Browse/index.lasso?-session=listsearch:574B1F59078be0B1D1xRv2A1DE6A

FM Forums

http://fmforums.com/forum/listpt.php

*http://www.fmpro.org/

*http://www.findfilemakerdevelopers.com/

*http://it.toolbox.com/home/search/groups/?r=filemaker&community=0

*Tips and Advice http://filemakertoday.com/com/index.php

*FileMaker Q and A Forum

http://fmoverflow.stackexchange.com/

FileMaker in the Palm of your hand - FileMaker has released a FileMaker Mobile Companion for PalmOS.
Users of the best-selling database program can now bi-directionally transfer and synchronize files between their desktop and palmtop computers.

FileMaker Mobile allows users to select and load the data they require from the desktop machine onto their PalmOS handheld.
The data can then be resynched with the desktop database via Palm HotSync technology.

FileMaker Mobile is available for both Windows and MacOS.
The Windows system requirements include a Pentium 90 or higher, Windows 95/98/2000 or NT4 (SP3+), 32Mb RAM, a USB or serial port, Palm Desktop 3.01 or later and FileMaker Pro 5.0v3 (English version).
The handheld must run PalmOS 3.1 or later, have 2Mb of storage and a HotSync cradle or cable.

Simon Aughton - Tuesday 12th December 2000

FileMaker Resources - FMPRO Migrator

FmPro Migrator - Migrates FileMaker to MySQL FmPro Migrator quickly and accurately migrates FileMaker Pro database structure and data to Oracle and MySQL. Large text and container field image data from FileMaker Pro is migrated to Oracle and MySQL with no manual data entry. http://www.dotcomsolutionsinc.net/products/fmpro_migrator/index.html"

FileMaker Resources - IMS

FileMaker - Information Management System
FileMaker Pro 8 PDF Maker
inventory management system
digital assets storage container: store product information, illustrations, QuickTime files
track every job from start to finish

[edit] FileMaker and SuperContainer
Store and retrieve Documents PDF and other files using the SuperContainer Plug-In which uses FileMaker's Global Field Web Server Function (TBC) - http://www.google.co.uk/search?source=ig&hl=en&rlz=&q=supercontainer+filemaker&meta=cr%3DcountryUK%7CcountryGB"

FileMaker Resources - Speedier FileMaker

Solution for slow database
http://fmforums.com/forum/showpost.php?post/188736/)"

FileMaker Resources - SMTP-IT

http://www.cnsplug-ins.com/products.htm?product=smtpit%20Pro

FileMaker Resources - FileToolbox

A plug-in for FileMaker products that provides low-level file manipulation routines, including, create, read, write, delete, directory listings, encoding, encrypting and message digests. http://sourceforge.net/projects/filetoolbox/"

FileMaker Resources - Tracking

Project: to keep track of all the Contacts details

CALAMAR Time Billing - Time Tracking
http://sourceforge.net/projects/calamar/
http://www.linearblue.com/timetracker.php
[edit] PopTime 1.0
A simple plug-in which displays a dialog for Time input http://www.datamaticsoftware.com/Plug.html#PopTime
[edit] datamecsoftware
http://www.datamecsoftware.co.uk/
 - Web Based CRM: Access Customer Details via the Web
- Bulletin Express: Broadcast to thousands of email contacts

[edit] Ancilla
Filemaker 7 Based Helpdesk, used to track support calls, integrated knowledge base, can organize downloads, and asset management system http://sourceforge.net/projects/ancilla/

FileMaker Resources - Interface

Splash Screen
in Flash in QuickTime http://www.jamesng.com/filemaker/filemaker_quick_tips/index10.shtml

See also: http://fmpscripting.blogspot.com/2009/01/filemaker-creating-startup-splash-about.html

As an alternative, try using HTML 5.0 http://www.google.co.uk/search?hl=fr&;source=hp&;q=HTML+5.0+&;meta=

Seasonal Message Generation:

http://filemakertoday.com/com/showthread.php?t=23301&;highlight=clock

Limited to 30 Day Trial Version to combat and protect Software Theft Piracy

http://filemakertoday.com/com/showthread.php?t=23186&;highlight=clock http://uk.search.yahoo.com/search;_ylt=A1f4cfhG9PJKwhYA8n9LBQx.?p=filemaker+pro+development+%22anti+piracy%22+-mac&;fr2=sb-top&;fr=yfp-t-702&;rd=r1&sao=1‎ http://www.hi-voltage.com.au/codex.php

FileMaker Resources - Version Control

http://www.chapsoft.com/brushfire/index.html

FileMaker & Web Resources

Twitter and FileMaker Pro
Q. Is it possible to pull Tweets into FileMaker? I've seen a few post on how to go from FileMaker to Twitter, but not the other way around. A. 1. use the built in RSS feed for any twitter stream and then transform it with XSL into a FileMaker compatible grammar
[edit] Skype
http://www.businesscommander.net/ integrated with Skype
http://www.filetransit.com/view.php?id=53762 
[edit] Dot Net or .Net
http://bytes.com/topic/asp-net/answers/289648-product-annoncement-ado-net-driver-filemaker http://www.dotnet2fm.com/ fmDotNet is a .NET class to exchange data through FileMaker Server's web publishing engine. fmDotNet is written in C# using .NET 2.0. http://sourceforge.net/projects/fmdotnet/

FileMaker Utilities - Advanced

Parsing
Incoming eMail messages into FIleMaker: http://software.filestube.com/software,a49e7014,POP3it.html
Related to a problem we discussed some time ago: Re: Parse out carriage returns: http://osdir.com/ml/db.filemaker.devel/2005-12/msg00189.html
[edit] DONE - Re POP3it:
Amram emailed me about it, and I have responded to him. Originally I had read that you have to register/pay for pop3it, however you found something that seemed to suggest that you didn't have to register the prog, so we left it and did not register nor pay. However now the program (Amram tells me) is asking to be registered, so I guess you will have to pay
http://www.cnsplug-ins.com/products.htm?product=pop3it%20Pro
[edit] TxT from FileMaker to Mobiles:
http://www.agiletelecom.com/howitworks.aspx

FileMaker Resources - Records, Formatting etc.

Records Entered according to User Permission/LogIn

Resize or Maximise Window:

[edit] Calendar
http://www.macmasters.com/
http://www.hi-voltage.com.au/products/filemaker-developer-tools/calendarbox/

[edit] Scheduling rental of Equipment:
http://www.kantala.com/images/Asset_Mgt_CS_1.jpg
http://www.hi-voltage.com.au/products/bookingpoint/

FileMaker Resources - Spelling

Misspellings, Near Misses and Natural Language Recognition
Using Nexidia's patent-pending technology and products for audio-video search, users can locate, index, and access specific passages within presentations with greater speed and precision than otherwise possible. Furthermore, users benefit from unsurpassed accuracy as the Nexidia solution is based on phonetic technology, enabling searches and mining to be conducted in a natural manner against the distinct phonemes or sound elements of human speech. This unique approach enables the identification of words, phrases and names regardless of accents, dialects, slang, recording quality, or even misspelling...
See more:  http://www.nexidia.com/about_us/news_and_events/news/in_search_of_the_right_search_technology_for_your_customers http://www.blackwasp.co.uk/Soundex.aspx www.catalysoft.com/articles/MatchingSimilarStrings.html

Date: 25/09/2009
RFC #:173
Can we have a utility to cONVERT WORDS tHAT hAVE bEEN tYPED bY mISTAKE iN cAPITALS tO Lower Case?

Date: 13/10/2009
RFC #: 191
Spelling Checker doesn't allow me to TEACH him new words(?)

Date: 25/09/2009
RFC #:170
Please whenever you make a Field Name or Instructions in FileMaker, run it by a spelling checker. 
This will ensure we have a legible interface.

Filemaker Utilities

Utility
http://www.squashedsoftware.com/products-filemaker-sleeper.php
[edit] Active and non-active Records
http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&thread.id=4458
[edit] DropDown Menu
http://my.advisor.com/doc/18351
[edit] Nested Menu
http://www.fmforums.com/forum/printpost.php?tid/199513/pid/309783/
[edit] Clear DropDown Menu Selection
http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&thread.id=4533
[edit] Deduplication
Software that will work with FileMaker http://www.patentstorm.us/patents/5806057/description.html

Data Import II: Importing Records

1. 1. Webviewer set to the address used as the get request should work. Then you can grab the source code for the html and parse it out.

1.2. You can add a java based 'module' or plugin to grab the data for you.

Q. It looks to me that many records were imported twice: once with, and once without the company name.  
I accept that this was required for Employer/Employees (or as you call it Company/Staff) purposes.  
However where there is only a Company, we don't need Company/Company relationships do we?  
It is not urgent, but sometime in the future (after you finish the accounts module?) please delete all records that are identical except that one has a company name and the other hasn't.

Q. There are many details in the fields that were not imported from the old contact file: Position, Department and Notes for example. 
Whenever I try to contact a gas engineer, all the pertinent details are practically lost. Is there any way to import them into the new file, in the Notes Field for example?
A. 22/10/2009 Menasche says: This task can be made easier, if you duplicate the original contacts file and Find all Records that have no notes in Notes Field (or all the other Fields mentioned in this request). 
Then choose Delete Found Records, which will leave you with a smaller File that contains the Records we need to work with.

27/09/2016
MS
Q. How can I arrange the Import Field Mapping Dialogue Box to only import Data that Matches a Field AND create a NEW Record IF the Data is NOT already in the Target Database?
Example: I have exported Records from one Table in FileMaker that need to be imported into another Table in FileMaker.  Problem is: some of the Data from the Source might already be in the Target Table. 
Step One is to Match Records,
Step Two is to esnure existing Data is NOT overwritten,
Step Three is to ensure that the Data that is not yet in the Target Table reaches it.
A. Change the Field Mapping Symbol to the Equal Sign: = for every Field that you are afraid that you will lose the Data: If the Data is not present it will be added (remember to tick the option "Add remaining data as new records") and if it is present, then it will be overwritten with the identical Data.

FileMaker SQL

Google Groups: comp.databases.filemaker - Which would you use here, FM or SQL?

http://groups.google.com/group/comp.databases.filemaker/browse_frm/thread/80f2e2e26d62d2ff/1e044709c30022f1?hl=en&lnk=gst&q=Which+would+you+use+here%2C+FM+or+SQL%3F#1e044709c30022f1.

www.excelisys.com - Excelisys :: Database Development Page :: Filemaker Pro Consulting and Database Development, Lasso, Servoy, MySQL

6. Examples of MoleSoft solutions

http://wareseeker.com/Information-Management/fmpro-worksheet-1.04.zip/379783

http://www.dotcomsolutionsinc.net/support/fmpro_migrator/article_migrating_from_filemaker_to_mysql02.html

3 Sources for Dynamic Lists

1. http://www.nightwing.com.au/FileMaker/demos.html,

2. http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_alp.php?p_new_search=1&p_search_text=dynamic%20list and

3. http://fm.lithium.com/fm/board/message?board.id=FM-en-4&message.id=22671

functions

www.fmfunctions.com http://www.fmforums.com/forum/fm_markup.php?g/1/x/1

Reports and Statements

Print Statements with data from various Tables:

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=109321&discussionID=9628262&sik=1262605879023&trk=ug_qa_q&goback=%2Eana_109321_1262605879023_3_1

eMailing from FileMaker

eMailing from within FileMaker

Look up 'majordomo' on this website, which may help in allowing FileMaker to integrate Outlook and / or interrogate eMail messages.

What is majordomo? See: http://en.wikipedia.org/wiki/Majordomo_(software)

also, see: http://www.google.co.uk/search?hl=en&q=FileMaker+to+integrate+Outlook+and+%2F+or+interrogate+eMail+messages&btnG=Google+Search&meta=&aq=f&oq

Would it be possible to integrate all the online social networking services with FileMaker, so that any eMail (or another kind of) message can arrive in one centralised InBox?

From the Vodafone New User Registration page:
'Use my email as my username. Please note we can’t accept email addresses as a username that contain a dash (-).'

Remember this tip
Message 1.0 is a FileMaker Pro In/Out Board Messaging Calendar Application which includes useful features and screens like:

An Intuitive In/Out Board screen Message creation from the In/Out Board User Message Folders (New, Sent, Saved, and Deleted)

To Do items and Calendar Events Day-at-a-glance view Week-at-a-glance view Month-at-a-glance view Holiday and special events creation Flexible system preferences including user security overview Cross platform (optimized for viewing on MAC and PC platforms) Multi-user - http://ptf.com/download/message/238255/

Date: 03/09/2009
Q. Is it possible to eMail PDF of Invoices?

===== eMail and Calendar =====

Dacons FileMaker Plug-Ins: http://www.dacons.net/  Connect Filemaker to BIS (=BlackBerry Information System/Server) 

http://rickonrails.wordpress.com/2008/04/

To create animated text effects

To create animated text effects, like fading, sequence (as in 'Waiting . . .', where the dots are alternating) see:
http://fmforums.com/forum/showpost.php?post/321564/ and preceding comments URI_scheme http://en.wikipedia.org/wiki/Data:_URI_scheme Base64 data http://wapedia.mobi/en/Base64 Text Conversion Tool http://software.hixie.ch/utilities/cgi/data/data extract data from databases  http://www.freedownloadscenter.com/Utilities/Text_Search_and_Replace_Tools/TextPipe.html
[edit]"

FileMaker Resources 023 - Power Safety Wiki

FileMaker Resources 003 - Power Safety Wiki:

iPod and iPhone

http://www.google.co.uk/search?hl=en&q=fmtouch+windows&btnG=Search&meta=cr%3DcountryUK%7CcountryGB
to synchronise the iPhone with Server data, see also: 'a team of FileMaker developers is celebrating the release of FileMaker 10 with a free database designed for the iPhone

http://my.advisor.com/doc/19486 Build FileMaker Web Applications with Apple's iPhone SDK

http://www.fmtouch.com/movies.php

http://powersafety.biz/MediaWiki/index.php?title=FileMaker_Resources_003#Reminders_and_Alerts

FileMaker Resources 003 - Power Safety Wiki:

Reminders and Alerts

http://ulearnit.com.au/

Credit Card Processing

http://credit-card-validator.software.informer.com/ I downloaded it to the FM 10 Folder in the Installers Folder http://www.transaxdevelopers.com/FileMaker_Gateway_Integration/FileMaker_Payment_Integration.asp FileMaker World WebRing http://s2.webring.com/cgi-bin/hubsearch?search

FileMaker Resources 003 - Power Safety Wiki

FileMaker Resources 003 - Power Safety Wiki: "SyncDeK - FileMaker Pro Synchronization
WorldSync Announces SyncDeK - FileMaker Pro Synchronization: ... SyncDeK application built as a next generation Java-based service. ... company offices, manufacturing plants, ISP-hosted databases, engineering teams, research ... comp.databases.filemaker - 26 Aug 2003 by Jay Gonzales - View Thread (1 article) http://www.worldsync.com:16080/syncdek/developer_alliance.html  
[edit]"

FileMaker Resources 033 - Power Safety Wiki

FileMaker Resources 003 - Power Safety Wiki:

Time Delayed Copy Protection

http://www.tek-tips.com/viewthread.cfm?qid=1552828&page=1

Capital Letter and lower case text

FileMaker Resources 003 - Power Safety Wiki: "Change Lower Case to Capital Upper Case Letters
http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=15165321&gid=109321&trk=EML_anet_qa_ttle-cDhOon0JumNFomgJt7dBpSBA
[edit]"

Q. Can you CapitalisE all Types in the Type Field?
A. Do you mean the whole word should be in Uppercase or just the first letter of each word?
Q. Just the first letter of each word (until I change my mind ;-] - sorry!)

Q. The Field Name doesn't convert the letters after the first letter to lower case - why?
A. It used to upper case it, but then one day I typed in the Name Field of the first Record - EDF... and it turned it into Edf, so I disconnected the Script for this field.
Q. Can you not Script the Field with a logic that interrogates the text; if it's an acronym of a company name (like EDF: Electrice de France), then don't change All Caps to Capitalise First Letter

Q. The feature to CAPITALISE all first letters in address Fields is extremely useful. 
Please can you make an exception for Postcodes? 
The Script should check if there is a DIGIT in the text (example: E5) than it should make it all CAPITALS.
A. 

Q. How to remove Title Case in text field?

A. http://fmforums.com/forum/topic/61648-how-to-remove-title-case-in-text-field/


Q. The feature to CAPITALISE all first letters in Contact Fields is extremely useful. 
How can I set up this feature with the exception to the following words: "and", "for" or "in" - see examples below:
"The Hare and Fox Pub" -  "The Association for Caring Parents" - "The Membership List in London"

Upper Case Caps Capital