Importing & Exporting

Hi, I'm new to the boards and to Filemaker Pro, so please bear with me: I have a giant list of contacts that is 180,000 rows, with columns such as name, address, company, state. The contacts are from all 50 states. I want to break down the giant list into 50 seperate lists, by U.S. state. Right now I'm just doing a CTL+F under the "State" column and typing "CA" for example, then exporting the list of California contacts to CSV. It works, but is very time consuming. Is there a way to make this faster? Maybe a script or macro I can create? I will be doing this every week, so trying to find an easier, more efficient solution. Thanks and please let me know if …

This is not so much about wanting a solution but about wanting to know the technical reasons behind the inability to import exif data with an import of images from a hard drive. As a photographer the usual workflow is to dump the CF or SD card data to HD first so it can be sorted, assessed etc. FMP11 can import the image's exif metadata from a 'device' such as a camera, smartphone or card reader but not from an image directory on a hard drive. I would prefer to import after this workflow step is completed and not directly from the camera. I know there are solutions to this problem via plugins, Java script integration, RAMDisk creation and so on but I would ju…

Dear friends, Could someone check my XSL. I simply want to achieve following XML: <invoices> <invoice> <inv_id>280587</inv_id> <inv_number>274218</inv_number> <inv_date>20140401</inv_date> <inv_exclbtw>18.50</inv_exclbtw> <inv_btw>3.89</inv_btw> <inv_inclbtw>22.39</inv_inclbtw> <pdf>true</pdf> <invoiceprojects> <invoiceproject> <project>SOHS35629</project> <projectdescription>Locatie: zzzzz</projectdescription> …

Greetings! Thanks ahead of time for any guidance  I have a library of musical cues. Each cue can be assigned up to 4 genre/subgenres. I have a Cue Entry Layout for the user to enter this and other data for each cue. It is based on the Cue Entry Table. I have 2 separate tables for Genre and Subgenre. I am pulling the Genre and Subgenre data through a portal into the Cue Entry Layout via a join table called cues_CATALOG. That data is populating 2 pop-up menus on Cue Entry. Here is the relationship graph:    I am importing data from an excel. First I import Title and Cue ID (using auto-enter during import for Cue ID) into the Cue Entry Table so that I have th…

Hi, I can't work out how to modify the attached stylesheet so that it works correctly with the attached XML source file. Would someone be kind enough to help me correct it? clients2.xml XSL_adresses_import stylesheet.xml

Hi folks, As a relative newcomer to FMP, I am trying to export some records and am having difficulty..... 2 of the tables in my database are: MANUFACTURER [mName, contact email, contact name] (approx 50 records) PRODUCT [pID, pName, description, price, mName] (approx 300 records) So, a manufacturer makes many products..... I want to export each manufacturers most expensive product, but only the top 10. This is probably quite straight forward, but I just cant quite get my head around it! Any help appreciated. I am using FMP 12 Many thanks Brian

I am importing data from Tab separated text file to one of the tables in FM file hosted on FM13 server. One of the fields in the table is "Price", defined as the number field. When I import Tab text file with "Add new records" option checked out, the "Price" fields are populated with the correct price in form xy.z (example 23.4). When I use the same Tab text file and set "Update matching record in found set", "Add remaining data as new records" and import the file, the "Price" field values change the values to xy,z (so 23.4 becomes 23,4 and so on). The system settings on FileMaker Pro side and Server Side are identical and set to use point as decimal symbol and comma as…

I was wondering if there is a way to disable to error message the pops up after a failed export. Even when error capture is on I still get a popup about being unable to create the file. The reason I need to do this is that I have a robot client running on the server machine and I can't have it waiting for someone to click ok after an export fails. I would rather be able to capture the error and make a report so I can check it later. I'm not sure why the export failed in the first place and obviously it would be better to just fix the problem, but for future problems I would like to avoid this issue. I'm using FMS 13 and FM 13 on a Windows 8 computer. Has anyone had a simi…

Apologise if this topic had already been posted. We have lots of pdf created by another application that are stored in a folder. I am using FM 13 with Server. I like to be able to import the entire folder at one go. My container option are set to stored externally and open. I do not see FM 13 have an option to do that. Do I need to write a script or a plugin can help ?

I'm converting a very old invoicing application in DOS (written in 1990) that is still used everyday at work, to a Filemaker Pro database. The default invoice starter solution in Filemaker Pro 13 will do perfectly, but importing the 20 years of data is what's bothering me and I really could use some tips & tricks. The old database files are .dbf (dBase) files, which Filemaker pro can import, but the old database has a few different columns. The customers are already imported, but the invoices table is a real problem. The old database uses one table, and Filemaker uses two. An invoices table and an invoices data table. This is a very basic visual representation wit…

Hi - I have a shrink wrapped solution that imports data from previous version into new version when I do an upgrade. I'm using FMP 13, and some of my users will be upgrading from FMP 11 versions. So I'll need to convert those databases before import. Obviously, it they already have a FMP12/13 version database, no conversion is necessary. However - my solution changes the file extension to the same extension regardless of the version - so I can't tell from file extension whether a conversion is needed. Is there some way to test a file via a script to see whether it's a pre-FMP12 version that needs to be converted? Thanks, Michael

Looking at changing our ecommerce shopping cart to Shopify. Is there a script that can be written or maybe it already exists, that can export orders from Shopify and import to our Filemaker data base?

