Importing & Exporting

I'm sure the answer is simple but it escapes me at the moment: How do I sort (alphanumeric, ascending) the fields in the left-hand pane of the IFM windoid? I tried sorting the data file's fields by fieldname (in the "Manage Database for..." windoid) but that doesn't seem to have any effect in the IFM windoid. I also clicked in the Source Field bar in the IFM; no effect there, either. TIA for your help! Rich

I have the newest version of SOHO Notes and need to import my data from SOHO Notes to Filemaker. I currently have Filemaker Pro Advanced 10 but expect to upgrade to 11 shortly. Is there a way to do this import without reentering all the data?

Hello, I have a database with a single table and many layouts! Each record has its fields on each layout, the connection between the layouts for one record are 2 fields which concerns the name of the person! The main layout for pictures has 8 multimedia fields, where pictures are being added and a button to open another layout where the chosen picture is shown in a bigger format, there for 8 records for each single picture field, which are built as containers! How could I export all this pictures and import them in another database which has the same form? thank you in advance, I am learning alone how to use FileMaker I could use some good advices! …

Hey all, I have many, 200+, csv files that are updated very often. I am wanting to be able to auto import all of these csv files into a table in filemaker. So I wrote some code in C# to extract all my file names as follows filewin:/C:/Direc/TMA/CPAS/F09/CPAS, US, F09, TMA 377B, SEC 001, TMA, Teacher1.csv¶ filewin:/C:/Direc/TMA/CPAS/F09/CPAS, US, F09, SCED 476, SEC 030, TMA, Teacher2.csv¶ filewin:/C:/Direc/TMA/CPAS/F09/CPAS, MT, F09, SCED 476, SEC 030, TMA, Teacher3.csv¶ I then have put these into an array inside filemaker, all 200+ file directories. I then set a variable to change what file extension it is defined as, and go through the entire arra…

Hi, I created a button that activates a script to automatically import data from a text file. It does not import the entire file, but rather a select line based on another field. So, for example, if the entire text file said: Num Type 005 Cat 006 Dog and the "Pet number" field in filemaker said "005" then it would import "Cat" into the "Pet Type" field of a record that contains various info about a family's animals. However, there are cases when the "Pet number" field might say 010, which is not in the text file. When this is the case I would like to create an error message to let the user know that the pet number they entered doesn't exist. But I…

I am trying to redo a badly organized database, without completely losing all of its data. Right now, I have ten separate repeating fields of session dates for each client number. I have figured out how to combine them into one large repeating field via calculation for the purpose of exporting, but I can't figure out exactly how to proceed to my end goal from here. Since each session can be identified by Client Number and Session Date (no more than one session per client per day), I am trying to export each of the dates in the large repeating field along with the client number associated with each date, so I can later import this information into a new separate Session…

Is there any way to export DATA in FMP format with password protection?

