Importing & Exporting

A Windows client has the FMP files on one computer, but does most of the work from another computer on the network (each computer has its own copy of FMP). When importing a pic into a container field by creating a link to that pic, then closing and reopening the files, the client can only see the pic if the file is opened on the "server" computer. They can't even see the pic on the computer on which the work was done. :

Jour! We want to automatize certain task, and make the content of our screensaver always up-to-date. It's a scrsaver with image and text for resto and services in town showing in hotels computer to give info to tourist and hotel worker about what's new in town. I like to know how I could link them, so text change in the database(ex:the resto menu) or image, automatiquely change in our screensaver by upgrading via our server or web site... Thanks in advance for any lead...

I'm using FMP5.5 windows ver and I need to keep a link from my FMP data file to MS Access 97. When I create the ODBC link, Access says I have to many index's. As I need the indexes and have deleted as many as I could, I thought "Why not export all the data to a FMP 5.5 file and ODBC link to it?" So I created a DSN file for the new exported FMP file and proceded with my external link from Access. Here is the problem, After I select the new file source, Access wants me to select a Link Table and there are none! When I created the link to my original file it showed all the data files to choose from. What am I doing wrong and how can I fix it? Thanks.

Jour! I'm a graphic designer. My compagny finaly decide to stop using publisher on Pc to produce magazine and starting using quark on a Mac(Thanks godness!!) I could't be happier... But we are using Filemaker a lot on all the Pc in our office and they want me to bring picture and the writers article store in our database to my Quark layout. How on earth this could be done, I have no clue... Could you give me some info? (plugs-in for it, article to read) In short anything !! Thank a lot... irislis Sorry for my english mistake but I'm french canadian.. This is the best I could manage. N.B:I do some pr…

Hi, I have Exel spread sheet which is having chiense character. I want to copy & paste those chinese character to a filemaker pro text field. While I am doing that those chienese characters are converted to ?(question mark). Is there any way to do it properly. Thanks, Kakali Basak

Greetings Folks I am losing leading zeros - when I create a tab seperated text file, leading zeros are retained. BUT then I need to save the file as an Excel file - which means importing tab seperated file into Excel & then saving it there. (this is the format required for uploading my stuff to a specific web site) - at this point all my leading zeros disappear from view. I have tried importing data both as General & Text format - with the same result Any help appreciated Regards Sean O'D London

I'm just wondering if anyone knows how to obtain the path to a referenced image file in a container field. Basically, I have a customer who has multiple people entering data and some are storing references to image files and some are importing the image into FileMaker. It would be nice to be able to somehow tell whether you are dealing with a reference or the actual image on a record.

I have an FM 4 database of about 1400 records with a container field for a quicktime movie. The movies themselves are stored on 7 CDs, called CD-1 to CD-7. Under earlier versions of the Mac OS (8.1), if the CD in the drive was not the one for the current record's QT file, the OS would prompt "Insert CD-5". Under the newer OS (X) the error dialog simply says "Please locate file <filename>" without any path information. The path data must be held in the db somewhere, because it is still accessible to OS 8. Does anyone know how I can winkle the path out and stick it into a field so that I can build my own error message? Many thanks, Dave

HELP!! When trying to insert an object (specifically a MS word Doc) into a container field I keep getting. FMP cannot complete this operation because of an OLE (0X80004002) error. Can anyone explain what this means an how to fix it. Thanks Stu

I'm using FMP 5.5 for windows and I have a question that I'm sure has been solved or asked before. I would like to use one file maker file (Like a menu) to serve all utilitiy functions i.e. export and import into or from various data files. So I've created a Utilities file and from there I want to export data from my orders file, invoices etc... My problem seems to be that when I use the export from the script command it wants to export from my Utilities file and I can't tell it to use my Orders file. Thanks for your help! Jim

Some of my Filemaker field is container type & filled with chinese(UNICODE) charater. When I am trying to export the file all the fields are exporting but the those fileds which holds chinese charaters are showing blank spaces. Can anyone help me to solve the problem ?

