Importing & Exporting

Hi, I am trying to import a space delimited file. File contains 8 columns and they are separted with spaces. spaces are not equal because the columns widths are different. Is there any way to import this file into Filemaker. I am importing it and its coming into one column (field). Urget help is required. Regards, Tusif

I have created a DB that among other things, exports a CSV file to the desktop. Everything works fine while in FileMaker. However, when use the runtime version, I get an error message: [color:purple]"output.csv" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. I tried logging in with the same admin privileges on both the FileMaker and the runtime version but the outcome is the same. Any help would be greatly appreciated. Thanks.

Has anyone tried to export contact information from Filemaker into FedEx shipping manager? I know there is software available to help with integration but all we really need to share is a couple of lines of contact info. Thanks for your help! Kelly

I am working on scripts for exporting and importing data for the purpose of upgrading to a new version of a solution. Scripts developed thus far work perfectly for everything but media (mostly photographs) in container fields stored as reference files; the media folder is dedicated exclusively to the application. So the question is, how does one go about importing media from one FMP file to another? As always, thanks in advance for wisdom and assistance.

I inherited support for a database and a user deleted some data that I then restored from a backup. Well, now I have a global field that has data immediatly when I open the database. I ran a design report and that field is not set until you run the script set for exiting the database. Why does the global field now open with a default value? Thanks Todd

Hi I have set up a script to import .csv files into my FM solution but what I would like is for the script to do this without me having to select each .csv file manually. The csv files have unique file names but are all saved in the same folder. Is this something FM can do. Regards Peter

Hello.. we are having import problems ..Our current table has several files empty imported from the old table. that used to work?! When I open our old table.. there are 4 of 6 files... that I must click the ShowAll button to see records. If I close table.. re open the same 4 files again, I still must click ShowAll again... This seems like a clue why Import is failing!! any clues please? [color:red]I have just edit adding my Import script in pdf.. xxxMain.pdf

I have a FMP8 database designed to match assessment records with a separate student database. I generate a unique key using student name and birthdate, and do a lookup in the student database for a student ID number. This works fine. However, I have a school with a "dirty" student database, where one student has multiple records in the file (the duplicate records have the same student ID). As a result, when I do an export from my assessment database, I'm getting a valid record (assessment results) matched to the first student DB record, and then a blank record (no assessment results) for the second student record in the DB. I know in other databases, I can force a specifi…

This is probably an InDesign issue, but I will post here first anyway. We are exporting data to ID as tagged text and that process is fine except for one thing. Any extra characters I have added (eg: paragraph symbols, spaces, etc) show up in ID with a leading value of 14.4. The other elements have a leading of 10.8 which causes the last line of the paragraph to have extra space above it. I have put these elements before and after I closed the tags, but nothing changes. Have placed in a template and a new layout with the same results. Help!

I have a database that lists all the rules applied to different avenues of the town. To be able to transfer data to the GIS communal I have to export (format excel.xls) with a line through in a single file. But if one takes the crossroads for example certain roads have several junctions and if I includes a voieID only the first line appears, other regulations disappear (which is rather embarrassing). Is there a way to combine exports and that all data on this path appear.

This filemaker database for our classified advertising has been in use for years. Every week we export the ads to a text file, that puts style codes (or tags) and when the art department gets it they place it in their template and it formats with the right style, size etc... by reading those codes. Now we are using FM 9, they have InDesign and those codes don't work anymore. Is there anyway to maintain formatting when we export the text or have it create a RTF file? Any suggestions, maybe there's a plugin?

Hello all. I've just realized that if I can extract a few different field sources of data from about 2000 MS word documents and get that data into some format that can be imported into my FM Pro database . . . if I can do something like this then I can save many hours of data entry that would otherwise be required to fill in my database with archived data. Please share any ideas you have on the subject. The fields would be: Gender (text, limited to value list), MedicalRecordNumber (text), SubmitterID (text), SecondSubmitterID (text), AccessionNumber (our ID, text), and ProvidedClinicalInfo (text entries of observed abnormalities or suspected syndromes separ…

I have a DB with 5 tables full of test results for a record (StudentID). These students (as a batch) only took two or three subjects (each subject is a table). I'm trying to have the teacher (using FM) choose which table to export for the batch of students. i.e. If this batch of students only took math and English, I would like an export only to export the Math and the English table. Not the Social Studies, Science and History tables. Is there any easy script process to do this? If I create and export records and choose all the fields of all the tables, the student will have fields associated with subjects He/She has nothing to do with. I can try multiple …

