Importing & Exporting

Hi there, I'm trying to find a way to import csv data from a URL. We already have some scripts importing xml data from url's but we now need to do the same for CSV. I don't want to download a file and then import that - just want to import directly from the url. Is this even possible?

Hi Guys can anyone advise me please with my following problem. I have a database (FM15) containing a field populated with the following example "AB12343-02-12345" I want to import a csv using "match existing records" matching only the "AB12343" element of the existing records. Then a new field is used to store the imported "AB12343" because i don't want to overwrite the completed field of "AB12343-02-12345" if no match exists it will create a new record. A big thank you for any Guru help on this!

Suppose I have a column of numbers in a text field and I wish to export that field. What happens is that only the last number of the column gets exported. If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works: all numbers are exported. The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers. So: is there any way to export a column of numbers (contained within one text field) to the disk?

Hi everyone. Using an application that was created wit FileMaker pro. (process master). I'm interesting in importing excel or csv data. Since it's a wrapper ABOVE filemaer I'm using I'm not entire sure of what the underlying DB is tho I would think it's 1 main table with lots of records. I should say at first, there is an option to export records from this SW into Excel amongst other things and the resulting xls file Does have column names There is an option to Import under File menu, which seems to enable loading files of any format. Is it likely as simple as importing a file with the same exaxct format/column names as the one the SW Export wi…

I’ve got a FM16 system that converts raw data (dimensions, etc.) into a SVG floor plan and elevations in the Web Viewer. However, my boss now needs me to use this same data to generate a DXF for integration with another system. Has anyone had experience doing this? I’ve been reviewing the DXF specifications, and it seems unfortunately nontrivial to me. Any guidance would be appreciated. Thanks so much!

Let's say I use FM as an inventory program for my company. I sell a bunch of pieces of wood. I want to somehow export these pieces, in a way where I can automatically import it to WooCommerce. Alright, so I am using FM15, but I'm curious as you would go about this.

Hello, does anyone know how can I upload a picture from my desk or any other folder in to a website with button "browse" using a script ? for exemple - first action select the file in the folder according to his name stored in a field then - click on "choose" the rest I can do but I can't find any way to do it >< here is a screenshot Thanks you

Hi, For some reason, I can import all 16,153 record except for the 1st record Looking back into the import step, the check box to "not import first record" is grayed and the check box is not checked. Any ideas ?? Any help I would be grateful.

Using the script step export field contents, I can not export the contents of a container field. Error message reads ...could not be created on this disk. use a different name, make more room on the disk or use a different disk. I know I have had this in years past, but I can not remember the fix for this. I found something about setting the fonts to .ttf, but I am on a mac running fmpa16. Any help would be much appreciated. David

I have an rtf string (imported from Oracle 11g) on which I've run a string replacement and now want to export using Export Records but it needs to be encoded in Western (Windows Latin 1). Can anyone help, please?

Hello all I'm a fairly experienced FileMaker Certified Developer and I have a challenge that I cannot think what the best solution might be. We need to export data held in FileMaker to an Excel file, but not just rows and columns of data starting at cell A1. The required Excel sheet has formatting, headings and totals here and there, and is designed as a quotation that you could hand to a customer. Does anyone have any ideas on how we could create a heavily formatted Excel sheet from FileMaker? It's needs to work on Windows 10 and Mac OS X. Maybe there is a way by exporting XML or HTML that Excel would import and magically format correctly. Or I wonder if V…

