Importing & Exporting

Every week I receive an excel spreadsheet with cases that I import into FileMaker. The excel sheet adds the new cases to the previous weeks' cases. So the sheet keeps growing as new are added. I want the new cases (upon import into FileMaker) to auto enter "Open" in my case status dropdown list. I tried using auto enter data but am having odd results. Often cases that are closed and several years old will show "open" and the new cases will show "Closed". I can't find a pattern to the old cases showing open, so it appears random. Also once the case is closed in the database, I don't want it to show open again on the next import. Any suggestions?

When I use the export field contents within filemaker- It says it can't do it because it is an unknown format. .PCT I am on a mac with snow leopard and it won't open. Is there anyway that filemaker can export an image in a container field to a .jpg or a .png so that it can be used?

I am trying to do a straight import of a file into filemaker from a locked Oracle database. I am able to export data but it exports with a semi colon rather than a comma. When I try to import to Filemaker it only sees one big field not many. Is there a work around. I haven't worked with filemaker properly since version 5 so I might not realise the obvious.

I have FMP Server 9 and need to be able to insert an image into a container field within the database using a script. This script needs to then export a the field contents to a folder on the server. This folder with get synchronized with our FTP server with Rsync. I access the database from work and from home and need the export field contents script step to work on the server. Help!?

I have 4 fields of data I want to export to a file. I tried to export as a .csv file BUT all of my field data contain quotes around them and I want to export the first 2 fields with quotes around them and the last two fields without quotes around them as the data needs to be in this format. Is there a way to do this?

I am importing thousands of records at a time from a 3rd party supplied file. Keeping it simple...the fields contained are job number, job lot and count. I can have 2 jobs, each with 3 job lots, giving me 6 records. How can I import the jobs into my jobs table w/o having them repeat? I am using "Update Matching Records In Found Set" when I import. It works great if the job already exists but if there are multiple records with the same job on the import file it imports all of them.

Hi all, I would like to know if it is possible to create a script where an excel file can be selected, and where values from a series of defined fields are imported into different tables in the database. For example: select excel file create new record in table "products" extract field "A1" from excel file and enter value into table "products" in column "product name" etcetera.. In short, I would like to be able to select only specific fields in a standardized excel file and insert them into FM via a script. Is that possible?

I am trying to create import scripts for my file that has 134 tables to be used to upgrade the file at a later time. I have successfully created the 134 import scripts and have been able to import the data from the old file (FMFile_Upgrade.fp7) to the new file (FMFile.fp7). However, if I, at a later time, want to copy the present FMFile.fp7 to FMFile_Upgrade and test the upgrade scripts, it appears that the "Import Records" code changes the source table in all of the scripts. Should this happen? Is there some other way to do this that I should explore?

Is there a way to find a 'tab' character in a field?

I have a multi-user, cross platform database. A portion of this database exports PDF files to a shared folder on the network. Exporting and viewing the files works fine. The issue is an inconsistency in the way that OSX and Windows write or don't write PDF files to the shared folder when a PDF file of the same name already exists. In OSX, the new PDF file simply overwrites any existing file of the same name. Windows, on the other hand, won't replace the existing files nor does it report an error. Has anyone had to deal with this issue? I could probably make file names unique by appending a time/date stamp but then I would invariably end up with multiple older P…

I am trying to put information into the Clipboard for use outside my FMP database. I tried this, but it doesn't seem to work. Any hellp would be greatly appreciated. Set Variable [ $Claim Info; Value:Billing Claims::LastName & ", " & Billing Claims::FirstName ] Perform AppleScript [ Calculated AppleScript: "set the clipboard to " & $Claim Info ]

Hi all friends a referenced image import can give two types of result ? I'm asking because I found that an image imported from a folder ( reference ) doesn't have the usual 3 values ( size, relative and full with the GetAsText ( Image ) calc ), but only one. So, in that case, it is not possible to determine the size of the pict. Someone does know better about this fact ? BTW: I solved the problem to show the size with a looping script; that didn't solve my question

Since I'm new to FM and scripting I just wanted to get some input to see if I'm the right track. I'm wanting to export a csv from FM. The shifts that I want to export are only the ones that haven't already been exported, and have been completed by staff. What I have is a saved find that locates the tasks that have a staff members name applied to them and a "Transferred" date field. The data that it finds will get exported then I want the script to update the Transferred field to the date that the export occurs. So would may script go along these lines: Go to layout Apply find Export file Update field ? I'm looking into the separat…

I was wondering if there were some way of accessing a list of files in a directory (folder), and then sequentially opening them and gathering the information in the files. Thanks for your help, Fed