I have created a DB that prints out statements at the end of the month. I am using it to replace another DB that can export the statements to a CSV file and upload it to a service that does my billing. The problem is that I do not know how to replicate the CSV file. An example of the output for two statements looks like this: "VERSION","CA14","RunDate: 04/27/2008","Thank you for your business!","Payments after the 15th will incur a $10.00 late fee." "HEADER","3162 Avery Way","","Sacramento, CA 95853","(916) 358-9000","5150833","Zavil Adi","PO Box 349053","Sacramento, CA 95834","","03/24/2008","04/25/2008","28.00" "DETAIL","5150633","03/24/2008","Crd","*** …

I'm trying to set up a script to save a record as pdf with a specified name. The database is hosted on a server, and I cannot seem to get the file path correct for the client. here is my script: Set Variable ["filemac:Desktop/"&"PO" & Purchase Orders::Number &".pdf"] Save Records as PDF ["$filename"] My goal is to have the pdf saved to the desktop folder of the user's home directory. When I run,as is, I get an error that the file cannot be created on this disk. I think it's trying to save to the server or my file path is wrong and doesn't exist? Thanks.

Hi, I used to import data from repeating fields using FM6. It only imports data when the fields are not empty. Let's say RepeatingField(1) to RepeatingField(3) are not empty and RepeatingField(4) to RepeatingField(20) are empty. I will end up having 3 new records because I choose the "Splitting them into separate records" option. The problem is, in FM9, I end up having 20 records even though 17 of them are blank. Am I missing something here? Thank you for your help.

I'm using FMPro for Mac, which is my default database. I regularly export my records from FM as tab-delimited, and then import my records into other programs, as my data changes. One of my primary targets is Apple's Address Book . . . this is so I can sync with my phone, etc. In FM, I have a comment field that I would like things listed on different lines. For example, Steve - 584939 Karen - 998373 When I export my records from FM, each record is obviously separated by a paragraph return. What can I do within a text field in FM to show the line break . . . that . . . when I export my data, will be recognized as a line break and not a paragraph return?…

Dearest Gurus, I've got an excel table whose *cells* (apart from row and column headers) *each* need a corresponding *record* in FM. (Each record would be based on three fields: rowheader, colheader, value) -- I'll then have more fields to add in FM9. Essentially, I want to convert the sheet not into an ordinary table, but into a saturated join table for two existing FM9 tables (one organized around the columns in the Excel sheet, the other around its rows). There must be an easy way... any hints?

I just changed to a new computer and upgraded to Mac OS X Leopard 10.5.2, and now I can not export my records from Filemaker in Excel format. Other formats are working ok. I post a screenshot of the error if any body maybe knows about the problem? Thanks!

in a current solution i am working on that has about 2000 records it takes several minutes to export this data via xml to csv or even tab / or any other format. Takes minutes and the counter steps in increments of 5 records at a time. This file is single user local. And still takes awhile to finish. Trying to figure a way to speedup the export, as this is only the tip of the iceberg soon there will be thousands of records. Thoughts?

Is there a way to export a page from FMP as Tiff or Jpeg format automatically ? any plug ins ?

I have a "processing" Database that imports an Excel Spreadsheet and places the appropriate data into Filemaker Tables. Its a long story but I am forced to do this in a two step process. First I import the data into a FM database called ConvertedData.fp7 and then I process that data from a second Filemaker Database. When I import the Excel data into ConvertedData, I close the ConvertedData.fp7 and go on my merry way with the second Database processing as it should. The problem is, if I proceed to run another spreadsheet through this process and attempt to "overwrite" the ConvertedData.fp7 file it stops me and says it's locked and can't overwrite the DB. I …

I have an advertising task management solution that we developed some years ago and are now we are streamlining. When an ad is planned a record is created in our "Media" table. When it is confirmed I want to automatically create a record in our "Design Tasks" table. The simplest way seemed to be to create a script that copied the relevant "Media" field contents and pasted them into relevant fields in a new record in"Design Tasks". However some of the target fields are required to be "not empty" (and we want to keep them like that), which causes the script to stall. Any advice?

I am attempting to batch import a folder full of PDFs as pictures. Everything works smoothly, except that FMP seems to be only importing a reference to the file, despite the fact that I have the "import only a reference" checkbox unchecked. Anybody know what I need to do to import a folder full of PDFs and have the data stored internally? (If this is a bug in FMP8 but has been fixed in FMP9, that would be good to know, as I have 9 on order.) BTW I found (here on the forums) a nice script to batch import PDFs but it imports them as files rather than as pictures, and also doesn't traverse subfolders, so won't work for me.