I am looking for a way to export to Excel format where I can control a great deal of details about the output formatting. I want my output to resemble this spreadsheet that I put together by hand. But I'd like it automated: https://goo.gl/GrNDDp So I'd like to be able to control row height, skipping rows, shading, etc. (I'd also like very detailed exporting to PDF too.) I'm assuming that I'll have to use a plugin to be able to do this? I Googled a little bit for plugins but wasn't sure if any of them do exactly what I want, so I thought I'd ask and get some opinions about plugins. Also... I also would like to be able to export fields based on sorting…

Hello Is there a simple way to import various files (more than 2000) where tabs separate 9 different fields so that each import would populate the fields as they are? The files are in UTF8 and PLAIN TEXT Importing them with the FileMaker function : FILE->IMPORT->TEXT FOLDER simply brings each file in one records wich is useless to me as I then need to script them to separate each chunk into a different field Importing each text file manually is impossible given the number of files in the folder Each file is properly formatted therefore there would be no "empty" fileds in the import process Any help would be highly appreciated Dan

Hi Guys I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards. I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other. I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. …

Can you export field labels from FileMaker? On import, you have the option to read the the first row as label or data, what about the other direction? Thank you.

Ahoy there ! I'm trying to make a xml import, but seams something I'm missing. The import access from the next link : http://www.sagasoft.ro/infoTert.php… The xslt it's here. When I'm importing, shows I have one record , but empty. Where I'm wrong. saga.xslt

I am currently using QuickBooks online. I have two years of data in quick books online, that I would like to import into FileMaker. Once done I will be canceling Quickbooks online. So my challenge is to get all my data from QuickBooks and imported into my invoice solution. So QuickBooks says they will let you download your data, but it comes as QBXML file, which I can't seem to figure a way to import and have all the things I need. Any suggestions. Clarence

Hi Folks, I'm having brain fade. My import isn't working and I can't work out what I'm doing wrong. Existing records are updated, but new ones aren't added. I'm importing an Excel file, matching existing records and adding new ones.I've attached grabs of the script and relevant dialogue. Can anyone see what I'm doing wrong please?! Cheers, Mike

I'm trying to find a way to export contacts from FM Server or FM Go and then import them into the Contacts iPhone app. Is there an easy way to make that happen because I don't see any import function in the iPhone Contacts app?

Hi 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 fo…

Hello all, This is my first post. Each year we do inventory in a retail location. We have 25 scanners that collect the barcodes that are counted and they include what tag/section number they have scanned. We auto send all the scanner files to 1 computer in a specific folder on that computer. However, they are tagged by scanner number, store number, day of the week and military time. I'm looking to find a way that filemaker can scan that import files from that folder every 10 minutes, import the file there and put in the file name into a specific field, append the end of the file to "imported" and move somewhere else (or at least not import again).…

Hello I have a simple database with various text files. I import text folders from TextWrangler , which allows me to manipulate the files very efficiently. I save the files as UNICODE (UTF-8) and Classic MAC CR which should be CHAR 13 in FMP13Advanced. I tried to import them all in every possible way including DOS, UTF-16 and everything else the software allows for importing, but the results are always the same. However if I try to manipulate the text files in my DB for reasons I cannot understand i can't find the CR using the PATTERFIND function, and I am unable to do a few simple tasks on my file. As I need to save the first line, always endng with a CR to a…

I've imported some data from various banking accounts for monitoring (just my accounts), but somehow over time some date-entries have been omitted. As I have commented on a lot I don't want to redo a raw import but identify what's missing. So I have a commented database that has date, debit and credit fields. I also have raw output (from online banking) databases that have the same fields. At the moment I've created 'missing data' database to import into that has a calculation field that adds together date&debit&credit fields that outputs as a number. Then I omit duplicates. It sort of works so far. Is there a more elegant/accurate way of doing this?

IN my db I have the following fields IMAGE (CONTAINS 14 FRAMES FROM A MOV FILES AS A JPG FILE) FILEPATH (TEXT FILE AS FOLLOWS: file://Data/Videos/MVI_9887.MOV) VIDEO A Container file where I would like to see the "file://Data/Videos/MVI_9887.MOV" In the DB I have several different records how can I create a SCRIPT AS SUCH GO TO FIELD VIDEO OPEN file://Data/Videos/MVI_9887.MOV I Don't want to keep the video file in the db but only look at it when needed The various INSERT QUICKTIME, URL and so on require me to set the actual file path for each MOVIE file and this is time consuming as I have more than 1200 records, therefore 1200 movi…

Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solut…

Spec: Filemaker 9 on window 7 computer. So I have some columns that need to be combine into one but I don't want to use Concatenation as a field because it creates quotes whenever I copy and paste. The example: Name = Nick Field Name A - Nick A (this is produced from entering the name Nick) Field Name B - Nick B (this is produced from entering the name Nick) FYI - Field Name A and B must in the same record. When I export I want Nick A to be first row and then Nick B to be second row is that possible? Right now as it sits it looks like the attached. Any suggestions?

I'm creating a script for importing a csv file. That file will get imported every week. I don't want to present a dialog box to user for mapping field since they might make mistake. However, there's a problem. The file's column order keeps on changing. So, I can't use the last import order. Is there anyway I can import records on the basis of column title? I know there's matching field name option but the problem is the column title of the csv file are like "Refunds ($)" and I can't name the filed using special characters like (, $ in filemaker. Any solution?

Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!

I'm looking for a method of authenticating with google via FileMaker. I would like to run post commands via the Insert from URL command to allow my FMDB to publish Cal Events to a specific calendar. Realistically I'd want this to be automatic when an appointment is assigned on the system. At the moment, I can get a post to work, but it returns an error. I imagine this is because the authentication hasn't taken place. Has anyone managed to get a working OAuth 2.0 setup/Google Login on Filemaker that will work with POST and GETs. Once I've got Calendar to work, then I want to start on Drive and Gmail. Thanks!

Hello, We have a solution to store pictures(JPEG and NEF) from a photographer. I am trying to mass import the raw files(.NEF) into containers but I have an error message saying 'This file could not be translated using the selected file type'. It is possible to drag and drop or File->Insert the file into the container directly but I can't import them from the folder. Is this impossible to import files from folder with extensions other than the basic ones? (jpeg, pdf, jpg, png etc) Thanks!

in filemaker is it possible to save or export the record browsed to image formats like .jpg .jpeg or .png ....... if yes plz guide me tx

Hi there, I have a bit of a challenge and was wondering if anyone has come across anything similar and could guide me in the right direction. I have a invoice line table where there are multiple records for one invoice. I need to post those multiple lines using the insert from URL function in one single post. Now before I go further. I am currently using the insert from URL in a number of scripts for the exact same purpose but in each case I am only ever posting one record at a time. This works just fine. So I'm not a complete newbie at this function. What I can't seem to get my head around is how I can get multiple records into my http post …

I'm trying to export my records data in a specific XML format. What is the best way to do this, configure a layout in the way I would like the data exported or? Please see pictures - thanks!

When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute? Usually it looks like <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Yet sometimes it looks like this <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Then again when querying the XML RPC it always look like this <datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="0" /> Asking the question myself, answering the question mysel…

I'm aware of filemaker being able to pull data from a specific website but is there a way for filmmaker to also input into fields on a specific website and interact with buttons within a script? Thank You Matt

I have a file created in version 11.0v4 (Mac) which has several import scripts in it, importing from one table to another. It indicates on the Import script-steps: Import Records ( "$pathToMe" ; Add ; Windows (ANSI) ] If I convert the file to version 12 and open it in version 12, every one of the import script steps display same thing. However, if I instead open the fp7 version 11 file in version 13, 14 or 15, all of the import script steps instead display: Import Records [ "$pathToMe" ; Add ; Korean (EUC-KR) ] Nothing has changed in the file between when it was fmpa11.0v4 and the next version. I converted the files immediately, closing the version …

Hi, I would like to know of how well Filemaker can handle large amounts of data in a table. Our current system which is not in Filemaker, gets record with passenger information through xml . We get records as soon as they are available , sometimes 10 to 20 records an hour. On a weekly basis we would have about 4000 records. How would I store these records so they can be viewed later on for reporting purposes? I can imagine how big the database would get within a year or two. There will also be about 40 concurrent connections through iPad . Employees that connect through iPad will only have access to about 2 or 3 layouts. Its a dispatch system. Will …

Hi guys! I'm having problems when exporting the data inside a portal, there are two portals on the layout but only one is viewable and the other is hidden, the portal that I want to export also has a filter . I'm using the export records option found in filemaker pro 14. This is the portal (it's in spanish): this is the export (I put the field names in english):

Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic. If you cannot find one then you may delete this text and post your topic in this forum. I´m trying to get html data from URL wich uses httppost request, and the function didn´t work, returning error 10. Someone knows what´s wrong? Maybe some security issue?

I am trying to create a list of dates from multiple tables to create a gantt chart. My projects have Shipping dates, Installation dates and task item dates. Each of which come from their own tables. Is there a good way to import all of these dates into one table related to the project, each with it's own record of Start date and end date. I'd rather have: Project | Item | Start_Date | End_Date| than: Project | Install_Start_Date | Install_End_Date| Ship_date | Ship_Arrive_Date | Task_Start_Date | Task_End_date

Good day FM gurus, I am having an issue when importing a "CVS" file into FM. I am receiving a daily file from a PBX, this file is in "CSV", one of the columns contain the start or the call and is formatted "11/9/2016 7:17", but when I do an import into FM it imports its as "2016-11-10 07:44:24", yes the field is formatted as a timestamp. The only way I can get the import to work, is if I open the file in excel and save it at "xlsl" then it will import it as a time stamp. What am I doing wrong.

I posted about this before (see attached link) but was never really able to apply the solution successfully. This time I'm adding a file showing three related tables (parent, child, grandchild). The client wants one spreadsheet with all the data in it. In other words, the parent records will repeat for each child record and so on. When I export by simply grabbing the fields I need, I need to drag down the resulting export table to fill in those repeating fields, which is time consuming. If there is a way to script the process to have a one button solution, that would be superb. Merging_to_Flat_Table.fmp12

Hi, A newbie here. I used to be able to Save/Send records as an excel file. Now that I am running Mac OS 10.10 on a Power Pc, Intel Core, iMac I get a notification that Rosetta is required. One problem, I have been told in the Mac world that Rosetta is no longer available after 10.6 and that a FileMaker upgrade for Pro 11 might be needed. Im fine with this but want to be certain that it will do the trick. If so, how high in FileMaker Pro do I have to upgrade to? Thanks

Hi All. I am trying to do a scripted import using PSOS. The import is importing from one table in my file to another. The source table is a table occurrence in the current file with an external data source from another file hosted on the same server. It fails with an error of 100 file missing Is this not possible with PSOS? I saw where PSOS could only import from the documents folder on the server but I wasn't sure if that also eliminated importing from one table to another in the same file. Just wanting to know if it's just not doable or if there is something else I should be looking for?

I have a script to import an Excel file into an FM Table. I have my FM Script setup to Import Records with Arrange by: LAST ORDER. But it won't do this. Every time I run this script it gets the field mappings wrong. Reverts them back to before. Ironically when I do it manually it works. Any ideas? (I have this type of scripted import working fine for other tables) (I tried shifting the order of the fields in the actual database table as well -- but that has no effect either.)

I would like to export a subset of records from a table for use in a FMGo database. When I use the export script step, all the records are exported. Is there a way to only export the found set of records? Is there another way to export a subset of the records from a table? Any help would be much appreciated. Thanks in advance.

Hi, I am trying to import data from an xml style sheet, however the import always imports the data into the 1st record, even though I'm clicking on the "button" on the 2nd record ?? Can anybody explain why the "import" import into the 1st record and how would I import into the record I am on ?? The 2nd records remains the "Focus" record through out each script step ... confused ? Thank you. Please see attached "Update Currency" script. updatecurrencyscript.pdf

Hi FMers, I'm trying to get multiple choice quiz questions into a FileMaker database. The information is in a plain text file. Question and options are simply separated by returns: Where in the cell is the genome located? Mostly in the cytosol. Mostly in the mitochondria. [X] Mostly in the nucleus. Stored in the membrane. Stored in RNA. Next question... Each question has 5 options, one of which is correct [X]. There's an empty line between questions. What's a good approach to get this into a FileMaker database with separate fields for the questions, the options, and the correct solution? All the best

I am trying to open my (local) FM 14 Pro file [which has an auto-exec "Import Script"] but the script needs a variable file name. How do I pass this variable file name into Filemaker at 1) the time of the file open or 2) at the time of running the script (if I switch to manual execution)? Is #1 by using the fmp:// syntax from a web browser external to FM? (or is that syntax just for use when invoked from INSIDE a FM file?)

All, First off, this really isn't a Filemaker question, it's more of a general web question. I'm working on an FM database for a real estate agent and one of the things I would like her to be able to do it look up some county property information from the county's website: http://www16.co.hennepin.mn.us/pins/addrsrch.jsp Ideally I would llke to be able to have her push a button in FM and the have the information passed to the county website and execute the search based on house number and street name. If that is not possible without plugins I would settle for just having the two fields on the webpage automatically filled in and the agent could press th…

If I make an export to at TAB-delimited CSV-file there is no header (first line with field names). Why and how do I add this automaticly?

I'm needing to export XML to a customer format. I've built a staging Table to get the needed data out. Need some guidance on how/were to start on building out the XSL. I've been scouring the web for help, but I'm still pretty confused. I've attached the sample data coming out of FM and a sample xml of the format I'm needing to match. Any help would be greatly appreciated. FMdata.xml ShipAck.xml

Hello I need a hint.. I have a file with to many fields I only need to report on a half dozen fields How can I do that to text or PDF Thanks

What would be the best approach to export sample data, that can be re-imported and still retain the necessary parent-child relationships, to provide a clean imported db as development proceeds. I am developing a db, and have 100 records each in an account, contact and product tables. I will be creating children records for these tables, that I would also like to export, as part of the sample data. During development I will be adding and deleting fields from some of these tables. I've created the script to delete the specific tables and reset the serial numbers so the clean sample data can be imported, when needed.

I'm using Filemaker Pro 11 in Windows 7, trying to automate the exporting of files from container fields. I've written a script that goes through all the records to export the files in the container fields while skipping empty container fields. The code works well, except that there are a number of records with container fields where I get the "Container fields cannot be exported." error. When I try go to these records and try manually exporting the container field contents by right clicking, the "Export Field Contents..." option is grayed out, though I am able to open the document and then manually save it. There are, however, way too many of these cases for me to pr…

I have privilege sets that have "View Only" set for some fields but I need those users to be able to import new data into those fields and not be able to modify the data. It appears I can't import the data because the user is set to "View Only". Would the better practice be to give those users "access" to the fields so they can import data but force them to only be able to go to layouts where that data is "View Only"?

So I have imported contact names in a fm contacts file from excel. Now how do I add the unique id numbers? Lori I have just figured it out. Sorry for the inconvenience. Hope there is nothing else I needed to do with the import. Happy Friday, Lori

Hi, I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters): Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"] Go to Layout ["files" (files)] Import Records [No dialog; "$FileList"; Add; UTF-8] When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error: The previous script step, "Perform Script on Server", could not be completed because of an error.... If I run Get ( LastError), I get error code 100 (File is missing) I have tried many different file locations for the textile…

