Importing & Exporting

As FM advertises itself as working seamlessly with Microsoft Office, I would like to know how to run a script to export/merge data from records into MS Word. For example, We have a central client database, and would like to have a button linked to a script that would put the address data into an MS Word letter. Anyway this can be done??:?:

In my quotation solution I have an Estimats file and a LiveOrder file. When a quote becomes a live order, the user initiates a script that finds that quote in Estimates and then imported into LiveOrder. On the host machine it is without trouble. When intiated from a guest an error message states that Estimates.fp5 could not be found (even though it is open at the time). User can then select via the host dialog the file and complete the task. I have tried repointing the script to the correct source file, both from the host machine and from the guest and have made sure that "relative path" is unchecked. Have also made sure that the master password was used just in cas…

I am trying to import a tab-delimited file into FM 4. It was originally an Excel 98 file which I converted to tab-delimited because FM 4 won't read the Excel 98 file directly. I have a text field (book titles) with some commas in some records. when I import, these records enclose the resulting FM text field with double quotes upon import. For example: Scat, Said the Cat imports as: "Scat, Said the Cat" Why does this happen and how can I prevent or fix it?

Hi, Is there any way to export data to MS Word, Excel, or another program, keeping the FMP layout? Thanks in advance

Hi. I have a database that I would like to add a field to. I want the field to be a link to a PDF file, so that when you click on the link it will open up the PDF in Acrobat. Each record would have a link to a different PDF. I am running FM 5.5 on Mac OS 9. Is this possible, and can anyone help??

I would like to use XML to read and write data from/to a Filemaker database. I am taking this route as I have heard the ODBC drivers don't work very well and the recommended method of interaction with Filemaker is via XML. I would probably rather take this route anyway if I can make it work. Here are some of the questions I am trying to get answered. I am a newbie to Filemaker so please bear with me: 1) Do you post the XML to a web server? Is this a FileMaker proprietary web server or does it use IIS? 2) Where can I find a definition of the XML schema used for reading/writing data to Filemaker? 3) Can someone point me to a good reference for this? Thanks, …

It is necessary for me to take a perfectly lovely database from a FM 5 file down to a FM 3 file. The file contains a large number of records. Not all fields are filled in each record. This is what I have managed thus far, in a nutshell: Sorted the fields by name Sorted the "move all" fields same exported to text with tabs attempted to import the fields into FM 3 When I open in FM 3, the fields and the imported information don't match, seems to be no obvious pattern to the mismatching. I have spent several hours already rebuilding the new database, making sure the fields and values and indexing are identical. I am not a complete novice, but I am pretty new…

I'm a firefighter who needs hlp with a problem. We need to be able to export my filemaker data in ASCII format. Is there any way to do this, or is there a conversion program that will do this for me. Thank you for any information you may have.

Hello everyone! This is my first post and I'm also new to FM so any help will be greatfully appreciated. After some digging around I found out I'm suppose to export as a text tab delimited file. But I can't find a expport command in Clarisworks. Is there a way to export the file? Do I need to buy another program to do the job.

Greetings Folks When I export a field which is all capitalized, the letters change to small ones in the export file - any solutions please - I want to retain the capital letters in the outcome. Regards & thanks Sean o'Donoghue

Any books/tutorials available for Xcatalog? The manual that came with the software is very vague and makes many ambiguous statements. Anybody have any success with it? Please help.

Hello, Could someone help me with a, for me, very big problem. Im work with a solution for travel agencys and need a itienary. From our airline reservation system Amadeus (similar to Sabre/Worldspan) I take a screenshot which is pasted into a global Filemaker field, formatted with Courier News for fixed caracter widt. What I want to do: From the global field I want cut out one line, or many lines, at a time and past them in a field for use in the application. I know how to select all, copy and past and that work perfectly but I want it automaticly with a script. Today I must go to the end of the line I want to use, mark it and let the script to the rest: cut an…