I have a database with some students that makes their applications on the internet injected in a MySQL database. When I use the ODBC function to import new records, i choose the option "Add new records" box only. Not any updating etc. But still the extra fields that I have in my FM Pro database gets deleted. What going wrong here?

Has anyone successfully connected FM and UPS Worldwide Shipping? If so, I'd like to learn how, basically trying to get the tracking number into FM each night...

Hello Guys, Im writing an csv export, so an accounts package will eventually import the data in. I have the CSV format the accounts package requires. Ive been mapping the fields from my app to this, and I've created a couple of calculated fields with a number of commas in. When I run the export the field that I have created which contains lots of commas in has quotations going around the first comma and the last comma. What I need is quotations going around all the comma's. My current stored text calculation for field comma5 is ",,,,," Output in csv is ",,,,," Output I would like to achieve is ",",",","," Many Thanks Jalz

Hi there..I have something that gives me a headache: I am building a new imageworkflow to make the image handling easier. This is how it goes: 1. put image in dropbox, folderaction attached, which triggers importscript filemaker. 2 Importscript FM imports and processes images: makes link with "product-database" and export images in the right directory/image archive, belonging to those products. 3. Images in dropbox are deleted. With that last step however my hires preview is lost (obvious). I thought that if I give the new path of the image to filemaker it would "see" the image in the new location but that assumption is wrong! How can I fix this? In …

i have been asked to create printing templates (business cards,envelopes etc) using data in our FM 9 system and PDF backgrounds supplied by the printer. The problem is that if I try to save a small PDF, like a business card, the output file is a full page with the little card in the northwest corner. Is there any way to output this PDF in 100% scale without the extraneous white space and without using another program to trim or crop? Thanks

I'm totally pulling my hair out. I'm trying to export a sorted portal which contains 54,858 records out of a total 130,000 records. Each time I try to export the records, I get 65,548 records. My export is set up to export from the current layout and I have chosen the fields associated with the portal. Can anyone tell me what I am doing wrong?

I've got this kick-ass little app built for one of my clients that allows you to push a button in FM, select the images off your camera you want to import, and then it automatically resizes, rotates, and uploads them to their web server. The problem is it only works on a Mac because of the Import from Digital Camera option not being available on Windows. Kind of a bummer because most of their users are on Windows. Any idea if/when this feature will be available for Windows?

Saving records as Excel crashes FM. When I try to import a file I get an error message: No fields are defined in data source. None of these problems occur on my lap top (10.4) that has Excel. On my iMac (10.5), FM does not like to interact with excel. I can work around with CVS files fine but, this is not a long term solution. Does anyone know what is causing this? Do I have to instal Excel for the FM functions to operate?

Hi, This has to be quite simple to solve elegantly: I am exporting a table made of several fields, one of them summarizing a total, some of the rest are part of the sort order. The exported table is correct except that the fields that were in the sort order of the original table appear in a single record of the exported table. I want them to appear in every record, so the only way I found to do it is to duplicate the field so I have the sort version and the export version. An ugly workaround don't you think? Do you know how to make it better? Thanks for your help.

Ok, I've done something stupid. : I've created a database with several related tables. The main database generates a serial number set to increment by one. I didn't make it unique (should have just didn't remember to do so), but didn't worry about it since the serial number is auto-generated and never seen by the users. What I'm finding when I do some work on the database, and then importing records into the modified version, is that the database creates duplicate serial numbers. Needless to say this is creating havoc in my relationships. What can I do to fix this?

Hi, all. I've successfully imported a lot of data from an Excel file into a database table. The only trouble now, and it is rather small, is that I have some fields that contain many separate terms that are separated by commas. These terms are all related closely and therefore they do belong in this field. The trouble is that when new terms are entered via the check boxes on my entry form, they're going to be separated by hard returns. This often looks better, although it takes up more space. How do I replace my commas with hard returns using "find & replace" or with a script? Alternatively, how do I change the configuration of my data entry checkboxes/fields s…

Hello For quite sometime I have been trying, in vain, to get round a (in my opinion) completely redundant FM server issue concerning referenced files in subfolders and servers. I have 20,000 pix that I (with the inestimable help of many of you in this forum) set up in an FM db many years ago. At the time, the thinking was that pix should be referenced to keep FM file sizes down & therefore speed up the searches. Then I discovered IWP and recently PHP and in both cases I have discovered that the server will only see containers elements that are either embedded or referenced in the same folder as the file. As having a folder with over 20,000 pix is not very motivating…

