Importing & Exporting

My script imports an XML file... when the step is called FMP pops a dialog, can I get it to run without the dialog, without stopping? The import works properly, putting data into the correct fields. I am not using an XSL style sheet. Should me import settings be different to get this to run without a dialog?

Hi everyone, I am glad to be new here and be part of this community. I am currently running Filemaker Pro 19.x and I have a lot of Table Occurrences. I created another fmp project file within filemaker in order to setup a dev environment which connects to the dev database. I have everything imported and it works the same way as the live environment however, when i make updates to the data within filemaker e.g. changing an address of a client, it will update the live environment as well. After checking with my filemaker hosting company, they told me that i need to re-create the table occurrences (TO). It wouldn't be a problem but I got so many tables there, tha…

never mind, stupid user error

I have a FM DB of several thousand links of specific text on web pages created using a chrome extension (super simple highlighter). The links look like attached image - The initial part is identical but after the #:~:text= it has a distinct link pointing to a different highlighted text. I export the links to a little program that checks if they are still there on the web and returns an error if they have changed. My little program gives me a .csv of all the URL's that had errors. I then import that list of erroneous URL's back into my DB and this is where I run into problems. If only one of the links in the attached image returned an error, w…

I retrieve email records into a database for a to do list. The body of the email becomes the task. I want to be able to send emails to the databse with a date in the subject. I used "***dd/mm/yyyy***" as a pattern in another database so that when this pattern appeared in the body it was extracted and placed in the due date field. I am trying to work out how to do that. I use a script to import the emails into the tasks database and I would like to process the new revords by extracting any date and putting it in the due date.

Is there a way to ensure that Filemaker text formatting is maintained when exporting to .csv. I have tried applying "uppercase" to a field in layout. I have also tried to populated a field using "uppercase" as part of the script. However, when exported to CSV, formatting is both upper and lower case.

I would like to export a text field, but the characters in the exported file occupy 2 bytes. I would only need the 1-byte character codes. How can I create such an export? I show the problem in this picture.

Hi To All, During export records in excel format, we only allows to save data in single worksheet. MY quesetion is that "Is there any possibility to save data in excel in multiple tab(worksheet) for single excel?" actually i have 3 different format of data in single report and i have to export it and when i am exporting in single worksheet, it is saving the data but format is disturbing for other 2 format design as i can only export in 1 specific design. Thanks in Advance, I tried out lots of R & D but not found any meaningful reply.

Dear all, I am trying to export a custom header like : "Destination, country Code, Vessel / Flight Name, ETS, ETA, Agent, Sum Insured £, TMK Rate, TMK Risk" It works fine but i could not display the £. Any ideas? Attached is the script used. and the output.

Hi I have a FM script that exports an XML file into a networked drive. This file then gets imported into an External Workflow Server. ( Not Filemaker ) I know the external server has a Web Service and can use POST and GET methods as I currently send requests from the server to my Filemaker database. What I would like is to send this Filemaker XML using one of these methods rather that dropping files into a networked drive that first must be mounted on the users desktop. Is it recommended to use Insert from URL to achieve this or am I better off using another method. I have attached a description of what the external Server can receive. Any help on this…

Following on from this thread: Can anyone give me any advice on how to make this compatible with v19 of Filemaker please? Mike Duncan's solution worked beautifully in an older version and any help would be greatly appreciated. R.

Hi- I have a solution with a scripted import to bring in data when the solution is upgraded. This has worked fine in the past. I noticed that when I was testing this today, it asked for an account to login before allowing import. Did FMP 18 add a requirement for account authentication that was not present in FMP17? Thanks.

Hello, I have what I hope is a simple issue but I can not figure it out. I'm using FileMaker to create an email message. It works like a champ except that part of what's created is a line of text that includes a number that's formatted as currency in my layout but often comes out wrong in email. So, for example, if the number (which is called "AmountDue") is $50.50, then it exports as 50.5 and drops the last zero. How can I get it to format correctly and show the two digits? Thank you! DM

