Importing & Exporting

does anybody know a way to "broadcast" a FM contact database via ldap, so that other applications e.g. Apples address book or MS outlook can access the information in the database. We use a FM Server 7 running on OS X server thanks

I have data base with unique ID numbers for every record in the data-base. Data-base1 has 920,000 records. data-base 2 has 6,000 records. All of the records in databse 2 have matching IDs with Database 1. (In fact all of the IDs in database2 came from Data-base1, which were sent out to get some new data added to them). Now, when I attempt to import the new data added to the 6,000 records in data-base2 into database1, some of the records are droped. for example: A136756 is a common ID between both data bases. However, when importing the new data into database1, Filemaker fails to import from this ID. I am loosing about 700 records. I have the two…

Hiya guys, Is it possible to perform a script with the "Execute SQL" command to update records in another database (such as Oracle) from a client machine but use the ODBC drivers and Data Sources from the server?? The reason I ask is in the past when I want users to perform an "Execute SQL" script I have to set up ODBC drivers and Data sources for each machine that will use the script. It would be easier for me if this script was ran server-side where the ODBC Drivers and Data Sources would only need to be set up once. But still make it so that users could run the script from thier own client machine. Does this even make sense and is this even possi…

In my solution one of my tables has about 300 fields, with a fair few of them being unstored calculations. To export this table takes a few minuntes for only a couple of hundred of records. One the other hand another table has about 100 fields, almost no unstored calc fields and to export this yields about 5 times the speed. Is exporting speed, field dependent, layout dependent, Filemaker version, or what? I've read the posts and there seem to be no clear answers. Does anyone have a definitive list of what can be done in Filemaker to obtain maximum speed for exporting records? (Please, no joke replies about buying a supercomputer – I need answers not bad wit). …

