Importing & Exporting

Hi I am exporting the field contents of a calculated field. It has several returns in it. If I open the resulting txt file in wordpad the formating is correct, however if I open it in Notepad it is formatted as one long string with no returns. Is it possible to force this? If I open the txt file in wordpad and save over itself and reopen in Notepad it is fine. The resulting file is required to be inserted as the body text of an email. Any help would be greatly appreciated Regards ZP

I'm importing an excel file in FileMaker and am having a tough time trying to figure out how to get two fields to relate. I have a Policy Records Table and a notes table related by index id and policy id. What I'd like to know is, how do I auto enter the index ID by looking up the policy ID? The excel file I have has two columns: Policy ID and Notes If I import the records into the notes table, they don't display in the portal since it doesn't have the corresponding index id. Maybe its easier to see what I'm trying to do so I've attached an example file and also an example .xls file Any help would be greatly appreciated, thanks! You c…

I'm importing pictures into my database but stops after 25 images to tell me, "sorry there is not enough memory to complete this opearation" what the heck?

Hi I have a set of records that I want to concatenate where a particular field is matching, such as a security Number and then output a concatenated text file. Is this possible, if so how? I'm stumped! Thank you

I'm trying to import three files that are actually dumps from the three OUs in our Active Directory system to be able to maintain a valid list of users and email addresses. Unfortunately, all three OUs have different sets of information in them and therefore require different import orders for each. So if I run the script that runs the first import, everything works fine. If I run the second one, it breaks the preset sort order set in the script. If I go back and look at it, the sort order is all messed up. If I run the second and third sripts, the first one's order is then messed up, as well. I can't figure out what I'm doing wrong! Any help is greatly …

Can anyone think of a reason why a text file would be grayed out and not available for import? One of our members claims he cannot import the file. He is on a Mac so I can't connect and look at it but I have never heard of this and can't figure it out. There is a script to import the file and it's been working for hundreds of members for years so that's not the problem.

When I import from a file I am having trouble with the passord window popping up and having to enter the password as I import a file. I have a file "multiple tables", I have a script that will import a file into my file. As it imports and then changes to another table it will ask for the user name and password. Is there a way to get the file to import the file and not have the username and password dialog popping up on each table change. The file is FM 7 and I have users in the file. I will put the username and password in at the launch of the file. And it will ask me each time I import to a new table. Thanks in advance