I believe that Status(CurrentError) returns 1 when a user cancels an action. So far the only FileMaker dialog that I've encountered that this doesn't work with is the Ask User to Disconnect dialog that appears when you switch MultiUser to Off. At any rate, I just did a preliminary test. Place If...End If immediately after your Import Records script step and test for CurrentError=1. Note: if Allow User Abort is On, then if the user aborts the import FileMaker will treat it as if the user has cancelled the script.

Hello, I'm not picking up basic font info (just Palatino, nothing fancy). The images come from OS 9 & XPress (Illustrator has the same problem) and when I import them into FMP 5.5 under OS X they print bitmapped. It doesn't make a difference whether I make them part of FMP or only a reference. Any insights are greatly appreciated! Steve

First, be sure that you are using a Y2K compliant version of FMP, namely 4.0v3, 4.1v3, 5.0vx, or 5.5vx. There may also be an updater for FMP3 as well. That said, the easiest wau to address this is to alter the text file before it is imported so that the dates are explicitly 2001. HTH Old Advance Man

Hi, I have a .csv file (comma seperated file) that I need to import into filemaker and am having trouble doing it. The file looks like this: Field1 name, field value1 Field2 name, field value2 Field2 name, field value3 If I import the file, FM wants to make each line a new record. I would like it to search for the field name in the .CSV then pull the value (after the comma) and then populate that field with the value. When all done, I should have one new record for the entire imported .csv file. I also can not assume that each .csv file will have the same fields on the same lines each time I import a new file. I tried looking for a parser plug in with no luck. I t…

Okay my FileMaker friends--I'm willing to listen to the anti-repeating fields answers I will get, but I must ask this question. Is there a way to import repeating fields from a text file? The file contains two fields: member_number and designation. I may have more than one designation for a member. The twist, and why I don't want to use related files if at all possible, is that I'm creating a run-time CD. It's taking forever for FM to open all the related files, just to display one field from each file. I have 5 or so different files that I would like to experiment with making repeating fields and see if that speeds up opening the files. Also, I'm thinking it woul…

Is exporting data the only solution to pass data to an external program? Is it possible to somehow pass command line arguments to a send message command so that when the program defined is run it will use these adjusted command line arguments? I need the command line arguments to be an actual defined field. Is this possible? so lets say I want to run a program called yipeee.exe I'd like to run this program as yipeee.exe [field type] where [field type] would be some defined value I compute before running the program. Current Solution ================= At this point what I've done to solve this is export the data I need to a file, then I have a perl script read …