We need to be able to upload files to a container field via the web in FM12…is it possible? IWP or PHP?

Dear all,  I'm having a problem in my Filemaker solution when insertion files in a container via script and also drag and drop. It worked fine fore more than 5 years and now i'm getting this strange massage (attached). The problem is not stable, because sometimes we don't see it. Also in some Macs it doesn't work at all.  I've tried to find a solution in the web, but i didn't found any solution. Is this a filemaker bug?  I really need an urgent helpÂ

I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK. However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours. I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout? Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours

Apparently, I deleted my original post. Beverly said I should, "update with any auto-entered FM primary key into the child foreign key via the temporary relationship" I am thinking this is correct but have never done this before. Can someone help me understand how to do this? Here is a simplified version of my xml: <!-- some of the data from the attribute tags goes in the Claim table --> <result check_number="01574380" eraid="2182629" paid_amount="34.00" paid_date="2016-02-05" payer_name="" payerid="" prov_name="" prov_npi=""> <!-- some the data from the attribute tags goes in the Claim table --> <claim from_dos="20160…

Hi, I am having trouble with writing a style sheet, when I run my script that call for the import I get a error code 719 which is the "Unable to Translate" ?? Anyway ... Here is my xml link; http://www.floatrates.com/daily/usd.xml Here is my style sheet <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="01-11-2012" N…

