This stream auto-updates
Anjani101 started following Exporting excel file row wise to filemaker existing layout
Anjani101 posted a topic in FileMaker Marketplace DiscussionsHi everyone. I am trying to export data from excel which is in form of questionnaire to new file in Filemaker. I made similar layout in Filemaker with all questions. I wrote script Import records(source: "export file") Go to record/ request page[first] . This script is importing data to the new filemaker file but its not in sequence. My excel sheet has 10 questions with their question no. defined. But in layout i wrote every questions. While importing, i am getting all data in only one row. that is 10 data from excel in 10 records in filemaker but in same single row. whereas I want to import data according to the questions no. I have attached imges for reference if my question is confusing. Here in image we can see that the value of excel sheet is going to only one row in filemaker unlike it should be imported to different rows. Thanks,
Anjani101 joined the community
So, I have more information. Test system configuration VMWare SCALE OS Name Microsoft Windows Server 2012 R2 Datacenter Microsoft Windows Server 2012 R2 Standard Version 6.3.9600 Build 9600 6.3.9600 Build 9600 Other OS Description Not Available Not Available OS Manufacturer Microsoft Corporation Microsoft Corporation System Name SIS-TEST-A SIS-TEST System Manufacturer VMware, Inc. Red Hat System Model VMware Virtual Platform KVM System Type x64-based PC x64-based PC System SKU Processor Intel(R) Xeon(R) CPU E5606 @ 2.13GHz, 2133 Mhz, 2 Core(s), 2 Logical Processor(s) Common KVM processor, 2100 Mhz, 4 Core(s), 4 Logical Processor(s) Processor Intel(R) Xeon(R) CPU E5606 @ 2.13GHz, 2133 Mhz, 2 Core(s), 2 Logical Processor(s) BIOS Version/Date Phoenix Technologies LTD 6.00, 2/22/2012 Seabios 0.5.1, 1/1/2011 SMBIOS Version 2.4 2.4 Embedded Controller Version 0 255.255 BIOS Mode Legacy Legacy BaseBoard Manufacturer Intel Corporation BaseBoard Model Not Available BaseBoard Name Base Board Platform Role Desktop Desktop Secure Boot State Unsupported Unsupported PCR7 Configuration Not Available Not Available Windows Directory C:\Windows C:\Windows System Directory C:\Windows\system32 C:\Windows\system32 Boot Device \Device\HarddiskVolume1 \Device\HarddiskVolume1 Locale United States United States Hardware Abstraction Layer Version = "6.3.9600.17196" Version = "6.3.9600.17196" User Name -- -- Time Zone Pacific Daylight Time Pacific Daylight Time Installed Physical Memory (RAM) 8.00 GB 12.0 GB Total Physical Memory 8.00 GB 12.0 GB Available Physical Memory 2.79 GB 7.02 GB Total Virtual Memory 9.25 GB 13.8 GB Available Virtual Memory 4.08 GB 8.82 GB Page File Space 1.25 GB 1.81 GB Page File C:\pagefile.sys C:\pagefile.sys I ran a test of one of the problem forms on each server for 3 minutes and logged the statistics at 5 second intervals. Here are my averages. Category VMWare SCALE Network KB/sec In 24.97297297 6.447368421 Network KB/sec Out 85.32432432 22.65789474 Disk KB/sec Read 159.7297297 40.76315789 Disk KB/sec Written 102.8648649 53.73684211 Remote Calls/sec 138.4054054 36.05263158 Elapsed Time/call 1217.540541 802.4473684 Wait Time/call 4.216216216 0.578947368 I/O Time/call 186.5945946 5.710526316 The same solution on VMWare performs on average 6+ times better in screen response. The VMWare hardware is 6 years older than the SCALE hardware. I believe that the problem lies with possibly a generally poorer hardware. I base this on the Network, Disk, and Remote Call (cpu/memory) performance. Going back is not really an option, but I can move to actual hardware although I prefer VMs for their ease of management. Any thoughts?
[ANN] Productive Computing Expands Capabilities of Vessel Service Solutions to Work with QuickBooks Online
Productive Computing, Inc. posted a topic in FileMaker Product & Service AnnouncementsSan Diego, CA - June 27, 2017 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce the release of Vessel Service Solutions (VSS) version 126.96.36.199. This vertical market solution was designed for the marine assistance industry and operates as a virtual command center to manage vessel assistance orders. VSS version 188.8.131.52 now features compatibility with QuickBooks Online via the FM Books Connector Online Edition plug-in. What is VSS? VSS utilizes FileMaker Pro and FileMaker Go to allow BoatU.S. captains to fully digitalize the tow order process from beginning to end. As soon as distress calls are received, any employee has the ability to send mobile orders from the office or an iOS device to themselves or other in-field captains. The captain receives the order on an iPad and, after assisting the boater, updates and submits the order back to dispatch for final processing. "We're excited that VSS has shown such success in the industry and we're dedicated to continuing to improve upon the solution and expand its capability and compatibility. We're committed to providing a product that is equipped to help our clients succeed and offer the ability for further customizations." Marc Larochelle, CEO, Productive Computing, Inc. VSS QuickBooks Functionality VSS is designed to connect with a client's QuickBooks Desktop or Online file. The solution pulls a list of items from QuickBooks that captains can use to fill out orders for services rendered. Once reviewed, cases can be pushed to a client's QuickBooks file as invoices either one at a time or in batches. When payments are applied in QuickBooks, information about remaining balances and paid on dates can be pulled into VSS. The solution includes list views and visual icons to indicate a case's status in QuickBooks Desktop or Online. For more information on this solution, visit www.vesselservicesolutions.com. FileMaker Pro Support and Plug-in Integration: Do you have database enhancements you would like to have programmed? Want help getting a plug-in professionally installed into your FileMaker solution? We can help!The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today. About Productive Computing, Inc. Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms. Productive Computing, Inc. also produces Core4 CRM and Core5 Starter Edition, two off-the-shelf productivity solutions designed to automate your workflow, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third party applications including Outlook, QuickBooks, Apple Contacts and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners. In addition, Productive Computing, Inc. is a full-service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4, Core5, or Vessel Service Solutions under a SaaS (Software as a Service) pricing model. Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected Platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance Partner of the Year award. Productive Computing, Inc. 950 Boardwalk, Suite 205 San Marcos, CA 92078 www.ProductiveComputing.com firstname.lastname@example.org (760) 510-1200 Press Contacts: Productive Computing, Inc. Keith Larochelle (760) 510-1200 # # # ---------------------------------------------------
Thanks for the information. I actually had a colleague point me in the right direction. I failed to understand that in order to use a client, I had to have the plugin installed locally. It makes total sense, I would have known this if I was more familiar with FM Plugins.
Probably a "Connection disruption". Fairly standard. We get this ~25% of the time. Most clients are in an area with just 'ok' connectivity. Good enough for voice, data not so much. We have found a VPN connection helps by keeping the connection 'alive'. hth
Hello, We are in the process of updating our FileMakerGo on the iPads from 13 to 16 but we are running into an issue with the sync. We are currently running MirrorSync 2.3 but will eventually upgrade to 3. Meanwhile, we need to get FMGO 15 or 16 work with our current MirrorSync. The sync error doens't always show, sometimes it syncs and sometimes it doesn't. Any ideas? Thanks
I am building a medical database for use in webdirect For the past 3 versions of filemaker server (13,14,15), I have encountered the same problem When loading the styles to the browser, 95% of the time the design appears as normal. However, every now again certain pages load without the style, leaving a white screen with the text only My file is currently being hosted on filemaker server 15, but I think I will upgrade shortly to 16 I have been using a supported theme which I have adjusted to suit my needs it's very frustrating because it is preventing me from presenting the software outside the office, as I don't want this to happen during a presentation Has anyone experienced similar problems, and if so, have you managed to find a solution?
FIlip joined the community
PaddyM joined the community
ArthurT joined the community
Your calculation is a little awkward because it checks the same thing twice, but other than that it should work. Of course, any calculation that uses Get ( CurrentTime ) must be unstored. This may add unnecessary burden on reporting. Consider keeping the calculation stored, e.g. as = If ( Time Out ; Time Out - Time In ) and displaying the alternative calculation as a placeholder.
drose0321 replied to drose0321's topic in PrintingIt's complicated. Because we are a public interest law firm, many of our clients don't pay any fee. The point of the software is to let clients determine if they can file themselves (and then produce the necessary forms) or if they require assistance from us. The lawyers here are uncomfortable (from a liability and legal ethics standpoint) with storing "non-client" data on a server that we own or control. So, this is the compromise solution.
Internet plug-in adds new script steps and online help for FileMaker Pro 16. Alphen aan den Rijn, Netherlands, June 26, 2017–Troi today announced the immediate availability of Troi URL Plug-in 5.0 for FileMaker Pro 16. What is Troi URL Plug-in? Troi URL Plug-in can help you fill in forms on the Internet, all from FileMaker Pro. It also retrieves data or images from web sites. - use the POST command to fill in a web form and retrieve the result directly in FileMaker Pro - use the GET command to retrieve data - use the PUT command to to transfer files or upload data to web servers - use the DELETE command to delete items on web servers - use a secure connection (HTTPS) using SSL - get access to password protected web pages, including those that require OAuth authorization - get JPEG, PNG and GIF images directly into a container field - specify cookies and proxy server settings - send tweets to Twitter with ease! What is new in version 5.0? We rewrote Troi URL Plug-in for FileMaker 16 and it now has the following new functionality: - Tested and made compatible with FileMaker Pro 16. - Added new functionality to the TURL_Get function. When getting images, like jpegs the name of the image (like for example img_4321.jpg) is now also added to the container data. - Fixed a problem with creating the correct OAuth signature for parameters in the TURL_SendAuthorizedRequest function. - Fixed a problem with the TURL_SendAuthorizedRequest function for urls that contain extra parameters (after a question mark: like www.example.com?page=1). - Made various minor changes to the example files to better work with FileMaker Pro 16. - Updated the code by adding improved namespace handling to make the plug-in more robust. Extra features when running FileMaker Pro 16 Version 5.0 adds the following new features when running in FileMaker 16: - The URL Plug-in adds multiple script steps when running in FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps significantly expand the possible actions you can perform with FileMaker Pro. Only steps that perform an action have been added as a script step. Functions that just return information (like for example TURL_GetLastHTTPStatusCode) are only available as an external function. The following seven script steps are added: - Delete URL - Get URL - Post URL - Put URL - Reinitialize URL Plug-in - Send Authorization PIN URL - Send Authorized Request URL - Added new scripts to several example files, which demonstrate how to use the new external script steps of FileMaker Pro 16. The examples check if FileMaker Pro 16 is running and will select these new scripts. - Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane. Apart from these additions we fixed several bugs and made various further improvements. More detailed information on all changes and improvements implemented in Troi URL Plug-in 5.0 can be found at: https://www.troi.com/products/urlplugin/ Pricing & Availability A fully functional demo version of Troi URL Plug-in 5.0 is available for downloading at: https://www.troi.com/products/urlplugin/ Licenses cost US$ 79 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site. Upgrade information Version 5.0 needs a new registration. The upgrade is free for users who bought a license for Troi URL Plug-in on or after May 24, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after June 30, 2017. Upgrades from licenses bought before May 24, 2016 are available from US$ 49 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site. Contact information D. Budding Troi Automatisering Newsroom: https://www.troi.com/news/
Hi Shanzo and welcome to the FM Forums, Can you post a copy your file, so that we can better see what you are trying to do? Please read this topic by Ocean West, as it explains how to add a file ,and more. Anatomy of a Good Topic Lee
Lee Smith replied to littlered136's topic in PortalsHi Steve, There would be no benefit to others by posting this file. The original file was written by a develop who has sense past away, Sarah was only tweaking it for her use. All we did was changed a few calculations, added a couple of Custom Functions from Brian Dunning's site having to do with coloring text, and checked the box for sorting a relationship. In addition, Sarah worked out several things on her own. Lee
Hi All I am fairly new to FIlemaker and am working on a project that I want to have a few conditional value drop down lists for product entry. I want to have the ability to enter in multiple line items and have copied the fields to make up 5 lines. The issue I am having is that the drop-down menu selections populate all of the line items when something is selected. For example, if I select something in the first field, it selects the same section on all 5 lines I feel like I am missing something simple but have been banging my head on this for a while and I am not getting anywhere. Any help would be appreciated.
Steve Martino replied to littlered136's topic in PortalsCan you post the answer too?
littlered136 replied to littlered136's topic in Portalsabsolutely! Where to I tick that it is answered and complete??
Who's Online 3 Members, 0 Anonymous, 119 Guests (See full list)
Who Was Online70 Users were Online in the Last 24 Hours
- Lee Smith
- Paul Jansen
- Rick Whitelaw
- Josh Ormond
- Jonathan Hogle
- Ron Cates
- Mark Stuller
- Productive Computing, Inc.
- randall riggs
- Mike Duncan
- Wim Decorte
- john renfrew
- Steve Martino
- Ralph Learmont
- Steve A
- Ocean West
- Dave Ramsey
- Mr. Ignoramus
- Al Quimby
- Aussie John
- John May - Point In Space