Importing & Exporting

I have an Excel file with Personal Contact Info I would like to import into my Filemaker database. However, in Filemaker, the Personal info (e.g. First Name, Last Name, etc) is stored separately from the Addresses, Phone, Email records. The tables are related via a unique identifier. Whenever I try to import the data, I don't see an option to map the fields to different tables. It only lets me select the table in the current view. Does anyone know how to do what I'm trying to achieve? Thanks!

I want to have attachments in the document. Perhaps a link to the particular attachment. The attachment (.doc, .pdf etc) would remain intact and be related to a record. I have FM8 but I was told this function might be available in FM10?

Hello all and thank you in advance... I am using FM 9.0 on Mac OSX. I have a database that contains a table "members." Each member on this table belongs to a group with a group name and group number. When I create a new member, and select the group number, everything works fine. When I import from XL, sicne there is no group number (or name) field on the spreadsheet, it doesnt import (makes sense). How do I get FM to assign a group number to that batch of contacts--there will be only one group number for each batch of contacts imported via an XL spreadsheet? I hope I have made myself clear. Thank you again!

I'm transfering records from an external data source to an existing table in my file.. It's been working just fine in fmpa9v3 however recently I upgraded to 10 and it's no longer working. I export just fine, but when I go to import and go through the regular procedures my results read: Import Records Summary: Total Records added/updated 1 Total Records skipped due to errors: 1 Total Fields skipped due to errors: 0 Table created: I see that the record was skipped due to an error but no error message shows up anywhere. I'm accessing a remote database that's hosted on the FMS10A. I've attempted to import it to same database but on my loc…

I can use "Import Records- Folders" to get a record of each pdf file on a volume when doing this from a mac, but the same process fails when doing it from windows. Does anybody know if this is a bug or just isn't supported on windows? Thanks, John

Hi there, I have several fields that contain return delimited values. Currently, when I export to Excel the values show up delimited by returns (as would be expected). I would like the values in the list to be separated by commas instead. Is there a way to do this? Thanks for you help.

I would like to speak with anyone who is using (or thinking of using) Filemaker to import or export data in RDF, SKOS, OAI, OWL, or other semantic web formats. We've taken some baby steps, but I would like to see what others are doing and possibly find some tools that will help.

Hi, I'm setting up FM to for use with my online store. I can download individual sales records from my shopping cart (mal's e-commerce) into a .csv file which can then be easily imported into FM. It gives me all the customer info and product info, but each item in the cart is given a sequential number so for the first product I get product 1, quantity 1, price 1, amount 1. The second product is product 2, quantity 2, price 2, amount 2, and so forth. What I want to be able to do is count how many of each items have been sold (and eventually subtract these off my inventory) but it seems to do this I need to somehow convert each sales (invoice) record to an indi…

Not sure where to put this question. It does relate to getting data into filemaker so I'll start here. I have a database that makes extensive use of graphics. For file size reasons I am thinking the images should inserted as a reference rather than embedded. My question is how to keep the referenced filename paths intact. If I keep the database in the same folder as the images, but move the folder from hard-drive to portable pin drive (or elsewhere) will the relative addresses stay the same or will the database be unable to find the referenced images?

I am trying to find a way to parse out a part of a field that contains a ref files location on an HD and export the result. Example: I have 10 container fields per entry that have QT refs. I have a field for each container field that, by a calc, shows me the location of the container field file. e.g. moviemac:/OLD/WORK/lowden/film.mov I am looking for way to parse out the last folder & file info ... /lowden/film.mov for each container in each entry & copy the info into 10 new fields that I will call Parsed_address & through 10. I presume that on the proviso that the parsing works, I can then export the resulting "/folder/file" ad…

I have a database on FM Server 9 with FMP 10 where filemaker hung when two users tried to import (using a scripted import) at the same time. It was not simultaneous but within seconds of each other. I have never experienced this problem before and can't find anything in the Knowledge Base. guess I never though about this being an issue since they are in two different sessions. Is there something I don't know about FMP 10? Am I missing something?

Hi, How I shall be able to move all my filemaker database records (Comprising of container fields storing images directly and not stored as reference) to Excel sheet I tried creating excel using export field contents and export records and save as excel script step to do that but what I found is,text showing image file name or path is rather than the image itself.

Hi. I apologize in advance for lack of skill level with FM-pro. I have a 8.0v2 Filemaker pro client that is running on OS X 10.3.9 I need to export the entire schema/table definitions from this system. I did some cursory searches on google and in this particular forum and didn't see what I need. Is this something simple that can be elaborated on for me or to provide an FAQ for this? i will be handing this off to a developer so I just need to be pointed to the steps. Thanks. Jonathan