hi there! annoyingly, in fm3 it does not seem to be possible to export text fields properly, when they are formatted using formatting options from the format/text/style menu. in my case this means that there are lots of fields that originally were entered all in caps and afterwards edited using the style menu. it is not possible to export this edited text. even when the export option "export as in actual layout" is used, the result is again all in caps. has anybody got an idea? i would be very glad, because there is lots of data... ;-( bernhard

Hi, If there is a constant Import,Export and Delete done on a File Maker File, will it get corrupted. Thank You

This might be a "give-your-head-a-shake" type question (my brain isn't fully functional today) but did FM remove the option to export to Excel in version 5.5? I seem to remember being able to do it in 5.0 (but I'm not positive since I did not use it that much) and there are also other questions about Excel in the forum so I think it's a safe assumption that FM at least used to be able to export to Excel. So am I going braindead/crazy/ignorant/all of the above, or does this option not exist anymore? [ December 13, 2001: Message edited by: FUBAR ]

Hi! This might sound very stoopid of me, but can I export / import a layout from database to another (they both have the same fields / scripts etc). Thanx in advance Dave

Hi! This might sound very stoopid of me, but can I export / import a layout from database to another (they both have the same fields / scripts etc). Thanx in advance Dave

We've developed a fairly simple assessment database using 5.0... but when we try to copy from quicktime and paste images (incl. jpeg) into the containers we get an error message saying something like "Filemaker is unable to read the disk this .. is on. Quit to ... continue to try again.." We use the images as an electronic portfolio of kids work. Any ideas? thanks Andrew

How do I keep the leading zeros on an export from FM 4.1? The field name is called "mail_code", it is a text field not a numeric field and there isn't any calculations going on. Basically this is what the data is in the "mail_code" field: 0234 0061 0432 0003 0893 etc... what I get: 234 61 432 3 893 HELP!! Josh

Is there anyway to bring word docs into Filemaker on the MAC? I know I can do it on the PC but is there anyway to do it on a MAC. This problem is really causing me grief with my employees. I love MAC by it's getting harder and harder to sell them on Apple because of stuff like this. Thanks for any help Wade

For those of you you are regulars to this forum this is my thrid post on the topic.I am sorry about that but I am still trying to import a student roster into a filemaker data base. The file is an Ascii file with each piece of data seperated by a comma I am running a windows computer and I would like to be able to take one piece of information out of this file and place it in my data base. Is this possible? When I try to convert the file to a filemaker pro database only the first feild of the file is copyed. Do I need to set filemaker to import a comma seperated files? what sorts of things need to be done to my data base to prepare it for the file. Please help!

Ok, I must be missing something here. I want to export my database as a tab-separated text file with field names included. So that I can import it into another non-filemaker document as I do with Access databases. Is this impossible in Filemaker? Thankyou for reading and eventually answering my question.

hi, is ther a way to import PDF files into a container in FM?, maybe with a special extention or something like that?

Anyone happen to know of any way I could export the contents of a single text calculation field as a text file, preferably named according to another field in the same record? What I would like to be able to do is to turn each record of a database into an html file. I thought of a script which would "find" each record in turn, omitting the others, and export the found set. The problem is the filename. The "export" script step requires the filename to either be entered or restored, meaning the file from one record would overwrite the file saved from the last record. I could imagine Applescript could be part of a solution but I don't know it very well. Any help would be…

I am sorry about the vaugeness of my post. I am using filemaker 5 on a win 98 computer. I want to remove the names from a sky word file. I can easly open this file in word or note pad. It contains a lot of information and each feild of information is seperated by a comma. is there a way that I can write a script which will go to this file, and say give me the text after the 7th comma and store it into a feild. What I am trying to do is take a list of students from this sky word file and place each students name in a seperate record. So that when I am finished I can have an update button on my data base linked to a script which can go to this file and take every stud…

You may have seen this in the Fields forum. Specific Question: In FM4.1, how can I produce html style line breaks within a calculation? I am using FM to produce static html pages. I use a text calculation to html-ify the data I need from each record. I would like line breaks (and indenting) within the html. If I put the paragraph symbol thingy in the text within the calculation: 1) If then, in browse I copy the html calculation field and paste into bbedit, things work properly. (I suspect bbedit converts the line break characters during the paste.) 2) However if I export the file to text, and then open the file in bbedit or a browser, between records I get proper…

When I export a number field to a comma-delimited text file, the exported file looses its leading zeros Ie 00312 exports as 312. I need to retain all five digits - how can I do this Thanks in anticipation. Sean O'Donoghue

I'm starting a project where i need to create a database of businesses. As I prefer working on my Mac, I would like to set this up in FM 5.5. However, my client is windows based and uses Access. If i set this up on the Mac, will I be able to provide them a file that they can use in Access. Will it be able to retain any formatting, etc. that I set up? Jeff

I am creating a database that uses as roster not in File maker format. This file contains a great deal of information. Is there anyway that I can make filemaker go to this file and copy only the names out of it and place these names in a data base?

Hi, I know I'm new to this filemaker/database thing, but scripting imports and exports seems to me to be uneccessarily difficult. I am trying to import data from a teacher's report to a school administrator's database. The Teacher data will be added to each term, and then exported to the school administrator. I tried to import the data by matching up the appropriate fields and info. (I did it as a tab separated text file). I checked off the option of updating data and then the sub-option of add remaining records. Then I created a script to restore the import order, and perform without dialogue. When I import using that script, If I import the same file, it jus…

