Importing & Exporting

is there a name for the process of removing items from inventory after you import them. how would you do that? i have one form of customers and what they ordered and another one with my inventory, how would i remove the item from inventory based on the sku during the import process? on the inventory form it has 2 fields one for called "in" and one called "out".

On the Filemaker web site. There is a page stating you can drag and drop excel spreadsheets into a Filemaker database. Are they referring to import or is it actually a drag and drop? http://www.filemaker.com/promos/50dollar_rebate.html

I'm having trouble opening DBF formated files. I need to convert a number of tables into FM, but every time I try, I get a generic error message. I was able to open the DBF files easily before I upgraded to 5.5. I have checked my extensions folder in FMP and the DBF translator is there. The open dialog will show me the DBF files when I select that file type. But when I try to open the file(s), no luck. I have checked the FM.com support knowledgebase and only found one document that might apply. It suggested I try changing the file type to "TEXT" which I tried, but again, with no success. Anyone have any suggestions. I need to move my files out of Fo…

Hello, Having an import problem with a JPG file I work on osX with Fmpro dev 6.04 The file won't import into Filemaker, it isn't even listed in the import list (dimmed). I can open it in all other apps but not in FM. If I resave it with photoshop 7 it works OK. What's wrong with this file? Any info appreciated. http://users.pandora.be/bonte/afbeeldingen/179.%20Trollen%20va%c9ist%20(Front).jpg

Apologies if that has been discussed before: If you import a set of records with the 'update existing' option checked, and the imported set has to records with the same key field value, which one will take precedence? The latter one? Example: I am importing part number counts into the db. What if I have the same number twice in the set that is being imported (the first one being a value of 6 the second being a value of 9) Which will end up in the db?

I'm new at FileMaker...this will be elementary to most... I made a flat file database with a runtime engine for a client to enter data at two sites. Now, I'm trying to write an import script so that a third party can keep a copy of the database with all the data from both sites. When I've tested the script, and I import the exported file, everything seems fine, but if I import the exact file again, it duplicates all of the records even though I've checked "update records" and "add new records" on the field mapping screen. My match field is an ID number that is a calculation field--concatenation of serial# plus left two letters of the location. I checked "don't st…

Hi, is it possible to attach a MS Word document to a record (preferrably by a hyperlink)? Our current workaround is pasting the text from the word document into a text field and losing the layout.

I am using Filemaker Pro 6 and the Server has FM Server 5.5 and both server and client are working on windows - Win 2000 Server and Win Pro 2000. I need some help with exporting and importing data from Filemaker using XML - SOAP format ? I would appreciate some help.

Hi Everyone, Would someone please help me with the following information. I have no experience with FileMaker or any other database for that matter so forgive me if I don't explain this very well. I have a friend who has a program that uses FileMaker Pro 3.0 for it's database. Is it possible to export his customer records into another program? The program he's currently using is quite old and is not operating correctly and the person who wrote it can no longer be contacted. He obviously doesn't want to lose the details of 7000 odd customers. If it's possible, I'll get to how it can be done next. :-)) [color:"black"] Thanks for your help. Regards, …

Trying to make my idea work but still don't succeed in it, allthough I've posted a similar question before. - I have a FM database that will be distributed to users as an executable. - Every record has 20 fields. - The first 10 fields will be edited by me. - New records will be added by me. - The second 10 fields of every record wil be edited by the user with data that only concirns him. After I have edited records (the first 10 fields of every) or add new records (with the last 10 fields empty) to the database, I want to sent the users an update. The user must be able to import the (changed) first 10 fields of every record that is already in his ve…

OK here's a strange thing, and as usual, I will do my best to explain it. First, I am using FM 6, and I have a conditional pop-up menu. I have a "Item_Category" field that dynamically changes the "Item" field. The value list is an "Only Related Items" list. Now, the catch is that I have the "Item" field set to Auto-enter a lookup so that you can't change the "Item_Category" field and accidentally leave the "Item" field unchanged; "Item" jumps to the first item in the newly-changed value list (the value list is set to include only related items). I hope that makes sense. Okay, now here's the actual problem. I have a script that imports "Matching Field Name" rec…

I want a "copy as" of my files. Could be possible a automated copy ?. For example, each program closes, filemaker will do a copy depending on file creation date hour etc. on a seperated folder ?

