Importing & Exporting

hello, i am new here, so please excuse possible clumsiness. Problem: FMA 8.5 odbc connection does not even start up when trying to start odbc sharing as an ordinary user or even admin on my mac i get xdbc could not be initialized when trying to do this as root, i do not get this error message, but can not connect to the database. filemaker support has been working on this for several weeks now - alas no solution yet. i would be grateful for help w

Hello, I have two linked databases that my boss would like to take home with her to work on. One is huge (153 MB), because we store images on there, and my computer freezes up while trying to burn it - I was just wondering from you experienced people what the best way to work around this is - to take off the pictures maybe and just save the written data?

I am exporting summary fields grouped by a particular field as ".mer" files that will be imported by our payroll system (ADP). The column names in the export file must match the column names in our payroll system so I have named the fields in my FM database the same as in the payroll system. The problem is, when exporting summary data, FM changes the summarized column name. A summary field in FM called "O/T Hours" becomes "O/T Hours by File #" when grouped by File #. I know I can't have FM change the column names (right!) and I don't want to edit the export file manually. So WHAT CAN I DO? What I thought was going to be a very simple solution is turning into a …

I am trying to export a text field with multiple lines, but when you open it in "Note Pad" on windows, there is no line breaks ? The same file if opened in "Word Pad" on PC there is line breaks at the end of each line. What is this about ? I have used "¶" or without the quotes with no changes Any ideas ? is there another type of character to be used for line break in a exported text file ? Is this character set problem ?? I need it to look normal in "Note Pad" on PC unfortunately ! Any input appriciated. Xoomaster

|----------| | 3 |----------| | |----------| | |----------| Ok.. When I export my database from FM Pro to an Excel file, everything is grouped exactly how I want it. The only problem I'm having is with blank columns. As you can see above, I'm getting blank columns under the parent cell. I was expecting the 3 to be repeated in the cells underneath. This is happening to all the cells in the excel file. Rather than Excel assume that the cells underneath are the same as the parent, (which they are), I would like the blank cells to repeat the parent cell.. Any ideas? [color:orange]HERE'S a link to a diagram of the problem.

Hi, Using FMP8.5 on Macs only, I have a routine to: 1. view a found set as a report with summary data 2. export the summary data to a txt file 3. import the txt file to a FMPro summary table (NB. I am using a txt file since summary data cannot be imported directly from one Filemaker file to another (right?), and get(summary) fn will not work in this case). To prevent the temporary txt files from confusing users I'd like to locate the them in either ~/Libray/Caches or MacintoshHD/Library/Caches. Is there any reason that the Caches folders should not be used for thsi type of file? Should I use one over the other? Thanks, FT.

I'm using only Macs with Server 8 with client 8.5. My users have a standalone file on their clients. From time to time they need to upload new data to a server-side version of the same file. I created a script to: 1. find the required set of data on the client 2. trigger a script on the server, which then 3. imports the found set from the client The server-side "Import Records" script step will work fine with a hard-coded path to the client file. The problem is I need to define the file location with a variable. But when I use a variable in the path I receive the following error: ""ClientFileName.fp7" could not be opened. (Already open)." …

Hi, I'm new to Filemaker (running v.7, OS X Tiger), and I want to export some records into a tab separated file. I can do this via export records, but I only need about half of the fields, and I'm going to have to do it frequently. Is there any way to avoid manually selecting each field from the export records screen? I tried to create a new layout that only showed the required fields, but when exporting from it, I still need to select fields from the entire table. Does this make any sense? Thanks!

Hi All, I have just found a filemaker database that can import records into iCal. I like everything about and want to include all the layouts, scripts and fields and database (Basically everything) into my current database. How can i do this? Many Thanks, Dean

Whenever I import from excel, filemaker will take all the blank spaces at the end of my excel sheet and create a ton of blank records - what can I do to keep this from happening? Thanks for reading this!

Hi. I hope this is a simple question. I'm importing ~25K records from another file. The import goes fine, but it's the sort order that has me confused. I've pre-sorted the imported file so that in FM - after importing - the newest record shows first in a list of records. But then, when I add a new record in FM, it appears last in the list, and I have to sort the records to have them appear with the newest record first again. I want the newest record to be first all the time without a sort. Is this possible? Many thanks in advance