(I'm putting it here because I classify it as "exporting" data out of filemaker, but it's not really. I didn't know where else to put it). I need to generate/export a log file of all changes made to any record in the database. IE, if a user changes anything, it gets noted in a log "At 12:05pm 01/04/2008, Username modified FieldName in record RecordName". And the log-file just racks these up. The problem, obviously, is that it could get rather large, rather fast. What is the best (most efficient) way of doing this? I've got a small-ish database at the moment, but needs to be able to scale to an enterprise-level if needed. My thoughts are to have a globa…

Does anyone have any tips on converting my nice normalized database into an Excel spreadsheet? A client wants to export Contact Info and Address for Contacts to Excel. There are multiple Contact Info records (phone, e-mail) per Contact and there may be multiple Addresses records per Contact as well. All three are separate tables. The client would like each related record in separate cells in one row per Contact, ideally with the Address and Contact Info data in the same row. I'll take just the multiple related Contact Info records in one row per Contact though, if anyone has any suggestions. Thanks

hi, I need to perform an auto-import from a csv file on that is on the web at http://myip/file.csv i tried to set up a variable to 1) fmnet:/http://myip/file.csv 2) filewin://http://myip/file.csv none of these work, only when I manualy import. Ver FMP9 any suggestions?

Hi, FWIW, I came up against this about 18 months ago, but I just cannot remember how I worked around it... ugh! I'm importing records from a FMPro local file to a FMPro file hosted on a server. I need to mark the imported records with a date after the import. If I do this manually, the imported records automatically show in a new found set of imported records in the server file. then they are easy to mark. However, when I script this import as part of a larger routine, the imported records are appended to the existing records in the server file. They do not show in a discrete found set, or even the existing found set. Can someone please remind me…

I am trying to copy some numbers in Filemaker from a single text field and have it paste horizontally in Excell. IE: Each number goes into a separate cell. I cannot locate a tab character to insert between the numbers. Also, is it possible to copy something to the clipboard without first placing it into a field? Thanks in advance.

Hi, Anybody know an easy way to get 3000 addresses from a FileMaker database into a GPS unit? I'd like them to be shown as waypoints/points-of-interest. Possibly via parsing the addresses into longitude/latitude? I am looking to get clients' addresses from our customer relationship database into GPS systems. This will help oour mobile sales team sales team. FYI, all addresses are in USA and we are open as to which model/brand of GPS units to buy. Has anybody had any success with this? ft.

Hi There My small business employs 2 sales people. They wan't to work from home, so I need to find a simple solution that a FMP database on their computer (at home) can "talk" to a FMP database on my computer at the office. By talk, I mean any sales they capture, for example, would need to be able to be sent to the office computer (via a DSL connection) once per day. Similarly, I would like to send them data such as new leads. The only method I can think of is to export the required data, email it, and import it on the other side - but this is not ideal. I don't wish to use IWP - any ideas would be much appreciated. Thanks

Hi everyone.... I wonder f someone could give me some tips on how to export my FileMaker Data to MYOB application. I'm actually trying to gain knowledge on how to do that as far as my programming skills is concerned...... I hope that there's someone out there who could really teach me the basics.... Just a bit of a background, I've never used FileMaker Pro eversince.... I hope u understand.... -sonOfGod

I've just begun work on a databook that is formatted in InDesign, but all of the data editing is done in FMP. My predecessor seems to have exported to an excel file and then imported that as a table into InDesign, which I'm hoping to avoid. I've seen a plug in by 65bit that purports to export directly from FM to Indd. Does anyone have any experience with this product, and or know of any other options? thanks, sara

Hello all I'm looking for a little bit of guidance before I start going through manuals and test scripts. I have a large database and I would like to script the process for exporting a new file (archive?) with a subset of found records. To accomplish this I am thinking of doing the following: Scrip steps 1. Save a copy as - using the clone option so that all layouts, table & relationships are intact 2. Use applescript to then export records from existing database to new clone. As you can see from above after step 1 I'm not quite sure what path to take. Any advice would be greatly appreciated. Best Kilby

I have data in a table in Microsoft Word 2007 document. Is it possible to import this data into FM so I don't have to retype it again?

Hi All, I'd like to store the path to a file or file reference that has been inserted into a field. I'd like to further be able to export that file path, along with other fields in the same or related table, into an Excel database, such that a person on the same network can click that file reference in the Excel cell and it will open that file. Is this possible? With or without the Troi plug-in? Sounds like a tall order; I remember that the Troi file plug-in enabled one to at least store the path to an inserted file in a field. Thx!

Can anyone help? Fairly newbie so apologies if the script is a bit chunky. My database has several image containers linked to text fields with the file name. The AutoCalculation function in each container is: "imagewin:/"& $$id &"/"& Image_ID &".jpg" (Image_ID is the text field). The container result should look like “imagewin:/D:/EUKL/FILEMAKER/Images/0003166.jpg”. When I import my database records from xls I run the script below to activate the image links. My problem is some links work and other are missed, although when I edit each missing link text record the link is established. Is this a timing issue and any ideas how I can shorten…

Hello there, I have 3 tables in my filemaker database. BOM, VPN, MPN BOM can have multiple VPNs and VPN can have multiple MPNs. I have to import data in regular basis into these tables. My problem is i get a single excel sheet with VPN MPN Description etc. How can i load data into these tables? I created a table which will load these values and tried to set relationship from this table to VPN and MPN. But Im stuck. Anyone please help me sort this out?

Hi ladies and gents... I've not been around that much but here, again, a problem I am facing: We have about 10.000 hires images which are linked to about 5000 products, all done in Filemaker 9 Server Advanced. To get and/or update those linked images we perform an "import folder" script which imports a reference into a separate table for linking: works great but takes a while. Now I wonder: HOW can i import the images of the current active record? Name convention: SKU_.tiff and SKU_detail1 or SKU_fx1 and such. In other words: behind the underscore is variable data, not always know to the user. (example: D41112_.tiff, D4112_detail1.tiff, D4112_detail2.tiff and D4112_2d…

Using the two-file separation model, I occasionally import all the contents of the data file into a sightly-modified structure. This month, I've re-encountered an import problem that has plagued me since I started using FileMaker: Scripted import definitions are unreliable. In my current attempt, I'm trying to update 11 tables from the previous database using a scripted import. Ten of the tables work fine -- all fields correctly map into the new tables using the Matching Names option. But on the 11th table, FMP invariably displays the fields in a jumbled match order (and declares "last order", of course) -- even though the import step is set up in the same wa…

I receive about 20 folders a day, containing 10-20 jpg images each. I keep them as sub folders in a master folder. I would like to keep that structure, since other applications make use of them, too. Right now, I copy all new folders to the master folder and then do a scripted import, by first deleting all records in my FM table, then doing a folder import with only referencing each picture file. I suprassed the 50.000 picture mark and needless to say, the script runs for about 20 min. I tried just 'adding' the new ones instead of deleting and reimporting, but what takes the time is the scanning of the folders and not the actual import. There has to be a better…

Hi has any one had experience exporting audio files from FMPro 9 I am wanting to export them as .wav files and attached them to an email Cheers D

I have a script that prompts for file selection, then imports and processes the contents. One of the fields is a date field. Not today's date - as I don't always run it every day, but there's a file per day. The date is however contained in the filename, so I want to be get the name of imported file.

I'm using 'Export Records' to send out some name and address details into a file. The data is stored in fields as all lower case. When I export a bunch of records via a layout button I check the 'Apply current layout's data formatting to exported data' option but output file still produces the data in lower case. I have applied 'Titlecase' style to the necessary fields in the layout both in layout mode and browse mode. All I do is 1) Enter find mode, 2) perform a simple record find, 3) Export a few fields from the resulting found set. Any ideas as to what I may be doing wrong? I can onky get titlecase output for these fields if I happen to have input them in accurate…