So at long last I've finished my offline update script ... wooooo ! BUT ... can't figure out how to create a universal relative path for both PC and Mac that points to a file on the desktop? Maybe my brains have just turned to mush but can anybody help ... please??? Sorry should have specified 'universal' meaning something that will work on any installation on any PC or Mac? Kindest, Simon

hey all, I am trying to create a solution where the core data is updateable. I have a data source that I import initially to populate the database. I now want to update that data. I have another source file that is a data dump that contains some of the same info as the original source import, some of the records have been updated, and there are new records. I import matching on a unique field. using the update matching records/import remaining records option. Records update fine but I have 4 new records that all have the same unique ID (the ID is unique to the individual not the record, so, you could have 4 new records all with the same ID because it's the …

I have records that have until now been getting pushed from an MS Access databse into FMS databases. It uses the SequeLink client, which frankly has been a pain. What we would like to do is instead pull the information from a SQL Server database into FMS. This would use the ODBC drivers built into Windows, which we've had far less trouble with. The problem is, while I would rather have all the data stored in the SQL Server tables (avoiding issues of synchronization and redundancy), the existing FMS tables (at least 16 of them) all have a plethora of calculated fields. Recreating those fields as shadow fields in the SQL Server tables and importing all of the FM re…

I realize this is a low level problem. I've had this trouble before but it's been so long and I don't remember the fix. I'm importing a tab delimited text file (.txt). When it imports, most (not all) of the fields are importing with quotes. Example ("5/8""" or "13,500"). How do I prevent the addition of the quotes?

I am building a runtime solution for airfare management to be distributed to travel agent. This allows them to enter airfares in a simple user friendly way and to export a standardised data format for upload to a travel distribution website I am trying to find out if there is a way to extend the export process to automatically send the exported file to an FTP box. Is this function available in any way in FM 10 adv or are there any plugins that would add the functionality. I would appreciate any suggestions

Hi FM Forum, I was wondering if there is a way to import from a excel file values to a repeating field. For example i have a field called "Groups" & it has 5 repeating fields on it. I was wondering how i would make the heading in the first row of an excel so it would know to put the first group in the first field then the second group into the second field? I hope this is even possible. Thanks for you help.

Is there an easy way to export images from a container field directly to a folder? I'm referring to exporting either from a database with embedded images (non-referenced), or exporting a subset of images from a database that references its images to a separate folder.

I am setting up a database for casting. Obviously I need a separate record for each actor who auditions and I have set up a workflow to import a photo from a digital camera -- that was easy. However, I need to take four photos of each actor: slate (identify) and the front, side back. When I import multiple photos it just creates multiple records. I need all photos to appear in the same record. I've heard of something like creating a table to hold the additional photos but I don't know how to do that. The goal is to have one and only one record for each actor that has their contact data, notes and the four photos. How can I set that up so that it involv…

NEVERMIND - FM 9 can't export to Excel 2007....Any Plug-ins or anything that can make FM 9 export to Excel 2007 (.xlsx):

I have on a regular basis to import .txt files generated by a Barcode scanner. The steps used are: 1: Import Folder to get the list of filenames and the path. 2: A looping script to work thru the file paths to Import File with fields appropriately assigned. Unfortunately this does not work as I get error 100 and message that "The "File xxxx" could not be found and is required to complete this operation" . A finder window then opens showing the list of files and a double click effects the importing. Why does this not occur from the script. FileImport.pdf

Hi All! I have a problem: In the Picture-folder in Windows I have a lot of pictures which should be imported to a Filemaker 8 field. All pictures have a unique name: img_0001.jpg Picture number 0001 add 1 for each new picture. Those pictures should automaticly be imported to a field in FM8. How should I write the complete script to get it work? -Per

I have a database of 300 individuals, each record having a photograph of the individual in a container field. The image is not embedded in the database but simply linked through a file path. I want to publish this database to a server but before I do that I want to convert the individual photo links to the actual images before I upload. Is there an easy way?

This is similar enough to the .pdf question that I almost posted it there. So I imported in a bunch of small .mp3's. When I open the file on the machine I created on, which also contains a folder with all those files, it works perfectly -- the files play. But when I copied just the file to a new drive, none of the files played -- and the file size was reduced by 200MB. Is there a way to tell if I did the import incorrectly? These files are supposed to be in fact contained in the file permanently, as long as I don't mind the hefty file size, right? EDITED: nm. Got it .

Is there a limit to the number of fields you can export import? I have one layout using a tab system with tons of fields, conditional fields, auto compile fields, etc. I understand container fields cannot be exported which is fine. But when I try an input the xml data back into another similar (new layout version) fm db I only see a fraction of what I exported when I sort which fields go where. Anyone know what im doing wrong?

Hi, I have data that I want to import into the same field, where I currently have a calculation where the last name gets stripped out. (eg. Bill_Smith) so only Smith appears in the field (I use the "middle"/'position' with "_" to only have "Smith" appear in the field. The question is that some of the data that I am importing has the 1st and last name switched around (eg. Jones_Nancy). So I was wondering if there is a script solution to this problem. I have got the calculation to strip out the last name in the "Jones_Nancy" example. But through the script, is there a way to select which way I import into the same field? These old data files that I am importing, I now …

One of the features I love about FileMaker is that when you drag and drop a PDF into a container field, the field displays a thumbnail image of that PDF. One of the things I hate about it is filesizes. We have a number of PDFs that would be beneficial to send to our customers in an email. Our general rule of thumb is that we don't send emails with files over 5MB. In our file system, a single PDF may be listed as 1 or 2 MB, so it should be fine to send. These PDFs are often updated, and in our FileMaker 'email center' we would like to have an actual image of the file shown in a container field so that the user knows clearly which one he or she is sending. …

I have a database for my cabinetshop that includes a field for measuring the square footage of materials. I would like to multiply this squarefoot result X the current price of different types of material. This needs to be set up as a lookup type relationship so that changes in current material price do not affect previous job cost reports. I would like, if possible, to manage the vendor side of the business in it's own database rather than as a table within the client information database. [color:red]Is there a way to import or lookup current prices from one database and use them in another database? Thanks for any guidance here.

Hi, I'm trying to export a bunch of student records (around 2,000), that are related to teacher records. Everything exports fine except the student's grade. Students are in grades 1-5, and grades 4 and 5 export, but not 1-3. I've tried exporting the data using .csv and .htm, with the same result. This is a recent problem. I've exported these records before with no problems...I must have changed something since my last successful export, but I can't for the life of me think of what. Teacher_Subsidy_Program_Clone.zip

I have to export summary data from a related table into a field I can then merge into a word document. As an example, the records in the related table are say: ABC 2 $3 ABC 2 $4 DEF 5 $2 GHI 1 $1 GHI 1 $1 So what I need to come out (in one text field) is: ABC 4 $7 DEF 5 $2 GHI 2 $2 The initials can be different every time. I understand I can create a report with sub-summaries and with sorting can work the subtotals out, but my problem is I need the summary data to be collated into one field so i can use this data in a word merge document Any ideas of a work around? TIA

I want to import matching records which will change a field on a specific layout. If that field is changed from its previous value, I want to automatically call a script. This works OK when changing the records manually on the layout. I want it to also work when an import is run to change matching records. Is this possible?

I have a script that runs an Access file which generates a text file of data. My script has a loop with an error capture that waits for the text file to be created and then imports it. In FMP 6 this worked fine. Now in FMP10 i get a "File is locked or in use" message from FMP. The error capture no longer works. Any ideas ?

I have been working on a little runtime for our K9 unit mainly to keep up with feeding, photos, grooming etc. nothing too complicated). Another agency wants to use it as well so I want to give them a copy. I know at some point we will have changes to the db and I will want to give the other guys the updated version as well. So for the last two days I have been trying to follow some of the postings and try to figure out how to get the old stuff out of the old runtime and bring it back in to a new empty runtime. I have managed to create a folder (these are Windows machines) and then export one table to the file. the problem is I can figure out how to get all…

I'm trying to help a friend. He has an OLD runtime file someone build using FM 3 to capture patient info, etc. However, the vendor is no where to be found and software is having problems. Is there an easy, or fairly easy, way of extracting the date from the runtime file?

I have a student database made in FileMaker Pro 9. I need to bring in 2400 students photos. I thought I had it but it did not work. The photos are .jpg so they are numbered by their six digit student ID. Example: 111111.jpg So I made a field called studentID and made it a container. Then I put that field on my layout. I went to Import records..Folder. It gave me these options: Image File Name File Path Image Thumbnail So I put the Image with StudentID. Thinking that the 111111.jpg would go with the StudentID 111111. But all it does is bring in every photo in order,obvousily not the right file per student. What am I doing wrong? All the photos are in…

Hi there, I've got a bunch of tables that sometimes have more than 65,xxx records (older version of excel's maximum rows). When I export to excel, it basically has to stop at 65,xxx and cannot export anymore. Ideally, I'd like to have it export the remaining to a new worksheet within the file. What's the best way to handle this? Via export script? Or external to FM? And how? Thanks!