Howdy, howdy: I use a variable to set the desktop path with the calculation: Set Variable [$_DesktopPath; Value: Get ( DesktopPath ) & "ESU 7 Events: " & EVENT_PARENT::EventDate_Min__lxs & ".pdf" ...but it's hanging up on the EventDate_Min__lxs summary field--I get the error message, "2022.pdf" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." (BTW: The date in the summary field is 7/30/2022, hence the 2022 part of the error message, I reckon.) If I were to just use plain text: Get ( DesktopPath ) & "ESU 7 Events: " & ".pdf" ...it works fine. Mind you,…

When I export related data from FileMaker into Excel, there are empty cells where parent data is implied but does not actually populate the cells. Please see the attached FM and Excel examples. My goal is to fill in every cell in Excel. Any suggestions would be much appreciated! Jason Example.fmp12 Exported Data.xlsx

I'm trying to connect to an SFTP server using the Base Elements plugin. I've set variables for; $SFTPname = "SFTP Server" $SFTPip = "sftp://111.111.111.111:22/" $SFTPusesr = "user" $SFTPpassword = "password" $FilePath = Get(documentspath) & "where the PDF is temporarily stored locally/" $FileName = "MyFile.PDF" $FileToUpload = $FilePath & $FileName (/MyMacHDD/Users/GeoSteven/Documents/where the PDF is temporarily stored locally/MyFile.PDF) $UploadFileTo = $SFTPip & $FileName (sftp://111.111.111.111:22/MyFile.PDF) With these vars defined I'm trying to execute this line $FTPputlist = BE_FTP_Upload ( $Uploa…

Hi everyone could some please put some light on a issue I'm having please. I have built a filmmaker project and is running well but I want to make another new project but I want to use some layouts and scripts from my first project. What I'm asking what is the order I should import I know the tables must be first but I don't know what to import next will it be my layouts or scripts I have tried to reach the forums but with no joy. Can someone please shine the light for me. Thank You

Newbie level question: I have a found set of MP3's inside a container field. 2 things I need to do: FIRST Export field content to an existing folder on the computer C:/Playlist/ Using GetDesktopPath is useless to me, unless I could export to ../Desktop/SomeFolder/ GetFolderPath seems good, but even after watching examples, I still don't understand the syntax. Has the script step GetDirectory vanished in FM Pro 18 ? THEN Later, I will delete all MP3 files inside the folder C:/Playlist/ I remember how to do it with DOS commands but not launched from Filemaker. I suppose Send Event should be used, but I don't get how t…

Our container field has the images stored on the server, external to the database ( [hosted location]/DBIMages ) so as not to bloat the DB itself. Some times the image is too small to view within the database in its normal layout, so I wanted to use the SEND EVENT to open the image so the User can see it full screen and then just close that application when they have finished. The SEND EVENT works fine if I hard code a file name with full path, but I am having trouble using a variable to store the file name and path because the filename is being passed as "REMOTE: " + the file file and the SEND EVENT does not recognise the REMOTE designation. How can I spec…

Good afternoon, I have a script running on the server (Server 2019 Standard) that generates a CSV file that I then place into a container field. Whilst I can do this on my local workstation with Get(TemporaryPath), then Insert File into a field, when I try to run it on FMS the file is created in a temporary folder but both the file and the folder are deleted immediately the moment the script closes. I stop writing to the CSV file. I have intercepted it and see that the file is being created OK though. I thought perhaps it may have been Windows Defender, but might it also be FMS deleting it? FMP on my workstation doesn't delete it immediately afterwards. …

I am feeling pretty dumb about not know how to resolve this. I have a Filemaker file that keeps a daily record of different ticket prices sold in our theatre. We have just changed our ticketing system and now receive a daily csv and/or Excel file that summaries the number of different seats sold at different prices. When I try to import this data into my pre-existing Filemaker file I am confronted with a "specify import order" window that has 7 "pages". This means that the number of tickets sold is presented on 6 "pages" of the import order specification. But I don't think there is a way of taking only the line of data from say page 2 into a given field, and then the…

SQLite is built into the Mac OS. One can use for example DB Browser for SQLite to take advantage of it. If I want to export a FMP database, to SQLite does anybody know where I find detailed instructions? Thanks

Afternoon all, I have a layout that I need to be accessed rom Webdirect, and on this layout is a-simple Export as Excel button. This runs a script that flicks to a different layout (with all the fields in i need) and exports as Excel. But this doesn't work in WebDirect. Anyone have a clever workaround? CSV would be fine Thanks!

Would it be possible to import this old web-based film database into a FileMaker template? It has been archived on GitHub. If so, is there a simple way of doing it? Thanks,

Hi I'm trying to import xml data into several fields using Insert From URL. I can get it to all appear in one field but I need it to be distributed into several. <?xml version="1.0" encoding="UTF-8" standalone="no"?> <MACHINE Generated="2021-06-28T14:19:20+01:00" device="Boris"> <IDLE>TRUE</IDLE> <IP>172.16.3.202</IP> <QUEUELENGTH>11</QUEUELENGTH> <TIME unit="sec">9780</TIME> </MACHINE> Is there a way to populate the following fields from tagging onto to my Insert From URL script. MACHINE, IDLE, IP, QUEUELENGTH & TIME I can save the xml into a file and import that w…

Hello. I have to export a folder containing several .fmp12 files as .csv files with the same order of the headings and the same name + suffixe. (ex : #135_2021_06_08_DATA_MAT.fmp12 => #135_2021_06_08_DATA_MAT_export.csv) Is there a way to do this or may I have to import all the .fmp12 files in ONE. I'm very newby with FMP but I try. Thanks a lot for your help. NB: All the .fmp12 files come from FIleMaker GOand are created each day

My Filemaker 18 Pro application files (.fmp12) are physically located on a NAS mapped drive W:. The application itself is running on the drive C:, accessing the fmp12 files from the W: NAS. I would to execute the Script step "Save Records as PDF" and specify a "filewin:<output filename>". This works perfect if I'm saving files on the drive C:, with "filewin://SERVER_NAME/share_name/Users/Joe/Documents/test.pdf". I would love to specify a filewin: to a place on the Mapped NAS W: drive but can't get it to work. I've tried every possible combination I can think of but FM will not save the records there. Any suggested solution? Native or even with a plugi…

I have a solution that imports xml files throughout the day . The way its set up is when a xml file gets dropped into a networked folder titled with its Job No ( 90001.xml, 90002.xml, 90003.xml ) an AppleScript is triggered and moves the XML file to a new folder and renames it to ImportXML.xml. The AppleScript then triggers a FM script that imports the xml into a solution and then then AppleScript deletes the .xml file. What I would like is Filemaker to be able to import using the original job number ( ****.xml ) and loop through everything that’s in the folder and to delete once imported. Any ideas if this is possible in Filemaker or maybe a 3rd party plu…

After a scripted import (ADD records), the found set doesn't appear normally (Screen Shot 1), but if I were to include in the import script these two commands at the end: Show Omitted Only Show Omitted Only ...then the records appear as they should (Screen Shot 2. The names have been redacted.) What would cause that?

Hi, Mac and WIndows are indeed different. Now, I have the same question again like before (see below) — only this time for Windows. "Comment" suggested correctly to use the TextDecode function, that did the trick — on Mac. However, this does not work on Windows. I have the following situation: A windows text file in a container field g::tmpc, on a windows PC using FM 18 with the following contents: Size : 64317550592 Size : Size : 1099508477952 Size : 23024804278272 When I copy the contents of the container field g::tmpc into a text field g::tmpt with Base64Decode ( Base64Encode ( g::tmpc ) ) Everythin…

Hi, I'm having pdf issues in a container field. It's a random problem. Comes and goes. When I import I sometimes gives me a message such as it shows the title and adobe logo or it gives me a "no disk space" and sometimes it gives me another message which I can't recall exactly. If I export it, it exports fine. The issue is viewing the contents in the container field itself which it sometimes does perfectly and sometimes not. I uninstalled Adobe Reader DC on both my pc's and reinstalled with no long term success. I found an article (which I cannot find anymore as I have opended hundreds of links to solve this issu…

Hi everybody, happy Eastern. I'm struggling to replace word mergedfield with a multiline text field from filemaker. I don't know the number of line I will have in my filemaker field. I'm trying with MBS xml functions WordFile.GetXML and WordFile.SetXML but I'm still not successful. I thing I have multiple problems : how to replace the line return characters I have in filemaker in the XML ? I'm not able to write out the XML to a new doc file. I see the new XML in filemaker variable but not in the outpout doc file. Do you use also MBS for that ? Or do you have any other method ? Thank you very much for your help. Antoine

Greets, All: I'm racking my brain trying to figure out how to set up the schema for exporting records for a report where I need to count how many records (in the Attendee table) have the same school district name per parent (Activity_Log) parent record. Please refer to the attached. The shown Activity Log (parent) record has 23 children records stored in the Attendee table, some of which are visible in the portal at the far right. Some of the children records have the same school district name (or more accurately, UUID number in the _kflt_District_NameID field.) When I export weekly records (using the fields at right in the Attendee field list) to an Excel spre…

Filemaker Pro Advanced 14.0.6, running as a database on my PC On a summary layout I display timestamp fields from various related tables and want to conditionally format them with a color to indicate that they are current within the last 2 days (green) or older (red). I don't need a precise answer for this, +/- a day is OK. Logically I know the calculation is current date/time minus timestamp, with a greater/less than calculation to change colors I have tried Get (CurrentDate) - Timestamp, with the calculation result set to "number" and I get junk numbers, e.g. Get (CurrentDate) Timestamp Calculation Result 3/…

I know this has been discussed elsewhere but I needed to Export some data and I wanted column headers. In Web Direct. There seemed to be two options - either using an XSLT stylesheet and exporting as XML. Don't think this works in Web Direct, and looked like it would take some time to get my head around. I also see there's a suggestion to export as a Merge file, and simply change the file extension. This looks good but won't support custom Column names. So I developed my own simple export which works in FileMaker and Web Direct: It works well, but can cause complications if Unicode characters are included. It seems Excel doesn't like UTF-8 with…

Hi people! I hope someone can shed some light on the following issue. I made a simple script for button to import the data from .xlsx and update a field. Script works good but I have a problem with the last step. If xlsx contains the data for import, field gets updated and record is not shifted. Fine. However, if the .xlsx has no data to import, FM automatically shifts to the first record. What I would like is that in the latter case record is not shifted or in other words... I press the button, there is no import because there is no new data, current record is not shifted. I tried with Go to Record as the last step but none of the offered options (first, l…

Hi All. I have a database that is currently sitting on 760MB with 425K records and from the trend it will grow at about 200K records a year now. as it is primarily used on mobile devices I think that this growth will lead to local processing problems. I am looking for a way to "hive off" any records older than say 18 months in the distributed version of the database while keeping all records in an "archive" version and then be able to add new and modified records monthly to the "archive" and removing the oldest month from the distributed version. There are 27 tables involved. Any pointers for achieving this would be appreciated *

Dear Community, I am working with FileMaker Pro 16 and I’m searching for advice on how to merge two databases. I have found some similar posts but which did not describe the same situation. I have database A in which the first 100 cases=records have been documented. Some time ago, two different teams have started to work on that database simultaneously: One team did not add new records but added new fields to each record. The second team did not change the records of the first 100 patients but added new cases=records -> database B. Database A has 100 records and 1599 fields, database B has 200 records and 1265 fields. …

Hi, I am trying to get a script to export records to the Filemaker Server Documents folder so I can a run a Weekly scheduled script from the Filemaker server itself. Then the script sends an email with the export attached via SMTP in the background But if run the script from thew server it is not attaching the attachment, it seems to be wanting to use my documents folder on my Mac. What path do I need to set in the export location for it to use the Filemaker Servers local folders. Thanks

I have a report based on a join table. This report only contains sub-summary parts. The first summary part is grouped by 'employee name', and the second part is grouped by 'hour type'. This report displays on PC and prints just fine, but when I export the report to an Excel file it omits any subsequent appearances of the 'employee name' field. All the other fields are fine. Here's the layout view. Imp_EmpID, HourType, and s_Hours all come from the parent table. c_Name_Reversed and SubDeptartmentName come from child tables: Here's the report view from within FM (names redacted): And this is what the export looks like: The employee ID n…

Good day all, I have the below script to import, my issue is that as records are import a group if skipping. The issue only happens if i import into my production database. If i create a new database and do the import it works fine. any help is greatly appreciated. Thank RudyM

Hi there. I am wondering if it is possible to save a pdf doc with a customer name? If so, can you guide me through the steps?

Hello all, I have an embarrassingly simple question but I can't find the answer to it: Let's say I have single-table, single-layout file with 10 items. I have 1 A, 2 Bs, 3 Cs, 4 Ds. There is a summary field "itemcount" which does what it says. Sorting by "item" I get A 1 B B 2 C C C 3 D D D D 4 I want to to export the 4 itemcount fields as in: 1 2 3 4 So far with any permutation of the setting in the Sort and Export windows I get this: 10 10 10 10 10 10 10 10 10 10 What are the correct settings to achieve what I need? Thanks (PS: I may ned the "Complete Idiot's Guide" version, sorry...)

Can you import multipage PDF as 1 page per record? Thanks, Ian

Hi All, We're new to FM. I tasked my team to write a transformation script to convert Excel files into a specific CSV Format . The script works well when run manually (user picks individual file) but fails miserably due to FM's apparent limitation when looking at folders, to only import image or text files. For the project to be a success is must have the ability to: Import multiple files types (XLXS, XML, CSV) Import from separate file paths Work on a schedule (e.g. every 15 minutes) Run from sever (Win) Nice to Haves: Ability to import from FTP Ability to export to FTP Move files from source folder once i…

Hi, all I need is to read the content of a text file into a text field and I can’t figure out how. Situation: I have ≈150’000 folders, each with one image file and one xml/text file with meta information about the image file. The image file and the meta data need to go into the same record. I’ve looked for hours now, but couldn’t find a solution: • I can’t use the import folder command, because it creates new records for each file in a directory. • I can’t use Do AppleScript > do shell script > cat x.txt, because I can’t get the result into FileMaker. • I can’t use the new Read File script step of FM18, because the solution is on FM16 a…

Good day Filemaker newbie here I'm helping sorting out some performance issues on a vb.net application that creates reports via the filemaker odbc connector. It is extremely slow, querying tables with up to a million records. Are there any other options one could consider? A rewrite of the vb.net app is off the cards at the moment. Thanks in advance, William

Hello! I have a solution many years in development for theatrical lighting data management. I'm working to implement some new features and before I dive too far into experimentation, I'm hoping someone might have some insight here. This solution is using MBS plugins, specifically the Socket.Read function, to receive incoming messages from a lighting controller. (Reading OSC from an Eos, if you are a lighting person) What I'd like to be able to do is to save each incoming message to a table in the background, in a way that doesn't affect what the local user is doing. The problem, of course, is that if I get 20 incoming strings, it takes a moment for FM to create…

I have 7,000 email exchanges in Mac Mail that I would like to convert to a Filemaker database. I can export them as an mbox file, but I do not know how to extract them from the mbox archive in a way that will let me import them into Filemaker. Mail theoretically allows you to export a batch of emails as individual PDF files or even into a large single text file, but there seems to be a limit to the number of emails it can handle in one batch. Does anyone have any suggestions for a viable procedure for importing emails into a database on the Mac? I have thought that Applescript might be able to do it, but my Applescript skills are very rusty and I have yet to find any …

Good day all, I need some clarification on how i can possibly accomplish a task. No matter how much i think of a way cant figure out how to do it. i need to import data from an excel file where column "A" contains a unique value, but column "B" and "C" can respectively contain anywhere from 1 value to 50 values separated by a comma each. I need to create one record per value on column "B" but keep column "A" as the key field for each record. Thanks JMart

I have a main table of products with skus, and a related table (matched on sku) of data from eBay with listing information about the sku. When I update the related table I show all records and delete them, then re-import with the latest download from eBay. That all works fine. I added a timestamp to the related table so I'd know how recent the last download was. In the main table I display some data from the related table, such as price, and I have a field next to it showing the timestamp from the related table. My problem is that if the related table has no data for that particular sku, the timestamp does not display (because there's no record matching the sku in th…

Gents, there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved? Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option. price.xlsx

Hi, I tried using the below script to export batch images from my container field: Go to Record/Request/Page [First] Loop * Set Variable [$filePath; Value: Get ( DesktopPath ) MyPics::Description & ".jpg"] ** Export Field Contents [MyPics::Picture; “$filePath”] Go to Record/Request/Page [Next; Exit after last] End Loop And modified it with all my information and when I run it in my database it only exports the first picture in each container when 1. there are multiple images in each container and 2. there are multiple records within each collection. I'm trying to batch export every image in the database. The image databas…

I am running a script on server (perform script on server) which successfully exports data to a PDF on the server ("Save Records As PDF"). Later in the script, I am trying to insert this PDF file into a container, using the "Insert from URL" script step. No matter what I do, I am always getting back errors. FM server is running on a Mac server. I have tried all combinations of different parameters for "Insert from URL", with various formats for the URL (starting with “file”, “filemac”, followed by “:/”, “://”, “:///”). Depending of the combination, I am getting either one of these errors back: 5 - Command is invalid (for example, a Set Field script ste…

So ... I have no problem attaching a pdf to the end of an e-mail. My issue is, a customer wants to attach / insert the pdf between his text. I've attempted several ideas but to no avail. Please see attached script were I've attempted to insert the pdf ... but only the file name is inserted ( in yellow ) Any guidance / assistance / suggestion I would be grateful. Thank you. Email_Script.pdf

Hi, I'm an absolute novice with FileMaker but I'm having to do a data export for a client. I have various container fields storing PDFs, XLS files etc. I've moved them from internal to external storage and I can see them all on my file system. Now when I export the records, selecting all fields, I can't see a link between the record and the external file. I would have expected a path or similar. Can anyone advise how I might be able to do this? Thanks in advance.

Hello all i have switched to FM from another database I could not afford anymore. i exported all the tables as excel file format, and then imported them into FM. Unfortunately the date fields got imported as a number. i have tried converting them by creating a new date field and using GetAsDate() in a find and replace field formula it just returns “?”. i would appreciate if someone could take me through how to do this. I did go and change the date format to mm/did/yyyy. That did not help. thanks mark

I'm required to export a CSV from FileMaker that I need to import in a PC based program. My export is a CSV or Excel file but when I try to import it, it shows that all the fields have "Double Quotes" in them and my PC based program will not accept the file. However, If I open the Excel file on the PC desk top and save it first before importing, the quotes disappear and the file works. How can I export the file from FileMaker so the quotes are not included? And what are they?

I am posting this here so I can link it to a post on Facebook regarding a method to import branching based on file header of csv using feature in 18 Data File fileImport.zip

Hi My Solution Lately undergone a major design update (new colors and layouts ) , but fileds weren`t changed. The file with the new design was a cloned copy of the live file. I have several tables with hundreds of fields. How could i import the entire file without have to go through every table seperatly - and first go to that table in order to be able to match it. the name of the tables and field were left untouched just the layout and design changed and it would be major work to copy over to the livew file. I would appreciate if someone has a easy idea.

I need to import data from a Google Forms survey. One of the fields is a text field containing multiple semi-colon-delimited values (e.g., "basketball;football;track & field;volleyball"). I need to break these out into separate records in a related table. The only idea I've come up with is to capture the field contents into a variable, count the values (using a method I have not yet figured out), create a related record with the leftmost value (the method of identifying which I have not yet figured out, given that some values contain multiple words and spaces), delete the leftmost value , increment a counter, then loop until the counter reaches a number equal to the n…

Hi, I have an FM solution that manages the loans we arrange for our clients. To do this we have 2 main data tables - Contacts and Deals. We also have several other tables that contain related data. These include Loan Accounts, Security, Comments, Documents, and Notes. There are also other join tables that allow us to record other relationships (eg. Contacts - Contacts to reflect employer and employee relationships). All deal related tables have a field called 'ID_Deal' which I use to link all the related data together. I need to be able to export a Deal, which would include all the related data from the other tables. I am happy to export this data …

Hi there, We have been working on Filemaker for many years now and will be transferring all the information to a new platform. We have information that is very important that appear in more than one tab but we are seeking to export the information from these tabs onto one excel document. This would be instead of exporting from one tab and then exporting the next tab and trying to take the information from one excel to the other, we would like to be able to export the information all into one document. This would save us a lot of trouble as we do have 2700 lines of data. There are two tabs, one that contains contact details etc for donors and the second tab co…

I use the import script step a lot and almost always from a outside ODBC data source. The method I employ for importing is to set a variable with the sql text and then use that variable in the import script step as calculated text. Doing it this way allows me to copy the text in a readable form from the variable when I get an "Extended Error (ODBC)" 1408 in debug and then paste it into MS SQL Studio and analyze the problem there. Every once in a while after making a change to sql text in Filemaker and getting a 1408 error in debug and then running the COPIED sql text in MS SQL Studio I get no errors in MS SQL Studio and the data is returned to me as expected. …

I am using FM 17 and am trying to submit some JSON to an 3rd party website to create and insurance claim. Below is the curl code I am able to run from the command line. I tried using Insert From Url to do the same thing and I am unable to get it to work. I get the following message back when I use Insert From Url: "Message": "The requested resource does not support http method 'GET'." I need both the information after the question mark on the url and the data after the -d tag. I think I read somewhere that if a ? and information is included after the url that Filemaker's implementation of Insert From Url assumes a get. I need to be able to have both and do a po…

Hi! using FM18v3 I defined an import, update using key with option :add remaining. Odd enough, when running the import for the first time, the key field remains empty. (Unexpected) As a result the second time I run the script I get new records, but now the keyfieldfield is filled. (Expected) The third time the import also runs as expected ( no new records ). I fixed this by defining this script in FM18 using an if. Eventually, I launched FM17 and re-did the script. Now it works like it should. Anyone else can replicate this? Kind regards,

The Import records script step lists the source fields as Source field 3, Source field 14, etc. How can I find out what the actual source fields are?

Hi, Sorry, can someone delete this post. Thanks Michelle

I have built CI tools in FileMaker for generating config files for services such as postgres, nginx, apache, and others. It all looks good, however the output is UTF-16 with some odd line breaks, Windows-like? $ exa -T sites-available sites-available ├── api.domain.tld ├── document.domain.tld ├── filemaker.domain.tld ├── graphql.domain.tld ├── rest.domain.tld ├── soap.domain.tld ├── webrtc.domain.tld ├── www.domain.tld └── www2.domain.tld Is there a way to set the settings for these export field contents as UTF-8 with regular unix line breaks? Even though this is written to a local folder on a workstation git handles the transfer to the server itself. Right now I h…

Hello - I have folders of images I want to create a script to insert into a field. The folders each are named that match a field "Rug Number" like this (where "1001" is the contents of field name: Inventory::Rug Number image:../files/rugs1001/AS-412-4,DESIGN,PLAIN,SIZE,3.10X6.1.JPG I want the script to insert the image file contained in folder rugs1001 - no matter what the name is (all the folders only have one image). Can I do this? I tried various variables, but am not getting the syntax right. And I don't know if I can just grab any image out of a folder...

Hello I have a database which imports data from a csv file. This csv file is generated by a machine usually every day. But it does not delete previous data, it just generates the whole data it has on the same file (overwriting it). Obviously I don't want duplicated records in my database. The first solution was to actually delete the whole records and re-import them, but this wasn't the preferred solution. So I thought of a second solution which I would like to share for any advice. I created a second table, Table_B with same fields as in first table Table_A. Then added a relation between the two tables where Table_A::field_a = Table_B::field_a…

Greets, all: I'm sure this has been asked but after searching through 168 pages of this forum, I couldn't find an answer so it's on me that if this is a repeat question. Sorry. This involves FileMaker Pro v12 client and server on another company's machine in another location; I'm using a VPN to help out. I want to code a script to import a file from the user's desktop (in a folder named StuAdd; the filename is Full_Download.xlsx) but I don't know how to code the syntax for importing from either a Mac or PC to the file on the server. So far, I have: Case ( Abs ( Get ( SystemPlatform ) ) = 1 ; "filemac:" ; "filewin:" ) & Get ( DesktopPath ) &amp…

Hello all, New to FM but have been going through the LinkedIn Learning modules and have a project in the works. I have a database of "listees" whose information I publish in a yearly directory (name, address, phone number, associations, etc.). I need to have this output to a .txt file (tab) so I can copy/paste into QuarkXpress, but am struggling to find an efficient way to do this. Using merge fields is ideal because I can add punctuation between the fields as opposed to exporting records, but I can't seem to find a way to export these fields to .txt in all my searches. Am I missing something or is this not possible? Thanks!

We have both a TEST FM server and the Main FM server. I have been working on the test server to create some new features in a database we run on FM. Once those are tested there will be a, Layouts, Value lists, scripts and many other things... I was wondering if there is an easy way to transfer the layouts and other devices to the Main server? I that there is "Sharing" under the file menu, but I am not sure if I can import just options that I have created? Does anyone know an easy way to import new tested items into the main server?? Or am I going to have to re-type it all into the main server? THANKS!

Hi, If you've ever been stuck with unwanted invisible unicode BOM characters inside your List, there is a workaround: The zero width no-break space (BOM character) can be represented as: --------- Char ( 65279 ) or \x{FEFF} or <U+FEFF> ... ---------- The BOM character may appear when you export your list, regardless of the TextEncode/LineEndings you selected. In order to avoid this pesky character entering your exported file (in the wrong position), specify _ENC at the end of the filename: ----- Set Field [ YourContainer ; TextEncode ( $q ; "utf-8" ; 1 ) ] Export Field Contents [ YourContainer ; "YourExpo…

I'm having a consistent problem when I export to Excel. When I do, there are empty row created between records. This doesn't occur in every record but enough to be annoying. Any thought about this?

I'm new here. Please forgive silly question but every time I perform an import, i can never find the import log. It seems it lands where I last opened an FM file but I open fm files in many many places. It is driving me nuts. How can I make sure the import log appears in a place that I can find it? I believe the same problem happens with error log file. Can I set a default somehow? Folks here seem very nice. I hope my question doesn't seem foolish or trite. 😁

Hi, I receive Excel files weekly with some columns I need to clean up, in order to produce SQL queries. I'm thinking of importing the Excel to FileMaker to have it generate the SQL queries. The SQL script then connects to an AS400 i7 series, via DBeaver (using its freeware JDBC) and retrieves tabbed text, which is imported into FileMaker for analysis. A previous post resolved how to deal with fixed-length formats and how to export multiple records (rows) in a simple yet effective manner, and has taken a significant part of the burden away for me. Here's the original post, with the solution given by Comment (EightCharFile2.fp7.zip ) The generated SQL needs a …

I'm trying to send exported data to an old mainframe that wants a .txt file type. It doesn't like the .tab type and hates the .csv type. I can copy and paste it into a notepad and send it ok, but that seems kind of clunky and unprofessional. Anybody know how to get FileMaker to export as .txt? Thanks.

Hi i created a script where i can import a list of records via an excel however i receive an error 729 and no records get impoted, any idea why? i would appreciate if anyone could help me out on this as i would like to get this import feature working

How do you import records from a Runtime solution into the FMP 17 file that was used to create the Runtime solution? I've tried to import the Solution's exe file, but get the error "file cannot be translated using the selected file type".

I have a csv file that I am importing as a trial. When I open the csv file in Excel I have 4140 rows of data with 20 columns per Row When importing into FM I have 4576 records visible and the last 120 rows are full of incorrect data. I suspected that the issue was with commas in the csv file, However, If I split the csv file in Excel into 2 .xls files and import them separately every this is perfect so I don't see the problem being within the csv file Is there an issue in FM that only allows a certain amount of data to be imported? Thanks in advance

Hi All, I have posted on this topic before but I have not come to a solution. I need to attach a PDF file when on click, goto server location, the client must be able to brows for the file, not a fixed location then insert pdf into container Please could you give me a few guide lines as I have tried quite few few with no results

Is it possible to view a dcm file inside filemaker?

On laptop running FMP Pro 16 Advanced these two script statements result in List.xlsx saved in directory FMPstoredfiles Set Variable [$SavePath; Value "FMPstoredfiles/" & “List” & ".xlsx"] Export Records [with dialog:off;"$SavePath"; Unicode (UTF-16)] On client laptop running FMP Pro 16 the same statements result is “List.xlsx could not be created on this disk” The FMPstoredfiles directory is there, not full, and not locked. Using the file menu Export Records will save List.xlsx in the FMPstoredfiles directory. Both laptops run Windows 10. The only difference is Advanced vs plain FMP. I have run out of troubleshooting ideas. An Internet s…

Hi All, I need to copy one field only from one layout (+- 200 records) and past all those records from that field into another layout. I have tried a few commands but does not produce the required result. Please could you advise on a script?

Hi I have an excel sheet with a column containing hyperlinks. How can I import it into Filemaker 16 that it creates a field where the links are shown url as http://....?? Regards

I am looking for a filemkaer solution for connecting to banks (any) or API's and sending them electronic payments to process and pay from our financial institution - they are saying to just create a NACHA file - has anyone created a NACHA formatting solution for filemaker?

When I "Save Records as Excel" all the found set records are saved out of the system. However, when I "Export Records," only about two-thirds are exported. What would explain not all records being exported? Thanks.

Hello, I'm not sure if this belongs in the forum or not, but I'll give it a shot. I'm looking for a free downloadable file that lists all zip codes, US cities, counties, and states with time zone, Lat and Long. Unfortunately the only thing I can find online is at https://zipcodedownload.com/Directory/ZIP5, or http://www.zip-code-database.com. While these are free, I cannot download a file and so I'm looking for an updated current file I can download. If anybody has an up-to-date source for this I'd be grateful. If I need to move this topic just let me know!

Hi! I'm in the Importing process of a database. In order to verify if the source file exists in the desktop -before "Delete all" script in the destination file-,I tried the "not IsValid ( $desktop ), where $desktop stands for Set Variable [Let ( [ MAC = "filemac:" & Get ( DesktopPath ) ; PC = "filewin:" & Get ( DesktopPath ) ] ; Case(Abs(Get ( SystemPlatform )) = 1; MAC; Abs(Get ( SystemPlatform )) = 2 ; PC ) & "MainDatabase/" & Get ( FileName )) I think that the IsValid step doesn't work here, because it is ignored in the process. Does somebody know if there is any other step to verify in advance if the file or folder exists…

Good day gurus, As usual seeking some valuable advice. I am currently importing a price list, the source is a tab delimited files, I am doing a one-to-one import and all works perfected. Now the boss is requesting to be able to compare the last imported price with the previous import. What I was thinking was to create an additional table (e.g. import one, import two,) and adding a import date field in order to identify when the import was done. Then create a script to empty the second table, move the records from table one to table two and then importing the new data in table one. Can someone give me some ideas as I feel i am trying to reinvent the whe…

Does anyone have an idea how to capture charging data made with the square app for a FM pro database

Hi. So, I just downloaded FileMaker pro and I have a few question. Question #1. Is it possible for me to import the contents of a PDF file into a database simply by adding a "button" where the user loads the PDF file from a FileMaker app. Number two, once I have this information, is it possible to add to my PDF file and then save it back as a PDF file. If someone can help me do this on the Trial version, I will certainly buy the full version. Thank you!

Hi i want to create a script where i can import new records via excel . i want to be able to pick up the related parent table id and place it in the designated field in the imported sub file. The PropertyIDF (see pic below) should get from parent table. see script below , unfortunately when i do the import it only places the propertyIDF for the first record in the foundset (see pic 2,) how do i script that all new records created should get the variable data in the selected field. i would appreciate if one could help me out on this.

Hello, First of all, I am a newbie on Filemaker so still learning every day new techniques... I like to search in the forums to deal with the challenges I find but this one I am posting I couldn't find anything so I am starting a new topic just in case. I am trying to set a script to import data into our Filemaker DB from a Excel file. Normally we would download every day an excel file from our Courier company with all the tracking information and then import that info into our orders table. What I would like to set is a script that would run everynight and donwload the Excel file into a Container Field and then use that container as a source for a recurring Imp…

Hi there I imported around 900 records into a fm pro db from an Excel db (.xlsx) . It's all there but when I go back to the db, I got 900 empty records. The data is gone but the records are still there??? The Start script checks fine. No weird action to perform. Just a simple sort. Any ideas?

Hi, I have a FMP server 15 running on a iMac which has very restricted access to the web. But it can have access to a Google Drive. Now I have a database where I store information about the staff of my company sorted by department. And finally, I have a server running the website of the company where I'd like to have the most updated staff listed on each department webpages. I'd like to have a script that would output the staff members on files stored on my Google Drive where I can ask the website to parse the listing. My issue: how can I export the staff members on the server hard drive? Ideally, can I ask a script to export directly on the Google Drive f…

I'm surte this is quite a simple task ... for someone expert I see I can export Record content using a Variable as the new filename for the exported file. I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename. The path for my db is as follows file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12 Thanks a lot

When importing using update existing and the source file has less records then the target file (error 727) what can I do to identify the records that did not get updated so that I can delete them. I am updating only some of the records in my database. I know I can delete the found set and then use "add new records" when importing but I am trying to update two hundred thousand records and it takes 10 times longer to delete the records then it does to import them. My database has a couple of million records. Filemaker shows me how may records were updated with import dialogue on but is that information accessible using a get() function? If it were I could omit record…