Hi there I am trying to import an XML doc into Filemaker, and am experiencing problems populating the FileMaker fields. I'm new to filemaker and I realize I am probably missing just a few crucial directives. Could someone take a look at my stylesheet below and recommend the missing textstring or point out the incorrect code? Note: when mapping in Filmaker the 3 field names align correctly with their tag names, however the Import Summary indicates that 0 records were added or updated. Thanks! <?xml version="1.0" encoding="UTF-8"?> 0 NAME="" RECORDS="" TIMEFORMAT="hh:mm:ss"/>

I have a database of contact information and as the data grows, more and more of it is cut and pasted from emails, spreadsheets etc. Unfortunately a lot of the fonts/sizes/colors of text are also embedded in the text that is getting pasted into the fields. Is there a way to impose standard font/size/color on the text in the field?

I was wondering if this is possible (seems like its not to me, but maybe there is a workaround)? I have a table (Task). It has two related tables (Budget and Funding). Both the Budget and Funding tables can have multiple records for a task. Is there any way to do an Task export to Excel that will contain all of the Budget records and all of the Funding records? I understand how I can pull from either the Funding Table or the Budget table individually, but not sure if its possible to include both on the same export for a task. Thanks for any help!

Hi everyone, I'm using FMA 8.5 and was wanting to have a button on one of my layouts that when clicked would fill the fields in on a mailmerge in word, but only for that one record. Please help Hayden

