Importing & Exporting

Hi all Read a thread about keeping your information in a different db then the input db and thought i would try this. I made a clone of my db and deleted all records in the clone and tried to import the information back in from the orginal. I removed all relationships in the clone db. About a quarter of the data is not import. Since the db is an exact clone, any ideas why this is happening. Using FM6. The import is done manually. Thanks Lionel

Hello all: Ok, this question is not about FM, it's about Excel. I have three fields in my FM file for phone number. I am going to import recs from an excel spreadsheet into it. The phone nums are in 1 column. So I did text to columns/fixed width and parsed it into three columns. But it keeps stripping out the lead zeroes. I checked everything, does any know EXACTLY where to go and change this? Thanks Ken

I am searching for a way to mark imported records. My problem is that my users must import records but sometimes they do it wrong and i end up with new records from another file. Is there a way to flag the records that have been imported : with the username of the person who dit the import and possibly the filename of the file the records are from. Also, the auto-enter option must not be used because it modifies the imported records and they are not usable after. I am new to filemaker so maybe there is an easy way to do this but i haven't found it to this date. Thanks

I want to import records via ODBC from AS400. Can anyone tell me where I can find an appropriate ODBC driver for mac os x ? Thanks in advance for any help!

i have a .msg file that i can open with excel. it lists the info like this UR|1701069 AA|Author TI|Title CN|Fine PU|Random House Children's Publishing PP|Naperville, IL, U.S.A. DP|2001 ED|First Printing BD|Hard Cover NT|1570717435 Fine/Fine Hard Cover Minimal wear present KE|NORTH KE|CAROLINA KE|FICTION KE|MYSTERY KE|DETECTIVE KE|POLICE KE|PROCEDURAL KE|MAGNUM KE|CUDDY KE|FICTITIOUS KE|CHARACTER PR|1.01 XA|4 XB|5 XC|BO XD|S UR|1701069 AA|Sachar, Louis TI|Boy Who Lost His Face CN|Fine PU|Random House Children's Publishing PP|New York, NY, U.S.A. DP|1997 ED|Trade Paperback BD|Trade Paperback N…

I am very new to FM and databasing, so please forgive my terminology if incorrect. I have many flat files with nothing more than email addresses within them. First, I would like to import them into FM. Secondly, I would not want any duplicate entries; but instead, a column in the database which tells me how many times that specific entry was attempted to be imported. Example: ([email protected]) is on files 'A, B and C'. When I import file 'A', it would added ([email protected]) to the 'Address' column, then put a number one in the 'CountImport' column. When I import file 'B', it would see the email address already is there and not add add to the database, but in…

I've got a script that uses the Send Mail command to create a message in Eudora. Worked great in OS9. In OSX, the script will open Eudora (or bring it to the front) but doesn't compose the message. Anyone have a clue?

Is it possible to import data from a handheld GPS (GARMIN) into Filemaker Pro 6? Sambo

When I'm importing records from excel to FM, I'm getting all my data in the correct fields. It works fine, but I get hundreds of empty records. I was thinking it was reading all those blank fields on the spreadsheet? But I cant find a way to make FM ignore them. Sorry if this has been covered before, I did try to search for it. Steve S