Hi I was wondering if version 9 allows for referenced photo links to be associated by relative location rather than absolute location as is with ≤v8.5. If not does anyone have any good tips dealing with this (ie moving a Dbase solution to another drive breaks photo links.( I would not like to embed the photos as there are thousands.

I get customer list from my customer with customers who ows money to the company. The list's I get is in Excel (xml format). My problem is that some customers have more then one debt so the customers ID can occur many times. How can I get FM to ignore duplicates of the customers ID. But still I want to get one of the field's. So if a customer have 5 records in Excel I want FM only to import one and ignore the others. Is that possible and not to hard to do as I'm not an expert on FM?

Hi, Is there a way to import a txt file into one single field instead of breaking it up into multiple records? I'd like to import the whole content of one txt file into one field / variable! Any help would be appreciated! Robin

Hi everybody, I'm not sure I'm posting in the right section, so forgive me if I'm wrong. I need to send a part of the databese to a client but don't want to let him see the information concerning other clients. I have tried to export the files after a search to another file but It only sends the principle table of my database and no layouts. Does anyone have an idea about how to do that? Thanks in advance

What is the most effeciant way to send a record from one database to another database on the same server? I Have tried creating a relationship between them, but it slowed the system down a lot, when they were joined. The import/export method seems to work, but not sure how to trigger the import from the other database.

Well, I posted this last night and, if you view Forums, it shows my post. But the post is no longer there. So I'll try again ... I have spent hours and hours mapping a migration in Import scripts (many fields from many files). The fields are not in same order nor are they same names. I have matched arrows on hundreds of them. Then, we deleted some fields in the source files and all my maps break - every one of them - the arrows no longer line up to the right fields; they have jumped many fields off. It seems that joining two fields in the import map (in scripts) does NOT hold. This is ridiculous. Once you click the arrow between fields, they should stay J…

I'm a bit hosed. I have very long import maps scripted. The field names coming in are totally different and the order is different. I had about half of them mapped (the arrow pointing between fields). During this time, fields were deleted in the Source table. All my arrows moved and mismatched the fields! Once I have placed an arrow, it should NOT MOVE. I understand if unmapped fields move but not ones I've mapped! This has cost me hours and hours of work and I'm one unhappy camper tonight. LaRetta

I have a container field which contains a file reference, and another field that displays the path to that external file. I'd like to make a script (button) which simply reveals the original external file in the OS X Finder. A calculated Applescript may be the answer but I have no idea as to syntax. Suggestions??

I just found out that my import/export functions are disabled when using IWP. Trouble is that my database has to have the ability to import a few files a day. It seems that the only way I could do this would be to have an "off-line" database that acts to import the required files and, at the end of the day, manually update the "on-line" database via IWP. The problem here is that more than one person will consistently be importing files to the database. This creates several complexities and organizational issues. Does anyone know a trick or a method that will make this import process less tedious (with IWP)?

hi. is there e way that when i export data, the field name in included as first data on the exported file? thanks

I've got a script to import data from a text file. It's just one record at any one time, and the script is working fine using the Import Records command and a file path such as file:../ImportThis.txt However this system will be used by a number of different windows users, and the database won't necessarily always be in the same directory as the import text file. What I'd like to do is have the text file in the windows user's home directory (c:Documents and SettingsUser Name). This is referred to by the windows environment variable %USERPROFILE%. So in theory in Filemaker I could then get the script to look at the path %USERPROFILE%/ImportThis.txt Ho…

I'd like to develop on a clone of my production file and later switch out the production file for the revised copy. However, this would require me to regularly import the current data into all 100 tables of the revised file. Is there a reliable method to automate data imports to multiple tables? Thanks in advance for your help, Donovan

To make my database user friendly, I would like to have the user click a field that then displays a related image, instead of forcing the user to drag, drop, and re-size the image to fit the field. For example, say I have a directory on my server that stores employee images. I then want a button (script) in my Filemaker layout that will insert and re-size a JPEG image ("employee picture 001, 002...") that is directly related to the primary key ("Employee ID 001,002..."). I have had trouble with this since it seems that you can't relate container fields (The container field cannot be selected in the relationships window). Now I'm thinking a container field isn't the w…

Greetings... a quick question from a new developer. Is there a way to attach incoming email to a specific contacts record? Thanks, -Dgee

I have a text file with fields seperated by the pipe character " | ". If i create a tab seperated file in Excel from this file, it stops at 65,000 records (there are over 100K records). is there a way to import the text file directly into FM and designate the delimeter as the pipe character to create the fields so i dont have to deal with the Excel limitation? Or any equally suitable alternatives? Thanks!! afterthought: i guess i can replace the pipe character with a tab in MS Word, but ideally id like to avoid this extra step

I am having attaching some files via refererence. I was able to successfully attach 3ds Max files via reference before. With a rather large delay. But now filemaker will crash whenever i try to attach a file. Has anyone had any trouble with this before?? Even with other data types? And is there a fix out for the sound file within quicktiem bug on windows???

With the export as fp.7 the message window says rebuilding depencies - what does it mean exactely? Export file is ok Thus I tried now without success Compress clone restore The error moves somehow - it is however in the fieldnames starting with A contained of 100%, if I do not omit these bring FM a message. Sometimes the export works even if I the field names V-W omits. It is all the same whether all DS are exported or only one. For what can one look for thus formula names wrongly? Relationship wrongly? Someone has notion where one best begins. The database works also with this restriction otherwise correctly. How does one go to the prob…

Hi, I want to transfer contact data from fmpro 9 to my Motorola Razr ( I just purchased the Motorola Phone tools which works with outlook express' contact database ). I browsed through the previous posts on fmforums and the only way mentionned is to export through vbscript which I know nothing about. Is there any easier way to achieve my objective? Any suggestion welcomed.

I am having trouble with imports requiring passwords for each table that it switches to. Is there a way once the user and password is given it will not ask for it each time. Thanks in advance

Hello-I am looking for some help, maybe even a starting point. I would like a user to be able to select either single or multiple fields from multiple menus, and then have each of the selected fields exported to Excel. For example, say the user selects #'s 123,125,126 from a "Product" menu, a range of dates (6/5/07-6/8/07) from a second ("Date") menu, and selects the desired output from a third menu (say, "Total # sold") for each Product ID. I would like Filemaker to then take only the user requested data and export it to Excel. I already know how to do this with Filemaker's "Export" menu, but I was hoping to make it more of a "user-friendly" function. Any idea…

FMPro9 . daily reports from a online storefront are emailed to me each morning. File sent is a .csv file and imported into Filemaker for manipulation and reports. Import script is simple clear out old records and pause while you navigate to folder to select the "file of the day" On Mondays, there are multiple orders waiting for FRIDAY THROUGH SUNDAY IN SEPARATE FILES. When the import script is paused for naviagtion to the file, I can not for the life of me figure out how to add more than 1 file.. Import is not selectable when it is called from the script and paused.. What am I missing? Some sort of loop section in the script? Not a real biggie, but, an anno…

I want to import data from an excell file into my filemaker database. I have a huge list of movies in my database and i have the same list of movies in excell with some extra information with them that i want to import into my database. Normally i would use the title of the movie as "primary key" to make sure all the extra info will be listed under the correct films in my database. Only problem is... The films in my database are listed like "The green mile" and the films on my excell file are listed as green mile ,the. And there are probably some other things that aren't the same but i don't know that yet. For the moment i would like to create a …

Hello I don't think this is possible, but I ask anyway: if a user is externally connected to a Filemaker application over the Internet using Citrix, is it possible to save a record as a PDF to a location in the Filemaker application’s environment rather than locally on the user’s PC? This user has no access to the environment the Filemaker application is in. Paul

I constantly have issues with my files whereby the field mappings constantly mismatch. Just to describe the situation: I have a 'master' file running off of a server. This regularly has additional fields added to it's tables. I then have a series of local files that have data imported into the master. They regularly have extra fields added to them. The problem is I have hundreds of local files run by many users, and upwards of 10 complicated import scripts in the master. What I find is happening is that almost everytime I add (or maybe delete) fields from one or both of these files, the mapping goes askew and i have to remap everything. I …

Hello, Can someone help with with this script. I have FM 8.0 Mac and want to write a script to export records of type merge. If I export manually, FM will remember last Type of "Merge". However, if I try to script it, the export keeps defaulting the Type popup to "Tab-Seperated Text". Simply, I want to write a script to export of Type "merge." Thanks, Denis

I have a fairly complex database that occasionally needs to import data from an Excel spreadsheet. The import requries pretty heavy processing and a very large number of calculation fields. So I decided to put all the import processing in separate filemaker files that would only be opened if an import was attempted. The import file processes all the data successfully and exports to a filemaker file for temporary purposes until the main database file can import it. Works great except for one problem: any time after the first import, the exported data is ADDED to the temp files (overwrite was selected when adding the file to the export script), therefore I endup with way to…

i have a contact db solution with contact and contact log tables. usually one does make an entry, adding a new log and the log already comes with a timestamp of the creation date. now we have to enter manually a large list of entries, especially log entries made on paper during the last 6 months so: how can i override the timestamp entry in the log? The best solution would be: adding a new log record the timestamp enters automatically but the typing person could still change the field data. thnx.... hans

: I have just been handed several floppies with filemaker 5 data that I am supposed to export or open in Access 2007 for a not-for-profit that I volunteer for. Can someone please tell me what I have to do to get them into Access 2007? Thanks. CJ12

I'm using 8.5 Advanced and 9.0 Advanced on a Win XP platform. I'm about to move my solution onto a commercial hosting site, and I need to make some changes. Currently, I store graphics in external files and only save the file path/names in the data record. Somewhere along the line FMI added 'Export Field Contents' (anyone remember which version?) that would allow me to store the graphics on the record, and then get them out. If I store them on the record, I'd have to export them to an FTP site. How (remember the DB will be on a hosted server) do I do that? Should I not store them in the records and put them directly on the FTP site? Then, to display the graphi…

Gday! At the moment when I export into excel, a new file is obviously created with no formatting. What I would like to be able to do is have a 'pre-formatted' spreadsheet that the data just gets added to. I hope this makes sense... Is this possible? It's just that this export needs to happen on a daily basis and needs to be presented to the marketing department, so it would be much easier to have a pre-formatted spreadsheet rather than having to 'make it pretty' every day... Cheers!

Hi all. I need help. I am a FileMaker Developer and I need to create a script to import data into filemaker from a text (TXT) file. Here's the rub: the data is being exported from some ANCIENT pc-based application called DataCenter Plus, and it only exports data into a nice neatly formatted txt file. That's great for the final text file, but it's not ideal for importing raw data. (There is tab or comma-separated exporting option, etc.) This is the ONLY way I can get data out of DataCenter Plus. There's no other way to export data from DataCenter Plus except for in this formatted text file. DataCenter Plus can export data as a single record, or as multiple r…

When importing from one file to another is there anyway to sort or specify the left side (source file) field order? I know it is possible to sort the right side (destination file) field order by name, field type, matching names, etc. But trying to find the field name in the source file can sometime be a tedious task, especially when there are hundreds of fields. I don't know if this is a limitation that pertains to version 6 or if FM has fixed this in later versions?

I know you can export a FM database to an excel file. What I don't know is can you name the exported exel file base on a calculation?

hi I am converting from ver 5/6 to 8.5 I have a daily routine to import data using a csv file unfortunately one of the fields can and does contain " single occurances of quotes, as part of a description..the problem is wheras the old version had no problem with this ver 8.5 does and on import i lose hundreds of records! altering the source is not really an option..importing via excel works perfectly but this would add an extra complication to the process......ideas would be greatly appreciated

Hello, I recently was given a some .fm3 files that I need to open. FM8 told me that I needed to open them with version 4.01. I didn't have that version but was able to get a hold of FM 4.1. However, on both the Mac & PC I get the following message: "This is FileMaker Pro Release 4.1 "(name of my file)" was created by version 4.01 of FileMaker and cannot be opened by this version. Please call FileMaker, Inc. Technical Support." I looked through FM's Knowledge Base and found something suggesting I use the "Recover" option. This yielded another error message (again on both Mac & PC): "The file "(name of my file)" does not appear to be a FileMa…

Hi, I have a Contact.fp5 file that I need to convert into FileMaker 9 Pro. The file opens ok and works in FM5, but it won't open/convert in FM9. The error message when opening in FM9 is: Contact.fp5 was not created by FileMaker or is severely damaged and cannot be opened. Yet as above, it opens and works ok in FM5. I get the same error message when trying to recover this file in FM5. So, the only option I have left is exporting the records, but this file has scripts and layouts that NEED to be carried across. Is there any way I can get these scripts/layouts exported with the data, or get around the above error message? Thanks very much/...

I have a file that I use as a reference or "lookup" file and need to update the data daily. This file contains approximately 20,000 records and 40 fields. Daily I will refresh this data by importing records from a .csv file. The import will update existing records and add new records. This action will be performed by a script and initiate via a button or menu option. Here's my question.... What would be the fastest way to update my reference file? Importing from the .csv file seems to take an extraordinary long time. Would it be faster to covert the .csv file to a Filemaker db and then use the Filemaker file as the source? Comments & recommendations …

I have a file I want to export the data. I have multiple tables. When I export the Data from all the tables I then would like to import them into another file. Both FMfiles are identical When I go to import it will show the main table I started with but it will not show the other tables in the file. So i added a new layout with all the fields in all the tables. I exported and then when I tried to import the same thing happen it just showed the main table to import to. the file with all the data showed all the files FYI. Is there a work around without using scripts to import export each table. Thanks in advance. : :

Does FileMaker 9 support importing MS Office 2007 Excel files (.xlsx)? I tried and it didn't seem to have .xlsx as an option? Please let me know if you know when they are planning to support it. All our clients are being upgraded to MS Office 2007. Thanks.

For some reason when importing data from one table (CompetitorMembers) into another (same FM file) table (ProjPartners) it always wants to import ALL records not just those in the found set. I can usually do this and have scripts already doing so in the same solution (with different tables). Why is it importing ALL records from this table?

Is there a simple way to occasionally archive a few records which may have data in a number of tables to a secondary db which has the same structure as the first? I'd like to be able to move records out of the main db on a regular basis, but not delete them altogether. Thanks

I need to create a simple runtime application that allows (non-technical) users to create customized HTML template(s) on their own PC for uploading to their own websites. Basically the user will click through a couple of screens inputing data into fields (their name and contact info, etc). FMP then needs to output the data fields within the context of an HTML-type file template (it's HTML, but it's not an HTML page- it will be uploaded to a content management product so the headers and end tags are removed). Ideally I would like it so all the end user has to do is a simple "select all" then "cut and paste" from a screen within the runtime application because …

Is there a way to import into repeating fields?

[color:blue][color:blue]How do I toggle between exporting different subsets of [color:purple]fields I use File Maker pro version 6.0 on a Mac and would like to know how I can easily export different subsets of fields from my records. I know how to cherry pick the fields each time, but that is tedious when one of my subsets contains about a couple score of fields, another contains a different few dozen or so fields, still another may contain several baker's dozens of fields and yet another may contain a completely different bevy of fields. In my work, I have to switch amongst exporting these different subsets. I know how to duplicate the entire file and to set the def…

What do people do when they make a new version of their file and export the information-- what happens with pictures, sounds, and movies in container fields. How is that backed up to someplace else and reimported or placed into the new files. I have graphics which respond to conditions in a file and they are are .jpg files in my database. what happens to those when I try to upgrade my file. Is there anyway to deal with this problem of not being able to export or import container fields. I can export as a filemaker file. But I have several tables in it with sounds and pictures. Does every table have to be addressed or is there a way to export a filemaker file w…

I'm getting a flat file from an MIS department and I need to update my solution's information with any new information. I've decided to import each record into an "imported data" field then parse it and set it into its appropriate fields, then do a "compare records" to update my existing data. My problem is in the parsing of the data. I can direct how I'll receive the data (i.e. csv, tab-sep) and the order of the fields. But, I cannot direct how many words will be between each separator. Does anyone have a good recommendation for moving through a field of data (of no pre-set field length or characters)? I tried LeftWords, but some fields have multiple words. If I…

I am using Filemaker to store large quantities of data for export to PAJEK, a program used for social network analysis. Two issues have come up for me. Because the processing takes a very long time (several hours running in background on my Mac mini), I would very much like to have a widget that monitors progress, e.g., by telling me which of several hundred events the script is currently working on. If anyone knows of one, I would be very grateful. The other problem is more serious. Serial numbers used as primary keys in the original data contain gaps where records were created and then deleted due to data entry errors. No problem for Filemaker as long as relat…

Running into a small... well large problem and hope someone here can help. I'm exporting my filemaker file to a csv file but that file is formatted for macintosh and I need it formatted for windows. Any ideas? excel doesn't help due to it's terrible conversion of fields or text being too large for it to handle if imported as "text." I guess I'm looking for a program that simply converts mac csv files to windows csv files or a way of doing it in filemaker. thanks

Hi, I have a database of real estate clients with all their information (address, phone, etc.) I also have a file on my computer for each client with contracts and other paper work they need to fill out when buying a house. (about 40 documents) What I want to do: 1. I would like to be able to go into my client database and from a layout get to all of the pdf files. I have tried making a layout with a bunch of containers but it is always tacky and hard to quickly view and print the documents. 2. I would also like to be able to import the documents hassle free and have missing documents highlighted. Thanks for any suggestions you might have, I have…

Hey guys, You helped me out a few years ago and... Things have been running smootly for two years, but my G4, 10.4.10. crashed and burned. I had it repaired, but now when I try to open my FM billing files, it won't open. I get a message that says, "this action cannot be performed because this file is not modifiable." I don't use the application but once a week, but I love the way it is layed out. Am I doing something wrong, or is there a simple fix? I am a FM novice, so I apologize in advance. paul

I'm trying to consolidate several databases into one by importing the filemaker files themselves. It's working mostly, but there's one problem: The containern field contents aren't getting imported. The container fields are ending up empty. (They should have various documents in them as objects) How do you import container field contents? I understand that if I was exporting to text-based formats like .tab, .xml etc they would get thrown out for obvious reasons, but why are they getting thrown out when importing the filemaker files themselves? Are there any export formats that will allow exporting/importing cotainer field contents?

I've got importing figured out in general, but I'm having problems importing data into a portal. I've got three fields in the portal name_first, name_last, and Pin. In the import I've set what goes where and can see in the preview that it is matching up, however when I click import though it says that the number of records imported is correct, nothing is actually imported and new new records have been created. Thoughts? Thanks, Matt

I am creating an import between two files hosted remotely. I have got my fields to map correctly whilst importing records. I will no doubt be making changes to both the source file as well as the target file by adding new fields. If I add new fields, FileMaker naturally tries to map it against a blank field. Is there a way to stop new fields being added in the database to appear in a import dialog box.

I am having some trouble exporting the exact data I need from two tables (a one to many relationship). The main table has a record for each set number, and the related table has a record for each individual item number with a field that says what set number it is in and is related back to the main table. So it looks like this: Main table: SetID# (unique) SetTitle Related Table: Item# (unique) Set# (many, related to SetID#) What I want to do is export (to an excel file, ultimately) The SetID#, SetTitle, and ALL the Item#s related to each set, with each Item# being in a separate field. But I can only get it to export the first related Item#, not all of t…

I am rather new to FM, or at least have not touched it since v2 or so.. and I am running into a few issues which I have had trouble finding specific answers for.. any help is greatly appreciated. First one: I am exporting data from a report sent to me, all imports peachy except the date. In the Excel file, it is written as 01-Feb-2006 and I have dates formatted in the DB as 02/01/2006. Previous imports converted the dates to the desired format, but this last one has not. I tried to conduct a search to find those records and delete them (then change the date format in Excel then reimporting them) but it won't let me search by that date format. I found a script …

I seem to be having problems with my imports. First, the URLs that import to the picture fields only show the URL and not the actual picture. This does not occur if I manually enter the URL in the IMPORT PICTURE area. Secondly, when importing data to checkbox or radio button type fields, the fields do not respond to the data and nothing is selected. I appreciate any and all assistance on this matter. Thanks. - Wagner

I was wondering if someone could help me with this record merging problem. I'm creating a database where I create the records, and fill in all fields but one, which is a very long text field. I will be distributing the database to a number of different people, who will each modify the field. After that, I want to reconsolidate the database. What would be the best way to do this? Is there a way to use the import/export command in thsi way? Word has a function that lets you compare and merge documents - is there something similar in filemaker? thanks!

Hello, I'm a Filemaker newbie but trying to learn as much as possible. I'm currently working with FM9 Advanced. I'm looking for some help/instructions with importing multiple files into my DB. I'm trying to create a database for a project I'm working on. There are a lot of different excel sheets needed for this project (each group involved has their own with specific fields). Some of the fields are the same (phone number, user ID etc). I'm trying to use FM to import all the different files and use relationships to pull the data together to show update, changes and info needed for different parts of the project. Here's an basic outline of the project. All …

I am having enormous trouble finding information on how to migrate my old phone log (with 4500 names and addresses) from Filemaker Pro 5.5 into my Mac address book. Anyone have any peachy ideas on a plug-in or anything that might work?

Hello, I am glad I found this forum and I hope a FM genius can help me solve this problem: I recently upgraded from FM 6 to FM 8. I had to upgrade numurous databases as expected, but unfortunately, in the update from FM6 to FM8, one database that had images in a custom field lost almost have of the images! The oddest part is that some images can through, and some not. Now, as far as I can tell, this issue is because the images were either embedded or linked, and in the update/conversion, the linking or embedded-ness of the images did not transfer. However, I cannot tell whether an image is linked or embedded to beging with! Although I updated the databases, I …

I have a file in which I used the feature of formatting text within Browse mode and the format follows the text from layout to layout. However, when I save as Excel or export to Excel or .tab or .csv it loses this formatting. I have tried all of the maintain formatting (which appears to relate to numbers more than text) options I can find. I can export it to pdf but I need it to end up in Excel. Please help me. I am supposed to send an Excel file to my boss tonight or early tomorrow.

I'm using Excel to take loads of raw data and then apply some maths and condense it into a template which I can then import into the database. My excel files all use text and logic functions heavily to condense the data so there are 1000 rows in the excel import sheet that can be filled if needed depending on the number of records I need to import. These rows all contain formulas but appear empty by using "" in the IF statements. Regardless of what I do (saving the file as text, removing all formulas), Filemaker always imports 1000 records, even if the majority appear empty. The only thing that works is if I copy just the filled rows in excel and make a new…

Hello All, I am working on a system in which I will have a centrally hosted database. Let's Call It "ServerVersion.fp7." My remote users have limited network access and in some cases no access. So there will be a client version. Let's Call it "ClientVersion.fp7." So my Client will add records and work off site and come back to the office and want to sync their data to the server version. So what I have setup is a Calculated Primary Key. It uses a serial number, hostname and host mac address. So the relationships are solid and should be unique enough to not cause any Calculated PK duplication. Now my issue: I can import data fro…

Hi Guys, Ive got a table of data which I want to export into a CSV file. When I do the export, filemaker places "" around each of the field values. Is there a simple way of preventing this behaviour? Many Thanks Jalz

I'm importing data into Filemaker (version 8.5) from an Oracle 8i database. All goes well except for columns that are called "long" by Oracle. These "long" columns can contain lots of text and are (I think) not indexable. The text in these "long" columns imports fine except that there are some extra characters at the end or the beginning of every line. The characters appear to be spaces and rectangles but they are not easily selectable with the mouse or arrow keys. I tried substituting these character with a simple native Filemaker carriage return but no luck. Anybody know how to how to clean them out after the import or better yet prevent them from being import…

I cannot figure out how to export subsummary data. Filemaker help mentions that the data needs to be grouped but I dont know what they mean by that. my report works great when soting fields and viewing with preview but how does this translate over to an export. Most any standard export would work. Thanks, Drew

I have a script that imports the contents of a dozen tables from the previous version of my application (I use the separation model) after I've made structure changes. The actual imports work fine. My problem is this: even though I have the "run with full access" option set, the script pauses at each import and requests a login to access the previous application file. How can I cause it to carry out the sequence of imports without me having to login twelve times? I tried adding a "Re-Login as Admin" script step before the series of imports, but that didn't change anything. I'm only using the Guest and Admin accounts at this point and either one works at the …

I have a mysql database and in this database I have a parent and child setup. What I am trying to do is import the newest child or if there are no children then just the parent. So if I have 4 entries for a name I want to import the newest entry. If I only have 1 entry for the name that one is imported. While I import I would like to check against what was imported last time I loaded filemaker to see if the entry is in the database. If it is not, import it. If it is and the information is the same do nothing. If it is and the information is different write over the current entry. Is this possible using filemaker scripts with ODBC connectivity? If so, can someone poi…

Hi All, So I recently got an older powerbook so I can do my filemaker 8 developement at home, late at night. I have a comprehensive relational database suite consisting of about 35 files in two folders (a main and a "support databases" folder). My issue is, I go home, I do some changes on a copy of the databases. then I come in at some point and I want to deploy my updated solution, which I may have been working on for a month or a day, depending on the additions I have made. In the meantime, 5 users in the office have been working on the real databases. So, I need to sync the two. Ideally, I would clone all of my new DBs, import all the data from…

Just checking if there is an easier way of doing this, other then copying values to varibles then posting to the new record. To answer the question of why would I want to do this, I have a customer service database, and if a problem shows back up with the repair with in 24 hours, thier is no charge and I just reopen the closed record. If it's past 24 hours old, I nesd for billing purposes create a new record, but most of the same info need to be brought forward. Ty in adavance.

I'm having a problem seeing images that have previously shown correctly. I created a stand-alone database in FM6 Developer and retain that format to fit with some of the users who have older machines. Images are stored as relative references to a Photo Library folder. This has worked stably in several systems (Mac OS 9, OSX 10.1-10.4, Windows XP, etc). A user switching from Windows XP to Mac OSX 10.4 cannot view the images even though everything is in exactly the same relative position. Her system is exactly the same as one of mine, with the single exception that hers is an Intel Mac while mine is a Power PC Mac. She is using the actual CD-rom to install from that i…

Hi! I've got a solution that uses ExportFM to generate images of different sizes that I use on my website: small, medium and a high-res blow-up that is supposed to be the four megapixel image that comes out of my digital camera(1704 X 2272). The thing is that if I edit an image with Photoshop before importing it into FileMaker, FileMaker treats the image as if it were 681 X 908 pixels, when in fact the image is much larger. It works like this... If I view the image within FileMaker in an enormous image field, the image appears as if it were 681 X 908. If I copy the image in FileMaker and paste it into Photoshop, I get a 681 X 908 image. If I use ExportFM with no…

I'm not sure what I'm missing in my import, but I am struggling to import address information from one FMP file to another. In the old file, the address is a lookup field which references another table, (not in the same file). I am trying to import this data into the new file. Is it not possible to import data from a lookup field? If not, can I create a field in the old database that will copy this data into a permanent field and then export it into the other database? I get a message that the import has occurred, and I have matched the tables based on primary keys, but no data! Any thoughts?

Hello all, I am looking to create a table that will allow me to aggregate my data. I want to be able to create a load file in excel with my perameters i.e start time, end time, category, etc... and upon loading, it will automatically populate my sales figures. Does anybody know how to go about this? Are there any good references on the web that could help me? Thanks in advance!

Does anyone have a good solution to export FMP data into a desktop publisher? I want to setup a template in a desktop publisher that users can modify, insert macros and then populate the macros with data. Adding to this, I want to a version to work on Mac & Windows and I will not know the number of pages until run time. Is this askng too much?

I recently converted some of our lab's old filemaker 5.5 databases to 8.5. Most everything is well and good, except a little problem that cropped up on Friday. We receive task orders from the NIH in excel format, and have traditionally just imported the data into new records in our database. However, since converting to 8.5, when we import the records, the incrementing serial numbers aren't generated for the new records. is this a new 'feature' of 8.5? or is this some kind of bug or glitch? We can do a workaround, by duplicating all of the records we import, and the duplicates magically take on an incremented serial number, but this seems like a lot of tediu…

Hi - I have been tasked to work with a custom designed FileMaker Pro 6 database with two files, one for contacts and one for organizations and both are related to each other. I enter both contact and organization data in the Contacts file and the organization info is automatically entered in the Organizations file. I need to import into these files an Excel file where each record has both contact and organization info. When I first made an import attempt. I discovered this was not easy. When I map the data between Excel and FM in FM, the organization fields are missing from the field list. Unfortunately I don't have access to the documentation from the dat…

Hi. A large text file imports on my Mac [dual-processor with 4 gigs of memory] in under 8 hours. My client is on a PC, and after 16 hours, he says it is only about 1/3 done. He got a new machine to handle this so he doesn't have to go over the network. Anyone have any idea why the huge discrepancy? And, more importantly, what I can do about it? Thanks much, Audrey Cole

Is it possible to import records and update the auto-enter serial number by script? I'm doing some development on a solution that is currently deployed. I am not doing the development 'live'. I want to work on the development copy, then import any changes to the data that have been made in the interim. I've put together a script that runs in the 'live' file that finds all the recently modified or created records in each of the 12 tables in separate windows. Then I run a script in the 'development' file that imports from each of those tables. I don't want to re lookup values (users may have modified those values and I don't want them to revert), or chang…

Hi, The department I work in used to use a word document as a form to enter some data, so it contains tables, information isolated in rectangles... We are considering developping a database using filemaker to store this information and my boss wants to know if it's possible to import it from the files we already have. I,ve done some reasaerch about it but I didn,t find anything helpful. Can anyone advise me? Thanks in advance

hi there! i'm trying to create a script so that records can be exported to excel omitting unnecessary fields. i thought to use the "export records" script step, define the fields i want to have exported then define the export format .xls but that doesn't seem to be possible. i can't define the export format without naming the resulting file. as the db will be shared i can't name the result file as i can't define the path...but i only want to pre-define the format to make life of the users easier. who can help me? thanks hans

I have a database that includes a city and county field. However, the data we imported uses "numbers" to link to another table (access database exported to excel) I would like to be able to import the main data, and then have a lookup/caalulation that essentially matches the numbers, then imports the actual city name. For example; Table 1 city=22, County=2 Table 2 CityID=22, Name=Los Angeles, County=2 Table 3 CountyID=2, CountyName=King I tried a "Let Function" but deleted everything (what I wouldn't do for an UNDO!!) Sorry is this is simple. I just do not want to maintain the city, and county tables after import. Thank you!

Hello- This is probably a basic question, but I can't find a solution. When exporting data to Excel, it all exports great, but all the data exports to one really long row. I'm exporting about 200 fields and it would be great to have it all appear in one column instead of 1 row. Any suggestions? Thanks in advance for the help!

I have a sql text that looks like this: SELECT CUSTOMER.NAME1, CUSTOMER.NAME2, CUSTOMER.TELEPHONE, CUSTOMER.TELEFAX, CUSTOMER.COUNTRY, CUSTOMER.POSTALCODE, CUSTOMER.POSTALDISTRICT, CUSTOMER.THECUSTOMERNUMBER, CUSTOMER.CUSTOMERGROUP FROM CUSTOMER WHERE CUSTOMER.THECUSTOMERNUMBER = '76250146' I would like to build a text, so that '76250146' is taken from a field within filemaker.

Hello, I am trying to import roughly 40MB of text into FileMaker and separate the incoming data into 2 fields; an ID field and a field to put the text into. The source file is a .txt file. A sample of the text file follows.. __F-997-341__ Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text __F-998-342__ Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text __F-997-343__ And so on... What…

Hello again. I'dd like to export a field value in an xml file. I'dd thought I'dd do it using a calculation field witch contains the raw xml layout. The problem is, in order that xml is valid and readable is neads a header line like this <?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?> the "" are my problem how to keep them as is. example : normally I do this ... "<?xml version="&"1.0"&" encoding="&"ISO-8859-1"&" standalone="&"yes"&" ?>"&..... etc... But this get's rid of my needed "" at 1.0 ?? How to resolve this ? Kind regards

Can you help me with the following export problem: Customer table related to invoice table When I select 1 customer the relating result can be >1 invoices. OK My Dbase is set up to show the last invoice inputted as first in a preview mode. Printing these invoices is easy ; I mean whatever invoice I select, It will print the selected invoice because I stated “print current record”. The problem is I’dd like to export the invoice as tab separated file. Suppose there are 3 invoices for one customer, It will always export the first(oldest) one. Even if I select another one. I can’t find the solution as in printing export only current record ? …

Greetings. I have a source of data that delivers 8 daily dbf files which I have been importing into my filemaker database. If I get lazy and don't update daily, I can end up with a lot of files! Is there a script or shortcut so that I can 'batch import' a folder of dbf files into my current filemaker database? I came across this thread http://fmforums.com/forum/showtopic.php?tid/177446/post/208717 which seems to discuss what I am looking to do, but I am not sure how to implement it. Could someone give me some step by step advice on how to get something like this to work? Many thanks! -Ryan

Hi there- I have a folder of excel .csv files, all formatted exactly the same (headers etc.). New files are constantly added to this folder. Is there a plug-in or something (perhaps filemaker can do it alone?) that would import any new files added to the folder automatically into a filemaker database that will reside in the same directory? Any help is appreciated Jay

A Filemaker 6 number field, formatted for currency, would update a Quark document via XCatalog in the same format - e.g. if the field looked like '£5.00' in Filemaker (although the content is actually '5'), it would update correctly in Quark. I have just updated my database to FM8.5, and now the prices come in as '5'. Does anyone know if I can change settings anywhere - XCatalog prefs, Filemaker - to get back the functionality I've lost? Otherwise I've got 400 pages and 3785 prices to put pound signs into!

Hi - I'm a filemaker newbie! At my office, we have downloaded a trial version of Filemaker pro 8.5, as we think it could be ideal for our contacts database. Currently, all the contact data is held on apple mac's address book, which only seems to be exportable as vcards (rather than .txt etc). Is there an easy way to import these records into Filemaker? .. I have read posts on here about 'data manipulation' shareware doing the trick, but am very confused about where to start! thanks so much :-) (by the way, we are on Mac OS X.4.6)

I've got 2 sets of FM files that are nearly the same except that 1 set includes some added features that were never added to the other set. I need to get that set upgraded to include all of the features the other files have, and I figured the easiest way to do that would be to save clones of the good files and then export/import the data from my old files into the new ones. I was shocked to discover that upon exporting to a temp FM file and then trying to import into the new file that the fields did not automatically match themselves up. They're named exactly the same thing. Do I really have to sit here and waste my time dragging all these fields to match the corr…

Hi All, Is there a way to open protected file directly via DOS Command? (Something similar to passing Account and Password for opening file via IWP.) Notes: I am using WinXP; FMP8.5