Importing & Exporting

I have now been using FileMaker 8.5 on my mac for a year now and there is still a problem I cannot solve. My database consists of a few thousand business names, addresses, tel no's. etc under a certain classification. It's a local telephone directory where there are so many businesses listed under Accountants, Builders, Car Dealers etc. I export the information as a .bas file which I then import into Quark which I can easily edit ready for publication. I discovered the problem when I looked at the Banks & Building Societies classification, there are 5 Lloyds TSB banks on my database, all with different addresses and tel no's but there was only one listed once the reco…

I have an Import folder script that brings in the directory path for all enclosed files for a web site. It works fine for gif. jpg. and even .html (Filemaker Documentation says html is not supported. I'm just bringing in the path not the whole file). I want to bring in .php paths also. Any suggestions? Does version 9 bring in .php? Also - I'm looking for 5 bata testers for a sitemap.xml creation database. You will need: Filemaker 8.5 or better. A web site and full access to it. The ability to create a blank xml file. Such as Dreamweaver. And a Google Account All testers will receive a free copy of Version 1. If interested send mail …

I've been using an XML-based text export and it's been working fine. I now find that I need to insert a line of static delimiting characters following each exported record -- and the characters may occasionally need to be changed, but I can handle that by editing the stylesheet. This is the XMLstyle.xsl that I've been using (courtesy of Fenton) <?xml version="1.0" encoding="utf-8"?> xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" > (the server omitted some elements of the above code) Can someone familiar with XML suggest a few lines to…

Hello all, Attached is the sample of my question. In my program, I would like to make a log file. The thing is, when I am creating a log file, on FileMaker, it would show the New line, however, when I tried to export it to TXT or Log file, it would contain the "square bracket." The thing is I want to achieve the information in the log file like this: Hello How are you? Testing 1.2.3.. So, if you run my script, it would generate "test.txt." The correct result that I want is "TestCorrectResult." Maybe I missed something simple... Thank you for your information and help. test.zip

Hi I am not sure I am in the right place but this is my problem. I have created a database with 10 inter-related tables. I have started using this solution for a couple of months now and it works well. I have now created a newer-better version of the same solution with slightly different layouts, a few added fields and an extra table, but all the tables and fields of the original db are intact. How can I import/move all the records into the newer version without losing any information and relations? Many thanks in advance Poly

Hi, I have found something that seems to be a bug. A table has a numeric field. If I export records from that table as CSV, all records that have a value lower than 1 and higher than zero (any decimal number such as 0.32) do not export the leading zero. This is a big problem for exchanging data among applications. One important consideration is that I am using an english version of FMP Advanced v3 in a non english OS (Windows XP spanish), using standard regional options for spanish (decimal symbol is a comma, thousands separator is a dot). However, this should not negatively affect exports from FM or any other program, by the way. From what I have foun…

What I did in fm6 was: export summary fields by customerref. to a intermediate fmfile, so I could reimport them in a statistics file as numbers. I did this in shared files and everything went well. Now, in 9, I don't seem to get the intermediate file to close in order to replace it with the most recent data. I worked around it with an excellsheet but isn't there a way to keep in inside fm? Thanks for any suggestions.

I'm pushing television program schedules out of an FM db and into a tab-deliniated file. The file is then imported into a digital video server for playback of our public access cable channels. However, I rewrote the scripted export step when moving from FM6 to FM9 and even though I am exporting a tab text file that looks identical from FM versions, the import into the video server fails on the first record. If I delete the first row of data in the tab file then the remaining hundreds of records import fine. I'm stumped. I tried character format options, I made sure to have the data formatted identically for decimals, caps, etc, I've inspected the files …

All, I've just recently upgraded to Leopard after I thought I had everything sorted out, and now I run into a bug where FileMaker crashes if I attempt to export a record as a PDF. I get a spinning beach ball for a second and two and then the application just closes. It happens both with the script step and with the "Save/Send record as" option from the File menu. It happens no matter what location I try to export to. Export as Excel works. I can duplicate the behavior on several computers running Leopard, so to me it looks like a plain bug with Filemaker 9.3 and MacOS 10.5.1 Can anyone else try to duplicate it? Does anyone have a su…

Hello all, I have been asking this question in the past and I just want to know if there will be any ideas on this? Thanks.. I am doing parsing from reports (generic reports parsing). I want to know if FileMaker can modify the Field Title when savings to Excel. For example: I have 3 Fields which are Account Number, Names, and Balance. I would like FM to export to Excel like this: Account Number Names Balance Date 12345 John Doe 123.55 02/02/08 55555 John Smith 15665.66 01/01/08 But the unique thing is I should set up the "Field Title" in other fields because the field name can change. For the next report, the field could be like this: Acc…

I have a Project table which has a related Team portal (which lists all the employees who are working on this project). I also have a related Notes portal (where you can input Notes for that project). I want to be able to make a script that will send the Note contents to all the Team members that are related to that project. I can do a single email to one person, and the Send Multiple Emails script still sends just one email but for all found Projects. Any ideas? Thanks, Brian

I am tasked with importing data (for reporting) from an existing database that is a DOS based billing system and over 25 years old. Part of the data is formatted as follows: 3 00314476 09/22/07 17 40 13 3 00314476 09/22/07 17 40 13 3 00314476 09/23/07 17 40 13 3 00314476 09/24/07 17 40 13 I import this at half hour intervals. As you can see from the above sample you can have many records with the same order number. These are viewed through a portal that contains the Master Order Number. I am told that there is no primary key from the DOS system which I could use to match incoming data. Even if they created one, the DOS system handles an…

I have been lookin around but haven't found an answer to this: Can you import ust a single record at a time? I am importing records from an old database (with 1 table) into a new database (with 15+ tables) and need to seperate out the fields as they are being imported so I can place them in the correct tables and relate them correctly... In other words I would create a loop starting at the first record of the old database that would go something like this: 1-import next record 2-sort fields and relate records. Any ideas on how to do this? Thanks in advance, ~Chris

Greetings! I'm new here and I'm also experiencing problems with records being duplicated. I've inherited a FM database w/ duplicate records and I need a solution on how to sort, and omit the duplicates. Is there a procedure or utility available?

I have a database running on Server 8 Advance, it contains a script which generates text files. I would like these files to be created to the server hard drive. When I run the script I get an error stating the file cannot be created. The script is trying to find the path on the local computer. Is there a way to get the files created without have to mount a share point on the remote computers? Can you specify scripts to run that stay local to the server?

I am hoping that someone out there can help me...please. I am needing to convert a drawing log (contract document) file from filemaker to an Excel format...help...I wish it was as easy as a file save as but that is not an option when I am logged on. Thanks

I noticed that I can't use "copy" to get information into the clipboard with merge fields. Is there a way to do that? I wish I could capture a client's name and entire address (which are in 3 different fields) into the clipboard so I could paste it into other programs. Any one know? Thanks.

I have a scrip that imports data regurlarly from one db to another. all working fine till today, with no changes to the system i now get the following in the Import summary Screen :- Total records skipped due to errors. anyway of know what the errors were or why this is happening.

Greetings I am trying to add data from duplicate filemaker files. When I do this it erased the existing data, I want to add data from one file without losing what is in the receiving file. thanks

So just as the title says, I'm looking to play around with creating some queries in Excel to access the database, pull the data in to a specified cell range, and then have it do all sorts of pretty charts and all that junk. I've got everything set up, I just need to get the ODBC working with MS Query. Let me start by saying it's 'working', I set up the DSN and when I start the process I can see all the table occurances in the Query window. Whenever I go to add one of these to the query, it completely chokes and freezes up. I realize I have a lot of table occurances, and the overall size of the DB is fairly large, but the field list for the table I'm getting at rea…

Hello! I need to export an xml playlist for a video player from fmp. frequently, i will need to export a record more than once IN THE SAME EXPORT. Is this possible? I.E. Export: Rec 1, Rec 2, Rec 3, Rec 1, Rec 4, Rec 5, Rec 1, Rec 6, Rec 7 Thanks!

have a directory of scanned documents as multi-page pdf's. This is a patient records solution (referrals, letters...) Need to add these into the database and display the contents of the pdf, as a review mechanism. A pdf is inserted into container field Insert file on the mac, displays the content (first page), but does not display content on windows. The individual pdfs once inserted, can be exported, ideally they should be capable of being printed directly from the db. Short of building a path variable from the insert file process, then parallel a insert as picture routine into a 'thumbnail/preview' field of the same file for every insert, is ther…

I am creating documents in Quark and the database I am working on is to store copy for all the items so that it is stored in one central location so that everyone can have access to the current copy. So here's the scenario: I can use a Quark Xtension called Autoprice© to take "tagged" text and pull the content to an tab-sep txt file. I can then pull this into the database to update. The items needed can then be pulled back into a tab-sep text file so that i can then import back into Quark. NOW - my problem is that when the file leaves Quark it has symbols set up in Quark to faciliate the Hard returns/ soft returns/ and Align here. In Excel y…

I have a rather lengthy SQL import, does anyone know of a way to keep the user "entertained" while the import goes on? I know FM pops up the import records as the records are being imported, but I am looking for something while the query is taking place on the remote system other then the spinning "rainbow of death" Any thoughts or suggestions would be greatly appreciated.

I am having a hard time understanding the http requests and XML importing. I have a inventory database that stores book info like UPC/ISBN, title, and author. I have two things I am trying to get done. When a user scans or types in the upc I would like Filemaker first to check the internal database for the book and if it does not find it then submit a http request, import the returning xml, and display the information listed above. The http request must be made in the following format. http://isbndb.com/api/books.xml?access_key=12345678&index1=isbn&value1=0596002068 In this request 2 strings are needed. The access key which does not ch…

I have a multi-user database that displays data from a DOS system. Data is imported every 30 minutes via a script on a dedicated computer. Every time records are created or changed in the DOS system they are added to the data file for import. The users can edit the records. If a user happens to be editing a record and an import takes place at the same time with an update to that record, then the import for that record is skipped. I know that this due to record locking, but is there any way to prevent this?

Hi Guys, this is probably an easy one for someone who knows windows... I can't figure it out and would appreciate a tip. My database has a scripted Excel export function. I've chosen to name the files Excel_11807.xls, and collect them in a designated directory "Lasting Record Data/Excel Export". I'm using the Get(FileMakerPath) function to locate the directory, as it is located in the same folder as my runtime solution (or FileMaker application for the time being). On the Mac, the following calculation works flawlessly: Substitute ( Get(FileMakerPath) & "Excel" & (Substitute (Get(CurrentDate); "/"; "")) & ".xls" ; "Excel" & Substitu…

Hi all - appreciate the help here and am looking for some simple advice. I will be spending a few months away at my vacation home and have a FM template and DB at my home office (set up by a college student a few years ago - I have little to no FM knowledge). Although I regularly back up the data, I don't want to lug my system to the vaca home (would rather take my laptop). What would be the steps to making a copy of the template from the home office computer and setting it up on my laptop? As the next step, what would be the process for making a copy of the data as well? The data should remain static over the period that I'm away, so I'm concerned primarily with acc…

I have a very basic file that I use to publish a categorized directory listing. It has two tables: The main table contains the company name, address, phone, etc. (around 300 records), and the other table contains the categories of products carried by each company with a different record for each category from each company (records related by a company code number; around 1,500 records). Also in the main table, I have a portal that I use to select and display each company's related categories. I need to export each company's directory listing data along with all the product categories they carry -- all in a single file -- but I can't for the life of me …

I don't know if this is possible, but based on the things I have seen people in here come up with, I am pretty hopeful. : I need to export these songs in to groups of 1000, (1-999), (1000-1099) etc., into a txt file. They must end up in this exact format for the text file. 000001|UNBREAK MY HEART|BRAXTON, TONI 000002|YOUNG AMERICANS (P)|BOWIE, DAVID 000003|TOO GONE TOO LONG| 000004|ALWAYS LOOK ON THE BRIGHT SIDE| 000005|ALL I ASK OF YOU|PHAMTOM OF THE OPEA 000006|ALL MY LIFE|K CI & JOJO So its, JB#|Title|Artist All on one line and with no spaces. The problem is, I have all my songs, artists, etc. in filemaker, but the karaoke machi…

I'm trying to import a xcel file which has 5 cell info and would like those info to be imported into 1 record rather than 5 separate differen record on filemaker? Each field does have the repititation from 1 to 15 lines. So what I was hoping for is to have all 5 cell info import within the field since i have 15 available lines. any suggestion..

Hi. Our business currently uses a legacy ADP system. Reports are hard to generate, and I'm testing out filemaker to see if we can generate reports more easily in an fm environment. However, the only type of file that the ADP will generate and that filemaker can read is a Lotus 123 CSV file. Which wouldn't be all that bad except that the dates are converted to excel serial dates. The rest of the data looks great. Is there any way to make filemaker convert the serial dates to standard gregorian format?

I have easily set a script to print to e.mail, however I would like to alter it and save the pdf to a the temporary folder, I would also like to print all layouts at the same time to the pdf being created, this does not seem easy, but I am sure it is ...? So I would like to print all layouts for one record to a pdf file, save in the temporary folder and e.mail it. I even worked out how to name the file from a field but cannot see how to print all layouts or save to that elusive temp folder .... Can anyone else help Thanks in advance...

hi all I have seperated my customer adresses in separated in three fields: 'street' 'number' and 'floor' in my database. My problem is how to separate 'number' and 'floor' with a comma, when merging the data into a letter template in FM. I only need a comma if the adress actually includes a floor. I guess I'm looking for a solution where a comma only is included if there is no data in 'floor'. But I cant figure out how. Can anyone help? Regards Lasse

I have many Excel files. Each sheet is one episode of a show, listing all music tracks used in the show. What I want to do is find how many times a track has been used in all shows within a given time frame, or within a given series of shows. Can I look at several Excel files without having to import them one by one and add date/episode data? We already have a process by which we create these Excel files...I'm hoping to do what I want without having to create a whole new complex process, just use what we have in place.

I'm using Filemaker 8.5. I need to import my data into another program useing the CSV format. My problem is the each record has to be on three different lines with different text between the fields. How can I insert text and a carriage return when I export from Filemaker

Does anyone have a solution for importing from a formated excel file? I have to use a form provided by my client. The Data is not in simple rows and columns, basically I just want to point to certain cells and let it pull the data out and import them into FM. If I try to import data using FM, the data is disorganized and shows as separate records instead of 1 record with different fields. I demoed Excel Extract data and text, a program from www.sobolsoft.com, but the program is not very refined and has NO support. Thanks for the help Matt

I have a database, with a dozen fields per entry, and about 300 entries in total. I am trying to find a way to export the data in a phone tree like manner. I am new to filemaker, and am doing this for my Dad, for his non profit business. Any help would be appreciated. I've tried messing with the layout function, but there are too many fields for a clean, organized look. I've exported to excel fine, but there are few options there. Thanks, Ben

I have a pretty complex databases composed of numerous tables. I have an Auto Enter assign a Primary Key ID fields. The problem is when I try importing new records, it messes up the ID fields. To update my database -At times- I need to import several records from a newer file, TO do that I have a script to import several tables at the same time. Because of the database structure; I have to uncheck (Turn off) the "Perform Auto-Enter while importing. Because of that the newer records are imported to the older database. Everything is good. Now if you try to create a new records, While the ID Auto enter serial number should start a unique new number, it do…

I'm importing data from Access into FM (using excel) and wish to using the "Registrations" starter solution. I am able to get all contact info in with no problem but now wish to import registration data for historical events, which are text fields with "y" indicating a person has attended. Does anyone know how I can import this into the "Registrations" solutions in FM? I am trying to see if I can import these as new "events" and then somehow match the proper attendees. Thanks for any help...

I know there are quite a few threads regarding this topic, but I can't seem to find exactly what I am looking for. I have database of 1000+ records of different species of flies. I have created a layout that prints out a PDF in a catalogue format. That is, all species are grouped under their appropriate family , tribe & genus names (using subsummary parts). The indenting and formatting is very critical for a catalogue, so I would like to retain this. It comes out nicely when I print to a PDF, however, I need it as a Word document (which the PDF doesn't convert to properly, obviously). Would it be best for me to export the data as .xml and then have a…