I am trying to create a script that will automatically export all records (and all fields) from a filemaker pro file (client.fp5) to a separate filemaker pro file (called Master.fp5) within the same directory. I would like the script to append and not overwrite any previously existing records on Master.fp5. I have found the "Export records" script command and have set it to preform without dialog but the script fails because it says there were no fields selected for export and of course if I leave the dialog in and select the fields by hand (which is something I can't do for this script) any previous values in Master.fp5 are overwritten. If anyone has an idea how…

I am trying to import a folder containing .gif images. I have hundreds to import. I'm looking for a quick way to batch import these .gifs. I currently have FM 6.0. Can you import a whole folder at a time when inserting pictures or is this something that would need to be scripted?

Anyone have any suggestions for getting around this? I am having serious problems with Developer 5.5v2 and importing tab text fields into a FMP database. The files appear but are not accessible. I believe this has something to do with the OSX filing system and fmp......the bug makes using OSX native runtimes worthless for me. I need the ability to script an import of the text file (works great in OS9 and Windows). One option I could do is a converter db (when running in classic) that changes the text file to a .fp5 file. I would RATHER not do this (clumbsy) but I am at a loss otherwise......even doing a copy and paste deal with text edit doesn't seem to work.…

I'm having problems importing pictures into a container fields. The first time I tried, there was absolutely no trouble. However, after shutting down the DB & re-opening it, FM is no longer able to "see" the pictures on my computer. The "Files of Type" field is defaulted to "All Available", but when you click the drop-down there, the only type available is "*.CGM". I've experimented with this on several different computers & it seems that it does this every time. If you uninstall FM completely & re-install it, it'll work again for one time only. Am running FM 4.0v3 on Windows XP. Not sure if its caused by an XP conflict or something else. Any sugg…

Hi, First post so excuse my ignorance -can the following be done within FM pro? I have a list as below J8AAC01 J8AAC02 J8AAC02 J8AAC06 J8AAC06 J8AAC07 J8AAC07 J8AAC08 J8AAC09 J8AAC10 This a sample of a much bigger set-I want to export (into .csv) only 2 out of 10 records. The decison maker would be 5 letters in from the left. So what I want to see is J8AACO1 & J8AACO2 in my exported file. J8AAC| would be the cut-off point. Is there a way of doing this as a calculation for multiple types? I would have records beginning J8AAC, J8AAB, C2AAB, D8AAB, etc in one large list and I need a calculation that could be applied to ALL records in the list to…

I have a developer working on a shopping cart for me using MySQL and PHP. I would like to be able to upload the price list but he's a windows guy and he's not sure how to deal with the Mac carriage returns without some major find & replace scripting. I've been saving as a tab-delimeted text file, but when I upload it comes up with pages of errors, the first of which says that there are too many columns in line 1 (which is not correct), so I assume it just skips over the mac carriage returns. Because I don't really understand the problem, it's hard to explain it any more than that... any help much appreciated!

I have two text fields, that are supposed to auto-fill themselves with a calculated, not looked-up value. However, those fields are empty after I imported some data. What can I do now to automatically update all those fields? I'm really stumped. Any help appreciated!

Hello. I'm trying to import data from another FM file to regularly update multiple records, using a calculated field as the match field in both the source and destination files. The manual states that a match field cannot be an unstored calculation, and I took that to imply that a stored calculation can be used. But in the import dialogue all the calc fields (including the one I want) are greyed out. What does this all mean? I can only get an appropriate match filed by joining 3 fields - Field A&Field B&Field C. This field will match with one record in the other file, from which I need to get the data from several fields in that record. I need to repeat this…

I have a file that contains several records constructed like this UR| SKU AA| Author TI| Title CN| Condition AI| Illustrator MT| Catalog PU| Publisher PP| Place of publication DP| Date of publication ED| Edition BD| Binding NT| Comments KE| Keyword PR| Price XB| 1=Add, 2-7=Delete However, sometimes records dont have a binding field, or edition field, or something else. It variers based on what an employee entered into the data base. The minimal a record will have is this UR| SKU AA| Author TI| Title CN| Condition MT| Catalog NT| Comments KE| Keyword PR| Price XB| 1=Add, 2-7=Delete So as y…

I finally built the ODBC link today between filemaker and our accounting software. I'm pleased at how easy it was. Ultimately, some of the filemaker data is going to be updated with data coming from the accounting software. Let's say that I can capture all the information that I am interested in, and the import works. How can I have this import run, say, once a day at midnight, or something similar? I'm guessing there is going to need to be multiple imports (as well as exports, eventually from filemaker), and running them manually is going to get old real fast. What's my first step?

I want to be able to copy a table layout as an OLE object and paste it into a CAD application. It appears I can do that from layout view but the table is converted to an image object and not editable in the CAD application. Is it possible to copy a table view as an OLE object and paste it as an editable object. This would be similar to copying a range of spreadsheet cells and pasting them into the CAD drawing. Thanks, Daryl

Is it possbile to import data from multiple worksheets at the same time?

I need to import text files in fixed width format into FM. I can first import into Excel and from there to FM - but - excel wants to treat each row as a seperate record; I need several of the rows (lines in the original text file) to form one record, so I don't know how to make that work. I need to do this regularly - several files each day. I'm a babe in the woods with importing. Any and all help greatly appreciated. Glenn

Importing jpgs seems to be posible, but could I directly photograph into FM? Could it be done with a custom script? See this page. web page There is a very small Footnote that this can be done on a Mac, but no mention of the date of this page. Is an update available for Win?

Hi, with Apple pushing their new sync technologies and the proposed advantages of a central/unified Address.app, I was wondering if this is something that FM can, or may be soon, able to take advantage of. I'd very very very much like to be able to draw certain data from a System wide source for all my needs. It seems to me that this 'Nirvana' is getting very close with Mac OS X Jaguar, iSync, Address.app etc, but it also seems to me that there might remain a major hurdle for those, like myself, who need to maintain databases of contact/billing etc. info, in an app like FM. Anyone any ideas/thoughts on this? Grant

I am hosting 3 FileMaker Pro files on a Server and I have 7 guest connected. Some are useing Filemaker Pro 5 and some are using Filemaker Pro 5.5. The server is running Filemaker Pro 5. When my guest import records from one file to another it closes the source file down if they have it open and that is really annoying to them. I can not figure out why it is doing this so i am asking for help. Thank you

I hope i am posting this in the correct section. Is it possible to insert multiple images into a container field for the same record. I currently have a database i made to keep track of my cd collection. And i wanna put a scanned image of the front and rear cover in 1 container field. I seen this done one time but at that time i never thought i would use it. Thanks for any help you can give me.

In Filemaker, I have date fields set as "leave Date formatted as entered" which gives me data of mm//dd/yyyy no matter what format I view it in Filemaker. However, recently, when I try to export and view in Excel, some of these dates are coming out as dd/mm/yy, so what is 06/21/2003 in filemaker appears as 21/06/20 in Excel. Any clues? things I should be checking?

How do I to split one field ("repair actions") into different records. The field contains sentences separated by a paragraph mark. Every sentence has to become one record. What is the correct formula to do this? To me it looks hard because every sentence contains a different number of words. To make it even harder I'd like to take along the value of a keyfield ("IDService") in the new record. So what I need is a record per sentence with the fields ("repair actions" - 1 sentence) and the according key field ("IDService"). But maybe you know the right way to do it. Thankyou for reading and eventually answering this question.

Hello and Help! We're an auction house specializing in autographs and memorabilia. We use FileMaker to do all of our cataloging, 1 lot = 1 record in our database. We produce a printed catalog 3-5 times a year (usually with 800-1200 lots), taking the text from FileMaker to MS Word to PageMaker to produce the material for the printer. Most of our lot descriptions involve a lot of formatted text - particularly bold, italics, underline, allcaps and smallcaps. To get from FileMaker to MS Word, we export as a tab delimited file, open the .tab file in Word, convert to a table, review for glitches (e.g. extra carriage returns), then sav…

Why do my Tif images expand so much when I import them into FM 6.0 Windows database? The images are 100k before the import and 600k after. I have to do the import from a Mac before the database is put back on my Windows server. Why can't I import the TIF images on the PC? It gives me an out of memory message when I attempt the import on the PC.

Using version 5.5v1 (Mac), when exporting data created using Option-Shift, those characters do not export correctly. Anyone know a fix?

Hello, I have a user whose database is 4.1 and she imported from an Excel doc. Unfortunately, extra characters, actually blank spaces, came in with most of the fields. She is trying to create labels and even though she is using merge fields, the blank spaces are not allowing the merge fields to slide up or over. Short of going into every field that has the blank spaces at the end of the text, is there a way to clean up these spaces globally? The excel sheet doesn't show extra spaces so I am guessing that the original document prior to excel did not cleanly save as an excel doc. Unfortunately, the user does not have access to the original doc nor does she know what appli…

A friend sent me a FM file as an email attachment. The file came through but there was no data in the fields. What happened?

Hi, I want to be able to provide advertising in my solutions that changes. I want to pull images from my web server, into a container field in the customer's files, this way the ads would periodically update automatically..... does anyonehave any idea on how to do this? I was looking for a plugin from waves in motion that looked promising, but they say they will no longer be developing it.... am I missing something stupidly simple? or is this going to be as difficult as it seems..... -John

Hi, I was contacted one year ago by a french company that provided some "daily intelligent back-up", along with an "secure externalistaion of the db on a protected location". http://www.adhersis.com or http://www.adhersis.com/it/ for italiy...or http://www.adhersis.com/de/ for germany Note that I'm not dropping these adresses for advertisement . They've been fooling around with me from the begining with some inexistant services, no Mac Configurations and really weak technical support. Their commercial arguments at the time were mainly focused on "the 11 september tragedy and the need to delocalize the backups ! " ( Can you believe it ! Shame!) and besides …

Hello, I have a database used by several remote users, and I'm adding new users to my list of clients. I'm continually creating updates of the database. I'd like to be able to ship the update to the users and have it import data from their old version. The problem is that the pathnames to thier files will be different depending on how they installed the db, their drive letter, etc. Can I create a script that will allow the user to import data from a pathname they specify? There are many files in the solution that need to be updated, so I'd like for them to be able to specify the path to the folder where the old version is located and let the script do …

hi, i can export to htm file so i can upload to my server, but the file exported is not very attractive and has borders around the table data cells. how can i export with a bit more neatness, and also can i export the colors i have set for text in my layout. i looked at lasso, and i think that can do it but i really dont want to download a 30mb program just to do this. i can edit the exported file but i would have to do this each time i edit my data. can anyone help? thanks mario

IMDB being the Internet Movie Database I don't even really wanna know how it's done (yet , but we use the IMDB to get data on the films in our database (Year, Length, Actors, Director, Cinematographer, etc.), and we've been doing it manually for all these years, copy/pasting and formatting. Takes quite a lot of time, as you can guess. So, could this be automated? As I said, I don't expect a full solution or anything, just a pointer to the right direction maybe... many thanks!

Hi I'm new to the FileMaker realm. We have 1,200 Excel spreadsheet files containing the same fields. Each client currently has their own spreadsheet. I would like to merge these files into one database. But I'm not crazy about performing 1200 imports! Is there a way, via script, that I can automate this import process but allow a pause to still be allowed to specify the file name each time? I am using vs. 5.5 on Windows98. Any help would be appreciated ... I've currently imported five and I'm already irritated with it! Thank you. Linda Gent DAC

It's possible to use FileMaker pro 5 on a Apple Computer (OS X) and link data located in a Access 2000 database file (.mdb) ? Thanks for your help! David

Hi everyone. Sorry in advance for the newbie post. I need to convert a FileMaker Pro database to a Sybase database. The schema in Sybase will most likley be different from the one in FileMaker, but I can deal with that later. All I want to do for now is to be able to export (move) all the data that is in FileMaker to Sybase. I can manipulate the data once I have it loaded in Sybase. I know I could export each "table" and do an import into Sybase, but I don't want to if I don't have to. I know I could get a SQL plugin and write insert statements, but again I would like to avoid this. I am trying to stay away from doing anything "custom" in FileMaker. I w…

Will FileMaker Pro 6.0 allow me to attach Word or Adobe files to a database record? FileMaker Pro 5.0, which I now use, does not allow me to do this. What I want to be able to do is to go to a FM record and then be able to link directly to an related Word or Adobe file. Thanks.

hi everyone, new member! i'm having some odd issues when importing data from a FileMaker 6 database into a FileMaker 5 database hosted on a FMS 5 server. it seems as though FMP is just picking a record at random and importing it. i get the correct final found count but the records themselves are wrong. here's a synopsis of what i'm doing: FileMaker Pro 6 (.fp5) db opened in FMP 6.0v4 served on FMS 6 (origin) FileMaker Pro 5 (.fp5) db opened in FMP 6.0v4 served on FMS 5 (destination) when i try to import the data of a found set from the origin into the destination, the resulting found set in the destination has the wrong information in the match fiel…

We are loosing records every time we do an import from Excel but only in Mac OS X, numerous attempts to reproduce the same problem in Windows XP has been done but it will not do it in Windows XP. We have 10 Excel files each holding 2 sheets with this fields: Code (text field) departure(date filed) Arrival (date filed) Destination (text filed) and Name (text filed) When we do the import are we using match field with filed Code, code is unique for each trip. Let us say we have 1000 record and we import with match filed 50 records. The 50 records are in FMP so the result has to be 1000 records, correct. Nevertheless, we get 960? The 50 records that we imported di…

Hi, I have a text field that I'd like to turn into an html document. What's the best way to do this with a script? Thanks, Dan

ANYONE had any experience using these 2 applications together.. We have all our databases (ie addresses etc) on Filemaker but all our Accounting is done through MYOB 11 and we can't get the data to share across the 2 software programs?? CAN ANYONE HELP WITH USING FILEMAKER AND MYOB TOGETHER.. OR ARE THEY DESTINED TO BE APART??? thanks

Okay, FM 3.0 bit the dust finally. I was able to get a backup copy working. Now I have been able to recover the files but for some reason they won't work. So what I want to do is take just the data from that one day and move it to the working page. Now what would be the best way of actually moving the data over? I can do a find for the date but then can I just export it directly to the other db or are there steps inbetween?

I am moving data from a Clarion database application that I wrote years ago to an FMP 6.0 database. The Clarion utilities afford me the opportunity to convert the database files into ASCII comma delimited files. I will write a VB conversion routine to split the file into several files and normalize the data. I wish to combine the address, City, State and Zip Code fields into one field on FMP 6.0 when I import the ASCII file. How can I accomplish this task? I suppose I will need to import each field separately and use a calc field to concatenate them but that is such a waste of space. What I would like to do is concatenate the fields in the VB program and insert the vbCR &…

Dear All, I have a MS Access database which is used by Sage Accounting software. I would like to import data from this database to my Filemaker database. I have set-up an ODBC driver and I can import records through the import ODBC source option. This works fine, but is there a way I can automatically do this? Make filemaker import the records every 5 mins or so. Any ideas, or am I asking to much? Thanks

I am contemplating purchasing FMP 6. to use on my PB G3 running 9.0.4. What I want to know before I buy, it is will I be able to create a "container" field in which I can drag and drop files from another program to be used as links to open them within their respective application? I have successfully done this on the PC, but cannot duplicate it on the Mac. I called FM, and they didn't have a clue. Thanks, Christopher Dortignac

Does anyone know of a tool that will export info to FileMaker 4 from a filemaker 5 db? Regards, Evan C

Is it possible to use Filemaker as a front end development tool and access data on SQL Server ? If yes how can I do it ?

I have a products db solution, there is around 1000 products (records) and 30 db in total. My customer are complaining that they are losing records and they are. I have checked all dbs that is related to

Hi everyone. I have a filemaker db that has names, addresses, and phone numbers (contacts). It is linked to another fm db that has information about where I met these contacts (meeting place). Is there a way to use Mappoint in conjunction with my fm db's to tell me how many of my contacts are within say 20 miles of that meeting place? I would probably work off of another file with zip codes I would imagine. If not, is there any other mapping software that could do this? Thanks for the help!

Here is the problem: We have a solution that worked fine in pre-OSX where it would grind through the solution and export the file just fine. In the OSX world, when it comes to that script step, it goes through it but no file is created - when I perform over a network. If I do it locally, it works fine. If I turn off the part of the step where it saved the file name and have to name it durning the running of the script, it works. And then afterwards it works fine. Problem is, I can't do this for EVERY workstation that will be using this function! We need to have this done automatically. Is this something in FMP? We are using 5.5, is this fixed in 6??? Ple…

I am trying create a database to handle customer complaints that can input information into the field by clicking onto a popup list it will fill in all the fields from a different database record. I have created a

Hello People! I was wondering if any of you had the simmilar problem. I have 100+ record in excel: PO,Date,Name,Qty,Amount,LocationName [no,date,txt,no,no,txt] and import works just fine and fields get populated but when I try to pull some data on web all of the unstored calcualtions get messed up and wrong .... is there a "known" issue with Excel--> FM with a field structure/type...anything that I could have overlooked thank you all!

Hi, Is there any way to run FM scripts automatically at certain times of a day? To be more specific, we want to import data from a text file which is updated continuously. we want to have a process running to check the text file once every hour and import new records into FM. The OS is Windows NT. Thanks in advance.

Hi there! Got a question. I have 2 db's, one "Temp" database with an Import button to import data from a dbf file, after importing i'm activating the other db; "Orders". Now i want to import the data from the "Temp db" in my "Order db"(script on startup), but i first want to check a calculation field(unique code) to see if its a new, editted or unchanged record. If they are the same..do noting, if there is a difference...change the record...else ...make a new record. I also want a statusfield after updating (so if a record is NEW, CHANGED or NOT CHANGED since last synchronisation) I really dont have a c…

I need to get some customer info from a web page online. It is all simple text. I attached a file that shows what the page looks like I need the customer name, address, city and zip, thats all. displaypurchaseorder.zip

I need to do 2 imports because one source file has the customer order and the other one has the customer info. How would i do the first import then go back and on a different layout and import the other info into the current record? Also, when importing from an excel file, how can i import just the first record?

Hi Guys, Not sure whether anyone has achieved this, but is there a way of programming a script that would export data from a FileMaker table into an Excel spreasheet and then run a Macro (again using a filemaker script). Thanking you all once again.

When I import records from one db to another, FM6 creates an extra blank record in the main db so that ever other record is blank. Is there a way of not creating the blank record. The import is done by a running an script. Tried the import manully but still get the same results. Thanks Lionel

Is there a way to setup a script to export records and setup a file so that each time it goes to the same file and has the same fields selected to export?

Hello everybody: I developed an application for Pocket PC using SprintDB Pro that has 16 tables. I would like to be able to read the info in these tables using FileMaker. What would be the best way to do it? How do I import the info? Is there a script that allows you to do it? Thanks in advance Pablomac

Trying to save a few steps for the user, but going to have some fun on the development end. I currently use the troi file i believe to make refrences to images on a computer. I have a way to capture an image directly from a camera to a computer. User will select the images in FM and they'll get loaded directly into a FM record. I need a way to automate importing a file into a graphic container, resizing it to a specified size, and exporting it back to an image file. Troi graphic looks like it can do the resize, and inside scan looks like it can export, but i'd like to find a way to do it all at once. Keep in mind, this is on a PC setup, i don't have the luxury of a m…

Help! I am looking for a way to either export multiple associate text strings from a single text field that are associated with a unique contact Id number. I the past I have used a single field to first put in a date of communication with a person then the call notes associated with that date. Over time of course this single text field has become rather bulky, plus I can not do simple searches in the field for specific dates or ranges of dates. What I am thinking now is that I should have a relational database called Call Logg which has a relation to the unique contact id number and fields such as date of the call, time, call notes, and other important information. …

I am trying to import Date of Birth into a Filemaker application from SQL Server. Date of Birth in the SQL Server is stored as "datetime" data type. It looks like this in XL: 26/05/2003 12:00:00 But can I get it into FMP? I've struggled all ways round, importing into a text field and using TextToDate function, importing into a Date field, into a time field. I'm stumped Can anyone help please? Thanks Richard Richard Berrisford ChestTools Ltd.

Hi FM Users I was wondering if any one knows if there is a size limit to images, specifically tif's, that can be imported into an FM database using the import folder function. David

I am creating a file of quotes from different authors. The text for the quotes is in a scrolling field. Some of the quotes are short, others are quite long. Is there was way to design a report so that the entire contents of the scrolling field can be printed, rather than just the portion visible on the layout? Thanks Scott

I am trying to get my solution to make a pick-up list. I have the following: I have 100 customers that are going to be picked up one morning for doing an adventure trip. I have 17 cars in the company I have name and pick-up point for all customer in my solution. I now want to make a pick-up list for each car, so 17 lists. However, if I i.e. have Mr. Spaghetti and Mrs. Spaghetti on one pick-up place I do not want to send to cars to this place. So in other words I would like to make 17 lists and do not break couple a part and only one car to each pick-up points unless there are more then 6 at that place. (6 customer in one car) Anybody have an id

Hi, We have the situation where people back at base need access to an FM db (on a LAN server). People need to record into the FM db on their standalone tablets 'out in the field' and come back to base and get that data back into the Central DB. There could be one or many users 'out in the field', so I'm not sure about merging two or more FM DBs back into the Central DB, or whether each 'man in the field' takes out a copy of the Central DB and they all get merged somehow back at base. The one/many people in the field will also need off-line access to the Central DB (i.e. a copy of this must be on their table pc too). Is there a prescribed way of doing this? Am I maki…

Hello all, I'm exporting data to a text file to give to a colleague who is importing the data into an INGRES database. Unfortunately, she needs each record to end with a line feed, while Filemaker ends each with a carriage return. Does anybody have a solution for us? Thanks, Carlisle

I have a couple of simple questions: 1. Can Filemaker Pro be used to both export and import data via ODBC across a TCP/IP network? 2. How do you import data using ODBC into a FileMaker Pro file? The FileMaker Pro file resides on one machine and the data being imported is in MS Access on a separate machine (the two machines exist within the same LAN). I am new to FileMaker Pro's ODBC abilities so am trying to get a feel for what is capable within the realm of ODBC and FileMaker Pro 6. Thank you for any help.

I'm putting the finishing touches on a solution that will soon be for sale. One of the last items I'm putting into it is an update routine that will allow users to download an updated version, click a button and automatically have their existing data pulled into the new version. I wrote something similar years ago, but with a major difference: I was the one performing the update, so I could manually do some of the tasks. Here's what I did: 1) Give the new version of the files a different name, i.e., MainNEW.fp5. 2) Place the new version of the files in the same directory as the old version. 3) Click the update button in the new files.

Hi All I have been trying to import an acad drawing into FM pro 6 and so for have had no luck in doing so. I have tried save the drawing into a program that called openoffice. This is suppose to be an share ware program to take the place of Excel. Could someone suggest to me how to import this drawing or suggest the software needed. Thanks in advance Lionel

Hiya, Can someone please advise me how to export field names with my tab file? Also, we Aussies generally use dd/mm/yyyy format and have our local system set to that. However, I suspect our server is in the US mm/dd/yyyy format for date fields. How do I have my date fields export in dd/mm/yyyy format as per the system settings? They currently export in mm/dd/yyyy format which is a huge problem as there is no easy way to change this in excel. Thanks in advance JB

Hi, all! Okay, I looked over the other article about parsing emails, and it was really helpfull, but I can't seem to get it to work. I believe I'm following his directions, but everytime I run my script, my field (for example "city") stays blank. Here is the contents of the email I'm trying to parse: Form from: http://travelagentdeals.com/pages/Subscribe.html Filled out by: 207.178.226.62 Email created by: Follow up: http://www.travelagentdeals.com/pages/thank_you.html ------------------------------------------------------------ Fax+Number: 234-235-2341 Zip+Code: 123456 Business+Profile: only Commercial SMTP+Server: mail.iswes…

Is there any way possible to have Filemaker export an actual carriage return within a single record. Am I spinning my wheels on the utterly impossible? Do I need to throw in the towel and make a Perl script do this for me?

I am using FileMaker 5.5 on a PC and a Mac. We frequently export filemaker data and import to Quark. Our users want a curly quote. I have changed the document preference to "smart quotes" but depending on the layout, FM will use straight or smart. Any suggestions to gaurantee curly quotes on export? Thanks.

Hi Guys, Im a newbie, hoping someone can help me out. Is it possible to export to Excel, where each record goes down a column rather than a row. Possibly using repeating fields? Thanks in advance.

Hi -- I'm looking for an AppleScript solution that will let me import a quicktime movie based off a set variable. I have zero problems inserting text, and/or images into FileMaker, but I keep generating errors when it comes to .mov. Essentially, I have this: property movie_path "Macintosh HD:Users:zippants:Documents:movies:02.mov" tell application "FileMaker Pro" set cell "movie_holder" of last record to a reference to file movie_path end tell The problem clearly is in the set cell statement, I have tried that line in the following fashions: set cell "movie_holder" of last record to movie_path -- Failed set cell "movie_holder" of last record to…

Hello everyone. Just joined... I'm building a complex scientific application consisting of both a C++ Mac application (OS-9 and X), a FileMaker Solution, and a FileMaker Plugin. I need to communicate data from my C++ App and FileMaker. Currently i do it (very primitively) using export/Import comma delimited text files. The only problem is that both programs need to know where to find these temporary files. Also, this must work on both OS-9 and OS-X! so i decided on using the "Documents Folder". however, how do i set FM Script Step to Export to "Documents Folder/export.txt"? Is there a way to give FM a path to which it goes when exporting?

I have now tried it on 2 different computers, but it's still not working: When I want Excel to make Pivottables from filemaker data, it won't work! Before it did work, and still with other tables it works, but not with the one I want to work on now! In Excel I get an error message " [color:"purple"]Database not open. Cannot open table:name of table ." I'm very sure the table is open, so that's not the problem...

I have been reading the parse email thread with great interest. I do however have a question regarding this process. How do you get the email into Filemaker to begin with? I guess what I need to know is what is the process of getting email from the email application to filemaker?

I want to export my records (which consist of the fields: name, address, phone number, city) with the City listed just once(as a heading) and then all the records that match that city underneath the heading (in alpha order). Kind of like a phone book, but this will be a student guide. I would then like to bring this file into a Pagemaker document. Is this possible? Example City A name a name b ... name y name z City B name a name b ... name y name z ... City Y name a name b ... name y name z City Z name a name b ... name y name z

Is there any way to hide the import dialog box? I am using FM6 to import an XML file from my website, and the dialog box says "importing from ..." and specifies my web address. I do not want my users to know the exact web address that this data is coming from. Can I hide the dialog? I tried freezing the window first but that did not work.

I'm importing records from a text file. I import the file in a single field, called IMPORT. The field IMPORT of each record stores entirely a single line of the file. However when FM finds a comma "," it treat the char as a field break and the rest of the line is not imported (since there are no more specified fields to put the remaining part in). Is there any way to make FM treating commas (and semicolons and so on) as normal chars ? thank you

Using FMP 5.5 I recently had to import voting data from a preexisting Party FMP file CD. My voter file and scripts used different Field Names, so Matching Names Order was out from the get-go. Manually dragging Field Names can easily overshoot to the top or bottom of the list, causing a displacement havoc. To align the import of the >80 Field Names into my file required over 3 hours by dragging. Given -- 1] Can't change data source Field Names, 2] must not change data target Field Names,and 3] must easily & quickly move Field Names manually. Does anyone know a solution for this or whether this problem has been addressed in v6?

I have created a "smart" PDF using javascript. If someone sends me their filled out version of the PDF file, is there any way to import this information into FMP? I should be able to use the Adobe javascript. I wonder if this is more of an Adobe export question rather than a FMP import question

We need to send out our data to somebody who uses FoxPro on windows (not sure what version). FMP will export to .dbf (dbase?), which is what the foxpro guy wants. However, the files won't open for him. We can import them (the FMP generated dbfs) into Q&A just fine (and the .dbf export out of Q&A works for him), and he can import them into excell and then into a .dbf that works with foxpro. Tab delimited works, but we'd like to use .dbf So what's the deal? btw, we're using FMP6 on windows

How do I get graphics out of FM container field to be a standalone graphic?

I am looking for a cross platform way to export the name/address block from within a FMP table and import it into a Word template. I can see a way to do this in a Mac only environment using Applescript, but that won't help in a mixed environment. Is there a cross platform plugin that will help?

We are setting up our internal system to include printable part drawings directly from Fm. The PDF's are exported in sufficient resolution in ProE to allow readable resolution on lines and dimensions when printed in A4 format. However once we import these pdf's into Fm (6.0 on OS10.2.4), the print resolution in greatly reduced. From my previous experience with Fm when importing pictures the resolution is pretty much imported the same as the original, but in the case of pdf's, it seems to have degraded significantly, such that the same pdf printed directly to A4 is no longer legible when printed from Fm. We have the graphics field set to enlarge/reduce, and have insure…

Dear All, I would like to know is there a way to import data from Filemaker to Excel. It means from Excel I import data from Filemaker. Do I have to set up something? IS there a procedure to do it since I am going to do it every week. One more small question I have a field using relationship calculation, when I export , it does not give me the right data ...is there way to achieve it? Thanks All Anh Phu Tran

I am trying to use Filemaker as part of an online store solution (I have actually just taken over the project), and I am having a few issues. Hopefully someone can make some suggestions to help me out... The setup is an online store that takes orders via a shopping system that we have purchased (which works excellently) and dumps them into a tab delimited file. On the same server we have Filemaker Server (an Mac OS X 10.2 XServe) running which contains all previous orders (and we use FMS 3 currently, so have many records to move over, hence the choice of Filemaker for the new system). The way the developers who I have taken over from interfaced between a tab del…

Hi I have a report with sub-summary that perfectly previews on screen but as soon as it sent to any printer, pdf file or even fax seem to be output as in browse view. Have you ever seen that??? I mean that the first line printed is the first line of the body (only one line = first record), then the footer. So there is no header, no sub-summary before and after the body.

Can anyone help me We need to verify the Medicaid coverage on 600-700 clients daily. We upload an FM text file on the State website. The results are displayed as a text report. I can copy only the text portion and paste it into Excel (see CopyPaste.xls with dummy data) or I can print it to file (attached PrintToFile with dummy data). I'd like to give the website, but it's a secure site. I have requested that they provide us with an option to download a delimited or fixed file but, of course, they just laughed (they are, after all, the State) I WebReport.zip

I always need to line up match fields every time I import data into a destination file. Is there a way to save the mapping fields order so I dun have to go through all those hassels? Thanks!

hello everyone, i am very new to filemaker, actually just started today. i am having a problem linking to an ORACLE database. i can make a connection and import the data fine. but is there a way to just link to the data so the data is pulled from the oracle database instead of being imported? any help would be great. thanks