Any sync process must have rules that determine which version of the data is to be used--local, remote, or ask. You might want to take a look at a product called SyncDeck by A.E. Wood & Erickson from the East Bay area in California. HTH Old Advance Man

Hi there. I'm trying a few different things to back up a Filemaker database running on Filemaker Server on Mac OS X. I can't determine a good way to do so by using the server's automatic backup capability, since we're backing up our computers with Retrospect, and the last I heard, Retrospect's Mac OS X client is rather "beta-ish" at the moment (on their site, they quite explicitly say how we shouldn't trust it for anything critical). So I'd rather make a copy of the databases regularly on another machine that can be backed up with Retrospect, unless someone can suggest something else. We already have another Mac running System 9.2 (which can itself be backed up with …

Mac OS 9.2: Filemaker Pro 5.5 crashes when I Import data from an Excel worksheet (Office 2001) . All goes well in setting up the fields to Import but when I scroll through multiple records using the Scan Data buttons, the program _and_ System lock up. I have to use a hard reboot and the FM file is then found to be damaged. The Recover command works fine but of course all the Import orders are unsaved. This can be very time consuming. Importing _without_ scanning data will normally work fine! Can anyone help shed some light?

I've just about finished a system to use my FM 4.0/Server 3.0 to send PO's (Purchase Orders) in EDI format. After pulling the necessary info. into one field for one single PO I need to script something to export the contents of that field with the PO Number as the text file name and drop it on an FTP server to be picked up. I.e 12345.txt. Any direction would be appreciated! Thanks, chood

Hi! I've got some data from FM 1.0 Pro from Mac and just want to import them to FM5.5Pro Win. The program just don't want to import these 'old' files. What can I do? Many thanks in advance for your help! Regards, Chris

Hi, I got a filemaker database on a CD and I work on Linux OS (Mandrake 8.0). I need to migrate this database to MySQL and I really don't know how to proceed. How can I access the database on Linux ? And how can I migrate it ? By advance, thanks for helping me khadeo

Hi. Can you out there suggest a way to export found records to excel, make excel chart the data and import the chart to filemaker? Or is a better way to do this? Thanks, Reynir.

Ok this is weird I don't have an option to import from a ODBC DSN in my Import utility.Its not there in the export also. I have a File Maker ODBC Driver installed on the m/c,why can't I import from a DataSoource Name? [ November 16, 2001: Message edited by: Jacob ]

Greetings When I do an export, eg 10 comma-delimited fields, HOW do I save this export so that I do not have to select each field seperately the next time I want to do the same export Regards & thanks in anticipation Sean O'D

Hello, I need help again, and again it's probably very newbie, so I apologize. i am making a database for recording results of quarterly assessments for my students. I have a number of layouts, (one for each assesment and one for an acheivement summary) for each student. i would like a teacher to be able to use the template to record the assessment data for his/her class and then use a button to create an export file that they can give to a department head, who will then collect the same type of data from other teachers and import it to her identical template to use as a masterlist for the school. My problem is that I'm trying to get it so that all of the actions requir…

Have a customer that is currently running File Maker 3.03 and has run out of record space, is unable to add more records to his database. He also would like to give people the ability to call his pc and view from remote locations. Need to know what would be the best plan for this situation?? Need to leave room for grow. Thanks, Ron Tuell

Ok - this is an easy one for you Filemaker Pro gurus out there. I am working for an International company that want to give access to some FileMaker Pro 5.0v3 Databases based in the US to users in New Zealand. They have a WAN link and both ends have a high speed Internet link. The Databases are of a reasonable size - but have been developed by the end user - so the optimisation of the solution isnt great. The complexity level is medium with several linked FM databases making up the solution. What is the best way to give New Zealand users access that is reasonably fast etc. Publish to a web site? Terminal Server? some other combination? Any feedback greatly appreciate…