I am very new to FM and have both FM5 and FM8. I have an Excel Spreadsheet containing a subset of the variables I want to put into my FM database. This subset will remain fixed for each record. Is there a way to import these variables by name if the names in Excel matches those in the FM database? Each record represents a series of fixed questions (that I would like to import) followed by summary statistical information for each question which I am generating and will attempt importing from SAS. I noticed that the person (long gone) who originally did this somehow has an option of "auto-enter previous" on the fields that I would like to import by name. I am assuming …

I am trying to import data from an Excel spreadsheet. The data headers are set out in the first two rows and the data is stacked two rows at a time. Is there a way to convert the data to import into matched fileds in FMP?

Perhaps I'm missing something but I can't get Outlook to stay quiet when I email to more than one email. It keeps coming up and telling me that soemone is trying to send an email. Do I accept yes/no I shut off every security and firewall I could find. And Yes I have the no dialog selection in the script. Help Frustrated in Ottawa! The Filemaker part was easy! ;)

I am trying to import an xml file but I get a parsing error. Do I need an XSl stylesheet? Does the file need an .xml extension?

Hi all I import data from an Excel-file into a field, "Status". The data is all in codes, and I would like these codes to be "translated" into a litteral tekst immediately. ex. imported code "1232" is shown as "Member has re-registred" when imported. It seems like a fairly easy script, but I cant make it work. Any help from you guys? Regards Lasse

I have a video clip locator database which will have about 14,000 video clips from the past four years and growing at roughly 4,000 clips per year. When the clips are imported either into FCP or iMovie they are named Clip 1.dv, Clip 2.dv etc for each project, so with seven or eight projects a year there may well be 24 Clip 1.dv's. As each projects clips are held in seperate folders, when the clips in each folder are imported into the database, is there a way to automatically get the folder name or path name into a clip location field or do I have to copy and paste the location via a loop into the clip location field after each folders clips are imported.

I got a high priority job a couple weeks ago just as I was starting to use FMP. I enlisted a buddy to help me. He ported the Access db we had been using to an FMP db. Then I modified it ever so slightly. He had made a value list on two fields and I created fields to relate to the values in those fields. I'm not sure if this is part of my problem or not, but it probably should be disclosed before anyone else looks at it. Part of the problem is that we are in a hurry and made two copies of the data we need to input. Although we tried to separate the data, sometimes we both input the same record slightly differently. Here's the problem. We have found that we c…

I'm not sure this is the right forum but I give it a try here. I have two costumer databases where each customer have a unique customer number. How can I compare the two databases and find if some customers are registered in both databases?

I've got an older DB in FMP6 that I need to export some data from. Whenever I export as a CSV, the file contains double quotes around my data fields. The program I need to feed this data to can't interpret the quotes. Here's one record as it is exported: "000011015","ACT","COM","11/11/2006","29","11","3/14/2007","3/14/2007","1","A08421","P000011015" I need: 000011015,ACT,COM,11/11/2006,29,11,3/14/2007,3/14/2007,1,A08421,P000011015 Of course I can do this manually, but that's silly. Anyone know how to export a CSV out of FMP6 without the quotes?

Hi All - Any help on this would be great. I am trying to batch import via script ISBN Book Information (using isbndb.com). Basically, the script pulls the ISBN and the Books Title from an excel sheet. It then goes to ISBNdb.com to get the remaining information (Author, Summary, etc.). The problem is that the xml import from ISBNdb.com. The script selects the ISBN correctly from each subsequent record in filemaker, when the data is imported, it always re-writes the first record. I would use a match import, the database does not include a return of what you requested. I believe the problem is with the style sheet - please see below, but any thoughts wou…

I have a simple import routine that goes from table to table and imports data from matching tables in a folder called 'temp' which is in the same folder as my solution. This is part of my upgrade routine. This script works fine in the original solution but as soon as I create a runtime of it the import routine just doesn't work. On further investigation if I open the runtime files with advanced and look at the import scripts the actual import steps have lost the source fields. The file refs are there,the folder 'temp' is there and the files are in it but as far as my runtime is concerned the source has gone. Can anybody help me with this please. I am…

I am having a perplexing problem exporting a date formatted according to the layout's formatting. My export script and it's formatting has worked perfectly for over 3 years. I have been exporting from this layout with the formatting working perfectly - the problem is that I added another date field to be exported, formatted 2007-03-06 (for a MySQL database) - the formatting refuses to stick - the output file (tab separated) always shows this new field's data as 03/06/2007. There are other date fields on the layout that export properly - I have triple checked the fields definition parameters and the formatting - it is exactly the same as the other 3 date fields on the…