I have an Excel file in which a single worksheet has data that needs to go into separate tables. For example... Table: Company Field: pkCompanyID Field: CompanyName Table: Contact Field: pkContactID Field: fkCompanyID Field: ContactName So if I have an Excel Worksheet that is like this ColumnA ColumnB CompanyA Bob CompanyA Dave CompanyB Sara CompanyB James CompanyA Sally How to I automate an import of that into FileMaker into the separate Tables while assigning the key field values and keeping the integrity?

Is there a function that works the opposite of Filter? (e.g. exclude/remove the Filter list items rather than include-only the Filter list items)

Greetings, I have an extremely large tab delimited file. When I drag & drop it onto Filemaker, it loads fine, but all the data shows up after import with quotes in each field, like: "John" "Smith" "1234 Mainstreet" "Yourtown" "NY" "10234" How can I either: 1) reimport so the quotes vanish 2) strip out quotes after the import (note: If I open one of these txt files in Excel, and use the import wizard, selecting 'tab delimited", it goes into Excel perfectly) Thanks in advance for any help you can provide.

Hi I have set up a script that exports several fields as a .tab file but would like it to only export data from the record that I run the script from and not the other found records. any ideas. Regards Peter

Hi~ I am having difficulty with getting a graph created in Excel onto my FileMaker page using the Insert - Object - Create From File (with Link checked as well). The graph does come into the page from Excel but it is very large and can only see a portion of it. I can't seem to size it down to fit the space even using the Graphic Formatting tool in FileMaker. Is there an easier way of doing this? My hope is to have this graph link to the excel spreadsheet that I will be updating weekly. Any help would be greatly appreciated!

I suppose my application having 3 images per patient..somewhere said I should not store that many images actually in the container? i read, now I am trying to figure what make below code function.. whereas the container references the file store on the drive// My field is a container, inside creating a calculation like: Let ( txt = GetAsText ( ***my field name*** ); GetValue ( txt; ValueCount (txt)) ) BUT?? Nothing happens differently.. I can still right click container field and insert image i browse for on my disk....... with this kind of code does THE FUNCTION still behave the same ? I should be able to emove image from drive and the F…

Hi, I'm trying to import a folder with several thousand images, and assign the images to specific records already in my DB. I have the files all as "ID#.tif", where the ID# is what I want to match by in filemaker. Unfortunately, since there is the ".tif" at the end, I cannot "match records by name" because FM doesn't separate the extension from the filename. Is a good work-around for this? There are too many images to load them in by hand. I tried removing the ".tif" from the filename, but then FM no longer recognizes the filetype as readable (no surprise). I'm looking at the search results for people with similar problems—I would like to store my images i…

Hi All, I am working on a script that exports then emails selected files. The problem I am finding is that, no matter what order I list the files in the attachment field of the email dialog, only the first file is actually beeing attached. Any ideas why this would be the case?

When i go to export in xml I can specify how many fields export. But when I import the file back in im limited on the fields I can input? Do i have something set wrong how can I change it to match all field names for record and not just 20 or so...

I have a media folder with large files (images, audio, video). I'm using the "Import Folder" option to import the assets and capture the filename, filepath, and thumbnail. However, this media folder is regularly added-to, and I need to be able to occasionally import only the newly added assets. I'm looking for a way to have FM skip matching records, i.e., records that have already been imported from this folder, instead of updating them (which was the only option I could find for dealing with matching records). I saw this: http://fmforums.com/forum/showtopic.php?tid/209733 but wasn't sure if it would apply to me. I tried it anyways (setting the filename to uniqu…

Can FM create a new folder on the OS? For instance, I want to script a name based on the date and project, to be used to make a new folder on the desktop. Then my data backup script would export the table(s) data into that folder. thanks

Hi everyone I am a naive filemaker user I am going to import excel file(.csv) to FM But, once I tranfer excel file, FM does not show any things (tables and fields) I have no idea what I am going to do Here I attach the file Thanks small.csv.zip

On my DB I set up an auto import script when the DB is opened. It imports about 36 tabs of data from excel into my inventory table so it takes a few seconds to load everything then refresh the items with less than 0, older than 10 days, etc. I wanted my DB to open to a specific layout used by everyone else without witnessing the import. My import was set to go to inventory then import. So basic thinking says take off go to inventory cause the script know where to put everything. So I took it off and now my app opens to the main user interface layout without showing the import taking place. But now I get an error for not having a relationship and the script is h…

Good Day, I need some assistance with getting an exported CSV file (from filemaker) into a fixed width flat file. The character length of the file must be 329 characters. Blanks in the csv file need to be filled in with spaces when converting. Can anyone recommend any software that can provide this functionality? Tks in advance Shaun

Hi All, I have records that each have several files that I am inserting into container fields. I would like to know if there is a way to use one script and have the field being imported to detirmined by a script parameter carrying the field name? Thanks

Hello, I have a script in database "A" that imports from Table_Remote to Table_Local in database A (it imports from itself.) Table1 is a remote table from Database "B", both hosted on the same FMP Server 10. When I run the script manually via the fileMaker app it imports fine. When I run it as a script step I get error 100 (File is Missing) at the import step. It doesn't seem to have issues opening database B to access Table_Remote because I can export data from that table within in the script, it just can't find itself to import. Does anyone know what I need to do to allow it to import from itself during a scheduled Script? I really have no idea why it's not worki…

Hello Guys, In Php page I am displaying the content from FileaMaker database. Where as the [color:red]part of formated text in Filemaker field which is stored is lost on php page. I need to get the formatted text displayed in php page as it is in FileMaker field. Awaiting for ur replay

I am trying to do an export from FMP to excell file. script prototype... go to layout for export find data go to browse export records The script functions perfectly with one exception... Their is a field on the layout that is a calculation field that is not exported. The calc field has valid correct data. The calc is If(field 1 = "Yes" and field 2 = "Yes"; Case ( cal_interval_units = "Day(s)";last_cal_date + cal_interval; cal_interval_units = "Week(s)";last_cal_date + (cal_interval *7); cal_interval_units = "Month(s)";last_cal_date + cal_interval * 30; cal_interval_units = "Year(s)";last_cal_date + (…

Hi -- I was listening to a podcast and one of the announcers mentioned that he imports a FM Table into another FM Table in the same FM File. I immediately started thinking about the awesome things you could do with this. At this point you are a little free from the graph and do some pretty cool things with staging records in one table and transferring them somewhere else when you are done. I just wanted to get some feedback from the community about this. Is this a standard practice out there? How often is this done in real production systems? What does this do to other users that happen be entering/updating recs in the target table while this Imp…

I am trying to import records from an Excel SpreadSheet into our FileMaker database system. I inherited the system and am merely trying to enhance some of the functionality. One of the enhancements is to automate as much as possible, so for example, if a person enters an area code, it automatically identifies the state, which identifies the country. A similar method is needed with the cities and states. Well this is the problem. I have a "State" file. In the state file, there is the 4 fields, state abbreviation, state full name, area code, and cities. Both area code and cities are repeating fields. I have a list of all the cities of Ohio in an Excel she…

I have a database with 200 records and need to export them to 200 individual tab-delimited files. Unlike the save-records-as-excel command there doesn't appear to be any way to export just the current record, then go to the next one to step through the entire database Any suggestions? Thanks. Colin

I am converting an old FM6 appl to FM10. I have the FM6 appl export all the files into merge files. Then, the new FM10 appl imports the merge files into the .fp7 files. When I first created the script steps, I manually selected each merge file on the Import command line and mapped the data fields to import (although I kept many of the same field names, I did change some, so I can't use a straight "matching names" import.) The imports were fully tested and work just fine. Here's my dilemma... Because this needs to run on MAC & PC, I changed the Import file to use a variable $path that points to the merge files. The exported files will be on the…

I have two filemaker files. I want to import data from one to the other. The specific fields in which the data is imported depends on the value in one of the fields being exported. Any ideas for simplicity - beyond going to the export file - grab data - put into variables - go to import file - check field (that controls where the data goes) and then put data depending on value in the field (that controls where the data goes).

I need to import a flat text file that uses Ascii(158) as the delimiter. ...I also need to export a flat text file that uses Ascii(158) as the delimiter character. The reason for this is that I am inserting filemaker in the middle of an existing process. Can Filemaker perform these types of imports and exports? Thanks

I think this is an unusual problem. I have an elaborate FM database with multiple tables, relationships, scripts, layouts, etc. It is on a classified system, but it is not classified. Security will not let me move it to an unclassified system because the tools they use can not verify that it is unclassified. Their tools only allow for ascii text scanning. So, I am hoping to create an xml file with the DDR in FM Advanced and move the XML file to the unclassified system. Security's tools can read that. I have experimented with it on the classified side, and after I create the XML file, I can not open it with FM Advanced. I would have thought that FM Advanced c…

I have a website with an HTML form on it that sends submitted data to an email address. We then copy and paste the incoming data into our Filemaker database. What I'd like to do, is have the form automatically populate the appropriate fields in the database each time data (text plus an uploaded user image) is submitted to the site. Is there a way to do this?

Hi, Is it possible to substitute the NULL values with space in the external .txt file from Filemaker. I do not want to use the TROI file plug in or any plug in. Is it possible just with filemaker ? Thanks for your help in adavnce.

[color:red]UPDATE: Apparently it was all the "0's" that caused the problem. I changed the Record Number Auto Enter to start with 1000001 and then imported the files and everything seems to work correctly. I am working with an import script on a Runtime. On the layout I have a field called “Record Number” this is an Auto-Entered Serial Number generated on creation. Example: 0000125 So I give the runtime out to the troops and then I need to do an update to a new version (and I set the "Record Number to 0000000" on the new runtime. Since I do not know what record number each officer is on how do I have the new runtime import their data and not duplica…

Hello, I have successfully been able to dynamically load images using FMstudio. I create the dynamic image link and reference it to the filemaker container field and it works just fine. The problem is I want to change those filemaker container fields into supercontainer fields so that the images load faster. How do i reference a supercontainer field when it doesnt even come up as a field in the database?

I have a client who is trying to insert a picture into a container field, using "Store as Reference Only". Her file is 400kb, jpeg. The application is in FMP 6 and she is running on Vista. She is getting a JPEG error #25. She can insert other jpeg files on a Google search, I could only find 1 reference to that error code, but the site is no longer active!! I was able to get to the old website; it was cached. In case anyone is interested, the problem is CMYK vs RGB color palette. FMP 6 cannot convert the colors in a CMYK file (not sure if the later versions of FMP are the same or can support CMYK files??)

Hello, I don't know if I am putting this in the right sub-forum, but I am stuck again in my first FileMAker Development. Ok, so this is how it goes: 1. I have two tables Header and Detail (one is to many). For each Header::Type, there are several Detail::Accounts and Detail::Percentages 2. In my transactions, I will create a table similar to the Detail Table, except for an additional field called "Value". 3. When my user enters a "Type" in my Transaction Header table, I intend to copy the related "Detail" records in #1 into a new table called Transaction Detail. The problem is, I don't know how to copy related records from one table to another. …

Hello all: I know this is probably a simple answer but I am using the "Export Field Contents" script and that all works fine. I export a document to the desktop and all is well. But how do I delete the document on the desktop after I export it there? Do I need a plugin or can I do this natively? DJ

If using group by fields to calculate totals when exporting to Excel it adds the totals in a new column for the first record in the group. Is there anyway to control and change this behavior? For instance, put the totals at the bottom or ideally in a new row? My intuition is to say no but I thought I would throw it out there.

UPS furnishes a text file with ZipCode ranges associated with a service code (URC.txt). I need to split out the range into a service code DB with each individual ZipCode associated with a singular value for lookup-printing on a label. How can we automate this process as manually, its quite cumbersome and time-consuming and the file is updated periodically. file resembles "US","01051","01053"," MA 011 9-05" "US","01054","01054"," MA 011 9-03" "US","01056","01059"," MA 011 9-02" "US","01060","01063"," MA 011 9-01" Is there a convenient calculation to split out these ranges into a file with fields: Country Zip Service Code US 01051 MA 011 9-05 …

I am working on a database in FM and I want to host a calendar. I originally made the calendar in excel, but it has pictures and color that I do not want to lose by importing the excel file into filemaker. Ive been able to upload a screen shot of my calendar into the file, but my hope was to host the file in FM and have a button that lets the user download the original calendar. Is this possible? Any help is greatly appreciated.

Hi -- a client of mine is trying to import a batch of records to a database at a remote site -- not instant web publishing, just Client-based interface using the "Open Remote" feature. She's finding she gets through the whole field matching step and does the import but gets a "69 records skipped due to errors" type of message. I've noticed that when I access a remote file this way I can't perform a 'Save As' -- which is actually a nice protection against someone swiping your whole database? Is file import / export also disabled when accessing a file remotely? I think it might be she hasn't accounted for the generation of the primary key field, but thought I'd …

I export records to Excel 2008. The default date format on the new sheet is 1904 as it is on any new sheet I open. If I copy one sheet to a new workbook, the dates are changed to 1900 format and it is necessary to reset it to 1904 format. This happens only with information exported from Filemaker 10. Previously ran FM6 and 7 and didn't have this problem. When I type information into a sheet or export it from MYOB, for example and then copy to a new workbook the 1904 date format doesn't change. This is quite agravating. Is it a bug or is there a workaround? TIA

On my import from excel I have my fields set for the data I want from excel. However on a blank field that will be used for something else that I have not touched yet I get data from the excel file. Its random fields too. I wouldn't even know where to start on how to duplicate it. My import is coming from a file with 32 tabs of data each tab is set and get every piece of data I want. However if I delete the blank field it then gets thrown into a field that is set for a calc. Anyone seen this before?

Is there any way of accessing the playlist information in iTunes (id3 tags) and mapping these to fields I create in Filemaker? I believe there was something in FM7 which was a plugin called i Gotta MP3 collection, is there anything currently available?

Hello, TIA I have set several fields to a $var's I Add New N Record, then start replacing field by field Set field with my $var etc vars Stepping through my code..watch $vars --they are there? but looking at the layout my fields are blank.. data doesn't seem to get committed to new record after my set fields LOL, i used Replace Field Content in learning.. fixed it... but now find that its replaced all my record fields with same content.. so I am back to Set Field command.. and must be missing something...

This problem has been bothering me for some time, but today it has reached a point where it affects the usefulness of one of my layouts. It is such a strange problem that I don't even know how to search for an answer, so I don't know what to do but post a question. At any random time, an entry in a number field might change from 2 decimal places to 18 decimal places. For example, a field that I typed 94.23 into two days ago, now shows up as 94.230000000000003979. The data in question was originally entered in Filemaker, then exported to an Excel file as a backup and imported later. The Excel file was not opened in any other program prior to importing to Filemaker, an…

I need to know how to write a script to separate e-mail addresss on an import. I have a customized solution that imports the e-mail field from our school's SIS. The problem is that if a parent puts in more than one e-mail ie ([email protected], [email protected]) the custom solution I have create imports exactly what's there and puts both addresses in the same field in FMP. I need to have the first e-mail placed in emailfield1 and the second e-mail listed placed in emailfield2

Howdy, all: I know this topic was covered elsewhere (for FM 6), but this has a different twist on it and is needed for an FMP v10.x. runtime, so my apologies if it seems like a dupe. I'm having a little trouble phrasing a script step so the records exported from a file (alpha.fp7) always ends up on the end user's desktop. I've attached a .jpg of the Output File Path List but don't know how to phrase the statement that goes in the box. I tried plugging in Get(DesktopPath) but FMP just laughed at me. What should I use using the Windows platform? TIA for your help! Rich

Hi All I have a list of 4000 records for multiple customers (around 40 customers). My list consist of CustomerNumber, invoice number, invoice date, dollar ammount. What i want to do is be able to run a report to this list and have my script save every customer to one worksheet. So in 1 worksheet i want to see all entries from the same customer, and so on for all my customers. Is this possible? IF not can it be possible to create one excel sheet for every customer. I want to prevent from doing a find mode for every customer and save to excel. Thanks

I wrote a script to [color:blue]import up to 100 files in one go. If someone is interested I will post it. It is probably a bit primitive but it works fine. I was surprised filemaker can't do that by itself, but maybe I'm mistaken.

I want to create a runtime to use in WinXP. I have created other runtimes, one I have been using successfully for 2yrs. That one relied on data keyed. This one will be strictly populated with records imported from files created by our accounting system. It is an older system, lacking very little in the way of querying information regarding disbursements. When we write AP checks, the check registers are printed to spool files, real-time for each check run. Spool files are named "apckrgMMDDYY.sp". Since they are spooled reports, all of the lines of a report are there, multiple occurrences of the page headers, blank lines, etc. Since the check date is in …

I have a field: Expenses It is auto enter with a calculated value. It works great. However, when importing the table that has the Expenses field, either nothing or 0 is imported. Clearly, the imported table has valid values but they will not import. I have checked the "Perform Auto Enter..." in the script step that imports but it doesn't seem to matter. Do I have to change this field to a Calculated value? If so, why does FM allow me to specify "Perform Auto Enter..." in the import script step? Wondering in Washington....

Sorting Millions of records takes many DAYS in FM 8 (if it does not crash while doing it) and many hours in FM 10. By placing FM 10 in RAMDisk 1.0 (2 GiB) a 75MB file will take at least 2 hours when sorted on 2 fields. (I am ever so happy I found RAMDisk for OS 10; compliments to the maker). Whatever I have tried - when saving the SORTED file - the sort order is gone when the file is reopened. The sort order reverted to RecordNumber order - which took quite some time, because before being able to Save, it appears FM first has to "un-do" the sort. I imagine the SAVE AS command is routed to the RECORDNUMBER Table to SAVE the Records in the - according to FM - "correc…

Hi -- I have just imported 30000 recs from MySQL. I built a layout to my target FMPro table, and did a File > Import Records > ODBC Datasource and used my odbc connection to mysql ... The import went smooth and it stated no problems. However, now that I try to "Perfom Find" on the "target layout" ... It states "THis script cannot be found or has been deleted." However, I can still view the data, and it "looks" alright to me. Do I have a corruption on my hands? Regards, --Rich

I have 2 related tables: 'Contacts' and 'Pupils'. I have a layout in 'Contacts', with a portal displaying related records from 'Pupils' - so far, so good. My problem is that when I export the information to Excel, the information from 'Contacts' is ONLY displayed alongside the FIRST related record from 'Pupils'. For Example: CONTACTS_____________PUPILS Mr John Smith________Barry Test _____________________Barney Fruitcake _____________________Tessa Tomahawk I need it to display as: CONTACTS________PUPILS Mr John Smith___Barry Test Mr John Smith___Barney Fruitcake Mr John Smith___Tessa Tomahawk I know why this happens, but is the…

I seem to running into some type of importing limit, but am not sure what the limit is. What are other people's experience with importing 10s of millions of records. Limits? Thanks.

Hi I want to be able to export fields from a record into an existing Excel file, and append to it rather than overwrite. This file is used by non filemaker users and therefore, keeping the data within FMP is not an option. Any changes to the file they make need to be kept. Not sure if this is possible/ Thanks Matt

Hi, i have a really primitive table. Basically 1 field. "Keywords" If I import new keywords (additional ones) via txt file into my table it checks for the ones that exist and imports only the new ones. Unfortunately it updates the existing ones, what resets the formating i have done to the keywords, like color etc. But the formating is a important factor for my base. So i am wondering, is there a way to import new keywords without updating the existing ones. I am thinking into a new table, than relate and compare. Am i thinking to complicated? In one script I did, the loop does not work for some reason, it works until portal row 2 an…

Access 2007 has a natty way of creating an email form that you can send to data subjects so they can fill in the form, email it back, and outlook works with access to automatically update the record. Does FM 10 have anything similar, or is there a way to emulate this?

I can't believe I've fallen at such an early stage of reacquainting myself with FMP. I have a very simple database set up with ten fields which will be an asset register. I want to import several Excel files into it that my colleagues have filled out. When I try this, even though I select the option to auto-serialize, it doesn't. What could I possibly be doing wrong?

My application has 8 tables. The main layout (called INPUT) has 6 records. The other tables are mostly 'transaction' tables. Here is the problem. I create a Cloned version of my app. Then I import the data into that version from a working version. When that occurs, I only get 1 table of records imported and all the other tables show with their relationships but they have no records. Waz up with that? What am I doing wrong? Thanks

I am trying to create a database to store content for a Flash file that will load the .txt and JPEG files into itself. I know data will be continually added to the content database, so my goal is to simply create records with date fields to order the records by, and site section names to find the records belonging together. I have created records with text and container fields. I would like to be able to find by section, sort ascending by record date and then have my script export my text and image container field contents to txt and JPEG files with names I specify in the script for each field and sequential numbers based on the record sort order. Example: fie…

Does anyone know if there is a plug-in or method to export FileMaker data to a fixed-width file formatted as UTF-8? I am working with a client who has to export data into another system and they require fixed width, and say there are no other options (csv, tab delimited, etc.). I searched the forums but only found an unresolved thread from 2007. I was hoping there would be some solutions in FMP 10...

Hello, I've done my best to browse/search for this solution, so forgive me if it's been covered. I'm trying to export data that exists in multiple tables to a spreadsheet/csv. When I do this, and there are multiple values, the export jumbles (seemingly randomly) the data that comes out if that data is in a different table. For example. In my database, say I have a Project table, a Company table and a Contact table. The projects, companies and contacts are linked via a key, but the data I'm exporting exists in their separate tables. When I export Project, I will often get Contact A showing with Company B and vice versa. It seems that the export is ignoring …

My task has two parts and I can't get either part to work! I have records sorted by SORTER field in a nice FMP layout that looks just like xl template. When I export to xl, using "Grouped by" SORTER and exporting all field onlayout, it just exports the first record per SORTER (eg. if "GROUP A" has 2 records it will only export the first, GROUP B also just the first, etc. So that's not working. Then, there's the template issue. Is there a way to export into an existing template, or is the solution still to do it in XL by populating xl template with data exported from fmp to xl... Any help most welcome! (fmp 8.5 upgrading soon to 9)

Thanks to the help file (not always do I find the perfect solution there!), I have figured out how to automate an export: Sort [Restore, No dialog] Export Records [Restore, No dialog, "Word List.txt"] However, the path is to the desktop and it's an absolute path which will crash if I move the solution or if during next OS install, I do something different and desktop has slightly different path. I need a relative path to the desktop. I need this script to work no matter what happens down the line. Also, I found this syntax on this forum message (http://fmforums.com/forum/showtopic.php?tid/210231/post/new/#NEW): Set Variable [ $ful…