Importing & Exporting

Hi, I've been browsing this part of the forum but haven't found an answer to my problem. Is there an ultimate solution for importing from a csv file in filemaker 6. I'm talking about several files with a whole lot of fields (+90) that are being imported and have to be assigned to the right field in a database with +300 fields. The field names aren't similar. Of course I've done imports before but never for this amount of fields. Now I'm going crazy writing my import script using the filemaker import window, searching, scrolling up and down, trying to remember where I found a field and when I find it back wondering where the other field stayed... an…

I am interested in using FileMaker to develop manuscript for a project that will be be both online and print. I want to be able to locally format text fields with italics and boldface in FileMaker, and then be able to export the text coded--either XML, HTML, or XPress tags--so that the local formatting is retained. I know that this was not possible as of FM version 5, but I'm wondering if that has changed in v7 or v8. Is there a function that allows FM to recognize italicized text in a text field so that I can add "" and "" around it in calculation field? Or is there a third-party add-on? Thanks in advance for any tips.

I've have jpegs of my art in the AppleWorks DB that I'm importing into FMP 8. While I've mananged to get the fields to FMP by saving the Appleworks as ASCII and spreadsheet before importing, the jpegs never get into the ASCII or spreadsheet in the first place. Other than re-importing the graphics (oh, that's all right, there are only 781 records), is there any work-around?

hi guys. i have an active database, which co-workers use. i would like to continue to develop the database without tampering with the active database. i thought about creating a new database and i want to import the fields to the new database. in the new database, i created 2 or 3 tables (named the same as the active database). now i was able to transfer the fields to the first table. but i can't change the TARGET TABLE to import the other fields in tables 2 & 3.