Howdy, all: My FM library is lacking in explaining exporting FM records to Excel in sufficient detail to make it easy for the novice, so I need a little guidance; I've personally never used Excel, but I've been dabbling with the '07 version of it today on a friend's PC. My questions are: 1) Is there a script "trick" to exporting related records in FM? I tried a number of different permutations with a simple export script and only once did it show the Parent's table related records; the other times I ran the same script it didn't export them so I can't reproduce what I did. *blush* 2) In the one instance where the related records were successfully expor…

I am a newb to FM, so tanks for your patience. I have a layout with maybe fifty fields. When I export them, delete the current records, and import what I just exported, the field names are all out of whack. Why doesn't it just match up by field name? Also, I want to consistently only export maybe half of those fifty fields. How can I automate that so it always picks the same 25 fields on export? I just made a simple DB with only four fields for testing. Same problem. Every single field re-imports in the wrong order and I have to manually drag those little arrows to get the fields to match up. What am I doing wrong? Thanks!

up to now i imported my email into filemaker via the pop3it-plugin. but that didn't worked anymore since i upgraded to fmp9. so i looked elsewhere and found an extension for thunderbird that exported all my emails as individual text files. so far so good. when i import those files into an text field, fmp9 displays an unknown character at the end or start of each line. i sorted out it's because of rn. on windows this is valid and should produce no problems. when i change the carriage returns to just r (the macintosh-way) the unknown character symbol disappears. is there a way to kill those additional n in filemaker? it just looks inacceptable right now. than…