Hi there all: I'm new to this forum and I'm hoping I can get an answer to my dilemma. I'm looking at using FM Unlimited to create an Intranet Portal for a section of our organization. (A Daily Newspaper in Toronto) There are several Oracle bases created over the years for different applications and I would want to at least be able to erad from these......writing to them would be fantastic. The trick is however, I don't want to convert them to FM bases as they need to stay as they are for the existing apps to use. Ideas? Cheers

Hi, I'm attempting to write data to a filemaker database from visual basic using the filemaker odbc driver (FMFMP50.dll - v. 3.60.00.00). I am running a trial version of filemaker under windows 2000. When I run sample code provided by Microsoft (http://support.microsoft.com/support/kb/articles/Q281/7/55.ASP), i get the following error: "datasource name not found and no default driver specified". Though the odbc driver has been added, it would appear that it can't find the odbc database. Anyone know any other resources or sample code that I could look at in order to get these two applications to speak to each other? Or is there any known issue with the trial version of f…

Hi, Does anyone know how you can get data out of a FM-dbase the way these data are presented in the "show index"-window (cmd-i from within a field)? tnx Yvan De Roover

Hello! A client has come to me with a FileMaker II database (password protected), and wants to be able to use it with FileMaker Pro 4.1. I have Pro3, 4, 4.1, 5 and 5.5, and none of these are able to convert the file (they seem to think it was made by v4.01Pro). Is this because of the password protection, or is there a product I'm missing to bring the files (almost) up-to-date? Thanks! Craig Sheppard Macintosh Support Dalhousie University Halifax, Canada

I hope this is the right topic to post in. I'm new to FM. I have an application at a clients site and I keep modifying it at my home office. I want to be able to bring the updated files to the client and bring their records in to the files properly (relationships and all intact). Tried import but it doesn't seem right. Is there a procedure on how to do this? If it is simple maybe someone can explain here or point me towards material I can learn from. Thanks for the help.

I'm trying to export a contact database to word with the usual things like: Name: Bob Address: 123 main street etc... My problem is: How do I get a file into word that has the field name in front of the database content, so that every instance of the "Name" field actually says "Name" in front of the data "Bob", rather than just a file with "Bob, 123 main street"? Am I going about this the correct way? My goal is just to get a formatted word file with the database contents. Thanks for the help. Paul

Filemaker 5.5 will NOT import tiff files that have been saved with the Preview.app but will import tiff files saved with any OS 9 app. Are there any filemaker updates that will rectify this? I don't want to resave all my tiff files

I want to export some fields from the database (FMP 4.1) to exact via CSV(Comma Separated Value format) all goes well, except for two points; - the integers are converted into strings ( ...","mytext","00000.00","...) and i want them to be exported as ordinary integers ( ...","mytext",00000.00,"...) any way i try, it doesnt work. - i want to export 1 record to 2 lines in the CSV file. that is, i want to have one line starting with 000 info info info info and under there, one starting with 001 info info info info from the SAME record... does anyone know how this is done ? the exact site isnt a big help either, on how you can import, i just have 2 example files…

I have been able to export data to .CVS files when the FMP database was hosted on my computer. The database is now hosted on a dedicated server, when I attempt to export data from the database, FMP crashes with the details of an invalid page fault in module FMCOR10.dll. I went to another computer and the same thing. I closed the application from the server and then opened it to export and it still crashes. Any clue? I certainly don’t know.

Is it permitted to use a calculation field as the matching field in importing?

In my arts organization, we keep lists of donors by levels of "Gold," "Silver," "Bronze," etc. I have the donor level in the Sub-Summary part and donor names in the Body. Sub-summary data will not export. Am I missing a step? Is this typical? Maxwell Morlay

Scenario > inventory dbase has 2 related files indexed on auto-incr. serial# field. Next, show all records & sort on Serial# field in both files > then export data from both files. This dbase is administered by adm as an online dbase whereby users just view data online. The adm add,edits, del records to update this dbase. In adition, a runtime version exists used by various users to add, edit del data, so the data in both online dbase & runtime version is changing. When runtime ver. was created, let's say both dbases were identical with serial #'s from 1 to 200. (serial # is index field in both files in both dbases) From there on adm increments seria…