Am importing from an Oracle table where a Date column is null. Instead of placing "" or null into the FileMaker Field, it appears to put in some sort of time stamp i.e. 10:15:39. I've tried different FileMaker field types thinking this may be the issue (Date, timestamp, text) and still the same issue. Using RapidSQL to view the data in the table confirms that the data is 'null'.

I have the Quickbooks SDK installed and I have figured out the XML layout to add an invoice to quickbooks using the SDK. How do you tell Filemaker that you are using the Quickbooks SDK in scriptmaker? And how type code into the scriptmaker window instead of using the pre-defined commands? P.S. I don't want to use the add-in called FileBooks

I created a form for customer service to use for inputing survey responses. Some of the questions have "check all that apply" responses. When I export the data to a .csv file (since I can't find an option in FM6 to export to .xls), the responses to these questions are separated by what appears to be the male gender symbol, â�� (unicode U+2642). The problem this causes is that now I can't split the cell data across multiple columns. I need one response per column for sorting and statistic purposes. I can't do a find & replace either because it's as if excel doesn't recognize the character at all. I attached a snapshot of what I'm talking about. Any ideas as to h…

Hello, I am new and I am hoping that someone will respond to my question with steps I can follow: My Excel csv file is setup as follows: Date,Player,Game1,Score1,Game2,Score2,Game3,Score3 23/2/07,Bob,TPlanet,345,Rcar,232,Fjet,135 23/2/07,Kim,Gwar,239,Fboat,330,Fjet,238 . . How can I import each row to a record that has a portal similar to how the Games and Scores are shown below? Record1 Date 23/2/07 Player Bob Total Points 712 TPlanet 345 Rcar 232 Fjet 135 Record2 (you get the idea...) I have been playing with portals from examples and they work quite nicely but I need to transfer all my data in FM first. …

Hi, I am new to FM as well as the forum. I searched and could not find an answer to my question. I am trying to find out if there is a way to export Excel (column) names and values to a FM 8 database that has defined names identical to the ones on the Excel spreadsheet, but not necessarily ordered the same way. What I am looking is possibly populating a defined database structure by name. Only a subset of the names in the database would come from the spreadsheet. Thanks, JWM

Hello, I have a field with 15 sections separated by commas. is there a way to extract the data between each comma separation??? Thank you, Tom

Is there a way to import a folder of PDF files, as you can with images, putting each pdf in a container field? Import folder only seems to let me do pictures and text files. Is there a way to do this with a script?

I am using outlook on an exchange server. Can I leave a copy of messages on server and import them into filemaker or do I need to use a plugin. I am developing a salesman task manager that will track his clients, contacts and tasks related to those contacts. I would like to have a portal on my client detail layout where he can scroll through any emails related to the client. I have created a notes field that is timestamped and searchable, but to put emails in there would require cut and paste. I would like to have a table that has all emails to and from my salesman and then use the portal to show emails related to his clientname or clientcompany. Any guidan…

Hi, I have NO background whatsoever with XML, but I really want to be able to import data from the online database at pubmed.org to Filemaker pro using XML. I think I've figured out the command to get filemaker pro 8 to import the record I want from Pubmed, but I guess I need an xslt thing to make it work. My script command for Importing Records would be: Import Records [No dialog; http://www.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pubmed&id=9037774&retmode=xml; Add; Windows ANSI] Does that look right? I'll change it to use a calculation to determine exactly which id # to include. But then, I get a parsing error: Whi…

Is it possible to export an image in a container field to Word? and what about File referenced Images? Been searching awhile and all i have seen is text but what about images Thanks

Hi - I have an interesting issue: We have one machine that is running Windows 2003, Quicktime 7.1.5 and Filemaker Pro 8.0v1 that can export pdfs with images fine. We have another machine that is running Windows XP, Quicktime 7.1.5, and Filemaker Pro 8.0v1 that can export pdfs - but the images are missing? Has anyone here run into this issue? I did some searching in the filemaker knowledge base, but I didn't see anything. Any advice would be appreciated. Thanks - Nathan

Apparently.. importing DBF data fields work fine those MEMO fields if my DBF file memo fields are of DBT format... that which is DbaseIII and Clipper.. FoxPro uses FPT extension... Sounds that I need a utility to convert my Fox dbfs .. Have any FM programmers come up against this and anyone know of a converter

XML import does not work if the http request goes over an proxy. Is there a workaround on Mac OS Tiger? Thank you Tender

This may have been covered many times, but the search engine on this board doesn't seem to find it. I am new to FMP from an Access background. I have a database structure and input form I like to use, so I set it up in FMP and got it working. Then I cloned the db but didn't get the result I was expecting. Traditionally (using Access) each time I would start a new project I start with a spankin' new copy of my formatted database. Is it possible to clone the FMP database and have the key field reset to zero?

I have a report run on all the line items of products that have sold. It gourps the data together in the preview mode to show the total number of each unique item sold. When I export the info it exports like I were browsing the records. I mean each line item shows how many times it was sold and not the total. Example: Part: 1234 Name:Widget QTYSOLD:1 Part: 1234 Name:Widget QTYSOLD:1 Part: 1234 Name:Widget QTYSOLD:1 Part: 5678 Name:MYWidget QTYSOLD:1 Part: 5678 Name:MYWidget QTYSOLD:1 Instead of: Part: 1234 Name:Widget QTYSOLD:3 Part: 5678 Name:MYWidget QTYSOLD:2 Any Ideas?

Hi all Can anyone help me with this one: From time to time I import Excel-files into a field named, "Status". I would like to know if its possible to automaticcaly delete any data in another field, (called "Payment Method") if the imported data in "Status"-field are, f.ex: "Not member" Regards Lasse

Need help on this one. To be able to get a nice overview of current projects and urgent deliveries I would like to make a button, which will switch to a new window or layout, that shows all projects (table view or something similar) that have a closing date within one week of the current date. Is this possible and if so How!? Don't know how I would start scripting this one? Can somebody help me out? Thanks, Dutchy

I can import from my camera into FMP but each photo creates a new record. I would like to import all the photos on the camera into all the fields in one record. Is this possible, or do I have to import then manipulate the many records into one? Cheers, Greg

Unless I login as a full-access user, the Export Records menu option is grayed out. I've allowed all other user accounts the ability to export data (via accounts and privileges). If I log in as a normal user, then re-login as a full-access user, the menu option is still grayed out. This is causing me a major problem with a client, as they have to export data once a month for a mailing list. One last thing, this implementation has worked fine for the past couple months. I've tried doing a recovery and it didn't work. Occurs on 8.5 Advanced and 8 Pro. Any ideas would be MUCH appreciated! Thanks, Josh.

Hi, I am having the following problem: I have set up an Excel Web query that collects updated stock quotes every two minutes. I then want to import updated quotes into my Filemaker solution. However, Filemaker does not 'see' the most recent data in the spreadsheet, but only the data from the original web query. I have named the data range in Excel and select 'data range' when importing the data from the web query excel spreadsheet, but still FM 'sees' only the old data, not the updated data which is clearly visible in the Excel spreadsheet. Any ideas? Thanks. Russ

I've move a series of files to FM Server 8 Advanced but can no longer export from one to the other. I can import and see the option to define a remote file to import from, but not a remote file to export to. Not always the brightest bulb in the chandelier and would appreciate guidance.

Ok, I hate to sound like a total dummy, but I just don’t get it. I have a db with around 10 layouts. I saved a copy and I saved a clone so I could work safely with the data. I opened up the clone, and I selected the import file option…on the left side (source) I see all the layouts, however on the right (Target) all I have available is the first layout all the others are grayed out. And of course only the data in the first layout (because that is all I can select as the target) gets the data inserted…all the other layouts have no data in the fields when I open up the clone after attempting to move the data over. I have pushed and poked every b…

I am a long time Mac user, but a newbie to FM. I have a db in MS Access that I need to convert or import into FM. Is there a quick and easy way to do this? I have successfully imported one table via excel, nut it was a tedious job to export from Access then imiport to FM. I have too many tables to do it this way. Any help/suggestions/tips/encouragement would be appreciated. Paul

Hi: ¿Does anybody know a different way to duplicate a found set of records, other than exporting/importing?

I've written a little FileMaker Pro advanced 8.5 script to generate HTML and then export the text to a file. For some reason, FMP Advanced writes the text in Unicode UTF-16 Little-Endian. When I point Filemaker's WebViewer (or Safari or FireFox) to this FileMaker generated HRML file, nothing is returned because all the browsers expect the HTML to be in UTF-8 instead of UTF-16. The HTML I'm generating is a block of text that when executed, makes a request to Google Maps to plot a multi-point map. Does anyone know how to get FileMaker Pro Advanced to export text in UTF-8 format? Is there a plug-in that can do this job? I thought about using PHP to generate th…

How do I export the field names of a table?

Ok, so I have the importing from oracle down pat. Just a simple sql script, and since I'm not exactly sql savvy, the query builder was a huge help. Now, I'd like to export new records created in filemaker back into the oracle tables as new records. I can't seem to figure out how to do this, any advice would be very appreciated. Thanks

It appears FMPv8.5 importing a FoxPro DBF file with its accompaning FPT that is the MEMO variable field... FMP say missing DBT file... SO any ideas.. I tried renaming but it only allows for me to continue, not accepting field. I can get other fields to a new FM table but need this add from the memo field as well. Any tricks avail Thanks

Is it possible, when sending an email with the contents of the email being drawn from a field, to keep the formatting of the text (color, bold, etc.)? My email is coming out plain text, and I'd like it to be formatting as it is in the db.

I ready to cry! I convinced the owners of my company to do online registration and now it's a mess! Web designer sends me this file (forms.csv) and I need to get it in FMP file, I can't send it. And I don't know how to change it to the needed formate... I'm so ready to cry! Is there a way to set the fields import, and how can I divide up the flat database to import into two files? Gratefully, Kim forms.txt

I'm setting up a script to prompt the user for a text file and then import the data. That's all simple and good, except there's a problem: the text is return-delimited, but contains commas. For the sake of argument, assume it's a chat room log file. So the text file contents will look like so: AH: really good, but maybe later... BP: Yes, I know what you mean. etc... What is set up to happen is for the import to take each line and create a new record (which has a single field for now) with all the text. This works fine, except FMP for some reason insists on trying to separate the text by commas. So far I've been unable to find any way around this behavio…

Hello, I am trying to export my database into excel. I have made style changes to the format.. all case changes. When it exports it does not save it that way. It goes back to the original file I imported in. I have checked the save layout styles box and unchecked it. Where have I gone wrong? Thank you

I have a csv file using semicolon as the tab seperator, consisting of 300.000 lines and 16 columns; which is the reason why I cant view the file through MsExcel due to the 65.536 lines restriction in Excel. So I am trying to import the file to FMP but FMP doesnt recognize semicolon (: as list seperator. So I can view all data of 16 columns in the same column. I dont know how to change the setting for this. Any solutions¿

I have a filemaker file to import into a new solution in my solution I have a serial (ID) field for each record my import records dont so when i import my records dont have a serial (ID). Is there a way to import a file and all the records it imports it creats a serial number? Thanks TMAS

I posted the following on the forum under "Scripting" instead of "Importing", so I will relist. 02-19-07 05:46 AM - Post#241230 I am new to FM scripting and am at present converting over some old dBase programs and have a problem. I wish to import a file using details already stored as global variables, that is, the file path is in one global field eg. (C:folder1) and the filename in another (eg. file.csv). I have no trouble importing the file manually into FM but using the Import Records command, scripted, I can't find a way of making it refer to the path and filename using data from the pre-entered global fields. There appears to be a path & file choi…

Trying to do a really simple import that I have done before, namely importing an older set of contacts into a newer file, this time a modified version of the Task Management template which comes with Filemaker 8. I do the import as always, it says it works fine then nothing... no new records, just the same template with no records at all. When it displays the import Report at the end of the process it says: - 830 of 830 records created - number of records skipped due to errors; 830 (??!!) - number of fields skipped due to errors; 0 The weirdest thing is that when I look at the Record ID field, it indicates that the next number to be increased by is the c…

I'm in the process of transfering from v6 to v8.5 My solutions imoport data from MS sql on remote server. In v6 when the import is triggered there is a mimimal delay before the import starts from the remote server. But with v8.5 there is a deley of several minutes before data starts to import!! What I can see is that in activity monitor FM is said to be 'not responding' But there appears to be a large amount of incomming activity on my network - almost as though somehow data is comming from the remote server long before the import is ready to start. Can anyone suggest what is happening Thanks John

I need help. I have two FM tables/databases related by NSA LithTable (contains many NSA values with different LITH values) NSA LITH 100 Sand 100 Silt 100 Gravel Etc. up to 8 lith values per NSA. GridTable (contains 190,000 records of many NSA values with tons of GRID values per NSA) NSA GRID 100 -50 100 100 100 36 100 45 Etc. up to 50,000 grid values per NSA. In the LithTable database I created a portal into the GridTable database based on NSA in order to list all the GRID values for each NSA. What I want to do is export the LITH field values and all of the rela…

Hi, I hope I am posting this in the right place. I would like to send email to a group of clients, but each client gets a separate, personalized PDF. I can put the appropriate PDF in the container field for each record, but how do I get Filemaker to grab that PDF and attach it to the email? Does anyone know a way of doing this? Perhaps a 3rd party plug in? or maybe I am missing something built into FM Pro

Hi, I import data from excel to FM. Problem i am facing occurs when excel already has data which i clear and write new data. This new data should then be imported to FM. But FM still import the total number of previous rows. eg. number of rows in old data = 100, number of rows in new data = 10. (100 rows are imported with last 90 rows being empty.) Any solution to this problem will be greatly appreciated. Regards TG

Hello, I would like to see the count of the each product i have purchased for all of last year. I can import last years purchasing excel sheets (over 200) to file maker with no problems but that will make tons of records of the same product with different order counts from different times. I would like to see total inventory purchases of each product. Is there a way to import the records by importing the matching product codes while adding inventory (rather than updating) to the matching record and add remaining data as new record? Is there another function that will look up matching values between records and then add the inventory field for each record for a grand…

I have a basic FM pro question (I'm using FM pro 6 for Mac) How can I set up fields to automatically format text that I've copied from somewhere else (document, web page, etc.) so that no matter what the text attributes of the original text was, once I paste it into my FM pro database fields the copied and pasted text will have a consistent look -- i.e. always show up with the same font, size, color, etc.? As it is now, I have to individually fix all the various text attributes each time I copy text into my database fields -- a real hassle. I imagine there MUST be a way to set FM pro fields so that whatever text is copied into them the newly pasted text alw…

I need to import a directory full of image files. I have the image file names stored in a text field and want to display the images in a container field. Is there a way to import the image files to the container field based on the file name that is stored in the text field so that the correct image appears in the container field? Thanks...

I am trying to import data for use in records defining account info. I am using an existing excel template supplied by my employer. The problem is I would like to have some data that heads the page repeat within the accounts. Example: (A1)Quarter (E1) Department (A2)Spring 2007 (E2)Technology (A9)Name (B9) IDNum (A10) John Doe (B10) 12345 (A11) Robert Smith (B11) 00007 (A12) Janet Damet (B12) 01001 So basically I want to take the header info of quarter in this case its Spring 2007 and department in this example Technology and have it added to each record A10/B10-A12/B12. Do you know the best way to do this? I know i can add it to the exce…

I have to import a html-file on a daily basis. As it doesnt seem to be possible to import a html-file I open the file through Excel and import the data that way. A bit long-winded, but it works.. Heres my problem: Renaming the HTML-file to excel takes away the first digit in a datefield, if the number is zero( 010207 becomes 10207) Is there anyway I can force FM to read a five digit number as a date - Or have I done everything wrong in the first place : ? Regards Lasse

Hi all, i have looked in the forums and with the help of google to find an answer to this, but as of yet, i have no real answer. Here is my question. Ive built a database that handles a number of stats for a hockey league. What Id like to do is export the data when updated to an excel spreadsheet, which is no problem.... except that instead of having lets say 8 different spreadsheets and then me going in and copy/pasting them together in excel, id like Filemaker to export them all as one excel workbook with multiple worksheets? Is this possible, or am I chasing my tail looking for an answer on this? Thank you Brian

Hopefully, this is an easy one. As shown in the screen copy below, FileMaker inserts "non standard" carriage returns in text exported under WinXP. The file was produced by right-clicking on a text field and selecting Export with the filename of Untitled.txt -- and then opening with Notepad. Is there a simple way to either 1) instruct FileMaker to insert proper CRs during the export operation or 2) replace FileMaker's carriage returns in the text field itself with proper carriage returns before requesting the export? I've seen this issue discussed as part of more complicated data cases, but no one seems to have clearly addressed this simplest case. Thanks …

Is there a way to grab the filename of a file being imported? I have a FileMaker tool that's used to massage some data before it's imported into another system. The import file names are unique for each file (with the files selected by the user at the import step), and I would like to base the export file name on whatever the import filename was. I've read through the built-in Help docs and done some searching here, but haven't found anything yet. Thanks!

Anyone know of a way to export data into a csv file, but include the corresponding field names in the first row? From what I can tell so far, the only way to do this is to export to an Excel format. The problem is, the app that will eventually need to import what I export from FileMaker cannot handle Excel files and requires column names. I know it's easy enough to just open the exported Excel files in Excel and save as csv, but I'd prefer to go straight to csv from FileMaker if possible. Thanks!

Hi Can someone tell me how save an export fieldorder (and fields) so I dont have to move every single field i need everytime im doing an export. I guess its done by some sort of grouping but I cant figure out how?! Thank you Lasse

Hi, don't know if what I want to do is possible with FM. I am rather new to Filemaker. Within my database I have a project status field that is set as radio buttons. Phases 1-6 When I select Phase 1 in the status field I would like FM to go to or show the Phase 1 layout or tab. Is there any way of doing this? Dutchy

So I need to separate some lines in my export with line breaks. I added a replace to the proper field, which adds a "¶" character for each record that has a Network entry. In the display, it all looks fine. But when exported, the linebreaks have all been removed. Here's an example. This is how it should look: Network Network A Server A Server B Network B Server A This is how it exports: Network Network A Server A Server B Network B Server A What am I doing wrong?

I'm trying to figure out a way to import incoming faxes into a filemaker pro database. Any ideas? The setup i have in mind is one where the fax machine apart from printing out received faxes also saves them as PDF or whatever image format and then have those files imported into a database. What fax machine could also save the incoming faxes as PDFs or image files and how would you go about importing them in a database?

Hi. I'm importing records from another FM8 database. I know that the data that I'm moving may have some errors in it (does not comply to my field settings). So at the end of import I get the message of records skipped and fields skipped. Is there an error log somewhere which details which records were skipped and which fields? So I can pinpoint for the users which records they need to fix? Thank you

Would upgrading to FM 8 help me, given its support for file names in a variable? I need to export multiple files in one fell swoop from one database. I have a field containing the data to be put into each file. And I have a field containg the name for each file. I want to export one file for each record, and perform this for all of my selected records. That's all. Many uses for this, for example, for creating an html page to accompany each photo in a collection. Or creating a projection file to accompany each aerial photo. Thanks

I'm fairly new to Filemaker and am having trouble exporting records to a .CSV file. Most of the exported data is correct, except for some of the dates. One of the records is the date 2007/04/06 and is changed to 2007/02/06. Two other dates appear to be swapped. The only thing all affected dates have in common is that they are the last record displayed in a portal. The two records that appear to have swapped dates are the first and last record displayed in the portal. Only the dates are affected - all of the other fields remain correct. Is there something I'm missing..? Something I should read with regards to exporting data from layouts with portals..?

Hello, I have a field set up to calculate data based on another field that will have data imported from an excel file. What I'm discovering is that the calculation field is not calculating during the import. It will calculate when I physically enter data in the field (as opposed to imported data). Am I doing something wrong or is this a FM "feature"? I'm using FM 8 Pro on a Mac OSX. Thanks! Trish

Want to be able to send invoices directly as PDFs. Invoice layout has an EPS logo. I know the obvious solution is to use a bitmap, but if a client prints the PDF I want it to look professional. Is this a feature or a bug? Any way around this?

Has anyone here used OutlookOps to sync data between Outlook and Filemaker? Do you like it? I will be creating a database in Filemaker for my client's contacts, and will then export to his PC. He wants to auto-update both Outlook and Filemaker whenever he adds new contact information in either app. He wants to keep Outlook because it auto-updates his Blackberry and Plaxo. Thoughts? Got a better idea than OutlookOps? Thanks!

What is the best way to import MS Word .doc files into a layout to be viewed on the web?

Hello Forum. New topic, new challenge. I have a BIG statistic in my FM file that I show to the user using PREVIEW mode of course. The statistic has lots of summary fields and can be one page or several pages long depending. You know how it is. Question: I want to save THAT in Excel, NOT the underlying records. How to do ? : Yours Truly, Spongebob

Hi, I've Table1 and Table2 Table1 contains Ref Key AAA T1 BBB T1 CCC T2 Table2 contains Key Att1 Att2 Att3 T1 A1 A2 A3 T2 B1 B2 B3 T3 C1 C2 C3 I want to do an export from table2 that woud look like that AAA T1 A1 A2 A3 AAA T2 B1 B2 B3 AAA T3 C1 C2 C3 BBB T1 A1 A2 A3 BBB T2 B1 B2 B3 BBB T3 C1 C2 C3 CCC T1 A1 A2 A3 CCC T2 B1 B2 B3 CCC T3 C1 C2 C3 Yes, I know that it will generate more lines that I have in B, but that's what I want. So I've made a relatio…

I have imported data in to a text field in the format: 2006.09.29 The format should be: 29/09/2006 Does anyone know how i change it ? it's 120000 records.

FileMaker Server 8: Script to import from one table to another. Nothing imports although with dialog it shows 1 import, 0 errors. Is there something elementry I'm missing?

Hi, Im using one of those serilize by category functions and having huge problems when importing data in. It should allocate each item with a unique Serial but it seems to be allocating blocks of items the same serial. ie.GE1 GE1 GE1 GE1 .... GE2 GE2 GE2.... etc. Unfortunately i wasn't capable of producing this by myself instead i used a file from this topic http://fmforums.com/forum/showtopic.php?tid/183472/ and merged it into my database. Any help would be greatly appreciated. Cheers Elliot

I am getting an error when I try to import XML files, do I need to apply some sort of XLS format?:, and how would I go about doing that.

Anyone know how to open a finder window via script on the mac? I have a mac path i would like to have a button that will open a finder to that directory. Fred

I have a button that opens a file requester and then inserts the file selected into a container as a reference. My question is this, if there is already a file in that container, I would like the file requester to open up to the current directory (already stored in a field name container.dir) so that it is easier for the user to find the replacement for that file. Any way of doing that? Fred

I have a little idea that i need some solid advice in order to achieve. I think this is possible but am a bit confused as to the best way to do it. 1. I would like to have a global field that contains the image of a file icon 2. When I create a new record I would like to export the "Icon image" to a location (like the FileMaker Pro path) and name the file with the record ID "REC00001.jpg" 3. I would like to then import the File and have it contain the ID so that I can get it out of the container with a calculation. 4. The objective is to be able to drag and drop the image to a container field and be able to get the file name out with a calculation…

I am using php on my site to display prices for items, etc. It is pulling the data from a csv file that I create with Excel. However, all this data is also in my Filemaker Pro v7.0v1 database. I want to take Excel out of the loop and just create the csv files in FM. When I export the data from FM into a CSV, I get a file that looks like this: --------------------------------- "3223","Frog","0","9425","6500","5525","2275" "9510","Animatronic Frog Puppet","0","0","0","0","0" "3333A","Baby Green frog","0","5437.5","3750","3187.5","1312.5" "3335","Don's Pacman Frog","1","1812.5","1250","1062.5","437.5" "1841","Frog","0","137.75","95","80.75","33.25" "184…

This is my first post and I am totally new to FM.. though I believe it is the solution that I will be quite happy with once I get over a learning curve. My problem is that I have an existing db that is used for timecards. It includes first and last name, date and 6 fields each for Project Number, Job Number, Time and OT. I manage to do a direct import into FM with by creating a table with the same fields. But I am trying to figure out how to do a report broken down by Project Code and the sub totals of the Job Codes (Time is in Hours, OT is in Hours) in that project. Since the data in each Project Code field for each record can contain any project Code how can I…

Hi, How do you save pdf files remotely without having to connect to the computer through personal file sharing? Is it possible?

I'm trying to create a program that will take the data from our custumer management app and allow us to run a monthly tax due report. However, when the "payment date" data is exported from the custumer management app(not a fm app) it is formatted in one of two ways in the same field. Ex. 12/1/2006, which imports into my fm app fine, but the other way it is formatted,ex. 2007 112, does not. The program dumps the data in dbf format. Is there a way that during the import data step, I can change the date to import properly. Thanks

Hello, I have my database working ok. But, now I have received image files (jpg files) and I want to import them into the database. I would like to link them, not store them in the db, as they are 15,000 files. The import pictures function get all the files unsorted. Is there any way of modifying the databse so record=1 gets file=1.jpg, record=2 gets file=2.jpg, and so on? (even if the file is missing, I would still like the reference to the file to be created). Thank you.

I am sure this is a common problem. I exported a calculated field that is set up for 100 repetitions. It is a simple calculation "quantity" x "price" = "total." All of these fields repeat 100 times. I would like to export these to excel. Then change the format to a $ for the price and total fields. When I try to change the format it will not allow me to change it to a $ sign. Because of the repeating values? Any suggestions on how I can fix this?

Hi All, I am trying to find a way of creating a script that will allow me to send "To Do"'s to Entourage. I have a list of customers that I need to call at specific times and I want to press one button that will export there name and telephone and key details from the database to a individual "To Do" in Entourage. (1 "To Do" per customer) Is this possible? Many Thanks, Dean

Hi, I need to send a copy of my database on DVD to someone on a ship without regular internet access. Sending a dvd is not the problem but what happens to the linked file path names ?. For example the uk database is on O:databasesthis database but it needs to end up on C:databasesthis database Will I lose the links to any files or does filemaker create the right paths. I need to link files as I want them to open from filemaker so embedding is not an option.