Hello everyone, I am new to FM and the FM forums. I am working for an academic program that is in the process of digitizing all of its student/alumni records. Some of those records include an alumni questionnaire that is filled out on Google Forms, all the responses for which are then automatically recorded into a Google Spreadsheet. We want those data to regularly get pushed from the online spreadsheet into a FMP12Adv Table -- in other words, we want to sync that spreadsheet with a table in FMP12Adv. So far, I have found two ways of doing this: (1) Stop trying to pull data directly from the web and just download the spreadsheet so I can manually im…

Hello all. I've been using FM for years and years but really consider myself a novice who has never utilized some of the more sophisticated features of FM. I'm running FM 12.0v5. I've often wondered if I could do the following: I have a custom-created FM database which catalogs my large CD collection with fields such as "Artist", "Title", "Label", "Number" and so on. I've always dreamed that it would be great to add a container field to the database, and, based on the Artist, Title, Label and Number conduct an online search for the CD artwork and have an internet site(s) return and paste into the container field that artwork. I know Amazon is a good source of CD artwo…

Hi, i need to export a large number of records from FileMaker Pro into a distant database using the http POST operation. For this i am using an "Open URL" command (as suggested on FileMaker website for this protocol) and it works fine except that it is opening a numerous number of browser windows - one for each exported record. How do i stop this from happening? Thank you, Milan

I know this is a printout version of something, but this is the most clear version of my lab results. Is there any way that I can import from this html page? thanks :/ gg.zip

I have a client using FMP13 on a Windows8 computer, who is telling me that in the past she would copy text an email address or text from any program, for example outlook, and paste it in FM and once pasted the text would show as the default of FM Font and size. Now, and I do not know how or why, any copy and paste retains the font and size of the source. Can anyone point to where can I change this back to the original behavior?? Thank you! Eva

I have created a FMP12 solution for a doctors office. When a patient comes in for an exam, they automatically get a recall date; typically a year from their visit. I would like to do the following: At any given time, export a list of patients who are due to be recalled. Then, lets say a month later, export another list, but exclude any patients who were recalled in previous exports, so there's no overlap. Heres where it gets a bit complicated. In, say, 3 months of exporting as above, I would like to export patients who haven't responded to their first recall, as well as new recalls. Then, after a set amount of recalls (3), if the patient still hasn't returned…

I am new to Filemaker Pro and have successfully built a “Contacts’ database but am struggling to produce a “Project’ database. I want to store for each Customer the details of the on-going projects such as all the correspondence, emails, images and drawings relating to the project. I do not have a problem setting up the Customer details etc. but the storage element i.e. how do I get the external files into Filemaker, is giving me a problem. Can any one advise me please?

I have a file that contains data entered by various persons. Some of the data is in full caps, some in title case, and some in all lowercase. I want to export the data to an excel spreadsheet, and I need all of the fields to be in Title case. I can change the case in the FMP file, but when I export it the formatting does not go with the data. Is there any way to do this export with the formatting intact? TIA

I want to get a zip file that's on a link No user/password.. Its just a link, as if on a webpage, presents a DL dialog box.. Trying to use Insert from URL with dialog... Shows www.X.com/folder1/folder2/ABC.zip the designation is to a container field.. Viewing container field I seeing.... ABC.zip.html WITH extension added html? UPDATE.. TESTING THIS IS NOT A ZIP FILE Reading all the docs.. this command seems to refer that I can DL picture files.. so whats the difference? Where i am going wrong/// Thanks

Hello, I have a solution that creates a backup copy of the file when it is closed which can later be used for importing into an empty file. My only concern about the data and this backup scheme is what happens to external storage data. I know when I import data from its current location, it brings in the external storage data too. However, when a copy has been save, must I also copy that data folder to the backup location. I am assuming this is the case but wanted to consult other developers. Thanks! Stephen

Hi  Since from a long time development in Filemaker I am facing a strange issue while importing data from an excel file to my Filemaker application. In the excel (.xls/.xlsx) the data are showing correct (e.g. 1.1524) which is entered by me but when it get imported into Filemaker its showing a different value (e.g. 1.1524000000000001).  This issue was not showing if I do import for same data using CSV file into Filemaker. I have tried a lot by removing all type of formatting from the excel file even I made the column to text still on import the data in Filemaker is showing wrong data. Is there anybody faced the same issue and got any solution please share with m…

Is it possible to "Save Records as PDF" directly into a Container Field or must I go through the file system first? I know, it's only one more script step, but still it would be handy. Gary

Hi Everyone I am new here - so please be gentle with me. This thread is the nearest thing I have found so far relating to my problem. I need to convert? and load into FMP on a Macbook txt files of size about 2.2Gb. Here are a handful of lines from a file: 17|530|A||A|| 22|548|A||B|| 22|548|A||A|| 44|7003|P|2||| 52|8553|A||A|| If I extract a sample and use txt to find and convert to csv, the data pops in OK. My problem is the size of the files which are too big to change in txt. I have tried a number of file splitters from the web without success and I am very much a beginner with code writing - the last time was with my B…