Attempting to import data with Import Script step and a calculation field to extract data from an Oracle remote database using FMP v. 5.5 and Filemaker Server v. 5.5. I can get it to work for one user accessing the host file, but then it gives an error message when attepting the same import at another user's computer. Anyone else have any experience importing from Oracle db using such a client server 5.5 setup?

I don't know how to create an ODBC database from Access and import it in a FM db. I've tried but it's not so easy. Who can help me ? Thanks a lot MC

without window emulator?

Ok, I have a solution that is being used on both the Windows and MAC platforms and now I want to upgrade both sets of users to a newer version of my solution. Can this be accomplished using Filemaker scripting, if so, how? or do I need to resort to outside third-party plugins to achieve the seamless transfer of data from version 1 to version 2? Any thoughts, example scripts etc. greatly appreciated. Thanks.

Thank You but I got how to get rid of it by substitute function.

Dear all, Is there a way to make FM 5.0 keep the custom import order even after File Maker has been re-opened. Example: I have a script that imports only two fields from one database into another. But when FM is restarted the next day, the order goes back to original "creation of fields" order. Then the user has to mannualy import and change the order again, which defies the point. Any suggestions. Thank you Bike on!!

I have a small data base that anaylses data and then needs to email to someone else to import into their accounting program. I have everything working fine except they need Excel format. I should be able to write a small Applescript to open Excel, open the file and save as excel, then return to the script in FM to email the data. I just cannot get the Applescript to recognise the file or do anything. Is their a plug in to add Excel export capability or can somebody please advise on the applescript bit. Many Thanks, Richard

I am writing a simple log book of operations for 250 surgical trainees in Aus. I am needing some advice on the best way at the end of each 6 months, each trainee could e-mail their data to the supervising body. I know how to save a found set as a fmp file or .csv file etc, but was wondering if there was anyway to simply have the found set exported to an e-mail message eith the push of a button, without having to save it first and add it as an attatchment to an e-mail message. Would appreciate any advice.

Is it possible to enter the value of a global field into the Where section of a sql query import? I would like to make my database portable for other users of this database system, but their fields for school names, etc will change. Also - Can I specify an odbc data source using a field value? Thanks

I'm not sure if this is the right place for this post...forgive me if it's not. I have a solution I'm using in a school where the grade of the student in the DB needs to be changed each fall. I have that figured out. However, the teachers want to keep all the data from previous years, so instead of simply changing the grade I need to duplicate each record and then change the grade on only one. In my mind I've solved this by exporting all the records--running my ChangeGrade script--importing the records just exported. I would put all this in one script which would run when the solution is launched if Today'sDate=September 1. Does this make sense? Is there a better way …

I'm a beginner of FMP and my operation system is Windows. I plan to setup my first database for my studying. Just one thing to worry, I'm afraid that my FMP file wouldn't be able to transfer to other platforms in the future. Did FMP promise that before? Thanks