Hi all Working on a contact management system. Is it possible to do a database for scheduling appointments and such? AND, is it possible then to have that integrate in any way with Outlook and/or iCal. Also, I understand you could create a form letter to do mail merges with all the contacts. But is it possible to do that with Word from a FM database? Perhaps there is a letter I want to edit more with a Word Processors more advanced features. I would like that option. Finally, if I create a budget database, is there any way I could make that compatible and work with Quicken or Quickbooks? Thanks

Hello group. I've tried this question over at FM Cafe and apparently that board is not heavily used and thus not heavily monitored. I see lots of questions that have largely gone unanswered. Here's mine: We have this client control application in FM5 (old as dirt) that was written by someone else (who is long gone from the org). As a novice user, I've been trying to get FM5 to export the entire database so we can move it to another more robust and networkable platform. Our little non-profit charity can't quite afford the steep upgrade path to FM9. Anyway... In this application, there is the Main (name, addrs, phone no, DOB etc.) database. There is a seperate …

Having just converted a solution from v6.4 to 8.5, I've just had my 1st occasion to add a new field to an import file format within a script. Under 6.4 it was a simple matter of re-running the script with the addition, then responding to a dialogue asking if the new import order should be saved. A simple yes to that dialogue permanently saved the change. The way to do the same thing under 8.5 does not seem intuitively obvious. How can one make such changes permanent under 8.5? Thanks.