Daily I import and parse a report from a mainframe computer. In FileMaker, prior to the import, both the FMP table containing the raw imported data (~~ 70k records) and the FMP table containing the parsed data (~~ 7K records) are emptied (select all, delete all). After importing and parsing the data, I need to post a summary of the information to a third table where a summary history of the parsed data is maintained. Presently I export a summary .mer file (~~70 records) which I then import back into FileMaker in the Summary table. This process is scripted, but the user still needs to name the export file and make sure it is a .mer file. This works fine except i…

Hello, I need to get some data from FMP7 to an oracle database, I was thinking of using ODBC but I can't make it work. Is it possible to access the fmp7 data from ODBC without opening the files I want to access? I installed the ODBC on the FMP server but it still doesn't work. Has someone successfully accessed FMP7 data through ODBC ? If not possible, is it possible to export data from FMP7 by batch (without human action)? Thank you in advance for your help, Olivier.

I am trying to create a stylesheet for an xml file. I have never done this before, so, I reduced the xml file down to one field to see if I could write the stylesheet. I am encountering one error message on the import and cannot figure out what it is. Can anyone help me? Thanks. xml.zip

Hi, looking in to the forums, I can't seem to find a solution to my problem. Maybe someone can help me out here? I have two FileMaker 9 files with a table in it. In the first file I have a lot of records containing information. In the second file I want to import a selection of records based on the content of a field in the first file. Some sort of a conditional import, almost like a relation between tables. Am I missing the obvious? The ultimate goal is to create one table witch contains records filled with information from 3 different tables within one file. This one table I can then sort, format and use for reporting. Thanks for support!

Hi. I want to import an excel spreadsheet full of data into FMP 9. Problem is, FMP only allows me to import records laid out as one in each row, with field names in the first row. My spreadsheet has field names in the first column, and each column contains a record. Anyone know of a way to get the data imported? Thanks, Carl

Hey, I`m a beginner in FileMaker, maybe my question is stupid... I have a field A with a lot of records and a field B. And now I want to import all records of field A and concatenate it in just one record in field B. I`m trying to do this for about a week without success... Can someone help me?

Hello everyone. I could not find a general questions forum, but I thought maybe those of you import/exporting from an Access database may be able to help. I am fairly new at database design in general, but I have been learning Access and VBA for a couple of months now (in my spare time). As it turns out, I cannot create a report in Access the way I need it to look, which is basically like a spreadsheet, with my table field names listed down the left side of a page, and the records in columns going to the right. There is a picture (!) on the FileMaker website here (The expense report) http://www.filemakerpro.com/products/fmp/communicate.html I have been told t…

I want to be able to create an email with an attachment. The user will create a record in a table named email. There are three fields, subject, body, and attachment. The send email script puts all of these fields together but when it sends the email, it puts the attachment on top of the text. Is there any way to send the email properly with the text on top and the attachment on the bottom?

Some unenlightened neanderthal produced an ms access database with 2 million records which I need. Exporting to excel breaks down at about 65 000 records Exporting to a csv also gives me an error at some large number Any other ideas please?

Hello All, I was wondering if there was a way to import Excel data into FM and create a Value List from that data. I have done it once but when I try to put the info into a drop down list it doesn't show up. thanks

Hi all, I am new to FileMaker Pro (FMP). Currently involved in a short R&D to find if FMP would be a ideal solution to be used with one of our existing Products which takes an XML file as input. For this I have downloaded the FileMaker Pro 9 demo version. I was able to create a catalog database in FMP9. Also I know there is an option to export the database to XML format. Then using an XSL stylesheet it is possible to convert the XML to the format that can be used with our existing application. We want to store pictures directly into the XML file in BASE64 format. However I found that FMPs container datatype cannot be exported to xml. So is there a wor…