Hello, I was wondering if someone can help me with an import I do daily. I currently import records from a web page (that I've been given access to as a courtesy). What I've been doing is "Select All" on the web page and paste this into a text file which then turns into a tab-separated text file. All I had to do then was set the "First row is a header row" option and import using the "Update Matching (add new)" option. This has worked fine until the number of records started to grow. It seems to take almost a minute per 100 records (I use FMP8 on a 667MHz G4 PB). I don't have the "perform auto-enter options during import" option selected. I've tu…

How can I get iCal to open or export the date of a specific appointment easily? I need appointments to sync to our Palm units, but have found no easy way other than manually copying appointments set in FM8 to iCal manually. Any ideas?

Recently starting working on a file I positioned on my XP desktop... and noticed that periodically, an "import.log" file appears sort of magically even though I didn't do any importing. The contents vary but it always refers to "import operations started" and usually mentions clipboard... Here's a sample [color:blue]11/28/2005 4:50:26 PM, SPARK2.fp7, 0, Import operations started 11/28/2005 4:50:26 PM, SPARK2.fp7, 0, Import operations started 11/28/2005 4:50:26 PM, SPARK2.fp7, 0, Import of script steps from clipboard started 11/28/2005 4:50:26 PM, Rpt_CallSumByCode, 0, script steps imported 1 11/28/2005 4:50:26 PM, SPARK2.fp7, 0, Import completed 11/28/…

FM6-WIN I have information in 15 fields that I need to combine into a single repeating field so I can search for contents of one field rather than search through each of 15 fields. Is there any way to do this.

Hi all, I think this is a common problem but I am not sure how to do it effeciently. I receive new stories everyday. They need to be sent out to folks that subscribe to the stories. Some subscribers only get fiction, some get non-fiction, some get kids-stories, some get everything. I have 2 data bases so far StoryKits and Subscribers StoryKits is where the how many stories, kind of story, copyright, etc. Subscribers is where the stories are sent, address, story types subscribed to, contact person ,etc. What I want to do is generate a third database or report that will show each storykit and what subscribers were sent out. I want to…

Ok here's an example of what I'm pulling from the CSV: ALSl #1,241391A,Fri Dec 2 7:46:3 2005 ALSl #1,241391A,Fri Dec 2 7:46:7 2005 I have 3 fields setup in my table: sawUsed - text jobKey - text dateCut - text It imports the file correctly.. but I only want one record of the job to import. I don't really care how many pieces have been cut (it will give me a new line with the same job key for every piece it cuts). I just want it to read the jobKey in as 1 record, then skip all the other entries till the jobKey changes. I don't care if it overwrites the record when it finds a duplicate jobKey.. but I just don't want it creating 100 records for…

Importing the excel data is not a problem. What I did was I created a FM8 table that has fields matching the columns of the excel file. I named this table Import. Now I need to do some parsing of this raw data. There are a few ocasions where one column contains data to many fields. Example, in excel I have a column called Address2 which has City, Province and Postal code. And in another occassion, I have many fields (in Imports table) that needs to be merged into one field (comments) for my working table. In the old access database, the developer had created 4 fields to create 4 lines of comment, instead of showing 4 lines of 1 field. Naturally the working tab…

How do I get Filemaker 7 to retrieve and display only the path of a selected external file (of any type) in a text field? It'd be ideal to be able to drag and drop a file or image onto a text field and have it enter the path as text in the field. Either that or clicking on the text field would bring up a file browser. Am I asking too much? BTW the demo of Troi File crashes my FM7 application. Thanks for any advice... TL

I want a simple export of data to go to the desktop. The fields are pre-determined in the script...the user simply launches a script and the export is done. I know in 6 and earlier, you had to export to a known location then use a file plugin to move the file to the desktop. Can this be done now in FMP8 using the get(desktoppath) function without using a file plugin? Also, would this be platform independent? Thanks Greg

i need to import records from one file (A) to another empty file (:. The file A contains compant records with orders. what i need to do is to have conditional increment whereby the increment occures only if the company number is different. all records for company id ? will have the same record id incremented. i need the increment to be done only if the company id is different on imports. can any help with this? thanks

I've read the Forums and found bits and pieces of what I need but it's just not clear to me. I have three calculation fields, foldername, path and content. foldername = "[color:red]unique" path = "filemac:/Servername/[color:red]unique/filename.txt" content = "text information about whatever" What I would like my script to do is to loop through a found set and export the "content" field to the path provided by the "path" field. Can it be done without a plug-in?

I am but a newbie and have tried to read up on everything I can but alas I am a bit loist on a couple of items in filemaker 8: First off I am using regular filemaker 8 not advanced(not sure why there are 2 differnt versions) anyhow I have created a table to import data into and it is working great, I have some serial fields, some calculated field and some summary fields. Here is the schema: sales_data:: sd_id -> serial autonum creation_date -> the date the record is imported data_date -> the date in the original text file postal -> postal code store_num -> store number category -> also a field in the original text file bu…

I am trying to import an access file (I exported the access database to excel) I am using fmp7 When I'm almost done importing it says Filemaker has generated errors and must shut down Any suggestions

Hi Guys, Can somone advise me on how I can try and recreate the FileMaker---->Excel layout into Excel automatically when I run my export script from FileMaker. Ive attached a sample of what I am trying to do, any help would be much appreciated as always. has anyone else attempted to recreate a couple of reports out of FileMaker into Excel in the past? Jalz reporttest.zip

I have a FM 7 solution with multiple files. When I try importing a found set into file1.fp7 from file2.fp7, it imports the entire record set, not the found set. I know this was suppose to be fixed with version 3 and it was when I did it on Win2000 but it doesn't work with XP. Any idea why it works on Win2000 and not XP?

Hello, how do I fill some field with the content of the clipboard. It's ordinary text. Do I have this to do with AppleScript or is it possible with scripts from/for FileMaker? I scan my Barcode with an external application, the UPC-code was send to the clipboard. If I activate the my databse I want to press a button which fills the content from the clipboard in my field. I tryed the forumssearch but didn't find any usefull hints. Maybe someona can help me? : wkr R.W.

I am using word 11.2 for mac. The mail merge has a built in filemaker import wizard. You create your labels, then get data source and one choice is filemaker pro file. However when it browses the desktop for my filemaker file, it is right there but greyed out and not available. Has anyone seen this or had this work successfully. does it involve upgrading to filemaker 8? I was able to get the data into excel and then from excel into word, but it took several extra steps and some reformatting.

Hi all, I've got a problem. I'm trying to migrate from a contact management solution with Maximizer 97is to Filemaker 7. The problem is, Maximizer exports it's records in a very broken way. If I pared it down to just a few fields the output would look like this ([CR] and [LF] denote the control codes) As you can see this is horribly, horribly broken. Almost any program that imports comma-delimited data sees every [CR][LF] as an end-of-row indicator, so very bad things happen when I try and import this. Does anyone have any suggestion of how I could co about fixing this badly munged file so that I end up with something importable into…

Filemaker pro 7 (winxp and osx) I have products in a database that I need to upload to my oscommerce shopping cart (easypopulate) The shopping cart requires a tab delimited file with header rows. My question: How to export the products AND a header row. I have tried making a record with the header information in it but I have some fields that are populated by a calculation and it always exports the calculated info instead of the header information in those fields. I am currently exporting, running an applescript and then uploading. While this works fine under osx, it does not under winxp. Please help anyone. Jeffrey Duncan 801.224.2260…

Rookie here, please don’t shoot (yet) Ok, Let me tell you what I need to achieve, maybe someone is kind enough to explain this to a FM Greenhorn (me) I need to Import data from a TAB Separated file, everyday. I know how to do that. But I need at Import Time to have some operations to be performed ON and WITH the data. 1. I need to Copy some fields out of the Record, to another table, based on certain rules, simple rules but I have no clue how to do that. Things like: If the NameId exists in the table and the Phone Filed is empty Update the Phone field…. Etc 2. I need to perform some data corrections, like, to cut out from some text fields portions which a…

I have a script in a solution that first exports data from a table and then carries out various other script steps. My problem is that when a user presses the cancel button on the export script it continues on running the rest of the script. I want all the other script steps to only be activated if the import command is carried out. (Oh and the export step needs to be have dialogue turned on.) Cancelling an export script step does not seem to generate an error message. I have the same problem with an import script step. In this instance, if the user cancels the script step OR they try to import the wrong type of file. ANy help would be appreciated

I do not seem to be able to exchange information between a FMP File with a runtime app made with developer. As soon as I use any function from the runtime app that interacts with another FMP file (such as standard import function) the runtime app quits out as it seems to be able to support only one file. The error I get is that I have exceeded the maximum number of licences. During this process I need information to be imported both ways and records to be updated on both sides. Are there any alternatives... help !!!

I have the need to change a exported filename to a filename from a global text field in the current database. For example rotyapplications.rrd is the file name. I want it to be renamed from a field called outpost# which is a global field and it contains 6. I want the file name to be rotyapp6.rrd. If the outpost# is 153 I want the file to be renamd rotyapp153.rrd and so on. This is a program to collect Ranger of they Year applications for a District ROTY evaluation event. Each outpost (church boyscouts) would have their own number. The program is at http://readyrangers.tzo.com/rotyeval.exe and is about 13 meg in size. From the main screen there is a Send V…

The company I work for sorts all the orders by a four digit order number. Several times a day we need to go in and alter these orders or in my case import more information from an excel file into the database. The problem I am having it, when I put in Order number equal order number and then import a specific field, instead of adding it to the record we have now and updating it, it creates a new record. This is becoming problematic when we have over 3000 records before the duplication. How can I stop this from happening and placing the information on the clients record without having several records for each field I update?

I have to do an annual report and I did a find based in the dates the cases were reviewed Now I have to get info on these cases like af=ge, gender, county etc. How do I do this with only the 36 records that are in the find

Is it possible to append data during the import process. I have added a new field to my table and would like to append data to that field during the import process from an external data file. I import approx 10 files to a single table, but I need the appended data to be different for each file imported and not overwritten. Can this be done?

Does anyone know why FM exports squares "" in place of returns in text fields? I am exporting html and firefox shows the squares, most annoying. If it is an FM7 bug, does FM8 fix this? Thanks.

I have a company table and an employee table. In Filemaker 6 when they were separate files, I exported the data for the first company, then exported the related employes for that company, etc. and all worked well. (well enough). Now, with them combined into one file and two tables, I can't figure out how to do it. What am I missing. Thanks.

I have a database of images in Filemaker 8, and I have been pasting in jpegs and giving them names etc.. Sometimes I run a find, and find say 40 out of 200. I then want to export all of the images in these receords to a new folder on the desktop. Just the pictures, nothing else. I can export one image at a time using the "export field contents" from the Edit menu, but how do I do this for all found records in one go? I want to end up with a folder of my jpeg images. Any help very much appreciated! Simon

Here's my problem. I work for a comunity group and have developed a very substantial database to track clients and various opportunites. The database as I mentioned is very substantial. However on our website we use a mySQL database to show people various opportuniities which exist that they may be interested in. What I need to do is as follows. 1. Connect to the sql database automatically. 2. Query the sql database to see if the opportunity is on the site. If not create a new record and upload the data from the relivant table in Filemaker. 3. If the opportunity is there, check the last posted date and if that differs from Filemaker, is. is older than on filemake…

Hi There FM Forum, Take that this is my first post and combine it with the fact that I'm a pretty new user to Filemaker7, I'm hoping this is a pretty easy question to answer even though it has completly dumbfounded me for a few days now. My question is two parted, I'm not sure if this is in the proper forum or not, so I'll apologise in advance. I have an access database I want to import into filemaker, Ii downloaded the odbc driver butt dont see it anywhere. Is there a plain english way to do this simply? Thanks, Jake

I added three fields (lookup) to a file. When importing records to another file, the field names matchup but there is no data visible on the scan or transferred (only in those three new fields). Field names match, format same. Other field data comes across just fine.

Hi, I have a report,with Sub total , total and it is grouped by User Id. I view it in Preview mode. I need to sequre the report from corrupting. When i work with it is o'k. I know that I can not see the sub totals and group by filed data in any other mode. However,my concern is that when multiple users have acces to it, i will have problems. Any sugestios? what and how? I was thinking to unable any other mode at the time the report is viewed by the user until it is printed or closed. I have no idea how to do this with FileMAker. Another thing: I was thinking to "skip" the Preview of the report. Just within the button that generates the report to expo…

Hi guys, I have an old application made on Corel Paradox Runtime and my client said me that it's developed in Paradox 8 db level 5. I don't know anything about Paradox but I see it is a database file driven. I didn't find any export function in the application. FileMaker can import data from Paradox? There is an ODBC driver that I can use?

Hi! I have to check for a registry key, I was using tiral of WinBatchm, but run out of time, so I made a small app that read the key, end return wheter 0 or 1 in a text file key.txt, then I import that file in fileMaker. The problem is that when I run the readKey.exe from FileMaker, it doesnt generate any text file, when I run it myself it works. Is there any trick to do when talking from FileMaker to .NET !?!?!? BTW, I'm not sure I posted in the correct forum, feel free to move to the appropriate place, thank you!.

So, I'd like to make changes at home with my laptop, but our company does not offer remote access, so the changes are not made in real time. Also, while I'm at home, the employees continue to make changes. I can sort by date modified to find changes the next morning, but is there an easy script I can set up to synchronize the two?

I am having trouble getting FM8 to Import from Excel 2002. It works as an FM Pro application, but when I convert it to a runtime it doesn't execute the script. Is this a limitation of FM or am I making some kind of mistake that I'm not catching? Thanks!

I am unable to get FM to see all the ranges that I defined in Excel! (There are only about 7 of them.) The ranges are defined correctly, my filepath to the Excel file is correct, and the Excel file extension is selected in Filemaker. All Filemaker sees is the worksheets, not the ranges.

Question...FMP7 I've got a script that exports some data. The script works beautifully when I run it from my local PC, however when I run the script from another machine, the export step does not retain any of the fields I had set. I realize this behaves quite differently than in FMP6. I'm sure I'm missing something obvious, but not quite sure. thanks in advance, Heather

Hi, I need to be able to import files from the web - everyday new file. I wish to automate this, but the problem is that the file/link cannot be a caculation. I tried with "open url" and a batch file that downloads the files automatically but "open url" does not work well with parameters (it just ignores the whole thing).... So...it looks like i'm stuck. Any suggestions?

Anyone know of a way to allow importing and exporting via an IWP published database? The Import and Export steps are not compatible with the web, per FM 7. What solutions have people used for this? My company is trying to knock down the number of clients needed by serving up databases via a web interface. At least one of the existing databases need to have import/export functionality, and I'm not sure what options are out there. Thanks!

BACKGROUND: I am trying to build a database whose primary function is to import an excel spreadsheet of items to be inlcuded in a catalog. Currently the list includes every individual item as a seperate record and item even though it may be listed as 1 catalog entry with 5 colors and 10 sizes available. I manually have to strip out the redundant information and compile them into a single entry before creating my text document for layout. WASTE OF TIME and opportunities for error. Because each item is listed with an individual part number (ie., X12345-123, X12345-124, etc) rather than a part prefix (X12345) and a subpart/identifier (-123, -124) it's difficult to do this au…

Can anyone help me import the contents of a return-delimited field into multiple records of another field? For example, Line 1 Line 2 Line 3 imported into another table as 3 separate records? Thanks!

Hi all, Please help! I'm going la la here trying to sort out how to export or save records as an excel file (neither way works). I have created a script that should automatically find a bunch of records, and then export specific fields into an Excel spreadsheet that i can email out. Using 'Set Variable' commands it saves the resulting file to the desktop with the name of a field in the database. That way I can loop through the database and create different filenames for each record. Works brillantly - except for one thing! The 'save as excel' and the 'export records' script step both fail to put on the file extension for Excel, namely .xls. The people at …

One of my daily chore is to export our daily sales records to a text file and upload this file to our corporate's FTP Server. Right now I am using a seperate FTP program to do the uploading. I would like to do all this from within FM. Does anyone know of any FTP program that I can execute from within FM 7 or 8? Or is there any plug-in can do that?

Hi, I've read some aerlier posts on this subject but they didn't really shine a light on the problem. What i wan't to do is to change the name on an exported FM7 file to a value specified in the exporting FM7 file. Otherwise it will be overwritten in the next export. What I have understood you can either do this via a plug-in or somebody mentioned a shell command. 1. What is a shell command? 2. Is there a possability to execute such a command on both Mac Osx and PC Win XP? I think it's rather wiered that FM doesn't support "dynamic" naming of fields like ScriptParameter or so.

Hello All: I'm working with a non-profit which buys mailing lists from other non-profits, and imports them into their contact db in FMP. Quite often they end up with duplicates, some of which aren't necessarily exact duplicates (due to typing errors, formatting differences, etc.) I'm hoping someone out there has a good strategy for eliminated duplicate entries, as it's bothering me a bit, and they have literally thousands of duplicates on their system already... Thanks in advance -Stanley

I have a student names database created by the PTA on FM. We wish to import just the student's house from an administration file created by the office staff in Excel.On import mapping dialog I match 1st Name and Last Name and only import house field. Of 800 records only one house is imported to one name. I'm guessing there is a critical difference in the fact the names were typed by 2 different organizations but how did just one get through.

Is there any way to extract a file path from an external file, short of copy and paste? For instance, if I import a picture into a container, is there any way I can script that import so it will also fill in another field with the filename and path?

[color:blue]My company has been working in FM 6 and had asked me to recreate rather than convert to 7. My problem is that someone else created everything in 6 and they are no longer here. There is a lot of junk and it was poorly documented. I have recreated several files and am now trying to import data from 6 into 7. I am somewhat new to importing and I am curious to know if there is a simpler method. [color:red]It seems that it would be much easier if I could match field names to field names rather than old data to new field names. Is there a way to do this? Is there a better way that what I am wanting?

Is it possible to import emails from Outlook Express without using a plug-in ie. outlook manipulator by Productive Computing. I just need to suggest options to my client and am really new to this particular area of development so wondering what exactly all my options are for doing this. I don't mind using the plug-in if that's my best bet but don't know enough about this process yet. Thanks for the assistance.

I have an Oracle database that I created an ODBC connection with, to pull in all of the records. I want to write a script that will compare the latest record added (based on the date field) and import anything newer than that date. The date field is set up with the time as well (e.g. 10/13/2005 7:57:17 AM). I cannot seem to get my SQL query to work to compare on this field. I assume that I will need to convert the field somehow? Does anyone know of a query that will work?

I converted a DBF file to FileMaker and noticed that the time fields contained and eight digit number instead of a time. I also tried importing the data into FileMaker and still got the same result. Is there a way to import time fields looks like a time. Thank you

I have a solution hosted from a FileMaker Pro 8 application. When accessing the database from a client, I am having an issue with an export script I created that exports an RSS (xml) document. The difficulty is specifying the path for the export. If I am at the local machine, everything is fine. Otherwise, I receive an error when exporting. I know this is an issue with the file reference, but am not sure how to correctly setup the export pathing for clients. Any ideas? Thank you in advance.

Does anyone know if it's possible to export the currect record only (much as printing can function). I know that I can create a find with the record's ID number (and so then have only one record in the found set), but I don't want to have to do that every time I want to export. Is the easy solution staring right at me?

Hi, In Microsoft Excel we are using a formula which takes information from another open application and enters the information into a cell in Excel. The formula we are using is: =AXLDDES|'AV..L'!MID_PRICE Is there anyway to imitate this in FileMaker, perhaps with a DDE command? so that the information is brought into a field in FileMaker Many thanks

Greetings. I have a script in a FMP6 solution, written by a vendor, which retrieves data using an import step. It performs an HTTP request, and uses an XSL style sheet, then performs the import. The problem is, as soon as we change the URL to HTTPS (which it should be), the step fails. I know the URL is correct because it works fine outside of FMP. The vendor suggests we have to change a setting on our network. The network manager and I debugged a few things, but see no issues. Anyone know if there are settings specific to FMP or FMP server (5.5) where I can modify things to make this work? thanks in advance, Heather

Although I've been working with filemaker since 1988, I've never used a spell check before. Now that I'm using a lot of text both in French and Dutch, it wouldn't hurt to check for mistakes directly in filemaker in stead of exporting my typings to a text file. I've always used the English versions, because it's easier to get the information I need, without having to look up the Dutch translations for English terms. But now I'm stuck. I got the English dictionary wanting to change every Flemish word I use and I seem unable to lay my hands on the Dutch dictionary or the French one. It's basic for someone using this thing since Filemaker II, but, well, there …

This is my first posting on FMForums so I don't know what to expect... My problem is that I have data (being a city name and a county name) in one field that is seperated by a comma. I want to seperate the two from each other and get them in seperate fields. I immediately tried to use first word and last word functions but realized it didn't work--of course the cities are sometimes one or two words as well as the counties. Is there a function that I can use that will recognize the comma in the middle and pull out data respectively? Help!!

I have a dilemma... We recently switched to filemaker pro to track jobs in our department until we get a new program (Virtual Ticket) implemented. Originally, we thought it would be best to keep the two different catagories separate in two different filemaker databases, so we duplicated the exact database and have maintained different records in each one. The problem now is that we want to combine the two together, but it has container fields that will not allow it to export the records correctly. I am new to filemaker and inexperienced and cannot figure out how to make the two sets of information available on one database. The two databases are IDENTICAL but I can't get …

I'm interested in sorting certain portions of my database during the export process...if possible. Example: I have a field that has 5 check boxes. As it stands now, the checked boxes will export in the order that they are checked, but I want them exported in a fixed order. So if boxes 4, 2, and 5 are checked in that order, I would like them to output as 2, 4, 5. Also (this is a good one), I'd like to be able to print out what each number represents. So like if 2 is L, 4 is A and 5 is V, then, using the example above, I would like 4, 2, 5 to export as L, A, V. I dream bigger than I'm able to accomplish. If someone could point me in the direction of what I should be do…

Hi, I am trying to export found records to a text file with fields separated by standard carriage returns instead of tabs. I am having two problems. 1) I can't seem to get the carriage returns in. I tried creating a global text field, setting this equal to "¶" and then exporting with my other export fields, but when I open the output file in BBedit, I see that it has inserted a "¿" instead of a line break. I also tried copying a BBedit line break, and pasting this into the specify calculation window, but this results in field entries separated by tabs and an empty space, but no line break. 2) I can't get rid of the tabs. Anyone have any thoughts? …

When I export a file with lots of French accents '

I know I can export the records to mer with field names. But when I export the records from related file, the field names will appear with the relationship name in the front. E.g. Relationship::Field_Name Is there a way I can get the field names without the relationship name?

Hi, I tried exporting data out from filemaker pro in xml format using FMPXMLRESULT grammar. I designed a xslt document to convert the xml information to be shown in html format. The result needs to be displayed in a table. However it displays the text and ignores the html. I have exported three fields from a table in xml format. In the result, the field data from all the records is displayed but the html is completely ignored. Has anyone experienced it before and can offer some help. I would try to attach my xml and xsl document if you would like to look into it. Thanks, --Sanjai

Is it possible to get that all the information in the repeating field will be exported to different cells in Excel? Thanks in advance.

My website uses a form wizard to collect information, ultimately sending the comma-separated data to me via e-mail. Problem is I don't know an easy way to get the information out of the e-mail, into FM. Information arrives in the following FieldName, Data format: 'OwnerFirst','Jane' 'OwnerLast','Doe' 'OwnerStreetPOBox#','PO Box 123' 'OwnerCity','MyCity' 'OwnerStateZip','CA 123456' 'OwnerPhone','555-555-5555' Currently, I copy comma-separated data out of e-mail and paste into Word, then change to human-readable format as follows: OwnerFirst: Jane OwnerLast: Doe OwnerStreetPOBox# PO Box 123 OwnerCity: MyCity OwnerStateZip: CA 123456 …

Anyne got any ideas as to how to script a find-replace "" with "/" in a field that contains a file path. In a scripted find-replace the is always regarded as an operator, even with the surrounding quotes. It works fine as a manual find replace - but I don't want to pass this on to an end user in my runtime solution. I want to be able to copy a file path from the OS, paste it to the field and use it to export field contents. The problem is the pasted result has the slashes going the wrong way for Filemaker to interpret as a valid path. Of course this could be corrected manually but it would certainly be more desireable to have this done automatically.

Hi all, We are using Outlook to collect web form data from a third party website. emails come down at the rate of about 200 a day and we have to get them into filemaker to try and process them - mostly brochure requests. Anyway, is there solution available (plugin / clever script, third party solution) that can look at an email inbox, read the fields in it and import them into filemaker as new records. Preferably it would also then move the email to a new folder so it doesn't look at it again. I don't mind if it has to be a once only daily manual process if it can't be automatic. Does anyone have any good ideas? Is anyone else doing this now? I don't mind h…

Hello, I'm trying to create a .txt file from a single global field in FM Advanced v8. I have entered a simple list into the field like this: This is line 1 This is line 2 This is line 3 etc... If I place my cursor in the global field and choose Export Field Contents, the resulting .txt file looks something like this: This is line 1[]This is line 2[]This is line 3[]etc... For clarification I entered square brackets [] in the sample above where there is an unknown rectangular character contained in the output. What I am after is a .txt file that looks just like the contents of my global field. Anybody know how to solve this dilemma?

Hi, I often need to import text data which includes carraige returns. I use the CSV or TAB systems and of course each time I get in troubles. How can I convert the CR in such a way that they will stay in the required fields? I use Text-Edit and converting CR to Line FEED didn't help especially because I mix Japanese and Latin ecodings therefore I convert everything to UTF-8. I suggestions highly welcome Thanks

Hi FM freaks Did you know, that it is fairly easy to integrate the graphing ability of Excel into FM ?! All is done by the DDE execute commands. Though hardly looking for, unfortunately, I could only find very little information on this. Now I am asking you for information or a list of DDE-Execute commands to control Excel via Filemaker. Below, you find a list of all thos commands where I was able to use them successfully. Can you extend this? or send me another list? or recommend a book? or... Joska SERVICE -> THEME -> COMMAND -> Comments 1) EXCEL -> SYSTEM -> [select("R1C1")] -> selects a cell within the opened Excel document in…