I'm very much a new user to this filemaker world.. I think some incredible things can be done with it, so it's all very exciting.. I run a business on amazon. I would like to download their unshipped orders reports and bring them into filemaker. I have attached the report I get from their system to this forum post. The way their system works (you'll see from the excel file) that each product ordered on amazon creates a separate line in the file. The system makes the same order # for each line of the same order with only the product details being different. I'd like to import this into file maker and be able to export it into a different txt format as well as print pro-for…

I'm trying to create a way to import pictures of our items easily. I've got a little script setup that does this, the only problem is that I can't figure out how to add the ID of the product record that the picture belongs to. Basically, I have a Products table and a Photos table related by ProductID. My script to import the photos off the camera adds new records to the Photos table but the ProductID field in these records is blank so they don't relate back to their product record like they should. The Import dialog doesn't seem to allow access to FM variables or fields or anything like that so I can't include it in my script. Is there something I'm missing o…

Hello all, I want to ask for ideas how to format the caption header on Exporting to an Excel file with data gain from the relationship. For example, if I have Contact database with ID (as Primary Key) and Item database (connected to Contact database with ID). Then, I created a new Layout which based database on Contact. In that layout, I want to include some information from Item Database. So, as a result, it would have Item::Item Name or Item::Item Price, as examples. The thing is if I want to export it to Excel, the header would be fine for Contact database (Name, Address, Phone number, etc), however for Item database, it would be (Item::Item Name, Item…

I'm working on a super top secret project and have a .dat file that I need to import into Filemaker. Now, I can take the dat file and convert to excel easy enough, but I'm looking to teach filemaker to fish. Is there any way to automate the process inside filemaker? When I open the file as text it is all % seperated... Like this: 2007%12%10%Monday%08%10%17% Can I import it into a dummy field and make a script to cut up to the % and paste it into another field?

I've not done any importing before and I'm confused on one issue. I need to import 1000 records from a file where there are 5 fields all in the same TO (Relationship). In my file however I have 4 fields in the Products TO and 1, VendorName in the Vendor TO. So how do I handle an import into two TO's from one? Milo

This is probably a very nebie question, but is there a way to create new directories when exporting records, so that one can group records based on dynamic record ID's? Searched and can't find any info on creating new directories, which probably means Plug-ins...?

I am having problems with the 'Save as Excel' feature. The generated Excel file contains an unknown character (is this 'white space?') after each normal character in a field. Only when opening and re-saving the Excel file in 'Excel', all is back to normal. Also, the FileMaker saved 'Excel' file is double in size before re-saving in Excel, and the unreadable header (when opening in an text editor) disappears to normal after re-saving in Excel itself. This appears on Win XP. Is this a known problem, does anybody know how the cause of this behaviour and a fix to it? Thanks a lot for any help.

Since applying the 9.0v3 update I can no longer export or save as excel. Anyone else having this problem? attached is the error message that i am getting. I'm and admin on the machine and there over 100GB of free space. Also i've tried a few file names same error.

Hello to everyone. Before I upgraded my software from FM6 to FM7 (Mac) a couple of years ago, I was able to import a FM file into MS Word by using the "Get Data" command underneath the Tools pull-down menu. It was very handy ... I could format everything as it came into the Word document, including fonts, punctuation, paragraphs, the works. I can't seem to make that work anymore in Word, either in MS Office X or the newly installed MS Office 2004. In both versions of MS Office, the "Get Data" command is greyed-out and therefore inaccessible. Yet the Help menu in Word mentions a Filemaker Import Wizard that should be available under the Tools pull-down menu (the "…

I've got a couple clients that like making Mail Merge letters in Microsoft Word. Right now, I'm exporting to Excel then merging that to a Word doc. I didn't know there was a better way, until I saw another client of mine, who had a past developer set up something using .rtf and .xsl and exporting in xml. I don't know much about xml, or xlst, but I'm willing to learn if it'll make this mail merge process easier. Can anyone point me in the right direction for using FM to export to a Word doc? Thanks, DJ

Is there a way to export one field to a Word Document and keep all the formating setup in that field?

:) I have a solution consisting of two files. The main file has 25 tables. The primary table in the main file deletes all records in itself and imports records from an external db nightly. Several other tables do the same thing. I can no longer delete the records in the primary table either through the script or manually. It gets almost done and then FileMaker forces all users off, closes the file and shows that none of the records have been deleted. This is done with a Full Access account. Is it possible for a single table to be corrupted? If so, can you recover a table w/o recovering the entire file?

Can we access socket connections and send a UDP Packet within applescript and/or with filemaker.

Hi all I have a file named "BOM_ITEMS" and in the file is two tables. One name "Bom_items" and the other is named "Temp_Bom". We often get request for duplicate jobs. We fabricated gas compressors. The file is for us to created our Bill of Material. Once a Bill of Material is completed and a duplicate needs to be made, I imported the BOM to the temp_Bom with no problem and change the Job number to the duplcate job number. The problem is importing the record back to the BOM_Items table. When naming the file path only the file name is shown and not the table names. I tried typing in the table name but when the import part of the script is actived a message appears s…

Hello all, I need help with my problem. Here is the condition. I want to import records from text file (txt). I gave the simple sample of text file with the filemaker solution. Basically, I want to import all the records in there. However, the unique thing was happened. It could not read word after "," and if there is quotation mark in the word, it would make the same line. I just want to see the importing did the same exactly as Notepad do. Is it possible? If this thread has been discussed before, please let me know the link. Thank you in advance for your help... :smile2: Import.zip test.txt

I have a database with numerous databases linked to it. When the user runs this specific script in File A, an "import records" script step occurs. This specific user does not have access to File B, but every time that the Import script is run in File A, Filemaker asks the user for the Password to File B. Any ideas on how to get rid of this?? Should I create a name and password in File B with restricted access to the database, so that the user can save the password in her keychain? Any help would be greatly appreciated. Thanks!

Hi I need to export text that will be used in lay-out software like InDesign and QuarkXP. The result should be something like: 1 [color:green] YES [color:green] more text... Is there a way I can get the exported text to contain those [color:green]tabs? If so, how would I get FMP to do that? I've been searching around but can't really find anything usefull. Thanks!

Hi all Is there an easy way to merge to Word Check boxes. I have a form that requires checkboxes to be check if the user selects YES to a number of fields. Is there a way to have Word do this based on the .mer file that is exported? Any help would be greatly appreciated. Cheers ZP

Hello. I am using FileMaker Pro 9 and cannot seem to figure out how to import a fixed-width file. I have a file that has one record per line, using a fixed-width format -- no commas, tabs, etc... When trying to import into FileMaker, it sees each line as one record. There are no options I can find for setting the widths of the columns, a la Excel. Ultimately my goal is to automate this process so the text file is processed every day and imported into our database, but I gotta get past step one first. Any help is greatly appreciated. Aaron

I have a database with tons of fields and some of those fields need to be exported as a number, but there are a few types of number lists, such as no = 0, yes = 1, unknown = 3 female = 0, male = 1 brown = 0, blue = 1, red = 2 Any ideas on how to make this easy for the users? I want them to be able to see the text value over the number value but for exporting to a statistics package, they need the number value.

Hi, I am new to file maker. I am trying to migrate data from File Maker 6 Table to a csv file. I am using Export Records -> choosing the csv file as file type and saving all the fields. When I go to the csv file, I am not able to get the equivalent field names at the top row. Is there an option that needs to checked to get the field names included in the csv file. Please help. Thanks, Bhuban

Hi everyone, I am perplexed. I have a number of files that are related to one another. If I try importing into File one from file 2 (or any of the other files), I can't click on update matching records in found set, it is greyed out. I can only add new records. I can import into file to FROM file one and update but not the other way around. I assume I am missing some basic and obvious setting here but I can't figure it out. I have full access to both files, I have file references going both ways and TO's in both files. What am I missing? Mike

I have a database app that I am considering releasing a shareware tool, but I feel I am missing one important piece before I can do it. I am looking for a way to migrate data between my internal versions of the database... IE its all on written in 8a but I have versions .1.01 .1.02, etc... backend fields are added and removed etc, I want to be able to export from one vs and import into the other just based on field names... if data fields have been removed they can just be left out.... Is there and easy was to do this?

I'm working with a third party who is supplying XML files on a regular basis and they require me to be able to import files where the filename has increased (e.g. orders 08032007, orders 09032007, etc). Conversely I want to be able to export files where I've added a timestamp to the filename on export. I do, of course, want to automate this routine with a script. Is this something I can do in FP8.5 or is there a plug-in that may do the trick? Can anyone advise?

Not eve sure i am asking in the right place I have this FM ver 8.5 pro application that use Troi for reading the serial port real time for data and storing it to a table (Displayed Incoming Call Layout Screen) in ABC application, suggesting what various incoming telephone DID trunks are doing and hanging up I want to show this screen, (Displayed Incoming Call Layout Screen) on other work stations but not poll the comport I guess what I am asking, Can I Read Only Share a FM database from another FM application.. or how can I do this?

Hello to all. I am basically just starting out with Filemaker for my company. As usual some requests have come down the pike for me to try and resolve if possible. One being, there is going to lots of data saved to folders in the coming year. The files will be generally tab-delimited text files. Is it possible to for FM to automatically import files into a database? Options or thru scripts commands? Sorry if it an unusual or already been addressed question(the joy of being a newbie again).

Hello All, I have a annoyance that I've been dealing with for a year or more. If you script an import from one table into another table in the same file. It does not work smoothly if you use server. It always ask you where the file is. If you open the file on the client side, it works fine. Any Ideas?

I was curious if its possible to import an excel file by drag&drop to an icon for a database. I am using OSX4 and XP

Hi, Mac OSX10.4.x, FMP 8.5. and 8.1 Server Advanced. I'm looking for a way to define a path in an export script. A client machine opens a database from the server. The client needs to export a tab-separated text report to an AFP server volume. A new report will always overwrite an older report. The path to the required location for the report is myserver.mydomain.com/ServerVolume/ServerFolder/FileName The client will always have privileges to mount ServerVolume with r/w access, but the problme is the volume may not be mounted at the time. I tried using 'Open URL... afp://myserver.mydomain.com/ServerVolume' but this gives an error if the…

Hi all, I've developed an online form where a user submits an application. There are a few fields that need to have text answers entered such as a field that has a user describes his/her history. Right now I have filemaker set up to import all the fields as a tab delineated file and it works fine unless the user enters a return in any of the longer text answer fields. How can I get the field values imported if they contain returns or tabs entered by the user?

Running FM9.0 Adv on XP For almost 3 years I have been using a scripted Import Folder to suck up one or more .csv files (renamed as .txt, of course) that come in daily. On Nov. 1 it worked, on Nov. 2 it failed with "FMP Adv has encountered a problem and needs to close. Updating to 9.0v2 Adv. didn't help. I deleted 9.0 and re-installed 8.5 Adv. Now it has the same problem ! re-installed 9.0Adv - same problem. Import file works OK, but even a simple one-field table, and a 'manual' import folder fails. The only thing that changed, that I know of, is that a System Restore was done just before the failures started. Maybe some system dll that FM uses is missi…

I'm a noob - so, if there is an easy idoitic solution, forgive me. I was hired to do some web work and along the way I became the filemaker setup guy. I created a form online that outputs data into a text file. My client just got filemaker and asked me to set it up for them, which I've done. The problem is I designed the data base with different tables to hold similar info. The tables are: contact info, career goals, education, and references. I can output the data any which way. Originally, it was a list of fields and their values ($field = value). I was having trouble getting that in. Eventually I just made it tab delinated but the info spans all the tables…

I have a product catalog that I built in FM 8.5v2. When I import the fields, it looks great with my layout. My problem, is that I am unable to import the folder full of images, with the images matching up to the proper record. I was able to import them, but they didn't match properly. 2 separate phone calls with FM Tech, netted me nothing. They are both saying that it can't be done. I don't buy it. I've seen 300-400 page product catalogues that were made in Filemaker, and have pictures. I can't believe that they manually imported all those pictures. Does anyone have any tricks up their sleeve that will allow me to import the images and have them match up with th…

I'm importing an excel file (Import Records - Specify Data source - file=filewin:/$FileName). I want to pass the worksheet name into the import process. Is there a way you append the worksheet name in the data source box? Currently I have to leave the Import dialog on so they can specify the worksheet name since it is not the first worksheet in the excel file. My app is importing vendor quotes from various folders on our Windows file system.

I have a layout on which all fields are entered as upper case ie) the caps lock key was on while all of the address and contact info was entered. But one field, 'Salutation', is formatted as Title case and appears as desired with the first letter upper case and all others lower case. When I export I click on "Apply current layout's data formatting to exported data". But the 'Salutation' field gets exported as all UPPER CASE. This is on Mac to a tab delimited text file. My question is, is this a bug?