Is it possible to set a script to export a record based on fields in a table to an existing .xls file with previous records? That way when inventory adjustments are made it wont update previous records. I don't want multiple .xls files. I want the specified fields to go to one.xls file and list in rows within the specified fields the data contained in them. So once I'm done creating a record from drops downs and calculations I can send the info to my .xls file in rows of records. Hope that makes sense. I guess what im trying to find out is how to export a single record to a xls file

Hi I'm very new to the Filmmaker. I have a version 8.5 I am trying to export data to excel,so I can run a macro. so I need the data from the repetitions to be copied into separate tabs on excel. but the multiple data in the repetitions show up in one single tab. is there anyway I can give them separate the output? thanks

I am using FMP 6 for Windows. I am trying to use container fields to set of an "Important Receipts" data base. It's been a while since I developed a new FMP DB but I was at one time very active in this process. A few questions: 1.) What is the best process to keep a acanned document to is't smallest size? 2.) I tried scanning to a picture file, then converting it to a PDF. The PDF is quite a bit smller in size but FMP doesn't recognized it as an object or image and won't allow me to put it into the container field. What is my best option here. 3.) Is ther a way to scan a document directly into the FMP container field? Thanks, Don

Sorry for my ignorance and (somewhat) obvious inexperience when it concerns working with Filemaker, but is it possible to automatically extract the metadata info (author, creator, title, etc) from hundreds of pdf files into filemaker fields?

Hey, Not sure if this is the right forum or not, but I was curious if anyone has put together a "dynamic" SQL statement using a global. In other words something like, SELECT * FROM teachers WHERE teacherid=^(gAccountID) I know my syntax is not correct, but I am too lazy to get to open the DB to find the correct syntax. Thanks for any help. B

Is it possible to access a DICOM file "images ou video" that is stored with OSIRIX, using a filemaker database?

I am confounded as to how one might view container data when a picture has been stored in it. Is it true you have to export it to get a file path and then show it in a web viewer? Is there a way to show images stored in Filemaker without plug ins? I am aware that I can display the container with a thumbnail of its contents. but I would like the user to be able to click on it and obtain a larger view. Is this possible? Thanks for reading these questions!

What is the simplest method to import user information (propterties/attributes) stored in Active Directory into Filemaker 9/10?

Hi all, i was wondering if it is possible to automate the export with FMP5.0. i want to export 3 fields fully automated with one click on a button. i have the export button but it then the end user has to specify which fields they want to export. and because it can be very confusing for the users to find the right fields i want this automated. is this possible, if yes HOW ? and also is it possible to do an OR search in a text box. if i do "test" "test1" then it is an AND search but i need a function that searches OR "test" OR "test1" for example. hope to see a response soon thanks

I need help getting data exported into a comma separated text format. Have tried exporting to EXCEL and then doing a secondary export, but I have a specific layout that must be followed and I can't get it right...HELP!!

Hi, I copied my original dbs for testing and learning purposes. I created a new layout and field names that I now wish to import back into my original database. I am not interested in merging or importing records, just layout and field names (value lists..sry not up to speed with the terminology yet) 1. I can copy the layout (copy and paste), but the field names do not exist in my original dbs...therefore they remain blank. Also tried Filemanagedatabasetableimport...but that yielded the same result. 2. I do not want to recreate every single field name again (it took a while the first time around). 3. I have used the search function on the site and referre…

Hi I have created a runtime solution that works just fine. When you export the data, you can delete everything in the runtime and export that data back in again and everything is as it was. However, when another user of the same runtime on a different machine tries to import the same file, the data imports inaccurately and is unusable. This happens regardless of the file type, tab, csv etc. Anybody know what might be causing this?

Hi All, Was wondering if anyone knew how to automatically generate bookmarks in a PDF. We have a list of 1000 records summary when sorted by "Class". I'd love it if it were possible to create bookmarks for each class. any ideas? thx, d