Howdy, all: I built a simple script that imports the records from an old .fp7 file into a newer one, but with every import script instruction I have to manually enter the old file's password to gain access to the data. This is fine if there were only one table, but there are eight tables' worth of data so I have to enter the old file's password eight times as the import script progresses from one import record instruction to the next. (...and yes, I have the "Perform without dialog" box checked.) So, my question is, is there a way to import all eight tables' worth of data in one shot so the password only has to be entered once? Or, is there a better way of impor…

I need to figure out a way to monitor (by monitor I mean that I need FM to have the ability to see if a new files has beed dropped into the folder so that it can begin the export process)a folder that is being used to drop new xml files for importing. The files all have unique file names. such as "Record.6845615.xml". I need to be able to delete the files after I import them. Any suggestions? Prefered plug-ins?

I've got a solution setup where the database is residing on a shared drive (for security reasons) and the database is being opened single user. I have a script run that automatically exports records to a text file on the user's desktop. I get a write error when it tries to run the export (not enough room on the drive, change the name, etc.). When I move the database to the C: drive, it exports fine. We are running Windows XP. Anyone have any idea how to get this to work without moving the file to the c: drive? Thanks for your help.

Hi guys. i am epxorting as an xml file for each record from my fmpro db. Problem being it will try to replace the previoulsy generated xml file with the latest generated xml file as the names are the same!! is there a way i can name each individual xml file automatically...dont really want to do this manually as i have 1000+ records to export each record generating 1 xml file!!! thanks.

Hi Guys, i need to find a way to export the meta data from my FMP6 db to my FMP8 db...both databases are the same just in different versions of FMP...i had to do some development of a new table in the FmP8 db. Thats why i cant just do a full migration! I do an XML export but it wont import the xml file into the FMP8 db as there are errors such as unicode!! : : : . The database is a fair size so i cant scroll through the xml export looking for illegal chracters etc as this will take months!! Any help please?: Thanks.

What strategy would you use to: *export a single record from a multi-table FMP8 file "A", thus creating a single FMP8 "satellite" file (with data from the multiple related tables), that can then be emailed cross-country and imported into a database similar to the original file "A"*