Hi, I live in Palm Beach County...home of the butterfly ballot and now the National Little League Champs. I bought Filemaker Pro 6 3 days ago, and after several hours of frustration plus a useless phonecall to the company techinical support, I stumbled across this forum and I am hopeful somebody has some advice. My problem is the same Supervisor of Elections office which did the butterfly ballot will sell a bonafide person a list of voters on a disk. I have 10,700 voters for the Boynton Beach City Commission District 1. It is in the format which the SofE worker calls "Fixed length record". Each record is exactly 541 bytes. There is a list of fields which lis…

One of my users installed a newer version of my runtime program on his Mac and then experienced the following problem. After he imported his files into the new version he found that when he attempted to export even a single record (300KB) the export feature takes ten or more minutes and when completed, the size of the file is 5.5MB even though when you open up the exported file all you see is that single record of data. He installed the program on two different Macs and is having the problem in both locations. This problem does not occur on my Mac, which burns the disks. Any Ideas?

Is there any way in filemaker to export only the newly created records and append those records to the previously exported ones? This will be a nice feature to implement. Thanks, Avida

I frequently import records from Excel files and fp5 files. I update records in found set, based on a matching field. However, if I have 50 records in my source file, and only 46 can me matched, and therefor updated, is there anyway to "display" somehow the records that WERE NOT updated? As it is now, I export the updated records to Excel, and match the data until I find the missing records. This is really inconvienent, and I am sure there is a much better way. Thank you...

I am a newbie in FP. I am working with FP5 and I planned to export records to Excel and Word in MS Windows. Word: I wanna to let my user to choose which record(just 1 record) he wanna to export by pressing a key in fm5. Is there a way to do this? Excel: I wanna to let my user to select muliple records and export to Excel by pressing a key. May I know how to do it? Thanks in advance.

I have a client that uses FM to record some events info. She wants to export that data, so I can then process the file using a PHP page and throw it into a MySQL db behind their website. I have a problem - the file that FM is producing is proving a nightmare to process. It is tab delimited text, but only seems to contain a line feed char as the record delimiter (ASCII char 13). All the PHP functions seem to want a full carriage return / line feed pair. When you view the file in any Windows text editor it is all in one big block as you might expect. Are there any other options that my user can invoke to produce the file in a different format. I am a total novice …

I need to be able to take data that looks like this: company name: my new company E-Mail Address: [email protected] Web Site: Home Phone: 555-123-9876 and drop it into a field in my FMP database and have a script that parses it into the correct field. The challenge is that not all of the data that I receive is "required". Other things that are challenging are things like company name where the name could be 1 word or 5 words. The one good thing is that all potential fields are each on their own line when I get them. Thanks for any and all help.

I downloaded a lot of attachment from that forum. Often I have a dialog box SAYING "System set up different than yours" (I try to transmate it as I am french). The problem is that this dialog box appears now even with my own DB. Do I have to change my settings ? Thanks

I am working on a database for a cabinetshop. I export my data out and open it up with microsoft excel. Once it is in MS Excel, I produce a pie chart to graphically represent relationships. As a value is changed, the pie chart changes. I would like to automate this process. Is there a way to produce something like an ODBC link where change in filemaker would automatically reflect the change in MS Excel? Can somebody aim me in the right direction? Thanks. Jarvis

OS: Windows 2000 Filemaker Pro 5.5 I have a container field in my database, and if I import a jpg file, for example, it works fine, both directly or via a link to the file. However, if I attempt to import a TIF file, I cannot do it, either directly or via a link to the file. The error message presented is: <filename>.tif could not be imported. The filter could not import the selected file. Thinking that perhaps the LZW compression might be the culprit I tried it on files I knew were not compressed and got the same error. What am I (or Filemaker?) doing wrong here? I am planning to use Filemaker to organize several hundred photos to be used…

I'm trying to link/import FMP 5.5 data into Access via FMP ODBC (FileMaker Pro FMFMP50.DLL). It fails with "Invalid Field Definition '<field_name>' in definition of index or relationship". I delete the index in FMP but I continue to get the error. I deleted the field in FMP, and now I get the error on the next indexed field. But I'm not even sure if the problem really has to do with indexed fields, when I deleted this field and tryed it again, I got the error on a non-indexed field. Is it actually possible to link via ODBC to a FMP dataset?

So here I am, with a Mac (yes, all you Windows types can razz me now) and an Access ".mdb" file, and no apparent way to import the data. Any suggestions?