I have a cvs file to import into my database. No problem there. BUT, I want to take the imported data and compare it to existing data and autopopulate or autofill the information fields not contained in the imported data. for example: data comes in with item_number, item_description, etc. existing data has information like assignment_client, usage, image. I would like it to compare the image_number with existing records and fill in the remaining information. any help on creating a script for this or finding one that might be of use to me? or someone want to let me hire them to create this? Thanks..

Every time I export text to a csv file some of the text fields appear in all CAPS - I need them in titlecase. In the database they are appear to be correct - I've gone to the trouble of fixing each field with the TextStyleAdd() function. When the records are imported into the database they are all in CAPS, then changed via the TextStyleAdd() of TextStyleRemove(). Why doesn't it preserve the formatting on the export? Any ideas?

Is there any way to import or export tables in Filemaker? If I create a database and distribute it to different people, and after that the database undergoes some changes, I thought the best way to update the database was sending only the calculating tables, inserting them into the existing database, without the need to import data into a modified database. Thank you, Toni

I have several pdf forms published by several different government agencies. I want to export my filemaker data into an fdf or xfdf format. The problem is that I have virtually no understanding of xml. I have an example here that I can basically copy or use as a template, however, I don't know how to manipulate the export exactly. In any case, I'm stuck and this solution could save me quite a bit of time. Can anyone give me a simple explanation as to how to export what I need as an xml export? I will give you whatever parameters are needed and I can probably figure it out from there. And by the way, I understand filemaker can create pdf files. That is not …