Is it possible to include field names when exporting records? This would streamline the process of importing records into my accounting software. Thanks.

I have a Microsoft Data Base file that I need to get info out of. It isn't a true Access database file, it came from my companies propriatary database with an mdb extension. Is there any way I can get the info into my FMP 5 database? I am using the Mac OS verison of FMP 5. Any suggestions? Is it even possible?

As a newbie (I haven't worked with FMP since '94) I'm tasked with migrating some existing FMP apps to a SQL based backend database. The ultimate goal here is to have ALL of our data reside in a single repository (MYSQL) without having to rebuild a significant number of our user interfaces. We have significant time and effort invested in building interfaces with with FMP and I'd like to keep them, only have them connect to MYSQL. I've tried using ODBC to connect, but it's not a real 'live' connection ... instead it imports the data into a FMP database, so I end up with a 'copy' of the MYSQL data. Since input is occurring at both ends (MYSQL and FM…

Hello all, As a newbi to Filemaker Pro 5.5, I have what I think would be a common request. I want to open a scanner program or any program for that matter i.e. (HP scanjet application) from within my file maker application. So the user can hit a script button that will open the scanner app and then the scanned image can be save to a container field all in one procedure. I have found external procedure calls for web use or email but nothing else. Any help is appreciated! Thanks, Jim

When exporting records I get the dialog box where I name the file I am exporting to. Is it possible to take the current database, clone it with no records, and then from the original database export to the existing file that was created as a clone? LR

Hi All, I have recently inherited a database. One of the issues I am taking care of is an importing script. I have noticed that after this import is completed, there are multiple Replace commands to set data in other fields. I know that Replace in multi-user is destined to fail due to record locking. My question is, does it also have the potential to fail if the records are brand new (due to the import), and no users would be on those records. My analysis is, it is still possible these records could immediately lock, if say, a users database is on a record that has a portal that might relate to a newly imported record "all of a sudden". I…

I want to import/update records from one file (dbase A) to another (dbase :, matching on names. The problem is that in the case of empty fields in the records that are updated (dbase A), the data from that field in dbase B are lost, thus overwrited with the empty field of A. How can I maintain data in B if the field in A is empty? Mireille

How do I export text that has been formatted, e.g. bold, italic, underscored and so on? It seems as if there is no export format that will support formatted text. Is there a plug-in that would solve my problem. Exporting formatted text to a MS Word document would be prefered at this time. I have FM 4.0. Thanks in advance. Henrik

how does filemaker handle directory structures (e.g., relative references?)... that is to say, if i have a file "Contacts.fp5" in directory c:foo and want to import from c:foo2, I would want contacts.fp5 to have an import step to import from the ../foo2 directory... does it actually store this other directory, or does it store "c:foo2" or neither?

I have two databases one with the same names as the other database. I would like to merge database1 into database2, but I only have some of the fields in one and not the other. Do I create the feilds first? Is there an easy way to do this? You see I also need record "John Smith" to stay in the same place. Thanks, RET

Hi, After linking a picture into my database I get an icon and not the data itself. OLE doesn't seem to work. Anybody any ideas ? Thanks,

Hi guys, I've never used filemaker pro 3 before and I need to export data from microsoft access 2000 on pc to filemaker pro 3 on mac. Any suggestions on what file format I should use when I export data from access. I thought good old csv format comma delimited? Any suggestions? Cheers

Hello all! I've been lurking here for a week or so wildly consuming (as fast as I can without getting heartburn) the knowledge you have to give on FMP. This has been a veritable Kings Buffet (or rather 'Queens' Buffet)! So here's my first question to you. We are proposing a database driven web site to a non-profit that currently uses GiftmakerPro, a fundraising software solution. Is this program difficult to integrate with FMP? We give our presentation on Monday and I'm sure I'll need to be able to address this issue to the board. We will be using FMP 5.5 Unlimited/Lasso to develop their site with. Thanks in advance! Stephanie

I need to take specific fields of individual FM records and export them into a new email. The touble here lies in the amount of steps and taking only certian parts of the FM data into the body of a text formated email message. I'm trying to accomplish this in word through a mail merge but it's not working. Please Help! [email protected] [ April 11, 2002, 07:00 AM: Message edited by: Carli ]

Can anyone please explain to me how to link a FM Pro db into Access 97 (win98) using ODBC. I have tried to set up the link with the File Maker Pro driver (there is also a Merant FM .txt driver which is not licenced with the FM5 Pro)and I am not able to connect for some reason. Is there a special trick or specific driver I should be using? I am a new and very inexperienced FM user - so please excuse the question. Thank yo for your help Jelena

I don't understand how ODBC works but I don't think that the needed driver exists for my Mac to import Access data. I hope someone can show me that, in fact, I can.

I have a .txt file that I want to konvert to a filemaker file. Each "post" in the .txt file is a line (devided with an enter) and every field is devided with a " | ". But filemaker cant understand that. It want

We import grades from a teacher gradebook on a weekly basis. I have defined the teacher number to validate to accept numeric values only. This works on data entry, but when data is imported non-numeric values are allowed. Is there away to validate during or after the import. FM4.0. thanks Hoggie

I have a field that is a counter for a specific persons records in a file. This works fine so long you manualy create new records. The problem is when I import records then the value don't get any bigger then one (1). To count a persons records I use a self relationship and the following calculation in the field. code: If( fieldname <> ""; If( Count(Selfrelationship::fieldname <> ""; Count(Selfrelationship::fieldname)+1;"1");"") It counts the time a record with fieldname exists and put that + 1 in the counter field. Is there some smart way to solve a problem like this? At second thought the solvation dosen't have to be smart so long it w…

I'm trying to export txt file which has linefeeds in one field. I have a calculation which constructs the text content for PageMaker tag file. Example: Export 300 users Current calculation produces 300 lines as: picturefile first name last name address tel Needed: picturefile<linebreak here> first name last name address tel Anyone can tell me how this is done? Thanks in advance.

Is it possible to add a pdf or .doc to a filemaker record, and how do I go about this?

gee, finally I find a way to place my question. I would like to insert a picture to each record of my db. Tried it with the 'layout' and got the result that the same and only one picture shown in every records. Typical beginner I am. Anyone can help? Pictures are jpegs.

I have 2 separate offices using one database. 1 office is mobile, and for the most part will be using the database locally. They will only be able to connect to the internet once a day. The Mobile office will only be editing 1 or 2 specific fields. Is there are easy and safe way for the home office to import the mobile office modifications to those specific fileds without over-writing their modifications to other fields?

I would like some help with filemaker. This is the first time I have heard of it when it was dropped on my lap and told to do something with it. Basically one of the offices have been using it to keep contacts in. And now we need to get the contacts out. except the export button (never seen the program myself) is not clickable and it was supposed to be done yesterday. So any help would be great. Thank you for any info. As far as I know the database is his but have no idea if there was any kind of password or administrative reason to hide or prevent exporting.

I currently have a curriculum database that was designed as a flat file. For increased efficiency and functionality, I would like to transfer this to a relational solution. The basic structure of the database is this: For every objective, there are many benchmarks. For every benchmark, there are many indicators. The current flat file is in the format: Record 1: Objective 1, benchmark A, Indicator i Record 2: Objective 1, benchmark A, indicator ii Record 3: Objective 1, benchmark B, indicator i Record 3: Objective 1, benchmark B, indicator ii I have created 3 databases: Objectives.fp5 Benchmarks.fp5 Indicators.fp5 I have created serial key …

hi, i need a help with import script. let's say i have file A and file B , file A - got name , qty repeat of 3 field. file B - got name & qty field no repeat in file B , i made a import script in file B. IMPORT [ RESTORE, NO DIALOG, FILEA.FP5 ] HOW IMPORT WORK ? 1 record of file A , will produce maximum 3 records in file B. because file A's qty field got 3 repetition. if all 3 repetition field is filled , it will import each repetiton qty as one record in file B. so it will be 3 records in file B. the problem --- let's say i'm importing first record of file A with 3 repetiton qty field and let's say there are 4 records in file A. < i…

Hi Guys, I would like to be able to import a PDF into a container field and actually be able to display it in the record. Therefore if printing the record it would print the PDF.. much like you can with word documents. I know i can import PDF to the container field but can it actaully display in the record?! is this possible or could anyone suggest a suitable work around. thanks

How to add a header to an exported text document 1) I am exporting about 10 records or so to a text Document. I need a particular text string that always stays the same to be the very first item in the text document. Is there any way to get filemaker to insert the text string at the first of the text file as it exports. The string never changes. I know I could create a field in filemaker and enter the text string in only the first record and not the rest of the records, but just wanted to know if there was a more elegant way. LR [ March 24, 2002, 08:49 PM: Message edited by: Larry Ross ]

I'm trying to import a big list of Chinese names into one field but they turn into ?? marks. I can input the Chinese name individually without problem. Maybe the clipboard does not support Chinese and strips all the formating? Is there any way around it? I have an old FM Pro 3.0 version. Any help is much appreciated.

Anyone know how to do it?

I'm using FMP 5.0 on Windows and Macs. As the machines I work on get faster and faster, I've noticed that when I am doing field mapping for importing from other data files, the field I am dragging zooms in both directions, and it is hard to get it right where I want it. (Especially if the corresponding field is somewhere in the middle of the list.) I guess it would help if the window was expandable. Thanks.

Friends, Is it possible to import PDF form data -- FDF -- into FMP v5.0 under OS 9? I have read that this is doable in OS X & FMP 5.5. Thanks again & again.... Fabe

Sorry if this is in the wrong section. I have the same database duplicated in 6 schools. Each school enters their own student info. They also customize a few of the layouts in each school. When I create a new layout in one building, I need to get that same layout to the other buildings. Is there a way to "export" the layout and "import" it to another database. If not, the only thing I can do now is to recreate the layout 5 more times. thanks, Mike

when I export address field to excell spreadsheet, a carrige return symbol appears between the address information. Is there any way around this? Thanks

For doing updates for a database system I have made, I use import from FileMaker file using matched fields and adding remaining. That problem is, say I want to import my customer database (17,000+ records) which takes a long time considering there might be 10-20 new records since the last import. So it takes 10 minutes it import. I want to try and speed this up. An idea i have is make a last modified field to field by then import the found set. Anyone got a better idea?

I create large (>5000 images) databases of plant photographs, to be used across Mac and PC. Of necessity this means checking the "Store only a reference to the file" option box. Can the box's default be set so it is NORMALLY checked? It's not a trivial problem, because a .jpg file accidentally imported directly into Mac FM is decompressed and stored as a 2 Mb implant, rather than 100-200K. Proofreading 5000 records is a major job that involves putting the referenced graphics "out of sight" and testing whether they are still shown in the file.

I am fixing up an old system in which the original author (I think was a gang of drunk monkeys) used repeating fields for almost everything (and made an insane number of other design faux pas.) I'm thinking of making some of them into the standard line items in a related database. But if i do that, I'm not sure if I can import all the old data. Is there a way?

I have a Filemaker 4.0. I've heard that Filemaker just afford 1.000 records, is this true? And if it's not; is there a way that I can merge two databases (of 1.000 records) into just one database? Any help will be highly appreciatted

This depends on both the OS and the programs, but yes data can be manipulated in such a fashion usong Apple Events, Frontier, VBS, VBA, and other means. Old Advance Man

We use FM to manage our ebay, unfortunatly i have the task of searching by title, and then inserting if it sold, final price and auction number. Now e-bay gives this to me in HTML format (woo hoo, ugh). Is there a way i can import this into FM and link it to my preexisting records? At 200+ acutions a week, this woudl be a huge time saver. Remember, more time saved, more money earned.

Hi there, i was just wondering if there was a way to export a file but that file name would be an entry in a field? so if i was doing an export for payroll week 10, there would be a container called "payroll week" and when you create a script to export it will save the file name what ever is in that container. this is something that i have been wondering for a while. any ideas?

Hello there, I am working on creating a new division on our company. I would like to use the exact "layout" (including scripts, pages, tabs etc etc) The changes will only be the name of the file. I do not want the current database information to be included in this duplicate. Just the basic overall program. For instance; We have a quoting system in place with quotes in numerical sequence. I would like the sequence to begin with a first quote of 1. Basically start over. Is there a way to duplicate the entire file for use with another comapny?? Thanking you in advance

I have a spreadsheet in Excel (Office 98). When I try to import it into FM 4, although it shows Excel as an option, it will not recognize the file. Any ideas?

Without knowing the specifics, it seems to me that either your update somehow messed up the relationships (less likely), or you need to import the actual [related] data into the other [related] file(s).

Does anyone have experience passing contact info from Outlook 2000 and WordPerfect 9 to FM Pro 5.5 and back? My firm has been using Outlook 2000 and WordPerfect 9 to manage their contacts. Shortly after arriving at the firm, I advised them to purchase FileMaker Pro 5.5 to use as our main database instead. They have now followed my suggestion. However, everyone in the firm is still used to using Outlook for quick lookups of info and emailing and WordPerfect for faxes and transmittals with automatic address inclusion. Since this preference for Outlook and WordPerfect is popular, I need to be able to pass the info back and forth between them accurately and relatively easil…

MultiUser imports and exports are very difficult to maintain. Why is it necessary to have these files placed in a separate database? You could look at using various relationships to move the data rather than export import. Old Advance Man

I have a FileMaker Pro database utilizing subscripts and superscripts. When I export this file to a flat text file, the subscripted numbers turn into just plain numbers (e.g. CO2 for the chemical symbol for carbon dioxide). Is there a way to get this data directly into MS SQL database with super and subscripts intact? If not, I was thinking there may be a way to replace the special characters with the HTML code for sub and superscripts, i.e. E<SUP>3</SUP> or CO<SUB>2</SUB>. Any and all help is greatly appreciated, thank you.

I am already doing that. Maybe I can shed more light on the problem by adding this: I have a database with over 200 fields in it. When importing records back into the database, how am I supposed to match the fields up so the import correctly? I understand I can save it in a script but what happens if I add or delete fields later? I still have to find a way to correctly import at least once before I can save the import in a script. I have no way to tell what data goes into which fields when re-importing the information unless I can get it to come in the same way it initially went out.

We have been running FM Pro Server 3 for years with FM Pro 3.x and 4.x on various Windows and Mac platforms. The server was an old Mac 7200 machine. Recently we upgraded to FM Pro 5.5 all the way around and put the server on a new Mac G4. We thought we would see a substantial improvement in performance, but we have been a bit disappointed. Of particular concern is the speed of imports. We have a time card database that we collect the labor data on a particular project by various technicians. When the project ends, we import all of that data into the workorder database. When the workorder is finished and ready to be invoiced, then data is imported into the Inv…

Hi, I have some data in a FMP database that I want to transfer to an Oracle database. How would I go about doing it? I am using FMP 5.0, I heard that 5.5 has ODBC connections but I think 5.0 has it too... How would I set up this connection so that I can move the data? Thanks...

I am putting together a directory with photo accompanying each record. When I try to import Photoshop files I get the message that there is not enough memory, try increasing preferred memory size. I have done this, taking the preferred memory to 50mb and get the same message. I can import JPEG images without a problem. Do I have to convert all the photoshop images to JPEG?

I am trying to output an excel file to the web. However, when the link is clicked, to go to that excel file, the excel spreadsheet displayed on the web browser looks like : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy ooooooooyyyyyyyyyyyyoooo'''''''''''dgfdg or something like that, no columns, no row, nothing like excel. the file is found, because i can catch some data on the display that relates to my file, however it is not right. The process works fine when i am testing it on a non filemaker web site. However, on my web site that is linked to the fm db, the display is messed up. Any Idea? Thanks David

Perform a find in the Main file to get just those records you want to copy over. Then go to the Smaller file and do an import. Only those records from the current found set in the Main file will be imported.

Can someone please explain what I do wrong! I have a FM Pro 5 database with six fields. I import data from Excellsheets and there can be doubles in them. My thought was to use the option "Update matching records and add new records" in the FM Importfunction and set the match one three fields which should capture the doubles and update the record if the three fields alla matched and then add all the rest. But this doesn

We have a database of "pictures," actually scanned documents to replace paper filing. We have been importing the full pictures instead of links (linking seemed too dangerous) and have reached the 2 gig maximum file size within one month. I am exploring finding from multiple files (to retrieve documents) but if that doesn't work out : 1. I will need to get the existing pictures out of the db to make the single file workable. How can I get the existing pictures out and establish "references" for them without re-doing a month's work? 2. Change the default in the import picture window to "store only a reference to the file." 3. If the refrences get lost, …

Hello everyone! I am making a database for photos of houses or vehicles. I have container fields to keep the photos, but I have a few questions about container fields and importing filters. 1) Pictures will almost always come off of a digital camera. From my Mac experience, the photos were in JPEG format. What image formats should be imported into FM? 2) I am testing this field with images from the Photoshop 6.0 Sample folder. I saved the image as a JPEG onto my desktop. When clicking Insert/Picture (A process I will script in the future) and point it to the picture I have saved, I either get a error message "Image Could not be imported. The filter could not import the…

OLE is a link. Not an import or an imbed. The letetrs remain on the Windows OS machine's network, not on your MAc. Old Advance Man

When you specify a specific file for FMP to import and the file is not in the correct location, you get an error message that says FM cannot locate the file and the import cannot be completed. There appears to be no error code you can capture to deal with this issue. Can someone help?

I've got a VB program that currently opens an ODBC connection to FileMaker and finds a particular record. The program then pulls the feild data out of the database and performs particular functions. I'd like to start using the same program to create new records and change field values. However, the feild values aren't changing when the program runs, even though I can see that the feilds are being accessed line by line. Has anyone else run across a similar issue. Here is the code I'm using to access FM: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Set cm = New ADODB.Command cn.Open "Provider=MSDASQL.1;Data Source=FMTest;database=myDatabase.fp5 cn…

Dear Import/Export specialists, I want to import the Excell file into File Maker Pro 5.0 while creating field names on-the-fly. In other words, I don't wanna go through heartache of creating same fields in FM as in Excell. The scheme that seems good is importing it first into Access (this will create fields on-the -fly in Access), do all my querying in Access, and then export it into FM Pro. I have Local Data Access companion enabled, and File Maker Pro ODBC driver istalled. I created a Data Source in the same folder as Access table, but got an error: ODBC--call failed. Create Table statement is not supported. So from this I understand that FM Pro …

hi there, i'm really new to filemaker so please be kind! i need to be able to have an html document on the web that accesses certain parts of a FM database. For example if I have a web page that has a "company" field and I have a database that also has a "company" field and I then change the name of a company in the FM document I would like it to also update the html document. Is this possible and if so could anybody give me any tutorials etc to help me through my hour of need!

Hello, I have an application where I need to import data from a tab text file into two filemaker databases that have a parent/children relationship. Can anyone advise the best way to approach this. The data looks like this. parentrecordA1->Field A...Field K childrecordA1->childfield1...childfield12 childrecordA2->childfield1...childfield12 childrecordA3->childfield1...childfield12 childrecordA4->childfield1...childfield12 parentrecordB1->Field A...Field K childrecordB1->childfield1...childfield12 childrecordB2->childfield1...childfield12 childrecordB3->childfield1...childfield12 childrecordB4->childfiel…

I am running on OS 9.2 and Filmaker Pro 5.5. When I try to import or open a .dpf file created in Microsoft Works database on a PC this file won't show up in the window with show all available selected. The dbf translator is in the FP extensions folder. Why won't it show me the .dbp file? Thanks!

Hi, Would anyone have an idea what could be the problem: The application resides on the Mac OS X server, FM Server 5.0 One of the users is creating records using a copy of the application, locally on her Windows ME computer. She exported the data, sent it to me, and I imported it into the server-based application. The record in question has one letter in one word of one field(out of >400 fields)changed to a period. The user says that no one changed that particular field, and it happened as a result of the import. Since I still have the file that was sent to me, I re-imported it again - and the problem is not there. I was wondering if…

Hi all, I'm new to this list and a (newbie) user of FMP 4.0. From a client I got his fmp database. In this database he made use of 3 containers where he put images (jpg/gif) in. Now I want to export the whole thing to access or whatever. And you get it: where are the container files? I tried to automize a copy/paste action with a program called AutoIt, which copys the fmp image to the clipboard, pastes it into an image viewer and then stores it on my HD with a reference to the record number the image is belonging to. This goes well, but sometimes, when an image is missing, fmp shows only the error "can't find file name.jpg". Since this message…

Hello, I have a MS Word file which I would like to import into FM Pro 5. I would like each page of text to be in a separate record. I have split the text up in MS Word with forced page breaks. Is this possible?

is it possible to take a database that was created on a mac and open it on a pc? I don't mean open it on a network. I mean can you copy the database from a mac to a pc and have the pc now run the database? When I try this the pc can't see the database and acts like it is a file that it does not recognize. thanks wade

Greetings I was hoping you guys could enlighten me regarding importing/exporting images in a container field from one file to another. I have a solution that will be installed on a laptop and a desktop. A field agent goes out to a location and snaps a digital photo. He loads his photos into the FM solution on his laptop, along with photo information. He then exports this record as a .CSV or FMP file and emails it to his secretary (oops, office staff) who can then import the file into the solution on her desktop. It appears I have it worked out until I notice that during the import, I am not able to import from or into the container field, because it does …

I need to recreatea database done in FM in MySQL. Any way I can export the structure so I don't have retype all the field names and such. [ February 04, 2002, 10:50 AM: Message edited by: signal ]

Anyone here know of a good way (internal or external plug-in) to batch import sound data into a container field? I have a bunch of VOX files I need to get into records in a FileMaker database and I can't see any way of doing it other than the manual way. I know I could batch up path and file name references and keep the files on disk (which, yes, would be the most efficient use of space) but I'd like them in FileMaker all the same. Any ideas?

Lets say I have a database with lots of records and fields. Can I update one of those records with an import of only the fields that need updating or will it wipe out the other fields in that record? [ February 12, 2002, 06:55 AM: Message edited by: signal ]

Overview: I have constructed a DBMS, comprising of over 100 Filemaker Pro 5.5 databases managed via Filemaker Server v5.5. The purposes of the system is to be able to gather every single detail relating to a construction project of over 500 apartments and break it down to specific details relating to each wall, window, door etc. information relating to which is then applescripted into MiniCad for production of drawings. The client's LAN/WAN comprises of just Macs, at their offices, and an iMac in the construction site office which is connected via Remote Access to the main office. Problem: Being, after all, a construction site there are large power fluct…

How do I prevent duplicate records from being created when I am importing records from an external (non filemaker) file. Checking the Unique Validation box seems to have no effect on imported records!

Hi-I am in the medical field and I email reports to a hospital. I want to design a layout for my report that can be emailed to a pc/windows that does not have fmp but does have the office suite (including access). The layout would have at least 12 to 15 fields, and need to be printed. It would also have to retain its form. I am using fmp 5.5 on OSX 10.1.2. I usually send at least 15 to 20 reports a week. There is no way they can have fmp on their computers. If any one can help-please be very basic-I can be a little slow sometimes! I appreciate your time-Terri

Hello, sorry to post such a simple question...how can I export only a found set of records instead of an entire database? Thank you for your help... Todd

Hi all, I'm new to FileMaker. I need to import a huge student database (currently in text file) into a database which contain 3 fields, Name, particular and date motified. The format of the text file is in following Name<return> <return> <tab>particular<return> <tab>particular<return> <tab>particular<return> <return> <tab>particular<return> <tab>particular<return> <tab>particular<return> <return> <tab>(Date format in yyyy-mm-dd)<return> <return> Name<return> <return> <tab>particular<return> &…

Please excuse this seemingly basic question... I'm attempting to import the data from one data base to another, but the only data that is not being successfully transferred is from the repeating fields. I notice that the option "import values in repeating fields by:..." is grayed out so I cannot make a selection there. Any thoughts? I'm using an old version of Filemaker - 3.0. Thanks!

Hello, I need to get a mailing list file from Access 2000 (PC) into FileMaker 5.5 (Mac). One sugestion I got was to export the file as an Excel document then import that into FM. Any better way? Need all the help I can get! Thanks, -Maxx

I have a container field with references to quicktimes. I need to turn those references into an actual import into the record. Is there a way to do this. I need to move the datatbase to Filemaker server, but all of the references are screwed up. Thanks!!

I will be attempting to export data from FMP on a Mac to an Access database on a PC. This is for a nonprofit and I'm the one that has to do it. I know a bit. Can I export the mac/FMP data as a .csv or .mer file and load it up to the pc and have access import it from there. Or do I have to have FMP for the pc as well to do this? thanks

Hi Forum, I'd like to send the result of a merge to a file. Even copying it to the clipboard would be a help. For example I've merged some names and addresses with a form letter now I want to email the letter to someone. How can I export the finished letter? Thanks in advance! jmc

I've created a calc field containing the contents of a value list that consists of related fields from an external file. It takes a few seconds to come up, but that's another problem. The current problem occurs when I want to export the contents of this field. Unfortunately, when I export more than one record, the field doesn't take the time to recalculate for each record; as a result, the contents of the calc field from the first exported record gets exported over and over. Help.

Hi everyone, I want to export some data from my db in FMP 5.5 to a CSV-file. I've created a calculated field (result is text) that contains all the data that should be in the CSV-file, but if i export the records and open the CSV-file the data is surrounded with ""'s (quotes). The program that imports the CSV-file doesn't appreciate these ""'s. How can i prevent the ""-adding ???

I see that Intuit Quickbooks can only import a certain proprietary IIF format... Has anyone found a way to export from FM to maybe Excel and then into Quickbooks....or some other workaround? Thanks! Brian

Hi. I am looking to take a purchase order database and export records to excel automatically every time a PO is created. We have multiple sites, which is a category on the purchase order. I need to separate the spreadsheets in excel by each site and then by month. Is this doable, and if so how would I go about doing this? Thanks for any help.

Hello, Can I put a button or field or anything into a document database which will take me to the relevant document created in MS Word? I am new at this so please use the KISS principle (Keep it Simple Stupid) Thanks Tom Cowen Alotau Papua New Guinea [ January 24, 2002: Message edited by: Legal office ]

Obviously, you'll have to create a new Master file as well. Then it gets tricky, since you have to create records in the new Master file with the necessary IDs. It's doable (I've thought of two methods off the top of my head), but my guess is that whatever you're really trying to accomplish can be better done another way. For instance, if you need a printout, create a leading summary part in the LineItems file when sorted by the ID field, put the ID field in the summary part, do the find, sort and print. That's just one possible alternative solution; there are many others. Chances are there's a simpler way to get the final output you want; I suggest working from that…

First, sorry if we are in the wrong forum, but hey we're new at this... We have got a problem with linking ms word documents in a record of FMP5.5: If we use a containerfield with a link to a ms word document, ms word will open in FM but it won't open in a webbrowser(explorer 5.5).And there is the problem, we want to open it in a webbrowser. Can anybody help us with this matter! Thanx, Marco and Niels Amsterdam, Netherlands

I am importing data into FMP from an excel file and have a field as a checkbox. Seems like this data is not being imported into this field. Please help ! thanks, Shalu