I imported a few thousand records from FM5.5 into FM7 that had a date field defined (in the 5.5 file) as a text field in the following format: YY/MM/DD. That same field is properly defined in the FM7 file as a Date field. I need a script that now converts the YY/MM/DD Date field data in the FM7 file to that which is compatible with FM7 Date format MM/DD/YYYY. 1. All records are for 2004. 2. I plan to use the script to "Replace Contents" of the Date field in FM7. I could use some help really quickly, if possible. Thanks, Deke.

I built a database and would like to import the data so I do not have to type everything out. The data is on an Excel spreadsheet. There are 816 rows and 16 columns. Is there a way to import this into the fields I made in FileMaker Pro? Would I have to ensure the Excel column headers are the same names I have in the database? How would I be able to do this, can it be done?

HI, I was reading another post and it answered a question I had in a sort of way. Any way I have posted a file that I am unable to import into. Can someone give it a look and see how to import into it so that it works, if possible set up a script or somthing. TKS 1126743430-2ndLowest2.fp7.zip

Hi, I'm looking to take the data from an online form and submit it to a FM7 database, but I'm having trouble finding tutorials. I'd like to use PHP and I've looked at fx.php which looks like it will work. Anyone have any advice? Thanks, Dave

I'm looking for a way to make importation of tousand of audio files (.mp3 and .ram) into a container field. I know that we can insert a QuickTime file but I didn't see how to import a folder of audio files.