I have seperate tables for each WBS level of a project (WBS Levels 4-8) Each table will contain the same fields to be exported, and I need to create ONE XML file that contains all the records from all WBS levels. What is the best way to get all these records into one XML file? Thanks for any guidance!

When importing a tab delimited file back into the same file I can't get the fields to map correctly. Here is what I am doing: 1. I created a layout containing all fields in the table and make sure that is showing all records. 1. I click file/export menu and in the "Specify Field Order to export" dialogue box I select current layout (I have also tried current table with the same results). 3. I clear the field export order box and then click "move all" and the fields populate in a list to the right, in the same order they appear on the left. 4. I click export 5. on the right side of the import window I try every field sort order available but not with s…

I would like my FM contacts DB as central contacts list for everything on my mac (mail, address book, ical, invoicing software, excel, etc.) What am I better off to use? For me, the better way seems to be an LDAP directory with groups and contacts that would be managed by Filemaker and be available in apple address book. Eventually, I could share the LDAP with others, use it for mailings, use it for login and password storing for users to access FM and so many other functions. But can FM manage an LDAP directory, and if so, how to implement it? The alternative would be to have a way to synchronize my FM contacts with Apple Address book, and have logins and pas…

Hi, I'm writing a script called Import Entire Database which essentially empties all tables and then fills them from a backup. The backup was created by the File>Save a Copy As... command. The script looks like this: [Empty all my tables first] // Do the following for each table Go to Layout["Customers" (Customers)] Import Records[No Dialog; Add; MacRoman] The layouts are each defined in Layout Setup to show records from the table I want to import into (i.e. my newly-emptied table). The Import Records step does not specify data source (I want to be prompted for that) but it does specify the import order. To do that, I gave Import…