Can anyone explain to me why FileMaker polutes text exports (specifically Export Field Contents on a text field)? For example... If I simply copy and paste text from an FM text field into a text editor and view in hex, I get this: But when I export the same field contents I get this: This is playing havoc with my attempts to generate ICS calendar fields that can be picked up and imported by Outlook. Outlook is not happy with all the hidden ascii junk (00 separators between all characters and the FF FE header characters at the beginning of the file. Anyone encounter this before and have a quick solution? Thanks all. David Wolfe F…

Hi, I'm having some real difficulty and I just don't understand what's going on. I have a set of files which were upgraded to .fm7 a couple of years back. I am trying to export from one table and import into another. Nothing I do will make it work. I can import the records into a 'clean' new file. When I try to import into my legacy file, I get an error for each record. 85/85. No log is created. I have ensured that the priveleges are ok. At least ... the file has a 'locked' user and an Admin. I login the Admin user before trying to import. I'm using FM 10advanced. I've also tried with FM9advanced. Neither work. Any help will…

I have a system which requires me to export packing slips in an unusual way. Each shipment is a row, with the last "x" number of columns representing the packages (or line items) in the packing slip. For example, if I am shipping three items, I will have columns for job number, address, csz and then three additional columns, one for each item. I may have two items or I may have 20 items. Currently, I control this by adding and removing fields from the export database so that each item gets its own column. The actual data is the number of items going to each location. This works great if I am the one creating each shipment, but I would like to be able to take a vacat…

Hi. If we import any file in container field, can we store on path in different fields like Field A should store drive, Field B should store DirectoryA, Field C should store DirectoryB etc. Thanks in advance for your kind help.... Regards, Tusif

I get these kinds of grayed out fields in "Field Mapping" in "Import Records" sometimes, what are those? Direct link: http://img9.imageshack.us/img9/4281/ghostfields.jpg

Once again I don't know where to put this question. It's somewhat related to getting data out of filemaker. My question is: [color:red]What happens to a file when you save a copy as "compacted copy (smaller)" ? The most noticeable thing is size. The one I saved like this was about 75% the size of the original. Does this do anything for optimizing performance?

I have tried to follow the example Fenton Jones gave (http://www.fentonjones.com/Articles/10_Import_Dupes.html) for importing new records and avoiding duplicates, but the intermediate script does not make sense nor does it act as desired. I am trying to filter out duplicates in one set of temporary records in a .fp7 database for import into another .fp7 database. Fenton's instructions were as follows: Find All i.e. Show All Records in FMP 9 Go To Layout ["Concat Only"] layout with single concatenated field of First and Last Name only Copy All Records Go To Layout ["Concat g"] layout with global concatenated field Paste [select, No st…

I’ve got records in table “A” (488 fields) that I want to import into Table “A Archive” (488 fields) in the same file. Both tables have identical fieldnames in the same order. Actually, I created “A Archive” by duplicating (copy/paste) table “A” in manage database and renaming it. I just want to be able to dump the records from “A” into “A Archive”. Is there some magic that I need to do on the relationship graph or is there a trick to importing from “A” into “A Archive”? I haven’t been able to make it work. Also, I’m getting “” showing up in “A Archives” layout. Thanks for your help.

I wasn't sure where to put this question. It fell under the category of getting data out so here it is. I am having problems printing PDF's. I have a memo field that allows you to enter descriptive text after performing a sort. This text field helps quickly explain the differences from report to report. Sometimes the data in this text field shows up when the PDF is printed and sometimes it does not. This is completely random. For what it is worth, when I look at the folder that holds the PDFs sometimes the file size is listed as ZERO K. When I close and open the folder it shows back up as a 60K file, but still no memo in the field. Any ideas…

I imported my whole database from MySQL and everything works, except for the new clients I've added to the database. The new clients seem to have issues with the fields that deal with calculation. Any ideas?

I'm stuggling with how to approach the following situation. On the forums I've looked up moving summary data between tables and also looked at self-join tables and trying to use the Get(Summary) function. I have a table with detail information. whse - cust - prod - price - cost - count ny - fred - rock1 - 10 - 5 - 1 sf - wilma - rock1 - 12 - 4 - 1 la - barney - rock2 8 - 2 - 1 ny - wilma - rock2 9 - 2 - 1 ny - barney - rock1 9 - 3 - 1 la - betty - rock2 10 - 3 - 1 I'd like to move the summary of some o…

Hi all, I'm importing phone numbers from Excel but the Excel data does not show the initial zero on numbers. The data is to be imported in two fields. The first field is for cell/mobile phones and a zero should appear in all records. The second field is for landline numbers. Some of these numbers have a zero as part of an area code prefix, while other records have the cell/mobile number entered in this field. However, most records do not need an initial zero. I don't want to make the changes manually as it is over 4000 records being imported. Should this be resolved in Filemaker or Excel? How do I resolve this in either program, to add a zero to t…

Good morning. I have an Excel file with book information. I have ISBN numbers with leading zeros. I have the column configured as custom/number with 10 spaces. The leading zeros show up in Excel. When I import into Filemaker 10 the leading zeros are left off. Can anyone help so that Filemaker displays the leading zeros? I have the field set up as a text field since some numbers have an X at the end. Thank you for your help.

Hi there, we are looking for a Filemaker Pro plug in to import text files that has tab and space decimeter. all the files are very messy and need a tool to import them into Filemaker. Attached "CSerSum.txt" example of text file that we need to import. Any plug-inScript or tool out there to help us with this? Thanks in advance, A CSerSum.txt

Hi all, In my student database, I wish to regularly add new students but also update the current student records. As I import the Excel file which contains the relevant information, I choose the option 'update matching records in found set' and I tick 'Add remaining data as new records'. In the field mapping section, I choose the Student ID field (which is a unique field) as =Match records based on this field These options should all be correct for the purpose of updating existing records and adding any new records. However, instead, this import adds new records each time. So in effect, I end up with a duplicate record of existing records. …

Can you have (Table 1)fields grab info from table 2 that contains records from an imported .xls file and delete those records once they are gathered WITHOUT deleting the fields in table 1. If so how? If not then how would I updated the imported file info without destroying the records on table 1? Can I trick it by getting the data thru some sort of relationship and calculation? Once the records are deleted the info is deleted which means when I update the records with new info the old records will now use the new info and eliminate the point of keeping records... Please help.

Strangely enough, the FileMaker website is down this morning and I couldn't find anything here about the subject, so hopefully one of you wisened folk can help me with this. Simply put, I want to import field data from a .pdf, but am clueless when it comes to coding an XSLT script used to import XML data in FM's "Use XSL Style Sheet" windoid...let alone what its file extension should be. Since we're only talking about a few fields, here, I imagine the script shouldn't be too complicated to code, but having no XSLT experience I may be talking out of my hat...or another region. :S TIA for your help!

I've got a database with hundreds of jpegs and pdfs. In an effort to keep the size of the db down, I decided to only have references to them. Is there anything in FM that I can do to the db, as far as moving folders around, or renaming them, that won't cause them to "disappear." I keep the files and the db on a drive networked to mine, and other computers. Soon we are changing drives and I fear the change will create a problem. Is there a workaround for this issue?

Hi all, I have been searching on the internet on how to alphabetize the "Source Fields" during the import process in the "Import Field Mapping" step. In this step you can choose a lot of options like alphabetize the "Target Fields" alphabetically, last import order, and other options for the "Target Fields", but none for the "Sources Fields". It would help a lot if we can alphabetize the "Source Fields" as we have a lot fields in a table. So far, I could not find anything yet on how to do this or is it even possible? My boss told me she saw they alphabetizes the "Source Fields" in some convention. Does anybody know if it is possible to alphabetize the "Sou…

Hi there I hope someone can help with this. We have bought a database system for our company (FMPro based) and this is currently being customised for us. One of the problems we have encountered is that we need to produce a registration form (pre-set form) which contains database information (course name, date, etc) which is auto loaded into the page. This is then auto emailed to the client. My problem is that our consultant insists that FileMaker can only produce pdf format and we have some clients that want to complete the form electronically. Is there any way that FM can create such an automated form that is not a pdf? Something like a Word doc?

After a long and frustrating afternoon of trying to unravel what FileMaker was doing to my imported text fields, Iâ��ve arrived at a solution that Iâ��d like to share. This involves text files imported using the Import Folder option. And from what I can tell, this applies to Windows only. After importing, all text paragraphs had one or two extra blank lines appended to them. I tried the various â��usualâ�� methods for removing extra carriage returns from the end of text fields. None of them worked -- because what FileMaker had done (for reasons known only to them) was add a combination Carriage Return + Line Feed every time it saw a Carriage Return in the import …

This is driving me crazy because I know I've done this before a couple of times... How would I use a relationship including a field calculation of Get ( AccountName ) equal to a field where a user's name is stored, to restrict the user to see only their records? I already know about the alternative of using a privilege set restriction, but that's just plain ugly because the user can see other records, but with a "no access" message, at least until the initial find is executed. Other than using a portal (which doesn't give us much freedom for reporting), I seem to remember using an intermediary table somehow, and also there was the issue of having no records t…

I was wondering if I am able to to import via script specific data in a .xls file that is classified by tabs IF the header name is unique to that column. So instead of grouping together all "ID_numbers" I would have "ID_numbers1", "ID_numbers2" and so on but using names that relate to what im doing. Or does it do this no matter what tab the data is located on. I have 17 Tabs of specific inventory data each tab being different but all in one file. Anyone know?

Hello, I'm creating a script that checks if a file exists. - Both "Import Records" and "Insert File" works. - If the file exists then Get(LastError) returns 0... if the file doesn't exist it returns something else than 0. However, "Import Records" always show an "Import Dialog" and "Insert Text" shows a dialog if it can't find the file. Is there anyway to skip these dialogs? Or some kind of workaround? Or maybe you have any tips on how I could build my script different? Thanks, any help is really appreciated *Edit* Noticed now that "Import Records" actually have a "Skip Dialog"-checkbox, so problem solved!

Hi, I am using Fm 8.5 advanced and troi file plugin 3.6 I have images in my FM database and I want to create a folder on the remote server and export related images to that folder. I am able to create a folder on the remote server, but when I export the field contents to that remote server path, its not doing it. If I use the exact path got by findfolder, it does something without giving the error but I dot find the file in there or anywhere, when I change the file path as remoteservername/wwwroot/...path, it gives the error as to file not found or Not enough disk change disk. but there is enough space in there and I have access to that folder. I am…

I'm trying to write a universal script (layout independent) for basic container field management: insert file, remove file, and open the file. Let's look at the Export of the file in the container field to open it. FileMaker wants me to "hard code" the container field, by selecting it in the dialog box. Is there a way around this?? I'm looking at all the tools available: object names, variables, but I just doesn't seem to add up. Even the new "Set Field by Name" function doesn't help: it takes me to the container field, but the export script step still returns error 102. What am I missing? Or am I attempting something impossible? I would be a huge time save…

Hi, I am probably posting this completely off topic, but I gotta confess I am really confused with this layout. I want to purchase Filemaker 10. However, I am not entirely sure wether I should get the version with 5 licenses. I am the only developer in house (a total beginner), and am creating a small database for shipping & logitics. My question is, since I am the onloy one developing the database, do I just need the one license, or everyone who is going to utilize the database needs one ( the remaining users are in separate computers accross the network). I appreciate your input, and sorry for posting off topic. krust

Hi I want to import an excel that has rows which should be columns - any way to correct this?

For some time now I have "automated" client updates of files through these steps. First run a script that asks the user to "open" their old file. The old file is then imported into a container field and a related calculation field returns the path that is then set to a variable ($import). The script then steps through layouts deleting records and importing records from the old file using $import as the file path. This works fine as long as I've previously "trained" the script using explicit file paths. I then replace the explicit paths with $import. I have a problem where this sometimes does not work for one of the import steps and I can't work out the…

Currently I import my inventory via .xls and use that to create report records based on what I use during my production. My question is how do I update the inventory without changing records made the previous day. For some reason it updates all the qty fields with the updated info and once a record is created i want to eliminate the updating. How is this done? Day 1 Start Qty 1000 Used 200 Day 2 Start Qty is 800 but once the inventory is updated it reverts Day one start qty 800 and throws everything off.

Hello, I'm taking baby steps learning to import a xml data file and a xslt style sheet. I've followed the examples provided with FileMaker and read http://www.goya.com.au/node/105, I am getting close, but I have yet to see data in FileMaker... I don't get error messages, the import recognises the stylesheet, I can match the fields, the correct number of records gets created but they are empty... I am hoping it is something obvious (or an error a newbie would likely make) Any pointers?

Hi all. Is it possible to create a script to import multiple Excel files within a specific directory? All the files will contain the same fields and mapping. The catch is that the names and number of files may change. Ideally i would like a script that can point to a location and will import each file in that location, regardless of their names or how many there are. Thanks for any help.

Would I need a script to shadow fields from an excel file located on a local drive. I don't want to import the file but simply shadow specific fields from an existing .xls file on a local drive. The .xls file is updated each morning with inventory stock and want file maker to pull from the available file each day.

Hi @all, I enlarge my software with filemaker databases. I'm programming with borland delphi. In this case I connect to the database via an ODBC driver. My fields in the FM database are mostly text types. But in my Application the fields are shown as memo fields. Are there any suggestions why and how to get the content of the fields? thanks,moony

First off, I am new to Filemaker. I am using FM Pro 8. I have been tasked with creating an automated backup of multiple tables. What I have done is created duplicates of the tables (without our complicated layouts) and have created a script to import the data I want to backup into these backup tables. What remains is exporting these tables into a single .fp7 file. If I export one at a time to the same file, it overwrites the last export and I have been unsuccessful in finding a way to export all the tables at one time. What am I missing?

so, i installed the automator actions so that i could use them with ottomate actions to automatically fill in web forms with data that is in my fmp database. works like a charm...sadly, at the end of my automator application, i have it send an email with some of the data that i have pulled from the database. now, i've done this many times in the past by just setting a variable of whatever information i'm pulling and then adding the uuid into the email action (ex. $(E4689E65-7C1F-4391-B7C9-C7D8459CAF91) this would be the uuid of one of the variables.) but when i set the variables from the filemaker record, it comes up like this (this is an random password generator th…

I'm an old hand at FM4,5, and 6, but our office just recently upgraded to FM9. Most things are working just fine, but the new importing dialogue box is driving me crazy. On our old system, I had some files that I'd run on a processing machine. The files would launch, import records from our hosted databases, then I'd run a script to process those records, run SQL commands to update a mysql database, then the records would delete. The processing machine was unattended, and the databases would launch on a scheduler, and close themselves out when they were done via FM scripts. Now that we're on FM9, I can't get away from the username/password prompt whenever I t…

I am new to this so be very clear in describing what direction I should go. What I have is a database for a landscape company. One of the layouts is for "Products". To keep it simple, it has an item #, description, size, price, SKU# and supplier name. One of my suppliers sends me a excel spreadsheet with the SKU#, name, price and size for the plants available that year. It has about 2500 plants on it. In the spring I need to update my prices for the next year. I need to import the new prices, identify the new products, and identify the products that are not available that year. Sometimes they may not have that plant that year but will have it the next year. I identi…

I am trying to import my table into mysql. The problem is I am using " for the enclosed deliminator. The problem is my data has " in it. Thus, I am getting an errors. [color:red]How can I export a table using a special character(eg. |) as the terminator and ~ as the fields enclosed. [color:green]Thus it would look something like this: ~field1~|~field2~|~field3~ The only way I can think of doing this is to use a calculation. There must be a better way.

Hi all, I've just recently installed the Actual ODBC database server on my FM10 server system and I'm wishing to use MySQL Data. I can easilly import and specify the relationships between the FM table and the MySQL table however what I seem to be having a problem with is if records are added to the MySQL database, FM won't automatically update its records? Is there a way to automatically sync the FM database to the MySQL database without having to re-import the data manually everytime I use FM? Cheers, Mike

Hi, I'm exporting data into a .tab file. For some reason, number fields don't get exported correctly, for example 3800 becomes 38 00, 170 becomes 1 70 etc. (there is additional space after hundreds) There is no extra output formatting selected in the output format options window. Any ideas what might be causing this? JariV

Hi guys, I am a newbie to Filemaker and need your help. Ok so here is my problem: I have one contact database and now i want to have a second seperate contact database. what I want is that the second database gets specific contacts from the first database. For example: I want in the second database only the contacts that are in my hometown. The reason I want to do this I need another contact database with the contact but want to include another informations regarding them, that I don't want to have in the first one. I hope I could explain my self good. I am sorry for my bad english. Thank you very much in advance. Cheers, Martin.

Hello everyone, New to this forum. I'm a photographer with a mailing list created in FMPro6 and need to be more organized when I call people so I will know whom I've called, when and what I said I'd do. The "Contact Management" part of FM seems appropriate but right now it's of course empty, no records. Can I take the records I've already created in my FM mailing list and presto chango make them all into contact management notecards? Thank you all and if you have any photography questions you want to separately email me I'll be happy to answer.

I have an old Filemaker Pro 2 file that I need to extract the data from so I can import it into a new Filemaker Pro 9 file. Problem is that my Mac won’t open the Filemaker 2 file because the operating system has changed since I last used it. It looks to me (but I might be wrong?) as though I need to find somebody with a Mac running Classic who can open the FP2 file, export the data to an ASCI file (I think??) that I can then import into Filemaker 9. The FP2 file is 3.1MB in size. I also have a copy of the FP2 application (1MB). I’ll happily pay anyone running Filemaker 2 (or possibly able to run my copy) to do this for me or if anybody has other ideas I’ll be k…

Hi, I'm having a problem getting FM10 to obey me when importing records. It seems to have a mind of it's own. I specify a Field Import Order so that fields from one FP7 file get placed into the correct fields into the other (current) FP7 file. XName > YName XCity > YCity XPrice > MyPrice XSnarf - XFloot - You'd think this would be pretty straightforward, basic, classic stuff, but no. Filemaker decides to import something like this : XName > YName XCity > MyPrice XPrice > XSnarf > YCity XFloot - It doesn't seem to remember what I just specified. What must I do to make the import work as I want …

Okay, this is it. I've got data in a FMP 9 file that I want to get into a Word 2008 file. I've managed to create a .mer file and import that into Word '08, but can't get more than one record at a time to appear. The Word file is a booklet with linked text boxes. The idea is to fill these text boxes with the appropriate data, but, alas, no fill. I can preview the merged data, but only one file at a time appears in the text box. Does anyone know how to get the data to all appear in the same text box as opposed to each record appearing in a new doc, a in a mail merge? I realize that this may be more of a Word 2008 question, and apologize if I've wasted your ti…

I'm wondering if it is possible to duplicate an entire database? The company that I work for deals with paper sales in rolls and sheets. Right now we have everything in one database and I would like to copy it so that we can have a rolls database and a sheets database that can still talk to eachother. But they need to be seperate because there are 2 different locations working on them. So we do not want the roll guys to have to deal with anything sheets related and vice versa. But we have seperate databases tied into the big one we have now (i.e. our invoice database) that draws from both sides, so we want that to be able to work as usual. Any suggestions? P…

so here is the situation i am creating a POS cash register system and after each order is complete it exports to an excel template but unfortunately after it is done once i cannot export again i get an error message saying: "filename" could not be created on the disk. use a different name, make more room on the disk, unlock it or use a different disk. is it possible to export to an excel file more than once or would i need to make more than one excel file? thanks in advance to all who help me on this

Is it possible for a script on monday morning be able to export and email the records from a set range of dates each week in xls? I have to pull record reports each week and this would be very useful if possible. I know other programs have the capibility but not sure if FM is able to. IF So How? Thanks

I'm exporting a list of item numbers to a file. I'm sending the file to a web developer who's adding it to a web site. The web developer insists the list be a comma-separate file. I've wrote the script and done the export, but the web developer says there's an extra character is showing up in the export. I don't see it when opening the file in TextEdit (OS X Tiger). I've tried every English-language character set: Macintosh, Windows, ASCII, UTF-8, and UTF 16 and he says he's still getting the character which is showing as a single block. He says it has a hex value of "1d". Any ideas on how to get rid of this character?

I have a backup routine script that exports all records in each table to files in the FMP format. When I setup the script, in the "Specify File" dialogue box I used the extension ".bak" after my file name. FMP seems to be ok with this and imports just fine. I wonder if anyone knows if this we still be ok when I create a runtime. Any ideas? Thanks!

i am trying to export records via xml stylesheet but have no idea what im doing so could somebody show me somewhere i can learn how to create one thanks so much

Any suggestions on how to "convert" excel formulas to fm calculation fields? Even if it covered only less complex formulas it would be interesting, as a complement to the standard import of static data from excel. Third party plug-ins? Thank you.

Is there a way that one can print the import order showing on the screen without printing the screen. I have a very large database to deal with and when I import I have over a hundred fields to deal with. Just wondering if this option is available in Filemaker 6.0.

During the current development stage of my project, I need to delete all records from certain tables before re-importing data again. What confuses me is the incredibly slow speed to "delete all records." It seems to be deleting one record at a time, taking more than a second per 100 records deleted. I'm still waiting for 550,000 records to be deleted, before I can start importing again (this was already a "reduced data set" which excluded files containing another 1.5 to 2 million records of source data; for the next few cycles I'll use an even smaller set of source files). At this pace, it will take more than 6,000 seconds (100 minutes) just to delete all the…

Hey all, I'm building a new solution from scratch. My first step is importing an XML file that contains multiple tables in the same file. I have translated it to FMPXMLRESULT format with an XSLT. The problem I run into is trying to make the data go into multiple fields. To test if it is even possible, I made a dirt-simple test database with 2 tables of 2 fields each, with the tables related, and exported to XML. The resulting file includes fields from both related tables. When I reimported that same file back to the test DB, it still would only try to put the fields in one table. Is this even possible to do?

In one of Fenton's posts regarding exporting text using an XML style sheet, he said: I've now come upon a case where "mush is all together" is exactly what I need -- but I don't know style sheets at all. I've attached the one I'm currently using. Can someone give me a tip on how to modify it so that nothing is added between exported text fields. I need the resulting file to be one long text string. Thanks in advance for any help. XMLstyle.txt

Our naming standards work very well for us as developers, however its a problem when records are saved as excel files via a script. The first row of data are field our field names, which are not operator friendly. Does anyone have any suggestions for scripted excel saves with human friendly field names? We'd like to avoid a second set of export fields. Thanks for your thoughts.

ok, i have to figure out a way to export records from my database in a very specific format. this is the format it HAS to be in when it exports.... NOTE: quotes HAVE to export "FIELD1","","","","","","","","","","FIELD2","FIELD3","FIELD4",FIELD5,"FIELD6","FIELD7","","","FIELD8","FIELD9","","","FIELD10","","FIELD11","" each line in the csv that has to export will be a new record from the table. any help would be greatly appreciated.

Has anyone interfaced ACT's SQL data files with FM 8.5 or 9? We currently use ACT for our CRM. While not 100% of what we need, it does most of what we need. If we could interface the two it may bring it closer to 100%. Thanks, Don

Hi when i past a text from FM in french language into Open Office or microsoft Word, this one consider my text as english, even if my preferences are on French language in both. What can i do ?

HI I'm trying to move my records from fm6 to fm9 I’m trying to use .dif after import no errors but some of records didn’t import correctly wrong information in wrong fields or just empty records. Nr of records in fm9 after import is exactly the same as in fm 6. Any suggestions? aro

The export field contents script step requires a constant file name (as far as I can figure out). So if I wish to copy field contents to a variable file I first need to export the contents to a fixed file name and then I need to copy this fixed file name to the desired variable file name using Send Event with either the cmd /c method or a batch file routine. Has anyone figured out a more elegant solution to this problem? Or do versions later than 7 Developer allow the use of variable file names for field export?

Hello, I;m hoping someone out there can guide me on this...I have single digit numbers imported from an xls in a field, which I need to replace with a term in another field. The script I am using to substitute the number with the word doesn't work using he number, and I apparently need to convert the number to text. The conversion code I have found doesn't work when I try it (replacing the field name to my own). I get error messages. Does anyone have a simple way to change a number to text. Oh, the fields are all text fields. I did try using a calculation field for the huge code I found on this site, but to no avail. Thanks,

How do you import records from Excel or from another FMPRo database and rather than have the transfer initiate new records, it would populate empty fields within records. So if I have a database of teams and need to update scores from last weeks games, how do I ensure the scores go to the right teams? I realize this is relational, but how is the relationship established during an import? Do you have to import into a related table BEFORE importing into the target table? Someone mentioned a "join table" which I am unfamiliar with (maybe that's my missing link). Thank you!

Hi all, I am hoping that somebody has come across this problem before and can share your insights. Thanks. I am using FM Developer 6. I have a found set of student records and am printing transcript reports out to .pdf file. (One .pdf file per student transcript - prefect) My problem is that FM wants the user to manually input the file name each time it comes to the 'print' script step in my loop. Is there a way to pass a filename variable to the 'print dialog' box? I have over 12,000 student transcripts to print to .pdf and don't want to manually input the filename each time. Thanks again for any help :)

Long time MS Access user, short time FileMaker user. Doing my best to figure it out. But I've hit a wall. I have an MS Access database that contains data that the user needs to 'push' to a FileMaker Server database. Here is what I've done so far... 1. I've configured an ODBC connection (DataDirect 32-BIT SequeLink 5.5). 2. I've created an ODBC link within the MS Access DB that points to a table in my FileMaker Server DB. 3. I've created a query that identifies the MS Access records that need to be 'pushed' into my FileMaker Server DB. 4. I tested the query and it works fine as a 'Select' query (shows the appropriate records to be added). 5. I…

I need to send someone a sample of my database so I need to delete most of the 633 records but not all. Either that or export 20+ of them. Can anyone point me in the right direction? I am running FMP9

They said it couldn't be done, but I'm doing it...almost. The university accumulates graduate student applicant data in a Microsoft SQL Server database and I'm downloading my department's applicant data into a FilemakerPro solution via a standard ODBC connection. The text data comes in fine but the stored document files (applicant's resume, for example) are in a binary large object or BLOG field. I find I can import these into a FM container field but only if they are less than about 80 kB in size. If they are larger, I get only the first 80 kB which destroys the document. I assume I'm limited by the ODBC connection. Does anyone know where to fine tune the standard M…

I need to be able to do the following: 1. Click a button on a layut to locate an image file, which will be on a server 2. Save the pathname to the selected file in the database 3. Display the image on the layout and possibly in reports How do I accomplish these things? We are using Macs so can't use OLE. TIA Patsky

before I import i need to test whether a certain named file exist first? Thank you

I have a need to export fixed-length flat ascii text files from Filemaker. I do not know if there is a plug-in out there for this. But would like to know. Basically I need to be able to specify the characters per field when exporting. Not sure if Filemaker is currently adjusting each output field length to manage the longest value in the database. Any ideas? thank you

Hi, folks It seems like this should be a standard function, but I am at a loss. I will be importing books (key = ISBN number) into an existing database. I would like the import process to SKIP any book records (read: ISBNs) that already exist. Can someone tell me how (if) this will work? Many thanks

Hi, I just tried this from an earlier post: $filename = Get ( DesktopPath ) & FamilyPhotos::Photo & ".fp7" and set the export to $filename but it did nothing? I just dont understand variables enough and the stuff below did not work...Im lost again. I have created a small runtime which is supposed to export a file to the desktop as a .fp7 Well, that is how it is supposed to work anyway. I have tried to set the path to everything I can think of…the problem is that it will work just fine on my PC, but when my son attempts to use the runtime and export a file to his desktop he gets an error that the file “Photo.fp7 could not b…