I need to download info into a SYLK file. The main problem I am running into is if I have a field that sums by city and has 10 items underneath it in the nextv column, it enters the info in 10 rows but does not enter the city. It's only an annoyance but it would be nice if I could get the city name to be entered in all 10 rows. Any ideas?

I haven't had a whole lot of experience with importing data into my files, but I thought I understood well enough how it worked. Our fiscal data system (Microsoft Navision) has clients in the database with their own, unique identifier. My filemaker solution obviously has it's own unique identifier for clients. I created an extra field to store the the fiscal identifier because we will be moving data back and forth between the two systems. I got an export from our fiscal system data that consists of their unique identifier and a SSN. Every client on the export had an SSN. I start an import into my client file. I use the SSN field as the match field and s…

Is it possible to open a word or pdf document outside of Filemaker? I have a series of docs but am working on a Mac, so can't embed them in Filemaker. Anyway I can provide a link to them instead?

Hi, I have to export record data for another DB. However, the other DB requires one field per line, e.g. If I have 2 records with 3 fields: Rec1: Tree1 Stump1 Branch1 Rec2: Tree2 Stump2 Branch2 I need them to end up in the export file as: Tree1 Stump1 Branch1 Tree2 Stump2 Branch2 All the fields are calculations so I can add in what I want but a carriage return (¶) does not force a new line in the exported file. Any ideas? Thanks.