Dear .. I'm a newby in scripting. I'm trying to divide only new records from db A on a weekly basis to B(db called 'Level 1) or C (db called Level 2). B and C are related to A using an unique ID#. Db A contains a field: Level. Kind Regards Bas Scholts

I have a text claculation field that formats a text that should appear as one line in an export text file. If I copy the content of the field and I paste it into Simple Text it shows the way I want, but if I export the same field into one record using Tab delimited, it creates a text file where the line is cut into segments that are smaller than 203 characters. Is this a FM bug or known limitation. Any work arround?

I have a database of direct mail contacts from which I do mailings and phone follow-ups (basic contact information plus misc. info like dates of phone contact and mailer information). I subscribe to a mailing list that allows me to download updated contact information (just name, address information). Before mailing each month, I would like to be able to update my current list, as corrections may have been made to spellings of names or changes in address, while still retaining the supplementary info I've entered (like what mailings were done when and content of phone conversations). Any suggestions? Thanks!

I have a database that we created in Appleworks, but now we need to migrate it to FileMaker 5.5. AppleWorks only offers me the option to save my database as an Appleworks database or as a Clarisworks database, and Filemaker doesn't seem to accept these file types as acceptable to open. I've searched these forums for the answer, but so far no luck. Is there a way to move this database into FileMaker? Thanks.

well, that's a little extreme. . . BUT i do a little drag and drop onto FM 5.0 from an excel files and it added 3 letters at the end of the last field to every record. . . basically there are a few fields like first name, last name, dept, section, and Barcode Number. This barcode number is the most important one. I was importing this data into filemaker and changing the barcode to a barcode font. . . well that data when imported strictly through drag and drop, add the last 3 letters of the first name field to the end of the barcode field. . . and ofcourse, this makes for the wrong barcode. . . i'll be trying to contact filemaker and see what is up. . . anyone else kno…

Hi, Does anyone know how you can get data out of a FM-dbase the way these data are presented in the "show index"-window (cmd-i from within a field)? tnx Yvan De Roover

Example: You find 3 records on you local computer in database 'A' You want to import these records in another database 'B'. But, you're in a network so when you do an import you're going to import of all the records of the database 'A' instead of the 3 you selected, correct? As the import takes place from the server and not locally, so the server doesn't know anything about the 3 records you selected. I know how to work around this but I was wandering if my conclusion was right. Thankyou for reading and eventually for answering my question.

I'm not sure if this is the right forum for this question, but I'll try anyway. I am creating a browseable graphics CD for intraagency use, its not for sale or anything, just for use by those in the program. The problem I am having is that when I burn a cd of the graohics database, all fields become unmodifiable. I know this is to be expected, but is there a way to get around this, or are there any suggestions on how I can distribute this information through other media? Has anyone ever created a CD of their FileMaker database for distribution? If so, how did you do it? Thanks in advance!

I receive tab delimited files from photographers that list name, folder, image number,... The fields are to be set up in a consistant order and have no field labels or blank records at the top. Every once in a while we will get files that have headers and blank records. So we need to scroll down a couple of records in the import window to make sure every thing is going to go in the correct FileMaker fields. The problem is we cannot scroll through the records in the import window. We are using FileMaker 5.5 on a Mac. We did not have this problem when using FM 4. Just wanting to know if anyone is having similar problems and/or if you have a solution for me. I did some more…

Hi all, I have a FM DB, I want to export to excel so that users can use it in the way they want after I process the data from the FM5.5. The problem I am facing is while exporting the data all field names are truncated to 8 characters, I have tried all possible formats but could not solve the problem. Hope you will have solution of this problem, Thanks in advance

I want to create a FM Database-slash-library of documents. I have a lot of research material I keep on my Harddrive, and it would be nice if there were a way to organize and reference it quickly. I would like to create a container (or something) that linked right to a MS Word 2001 Document. I don't need FM 5.5 to open it for me, just to point out where it is on the Hard Drive, and open it up. Can this be done, and how can it be done?

How do you import calcualtion fields?? Don't tell me I have to assign it to non calculation fields.

I am trying to import a text file that uses a semi-colon as a field delimiter. Filemaker 5.0 only appears to want to use a tab as the delimiter character and there are no options to specify alternate delimiter characters. Other than first running this file through excel, is there any way to get FM 5.0 to import this file directly. Thanks

Hi, I have to import data from a filemaker 5 db in my filemaker 5 db. The problem is, that some pictures are imported on Win, and on mac I only get: "Windows OLE-Object" instead of the picture. I need quick help. Thanks in advance, Roland

FMP5 and Server. 7 Mac OS9.1 workstations. I need to fine-tune a script so that the found data is always exported to the desktop of the workstation being used, not just on the machine where it was written! The Select File option only works for the machine used to write the script. Do I use AppleScript instead of FMscript? [ October 10, 2001: Message edited by: flintg ]

I want to import (OLE) a defined range from a certain Excel sheet by means of a FM-script. I can do that, except that there seems to be no way to define the sheet and range from the Excel file in the script (normally one would enter for sheet "Amoebe" from file "animals.xls": Amoebe![animals.xls]Amoebe Chart 1 (for a chart) or animals.xls!Amoebe!R2C2:R5C10 (for a table) but in script I can only give the Excel file name (without even path). Is there a way out ? Thanks, Albert

When using Filemaker 5, we can't seem to locate or access our Filemaker 4 files on our host server. Is Filemaker 5 backwards compatible? If so, any ideas where we're going wrong? We're using a Mac OS 9.1 G3 server as the host, and using iMac DV units as the access positions.

I have a database of 11,000 records, and would like to update a checkbox field for around 4,000 of those records. We exported all records to an excel file and then pared down to the ones we wanted to update. I would like to globally add the check by importing if possible...is this possible? We are using FM 4.1v3 for Mac [ September 27, 2001: Message edited by: Dezza ]

I have a database with over 119,000 records I want to click a button to sent the contents of a merge field to WordPad. I used the sent message command to open the WordPad document and it works great. I then would like to delete all info on the wordpad the paste the contents of the merge field to wordpad, save it, then close it so it can be used by another program. I've tried to use DDE Execute for this part but I can't seem to find the topics or commands for this process. I went to the microsoft libraries and spent many hours reading help files but it was not any help to me. I've contacted the programmer of the application that needs to recieve the contents of the merged…

I have a large number of JPEG picture files saved in a container field. Is it possible to write a script to export all of these to separate JPEG files named as the contents of another field in the record?

I need to bring my Access database into Filemaker Pro. (Win to Mac) Thanks.

This is more a "I wonder if" question rather than "my job depends on this"-type of question: Is there a way to reduce the size of a file (get rid of unused blocks) without closing the file? I am dealing with a file of some 80000 records and it is being reduced by about half (it goes from about 10 MB to 7 MB when closed).

is possible to connect with a fmclient to a fmserver who is on another city ? example: i'm in rome and i have a fmserver rel. 5.0; i m going to milan, can i have the connection with fmpro 5.0 with the server who is in rome via internet at the same mode end state of one of my connection in my LAN thanks in advance

is possible to connect with a fmclient to a fmserver who is on another city ? example: i'm in rome and i have a fmserver rel. 5.0; i m going to milan, can i have the connection with fmpro 5.0 with the server who is in rome via internet at the same mode end state of one of my connection in my LAN thanks in advance

I am trying to export my filemaker 3.0 files to access. does anyone know how to do it.

I am importing data from a web submission. I am getting aberent characters that cause FM to create a new record too soon. If I go through the data in Word, I can find and eliminate most of these characters. (Most of the offending characters appear as little boxes in Word.) If I then look at the data in NotePad, I can find a few more. (In NotePad, the character appear as small boxes.) But in the end, I am still having records split up into different records. Any ideas?

I looked through the other postings hoping to find a solution, but no success. I have created a CGI form using BFormMail.pl from Brian Sietz. I have a FileMaker database created to receive the items sent by the CGI script in my form. My form is at: http://satf.org/text/task_area_report.html if you wish to view the source code in your browser. The variable I need to define is db_delimiter Since I don't know how to tell FileMaker to use a special character for the field delimiter, I need to know how to get CGI to send a TAB as the field delimiter. This script lets me define the delimiter, but it seems to accept only standard ascii characters. I have tried copying…

hi, Have anyone tried converting database in FileMaker Pro to MySQL. Are there any converters available? And is the converter freeware?

Im trying to import from a repeating field splitting the records into seperate records. However it seems to create records for the blank repeating fields as well as the full one. IE a repeating field that is set to 300 repeats is creating 300 records even though only two of the repeats are filled. This worked in FM4.1 I cant get it to work in FM 5. Any clues? [email protected]