Importing & Exporting

Generally I think FM is greatest thing since sliced bread......until... I have a file.dbf on a server used by server side appications. Needed to add some text to several records in one field. In this specific case; a "keyword" field for a search algo that uses the file. Downloaded the dbf file. No import function or open function. FM converts it to FM format; ok I'll go with that... I add my data to the desired field and records with Import|Match|update Made a tweak with the great built in Find/Replace function. Looked for Save As dbf NOT File Export as DBF Did this as unsorted and all fields in original table order. (can't remember if it wa…

Hey, Well im not the best FMP user and i think there may be around this but not sure. I'm setting up a huge database with over 3 million pictures. Now what im wondering is if you are able to import a folder of images into the one record if so how?. I know the option of importing a folder of images into new individual records but not the same one. Just wondering is there a way around putting each picture in individually cause that is just gonna take years. Thanks Nick.

HI, I've actually been using FM Pro since the 80's, but only in a limited way. never became a Jedi, so to speak. Anyway, its tax time, and I downloaded my csv file of all my Paypal purchases and income. Unfortunately, the brilliant minds at ebay (paypal's new owners) didn't put the "Paid" and "received" amounts in two different columns. What do they give me? One column of payments and receivables, the payments showing a "minus" to let me know that a payment was made. How nice. However, I uploaded this csv file into Filemaker 5.5 ( i guess i better upgrade cuz 5.5 wouldn't import a csv file). For my taxes, i'd like to show what is INCOME in this …

Hi everyone, I am building a database which will contain multiple .jpg or .bmp images for each record. I built two related tables. The first table is for the data entry part of the database, and the second table is for the images. The two tables are related by a serial number which is generated by Filemaker. Each record's images reside in their own folders. So I only need to import one folder per record. Is there a way to import the images directly into the related table and assign them the serial number so that they point to the record I created? When I use the import folder script, the imported images do not get linked to the original record. t…

I'm trying to import data stored as attributes in the xml file. The xml file also has data in it's elements too. I managed to figure out how to import the element data, but that approach doesn't work for the attribute data. Here's an example of the element data I'm attempting to get the highlighted data out of this file. The structure of the xml file is: ProfilesProfileUniqueID

Please Help. Is there a way to save a custom Import Map for use with the same fields? I can't seem to find any posts or help for such and I can't even find a script to do so. I cannot believe that FM8 would not have such a feature when Act...etc. has it? : Thanks for the assistance. Ben

Hi there all. I have a question. I set up a file with lookup fileds (just about all of them) to pull in information form three different files. I now want to find a way to use a script to import all matching data from all three files and do this every two weeks automatically. Is this possible? Thanks in advance.

Hi, A newbie here to the forum and to filemaker (so if this is in a faq somewhere please just point me in the right direction). I'm trying to do a scripted export of data into a CSV file, which works fine with the exception of the formatting of a numeric field. The help file for "export csv" says, "Quotation marks enclose all field values, except unformatted numbers."; but my output file has every field (even numeric ones) in quotes. Under File, Define, Database, the field tab has the variable listed as a number, I don't see a setting for unformatted. Can anyone help with how to get my number fields to go out in the csv file without the quotes? Thanks…

I am trying to import Ascii or Tab files into FM and I've found a way of doing it but I need all of you guys help to simplify my calculation because the calculation eats up 100% CPU usage as it gets deeper in breaking down the tab blocks. I have a text field which i named Souce Data and I've imported a line string of Ascii/tab that looks like this. S0128|2014816830004|HOME HARDWARE - TORONTO|||||2014817930001|ROB BLAKE|Z602W05584|20060221|SA...... Then I create a series of field that contain calculation. My first field (f1)Calculation looks like this Left(Source Data;Position(Source Data;"|";1;1)-1) Second field (f2) calculation Middle(…

I've been trying to implement an inventory export that has a user-entered delimiter text field on the end of each record. I placed the delimiter text in a global, but it shows up on the first record only. I would appreciate it if someone can explain why that is so -- and suggest another approach. (I certainly thought a global would work.) Thanks ExportProblem.fp7.ZIP

Hello, I'm a relative newbie to relational database design so my apologies in advance. I'm putting together a database to help me track my business expenses, all taken from my monthly CSV credit card data dumps. Many of my expenses will be recurring, i.e. they'll be from the same vendor but sometimes from different addresses. Example: Home Depot has several stores we use. I want to track how much is spent at each store. The same is true for a variety of other types of stores we use. So, I've set up my little vendor table with a key field, vendor name field, and vendor address. The question is how can I get Filemaker to check the table to see if the vendor at tha…

I was looking around for a way to have a field in my database to be able to export to a specific field in Excel. IE: Field "Install Date", to export via script into an Excel Template(.xls) called. "TN Change Form", into cell "A7". Any ideas how to make this work? Is this a SQL related question or can a special type of calculation make this work. Thanks in advance. Chris

Wondering if this is possible.. PDF in a container, I want to autofill filemaker data fields from PDF metadata... possible?

I use filemake to keep records of people I interview for careers. Each record has a picture box. I take a digital picture of each candidate and upload them from the camera into a folder at the end of each day, I then import each photograp to it's appropriate record. I would like to automate this process rather than importing each photgraph manually. Is there a script or function that will import all the days photographs into their individual records. Each photograph is given the same name as each record.

we must analyse data published in a site in asp format. is there any way that i get the data automaticaly from that site and if fm can update the data automaticaly?

Hello, I am a beginner indeed and just joined in. My problem is, I am developing a FM database where one programm I use, converts it`s files automatically to PDF ( via Acrobat Reader Print option) and saves those in one folder. That folder updates many times a day(new PDF files comes in it).How on earth can I import those PDF files to my FM database ( I use commercial script automation software to import in periods of times), I can only figure out to INSERT PDF into the container one at the time. Did anybody understand? Heelp!!

Hi all I try to open file by 'openurl', following is my path. H:coh-itAdminDomain Names RegistrationDomain Name in PDFDN (.com.xx)xxx.pdf Actually I was still working on the file, but few days back I have managed to do this right already. But today my openurl dun works. After playing with it I realise it only opens up to 2 path. e.g. H:xxx.pdf then it will works. If more then 2 path e.g. H:coh-itxxx.pdf, it wont works the file wont be able to open. And oddly H:xxx.pdf works. I have access to these files, i can manually go into these folders then file to open it but not through my 'openurl' button. Can someone help me with this..? Thanks …

I am designing a soccer club database. It is structured to have only active data, in other words, the teams for this year will have the same players as a default for next year's teams, and will be edited accordingly. That means that there will be no history of the teams from previous years. What is the regular approach in this case? Is all the information exported to another table/ excel sheet at the end of the season/ year? Is it an automated script that the user can perform, or is usually done by the db administrator/ developer? Any other ideas that might be practical?

Hi, I have a membership database where the layout is designed in such a way that only the relevant fields (information) are related to the member, on the same layout, I use Tab Control to manage information pertaining to family members in inclusing spouse's information etc. Now, when I export the database to Excel, all information on the main layout related to the member get exported correctly, as well as information on the tab control being displayed at the time of export, all information on the other tabs do not get exported. Any idea how I can export every information (information on the main layout, and all information on the tab controls) to an Excel file at o…

Today I tried importing a text file that was approximately 9000 records so that I could parse out some information. After importing the file I noticed that only 7413 records were imported. I did this a couple of times with the same results. Finally I went to the last record in the db and click in it and discovered that the last thousand or so records from the text file loaded into the last record of the db. HAS ANYONE HAD THIS EXPERIENCE. How can this happen? Are there hidden control characters in the text file causing this. When I look at the text file in WordPad it displays all the records without any problems. Any suggestions on how I can resolve…

We get the following error: Beside elimating the data field that cause the following error - is there a way to by pass this error. The DBF memo file (.dbt) could not be found. Only the non-memo-field data will be imported.

Hi!! I am trying to import a contact list from excel into FMP, v. 7 - After I import it, any zip code that starts with a 0 (zero) does not disply the 0. Also, I cannot inport the dashes it seems, but that is a minor thing. The main thing is the zero. i.e. imported 04875-1566 displays 48751566 Is there any way of doing an exact import to import exactly what is in the excel file? Thanks a million - Gemini9189

Hi all, I have browsed through this forum trying to find a solution to my problem. I kind of saw something there, but not quite there, if you know what I mean. Now, I want to export records using a script, when the script comes to this export step, a window will pop-up prompting user for a filename, this same window also provides options at the bottom of the windows allowing user to "Automatically open the file" or "Create email with file as attachment". If I check the "Create email with file as attachment", it will fire the e-mail client with the filename as attachment etc. However, what I need in my script is to be able to capture the user input for filename (wha…

I'm currently developing a web site with a products catalogue. It happened so that a catalogue already exists as a filemaker database with product pictures stored in container fields. The site is written in PHP with MySQL database. Therefore site admins need to synchronise the catalogue in filemaker database, with the one on the site. So my only aim is to make synchronisation simple and clear for end users. I suppose to export data in any format that can be parsed by PHP script, upload to server, parse it and then fill the database. XML export of catalogue is good, but container fields are not exported. Administrators use filemaker 7 pro on Mac. I'm new to…

Apologies - this was originally inadvertently posted in FMP8 General discussion I was thrilled to find the Set Variable script step, and I'm trying to use it with Export Field Contents to build simple web sites - I build the contents of an html file in a calculation field then export that field for each record in a looping script. All files are created as expected. My problem is as follows: The exported HTML looks and loads fine in a browser window except that (for some reason) the reference to my style sheet does not work. (It does find an img tag reference.) If I paste the contents of the field into a new (BBEdit) text file and save it to the same location, …

I have made 2 scripts for updating my app. Export will export all data in the form/table to a .csv file. Import will import thr .csv easily. This has been seemless and works ok. However, if there is no data to export, the file.csv is not made and that is good. But on import it stops because it cannot find the file.csv. How do I make a condition so that if the file.csv is not present, it skips it and continues with the others? Export: Go To Layout["Brokers"(Brokers)] [Export Records[No dialog; "Brokers";Windows(ansi)] Import: Go To Layout["Brokers"(Brokers)] [import Records[No dialog; "Brokers";Add; Windows Ansi]

I am trying to make a button that will export my records but I need either a dialog that requires you enter a filename or I need the filename to be retrieved from a field.

Is there an easy way to export records on an Excel format ? Nick

I have a piece of scientific data analysis software that does peak labeling of spectra. I may have up to 2,000 such spectra collected in an automated manner overnight. Each spectrum can have around 100 labeled peaks with various attributes. The easiest way to export this data from the application in an automated way is to create a separate excel worksheet for each peak list. So of course I can import each worksheet into filemaker so that all data is in a single table, but if I have 2,000 such worksheets and I can't dynamically loop through the worksheets in a scripted import, what is the best way to get this data into filemaker? Any excel gurus know how to u…

hey, sorry if this is a stupid questions but from what i have been reading the only way to specify what i want to export is by creating a specific layout for it, is there not a quicker way? as i said sorry if this is a silly question !! cheers, RF

I am so glad to have found a FM forum! Here's my problem.... I created a report to format my data into a basic xml file. It looks like this: Now I need to get that into a text file EXACTLY how it appears. None of the export options seem to do the trick. Even if I could just cut and paste the whole thing I would be (marginally) happy. Thanks. Vincent

So I came back from lunch today to find that my idiot of a parter had imported an excel file into 5 fields in our database. The problem is that he did it incorrectly and it replaced the 5 fields with the new data (which he meant to add to it) AND it also replaced some first name/last name things incorrectly! Of course our backup copy is more than a month old and would require HOURS and HOURS of re-entering the data to fix it on our own. Any help as to being able to recover a version that we saved this AM would be eternally grateful!

I have plenty of experience with FM (and only FM) in the office networking setting and now I am considering making a database to exchange data via modum with other companies' solutions/programs. The data format for the exchange has been standardized to ANSI ASC X12N. Questions: can filmaker be used to create a solution used in my office but to exchange data over a modum with the above standard? Where can I find out about ANSI ASC X12N - FM interface. Thanks.

Hi, I am exporting data to a MySQL database from ODBC but date formats are causing a headache.. FM Date = 3/2/2006 MySQL Timestamp(8) = 20060302 Is there an easy to convert from FM to MySQL date format. At the moment the export script goes something like .... Set Variable [$startDateDay; Value:Day(Events:event_startDate)] Set Variable [$startDateMonth; Value:Month(Events:event_startDate)] Set Variable [$startDateYear; Value:Year(Events:event_startDate)] If[$startDateDay < 10] Set Variable[$startDateDay; Value: "0" & $startDateDay End If If[$startDateMonth < 10] Set Variable[$startDateMonth; Value: "0" &a…

Hello, I need to export to a text file without tabs ,spaces, or commas, just a plain text file without any separators. - Please help. Thanks-mikee

I've been stymied on this one for a while, and it all seems to have to do with limitations in FMP 8. Though perhaps if I got Advanced, there might be some functionality that I don't know about... If so, please let me know. Anyway, I want to fully automate my backup and restore. Let me explain... I am developing a complex database consisting of multiple files, each containing tens of tables and many layouts. It is hosted on a server and used daily. I want to be able to add features and make bug fixes without disrupting the use of the database, so I make a copy of the files on my own machine and make changes as needed. When it comes time to sync the new database w…

I have a data import that has a series of fields [color:red]for each record. (mark01, mark02...questiontype01, questiontype02...answer01, answer02...) The data in the markXX fields is either a letter or number depending on the questiontypeXX field as is the answerXX field. Is there a way (other than manuall looking at the raw data) that I can create a script that will relate all related fields([color:red]in each record)based on their ending number (i.e. 01, 02) and then perform a test on Question Type to perform the comparisons. As of now I am manually creating a caluclated field for each comparison (mark01 and answer01)based on each question type. Multipl…

How do I get FileMaker to print the field names when I export? I get all the data, just no labels. Thanks! Sarah

Hello, Attached is a screenshot of the Excel spreadsheet that I need to import into FileMaker. The full spreadsheet is 200 columns, 400 rows. Each row represents one patient. Each row (patient) needs their own record in Filemaker Pro. Any Suggestions??? Thanks! Alisun

I need to export graphic image with a specific name for a project that we are require to upload images to a web site that host on-line auction for us. We have the product ID to show different auction item and the image name have to somehow reflect the product id. I created a field to use as file name in the database, but I don’t know how to make the export file name using the field I set up in the database. Any idea?

I'm new at FMP and am building a brand new application in which the database structure is evolving as I continue to expand the scope of the application. During this development period, I want to be able to export the contents of my test database (5 main tables, but growing) so that I can easily restore tables individually -- or any combination of them. At this point the database isn't large enough for file size to be a factor. But I occassionally find a need to restructure a table or change a data type (e.g., text to numeric), so I need to allow for simple table- and item-level changes. Of the TWELVE different formats offered in Specify Output File, I'm only f…

Hello We have 60 fp7 files, generally with one table per file, the data (not worried about functions/layouts etc) needs to be migrated to a new database (in existence and designed). These files have been created in previous versions of FMP and one or two contain large numbers of fields (720). I'm using FMPro 8 Advanced. What is the best way to migrate the data and perform the field mappings/transformations? Write scripts in destination/source or an intermediate file? Import seems not to be able to sort source fields and I get in one Import Records step no source fields viewable. Hope this explains the situation. Thanks

Just wondering if there is a way to find a date/time stamp of the last time a filemaker db/solution was developed on. i.e. last time a layout/table/script was created. Perhaps a hidden Get() command..? If there is no such thing, could you suggest other methods of getting this type of information? Thank you in advance for your help. Sung Joon Kang

Each month I download the statements for each of my credit cards and import the transactions into a table in my FM8A database. In the Import Records script step I have specified the names (and paths) to the various possible downloaded files, and the script will import the first valid file and path that it finds. Only one valid downloaded file will be present at any time, and I will have already named it according to the credit card which it represents: e.g., citi.qif, mbna.qif, etc. Here's my question: is there any way to determine the name of the file that the import script locates and processes? If it opens mbna.qif, for example, I'd like to be able to identify th…

Sorry, I wasn't sure were this question would go. My question is, is it possible to download data from a general website and input the data into FileMaker? Is there a script that will do this or a utility?

I've got text in the clipboard that paste fine in textedit but refuses to paste into a text field in FileMaker. If I paste the text into textedit, I can then copy the text from there and paste it with no problem in FileMaker. Has anyone else run into this issue? The text is html source code.

Hello again, I understand how to insert PDF`s into container, greating a path to that file in "insert file" and open it with FM, but is there any way to insert a whole folder of PDF`s there so that I could open the PDF files in it one after another in FM without allways greating the path to every single files? Any particular script? Help help!!

Hi every one. This is the first time I'm having troubles with importing data into a filemaker database. I'have configured a script for importing from a tab-separated text file in filemaker 4.1. In this file there are two date fields. When I changed into FM6 the import goes wrong. The dates are in european format dd/mm/yyyy. When they are imported they go in american format mm/dd/yyyy. Of course I have imposted FM to work with system dates which are dd/mm/yyyy. Now this is causing some trouble since one of this dates indicates me the deadline. Example: text file --------------field in FM 10/02/2006--------------02/10/2006 In other cases of importi…

Is there a way to import an entire csv file into a single field for parsing within FM8?

I have found a sub routine that will convert a decimal to a fraction with a set degree of accuracy. But I need something that will only work in 1/2, 1/4, 1/8, 1/16 (powers of 2). Anyone know of anything to help me?

I am a systems engineer and have never worked with FileMaker. Our Client is (for whatever reason - not important) wanting to migrate their "servers" from a mish-mosh mac/unlicensed ms server environment to a fully legal and licensed microsoft environment. Is there a way for a dummy like me to export the current FileMaker Server 7 data into SQL? And if so, will the client workstations still be able to connect? I have found something called FMPROMIGRATOR, but the website does not load... as always, "any help would be appreciated"

I am trying to make a feature that asks for number of colors to be used and then changes layout or insertion fields to require that that many fields be filled out? e.g. if I say it is a 4 color print, I want it to ask what the 4 colors are but am stuck trying to make variable # of fields display- I have a max # that can be filled out and could just have ability to enter necessary # but that seems so... inelegant. Any advice is appreciated- thx -- ehd

Hello, I have a huge excel file - 400 rows, 168 colums. It is a medical spreadsheet, and each row represents a patient. I need to make each row an individual record in FMP. Transferring information one row at a time would take forever! Do you know the best way to import this Excel file into FMP? Thanks!! Alisun

Could someone tell me how I might export a repeating field so that all repetitions end up in an Excel cell separated by carriage returns (one on top of the other). ?

Greetings from a first-timer First of all I would like to give congrats to the developers as they have done a great job with this product. I have been able to accomplish the majority of my project without the need of support until now. The business need I am addressing to basically an order entry system containing and order header and order line item. The line item file is related to the header by the order number and a line number ( one-to-many relationship). The order number in the header is assigned by serial#. The task I am having the problem with is the need to duplicate an order (both header and line items). The way I am doing this is with a script that: …

Hi. I'm relatively new to Filemaker - a warning. I imported records into a database, creating fields as I imported. The database indicates (via grey horizontal bar on the right) that there are 20 fields, 400 records, but nothing shows up in the actual viewing area. I do have "show all records selected," and when I click on define database again, all the correct information is in there. It doesn't matter what view I'm in (layout, browse, etc.), it just shows blank white space where my table should be. I'e imported records before and haven't had this problem. Any help would be greatly appreciated!

I'm using FMP 7. I have a folder of 180+ xml files, all with the identical xml format. I'd like to import all the records into my DB. I have made a script that has the import command. It allows me to add all the file paths for my xml files in the file path box which I have done. When I run the script, it only imports the first record. IF these were text files, I know I can use the batch import functionality. Is there a way to either import this batch or somehow loop through and import each file?

Using the template "registrations". The database consists of Events, and Contacts. I enter the Events in manually and import the Contacts from .txt files. All the data has come over successfully, in the correct fields. However, when I try to add the Events to the Contacts, using the "New Registration" button, it only works about 1/4 of the time or less. Sometimes it will add the event, most of the time it shows the list of Events, then takes me back to the Contact page without adding the Event. FileMaker tech support has not been able to help. Running a Recovery of the database did not help.

Hi, I wonder if one of you guys can point me in the right direction. I am initiating a script with an calculated URL request. The result is a web page with a single image on it. I need to be able to get this image in to a container of the current record automatically. How can I do that - hopefully without having to buy another plug-in? Many thanks in advance for your advice. Paul

Hi I need to import the directorylistings from CD's and DVD's. I need records in FM showing the discname, folder they are in and ofcourse filename. Do I need a plugin for this? I don't want to import the .jpg's or whatever is on them into FM, I only need their filenames and foldertree... T.I.A.

Hi Everyone, I'm performing a simple export from a Contact layout (three Contact fields with only 287 records). No matter which export I select (TAB, csv), it takes 5 seconds per RECORD! But if I select Save/Send Records As (Excel), it is done instantly!!? I had really hoped that the slow export would have been resolved in vs. 8. I am struggling to understand FM's theory on why it would take so much longer as an export! At this point, unless I can figure out how to speed it up, I'm considering ditching exports entirely. But it is sad to have a feature which is almost worthless to me. Can anyone explain why there would be such a speed difference? Or am I doi…

I have been away from Filemaker for sometime, and new to Version 8. Here is what I am trying to do. I get an employee file from HR every Monday morning. It is all of the employees of the company. The only difference between Week 1 and Week 2 is Week 2 will have new hires and will not have anyone who has left the company. I am trying to figure out how to import the file each week and identify those employees who have left the company (1 report), & new hires (2nd report). Also, I get this file every week, so this would be an ongoing problem. Ideally if I start this file on the first Monday of January this year, and then run it weekly until the …

I hope this is a simple question: I want to do a simple export of records to excel. Name address etc.. this works fine, the problem come in when I go to export a portal with more than one entry.. it automaticaly puts them Vertically 1) this is hard to read 2) hard to move data around in excel. Is there a way to export a portal Horizontally so I only have one line in excel per entry? Joseph

I am working on a database for a company to manage contacts, and I do not work anywhere near their offices, therefore it is all done remotely. I have finished one version of it, and they have started using it. But how do I create new improved versions that I can email to them, and they can install WITHOUT losing the records that they have created? The long way around this would be to have them email me their current version and I work on that, but this means a disruption in their ability to use the database. If anyone has any idea if i can do this then please give me a shout!!

I'm having an issue with FM8 Advanced having an issue importing CSV. For any database created under 8, the CSV import gets hosed. Looks great in the import dialog and I can preview every record just fine, however the actual import does not match the preview. Basically the first record imports perfectly, the second record imports the wrong data (about half way through the second record) and this just ripples through the entire file. For one of hte problem imports I get 503 records when I supposed to get 963 records. This does not happen in any of my databases upgraded from FM 7 to FM 8 - they still import fine. Same issue occurs on both Windows or Mac no matter…

Let me start by saying I know practically nothing about XML. I have tried to modify a few example XSL sheets I have found here, but failed miserably. I want to export, to a text file, a report with sub-summaries. My db has 2 tables: Companies and Products. The report is from Products, grouped by Companies. Ideally, I am looking for a generic XSL that I could modify (if needed), that would have the following parts: [color:navy] 1. Header - information from globalHeader field; A variable separator (let's say for now three carriage returns); 2. Sub-Summary (leading) - information from related fields in the Companies table, separated by another variable sepa…

Anyone know of a way to import cd info off the web into an FM db? Cheers, Kundan

Riddle me this... If I set up a database - Field1, Field2, Field3 with one calculation Field Field4= LeftWords(Field2;1) and one auto-entry Field5 : auto enter serial number and import a text file with 3 CSV fields If I do a plain old import, add new records, perform auto entry then the text comes in as expected. Fields 1-5 are all filled in. If, however, I do an import with "update matching records in found set" (where I have all records showing) and have "add remaining data as new records, things don't import as i would expect. Field5 does auto enter a serial number, but Field4 does NOT calculate, and does not fill in. I very much need it Fi…

Hi, Every night at 1:00AM I have a script run that exports data from all my fields into a merge file. For some reason, one of the fields (called JobCostBasedonInvoice) is blank for 80% of 20,000 or so records. It's just a standard number field, nothing fancy. When I run the script manually in the middle of the day, it works fine... Any idea why something like this would happen? Thanks, Andrew

I am currently trying to import data from filemaker 5 to 8. I got the files from the company off their server. When I try to import them after I copy them to my hdd I get this error. "either the host is not available, or the file is not available on that host." it is almost like it is treating the file as a link to the real file, but it is the real file. One of the files is 1.3Mb in size. I also get an error when I try to open up any of the database files on their own. "The operation could not be completed" "An unexpected error occured(error code - 10660)" It's almost like there are some hidden permission on the file so that you can only access it t…

Hello, I'm importing from a MySql to FileMaker 6 using Actual Technologies' ODBC driver. Works good. The problem is a timestamp field(column) in MySql is automatically formated to a date format (mm/dd/yy) when it gets in FileMaker. Is this being done by FileMaker or the Actual driver? The FM field is a number field; or it can be text field. Either way the MySql format is automatically changed to the FM format. The MySql timestamp format is yyyymmddhhmmss. I need it to import into FM in the same format. Thank you, Omer

I'm looking for some direction. Background This aplication is for a pottery co-op to generate firing fees every couple months. During the period, several kilns are fired with each kiln containing many pieces from different members. For each piece, a firing slip with the members name, the height, width and length of the piece is recorded. This data is entered into a flat file and the name of the file is the date and kiln that was fired. So the data from one firing might be FILENAME: 20060106 BAILEY ann 2 3 3 ann 3 4 4 ann 2 3 3 ann 4 2 2 joe 7 4 3 joe 2 3 3 joe 2 3 3 etc, etc I wrote a script that grabs the file name to enter as a field i…

This is actually TWO questions: 1. Is there a way to export repeating fields as seperate fields... rather than a single continuous string... so Excel reads them as seperate columns? 2. If not, can I "trick" Excel to thinking they are seperate fields by exporting the data with either a tab or quotes around data. Like this: "data","data2"? How do you get filemaker to allow quotes or tabs in calculations?

In my database, I have some line breaks in certain fields. Everytime I try to import into mysql, it fails because of the line breaks... What type of line breaks work in FM and can be imported into mysql? Also, how can I find these line breaks and replace while in FM? Thanks for your help.

I have a trial version of FM7 and am in a hurry to solve this: I want to find a record in one file then make a copy of it to another table with matching fields. The point being that I want to moderate values without changing the original or adding records to the original file. A sort of lookup. How? FileMaker Version: 7 Platform: Mac OS X Panther

It's been years since I've worked with Filemaker. I'm now trying to use it for an interim solution until our reporting group can help me with a permanent solution. I'm importing data into Filemaker and running a report that I would like to print to a Word file so that one of our staff members that does not use Filemaker can update the document daily as needed (the document is recreated weekly via my data import). Years (and versions) ago, I could click the "Print to file" checkbox and my report would output to a format that I could then open in MSWord. When I try that now, I get a bunch of goblety-guk. FM documentation offers no help in this regard. Advice would be greatl…

I am trying to export to a csv file that I can upload to a mysql database. I need the first row to have the field names. How do I do this? Or can I export to an odbc connection mysql table? Any plugin suggestions that can do this? Thank you.

Is there an easy way to export my filemker 6 databases to MqSql ? I have many filemaker databases and want to move this over to mysql for web reasons. Any idea how to do that? Very thankful for advise! Oystein

I wish to import records from database A.fp7 to B.fp7. The two databases share many of the same records, but the ones in B.fp7 are the newer, correct ones. I wish to import only those records from A.fp7 which do not exist in B.fp7. The records include a unique identifying field, so the aim of the import would be to add to B.fp7 only those records from A.fp7 in which the value of field01 does not match the value of field01 in any existing record in B.fp7. Could a script be written to do this? I am prenovice when it comes to scripting...

Hi, I hope this is the right forum for my question, which tries to drive me crazy and I must have a solution until the end of the week. So, any ideas will be helpful. I am working on a project with persons and items and I need to export data (from persons or from items) in order to print some kind of labels. This file will be imported into QuarkXpress or InDesign, where there are the proper printing layouts. The problem is that i need the data from any field to be included (repeated) as many times as the value of the field "repeats" specifies, into the tab delimeted file I produce. Example (in the persons db) Suppose that my found set contains t…

I am developing a database with about five tables, each of which has a unique serialized primary key by which the various relationships function. Everything works great. My problem is that a group of users will be entering data into a remote copy of the database. After several months, this new data will need to be imported into the primary database. But, of course, since both copies will be creating serialized primary keys, there will be duplicates in the remote copy that need to be systematically changed as part of the import process. Surely this is a common problem. Can anyone point me in the right direction? Perhaps an example script somewhere? We've yet to…

I am using Apple's Address Book. My Address Book files (I think are stored in vcf format) each contain one graphic and several text fields. How can I import these records including both the graphic and text into FileMaker? TIA

I'm a newbie at Filemaker, but oldtime computer user. I want to automate some data entry. I want to have a script do the import. The Filename to be imported has to become a field in the table the file is imported to. For example Filename = FOO with records aaa bbb ccc ddd eee fff when the import is done I want to have four fields with aaa bbb ccc FOO ddd eee fff FOO I've been looking at the various functions and scripting commands, but can't figure out which to use. Can someone please point me in the right direction? Thanks in advance.

I'm hoping there is a simple solution. I am exporting several DBs to .csv files and ftping them to a linux host. When the export is done on a PC no problems. On a Mac, the carriage returns in the uploaded file are not recognized and the data is handled like one long record in Linux. Is there away to get FM6 to export .csv with CR & LF (or which ever one linux is expecting)? Or does this need to be addressed on the receiving end? JRW

I use the command "Export Field Content" to copy a PDF file to a temp folder in Windows 2003. I want to use the user temp folder set by the system variable %TEMP%. When I try to specify the output file, I enter this path "filewin:/%TEMP%/MSDSX_A.pdf". I don't think Filamaker support those windows "System variables" ?! Something strange, when I view back the code after entering it the path is modified to : "filewin:/%25TEMP%25/MSDSX_A.pdf". What those "25" are doing there ? Any idea how to use windows system vars in filemaker ? David St-Onge Maerix

I'm just wondering if it is possible to set up a variable to export to (or even open a file on) the server by using a variable which gets the network or file path (on a server-hosted file). Is this just a pipe dream of mine?

I was updating a FM8 database using XML and noticed that an import log (text file) was created. I don't know how it came about, I love it, so I'd like to replicate and have this as part of the solution. How does FM8 create the import log and how can I use the same theory/methodology to create custom logs for imports/exports? Import.zip

My problem is this. I have four fields which have one of two values, .5 or 1, or no value. I have a calculation field which is If(team a or team b or team ecom=.5,.5,1). What happens is records created in Filemaker work fine, but records imported into filemaker from excell do not return the logical result, and even if I attempt to change the imported data the results do no follow the calculation field. I have made sure that the number fields in excell are set to a number designation. Any help would be greatly appreciated.

Brief background: Webhost backed up server - and after upgrading OS, data from mysql was not restored... 20,000+ records lost. UGH! Says anything that can be restored is... After moving to a new host ... realized I had received emails from each form submission. Was able to dump them to text files. Using a small group, imported each text file into a seperate record. Entire email is in one field. (To, From, Subject, Date & Body) Have been playing for several days trying to parse the data into individual emails so I can get the newsletters back up & runnning. Played with Middle, Position, etc... but having trouble figuring out how to capture everything f…

I have a filemaker database containing product picture with repeating field for product Item #. (one to many - 1 picture different item # ) I'm in the process of migrating the file from version 6 to 8. Instead of using the old ways to link the relationship, I wanted them in table format. So i imported my picture database into my product database table but it didn't turn out the way I wanted. The importation has made the Item # and picture a one to one relationship. How can I do it so that it doesn't separate the repeating field? I hope i am not confusing anyone.

I have a datbase that has 1200+ records. I exported all the records with the FileMaker 7 extension. My problem is I do not need all the records back in the database. I only need ones that the item has not been sold. The boss only wants those items back in the database. Can I script to have this done? If so, how? I know how to import but not with this condition. Again, I only need the records out of the 1200+ that the item has not been sold to import back into the new database. Thank you.

I have two versions of a file that are almost exactly the same except for a couple of layouts. I imported newer data from an older version to a newer version. I checked and re-checked, and all of the precise number of records are in place exactly as they should be. But somehow the new version of the file is almost 10 megabytes LESS than the slightly older version with the exact data contents. Either file, saved as an empty clone, differ only about 300kb. How is it possible that I have lost 10 megs when all of the data appears to be in place??

Is there a way to import text (for exmaple, a report) from MS Word into a FM Pro 7 layout ?

I have 2 filemaker apps I want to combind into one. Forms, layouts and all without having to recreate the layouts. Can this be done? Thanks

Is there a way to createan update for a distributed application without over writing the current data? Is there a way to have all the data gathered in my app to be held/stored in an external file other than the one with all my forms and layouts? Thanks

Can somebody tell me if there is a way to mass import records from an older version of the same file? Like say if a file crashes and I need to restore the data to a backup, or if I make layout changes and need to migrate the up-to-date data into the new version of the file before going live with it. Right now I put together a script with about 50 import steps for each table that I need to update. It is annoying because it makes me re-enter the admin password for each table that is being imported. Is there a better way? Edit: I am just trying to figure out if you can import to all tables at one time.

I'm trying to pull information from an Access database, then format it a bit, and push it into a FM8 database as a new record. It works great if I have all fields in the filemaker database set to text... But if I change the field that will hold the date to a 'date' type it only imports the first record, then the SQL engine bombs out on the 2nd query saying the "Query Failed". I pull from the access database a string, that used to be a date in the actual program that uses it. I then trim off any white space. If I output the date to the screen that crashes it, it's 12/29/2005. Which is valid? Any ideas? Here's the entire script: ' This script is going to que…

I'm currently running an import on the 'newest' version of our one file, importing all the information over from the 'old' file. There are a few fields that are missing on the old file, but I'm just using matching names to handle all the field matches. Anyway, the file I'm importing from is roughly 61k records, and the total file size is probably around 200MB (a lot of text). I ran the import for over an hour and was only able to import roughly 15k records when I then had to cancel it. If it makes a difference I was terminal serving into our server at work, and I had the filemaker server service stopped. I can't understand why it would be running THAT slowly,…

Facing a very strange phenomenon. Import scripts that worked perfectly fine seem to 'lose' their order. Already encountered this problem three times. At first I thought it was my mistake and started over again, but now I'm sure I didn't change anything. Is their any explanation for this? Haven't entered the script and confirmed a new import order. I did add fields to the tables but that shouldn't make the difference. Anybody had the same experience? Are there things you should watch out for that might change the order? Oh I just wish their was an easy way to view the import order and what fields it imports from, without having to run the script ag…

Hi I have a file that has 6463 records with 138 field. I copied it as an empty (clone)file. I opened this blank file and wanted to import this 6463 record .I choose "matching names" and click "import". after a long time consuming import process it says "6421 records skipped due to errors" (The number of skipped records changes everytime) and file turn with very few record ... please tellme what I did wrong or filemaker did something wrong I miss FM 6 import capability Best regards