Hi there, We have not purchased FileMaker yet, or I could probably answer this question myself... I work for an aviation services company where our client uses electronic forms created in Adobe Acrobat (Designer.) They currently use FileMaker, but have the electronic form send the data to a folder. Then, they manually enter that information into their FileMaker database. Our question, is can we take this information easily into FileMaker without them having to manually enter the records? I am 99% positive you can since the information is exported as XML and I read in some other resources that FM can handle XML. My question is, how hard is this to impleme…

If I want to try having a young person do some data entry for me in a relational contacts database but want to be able to check the records she typed in before adding them to the existing database, what is the best way to proceed? One issue is that a search needs to be done on each contact before creating a new record, because some contacts might already be in the database.

I have multiple dynamic columns which only contain summaries. Owner wants these 'cross-tab' views exported. Each attempt takes forever to export 100 records with 6 columns; it's almost like FM recalculates the summaries. And once exported, I end up with multiple rows of the summary totals and only the first row contains the 'row.' I understand why this happens - I need to be in the many side to have the 'row' list on each line ... but that's not what I want! Each column is a different relationship. And the following lines aren't needed because they only contain the summaries listed on the first line! I want a duplicate of my row/columns to export in cross-tab fashio…

I have a series of related databases and want to export data from multiple related files simultaneously. I can do an export from one database and select fields from multiple related databases (by selecting a relationship in the left pane of the export dialog and moving the fields to the right pane), but the export for the fields in the related databases contains no data. I thought FileMaker was able to export related data as well as data in the current database. Anybody have any idea for what I should do? Thanks in advance. Richard.