I have a simple contact solution with just a table. I need to import my contacts pictures from a folder. All pictures have been named using an ID, which matches the ID field on the contact table. Please how do Import these photos so as to match the ID field . I am familiar with importing from csv and excel files but not this one. Thanks.

Hi- In number formats, my system uses a period for decimal and a comma as thousands separator. I have a number field set up the same way. Some of the records I need to import from .csv files use the European notation (comma for decimal, period for thousands). I'd like to change the European formatting to match my system format, preferably on import, but I can't find a way to do this. An alternative would be to do this with a script after importing, but it would need to apply only to numbers that need the format change. I tried a simple script that divides the number by 100, but if I accidentally applied this across all records it would create a mess that …

I am wondering if there is a way to import the contents of a CVS file into 1 field, much in the same way you can import the contents of a txt file into a field. Thank you, Fed

Hello, I have a small problem before importing an Excel file in Filemaker As I run a macro on Windows all goes well the work is done corectement to use the file to import into Filemaker But on Mac that does not work I tried with several Excel and of course Windows Excel for Mac I think this is the path for the error message, this is the way: sPath = "C: \ input \" Thank you

Hi My scenario is, when I used to RUN a Import (Folder with Import only the reference) script from a iMac mini to remote Windows File server, it used to take 4-8 hours. But when started using the same script from Same server(Windows), it started to take more than 24 hours. Only things I have changed: Import from Windows FS ( Files of type Windows from OS X) Modified the Folder location to local server. Any suggestions or known issues.. Pls note: Previously we used Filemaker 10-11 now using 13-14 in both client server. The old Mac was OS X (10.5.8) with FM Advanced 10. And the old remote server was a Physical windows 2008 server with FM 1…