Hi! I have a huge problem with importing data back to FM database. Importing to one table is simple but how to import related data to second database with same relationships. I have included two example files PeoplePets1 and PeoplePets2 ( second contains one record less ) and I created XML export ( I don't know which format is best for exporting ) with related data included. But how can I import related data to second database file and that relationships stay the same? I don't have any idea... Problem is when I would have to make changes to database and distribute new solution to customers. In Developer's Guide is said that you must create new solution, export data…

is there a script step or calculation that can be used to get the filename of an imported file (assuming the import is done using a script)?

Hi, I have to import a folder of images. But i want to use script to do this. I can not find import folder script step. Is it possible to import images in the folder by script? Thanks Osman

Hey people! I'll trade my kingdom (such as it is) for an easy-to-use Filemaker Pro 8.0/8.5 to address book sync. I'm using OS 10.4.6. I've searched the forum without any satisfying results. I can't be the only one that needs this handy feature/utility. Somebody out there ought to be able to come up with this handy utility. All you developers that just finished your big conference get to work on this simple yet important item, please. Before someone recommends Address Exchange, allow me to say that that software hasn't been updated to be compatible with Tiger. Address Book Importer is only a partial solution and leaves me unsatisfied. So...there's opportunity here for…

I have a database with parent and child records. It works great. However, if I make a copy of that file, remove all the records and then import the parent and child records from the original file into the blank copy, the relationships do not work unless I close and reopen the file. Anyone know why this might happen? :

In the final runtime version of my solution, both for XP and Mac OS, the user can click a button to bring up a standard file dialog where he is supposed to select an XML-file he has received by e-mail. That XML-file will then be imported. (The format (fields to match etc) of the XML file is already known to me.) The current solution has an 'Import Records' step with 'Perform without dialog'; the 'Specify data source' is NOT checked, but the 'Specify import order' is of course enabled and properly setup while I had an XML test file selected. The 'import order' is saved with the script step, even when I make sure 'Specify data source' is NOT checked. The curr…

I have a database of 100,000 records and I need to have the database export from a calculated field. Is it faster to: 1. export from the calculated fields or 2. is it faster to loop though the data set a text field for each calculated field and then export the text field? Thanks for your help

Using Filemaker Pro 6, I am exporting 195 fields to the .tab format. Most are fields in the active database, but several are related fields. Every so often I get extra records exported. The extra records either are all tabs or have the last value of one or more of the related fields. Any ideas of what I'm seeing and how to prevent it? Kay

whenever I use a certain script to import files, the file browser (on windows at least) always defaults to files of type csv or txt. Is there a way to change this behaviour somehow?

My database has anywhere between 45,000 records and 350,000 records( it changes every day). I need to be able to export 2000 records at a time until all the records have been exported so the way I see is: 58 exports of 2000 records would work for a record set of 116,000 This is going to take me a long to in the scriptmaker to type. Is there anyone out there who knows a faster way of doing this. I took a screen shot of code from script maker so you could see my logic, by the way count1 is just get record count divided by 2000. Please help me! Picture_6.pdf

Hi I'm exploring the integration of GIS mapping software with a Filemaker solution for a company related to health services. They want to be able to diaplay sites like hospitals etc on a map of the UK. We have postcode data so I'm anticipating the need to export it into another bit of software: unless you know different. 1. Do you know of any good GIS mapping software? 2. What's the best way of integrating it with Filemaker? Best John

Greetings- I'm new to the forum and would appreciate feedback. I'm trying to export text (ultimately to MS Word) and hold onto the Bold style I've added in FileMaker. I've tried every character set in the "Specify Field Order for Export" dialog window and every file type for export (I think), but all I get is plain text.

I have built a MySQL booking system to be used online by about 20 users all over Australia. Users can go online and see a calendar of their bookings. The problem with these systems is always this: Users take some bookings online from the public - but others over the phone. So they keep two sets of books. There are double-bookings, etc. I've considered using AJAX to send users an Ical format calendar to synchronise with outlook. But I'd much rather send all the users their own desktop filemaker executables which would synchronise/dump MySql Data. That way I can get some compliance from the users who may use Macs or who will not pay for a full Filemaker licenc…

Hey I have a solution that interacts with other programs using an XML export. Currently, I have FMP create my file in a global and then using the "Export Field Contents" the user saves the file. My problem is Filemaker saves the file in Unicode, but my clients antiquated other system only accepts ANSI characters. How do I tell Filemaker to save the file as ANSI? The work around, is to have the client check off the 'automatically open file' checkbox, the file opens in WordPad, then they use 'save as' to save as ANSI instead of Unicode. Anyone know a more eligant solution? TIA Jerry

In http://fmforums.com/forum/showtopic.php?tid/179213/post/216866/#216866 David gave me great idea how to organize the interests of my contacts in our service tools. I have a question now: I have Excel-sheets with contact data where the interest of each contact in our tools is marked. How can I import this information into my Filemaker database? thanks for your help hans peter

Hi, I'm looking to import from a camera/webcam directly into a container field. I tried troi Grapper Plugin without much success. Thanks, Skip

I've got a large database that we've routinely exported to .xls format. The database opens and works fine in Excel 2000, however in Excel 2003, certain fields are replaced with question marks, everything else is the same. Everyone of the fields that has this issue uses the List() function in FM pro to get related data into one Excel row. Does anyone know what causes the difference?

I need to export records from two different .fp7 files to one another. For example, abc.fp7 is a note taker file with 500 notes. I need to export those notes to 123.fp7 which will be only 1 record housing all 500 notes. Is there a way to make a container to export these notes from one another automatically? I also want this to be only for certain accounts with the proper privledge to access it. Thank you very much for your time

I have a little problem: I have a Search Layout I use for exporting into Excel. There are two tables Category and Contacts. Category ID is the foreign key in Contacts. If I save records via the menu command Save records as Excel - it works fine, all data from fields Category and Contact name populate all the Excell cells on the spread sheet for all the records. However, when I do a scripted button to export Category and Name, the fields do get exported, but Category shows only grouped data - Names are fine - all the cells are populated, but not Category which I would like to see populated next to the names. I have to point out that I did not group Category prior…

Hi: Is there a way to import from a .csv file and have a serial number field auto-populate? Any script examples are welcome. Thanks, Kenyon

I have been searching long and hard for the best solution at pulling data from the web and into Filemaker Pro 8.5. My problem is this: I have a form that will be filled out by all of my sales representatives, and this form will need to come directly into Filemaker so there is no retyping required and the process is as automated as possible. This includes matching the fields on the web to the corrisponding fields in FM. The form will need to be on the web. I have looked at every option in the book: pop3it, mail.it, cafephp, ODBC's, php's, mysql's, and IWP. I am a novice/intermediate user I guess, but with little programming knowledge. I need to know what is the easies…

I'm trying to export fields with some italicised data - a database of questions and answers eg. Whose 1988 debut album Forever Your Girl was still yielding hits in 1990? However, when I export the data to MS Word I keep losing the italics. Any clues anyone? (PS. Answer is Paula Abdul)

I am trying to use the find/replace feature to eliminate user entry errors when they hit the "enter" button twice while typing in a list. I can't seem to find a way to make it find the carriage returns. - Would I have to do all of this in a calc field.

Good evening, I want to be able to export data from file ABC.fp7 to CBA.fp7 automatically. Is there a script that allows this and how can the files run dynamically? Thank you for your time

In my student management database, I keep two identical tables. One for active records, one for an "archive". The archive is used to semi-permanently store data for a student that has moved, graduated, etc and the informaion needs to be kept, but kept seperately. Fairly frequently one of these students is needed back in the main table. Over the years I have accomplished this several ways. Currently this is what I am doing: "Users" can mark a student that needs to be archived by clicking a button that sets a match field. That student(s) then shows up in a portal and an "admin" can click a button to archive the student. What happens when the button is clicke…

:P Hello, I am relatively new to Filemaker. I have a database which I am trying to export into another application. I have exported the database at present to a CSV file. However when I look at the CSV file there are no Field names. How do I export my field names along with the data. Regards A very frustrated filemaker user!!!

When I go to the File>Print menu in FMP 8 with a Mac... and I choose "Preview" so as to see the PDF document with Picture Viewer.... It chooses a default name for the PDF file that is exported. How do I change it ?

I have several detailed reports that I would like to export as a PDF file to send via email to colleagues. Can I do this in FM 6 or do I need to export the records to Word, format as needed and then save that document as a PDF file? If FM 6 does't support exporting to PDF, do more recent versions? It may be worth it to upgrade. Thanks, Nicci

I need to import an Excel spreadsheet into Filemaker to convert it to a database. I have one column that displays UPC codes as 14 digit numbers in my spreadsheet. In Excel I can format the cells so that it always show 14 digits. For example if I enter 22211704423, Excel will add three leading zeros and format the cell as: 00022211704423 Is there any way I can do this in Filemaker? Thanks

I've got two databases related to eachother. On one database there is a blown up picture with all the info typed into text fields, and this datebase is online and can be viewed. The other database holds the large picture files and imports the text fields from the first datebase. How do I make it so when people can download the large files if the thumbnail is the the picture they're looking for?

I am looking to import a field and have a 'add to' instead of replace data, while using a update using matched fields. I work at a Production company, and multiple clip numbers can be used in multiple 'PODs' and I want to be able to figure out what clips are in what pods, I am integrating Final Cut Pro into the mix, so it is exporting all of the info that I need, I just want it to tabulate in the pod field while keeping the same clip # and the same number of clips in the database it seems like it should do this for me fairly easily...

Surely I've missed something. It can't be this hard! I'm trying to construct what I thought would be the very simplest way to archive the contents of an FMP file -- and be able to restore those contents at a later time. I've designated the .fp7 file type on the export -- and by all outward indications, FMP produces the file (records.fp7) properly. The import specifies the exact same table and Matching Names. But, invariably, the items are scrambled when the import executes. Even when I go into manual mode (activate dialog), none of the "Arrange By:" settings will cause the fields to align. I've had to resort to using Custom Input Order in every in…

Having a look for the first time at an auto importing script. FM is asking me to nominate a character set for the import. These sets seem to be predominately platform related. Since my solution may be used on either platform can anyone advise on what might be the best setting? TIA Phil

We currently have a large project that we are working on for transfering a great deal of audio information from older sources to digital media. Part of the project is creating a kiosk station which will allow people to listen to any of the music we are transferring. For this part we will be importing about 800 CDs into a compressed format. We will be using iTunes as the backend and I would love to be able to edit the ID3 tags straight from FileMaker since we already have all the titles from the CDs in a database. These aren't CDs that would come up under GraceNote. I'm not an expert with Applescripts, but I'm thinking we will be able to name the CD to its corresponding CD…

I've got a picture database of University research slides that I'm putting into a database. The raw images are about 5 megs each and I've put them on their own seperate database. In another data base I have greatly lowered the resolution etc. to make the pictures about 16K each. What I want to do is make the 16k version the one that people see on the web, and if they want the image for their lectures I want them to be able to click on the image and have it download the raw 5 meg image. How do I get filemaker to match the files, and make them be able to download the raw image? Thanks

I’m having trouble copying from a text field directly into an MS Word document. It seems to double the number of carriage returns that existed in the FMP text field. Is there a way to fix this?

I've created a small program that converters Outlook 2003 Agenda files into a format needed by one of my customers. A couple of fields should be in the Unix Timestamp format. I've noticed that Filemaker 8 has a timestamp function, but this is completely different from the Unix Timestamp format. Is there anyone who has a simple conversion tool / tric for this?

Hi, I'm a newbie with a full-blown Server 8 Advanced setup to manage. I have a simple database on the server, and to produce reports I want to pull the data out of it and into Excel using the ODBC driver and MS Query (Office 2000 version). Everything works fine, except that MS Query kicks up an error on the FM database's date field. The date field is set to be strict about the format, and to enforce a 4-digit year, so they all look like this: 6/8/2006 Has anyone else run into this? I have not found this issue on the forum, so forgive me please if the question has been answered. I need to use Excel for this, as we do not want the FM client proliferati…

I am looking for a way to import HyperCard records -- anybody know how to do this?

I hope that this question has not been already posted, but suspect that the question is right out there and I'm missing it. I'm using fmpro 6 to keep track of information requests. I download information from the website into a .csv file and then import it into the fmpro database. The date format in the csv file is x/xx/xxxx x:xx:xx PM (or AM) I'm trying to format the field so that it is only xx/xx/xxxx. Can anyone help me come up with a script so that it is reformated every every time that I import? I've tried all sorts of things to no avail - including modifying the csv file before importing it. That corrupted my database beyond belie…

This may seem simple, I hope it is... I have a database with two tables contained within. I am trying to import data to the second of the two table (within the same database), however the import facility seems to only allow imports to the first table created! Anyone with any bright ideas?

I'm importing records from a file, and using Update Existing Records with a match fields. I would like to update the existing fields with the incoming values, only if the incoming values are not blank. That is, suppose a record in a Contact table has content in the Address 2 field. The source file has an updated phone number, but does not have a value in its Address 2 field. I want the phone number to be replaced, but I don't want the Address 2 value to be overwritten with blank data. Just turning off a field in the import dialog is not a solution, because the fields which are empty in the source table vary from record to record. It seems to me that this wo…

Ok please bare with me I know a little so Im dangerous as they say I have the following data:- CHRISTINE *Best Price DVD* Das Boot *Best Price DVD* FINDING FORRESTER *Best Price DVD* as individual records I want to automatically remove the *Best Price DVD* from each record. The title of the DVD changes Thanks for your help

Hi .. Used Filemaker today - the first time since 1996 ... it's changed a lot - but also feels very familiar .. One question - I have created a text field with pre-defined font and size (etc) - but when I PASTE text into this field, it honours the RTF settings of the pasted text? This is not so good since I wish to honour the original field properties. Is there a workaround? Thanks in advance Jon

I am quite new to FMP and to everyone else this is probably a stupid question but; I have created some new layouts and scripts for a client in FMP6 and have come to the end of the development work and now want to update their system with these new features. But having never done this before I am not sure how to do it. If I copy the databases back onto their server won't it overwrite all of the database entries that have been made since I took a copy and completed the work? If so, how do I get these latest layouts/reports and scripts into the current databases?

I have a field with formatted text in it. (Some of the words are a different color) I would like to somehow export/save this formatted text to an external document that can be opened and will show the colors. I have tried multiple script steps and menu options, but to no avail. Is what I want possible? Thank you for your help, Nancy

Is it possible to set up FMP to be able to check data in and out so teachers can do reports at home. If so, is there a way they could do it without their own copy of FMP - I am thinking FileMaker Advanced. Many thanx PJ

Is there a way to export and Import the value list? When i do updates the value lists have to retyped in every time.

Hello all, I apologize if this posting appears in the wrong section--please point me in the right direction if this is the case. Right now I'm running FM Pro 6, but will be upgrading soon to version 7 or 8. My goal is to use Filemaker Pro to graphically display geographic data based on parameters set in Filemaker. This will be used to plan national tours for musicians, and I will be using existing information in my database, such as venue size, venue type, and location. Ideally, this will enable me to look at a map displaying all the venues that fit my criteria and plan routings accordingly. An associate of mine has done something similar on a PC (e…

I did a search of these forums and it looks like it is possible that FileMaker 8 does not have an automatic export function. Is this true? What I want to be able to do is export every-night a specific set of information and email it without any interaction. If FileMaker can not do this by itself can you direct me to an external solution. I looked at Automator built into OS X but there was nothing for FileMaker in there. Thank you for your time.

I have done a bulk import of a text file to a Filemaker Pro 5 database (about 400 records). I am now running into a couple of problems manipulating the data. An important body of text has gone into a "comments" field in every record, and in this comments I field I included various searchable codes so that I could find the imported data records and do some processing on them in FM Pro. The text in the comments field appears perfectly, but when I search for codes and simple words that I can see in the comments field, FileMaker returns "text not found". The text is visible, but somehow because it's imported it's not indexed, or searchable, or something. I have tried reimport…

I've created a new version of a database, which is empty. I'm attempting to import data (actually only 1 test record for now) from an earlier version of the file. The Import Summary dialog reports ... Total records added / updated: 1 Total records skipped due to errors: 1 After the import, the new database is still empty. And there's no Import.log file to tell me what went wrong. The FMP 8 Advanced Help for the Summary dialog says "For more details, click Open Log File to display error messages." Click where? There's nothing in the Summary dialog, and no FM menu item I can find. (I suppose if I could click, it would tell me there was no log file.) …

Hi everyone, I have a FM database with around 90,000 entries. I want to add a new field and then combine it with another. For example: Now I have: John Doe I want to add to all 90,000 records: "Mr." So now I would have: "Mr. John Doe" How would I easily go about doing this? So far I am able to create the new column and I created a script to loop through and add "Mr." to each field. Now I just need to find a way to merge it with the other column. I tried everything I can think of. Thanks in advance for any help you may be able to offer. Thanks!

Suppose I have a file set to use yyyy-mm-dd as the date format. I export the records as XML (fmpxmlresult, no style sheet). The resulting XML document contains: ... ... 2006-07-04 ... But when the document is imported into another file on another system, Filemaker ignores the declared date format, and imports the date data as invalid dates. Actually, my REAL problem is importing from an external XML source, using a style sheet. The style sheet presents the XML data "as if" it came from another Filemaker file. The first example is only to show that the problem is not with the style sheet. Eventually, I would like to distr…

I would like to export files to a friend who runs MS access. What extension should be used so he can import my data. Thanks

I have a database where I have a repeated field called conditions. The values are pulled down from a value-list. You can imagine it's an interview and I'm noting a whole lot of things that I think the person needs to do, as in, say improve presentation skills work on english etc All of this is fine, except that I also have a need to take this accumulated list (which may of course be empty for someone who is very good) and export it as "one entity" separated by commas. Think of a letter summarising my findings and I want to say "Joe Blow needs to improve presentation skills, work on english, blah blah" OR I want to take all these condition…

Hi everyone, First of all I must pass on my thanks to sbg2 who nutted out the majority of my queries regarding importing email text in this thread. I am now able to import lots of repeated text entries via his script however I want to set up a script that does not import text data that already exists as a record (i.e. the info is repeated in the email text). I have tried to do this using the find script step without any luck and was thinking there must be an easy way to query the database. Please take a look at the file attached and I'm sure you'll understand what I mean. If you look at the example text import strings, you will see one patient's data …

Sorry this is such an idiot question, but I'm a beginner and cannot find in the manuals how I export the RESULTS of a layout that has exactly the information I need. I can see it on screen and print it out, but I don't know how to get it into a format I can read in Excel. I can export the entire database, but I want to export ONLY the results shown in my format that I can see on-screen. I'm using FMP 6.0 under OSX 10.4.7 on a Mac G4. Thanks! Dave

I am not too familiar with FM 5. I need to create a script to import from an Excel file. I will need to match the fields, and then run this script manually every month, but without having to manually match the fields each time. I created the Import script, checked Restore, and matched the fields. But when i tried to run the script again, FM did not remember my field matching. Did i miss something?

I am scripting an import from fp5 data file. If a user has not converted the file yet, one would expect the error to be 816...no problem....except, when I capture it, the default filemaker message still appears. I have attached a simple example, just try importing a fp5 file and see what happens. What is really strange is that I used a script variable to save the error and it does show up in a dialog after the ignored error capture. Any ideas? I have looked on the boards but have not found much help yet. Thanks! Bug.zip

Hi I would like to know if there is a way of checking to see if a file exists when using the Save Records as PDF script step. I am deriving the file name based on record attributes, but want to prompt the user to over write if exists. I will do with an AppleScript if necessary, but would prefer to do with FM. Thanks halski

I have a many row .txt from a exel spread sheet im trying to import into filemaker. Is there any way other then making the .txt a string to get filmaker to ignore the returns so it imports all the data as diffrent Fields in one record? as it is right now FM asumes each line is a new record.

I am having difficulties explaining this one. my hopes are that some one in this forum has seen this before. I appreciate any guidance offered. I have created a script that creates .txt files from my FM database. each record is named after the record number xxxxxxx.txt . A little html scripting is then added for my import to my ecommerce web site. the text files look great but when the *.txt files are loaded on to the web, the mysterious "ÿþ" characters appear before my text. I have been trouble shooting this problem now for several weeks. with no success. below is an example of my FM created text file: (this is exactly what FM makes for me) ##############…

I have a FMP database that I have created, I also have an Access file that I have to keep track of EMS CAD calls. The FMP database is the main backup for this access file. I setup and ODBC connection to the access file from FMP, and was able to import the data, but I need to set it up to that when I import data, it only gets the new data and not the same older data over and over again. This is leading to duplicating in the FMP database. Thanks

Is there an easy way to paste text from a word document...but keep the formatting/pictures, etc. I've tried changing it to a container field and inserting object and file, and all else and none of that works too well.

I am trying to use the "Export Field Contents" script step, but when I output a file using this step I get one that is not encoded correctly. (To be specific, my web browser can't execute it properly). I've diagnosed the problem to the file not being encoded correctly-- when I re-save the file as Unix encoded UTF-8, it executes fine. Does anyone know of a way in FileMaker I can save a file as UTF-8?

Has anyone experienced XML that has multiple "data" lines for each "col"? How do you get the XSL to take that into consideration? For example: Client 1 CLIE1 Jim Bob Billy Sue Client 2 CLIE2 Billy Ray Susie Q I can get the XSL to display Jim Bob, but skips Billy Sue and proceeds to the next client, Client 2 and displays Billy Ray, but not Susie Q. Anyone else have this problem? What was your work-around?

Issue: In FM6 I exported data to an HTML table and uploaded to web server, which parses data into an SQL database. In FM8, works fine too, except that diacritics are suddenly encoded in a different way. The format I was getting from FM6 was very handy because diacritics were encoded for example as follows ñ = soft n which required no translation to load in a web page cleanly on pretty much any browser. Now in FM8 I've tried Windows ANSI, Macintosh, Western European, and none give me the encodings for diacritics that FM6 provided in its HTML export. Instead I get codes like 226 often two in a row (presumably unicode control characters, but I'm not well versed in t…

Is it possible to hide a field in the import window? I would like for the user to see only specific fields when he imports a comma, tab, of filemaker file from a different solution! TMAS

Hi I'm scripting an export for a system where several users will all be exporting their files to a central system. Rather than setting up all the databases individually, I want the script to say - export to a file and call it "Parish acronym" (field) plus "xmlexport" (real text). i.e. when all the files reach the other end they will be tagged with their own acronym. Is there a way to do that and still have the export run automatically with no dialog box? Rosie.

Hey folks! hope someone can help me with this one. I am experimenting with data driven graphics using Fireworks MX This technology uses xml as the database to create the data driven graphics from. I need to export xml from filemaker xml that looks like this: <?xml version="1.0" encoding="iso-8859-1"?> 001 Design By Coast 002 Peninsular OneSource 003 Dynamo Design and when I try to use the export xml feature it looks like this: <?xml version="1.0" encoding="UTF-8" ?> 0 001 Design By Coast 002 Peninsular Services I have figured out that i need to use …

Apologies if this is dead obvious, but I'm not finding an answer very quickly. From what versions of FM8 can one share a file as an ODBC data source? Thanks.

Whats the best way to move a record into a specific worksheet in a specific excel file? Currently, I'm exporting to a new .xls, copying the row, and then pasting it to the desired excel file and worksheet. Is there a better way? I'm beginning a project and this would be a huge help.

Hi Folks, I hope somebody may be able to offer some suggestions on a weird problem I am having. I am doing an import of a 5000 row excel spreadsheet into FM8 and are importing based on matching rows based on one key field. The import seems to work fine, but the resulting data in FM shows some weird symbols in the first field of the row on records that aren't supposed to have anything in that field, but these records do match the key field. Symbols such as #N/A, and random characters seem to appear. I am doing other imports and they work fine. It only seems to be when I am doing an import that uses the matching function. I have even tried clearing these fields i…

I am trying to create a method to import text from email orders we receive into Filemaker. Below is an example of the email text we receive. I would like to capture everything right of the ":" to a related field in Filemaker. I would like to let the user cut and paste the text from the email into a text box in Filemaker. The user would then hit an 'review data' button to move the data to related fields so they can double check the accuracy. Once they confirm the accuracy, they could then hit an Export button to move the data into the Filemaker Orders Database. USER/EMPLOYEE DETAILS: Name :Tim Burton BU Name :Southern California BU MU Name …

I've got a script that deletes a set of records from a table, then imports a new set of records from an external data file. The imported data values include foreign keys to a related table. The layout from which the import is being executed displays a number of fields from the foreign record. After import, the layout shows blanks for the related fields, despite the fact that the related record DOES have values in these fields. If I close FileMaker, then reopen FileMaker and return to the same record, THEN the foreign field values are displayed as expected. I expected that the related fields would be resolved IMMEDIATELY when a new record is imported, bu…

Dear Sir, I need a very small help.. If I receive any fax or phone call on my pc I want the fax no should come to my filemaker database...? Is it possible? Thanks and regards, Tusif Ahmad

I import about 20 pictures and they're automatically inserted into my Photo Catalog layout I have. Problem is when I post it on the web the pictures don't show up. I looked at the help icon and it says that its not web transferable. How can I make it so my pictures will show up (so it is web transferable) Thanks.

Hi all- I have built a relational database of about 20 tables, and am looking to figure out a way to archive records that represent "old jobs"; that is, completed, paid in full, and not to be seen again (unless i decide i need to re-import them). Essentially, I would like to be able to select a client whom i want to remove from my database. The script will then locate every record related to that client (every job, every order made to outside vendors, every invoice element, every invoice, etc), export that data into another file, then delete it from my current database. I realize this is a broad topic and there are probably several ways to approach this. …

I am a total newbie to Filemaker, but I managed to design a rudimentary database for my firm. My problem is this: I enter a record. Fine. Then it needs to be changed, and it overwrites the original. How can I save both? Any help greatly appreciated! Thanks in advance.

Hi, I am importing records using a script from Contacts.fp5 to Contacts Clone.fp5 over the network based on the last modified time every hour. Duplication of records happens and the more than one record is created in Contacts Clone.fp5 for Eg., Record ID12345 update time 14:00:00 Record ID12345 update time 14:30:00 I have checked the Import Action as Update matching records in current found set and Add remaining records. I am not sure even then why is the duplication happening. I would appreciate help.

Hi, This may be very simple. I would like to set up an Export where the Export is XML File using an XSL style sheet. I want the user to be able to select the style sheet from a directory everything else I will automate. I figured I could set it to reference a variable but I’m having trouble setting up the part of selecting the path file name to insert into the variable. Thank you in advance for reading this and any assistance.

I have to do a daily import of 1 to maybe as many as 50 dbf files that contain 1 to X records (usually under 5). Preferably I would like to have the dbf files saved to a directory and imported in one import step or at least scripted without the need for repeated input from the user. For now I have created a loop script that is set to import. Once a file is imported I drag the imported file to a "completed" folder and then double click the next file to import.... rinse and repeat. The import folder option doesn't work because the files are not .txt files. Is there any way to do multiple imports without user intervention?

Hi everyone, I've just started a new job in an office with a copy of FM6 on Windows 2000. They want me to build a client database that includes a function to take a client survey that's filled out in MS Word and import the answers into FM. Is this possible? I can't picture how it would work, other than possibly converting the questions and answers into an Excel format and importing that - but even that seems redundantly difficult. Is this a situation where cut and paste really is the best way? Thanks so much!

I have a small database that I use to keep scanned copies of documents i need to archive. At the moment i am able to import the files as pictures and using the file name can perform various activities with external applications etc. However i would like to be able to do the following: Import the file size with the image (this is so that i can screen erronous images) Atuomatically delete records based on date i.e. after 1 month from date of import. When deleting the records from the database delete also from the computer. I realise that the last two are not really for this particular forum but i guess they do have a relavence as i am sure others may …

Hi, I thought this would be simple, but I guess not. I have a field that I have used to generate emails from my FileMaker Pro 6 database. This field is formatted just fine, by using codes like & "¶" & "¶" & for returns and so on. I can't make things bold or underlined for email. Since these tags in email are just HTML tags, I thought I could add something like & "" and finally & "" at the end of a line I wanted bold, but it doesn't show up as bold text in the email client. (The raw tags are just shown instead.) I'm using Eudora 6.2.1 for Mac OS X, and I've sent a test email to myself to see if maybe the email client will make it ap…

Is it possible to alter the text encoding of a field or record export? I am trying to export the contents of a text field, for use in another application. Currently the text encoding is coming out as Unicode (UTF-16), but I need it to be either: UTF-8, Western (Mac OS Roman) or Western (Windows Latin 1). I can change the encoding in Text Edit and I assume write an AppleScript to do this automatically, but I'd prefer to have it all done within Filemaker if possible. Any thoughts? Thanks in advance.

Hi all, is it possible to just import a table of contents of a network drive (I do not want to import the files, just the file names and paths)? I know it's possible to import file references for images and text files - but how about any other file types (pdf, xml,...)? Thank you Berny

Is it possible to parse the contents of a PDF document? Alternatively is it possible to 'grab' data from a website that is displayed from another database (i.e not as HTML). Obviously I could simply cut and paste the info into a text file and then parse it from there, but I wondered if anyone had any other ideas? Thanks in advance.

Hi, I've been given a big text file that has info in it like this (tab separated): Stock Number: 22249 Genotype: y[1] w[*]; P{y[+m8]=Mae-UAS.6.11}CG8728[LA00703] Chromosome(s): 1;2 Breakpts/Insertion: 43F3 (R3 flank), 2R:3000001 (R3) Date added: 2/17/06 Comments: May be segregating CyO, J.M. Stock Number: 22250 Genotype: y[1] w[*]; P{y[+m8]=Mae-UAS.6.11}LA00720 Chromosome(s): 1;3 Breakpts/Insertion: 73E1 (R3 flank), 3L:16918704 (R3) Date added: 2/17/06 Comments: May be segregating CyO, J.M. Stock Number: 22251 Genotype: y[1] w[*]; P{y[+m8]=Mae-UAS.6.11}LA00734 Chromosome(s): 1;3 Breakpts/Insertion: 62B1 (R3 flank), 3L:173…

I receive a bank statement in XML format and when I try to import the file into FM, I always get this error "XML parsing error: Expected end of tag "Meta". I am new at working with XML files and would really appreciate if someone could help me figure out what is wrong. I have attached the relevant files. Thanks sample_files.zip

Hello! Would like your thoughts on how to solve this problem -> Problem: Export data from 7 tables to 1 file and then import data from that 1 file to the 7 tables in a different runtime solution My solution: Example 1 a) Create a file with the 7 tables and include it with the runtime (file A) : export data from the 7 tables to separate fp7 files c) create a copy of "file A" d) open the copy from within the runtime, then importing the data from the 7 files to "file Acopy" d) at last closing down "file Acopy" and returning to the main file in the runtime solution (of cource all this done with a script) Example 2 a) same as above …