(Fortunately this question is more theoretical rather than some immediate crisis – which is often the case with my other postings:) I have a medical application that uses a long list of Vitamins that I’ve imported from Excel into FMP 7 to create a “Vitamins” table. I specifically used auto-increment to assign a record number to each of a couple hundred records. This was intended as a “one time” import – I shouldn’t need to do it regularly. As part of the application, I use the record number to do look-ups: The record number gets stored in a “Medical Tests” table – I use a portal to display the actual Vitamin names. All works fine – but here’s my concern: At…

Hello all, I'm a newbee here and to filemaker in general. I was wondering if there is anyone who can guide/help me with this issue. I'm trying to import text from a website. Let say, ,I'm typing a name of a product and when hitting a button filemaker connects to amazon (as an example) and retrieve the fields that I ask for. I know it's a bit complex but I'll be happy to listen to any advice on this subject. Thanx, Ethan

I imported a bunch of records into a FMP 5.0 file. The dates I imported were al 07/01/05. Of course, FMP 5.0 thinks the date is 07/01/1905! The dates are stored in repeating fields, which makes converting them even more difficult. Is there any easier way to get FMP to realize that the year should be 2005? Thanks the Mad Jammer

Hi all: I'm a teacher interested in keeping a record of my classroom books in FM7. It would be most helpful if I could import records directly from the Library of Congress or my local library -- both can save search results in the MARC or MARC 21 format. Is anyone familiar with importing these records into FM? I can convert them to XML but I'm a pure novice with XML. If possible, please point me to utilities or style sheets that could make this feasible. Thanks in advance.