Hi guys I am trying to do an import of xml data using an http request (after great help from Fenton with the xslt). However when i try and run the import (manual or scripted all i get is the following message: "XML Parsing error An exception occured Type: NetAccessorException Message: Could not open file {0} Line no 0 columnn no 0" No matter what I try to do to solve the problem (including stopping and restarting server, closing databases etc) I cannot get past this message now Does anybody have an idea what to do about this? Many thanks Simon PS apologies if anybody thinks this is a double post - the previous thre…

Hi I am trying to import this excel sheet into a modified filemaker template for time billing. I am not sure how to make the relations so that when I import the line items, it creates one record per billingID on the time billing table. I've tried a few things but so far nothing has worked. Any help would be much appreciated. I tried making a script too but it only made one record. Importtest.zip

I'm hitting a problem that should be relatively simple but it's beating me so I'm sure I'm doing something woefully wrong. When attempting to export to XML in a script, you have to set the Grammar and XSL stylesheet options. I'd like to store the stylesheet in a container and drop it before export to use in the next few steps. Makes the database much more portable. Easy enough to drop and I can drop the xslt file in whatever app folder FileMaker has launched from (via Get (FileMakerPath) ). That works great. Then, on my main data export step where I reference that stylesheet, it's failing unless I specifically hard code code the xslt file location in the "fi…

Hi, I have attached an Jpg image showing how I am trying to insert an Avatar image to a container using a script. My patient file image usually is blank.. this would be a temporary image,,,depending if Male or Female, I intend to stuff 1 of 20 pre images from a preset determined path....to fill blank Patient field by reference. Seems to be a path problem on the Insert command that works if I hard code the path Any ideas are help... TIA too

Greetings, I finally got Filemaker to view some data exactly how I want it done. It required me to create some subsummaries. Looks perfect on the screen. When I export to Excel, it also is correct, but I was wondering about something. If you were to export a summary field in a normal export... it would have a value for every row... When you export it in a Sub-summary.. it only fills in the top row.. then is blank until it hits a different value in the sub-summary. I was wondering if anyone knew a way to plug in the value for every field again... but maintain its sub-summary sort.... I hope that makes sense...

Hi all! i'm quite new to FMP so i hope you forgive my ignorance.. i want to import files into a container and i first started with "Insert file". as you probably know it works without probs in FMP but it is not compatible with IWP. does anyone know if there is another way to do that so that i can import files via a web browser? i tried to search for an answer but didn't find any.. thanks a lot! /nilsOhm

This might be elementary to some// My attached image display my 3 tables and they are related by an invno# Can't figure the schema to purge from a selected Invno# to the end of file ..to dataCoded file to my Desktop... How to get 3 tables out of a 1 file with 22 tables to 1 file? I have purge 1 table out to my desktop as 1 file (individual files) ..however I want to keep the 3 intact as 1 file... Some hints are appreciated

hello, the short story: Filemaker 10 is crashing on Windows XP when viewing a record with a container field that has a previously inserted mp3 file. So i have created a test file with one table and a container field. When trying to insert an mp3 file, the file selector does not show the mp3 option, it only shows aif, au and wav files. i have to switch to showing all files to be able to insert the mp3 file. After insertion everything seems fine, the file shows QT controls and plays. If I close and reopen the test file, Filemaker just crashes. Any ideas, please? thanks alex

I have a successful script for collecting "addresses for a found set" in a database that is starting to generate found sets over 100 recipients. As this grows there are IP concerns for the limits on the number of recipients any one email can have and the time it takes for FileMaker to crunch this much data and get into the email client. Is there a calc or method whereby the found set can be broken up in to sets of 50 recipients or less?

Hi All, I'm trying to setup an automated excel import (automated meaning no dialogs, importing from a variable defined path) and having an issue. When setting up the import script step the "don't import first row" checkbox is greyed out. I can't get that option toggled on permanently in my solution. If I allow dialogs to happen I can get at the checkbox during script execution, set it and all is well, but can't do it for the automated process. Is it because I'm defining my import source via a variable and not a hard coded path? Any way around this fantastic issue?

Hello, Thanks for any help in advance (best say that now before i get into this) My issue is as follows.. I have a db that has a record that has a table for a Quote that has an associated table that hold the parts for that quote so for example main table would have company name address etc & the other table would hold the parts list ie some widget another widget (this is displayed in a portal obviously.. This all works fine.. however i have a script that then creates a sales order (ie just copies the record to the new table (sales order) ) here is my issue i need to bring the parts list across to the sales order associated parts list table.. im a…

Dear FMP ninjas, I need some advice. I'm book-learned in FMP and I hit the boundary of my knowledge pretty quickly. But I'm the main expertise provider in my office, and we recognize FMP as a powerful tool for collecting project data. So I'm trying to make our DB as easy to use as possible for my colleagues using scripts, layouts, etc. Any advice, examples, pointers to online resources, etc. would be most humbly appreciated. What's got me stuck right now is scripting a comparison between two tables in my database and then merging data in a nondestructive way. To put my question in context, we are running a multiyear project for which we recruit 20+ part…

Importing Not: I have a found set in the table1 which I’m trying to import into table2, both in the same file. With no relationship between the two tables. (Manually to begin with then scripted.) The “Import Field Mapping” shows the records and count is correct on the source side and I can step through the records. To simplify things I have selected one matching field to import. However this is what I get in the Import Summary. Total records added / updated: 2 Total records skipped due to errors: 2 Total fields skipped due to errors: 0 Table created This leaves the found count in table2 the same, no change? What gives? Jerry…

I'm trying to use Export Records on a single record to export a single field containing XML code. The file needs to be in UTF-8 format, which is why I'm using Export Records instead of Export Field Contents. I'm exporting as a Tab separated file. The problem I'm having is that the resulting XML code is malformed because the carriage returns are stripped out and there is one single line. Is there a way force FileMaker to keep the carriage returns so the code is correct? When I use Export Field Contents the code is unchanged. Thanks

In my short time playing around with Filemaker I've run into an issue with the "Export to Excel" script step. The problem with exporting directly to Excel is that when you open the file it displays all of the information as text, regardless of whether the field contains numbers or dates. The only way to fix this is to actually go into the define fields setup and define each column as the correct number format and then enter EACH CELL BY HAND to apply the changes. Is this an issue that anybody else is running into with using the Export as Excel step?

I am for the first time integrating three files into one file comprising two parents, P1 and P2 and one child, C1, where the child records are displayed in a portal in P1. The key field in P1 is P1ID and C1 was set up with a key field of P1 as well in addition to is own C1ID; all are text fields and have P1ID :: P1ID is the relationship for the portal in the original and it works fine in the original. I brought over the layouts and turned of the auto-enter feature for the P1ID fields in the new tables prior to import to ensure that the records match the originals. The original and new tables have the same number of records and I have paid particularly clo…

Hi all I've been developing a database that allows my database to update certain pages of a website with information on my database however I'm having trouble exporting it in utf 8. In normal circumstances I wouldn't mind going through the pages and re-encoding them in Notepad++ but when it comes to several pages, I need an automated solution. Can anyone provide a preferably free way to do this. Thanks Ineva.

I have two files that are set up and working. 5 users access via open remote. One file is a container to hold pictures and video's. When I do a right click, insert Quicktime, select video and choose Open- the video file reference is inserted. I can see the video but others can't. I am reading that a quicktime movie can be stored, not just the reference... How? Or, In a situation where people are logging into a FM file remotely - how do we all upload a video to a folder on the computer via an IP address? Help-I can't find an answer! Thanks in advance.

Greetings; I know you can change the font to title in Filemaker, that makes it so that the fields are shown as Title Case, however when you export them they are still in the original case, is there a way to make it so that it exports a certain file in Title case?

HI not sure what Im doing wrong. If I import a file and update matching records (using match field) and select add remaining data as new records it ends up adding all as new records ie doubling my records. Strangely it doesn't always do this if I test just a few records. Is there a bug?

I'm a teacher with ~50 students. I used to employ Excel to keep track of grades, but more recently I've been shifting to using Filemaker, as it enables me to send out grade automated reports via email. But I still find Excel a lot more efficient for basic data entry tasks. For instance, I can hit "return" or "down arrow" to quickly move down through a data column, recording all students' grades for given assignment. I recently upgraded from FM 7 to FM 10, and the "Table View" is great for viewing my students' data in an Excel-like format. But I can't figure out what keystroke will move me rapidly down through the data column, from one record to the next, keeping the …

All, Anyone hit this scenario before? If you have a complex database with many tables and want to be able to script a data migrgation into the newest version from an older version, you have to set up lots of "Import" script steps, one for each table. The import source filename is set in the script by user entry. To set each script step correctly you have to hard code the file name temporarily during script edit so you can pick the source table name and the field import order (in this case "Matching Names"). After that, you remove the hard coded reference and slide in your $variable reference you know the user will set. My question is, if one table doe…

I was wondering if there is a way to transfer (integrate) one or more tables in one file to another file (including field definitions)?

Hi, I am not sure whether this is the right place to post this link and chosed this general import and export topic for this.. I am having an application in filemaker 9. Suppose a table Employee has all combination of field (text,number, date, container) This project was given to a development team to get the data into this application via ODBC from another ODBC compliant application say APPX.. From this APPX my development team was able to get text,date, number etc data properly in to the filemaker application. But they we not able to get the binary data in to the container fields of FM. Did anybody have been encounterd with such issue? Please …

Hello everyone, I have a problem trying to create multiple parts at once, this is the way i want it to work: I have a database where i have a field called part number, i have a different layout where i have a global field, so i have a scanner that scans a serial code, does an enter automatically (goes to the next line) and does the same thing until i decide to stop scanning. So i should look like this, 1 2 3 4 5 6 I want to have a button called create that reads all the lines but creates line by line. I hope somebody has a response for me, i would appreciate... Thanks in advance

We run a nightly script on a dedicated client machine that exports a series of csv files to several shared drives. If one of the shares happens to go down, the script hangs up when it can't write the file. Error capture doesn't seem to work on this type of error. This is an unattended machine, so we usually won't know when the script fails until the next morning. Does anyone have a technique bypassing a failure like this so the script will continue to run? Thanks!

I am purging only these 3 tables that are linked by their InventorNo. in a archived history file having 20 tables in it.. These 3 to 1 new desktop fp7 file. I have code working for the namedFile... I have currently working code that does an Export command of a found set of records, But its layout is of only 1 of my 3 files? I am stumped, thinking the flow or is their a simple way or must Export 3 fp7 files or do 3 Export commands? Thank you again?

Hi All, I am wanting to take my database off site and continue to develope. When I return to the office I would like to replace the old file with the updated one I will be working on. I imagine that it is a matter of importing all existing records from the old file to the new one, But I'm a little unsure about how to go about it. Thanks for any suggestions.. Ron

I have posted this question before... But I want to word it differently. When exporting from Filemaker to Excel format, is there anyway to provide custom column header information? Right now, it will export the column header as the field name, or the table Occurrence::field name. If I am trying to design a very specific excel report, is there a way to denote my own columns headers through scripting?

I'm sure this is a common need but I can't find a solution yet. I am making an "event record" in FMP and want to automate emailing it out to people. I see solutions for adding it to my own iCal through Applescript but I don't want/need it in my own ical but to send as a .ics file attachment. Any ideas? Thanks, Brian

My inventory file i like to purge tagged records to a History table inside my application.. I am trying to understand the flow. If I have a foundSet of tagged record It seems like must export out to a New file.. Then Import ? I looked a Copy All.. but don't get it Something I haven't needed to do before TIA

I'm doing a favour for a friend and I'm really pulling my hair out. I need to export a report to excel which contains sub-summary's sorted by date. It's a list of dates with totals which I can view on screen, print or export to pdf. However all I can get in excel is a list of dates with a grand total next to the first date. I must be missing something. Any help appreciated.

Is there any way to edit an image in a container from within FMP?

I have 1 client who has a problem with the Insert command (on Insert picture or Insert file.) The Insert functions are scripted and set to Insert with Reference only. When he tries to run any of the Insert scripts, his program immediately shuts down. My program is an FM10 runtime application. He is running on Vista Ultimate with Service Pack 2, 32bit. I have over 500 clients running my application, in various OS (both MAC & PC) and he is the only one that seems to be having this problem (at least that I know of.) Has anyone encountered a similar problem or have any idea as to cause or how to fix it?? Thanks.

Hi I volunteer for a not for profit organiasation. They use macs and iphoto to record the work of young people. They need a multi user photo library and I am looking at creating one in filemaker. However importing needs to be snag free and simple, as the people concerned are used to iphotos import functionality. I have hit a brick wall when importing. I can get them into filemaker ok, but cannot get portrait photos always show in landscape. I do not want to use the select photos option I want to creat some form of auto rotate or a script to rotate once the picture is in filemaker. I am importing images from folders or digital cameras. Is there any way …

I have an excel file that I need to convert to a "return-delimited" txt file. If I import the file into FM, is there a way to export it as a return-delimited file? (I tried to do it with MS Word, but it exports as "paragraph mark" instead of an actual "return", and the system that will be reading the subsequent txt file does not recognize Word's "paragraph mark" as a Return. Thanks much for any help.

Ok I need to export some info from filemaker and import it into a ecommerce app. This is an example for you in its simplest form 2 fields: a model and a description Model Description XYZ1 1.this is a very good model thatblah 2.blah blah it does all sorts of things 3.also good for this is a very good model 4.good for sports too Now when I export as a csv or tab .. the description sits all on one line... i need there to be line breaks on it. How do I format the description text so that the description does not sit all on one line??? At the moment im just getting: 1.this is a very good mode…

Rank newbie needs a nudge. How do I import a date field with the format YYYYMMDD from a CSV file? And as an aside, is it me, or are the FM docs a bit obtuse?

I have a global field that I'm trying to export into a file using Export Field Contents but FileMaker is creating a UTF16 encoded file. I need a UTF8 encoded file. Is there a system or FileMaker setting somewhere that can change this default? I'm on a Mac running 10.6 Thanks,

Introduction This is a simple question and I appreciate any help or insight that anyone in the community can provide. Background I'm a practicing family and commercial real estate lawyer. I have approximately 150 precedents (word templates with basic fields to automate processes such as other lawyer's contact information, pertinent client information, etc.) which I use on a regular basis. To date, I use a very simple Access database (about 75 fields) which contains the data I use. For input, I use 6 very simple input forms. Dilemma/Problem: I found out about FileMaker by chance. I downloaded the trial and I LIKE how it does things. I can imagine it would…

I'm using Save As Excel... to get data out of Filemaker. One of the fields is a text field (500 characters) and when it goes to Excel, the display is a bunch of hash marks (#####). Setting the cell formatting to "General" solves the problem. But the client is awful picky and want the text to display correctly without doing that last extra step. Is there a way to set the formatting of an Excel field to display the long text in a field?

In the table view can I copy a column of values and paste them into Excel? ...or do I have to export the entire table to Excel and copy/paste columns from spreadsheet to spreadsheet?

Hello, I have my database in FM7. I have a client who is using FM 5. I would like for him to have my information imported into his database. My files include photographic images. Is this possible? Thank you

Hi all - Simple question from a newbie (I hope). I am in the process of importing data from an existing database and one of the fields I use to track who entered the data for the record is automatically populated as a calculated value from Get(UserName). How do I prevent this from re-calculating and using my user name for all the records? Thanks

I'm trying to find a way to apply conditional formatting to a time field. The time field updates itself continually due to an unstored calculation, but I want the time (or else the field fill colour) to show one colour for working hours and a different one for outside working hours. Any help would be appreciated.

I have two files that have been developed by different users. Both contain data that is similar (First Name, Last Name, Address, etc). I am ready to update one file with the other, so that I only have one file in the DB. My problem comes with the update option. If I am updating file #1 from file #2, and file #2 has an empty field where file #1 does not, it overwrites the field with a blank. I must be doing something wrong. Is there a way to keep the field data in file #1 if file #2 has a corresponding empty field?

Hello everyone, Fmp 10, I am having a problem with my solution re. Pdfs. Here's what I need to achieve. I have a database with Pdf's stored in container fields. They need to be merged and saved as Pdf's to be attached to an email (each pdf has different content), each email will have 7 merged Pdf attachments, I am using smtp_it plug in to achieve this. I am merging the Pdfs and then saving to a folder,then inserting the files back into containers as ready to be emailed, yeah this works fairly well, although I am having some problems with the save and insert routine namely overwritng and naming conventions, I don't think this is insurmountable. My question is. Can …

I am trying to import (reference) all jpg images in a folder via a FM script. However, I would like to be able to tell the import routine every time the script runs, which folder to import (automatically based on certain parameters of the active record). Is there a way to achieve that? It does not seem as if the dialog box for the 'specify data source' allows me to have any variables in it

Hi there, I must be the nth to ask that but can't find a way to do it. Is there a way to export data to Quickbooks? If so, what is the type used to get the job done? Thanks for your help!

I have an export script that I use on a weekly basis. Is there a way to a variable that would name the file with the info from a field. So when I use script it will export the data and use the first date from a specific field?

Hello, I'm looking to email a record by using the "Open URL" Script using "mailto:" in that script. I can't use the standard "Send Mail" script because it will not open Thunderbird 3 . So, with my current script, I'm able to open thunderbird, address it, add a subject, and a body, but it will not attach the pdf that I save on my computer. This is what I have thus far as an example: "mailto:[email protected]?subject=Camden Service Call&body=ServiceCall&attachment=file:///C:/$TempPDF.pdf" Any help would be appreciated. Thank you - Jeff

I have an existing sub-summary report on a layout for InvoiceLIF records, sorted by Customer Name. There are calc fields that put each line item value into a category (separate fields for each category) then a summary field for each category field. The report displays everything properly in Browse mode (FMP 10) but then when I export it I get the sum of the field for all records placed in the field for the first record. The values for all but the first record are blank except for the Customer Name - I'm using existing fields that have been used for this report with no problems. - All the fields are summary (Total of...) - The export is grouped by the sub-sum…

I'm not sure if this is the right place for my question, but it is related to the ins and outs for filemaker. I have a database with product photos. All are arranged on an external hard drive because I knew that in the future our home business would expand to more than the one user at a time. I now have a network based backup hard drive at home, and want to shift the references to inages on the backup of my smaller portable hard drive which is now on the network. I want to use the portable one as a working drive - to edit images in the file when needed, and the edits being 'uploaded' to the database next backup. Is there any way I can change the file …

Hi, I have a table A with records. They are linked to table B, 1->n. I need to export the records of A and B in Excel. Everybody knows that the good way to do so is to go in table B and to export the records of B and the linked data of A one row for each record of table B. But... I need to export ALL the records of table A, and NOT all records of table A have related records in table B... So, if I am in table B before to export, I have no access to some records of table A... (those without linked records in :. I tried to find an answer in the forum, but whitout success. For me, the only solution is to start the export from a model of table A, but how to…

Does anybody have any insight: I'm running an import of some Excel files into my FM database. I started getting errors that space was low. I thought, because I'm accessing the database via a network connection to a different server, it was the server machine that was running low. Not the case. I looked at the computer I am actually running the database on and I noted the disk space left: 1.2GB. I ran the import again (and this import will delete the existing information in the table so I'm not making the table bigger) and I ended up at 1.17GBs left. Does anybody have any idea where the space is being used up when I run the import scripts??

I have a sports database with a portal of related records. I want to be able to export the data for use in a Quark file. I need to export all the data in the main table and all the related portal data as one line. Before I started using related records, I would use a calculation field like this to get the result I wanted: Home_Team_ID & " " & Home_Team_Final & ", " & Visiting_Team_ID & " " & Visiting_Team_Final & ¶ & Player_ID & " " & Scoring_Type & " " & Scoring_Distance With the data in a portal, I'm only getting the first record of the portal. How do I get all of the related records in the portal to…

Hi - Does anyone have experience with the FM-iCal Connector product from qutic? Does it work reliably? What level of expertise does it take to implement for publication to iCal?

Ms, Mr, I just created a movie DB. One of my data is the IMDB id movie number. With this number I can link to imdb. How to tell my DB to link to imdb.com with the movie id 1259571. Example: http://www.imdb.com/title/tt1259571/ What I want is the possibility to click on my IMDB id and be directed on the imdb.com web site. Thanks for your help Alain

Hi! I stored many file in a record (dwg, dxf, stp, pdf, jpg etc. every file in a container field) and the normal opening is not acceptable to me (right click to file name and save as...) Is there any script or something that will open my files with other application? I am still new in FM. If anyone know a good solution please write it with details. thanks.

This may seem a little redundant, but I have a solution built in Windows, but would like to rebuild it on MAC OS. I'm not familiar with MAC much, but can anyone give me some advice on the BEST way to go about this? Would I completely have to rebuild the solution in MAC from the ground up, or is there any shortcuts I could take such as importing script, layouts, etc?? Is that EVEN possible from Windows to MAC?

I have this tabbed interface with dentist patients' cards, and the X-rays for their teeth. One patient can have many X-rays, okay? If I click the tab for their X-rays, I am taken to a portal showing a row each for every X-ray for the particular patient. Trouble is: if the image file had been inserted using the "Insert Picture..." command after right-clicking into the container field in the portal row, then I don't have a quick way to see the actual file in a big window. And if the "Insert File..." command after right-clicking was used, then I have no visual feedback inside the portal: all I see for all the rows (and therefore all the X-rays for the patient) is the ge…

I have a client who needs an inventory tracking and CRM system. The CRM part is a no brainer, however his inventory is a bit of an issue. He sells cards that all have individual serial numbers on them. The cards come in blocks of 250 in the boxes with the beginning and ending serial number printed on the outside of the box. Typically, the process is this, a client will call in and order say 1000 cards. They create the invoice, charge the client's credit card and send the "pick ticket" to the back of the house for fulfillment. Problem is the back of the house will grab 5 random boxes to fill the order. My thought was to have them scan the beginning barcode a…

Hi, I am so new to databases and filemaker, it's scary. Now, I am trying to import data, a price list that updates regularly. Each time I import, based on matching fields, and adding new ones, it duplicates the existing data? I can't see why, when it's based on a field that doesn't change. I'd love some advice. John (Chase)

I have a scripted backup for data and development updates. For the data backup the script uses a check layout for each table, and exports idividual files. The challenge is that during development, if there are new fields added, these do not show up in the export without a manual "clear all" / "move all" step. I noticed that in the dialog, there are both Layout and Table selections. By default it reverts to the Layout selection. 1 - Is there a way to force the Table selection at export via scripting? 2 - Is there a way to force the "clear all" and "move all" via scripting? thanks

I wish to import from my Apple Address Book app. fields into a contacts data base in FM10 using lookups. I can only see it as a VCARD and FM imports all the data into one field. Anyone know how to get around this.

I need to create some export/import routines on Mac OS X client. I need to export the data to a temporary location which the user does not need to know about. I don't care what happens to the exported data after the routine is run. Should I export the date to /tmp ? Would /var/tmp be better? Or somewhere else? Just looking for best practice. Thanks, ft.

I am going out of town with my laptop computer that I have file maker pro on, and I wanted my assistant to update my data base while I am gone. Is it possible to do the database on an excel spread sheet and then import that completed data to my database when I return? I do not have my file maker books any longer and am not sure of the fields that file maker will require to successfully transfer all the info...Please help... Matt :

semi-regularly i need to import text files into a filemaker database. these text files are delivered to me with UTF-16 encoding and filemaker apparently can't handle that. the only option i see at this point is: 1. open the file in a text editor. 2. save it with UTF-8 or something else. 3. import that file into FM instead. not very slick. is that my only option or can i somehow trick FM into accepting the source file.

Hi All, I have a data base that runs on a networked harddrive, I have created a runtime to distribute to co workers to input data into. I am trying to figure out how to get the data they input to be updated on the fmp file and then sent back out to the runtimes, so that everyone can see any changes made by other people when they look at their runtime. (ie one person make a new entry in their runtime, the central networked fmp file is updated with this new entry and then the other runtimes are updated from the central networked fmp file.) I am doing it this way because we are a small company and can afford only 1 copy of fmp adv., thus the need for runti…

I am trying to get a server compatible script to export a found set to a csv file on my server. I understand from previous posts that when using Server 9 , the location of the exported file has to be very specific. This is what I have so far after the initial find has been scripted Set Variable [$filepath; Value:"filewin:" & Get(DocumentsPath) & "exportfile.csv"] Export Records [No dialog; "$filepath" ; Windows (ANSI)] When the Script runs on the server , i get the status "ScriptMaker script aborted" where am i going wrong. I also just tried using Export Records [No dialog; "filewin:/C:/Program Files/Filemaker/Filemaker Serv…

Hello, I am trying to import the below files. I know that the .xsl file is not completely right, but have come close. Problem right now is that the nested elements show up as separate records instead of all the same records. Although fields match. DNSWellness.zip

Hi I am having some dificulties in importing data from a txt file. In this txt file the date is in american format mm/dd/yyyy, while I want to import into a date field in european date format dd/mm/yyyy. I am not succeding in doing this. Any idea?

Hi, I hope someone can help me with exporting records to excel. In my FM database I have records with customer sales history, it is sorted by State and on the layout I have summary fields and then grand summary fields. I want to export a found group in FM to Excel but retain the summary fields. I have tried to import from within Excel but get the error message "object not found". I can of course export from FM to excel but I have no summary rows. Appreciate the help.

Hello. With the help of the forums and many hours of trial and error, i have successfully gotten my exporting working... mostly. My script does a find for specific records, then saves those as a FP7 file, then does another find for other records saves those and so on... ie: find records A... export as "records_A_found.fp7" find records B... export as "records_B_found.fp7" etc... The problem is that i have the export to path hard coded in and this works great on my mac, and i have even been able to getting working on my windows XP, however, it will not work on windows Vista. so, what id like to do is setup a variable to find the desktop path, l…

Hi I receive daily job orders in a Microsoft Excel Spreadsheet. One job per Excel Spreadsheet. The .xls files are made up of 3 sheets but I only need information on sheet 2. Sheet 2 is spread over 13 rows and 46 columns. In all there is over 200 cells with either text, number or date information. I only require about 30 cells to be imported into my Filemaker solution. What I can't do is somehow mark the required cells I need in XL so let my Filemaker script knows to import these. Filemaker seems to only import information on individual rows per record. Does anyone know if this can be done or should I be looking at applescript?

Printing.. is there a command that will right justify the field? Attach is jpg image captured showing some fields using debug viewer I understand in layout how to Right justifing text to show.. as seen in my layout image attached Looking at the viewer or the one msg_text_field, its left justified in fieldand is sent to print that way. I am trying to finger how to get it to print Right justified too Thank you

Hi All, I have recently purchased FM10 adn ahve imported my version 5 database. While I didn't have too many problems with the conversion it seems that the system now stops running at certain actions. E.g. I'm clicking a button that leads to another layout and the program doesnt do anyhting; when I click again I see the "not responding" message in the window and it takes ages until tit then asks me for a file that couldn't be found but the file it's asking for is still in the same path/directory. It sometimes does this for 5 different files and takes about 5 minutes until I have cancelled all windows and can return to working with the database. Has anyone had a sim…

I came across this post on the FM help forums: http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&message.id=28046 The poster (ralvy) included the following quote from the FM documentation: "If you import records from a closed file or an open file that is not displaying any windows, FileMaker Pro imports all the records, regardless of any found set." Can anybody confirm that this works as described? I'm specifically talking about the part about an "open file that is not displaying any windows." This is the behavior I want, but it doesn't seem to work. I tested by doing the following: 1. Open my destination file 2. Open the source f…

Never Mind!

Hello I am currently cleaning up a database, where ways to many field got created - an now should be removed in order to make it snappier. Now, if I delete some fields, the export records (to tab files) doesn't keep the corect fields. How would you handle with that issue? I'm quite confident, that the OS Version is not by any relevance. Is that right? Cheers and thank you for your feedback

I have multiple FM databases that are all similar, but from different "seasons". I am looking for a shortcut to save the export field order from one FM database and use that same field order on another similar FM database without having to manually reorder the field order for each database. Thank you for any help with this.

Specifying excel worksheet when importing Hi All, Is there a way to specify an excel worksheet when importing using script steps with no dialogue box shown and using a variable as a filename. See below screen shots: When you choose a static file another window appears prompting you to choose a worksheet, this doesn’t appear when using variables. The excel file contains multiple worksheets and I need to be able to choose which one to use. FileMaker Pro 9 Adv FileMaker Server 9 Windows XP Any idea’s?

I want to export files into a specific folder on the desktop. I am able to get all the files exported, but cannot fine a way to create the folder on the desktop first. The script needs to work for both PC & MAC users. The folder name will always be the same. I know there are plug-ins, but does anyone have a script that can work in native FM10? Thanks.

I have a layout that contains 33,466 records. But when I do a tab-delimited export and open in Excel, I get 33,491 records. Not only are there more records than in the source of the export, but some of the records that are in the source are missing from the export! (But represented by blank rows.) I traced it down to records that don't have a corresponding record in a related table. (But then I removed that relationship and it did not make any difference.) Call me a purist, but if I'm looking at a found set of x records and I do an export, I expect to see x records in the export, with no additions or subtractions! In this case, it looks like there are additions AN…

I would like to insert a picture for each product record in my database in a certain way and thought I had sorted it out - but I haven't. I have a folder on my server that contains product images and I have a container field in my database ready to hold these pictures. The name of the image matches the product code of the related item. What I am trying to achieve is to have a button trigger a script that will insert the right image into the container field for that product. With that in mind, I have created a calc field called 'path' which looks like this: "imagewin://SERVER/Images for FM Server/Lo_res/" & Product file::Item code & ".jpg" …

I have a script that saves records as Excel. One of the fields is a long descriptive text field. It seems like the default Excel field formatting for that field is "text", but when a "text" field has more than 255 characters, the text gets hashed out (####) on display. Changing the format of the cells to "General" fixes the display problem. Is there a way to change this default formatting from within Filemaker? Thanks, DJ

Hi Forum I have a tricky problem I just can't find a good solution for: I have an ordering database like so: Inventory_Items (things we sell) Sales_Orders (customer orders) Ordered_Items (things sold in orders) My boss has asked for a report that shows, for a supplied date, the items we sold summarized by name and listed vertically, and the number of each item we sold by customer listed horizontally. The customer list should be able to expand dynamically. The final result needs to be exported to Excel. Other than hard-coding summary fields by customer, I have no idea how to do this. Any helpers out there? Please?

I am working on a saveas pdf script, but have found that if there is a pdf with the same name as the one created, it get's added to the pdf. How can i get the existing pdf to be either deleted first, or to replace the created pdf?

I'm having difficulty getting Filemaker to export into a 100,000+ row excel file. For example I can successfully export a file with 1000 records but once I try to export 100,000+ records about halfway through the export Filemaker becomes unresponsive and crashes. Additional Info: Client OS - Windows 7 FM Version - FM10 Advanced Excel Export Format - .xlsx Rows - 100,000+ Columns - 30 I also receive the following error in my event log. Faulting application name: FileMaker Pro Advanced.exe, version: 10.0.3.303, time stamp: 0x4a3ad6bc Faulting module name: MSVCR80.dll, version: 8.0.50727.4927, time stamp: 0x4a2752ff Exception code: 0xc000000d …

Hi All, I have two FileMaker V10 databases that are similar in table structure. Database A and B. I like to synchronize tables in Database A to B. Is there a way to automate the synchronization? If not, I setup the Import script that upon the execution it asks the users for login name and password. Can I save the username and password within the script so it does not ask the users? Thanks in advance, A

Hi I have to create a XL spreadsheet that I can send out to workers to fill in and send back to me. I then need to import this data back into my FM database. Each XL document will have a unique job number that matches with my database and several fields that need importing into it's matching field in the database. I'm having trouble as Filemaker is only letting me import each row at a time and my XL data is only in 'column A' but 30 rows down. Any ideas

I am using a Filemaker database in order to create images from text fields (it's a "from text to image" process). I am creating the images using the "print to iphoto" option in the printing dialogue. Those images are exported to iphoto and from them to my ipod in order to create a kind of PowerPoint presentation. The problem is that the photos so created have a very strange name ("dCxLmt", "QBI8Nf" and the like). I would like to create photos with a title/name that relates to the record or can derive from it (let's say from a field content or formula). Is it possible to do something like this using the "print to iphoto" menu? Of course I can manually manipulate t…

Hello, Im looking for some advise and direction here... I have a database setup and running, but we are a unique situation ware we have to have multiple copies of the DB running completely separately at various times on multiple laptops. (no internet connection so FM Server is out) This is a customer database and each customer has systems and each system has inspections. At no time is the same customer, or any or their systems, modified by two copies of the file... so one person would modify customer A, the other customer B.(no worries about both editing customer A...ever) What i want to do is script a process to (weekly) import all created and modi…