I have two databases. One is production database that has live data in it (we'll call it Database A), and another database that is a test database that I'm developing new features on (we'll call it Database B ). I take a daily backup of Database A, and attempt to import the records (Using the File -> Import Records function in FileMaker Pro Advanced) from a table into Database B. Database A, in just one table, has 37,357 records, after import is finished, FileMaker says 59 records were skipped due to errors. No other details we're given. Not sure what is causing the errors with those 59 records, is there a way to get more detail? Or even an interactive way to …

I am building a database for managing activities in my cabinet shop. The database has two tables with similar fields. (Table 1) contains the fields: POSSIBLE TASK & QUALIFIED WORKER (Table 2) contains the fields: TASK DESCRIPTION & ASSIGNED WORKER (Table 1) is essentially like a grocery store. It contains all the possible ingredients (POSSIBLE TASK) to build any kitchen we might sell and all the possible vendors for the task (QUALIFIED WORKER). (Table 2) records are created on a cabinet by cabinet basis. Each time we sell a particular type of cabinet the tasks germane to that cabinet are imported from Table 1. The field QUALIFIED WO…

Hello, I have an inventory system running on Filemaker 11 and I would like to add pictures of my items into the database. The thing is I have over 20,000 items in my database and adding the images individually sounds like a chore. I already have the images named with the item number of the item it's a picture of, so is there a way I can automatically add images to my database based on the file name and the item number and have users connecting to the database on my Filemaker server be able to see them?

I have a shrinkwrap solution with a separate installer/updater file. That file contains the scripts that creates a temporary file of each of the old and the new FMP file, performs an import into the new file then compares the results and continues. When I prepare the installer, I need to have a copy of each of the old and new FMP files so the updater file can map the fields that are used in the temp files. The purpose of the structure is so I don't have to remap the fields or check the field mapping each time I do an update. Someone else has written this for me and I've generally still only used FMP 11. I understand that FMP 13 maintains field mapping by the field ID …

I am not sure if this is a scripting question or an importing question. I am trying to import found records from one table into another. Both tables reside in the same database. I would like to able to perform a FIND in Table B and have the found records imported into Table A. I can do this from the File menu. When I select "Import Records" I have to then select the file I want to import from. I would like this to be a one button process. I ALWAYS want to select the found records from same specific file. Is there a way to script this so that the user does not need to make any selections?

Is it possible to import records from one table into another? I have a database that I use to manage work orders at my cabinet shop. The database has two related tables. Much like a grocery store the first table contains all the possible ingredients of anything we might sell to any customer that comes in the door. The second table pulls data from the first table according to what the customer actually did buy. The first table has three fields. CATEGORY ::: PART ::: PROCESS This table contains all the thinks we sell and all of the processes it takes to produce them. Typical field values might be: CATEGORY: Sink Base PART: Plam Floor PROCESS: …

Hi I've been learning FileMaker for the past few months and are currently working with 2 versions of a database. I have a Deployed database and a Development database. The Development database is based off of the deployed version. I have been making changes to the Development version's layouts. The layout and field names in the Development version match all field names in the Deployed version, so I'm here trying to write a script that will import all data over from Deployed into Development. Preparation and thoughts: 1. Delete all records on all tables in Development version. 2. When I import records from Deployed into Development, the next auto-enter serial …

I am new to FileMaker and I am setting up my first database. I have created my first table and its fields as a test, and I have imported data from Excel spreadsheet. In my previous application I had a checkbox. This data exports into Excel as either the word True or the word False in each Excel cell. In FileMaker, I set up a checkbox for the imported field. I defined the FMP field as using a value list with only one possible value, True. My goal is to provide the user with a simple True/False choice, rather than True/False/Neither. I can then shorten the display box for this field in the layout so the Field Label is right next to a single box, and the box d…

I need a option to get the 2 fmp12 files to a remote location.. via email and, I think compressed.. data files can get bigger in time too And distribute this app to others, without additional cost, everyone spend for another plugin? Just wonder my options And can a fmp12 file be emailed safely, attached not compressed? Someone mention me way back, being causious Thanks

Why would an Import[] fail when run as a scheduled script on the server, but work when run from the cilent? I'm importing from one table in a file to another table in the same file using an FMS13 server with an FMP12 client. The error is 100 file not found. I've tried two protocols: file:My File fmnet:/wingforward12.dyndns.info/My File Both work when run as a client, but not on the server. Any thoughts?

The contractor who's setting up a CMS for us that includes MySQL databases populated by the XML feed from our database has given me the following request: feed contains this line <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "http://localhost:16020/fmi/xml/fmresultset.dtd"> He has asked me to restructure the feed leaving this line out. Can I do that (in FileMaker Server 13)? Is it a reasonable request?

Hi Everybody, I have this XML file <?xml version="1.0" encoding="UTF-8"?> <mascot_search_results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.matrixscience.com/xmlns/schema/mascot_search_results_2" xsi:schemaLocation="http://www.matrixscience.com/xmlns/schema/mascot_search_results_2 http://procyon.cnb.csic.es/mascot/xmlns/schema/mascot_search_results_2/mascot_search_results_2.xsd" majorVersion="2" minorVersion="2"> <hits> <hit number="1"> <protein accession="gi11841"> <prot_desc> ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit [Nicotiana tabacum]</prot_desc> <prot_score>2193&lt…

I have a large calculated field that creates a vCard for my contacts that I want to export in an ascii format file with the extension .VCF. Basically if I copy and past in a text editor and save as text with .VCf it works. I would like to remove a few of those steps. It looks like the xml may be the answer but I have no experience with it at all Thanks

I am trying to come up with an efficient method for importing Image References to a database I am creating. Part of this Database is an image repository. I have an Item Table, Join Table, and Table that holds file path references to images. This part works perfectly. Where I am running into issues is: When a Mac User imports a folder of images from our server, the syntax is different than someone using a Windows Computer. So when people view my database, if it was imported with a Mac, only mac users can see it, same way with Windows. Because the File Path is slightly different. The actual images sit on a server available to everyone on the network...…

Hi, I have a starnge situation. I added a new nightly sweep. I basically duplicated an exisitng progam and changed the tables so that data will now import to newly created tables. I have a schedular setup to run this every night. The schedular runs the programs, it goes the table layout, deletes the old records and imports nothing. the message says imported 0 records. But when I open this program and run it manually, it imports all the records. I checked to see that the file where the newly created tables are have Full access to delete, add and modify records. No restriction. What I am doing wrong? Please advise. Thanks in advance.

I'm trying to import an excel file that has an embedded Word document on each row. I want the Word documents to be imported in and saved on a networked drive. Is there anyway to do this? I would be OK with temp. storing docs in a Container field for the initial import. To insert the object into Excel, I'm using "Insert Object" , selecting the tab "Create from File" not "Create new" and browsing to the document and checking "Display as Icon". The specific application is importing timekeeping records with a related status report word document attached to each line. Any help or ideas on how to do this are appreciated. Thanks!

I'm in the process of importing data into FMP 6 using a .xls upload. I have no issues populating standard text fields. However, I cannot get checkboxes to populate on upload. I've matched up the fields to the column in the sheet and tried to use True in the field as well as the field name. Do you have any suggestions on how to populate check boxes on upload. Thanks!

I'm trying to move records between two Filemaker databases. One of the databases "Target" will be hosted on the server, one "Source" will be used on an iPad through Filemaker Go, however at the moment, they are both running locally on my workstation (from what I understand, I can only import from another local file using Filemaker Go, and Filemakers knowledge base article reflects this fact). I'm trying to migrate data from two individual tables, in both databases both called Table1 and Table2. On the source file, I've got a script that will go to the layout of table1, run a script (called import1) on the target database, import the table1 into table1. My script then …

Cannot open PC FMP records made from PC ver 5.01,to Mac Using FileMaker Pro 11, is there a “translator” that will import these older FMP PC ver 5.01 to FileMaker Pro 11 advanced 11.0v4 on Mac Mac Lion ? or any solution to this problem?

I would like to import an XML file into a Filemaker table. Filemaker is requesting a XSL stylesheet. How do I create one?

Hi Everybody, I have a FM database with 3 fields: FieldA, FieldB and FieldC. I would like to export the records to a plain text file but with this structure: FieldA_1 [space] FieldB_1 [carriage return] FieldC_1 [carriage return] [carriage return] FieldA_2 [space] FieldB_2 [carriage return] FieldC_2 [carriage return] [carriage return] FieldA_3 [space] FieldB_3 [carriage return] FieldC_3[carriage return] [carriage return] ..... Is it possible to export the data with this scheme? Could anyone help me? Thank you very much, Wardiam

Hello I would like to know if it is possible to automate the import of XML files that have different names. A client of ours wishes to send us XML-files containing order information (publishing company). The filenames are all different as they are the ID's of the advertiser, something like 12321_1111.XML. I have the .XSLT file ready for conversion into FMP, but now the next step is to automagically import them into FM. The XML's will be send to us via FTP and I would like FM to import them. Is this possible? To run an import script without defining the filename to be imported (is unknown until they arrive at our servers.) Thanks! JP

Greetings, I have manually put together a field calculation that formats proper geojson for my mapbox maps, this formats things fine. Where it doesn't do what I want is in the script loop, it always gives me only one result based on the sorting. I have also created another calculated field to list all of my other calculated fields and add the header and footer for geojson...same result, it always comes back with only one entry. Even if I try to loop another field, a text, number, whatever, still only one result. Then I tried to export my calculated fields as tab separated text, this gives me all the calculated fields, but then it does not seem easy to inj…

I run a simple import script on my Windows 7 Platform.  (see attached picture)  In the import dialog, I simple specify the file name without any path. That ensures it will always work, wherever the end user places the application on his hard drive.  As can be seen, the script step indicates Windows ANSI  However, the end user runs the application on Mac OS X. That script always returns empty records which is impossible.  Obviously, I need to add a Mac path in the script.  How can that be done on a Windows computer? Is it simpler to edit the script on the user's computer to have it properly configured?     Â

This may be nothing but don't understand what it is wanting me to fix. 2013-11-27 12:54:38.353 -0600 Servcall_Ipad::Customer_Name::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.361 -0600 Servcall_Ipad::Cust_Address::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.364 -0600 Servcall_Ipad::Cust_Phone::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.366 -0600 Servcall_Ipad::Cust_City::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.376 -0600 Servcall_Ipad::Cust_Phone_AC::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.378 -0600 Servcall_Ipad::Customer_Number::Field 10 Attribute “name” missing. 2013-11-27 12:54:38.379 -0600 Servcall_Ip…

Hi, everybody Im new here, but made a search in forum(s) and havent found any good advice. Converting Windows fp5 to fp7 using FMP 8.5, woud like to move to 12 or 13 version. Quiet complex database with lot of scripts, value lists, butons etc. Database content made on v5 using non-Unicode fonts and special characters (like - Lācis gāja mežā dzērvenes ēst Pity thing is - Value lists and even Scripts and Field names are sometimes made with such symbols (i told them dont use it on scripts and fields... but this was loooong time ago and even i dont remember this for sure So, Database itself converting and even looks something similar. All fonts are ok, specia…

Is it possible to have the user be prompted to choose a text file, and then have FM read it? There's a certain type of XML file that users will need to import more than once. I need a script to process the XML and add records. I have no problem parsing the XML file in script but I can't figure out a way to read a text file. Is there a script command that can prompt for a text/xml file? Or is there some file chooser UI field type? I tried using 'Open File' without specifying the location. That defaults to only select FM file types. If you change the dialog to show all file types, and then select a text file, it complains that FM didn't create the file (which it a…

I am struggling to create paths to save a pdf document on a Mac and Windows desktops. I don't want to save it in a folder just on the desktop. Any help will be appreciated

Hi all! I'm trying to simply export a field (or record if I have to) in RTF format so that the formatting I've assigned to this field's data (font, font size, style) will carry forth. Have tried every option I could find but none work. The resultant RTF file will be placed in InDesign ultimately, FWIW. Is this a job for Applescript? Thanks for any help!

Hello, I am exporting data in CSV UTF-8 format. There are 8444 records being exported, but for some reason, the CSV contains 8479 records. When I open the CSV in excel, I can see that there are two albums that have for some reason created a new blank record for every track in the album in addition to the track itself. The database relationship is 1 album has many tracks. Our website groups the tracks by album, so the album ID has to match the track ID. Since these new records only have an album ID and no track info (since they are blank), the website brings back an error and I currently cannot update data on our site. Does anyone have any insight as to why FM…

This may be related to other topics. If so I apologize, but I haven't found an answer. I'm a developer working in cross-channel marketing campaigns using variable data. I'm on a Mac (mountain lion) using FMP 12 Advanced. Variable QR code encoded data is generated for me on windows.net systems by my microsite hosting provider. The encoded data for a QR code consists of a string of characters followed by a vertical tab or line break, follow by another string and a vertical tab or line break and so on. I import the data into FMP to do further data work, export the data to a .mer or xlsx file. A variable data print file is produced using HP's Smart Stream Designer, wh…

Hello everyone, just nee a little input. My supplier("A") has provided me with there catalog in a excel spread sheet with item#, desc....etc.. So my question is would i import all that information in to my current product table which is in my One database or... would I create another Database just for this catalog(which will be updated year to year) and ref it as an external source? Also if I have supplier "B" send me there catalog would I combine the 2 together or keep it separate? Any suggestions would be helpful...maybe you faced something similar to this. Thanks -J

What is the quickest/easiest way to import records from one filemaker database to another? I have 2 solutions with identical tables with identical fields etc..? i.e.. if you were cloning a database.. how can I get the records from the original that i need and put them into the related tables??

Should be simple: how to move data between DB's with script? DB #1 is large, keeps track of several things, including when we need to write checks to other people. DB #2 is the checkbook, a simple flat DB. DB #1 tells us when to write checks, how much, etc. It knows everything. Then we manually key in that data to DB#2, and it prints the checks. I should be able to make a script that will take the data from DB#1, jump to DB#2, enter that data, and print the check. Can someone give me some general guidance as to how to approach this? Could I import DB#2 into DB#1 without the two being related? Maybe there's a better method in general to do that? Thank you…

I'm creating an update to a system which has several older versions, they are runtimes, each user backs up their data (into a special fp7 file) using an inbuilt script which saves various system settings in various fields, as well as other tables for their data. Everything is locked down, runtime kiosk. When they receive a new version they run a resoration procedure, which is a special import bringing in all their settings and data from the previous version's backup file: this could be v1 to v5, v2 to v5 etc. depending on their upgrade path. As the system has grown, new settings and features are of course added, and in newer versions I've added these to the backup…

Hi, I am trying to import a csv file and one column, supposed to be a timestamp column, contain only numbers, without any spaces, forward slashes, dashes and colons. Here is a sample: 20131025191900 I want to covert this number into something like 2013/13/25 19:19:00 Tried the GetAsTimestamp function, but it did not work. Will appreciate a lot if somebody has a sollution for my issue. Thanks in advance. Alex

I have several tables which I want to export to a TSV, but I wish to include a custom header at the top of the actual exported data. This custom header is comprised of the field comment of each field, NOT the field names themselves. Currently in my export script, I am adding the custom header row to the actual data, sorting it to the top, exporting, then deleting it. However, there seems to be a problem when users run the exporter concurrently, and actual data rows are being deleted occasionally instead of the headers. Because I can't figure out how this is happening, I want to eliminate the need to delete records at all in the export script. My new idea is to gen…

I am running a script that imports records from one table ( Table A ) into another ( Table B ) in the same database file. Here's what the script does: 1) Navigates to the table with the source records ( Table A ) and performs a find to pull out the records that will be imported into the other table ( Table B ). 2) Navigates to the destination table ( Table B ) and performs the [show All Records] script step 3) From Table B it imports (updating matching records) the found set from Table A. At this point I can see through the import dialogue that the records being imported are the correct found set. In this case a single (1) record. 4) Upon completion of the import,…

I am importing a folder of images into a table via the FM file>import records>folder dropdown. The import is successful and I can see the images on the host computer, but when I go to another client computer I have a "file not found" message. I put a calculation field on the table and it is returning: image:/Macintosh HD/Applications/FileMaker Pro 11/Web/images/10-163_002.JPG The images are visible on the host, on the IWP, but not on the client computers. And the same is true in reverse, if I upload the images from a shared folder on the server from a client computer the images are only viewable on the client computer and not on the host. I am su…

I am using FM 12 advanced  I have an import script that first deletes all tables and then imports tables from a previous, specified version.  Recently FM has decided that it will not remember the Source table for my Global table import.   I turn 'perform without dialog' OFF, change the Source table and everything works great. Then I turn 'perform without dialog' ON and it goes back to it's old way of not remembering the Source table.  What's the 'magic' trick here?  Thanks  ron

I know I have seen a 'best practices' list of how to move a new 'feature' from one file to another, but I am unable to find it anywhere. (I actually saw it at DevCon this year, in a presentation by Todd Geist, but it doesn't appear that the slides from his presentation are available...) Scenario: you have developed a feature in an offline file and now want to port it over to the live file. It has tables, fields, layouts, scripts, etc... I have seen a list of how to port the feature to the new file to minimize disturbances: 1) Import tables first (Fields come over with tables) 2) Copy scripts over ... etc. Anyone have such a list, or know where to find…

I have been using Excel to record the routine daily issue of items to different groups in a matrix layout, I use a different workbook for each month with worksheets for each group. Each item can have a different quantity issued on different days. The matrix takes the form of the item issued being the left hand column and the date issued the top row of the matrix, the quantity issued is recorded at the intersection. I'm hoping to be able to create a Filemaker solution but having difficulty importing the existing data in a useable format. Is it possible to import the quantity and date issued information as it is currently held in Excel? Hope this makes sense, any gu…

I apologize if a similar topic has already been covered. I've searched for most of the day for an answer and can't quite find the answer I need. What I'm trying to do is have a way customers can fill out a web form, submit it, and that data automatically populate into FileMaker. I feel like this is something that should be possible, and probably is but I just don't know about it. I'm pretty familiar with web design, web forms, html, php, etc. I'm just pretty new to FileMaker. Any help would be greatly appreciated.

I created script which runs Snapshot but when User runs it it says a toolbar must be open (which I keep hidden and locked). I do not understand how this is supposed to work. It is so exciting to be able to do it but nobody talks about how wonderful it is. Do they not talk about it because it just can't be used because most people hide the toolbar so they can't use it? Please someone what is the scoop? I have tried everything to use it and can't figure it out. It keeps saying it needs toolbar open but how can I open tool bar when it is clicked to run since it is not a real script where I can add a 'show toolbar' first. I need to hide toolbar when done. ps I ch…

I extorted data as csv file form somewhere and then i m trying to import this csv file into filemaker. But i want to import only those records which are not available means some specific records from csv to filemaker database.How to perform this?

I have developed a database in FileMaker that dates back to the first versions of the software on the PC. I am now using FM12 and would like to automate the manual file importing that I have been doing for years! I use the database in my own company (we provide loan examinations to commercial banks). The database contains all the loan and borrower information in the client bank's trial balance. Over the last 20 years I have obtained the raw data from my client banks in ASCII format from their various different service providers. Since the data varies widely from bank to bank I have always manually parsed the ascii data in Excel, then built my two related tables in…

Hi All, I am working on Exporting the data into excel. Whenever I tried to export in Excel the name of the column in the excel appeared as the name of the fields that I am using in tables. For Example : I have two table Table A: Fields: Roll, Name, Address Table B: Fields: Roll, Fee There is relationship between both these tables using fields Roll. Whenever I am exporting the records in Excel from Table B, it gives me column name like Roll, A::Name, A::Address, Fee but it should be in this way, Roll, Name, Address, Fee or whatever name I should use for column name. Hoping for quick reply ASAP. Thanks in advance.

Hi All I have a script that stores a path in a field to a Word document on my computer. I then use the Open URL script step to open this file. All works perfectly - I can open the file as can other users on other computers. The problem I have is if one user has the Word document open and then another user opens the same file it does not open this as read-only. If one opens the file from ones computer (not via the script) then Word warns the user that the file can only be opened as read-only. With both copies open in normal mode only the last saved version will be present. Is there anything I can do differently to ensure that subsequent openings of the Word fil…

Hey all, I am trying to export FM data to an excel or CSV file but the result isn't coming out like I would like it to. The data is Program/Style/Color, a program can have multiple styles, styles can have multiple colors. What I want is to have an excel or csv list of the above but what i am getting is... ProgramA - Style1 - Color1 BLANK - Style2 - Color2 BLANK - BLANK - Color2,2 ProgramB - Style1 - Color1 BLANK - BLANK - Color2 The export function is not filling up all the cells. Can this be corrected or is this a FM fail? Thanks Michael

Hi, I just got FM 12 (12.0v4 to be exact) so I'm new to it. I'm wondering if it's possible to import a batch of csv files in one shoot. I tried Import > Folder, then selected the folder where all the csv files are located, then clicked on "Text files" (rather than the default "Pictures and movies") but it won't work, I get "No files of the specified file type were found in the specified folder". Technically speaking I know that csv files aren't text files but there isn't a "Comma Separated" option which would be the correct one. Best,

i export a field text that contain "www.abc.com" using the xlsx format, the cell contain "www.abc.com" but it doesn't work as hyperlink, jusy copy it in to a new cell and it became a hyperlink. How to get the hyperlink directlly from filemaker export? Thank to all for the attention. Franco

I messed up. I imported some pictures as 'store reference' but in this instance, I need them inside the database in a container field because I need to move the folder. How do I now say to take that stored reference and replace it with the actual image?

I have a reporting table A called Maintenance which contain a lot a vehicle records and i want the total amount for a vehicle to display on another table called Dashboard when i select the vehicle number in a list on the dashboard and each vehicle selection will display the current total amount. Thanks for your help.

I have an scripted import (FM 12 Adv) that updates the current version of my application with whatever the prior version the user is using prior to getting the current version. As part of that script I know the Source::$$Path (including the filename) ... and I know the Source::$$Filename . These GLOBALS change depending on what file the user chooses to import. It seems that ExecuteSql *requires* the source table for the import 'Be On The Relationship Graph' before it can execute any commands. True? If so, how do I get (the unknown) $$Filename into the Relationship Graph so I can use ExecuteSQL? Also, FM does not seem to allow me to script the use of D…

I'm not finding much on the Error - 130. I'm trying to export a set of records to an xlsx (also tried xls) file but each time I get the 130 error (Files are damaged or missing and must be reinstalled) Is this because I don't actually have excel and only have Open Office? My question is, Do I need to reinstall FM or Excel? If you have any words of wisdom, they are much appreciated. TIA.

I have a membership app with a membership table. It is imperative that allow users to import data from a previous version into the current version.  I have a pretty simple import script that first opens a layout and deletes all the records. Then it opens the same layout imports the table information from a previous version matching on field names. This seems to work. But not really.   In the import I DO NOT check "Perform Auto Enter..." since I import the PK's from the previous version. The same for related tables.  Here is the situation. I have the PK showing in gray above the Members layout. It shows the PK of the selected record.  …

Hi There, On windows 7 x64 with FIlemaker 12 advanced V4 when using the "export field content" script function the content of the field is written in mac (roman) format and not ansi (utf8 would be better btw). This is a serious issue because some chars (carriage for example) are not read correctly under the platform (windows). Has anyone notice this behavior? It's a know bug/issue? Thanks a Lot, Rob

Dear fmforum,  i have a database with about 1000 items. each item has up to six images. i would like that each image has a filename that looks like this: "product id"_1.jpg the second image should have a filename that looks like this: "product id"_2.jpg  and so on.. where "product id" is the unique number for each item.  i have a script that exports the items image and changes its filename to: "product id"_x.jpg  is there a way to change the images filename when IMPORTING it to my database?  i attached a screenshot of my export filename script and another screenshot where you can see the difference between the filenames. the left one has the origi…

I have a file called People that contains Name & Phone number fields Then a related file called Addresses that contains address fields, which appear as related fields in the People file Addresses::Suburb etc How do I import both the names and addresses from a single external file? If I try to import into People file it doesn't display the related Address fields in the import dialog If I try to import into Addresses file it doesn't show the People ID (as its related) in the import dialog that I need to match the address records to Or am I missing something obvious in this process?

Hi, I am having issues importing a previously saved PDF in to a container field. It's throwing an "Unknown error: 20403" I have tried both: Insert PDF (with the appropriate imagemac: path prefix) and Insert File ( with filemac:) path prefix Script: $File = "filemac:/Macintosh HD/private/var/folders/tg/3bq5pqmn3mgdq7lbbw2p8l_r0000gn/T/S10.1/Myfile_02-14-2013_10:29:48_AM.pdf" // also tried desktop path files Go to Field [PDFContainer] Insert PDF[$File] or Insert File ["myTable::PDFContainer; $File"] The container field on the layout is set to allow interactive content I have tried defining the container as internal storage, and external st…

Good Afternoon, I recently built "Catch All" database that captures all of our orders from several different locations. (In-house, web, subscription programs, etc) This filemaker database is talking to UPS worldship through ODBC and with a keyed import from Worldship. We pull the needed data and then ship the package. One thing that UPS requires on packages is the attention field which I have mapped, but information is not always populated in that field. For example: (Filemaker Field - Worldship Field) Full Name - Name or Company Address Line 2 - Attention We don't always have data landing in the address line 2 field so the shipping department …

Hi Everybody, I am trying SQL Explorer from Seedcode (http://www.seedcode.com/filemaker-sql-explorer/) because it is a great option to create EXECUTESQL queries. I have found that with this tool it is possible to export my table data to an HTML grid (using jquery). This option is fantastics in my case to export my reports and upload to dropbox. Then I have used site44.com plugin to link my dropbox account and have my own "website". You can check the result here: http://proteomics.site44.com/S10/ The problem is that I want to modify the jquery files to get a Grid with subgrid as in this example: http://trirand.com/blog/jqgrid/jqgrid.html (in "Advanced" item > "G…

Please help this poor sole out. I am trying to do something so simple that I cant believe I cant figure it out. I want to insert a file into a field but I don't want a file I just want the dialog to show me a directory on my PC. I have setup a Global Variable called $$ImageLibrary but when I use the Add File and specify the location file:../Pictures/Cars/ it keeps giving me an error out saying it looking for a file or file does not exist. I don't want a specific file, I want the directly. Can I do this? Any direction would be awesome. Please email me at [email protected]. Thanks...

I am using FM 12 advanced.  I have a membership application that works well. My users have asked for the creation of an Address Book that will track 'unrelated' addresses of non-members. It works too.  The first version WITH the Address Book is v 1.22. All prior version DO NOT have the Address Book feature.  The Problem: When I Import v 1.21 into v 1.22, my import script seems to import records from Members (presumably since it can not find a v 1.21 AddressBook table).    I have tried this:  ... hoping that I could determine if the table existed in the Source file. But, it does not work. All I want to do is skip the AddressBook i…

This hasn't been a problem until now.  The source and target both have a table called GLOBAL. When I try and import into the Target Global FM shows a source of Members. I manually select a Source of GLOBAL. It imports. All is well..... until I run the import script again and then the Source reverts back to Members. I can not get FM to use a matching Source and Target .... grrrrr !  Waz going on? ? What is the 'trick'?   Â

Hi I have an Order Management System. I create a Revenue Report based on the month and year given by the user. When this report is exported into excel, I get one row of data and one empty row. I do not use any Group By while exporting. It is a simple export of data. When I look at the report in FMP, everything is fine. If anyone has come across this, please let me know. Thank you...

It's amazing to me that I'm having so much trouble with this, but I am. So, any help is really appreciated. I need to move records from one table to another. The tables are virtually identical with the same field names. In fact, I just duplicated the one table assuming it would be easy to just move them into the second table from the first. Guess I was wrong. I am currently running FM 12 Advanced and sharing it with an online hosting agency that specializes in hosting FM solutions. Right now we will have about 5 people sharing the FM solution, but eventually 20 or so. I've created a script that exports the found set of records in the first table to an excel f…

Hi. I've got an issue exporting to CSV file - that occurs both on my Windows and Mac versions of Filemaker. In short, I am importing a list of Active Directory objects into the table. No problem. User can then edit some attributes of each item. No problem. I then run a script to delete records that were not changed in previous step. No problem. I then add a new record and put text into the fields that will act as the header line for the resulting CSV file. No problem. I then export to the records to CSV file - so that will be the modified entries + header line. e.g. 3+1. The problem is that the content is duplicated the amount of times that there are recor…

The one-fits-all XSLT for FileMaker. Transforms arbitrary XML grammars and namespaces into FileMaker records. Every textnode or attribute one record. http://jensteich.de/fmfaq/export/universal-xslt-fur-den-import-beliebiger-xml-daten/

This one has 'bugged' me for years... In my scenario I frequently update my development file(s) with the latest data from the live system and then reload the development to the live server. This is all scripted and it works. The development and live files have identical credentials and do not use an automatic login method. In order to make the scripted methods work I have to use a File Open script step to avoid a credentials challenge on the Import Records script step. If, however I run a manual import I do not get challenged (even if the source file was not open) Why is there a difference between scripted and manual import methods?

I have a simple membership app whereby I have Members Table -<< Awards Members Table -<< Dues etc... This project has been going on for over 18 months and I have a couple of users who have 'cross linked' their primary keys. That is, I have placed a read only copy of the Primary Key on the Members layout and I can see that there are sometimes 2 members with the same Primary Key. Weird. (The PK is Auto Enter, Serial Number, X Prohibit Modification During Entry) Anyway, as I release current versions of my app, the users import the previous version. This is scripted and it works well. I would like to somehow cause each imported Member record…

I am planning to import a series of records, about 6000, with a XXX YY type of serial as primary key, XXX for ascending serial and YY for year data. I am then planning to use filemaker to take it from there and continue with any new inputted record with the same convention but, of course, auto calculated. This all seems straight forward, but I just want to run it by you guys in case there's some known glitch in that which I 'll have to be aware of before I begin.

I'm hoping this is possible but trawling through the FMP documentation and forums here hasn't resulted in a solution to what I'd like to do. Essentially I'd like to create a script that can merge the database with another database (where the table structure is guaranteed to be the same). Now that's basically importing from another FMP database several times (since each import can only handle one table). However, I'd like the user to be able to select the file to be imported, and not have the filepath hardcoded into the script. I realise this is possible by storing the filepath as a script parameter, but how can I bring up an "open file" dialog box in a nice way …

I have 12 DBF files that were linked together on a one to one basis in Lotus Approach. This was necessary because we need about 800 fields (most with lots of text) and Approach only allowed 4kb per record, as compared to FM's 2Gig. I can quickly import these into FM Pro 9 by simply creating new Tables, however I am then back to creating all those "one to one" relationships. I have been told that is not a good way to go. I have found that to create one table with all 800 fields is a very painstaking process of creating new fields one at a time, then painstakingly mapping the import, then doing the import to "Update matching records in the found set." Does …

I need to import data from a spreadsheet then spilt that data into different relational files. I have a person file that could take all the data initially but then I want to push that data into separate related files such as address, events, etc as that is how the legacy database is structured. Do I create a script or action that copies multiple fields at once and pushes them in to related files? If so how do I do that as I've only created scripts that copied individual fields before, not many at once. If someone has a previous example I could modify that would be great.