Can FM Pro 8 import Microsoft pst files, such as emails, contacts, etc. I need to import a group of emails. Thanks, Gordon

To all that have the know how to implement what seems logically like an easy to solve problem (considering the power of this amazing program), I have a directory of text files (~600 of them) that were typed by my dad's secretary about 10 years ago that contain, in each file, one contact's information for an address book. Unfortunately (for me), the files are in no delimited format with which I could use a standard import to gather the data into the necessary component fields. I have included a zipfile containing a sample of the variations of the sourcefiles that I need to parse. I tried to choose the most diverse ones so that the algorithm suggested migh…

Hi, I am looking at creating a database that is based on images but the thing is i need a way of getting multiple images into the one record. I would really appreciate it if anyone can help me find a solution to this. Say i have 100 folders and within the folders are 20 or so images but i am only wanting to create 100 records. Is there a way i could import multiple images say into a container field or something as im not advanced with FMP. I know i could go and click import image with every image within the folders but i would be here forever and i just would assume there is a way around this. Again any help would be much appreciated, thankyou.

Hi, I am updating a Filemaker Pro database file version 5 i think (.fp5) I was working at the office on a mac in filemaker pro version 6v.4 to make changes to the current database. The program(database) is a label system which you enter some data in some text boxes, and then you select from a list of buttons on the side to decide what type of label you want the data to go on which type of label. i.e. a cd label, a dat label, a cassette label, etc. It works pretty well, (when it works). My job was to add a new style of label sheet to the list of labels. So that consisted of measuring out the different dimensions of the individual labels on the 8 1/2" x 11" sheet of label…