Has anyone been able to scrape facebook for posts? Is there a successful or better approach other than using webviewer to grab html? Thanks

I've taken an existing database and deleted all of the records out of it to create a sort of "template" database for other purposes. The original database had a sizable amount of records, but they're all gone... However this empty database is over 200MB! When I did this same exercise a few months ago, it was around 70MB. I've made minimal schema changes, I don't have much for graphics, and I have saved a compacted copy and it is still over 200MB. Does anyone have any ideas for shrinking that up further? I'd like to get it below 100MB to make it transferable to an iPad. Thanks, Ryan

Hi everyone, We're having an issue when we do a copy and paste, whether between layouts or to an external program, that means the record number is pasted rather than the data in the field from said record. This is happening more often than not, but of course it will occasionally paste correctly - just to add to the frustration. I've had a bit of a look around but can't find anything on the forums. Any ideas about why this is happening and what can be done to fix it? Thanks! Jenni.

Hello I am trying to write a script which exports a set of records in fp7 format. the filename is appended by the current date. In the first instance I can't get the filepath to work. I can get it to work by just entering a filename into the export files dialog box ie file:filename, but this dumps the file into the Filemaker Pro folder or I can get it to work by putting the entire filepath. filemac:/Volume/Users/admin/desktop/filemame the problem is this would only work on my computer and this is a shared database - is there a generic filepath I can use which could solve this I have tried various combinations For example file:/desktop/filename But …