Hi, I'm currenty unable to get some data from a FileMaker 4.1 database into a replacement Access 2000 application. I can export the file but Access won't import it. After much investigation I discovered that the export file (approx 2MB) contains some weird characters which cause Access to fall over. Undaunted I wrote some VB to strip these out only to discover VB 6 (and Access) recognise these additions to the export file as 'End Of File'. Though I could open the files in Word or Wordpad (both Access and FM are on PC's running win 98) I've tried all sorts of formats (comma separated, tab separated, merge, DBIII etc) and all sorts of characters sets to no avai…

I'm doing an export of some 36 fields from a FM (Developer 6) DB and 3 related FM DB's. I'm putting the export in a script. I've got one field that's driving me bananas - it keeps disappearing from the export list. I performed the file export, create the field list, - works fine, everythings there. I openned the script, clicked on the export statement, clicked done and told it to replace the export. I ran the script and this one field (from one of the related files) didn't show up. I ran it again and checked the export field list, and it wasn't there. So I did the file export bit, and the field wasn't there either. Many, many tries and no luck. It'll e…

Our law firm is on Macs. Unfortunately, we need to use a Windows-only time-billing program. We've decided to go with TABS. I'm writing a small database to "capture" the time at our users' laptops and desktops. I need to figure out a way to export that data from each computer, combine it to a main data repository file, then import that data into TABS. Any suggestions as to handle the process where we export from each computer and combine into a main repository file? I'd like to leave the data at each user's station intact, so each user can run basic reports (timekeeper productivity, etc.). I'm quite new to FMP, so basic explanations would be greatly ap…

I have several scripts written to export data from my contact database (FMP 6.0v4). The exact fields being exported, or their order might change from script to script. Is there a way to "lock" those export fields and their order for just that script? Currently when I export and change the required fields add or subtract, when the export script runs, I have it pause and the right column has the fields from a previous export, so I have to start over each time. It sounds like a simple request, but I can't figure it out.

Just got it!

Hello, I have a question for you FMP experts regarding how FMP 5.5 Server / Client "remembers" or recalls the file path for importing and exporting data. I've been working on a legacy (fmp 2) solution that a client requested be placed on their FMP 5.5 Server and some additional functionality. (they did not want a total redesign, that I suggested) The current data flow runs like this A databases (inventory) exports some records to an FM database (temp) then runs two external scripts that import various fields from this newly exported database. These databases then export tab delimited files based on the imported data. This was originally run as a single user…

Hello, Is there a way to capture the text string value for the file name chosen through FileMaker's 'Insert Picture ()' function? I've created a simple button that allows a user to insert a photo, but would also like for that script to write the file name to a separate field. Thank you.

I have an FMP database. It has several fields: text, numbers, dates and one container field where I keep a picture for each record. I want to select some of the records and export some of the fields, including the one with the picture to an html table for publication in our web site. I have not problem exporting all the fields very quickly and automatically, except for the pictures. I can add the pictures by hand. The result is fine but it takes a lot of work, time and risk of errors. I don't want to buy or set up the FMP version for the web; I don't need to give the viewers any searching capability. All they need is to see the table but they want i…

I'm using Filemaker Pro 6 with Filemaker Server 5.5 on an NT system. We have a database of books. Every book has a unique ISBN number. On our network, we store images (jpegs) for each book - the filename for the image is the books ISBN number. I would like to be able to look up an image on the network based on the ISBN number and return it into a field in the corresponding Filemaker database record. I looked at the Troi plug-in, but I couldn't get it to work the way I wanted it to work. Any suggestions? Thanks.

I loss my images when i transfer my database from 1 computer to another. My images are linked to the database and even if I drag my whole folder over my network or save to cd and transfer that way the images go. Any idea's? I have over 9000 images so re-linking is not an easy option

I have a problem with import of an XML structure via a PHP generated XML structure. It seems to work on my local machine, but it does not work on the one of my provider. Does he need the XMLRPC add-on on his machine? If I import the same structure via an existing XML file everything works fine. any ideas?

I have a database of events and have been asked by enough users now that it annoyed me into actually looking for a solution: any way to import from filemaker to palm date book? I mean, I put the friggin' thing on the web, they've all got laptops and wireless internet, and still they ask, "Can I import this into my Palm?" Ungrateful so and so's.

Can someone give me a heads up on how to convert the attached records in fp fields under the respective catagory Thanks for your help in advance vhs.txt

What is the easiest way to export a filemaker database to access? I need a method that will limit data loss to zero, and will be easy for a large database.

Post deleted by Cmearl1

Hi!! I need to import 9 Excel Timesheet Files Weekly into FM to do a cleanup, validation and spit out reports on delinquent employees. I've got the meat and potatoes of the program done, but I was wondering if I had to import the files manually each week. As far as I can see, the Import script only allows you to choose one file at a time. I have a folder named "Timesheets" that holds the Excel files named with the Employee Init and Week No. (AGD-0334, DAT-0334, etc) The week numbers will change obviously each week. Can't I tell FMP to import all files in that folder at one time, or at least all files with the 'Week Number' field in the file name? None of …

Hi all, I'm new to the forum and hope someone has had a similar problem and can offer some advice. I have a database of about 2000 records and 500 fields, when doing maintenance on it I make a copy first, make the changes and then import the 'live' version back in. It used to take 30 minutes or so to load all the records back, but now takes more than 5 hours! The only significant change I made that could slow it down was to add about another 20 summary fields. Has anybody had a similar experience? Thanks.

I am just finishing up a small project that needed to be in filemaker, and print out high quality images. Since we produce catalogs, I naturally used TIFFs as the image format. However, when I wrote an applescript to import all of the records (necessary due to some logic needed to import the thousand or so images), I kept erring out on a group of images with a "incorrect data type" on some images. After hitting my head on a wall for a while I finally discovered that these images happened to have transparency enabled. After a re-save in photoshop, they imported fine. Lesson learned: filemaker does not like transparency

Hi All, I'm trying to export a database into a tab-separated text file which I will then run through a template that will do some html formatting on it, and I'm running into some problems. I have about 200 fields, and only about 100 of them are showing up in the Table view of Browse mode. Those same 100 fields seem to be the only ones being exported, as well, even though I specifically select all fields to be exported. Is there a field number limitation on exporting, or a file size limitation? I'd appreciate any help anyone can offer - and reducing the number of fields isn't really an option. Thanks, Brian

I have two seperate DB's. I would like to export from DB-1 only a few records into DB-2. I do not want to import all the records in the DB. My prupose is to import certain records used from a previous years report into the next year. Can it be done?

To change the original import order I run my script (which has restore, no dialog selected) and then watch what fields filemaker imported (File menu - import records). Here's the problem, When I watch the import order after running my script it isn't the one it used for the script. Even though the import was perfect (and that never could have been with the import order filemaker shows me). What's going on? How can I view the used import order? Thank you for reading and eventually answering my question.

did anyone ever tried to import MARC (or UNIMARC) data into FileMaker ?

For the past several years, I have been archiving old paper files onto a FileMaker database. In each record, an image of the paper file is stored in a container field. Since I started, I have been inserting the .tif files via Insert > Object > Create from File and then choose the one I need. Up until last week, when the image was inserted, an icon would appear and the filename would appear underneath it. Whichever program I had set as the default for opening .tif files would open the file if the container field was double-clicked. Now, however, whenever I do exactly as I have been doing for the past several years, I get a thumbnail of the image in the container…

Has anyone experienced problems exporting data from filemaker to ".mer" files in a set hosted by Server 5.5?? My Export Record script step has the restore export order and no dialog options selected. The export works properly in a single user environment, when we move to server 5.5 it doesn't export the selected records. Any ideas?? Frustrated... Chris

I've got a thoroughly naive question for you all...I am beginning a project involving data mining some very large fisheries databases. Trouble is, I'm a field biologist and a definite neophyte when it comes to database extractions and queries. I'm looking for Mac OSX compatible software with a reasonable learning curve. I must admit I'm more interested in the questions I may be able to ask given the right data, than I am in learning a complicated software package. Other folks have suggested that I download MYSQL saying it's easier for what I want to do than FM, but a quick look at MYSQL has me rather concerned! I know that I can import tab-delimited text files from the ma…

How do I create a box that when selected, will allow me to navigate to an image on my harddrive, and then display said image reduced to fit into this box. This all has to be done while in browse mode. Can somebody please let me know if this is possible. Thanks

Hello Team, I have a calculated field which the calculated result is text. A simplified version of the calculated field is "SR" & "," & "Account Reference" & "Net". When I export that field, the result that comes out as a CSV file is : "SR,ABCDE,100". I would like to format the field so that the export of each field has speech marks in between each value i.e. "SR","ABCDE","100". Is this possible? Thanking all in advance. Jalz

Every day we export data in .csv format from a Filemaker file hosted on Server 5.5 via Client 6.1. The export includes all records in the table, about 120,000 records. From time to time we get additional rows inserted into the csv file for which no record exists and that contain no data. They are correctly formatted, containing the correct number of fields, all of which are empty. And we have noticed that these only appear in locations where records have been deleted. All our records are given a serial number when they are created, and the empty rows are inserted between serial numbers where we can deduce there have been deletions. So it is almost as if, w…

Hi, Is it possible, when using the Import - Folder function to import all the contents of the folder into a single record? At the moment, if the folder has six images the Import - Folder command creates five new records (one image goes into the existing record, the other five go into new records). The database I'm building has 900 records and each record has at least 8 images. It would be great not to have to import each of these images by hand. Really hoping someone can tell me how Thanks, Dave

I am looking for a solution which enables a Filemaker database to place items like meetings and appointments into iCal directly and move the item around if the appropriate date/time attributes are changed from within the FileMaker database. Such items would appear in iCal under a calendar unique to the FileMaker database.

Help! Here is my issue. I have a field designated as a container in layout mode. I want this to contain a thumbnail of the first page of the quark doc for that particular record/job. I can't figure out how to set this up because this layout can and often does contain more than 1 record. My question is how do I specify that field to show the image for each record, not the same image for each record. Is there some way I can click on that field in browse mode to allow me to link it to the quark doc. Please Help!!

I imported a text field that I want displayed as a money field. However, instead of displying the correct amount the program displays 2 zeros to the right of the decimal point instead of placing the decimal point two digits from the end of the text (i.e. 13155 shows up as $13,155.00 instead of $131.55). How do I fix this? Thanks The Mad Jammer And then...there was nothing

Can anyone please help me with importing data from an fp5 database to one in fp4? I can't seem to make it happen.

Help! I am trying to include a thumbnail in my database. I created a new field and designated it as a container. But when I go to Insert/Picture, I get this error message; "Error -2804 occured during initialization of Claris XTND System" I am running FM 5.0 on a G4. Ideally I am trying to include a thumbnail of the first page in Quark for each of the jobs/records in my database.

I have been asked to create a FMP file to handle accounting data. The user is currently doing this in Quicken for Windows. My problem is that they want to import the data in the Quicken file into the new FMP file. Can anyone tell me if this is possible, and if so, how to go about it?

I have a set of files developed on a Mac that is being migrated to FM Server (on a Win2000 Server box). These files run a series of import scripts, both importing from related FM files, and importing text file dumps that are positioned on our NT Server's hard drive. I created them in FM 5, then 5.5, and am now running them in 6. When I place all the files on FM Server, I found I have to open & close each import & export script and re-specify the file location. So far so good. This works to respecify the path to the Filemaker files. But when I try to do the same thing to the text files, it fails. I've tried unchecking "save relative path" and it does…

Hello, I have a client that wants to use Filemaker Pro (5 or 6, he has multiple machines with multiple copies) to gain full access to our web database (MySQL) I tried figuring this out by myself to no avail, as I am not really an expert on Filemaker. I would appreciate any tips/tricks or pointers as to how to make this happen. Thanks, Denis

When importing files into filemaker, you can designate a "match field" and then update the record with the imported data instead of creating a new record. I'm working on getting and putting info into Filemaker via ODBC. I can find and retrieve records just fine with ODBC (not the speediest though), but when I try to use a primary key and update a record, it simply creates a new record instead of first finding the matching record. I'd like the behavior of using the primary key as a "Match Field". Is there something I'm missing, or is it as I fear and Filemaker's ODBC implimentation is just poor in this regard. This is using OS X, and the other side is the UPS …

Is there any way to achieve (or closely simulate) real time data sharing between FMP and an outside data source? I'm using FMP 5.5 on Windows, and I may need to interact with a data source on a Linux box. Is Importing/Exporting the only way to go? Can I 'push' data into FMP from an outside ODBC source? Can I view ODBC data through FMP or do I need to import it? Unfortunately I don't have a lot of details at this time, so I'm mainly looking for general suggestions or options that may be available to me...

Hi, I have an issue where a .mer (merge) file is read as a sylk file when I go to import it into excel. It does not happen with all my databases, only a couple of them. Has anyone encountered a similar problem or know how to fix this? Thanks

I

Is there any way to tell FM Pro to change the line feeds in a calc field to carriage returns? I need an automated way to do this, either via scripting or a plug-in. It has to be simple - my users have little technical expertise.

Does anyone know why the FileMaker Pro ODBC driver is unable to create DSN that points to a dataset? It just creates empty DSN, there's no option to point it to specific database Same goes for User DSN and File DSN. B

I need to find a way to export records, one at a time, saving each record with a different filename, automating the process with a script. What I have written so far stops with the dialog box waiting for the filename. I am generating filenames within a special field - I want to copy the contents of this field and paste into the dialog box (automatically) and (automatically) hit return, and continue on with the script. (The actual problem: I need to export certain records once a month to an accounting database(proprietary). The database programmers have written an "application program interface" (API) that will always scan a certain directory. When the API se…

I export FileMaker data, including text box data, to a SQL database. The data looks fine in FileMaker, but when it is imported into SQL, carriage returns are displayed with a square character. Has anyone else experienced this and do you know how to prevent it?

here's the deal, we have an excel file that has one column of store numbers, and a second column of various numbers... lets say for ease sake they have 5 stores and 10 numbers. so the excel sheet looks like this: STORE -- number a -- 3 b -- 4 c -- 1 d -- 6 e -- 2 -- 5 -- 9 -- 7 -- 10 -- 8 what they want is store A to get each number (A3, A4, A1, etc) then store B to get the same numbers, then store c, d, and e... How in the world can i do this easily? If it was really on 5 stores and 10 numbers it'd be a breaze but it's 500 stores and 1500 numbers! Can i script this somehow? the final file has to be a text database w…

When I import a comma-delimited text file which does not have the same field names as my fmp db, I must order the fields in the destination file to match the order in the source file. Is there a way to assign a name to this order and place it on the "View by" list? Once, when I imported an update to my destination file, the "last order" view had changed inexplicably, and I again had to re-order the fields, which are extensive. I would like to have an order saved by a name I would assign, so that if the "last order" does change again, I can go to the "view by" list and choose my own named order. Does the "custom import order" choice offer such an option? Tha…

I'm an ex-Windows user considering migrating from Access. In FM is there a way to copy and paste data to an excel spreadsheet, or a sheet in a graphing program as one can in access? Or does one have to export data to a file and import it/open it in excel? Many thanks.

Hi, Looking for some help-I have some large text files that have more than the Excel limited 65000 lines in them. The records use space to differentiate between the columns (9 colums in total-see below).I want to use FP to import them but I find I have to break them up, use excel to convert them to .csv and then import them. Is there anyway that I can import these files directly for onward use within FP? Attached is a sample Thanks in advance Sandy example of text.txt

I posted this in the PDF section of the forum and have not received any response. I can import the file path and name of a PDF in from a folder on OS X, on Win machines I cannot make this happen. Any ideas or help would be appreciated. Dean

I'm trying to put together a phone directory in Word using a contact database with a related phone database. Originally, I was using a flat Excel file that I could do a merge off of. With the new relational contact database I'm ending up with export files that aren't set up correctly to merge (Single records take up several rows) To get around this, I wrote a script to take the contacts names and all the related phone info and put it into a singal field/record, formatted with the proper spacing and then I export that. This works great except I have to use spaces to seperate data of different legnths. Is it possible to use/add tabs in a filemaker text field/script to get a…

Does anyone know how to export Filmaker data into LDIF or vCard (.vcf) format? All ideas appreciated. I am trying to export a FMP contact file into Apple's OSX Address Book program. Note: LDIF is not the same as the DIF format (as far as I can ascertain). Many thanks,

I am trying to import an Excel file with a list of email addresses into a Filemaker field called "Email Addresses". I also want to "update matching records" and "add new records". However, Filemaker only allows me to define the field as a field to IMPORT or a field to MATCH...but not both. How do I do this when the only field I want to import is also the matching field? Thanks!

I want to move data from FMPro on a Mac to FMPro6 on Windows. The first time I tried to copy the Mac file, I found myself creating a "Read Only" copy. Is there a simple way of copying a Mac FMPro file, exporting it to my Windows machine and then merging it with existing data files in Windows FMPro6?

Hello Guys, Im producing a multiuser database, that's going to be used in a workgroup environment. I've produced an CSV export file, which gives me access to the records in FileMaker in another format. My dilemma is, I want to export the data in a particular folder, hence I will have to use a pathname. Can this be done natively in FileMaker or do I have to use a plugin? (which im desperately trying to avoid-as im working on a shoestring budget!) Thanks Jalz

We have a company database we run on Filemaker Server. I would like to create some custom layouts (previews) on my laptop (standalone) and import them back into the server database. Right now the only way I can update the layouts is to work directly on server version or copy the standalone file over the server file and lose the data. Is there any way to import layouts (previews) without disturbing the data?

I'm wondering if anyone has a script or an AppleScript that would allow me to import the name of every file in a set of folders into the database. I need to get the folder name and the file name within the folder. Any suggestions are appreciatied. Thanks.

If you looked at my last post in here called "brain fart" you will see that i had problems with the layout of a file i am importing. i finally got it to the right layout. UR|100000 AA|Grisham, John TI|The Rainmaker CN|Fine MT|Fiction now my problem is importing the fields into the correct fields in FM. The fields in my file are titled fortunatley UR = sku AA= Author TI = Title etc... The problem i have is sometimes it is missing the author or, one field is for keywords, and sometimes it has like 10 keywords so it will look like this... UR|sku AA|author TI|title KE|cars KE|racing KE|tires PP|Publisher i thought m…

I searched the posts but I it didn't seem anyone had the exact same problem as me. Here it is : I have a script that imports data from the current found count in another Filemaker database that sits on another server. The thing that happens, is that it looses the path everytime I import. So every time I want to import data, I have to go to my import scriptstep and browse to the file I want to import from. But when I look at the import script step before I "repoint" the file, the IP address is still there...(??), but it doesn't import at all and it doesn't show me any error messages... After I repoint the database I want to import from, the extension of the file shows…

For my jewelry business I need to send my clients a picture and price information for various pieces. Each record contains a jpeg photo, text in various forms with information, a logo etc. I'd like to be able to output a record as a .pdf file so as to send it as an attachment to an email, which they can then print. Plugin? Script? Thanks

I imported some records containing dates and they appear exactly 100 years older than in the original file, which is just a text file. The original data was in another FileMaker database on a PC, but I was accessing it over the network from a Mac. I exported it, manipulated in Excel, then saved as text and reimported. Later I redid it all on the PC but still had the problem. The data looks fine when imported into Excel, and the date field appears as 12/31/2001, etc. - already formatted in the text file like it was in the original FM file before exporting. What's happening?

How can I export data from a filemaker database into a safari web form? I am using fm 5.5 on mac osx. Thanks Jchryss

Is it better to export or import? I have a file that imports some records and after I leave, the records are deleted so that the same records are not entered 2 times. How do you overwrite records when new info is recorded, because it always imports a new record everytime I get into that file?

OK, first I thought I was just crazy. But it happened again... I have a file called Invoice Parts. I make a clone, do some tweaking (adding fields, changing layouts, etc). I even delete a couple of fields. I do not change the names of any existing fields. Now, from Invoice Parts Clone, I import records, select Matching Names, but when I look through the list, there are a number of fields that should be lined up but don't. In fact, several of them. I actually highlighted one, rechose matching names, and it didn't move! Of course, I don't expect data to go into any newly created fields, or go from from any deleted fields. But the one's that aren't lining up …

I want to create a template in fmp 6 that has a unique ID record number and is able to be emailed to someone that doesnt have filemaker so that they can fill it out and email it back to me and hopefully convert it back to filemaker format. I want to use MS Word but Im confused on this whole process. I actually dont know anything about this for the most part other than where to perform the comands to do it. But I have no idea what commands to use to achieve this. So if anyone responds would you mind given plenty of detail on the whole process. I really appreciate any help anyone can offer. Sorry if Im too vague, Thank you, Josh

I'm having trouble replacing an export file when I bind my solution. I path the file, set the script (export, no dialog and specify the file)and it works fine. The file is replaced with the current found set. However, as soon as I bind the solution, it no longer works. I get an error message when I try to use the button that say it "Cannot create file GenRef" in the specified location. It suggests that I "rename the file, turn off write protection or select a different location". Any ideas? Thanks

Can anybody help me before I get frustrated with FMP. Is it possible to get a data from record one if I am on record two? If so, how? I need a data from the first record in a calculation field of the second record. Thanks for any help you can spare to me.

This mostly concerns a single-user, relational db that is distributed using Filemaker developer. There are 2 files in the solution that need to be exported to tab files on the user's desktop. The problem I am having is getting the files to consistently save to the desktop on NT/2000/XP systems, where the desktop path is based on the username (the windows username, not the filenamer one...). On these OSes, even if I set it up to export to my desktop and save the export order, when I move to a different PC, or even move the .fp5 files around on my computer, the script won't work. It either exports to the folder the filemaker files are in, or it saves to 1 directory …

I'd love to get clarity on some irritating issues (inconsistencies/bugs) with Filemaker's handling of imports/exports: 1) I have a script that saves an export to C:Mergemerge.mer (using specify file in the export script) - and it sometimes fails to export to that location, choosing, instead, the Filemaker Pro directory. The solution is hosted by FMS 5.5 and Win2000, and all workstations are Win2000, running FMP 6 with recent updates. It will sometimes fail on one workstation but will work just fine on another! I'm sure this has to do with the lazy way Filemaker records an export path - does anyone know exactly how it does this and how to avoid it failing? 2) …

I am trying to import an excel spreadsheet into a filemaker database that has several related database fields in portals, such as phones, products and upc numbers. I can import all the data that goes directly into the main database but I have not figured out how to import the data that goes into the portal fields. Anyone out there that can help? Please.

I have an Excel spreadsheet that has 186 fields (columns). I need to make it into a FM database (i'm using 5.5v2), I have searched this forum and the manuals, but cannot find a definitive answer as to whether or not FM can automatically define fields on an import from an Excel spreadsheet based on the sheet's header row. The closest thing I've found so far, is how to import a spreadsheet and have FM create field definitions F1, F2,.... etc, but that doesn't really solve my problem, because I'd still have to go in and rename the definitions anyway. I hope this isn't a redundant topic that I'm bringing up. I did a search but couldn't find anything. Thanks for …

HELP NEEDED! Working evironment: PC-windows I'm trying to export records from FMP-4.0 and because there are Greek characters (using, Arial Greek TT Font) in fields and text boxes everything looks very wrong in the exported file! I've tried other fonts, but nothing...: I also tried something that SHOULD work. I opened the FMP-4.0 file from FMP-6.0 and it opens fine, but once again all the Greek characters are wrong! I'm desperate! What is there possibly I could do? Something anybody can think? ASCII conversion or something? (p.s. English characters look fine in all cases) See attachment picture for example. Please help!

I have a database that I am importing information in from an excel spreadsheet. When I designed the database (due to my inexperience) I put in a bunch of drop down menus. For instance, products and their UPC numbers. I am now trying to import the data but can't get it into the fields that have drop down menus. Is there a way to do this or am I going to have to put the data in by hand?

HELP NEEDED! Working evironment: PC-windows I'm trying to export records from FMP-4.0 and because there are Greek characters (using, Arial Greek TT Font) in fields and text boxes everything looks very wrong in the exported file! I've tried other fonts, but nothing...: I also tried something that SHOULD work. I opened the FMP-4.0 file from FMP-6.0 and it opens fine, but once again all the Greek characters are wrong! I'm desperate! What is there possibly I could do? Something anybody can think? ASCII conversion or something? (p.s. English characters look fine in all cases) Please help!

I use windows 2000 and filemaker 5.5 I would like to know if someone knows how do I export records from filemaker to a txt file (this txt file could be excel, for example) and I would like to choose the columns names. For example: I have a filemaker file with vehicle data. The fields I would like to export are called: VIN, date, _c24closed, _c48closed, _cOpen When I export records from these fields and when I open using excel the column names are the same as in filemaker. The problem is that I would like to change the column name the the TXT file. Does someone know how to do it using filemaker , or is there a plug-in I could use to change the column name when expo…

I have built a database that uses Troi File to automatically import entire folders of images and text files. I would also like to be able to automatically import video and sound files (Quicktime, .wav, .mpg, etc.). Using the standard FM Quicktime command, I can import one at a time, requiring the user to select each file, but I would like to simply have the user select a folder, then let the script handle importing all the files in the folder. All help gratefully accepted.