Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Jonathan9's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. As a small developer in the UK, would others (of similar type), recommend the joining the FileMaker Business Alliance? http://www.filemaker.co.uk/fba/ (US only info: https://fmdev.filemaker.com/docs/DOC-1244) The annual cost isn't listed... I note that the US version (and I assume UK also) allows for a NFR current version of FM Advanced too, which could be cost effective with the other benefits when new versions are released II'm aware v12 is coming soon..! Other advantages listed such as TechNet membership seem redundant now Technet is free to join... Any opinions?
  2. I have a runtime (v11) which is distributed to a several hundred users, and as with all users, they have different systems, some are just home/personal laptops, some are corporate secured down laptops, some standalone, some network. I always create a custom installer, which copies the runtime files to the specified location, adds start menu/desktop shortcuts etc. The runtime has several files with data, but as with most runtimes the data is held in the same area as the runtime files as it seems the best option, the system has a backup routines, which also places backup files in the file location determined by FileMaker scripts (as we didn't want to use plug-ins to give access to user defined folder areas). With XP and before I had always installed into Program Files and this was rarely an issue as 99% of users had read write access. However now a large proportion of users are running Windows 7 (some Vista), the issue of protected folders and admin rights is far more complex and causing issues. If the user doesn't have full admin rights (or over-rides the UAC), and most of the users for this system aren't technical and don't understand the issues, they cannot add or edit data in a runtime system installed into Program Files at all. Program Files is a protected folder and Microsoft encourage developers to install user data to: AppData, LocalAppData, ProgramData. However as the user will need to access the installed folder for upgrades and backups, I don't feel these are ideal locations, as they are too obscure. It is considered bad practice to ask the users to alter security settings just to run a program which doesn't fit into MS guidelines. Documents / My Documents is out as if the PC is on a network system, Docs is a network folder, and performance takes a hit. Have considered creating and supplied a unique USB key for the system, but with users on older USB 1.1 the performance is useless. How are others approaching this? I'd be interested to hear your thoughts...
  3. I agree - I guess not. I will have a look at the XML format / XLST style-sheet, as the users are running Office 2003, thanks comment. My follow up was just wondering if there were any other ideas of though: between the manual transpose I first suggested (which is the most tedious, but gives perfect data within FMP and then a one-click option to the user to export directly into their required format); and this Line/Subst idea which creates a calc with delimiters to move into an intermediate format. [When I do this using Access I open up an instance of Excel and script the actual creation of the data from the query in Access directly into the correct cells in Excel, which is the most efficient way via the MS route]
  4. I should have made it clearer, each field is to appear in a separate cell on an excel row. I've edited the original post to add more details. Hence my first thoughts were to create a large temp table and manually/loop transpose the data in a script, then export this temp table to a XLS file. Obviously if we were to go down the CSV route with using any delimiters this will be an issue if the file passes into a CSV or another format before moving to Excel. However if there no other solutions, a script could remove/replace any offending characters first from the actual data set... Any other ideas?
  5. Ohhh The List with Substitute functions, what a great tip, thanks TheTominator! Ideally they want a one click from FileMaker into an Excel (native formatted, data in each cell) export, but the CSV could be a great starting point, and worst case if I can't come up with anything else, they can open, format within Excel and save as XLS.
  6. OK this is a very odd request (clients eh?!) A system manager requires an export to native XLS Excel file (ready for a very inflexible accounting system) from multi line item records to be shown on one long line for each master record. Example for simplicity: [color:blue]Master Record, Orders OrderCode, OrderDate, OrderInfo etc [color:blue]Related Lines OrderLines(1 or more): Item, Cost, Tax Now they want an export file from this data which will show the following: OrderCode, OrderDate, OrderInfo, Item(line1), Cost(line1), Tax(line1), Item(line2), Cost(line2), Tax(line2), Item(lineN), Cost(lineN), Tax(lineN) Added for clarity - Each field needs to be in a separate cell in Excel, one row for each record, the commas above are just used to describe the requirement E.g. A1=OrderCode, B1=OrderDate, C1=OrderInfo, D1=Item(line1), E1=Cost(line1), F1=Tax(line1), G1=Item(line2), H1=Cost(line2), I1=Tax(line2),etc Although we can put a cap on the lines to 20, it still seems a very tedious process to set-up a large temporary table and transpose the data from the master and line items into a long static record before running an Excel export. I know I could export in a more traditional format first into excel and then run a VBA script to transpose, but ideally I just want a one-click export from FileMaker... Any ideas/tips on how to achieve this easier in a script, without just hard coding it all? Thanks all (this will be an 8.5 and v9 system, so will need to work in v8.5 as well as v9)
  7. Thanks for that bcooney I'll have a look. We don't want to directly interact with the Exchange server (for all manner of reasons), just generating e-mails into the users Outlook. For batch PDFs I'm thinking of saving each one to a temporarily folder with an ID, then sending an e-mail, attaching the specific ID PDF, then looping through, I'm not sure any plug in will handle that. I can do it all in FMP, but obviously I'll get the Outlook alert every time a message gets sent! Any other ideas, thoughts and comments of achieving this and similar solutions?
  8. A system I'm working on needs to be able to generate batch e-mails for orders received each day. E-mail out to each person ordering. The end users want to print (or save) a PDF version of their "official" order form and attach this to the e-mail, then just have a basic piece of info in the email, e.g. "Dear Mr A your order 12345 is attached". Their systems run an Exchange server and Outlook 2000 and 2003 on the desktops. My idea is to create the PDFs and save with a ID number for the order, and then generate a filepath for attachment, if this is possible in the Send Mail script. The Save Records as PDF, has an option to attach to an e-mail, but it appears you can't script any details of the e-mail, so for a batch it'd be useless. If this isn't possible I'd want to create a highly structured HTML e-mail, matching their order form as close as possible, but can this be done via FMP? I've just run some basic send mail tests, firstly the mail seems to be always created in plain text, is there a way around this? Secondly batch e-mails, as no doubt you are aware fed into Outlook trigger the "a program is automatically trying to send e-mail..." alert to be displayed, requiring the user to click yes every 5 seconds for each message. Very tedious. I'm aware of tools such as ClickYes and in Access based systems, I've easily interacted with Outlook directly via VBA to prevent this happening. Thoughts, opinions and ideas please? As it doesn't seem as straight forward in FileMaker as it is using VBA... I've had a brief look at plug-ins like [color:blue]mail-it, but I think they would want mail going into Outlook first, rather than connecting directly out, as they are part of a large corporate network. (This project is using FMP v8.5 and Server v8 on Windows 2000 and XP - however if FMP v9 offers a better set of tools for batch emails, we can upgrade this project.)
  9. I assume you mean it's flickering constantly in all applications, rather than just in FileMaker? It if it's it's highly likely to be a screen or driver issue.
  10. Thanks Henk : Yes I'm aware of that, I use privileges on everything, but obviously some users need deletion access (but never delete all in my experience!). Therefore I wanted to make sure that with custom menus set at startup via scripts (in my case), depending on the user level, there is no quick way (or any way) for a curious user with non-admin access to bypass them and switch to full standard menus, which don't run custom code and may have "delete all" options. I think for many of us that have been developing since earlier versions (myself at starting at lowly v3!), especially in large systems where we have constantly migrated to new versions, many times the client doesn't have the budget for a full rewrite in the newer technology, so systems end up with compromises using various functions. I'm also curious to see if these three old menu options in privileges: "all", "editing only" and "minimum" are now rarely used, being just throw backs to the older versions. I still firmly believe that some of these custom menu functions should be integrated in the privilege sets for certain defaults, although some believe not!
  11. Clearly since FM introduced custom menus, there is a bit of a clash between the options in Privilege sets, (to allow users to have "All", "Editing only" or "Minimum" available menu commands), and then providing proper custom menus for your solution. Custom menus won't function fully unless users have "All" set in the available menu commands of their associated privilege set (i.e. custom menus are heavily disabled, and any new non-Filemaker related menus/menu items are completely unavailable.) I assume everyone who is using custom menus, is now allowing users with custom menu access, "Full" menus in the privilege settings. Is there any danger to this approach? The last thing any developer wants is a rogue user managing to bypass the custom menu and suddenly having access to Delete all and other lovely commands!
  12. I personally disagree, but each to their own! To be able to set a default menu set for each privilege level, within the Privilege dialog, rather than added extra code at start-up, would be a more elegant solution. Also it would be one area where you manage all standard group level restrictions. You could still override these in scripts later - giving more flexibility in my opinion (just my opinion though!). It also would be continuing in the way the three basic menu restrictions operate in Privileges: None, Minimal and Full. Seems logical to me...
  13. I agree, Vaughan that seems to be the best, and only method, I can devise too. What I really hope FM do is add a "default menu set" option to the Privilege sets - be a useful addition, and the more properties available the better.
  14. Ahh that's handy, will do this and check account privileges in the script so only Admin users can switch on full menus - great tip David :B
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.