I created a new db (v7) with date fields defined as date-type. The old db had all 'date' fields as text fields: "yy/mm/dd" The new db date should be "mm/dd/yyyy" I have tried several approaches, but have not been successful in converting the date-oriented fields from the old to the new db. I have looked at other similar entries in this forum, but don't seem to be able to apply those to this situation. (My fault, likely.) Can someone help with specific scripting, if that is what is needed? Thanks. Deke

How do I write a script that will export the data and directly open it in Excel?

I am creating a database that will be used to handle orders by importing csv files from various Internet sources of orders. Unfortunately, the files are very different in the way data is arrayed and presented. For example, product information is stored 2 columns in one and in three in the other. One has the full name in one column, while the other separates first and last name. One has perhaps 15 fields, whereas the other has about 30. I have been playing with setting up a separate table for importing each data source so that I have fields that are easily matched with the source file. I was thinking about setting up calculation fields within the import tables to clea…

Hi I am working on a project where I need to empty the data stored in a few of the tables within the larger database. It is a judical database where some tables define judical codes, which will stay the same so those do not need to be cleared out, its just tables containing offender data from that past year. Does filemaker have a method which will empty the data in a defined table, if so how does one go about performing this operation? I am very new to FM and any help would be greatly appreciated.

Hi there, First of all can I apologise if I am doing the wrong thing in posting here. I have already posted at http://fmforums.com/forum/showtopic.php?tid/168856/ but wasn't too sure if that was the right place to post as there have been views but no replies. So I apologise if I am doing wrong, I don't mean to I just could really do with a hand if someone has the time to lend. Thanks! Mark Bowen I am very new to all the transformation of XML to HTML using XSLT but was wondering if someone could take a stab at leading me in the right direction. I have been trying for the past 12 hours to create something which I am sure must be able to be done with ut…

Hello all, I am a student, and I have exported Filemaker Pro data to excel in sylk format, which I am told is the best for excel, but it has not given me any field names. I have a zillion fields and do not want to type them up in excel. I tried a merge format (but apparently this is for word, not excel) and this gave me fields but there were " " everywhere. And all the data was in one huge cell. Any help would be greatly appreciated. I do not know why filemaker has not given any clear support (as in documentation) in regard to this. I am ok with computers but this 'simple' task is completely beyond me

I'm using Pro 6. I'm trying to import only NEW records from one FM file to another. I'd appreciate it if someone would assist me on a few minor issues. My questions: 1. How do I import the new records each time without importing all records? I thought the "add new records" option meant it would only add NEW records, not all records. It works if I first use Omit Multiple Records and omit records which were previously transferred from the original file before I then import the new entries into the clone. 2. When files successfully import to the clone, almost all text records are transferring fine--all but one, which isn't putting in the entire "Serial ID" (my …