Set Variable [$path; Value "file;" & Get(DesktopPath) & "Name.pdf" Save Records as PDF [Restore; Append: No dialog; "$path"; Records being browsed] I would like to replace "Name" with a Parameter or calculated expression. Any thoughts?

I want to import multiple .csv files into one Filemaker database. During the import, I want capture the file name of the .csv and place it into an empty Filemaker field for every record related to the .csv. The goal is to identify from which .csv any record originated after I am finished importing all of the .csv's. Thanks in advance for all of your help! Earle

I have a large Excel file that I have decided to put into FileMaker for work. I believe this would be a good way to put into use what I have read about and learnt through a book I was reading (Filemaker 8: The Missing Manual). What I want is a Filemaker layout interface where my boss (or me) can filter the list by date and by company and have a report printed which will summarize a company with a sub-total. The Excel spreadsheet uses calculations as well, please let me know how you think the best way for me to import this file would be. I want each company on a new page as the companies have to be sent the report as a form of invoicing. Does anyone ha…

We're trying to create a Filemaker file that will perform one task: importing reports that are in XML format. The reports are always in exactly the same format, and an XSLT file has been created that successfully does the job when referenced as an external file during the import process. Now we'd like to embed the XSLT file in the database. Yet every time we do this we get an error message: We've tried pasting the XSLT in a text field and we've tried pasting it directly into the relevant box in the Import XML dialog box that is part of a script. Any tricks we need to know, involving line endings or characters we need to escape in the XSLT language?

I export serveral hundered of these records a day, and I keep running into this problem. When my unix box tries to import and parse the records i get errors on some of the records. I believe they are due to some type of wierd imbeded character, but have been unable to find them. I am including a copy of good and bad version of the same record. You can see the issue if you try to open them in FireFox. IE seems to open them both fine. Any help would be greatly appreciated. fmexport.zip

Is there a way to export a Time field that would export the Time Format along with it? For example... If I have a Time field and I put "20" in it, I get "8:00 p.m." When I go to export that field (or convert it to text or what have you) it simply exports "20". I want to force it to export the formatted time. I've tried a number of different ways, but nothing seems to work as flawlessly as I'd like. Any help? jon

First off, have not been here in a while, amazing category list. AJAX and Flash were the last things I would expect on the Filemaker forums, we have come a long way... To my problem. I have not done this in a while and I am sure (maybe I am wrong) that you can change delimiters for an import but I cannot locate where do to this option. I have been sent a CSV file with the 'pipe' as a delimiter. I am helping an academic researcher with a project and she sent me this file. Thanks so much for any guidance

Hi, I have a FMPro6 db which i have placed in to FMPro8. I then further devepled the FMPro8 db with some new tables. The original table i converted from FMPro6 to FmPro8 now needs the data transfering from the FMPro6 db to the FMPro8 db. To do this im exporting as XML all data and the trying to import the XML file in to the FMPro8 db...problem being it errors!!! i get an excel parsing error: Invalid character (Unicode: 0x1) Line Number:191185 Column Number: 10 Is there another way to do this? can anyone help me please??? Thanks.

Hello - Okay, I am lost. I have rummaged through some examples here, but I can't seem to get my XML database to import records into FM9. I got one example to get me though without errors, but no records import. Here is a truncated version of my xml file: <?xml version="1.0" encoding="ISO-8859-1"?> 2/26/2008 My [email protected] "xml.asp?uid=0000&order=appliedto&direction=up" asc desc creditcard issuer 1144 Card Name bank and the xsl file: <?xml version="1.0" encoding="utf-8"?> 0 …

I think I have found a way to get at my data for the header - export field contents - but can I append a file ---- write to the same file over and over - appending without overwriting ---- how do I do that?

Is there a way to export text which has bee styled in FM (bold, italic, underline, etc.) to HTML and still maintain the formatting?

I am exporting one field named export through a script step (export records) - the field is fixed length. All is good. Now I need to add a header to this - save with another fixed length field (one record - it is summary data). Can I use another Export step ----- but append it to the same file? I know I can use a summary field - but can you format the summary field to fixed length? Please help - Thanks

When exporting a field using a check box, if multiple values are selected, the export looks like this: 80 85 Where "80" and "85" are two different values. Does anyone know of a way by style sheet to seperate these values such as: 80 85 Or something similar? The program I am exporting to does not recognize the the data together on one line... Any ideas would be appreciated!

Hi, I've read in many posts that it's possible to export or save filenames based on a variable field. Is there a way to achieve the same thing in version 6 ? If not, what plugins for version 6 would do this for me? Thanks, Steve.

Hi! I´ve read several posts on this forum and tried different xsl examples, but I still have the same problem. I get double in my exported textfile. To explain the whole problem: I want to create a file from a textfield in FM. The textfile acts as an command parameter file for a 16 bit DOS-program. I I create the textfile in Notepad and run the DOS-program all works fine, but if I create the textfile from a exported field in FM it won´t work. The export field does not work. Ive tried the export as XML with an XSL file that looks like this: <?xml version="1.0" encoding="utf-8"?> xmlns:fm="http://www.filemaker.com/fmpxmlresult" ex…

I have a FilemakerPro database with many records that I need to send as an XML file to the EPA. I can export as an .xml but I need to add headings and structure the file in a nested format. Is it possible to create this type of file with filemaker? If so, any tips on getting started?

Hi there, I am trying to export a tab delimitated text file for importing into another system. The problem is that the other system doesn't like the line feed (LF) and Carriage Return (CR) combination that FM produces. It only wants to see the LF character. Does anyone have an idea how to do this. I believe there may be a solution using XML, but I'm not familiar with xml.

Hi. I just wanted to get some feedback what you thought were some of the best practices for importing data. Should I back up the table first? Thanks. Charles

Hey all, heres my problem, basically I have a script which runs the import process at the click of a button but what i would like to do next to the button is show the date last imported heres and example of my import script: Show Custom Dialog["warning message"] If[Get(LastMessageChoice) =2] Exit Script[] End If Import Records[No dialog; Source: "filename.xls"] all help is much appreciated. :)

I found a nice way to send an email of a text-based record: Set Variable ($email, "mailto:"& YourTable::Username& "<"&YourTable::email_address&">?Subject="&YourTabl e::EmailSubjectField&"&Body="&YourTable::Field_A&" ¶"&YourTable::Field_ Open URL [$email, no dialog] But this only sends the content of one record. Is there any way to send the content of several records, in the body of a single email?

I used to sync to a Palm via FM Mobile. Is sych to iPhone doable?

Ok so i have created a script that pulls all records with XX/XX/XXXX Date from File A But i only want the results that were have to do with station X. I think if i just put a validation and filter out all numbers expect X. Station 1-21 Thanks ao

Hi, I got a unique Import issue. I got this Excel file generated from a certain program. However, when I want to do import these records (which are readable by Excel), it will cause FM to crash? However, when I re-saved it to Excel, then it would be fine. Can someone enlighten me with some information? Thank you in advance for all the comments.. : Test.zip