Is it possible to use "Export Field Contents" to export as utf-8 rather than utf-16?

I am looking for, a script or method, so I can import records from CSV to another related table fields ! How is that possible

Hi All I am still considering myself a newbie and my query may have been dealt with before. I have a database which has a portal displaying records from a related table. I have exported all the records in this table as an Excel spreadsheet but, as a test on importing records into a clone of my database, I find that the Import Field Mapping dialog box where you match source fields from the Excel spreadsheet with the target fields in the Filemaker database, related tables are greyed out. Does this mean that I cannot import to records from the Excel spreadsheet to the records in the related table in the portal? Frank

I wonder why the different variations of delimited text files does'nt contain a first row with field names (except for merge files). I make several exports every day and it's quite anoying and time consuming to do it manually by copy/paste every time. 1. Why is it so? 2. How can I make Filemaker to include theese field names?

I have exported a contact list from another contact manager, In the original contact manager,I was able to create sub levels beneath each top item. The exported file now has all of the levels as an Excel flat file, with the appropriate sub level beneath the correct item.I know FM does not implement sub levels so I was planning to import the top level into FM, and the sub levels into a notes file.How could I set this up so I can relate the correct sub level data to the main item in FM. Either during import or after it is in FM. Thanks

I am using FM14 x64 and trying to import a large 2GB CSV into Filemaker but it crashes. I also have data in a FMP12 database that I am trying to import directly into a newer FMP12 database. I am having crashing issues importing large files into FileMaker. So, last night, I decided to load the latest FileMaker x64 demo on four computers and try to import the data. When I got up this morning, FM had closed on each computer without finishing the import. On three of the computers, Filemaker closed without giving an error message. Those three use SSD's. On my 4th computer which uses SATA, I did receive an error. Not sure if hard drive type has anything to do with it.…