Hi everyone, I'm having trouble exporting CSV data out of calculated fields - it exports data but it's not the data that's visible in browse mode. thanks in advance.

Is there a way to import a defined found set from a sever to a local file?

When importing an image to my database, I currently use the "File Name" field to relate the image (so that it is available for viewing as a container field on other layouts). The only problem with this is that the images are stored on a single hard drive, so when I place the database on the web (IWP), filemaker can't find the files and the main images are lost (only the thumbnail remains). Is there a way to use this same import method to upload the image to the database, but then save the image directly in the database so that it is available online? Is there a reason that the thumbnail is stored on the database, but not the main image?

I created a new dbase in FM 9.0 with subsummary reports. Nothing fancy. Almost everytime I go to export the data (not save as) FM crashes. I have never had this issue with previous versions. Any ideas of what is causing this? I have tried remaking the database and the layout and niether work. Thanks

I have a great grasp on the relational database concept. I have about 5 up and running. The thing I don't understand is Calendaring. Is there a resource I can use to get up to speed on this? I basically need to understand the basic concept of how to assign something to a dates and then know it is no longer available. I would also like to learn how to display it in a calendar style layout. A couple of big questions are: Do I need to create a record for each day for each thing I want to schedule? That would be TONS. Also how do you display data in columns (7 days across) rather than lists? Thanks in advance.