Hello, I have two tables: one is company and the other is contacts. One to many relationship in between. I want to import contacts from different FM database into this one, but the problem is : I have one table in that db for company and contacts(like contact1...contact12) and separate tables in which I am importing to. I fear I have to start fresh entering 1500 records manually and their contacts. Please help!

Environment: Windows 7 with FileMaker Pro 14. I have a test database that I am currently making changes to. I saved the test database as a clone, so that I could test importing data back into it. the Import functions allows me to import the first table of information just fine, but it will not let me import any other tables. On any subsequent import, I can select the source table from my source file, but all of the target files are grayed out, except for the first file to which I was able to import into. What am I doing wrong? I will need to do this on a regular basis, as I will use this technique to move my changes into the live environment. Thanks, …

I have an email folder where I have stored all emails discussing the program being written. It has my questions and responses from bosses and employees as back and forth emails. I want to move those emails or link them somehow so that when in FM there is table that developer can review which has the emails. They can search for words or phrases and find all discussions made by the bosses and staff about it. I found Developer Tools which shows html like this <html class="js canvas no-touch websqldatabase indexeddb draganddrop cssanimations csstransforms3d video audio localstorage applicationcache" lang="en"><head><style id="mceDefaultStyles" type=…

It has been covered here but I really can't find a sufficient answer. When I do an automated import of an xlsx file that has no blank lines at the top into a portal that is part of a child relationship I keep getting blank lines. I've confirmed that there are no blank rows in the excel spreadsheet. For the particular import I'm talking about i get one blank line at the top (portal is not sorted in any way). I also get two blank lines at the bottom. I can almost understand the blank lines at the bottom (how does FM know when to stop?) but I cannot wrap my head around why I have one at the beginning

Hi, I am trying to "Name" my text file when I export "A" field content. However "Filemaker" uses the data within the "Field" to "Name" the .txt file ?? Please see attached script steps and pic of .txt file exported. How can I export the "Contents" of a "Field" where I can "Name" the file. My normal naming conventions for lets say "PDF's" doesn't work for a .txt file ?? Thank you. Tom

Hi Everyone, I'd greatly appreciate your help - I've got 2 excel files that I want to import into my DB. When I import the data into FM, I would like FM to add the figures together rather than overwrite them. For example: on file1.xlsx Dave = 6 on file2.xlsx Dave = 4 I would like to import both files, and to end up with Dave = 10, but all i can do is get FM to overwrite the data, so that I get either 6 or 4. Is this possible? Many thanks,

Hi All, Sorry if the title is a bit confusing, I wasn't sure how to explain it. Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters) the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002. I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in t…

In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens). The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct res…

Hello all, I am having a bit of trouble figuring out a way to obtain my goal. My goal is to use Filemaker as a database for contacts, and then, upon the pressing of a button, exporting that contact info into an already existing Excel file, in which it would either add a new entry into the database, or modify an existing one based on the name. I am essentially using both Filemaker and Excel as the same database, but Filemaker modifies Excel, and not the other way around. My attempts from my limited Filemaker usage have been to Export the filemaker document as an excel workbook. So therefore, it would just re-save the database, and any changes would be…

I develop in an environment with a 50/50 mix of Macs and PCs and have many scripts that either export or save records out to a directory on a server. On PCs, this is very straightforward: just enter the output file path and the file saves, no other interaction required. On Macs, the only way this works is if the specific drive the directory is in gets mapped to each user's computer. This is problematic for a bunch of reasons, namely that it means extra steps and we have users who regularly delete the mounted drives and then wonder why the scripts stop working. Is there a trick for Macs that I'm just missing?

Hi there, I have a field that has been altered for more than 100 000 records to the same value, it is a number field - I would like to know if it is possible to restore the old values for this field from a latest backup, importing only for this field. please help and many thanks, Miss Amen

Hi please can someone help me when i insert a pdf i get a message not enough disk space and only get a referance file