I wanted to merge several databases into one large database. I created the new one. I imported these other databases from the Define Database screen, and I lost all my formatting and everything! Help!

Hello, I'm having a monday afternoon brain-lapse in conjunction with a lengthy amount of time away from FMP--not a good combo. I wish to use the Send Mail script to send data from related records in a list format...e.g... Patient ID, Date of Birth, Weight 101, 2/5/1991, 125 102, 10/1/1987, 143 103, 5/20/1969, 118 etc... (cannot show tab "effect" on this post--so please assume that for every comma above, a tab would be in its place.) The calcs I usually embed within Send Mail scripts usually only require info from one record at a time, so this is throwing me for a loop. TIA for help on what I anticipate to be basic functionality that…

Campus Productivity Kit query. I have 20 students at my university using Campus Productivity Kit. It is terrific for organising information and projects. Next I need to view and grade the students' work in Campus Productivity Kit. How can i view ALL students' work on my office Mac? Can I ask them to e-mail me a file or folder and then open in Filemaker Pro? Will it reveal all details in their Campus Productivity Kit such as names and Notes? What file or folder do they send me? If this works fine then i will buy Filemaker Pro. Please post any advice for this busy teacher. Cheers Michael Vallance

I have been attempting to import data from a set of .dbf files that are served out via ODBC. All is well with straight forward pulls but I have a problem if I want to use a date column in a WHERE statement. The following is created using the SQL Query builder during the import process. SELECT `STUDCAL`.`IDSTUDENT`, `STUDCAL`.`SDAYSTATUS`, `STUDCAL`.`SDAYACTIVE`, `STUDCAL`.`DAYDATE` FROM `STUDCAL` WHERE `STUDCAL`.`DAYDATE` = 2007/09/28 AND `STUDCAL`.`SDAYACTIVE` = 1 The DAYDATE is a value which was taken from the Query builders pull down list, so FileMaker seems to reecognize the value at that point. When the query is run an empty set is returned wi…

Hi I am new at this, and may be the answer is easy. I am trying to export a set of records separated by c/r, line feed, and the last record ends with (EOF)marker ctrl Z.I wonder if some one can help?