Hi i made a export from my calculated xml data. Using a simple stylesheet to export my calculated field and clean up the FMP xml code. <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/"> <xsl:value-of select="." disable-output-escaping="yes" /> </xsl:template> </xsl:stylesheet> I only need 1 field to be exported. That contains all my xm…

I know I need and xslt to import XML into the proper fields in filemaker. Is their a way to capture the entire xml file as a single text field? I tried using this ssl but it removes all the formatting of the xml data. <?xml version='1.0' encoding='UTF-8'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="InputXML" TYPE="TEXT"/> </METADATA> <RESULTSET> <ROW> <COL> <DATA><xsl:value-of select…

So the company I am working for just picked up a huge contract with a cruise line, where we are going to be surveying some of their hardware and other equipment, guess who has two thumbs and is the lucky son of a gun to make the database for this project? This guy! Anyways, I can't really go into detail for legal reasons, but I can explain what I am looking for. I'm wondering if there is a way to export the records from the database in filemaker to an existing Excel spreadsheet, and the biggest reason this is the route I'm trying to go is, I based the solution that I've build thus far on the spreadsheet deliverable that they had given us at the beginning of the bi…

A client of mine wants to tie their solution to Converge (https://www.myvirtualmerchant.com/VirtualMerchant/). They offer an XML option, so it look feasible, but I was wondering if anyone else has tied a Filemaker solution to Converge's API? Also, with the new EMV Chip Cards, does anyone recommend any particular payment gateway for Filemaker? Or do the new chip cards not affect anything? Any and all info about payment API's most welcome. FM Pro and Server 14, Mac OS X environment. Thanks!

Hi, Is it possible to have a form on my web site that a user can fill out their information and when they hit submit it sends the POST data directly to my FileMaker 14 database? I do not want to use web direct or have to grab the data any other way. I want to be able to POST it directly.

I have a script that works correctly on a server machine when running within FileMaker Pro 13, but raises errors when run within FileMaker Server 13. Both are running under Windows. The portion that is raising the error is an `Import Record` script step that imports from one table within a file into another table within the same file. The error returned is 100, "File is missing," so I'm wondering if this is something not supported when running a script within FileMaker Server. If that's the case, I'm thinking that perhaps exporting the records to a temporary file and importing from that might be a workaround, but before I start down that road, I want to check and see if …

I have a simple database with two Tables: Donors (one) and Donations (many). I'm trying to export a CSV file that lists all the donations grouped 'By Donor' -- so that in Column A we see the Donor Name, followed by the Date, and then the amount, of each donation -- one donation per line. But I want to see the donor name just once, on the line of the first donation that person made, so that on successive lines by the same donor, we don't see his name repeated -- just blank lines with only the donation info displayed. I know this is super simple, and I've done this successfully before just a few days ago, but but somehow I just can't get it to work now. Seem to have tri…

Hi, I thought you could append an export file similar to the "Append" when you safe to pdf. Please see attached script and pop up pics, I've created two "Temporary Paths" .... $Set Temp Path and $Set Temp Path 2 and I added both into the "Send as Email" script step in the "Attach File" pop up. However, I am only allow the first valid "one" file in the "File Path" window even though both are valid. Is there anyway to get both .csv file into the same email body ?? I'd rather not have two email window pop, one for each export. Any assistance in this matter I would be grateful. Thank you. Tom

Hi, I am experiencing another issue when exporting a cvs file. For some reason ( please see pic ) I am getting my date fields exporting incorrectly. I am in the US ( MMDDYY ) and My client is in Dubai and they are DDMMYY. Even thought the user is selecting from the "Calendar" drop down which is MMDDYY and that is the way the date field populates and I validated the entry and I've double checked the "Field" format ... when I import the .csv file into an spreadsheet the dates that have aligned to the "Left" the spread sheet sees them as "Numbers" and the dates that have aligned to the "Right" the spread sheet see them as "Dates" but the "Day" value is the "Month" and th…

HELP How can I Export using a $variable as my File Name I am a new User with Filemaker 12 on a PC. I need to export to a file and have the field "Report Id" be the file name I Exported. Sample " Field Report Id = "Mik01122015" I need to export mt data to "Mik01122015.txt" How can I Export using a $variable as my File Name "$variable= Field "Report#" Export to "Report#123.txt" I am using this script