Importing & Exporting

Hello FM Users I was wondering if anyone can tell me if there is a way to access the reference path which FM stores when using the store reference option whilst incirting pictures in a container field? Thanx in advance David

Do you have to pause FM Server while doing this? I know for a backup you do. The books don't say to, but I'd sure hate to destroy this wonderful piece of work doing an export.

I am using FMP6 on three computers. Two are connected together as peer to peer, the third is a laptop that can connect to the powerstation/server via wireless. I am looking for a script that can synchronize my laptop with the server when the laptop is taken out of range of the wireless, had data added, then brought back in range of the wireless. I want to be able to import/export new data from the laptop and put it on the server and take new data from the server and import/export it to the laptop. Can this be done and if so, how? I contacted a local FMP person who says he thinks it is not possible. I SURE HOPE HE IS WRONG!!

I have a database which I want to use to produce what's on listings. Essentially there are three fields that matter: The town where the gig is taking place, the type of performance and a description of the act. I want to import the records into quark in one stream already tagged up. I have no problem tagging the content. But I can't seem to get the correct output: I want each town to appear as a separate title, followed by a listing of all the acts sorted by the type of performance, so all the comedy gigs are listed together, followed by arts exhibitions etc. I can get a preview of what I want and print it. But what I want is the preview as a pure text stream. In effect,…

Hi, I'm hosting a survey that submits to a Filemaker Pro 5.5 Database. One of our objectives is to be able to reject people that try to submit the survey twice by logging the clients IP address and rejecting repeat addresses. Currently, I can log the clients IP address with the [FMP-ClientIP] CDML tag. But, I'm having trouble coming up with a way to reject people if Filemaker grabs an IP address that's already been submitted. Any help is much appreciated.

In my ongoing project to gradually replace our company's creaking old DOS system with spanking new FM modules, I've reached the point where my FM purchase order module is ready for users. So I need to export into a text file the day's work, then import this file into the DOS system. The DOS system needs the PO header records & detail records all in the same file, yet requires five fields exported for header and seven for detail (with no empty fields allowed). The solution is two concatenation filds that rope together the fields to be exported for each. Then a calc field that fills itself with one or another of these, depending on the header/d…

I'm trying to post data into a FMP DB from a web browser, using the url method (as opposed to the form method. I manage to create a new record; however, when I try to put into a single field the contentes of a cookie, It writes to the field the code for getting the info I want. Here's the code (I use JavaScript): <script> window.location = "FMPRO?-db=databasegoeshere&-format=responsepage.html-&nameoffield=[FMP-Cookie:nameofcookiegoeshere]&-New" </script> As I mentioned above, the content of the field nameoffield gets set to [FMP-Cookie:nameofcookiegoeshere], and not the content of that cookie. Can anybody clarify me a…

As I was testing my newly settled Serial Number (1-1,1-2,1-3,1-,4, using the classic method selfjoin and lookup to nextserial), I encountered some difficulties when importing. The serial was OK for a while, then started to count only the next serial number giving me 1-1,1-2,1-3,1-598.... My first thought was that the look-up couldn't be executed during the Import session. But after testing the same procedure on a reduced found set (1,000 records instead of 10,000), it worked. I ended up with a loop "create new records" based on a OnetoOne relationships and it worked fine, but I'm still wondering why it didn't work. Here is how my serial number is defined S…

Let me see if I have this straight. Let's say I have a file that includes the fields NAME and then BP (blood pressure). The BP field is actually a repeating field with every time the person had their BP taken. Now I want to export this data for import to SQL Server. It appears to me that the best way to do this is to make a new FM file with a NAME and BP field and then import from the original file using the "split" function. Then export THAT file to a tab file and import the tab file into SQL Server. Sound right?

Is it possible to export records to a .csv or .tab file with field names on the top row?

I use windows and filemaker 5.5 I have two fields and both are text fields. I need to import data from excel into these fields but I have to use import update matching records in current found set and add new records because I may have records in my excel sheet that have to be updated and some new data too. In field 1 I have only numbers and in field 2 I have numbers and letters. When I use field 2 as the matching field it imports the matching records again instead of just updating them, in other word, it duplicated the records that exist in both excel and FileMaker. When I use field 1 as the matching field it imports correctly, updating the matching field without dupli…

I apolgise if this has been talked about before (I did a search but didn't find what I needed.) I have FM Pro Developer 5.5 running on OSX Server X.2.3. I have used a container field and have placed PDF, EPS, etc. files in it. They always show up in FileMaker just fine. However, how do I get the files back OUT of FileMaker. Drag and Drop just yields a picture clipping. I would really like to be able to store PDFs in there and get them back out again for other uses! The files need to be extracted on OSX, OS9 and Windows computers. If anyone has an answer, please let me know. Thanks a lot. Kendall

I am having difficulty getting the plugin working. I need to sync Filemaker 5.5 with a mysql database. anyone have experience doing that? or experience with the plugin?

I would like to know how to export some field data with the field names. When I open the file I exported they have the colums title ? Luiza

FMP 5.5 I have this SQL import code: SELECT `HEADER`.`BAL_TOTAL`, `HEADER`.`CHARGE_AMT`, `HEADER`.`CREDITCARD`, `HEADER`.`CUST_ID`, `HEADER`.`DATE`, `HEADER`.`DUE_TOTAL`, `HEADER`.`EDIT`, `HEADER`.`EXP`, `HEADER`.`INV_NO`, `HEADER`.`LAST_NAME`, `HEADER`.`PAID_AMT`, `HEADER`.`PAID_OUT`, `HEADER`.`ROA`, `HEADER`.`SALES_TIME`, `HEADER`.`SALESMAN`, `HEADER`.`STATUS`, `HEADER`.`TAX_TOTAL`, `HEADER`.`TAXAB_TOT`, `HEADER`.`TAXRATE`, `HEADER`.`TERMS` FROM `HEADER` WHERE `HEADER`.`DATE` >= I would like to add a global field value of g_lastupdate after the >= in my code. I want to build a script step that sets the g_lastupdate value to the current date when r…

How can I connect FM databases with AS400 databases dinamically (if possible) ? We have an AS400 for the core business (we are a wolesale dealer) and some filemaker solutions. However some data is replicated in the AS400 and FM databases (for example the Suppliers Data). I'd like to keep the replicated info only on the AS400.

I have a FM database with around 200 entries. I have set up a letter in Office XP and connected to the FM files using ODBC. The problem is that I only want to generate letters on about 50 of the entries (based upon the entry of one particular field). For some reason, Office will generate letters from 200. How can I set this up so I can filter out the other files? Thanks. Cameron...

I have a repport layout with a field that I've configured to show data with text format as uppercase. On the screen I see the repport showing everything in uppercase, but when I export data to excel some records are in lowercase. How can I garantee all data will be exported in uppercase ? Luiza

I have FM file that is creating a text file on a Mac(using the TroiFile plugin). The txt file is then being opened on a Windows machine. I am using the TRFile-ConvertFromFMText function from the Troi plugin but it only converts the line endings to the native format of the OS that the FM file is on. So basiclly I need to be able to replace <CR> with <CR><LF> from the Mac OS. Thanks, BC

I'm trying to import address label files from Pagemaker and Word, and not wishing to retype or cut and paste, I was wondering if there was an easier way. The addresses have been typed out in neat lines and arranged in columns to correspond to the label size. Has anyone any idea what I should do!? Sambo

Howdy...I'm a newbie to both FileMaker and this Site....I can guarantee I'll be coming back here because I enjoy using FileMaker. The problem I'm experiencing has to do with an Excel Format problem. The data I have looks like this.... That is how it downloads.....the list goes down the page and is one "record" with the next page being the next record......all of these records have the same "labels" which repeat in every record..... problem one: When I import this into filemaker....filemaker recognizes "each line" as a "separate record".......IT ISN'T!!! What I'd like to do is have the records fill going across and feed into columns like this: …

I would like to import folders of images to FM6. No problems there so far. The cach is that together with the actual picture (or a link to it) I would like to grab the extra information (keywords, copyright and so on...) that is stored within the file itself. This information is typed in by the photographer (usually in Photoshop) and it would be really nice not needing to rewrite it.

is it possible to create a function that let's the user of a runtime solution (with no filemaker in his computer) export a part of the database to a tab or comma delimited file.

I would like to export data to excel but the problem is that for the repetition. I did not see it clear and give me an confusion how to separate them. Do you have any suggestions how to export to excel with repetition field? Is it extension is mer or csv?? I tried them both but does not work at all. I would like to have your advice. Thanks

Is there any way to bring memo fields from dBase or Foxpro into filemaker? Thanks Larry

I need to export from my FM inventory sytem to Quick Books. Quick Books needs the data in an ".iff" format. FM will not export in this format, and neither will Excel. Any ideas how to get my FM data in to Quick Books? Steven, Outdoor Sportz

Here's the problem: On my web site, I have a PHP form which the user fills in, then clicks a button to "Submit." The data is returned to me as an email, and looks something like this (after the header is removed): <sample data starts below> realname: John Lincoln nationality: USA email: [email protected] computer: Mac </end of sample data> So, the data arrives as an email in this format: (category)(colon)(space)(data)(carriage return)(carriage return) (category)(colon)(space)(data)(carriage return)(carriage return) (category)(colon)(space)(data)(carriage return)(carriage return) etc. Rather than collec…

Hi all. Newbie user here, thanks in advance for any help. Also, I wasn't sure if this was the right thread to post this in, since it technically isn't data import/export, but I didn't see another thread that seemed more appropriate. My client has designed several layouts for reports and data entry screens in Adobe Illustrator. I have heard that I can import these directly into FM Pro 5 (the version I am using) and use them as layouts or templates. Can anyone verify if this can be done or not? If so, I'm not sure of the steps to do so. The Illustrator files are currently saved as .ai files. Thanks.

I don't know why each time I import I import new data and it delete old data? Is there a way to import new record and keep old records?? Thanks

I wrote a report writing solution for our lab in FMP5.0 I used container fields to insert jpg images and found that using insert quicktime rather than insert picture made a huge difference in performance and file size. We are trying to upgraded to OSX and FMP 6 but since FMP5.5 I have not been able to insert image files from the "insert quicktime" option. The latest fix v.04 allows me to import gif and pct but not jpg. The Filemaker site has a tech note claiming that they have fixed this and any file type recognized by quicktime will work. Does anyone have any ideas on how to work around or when they will really fix it. BTW I tried changing my scripts to "insert pi…

I have a contacts database with 4 tables: Contacts: contact no, name, address etc. Phones: contact no, phonetype (work,home, fax etc), phone email: contact no, emailtype (work1, work2, home etc), email date: contact no, datetype (followup, followup2 etc), date I would like to export data to: 1. Filemake mobile (which does not support relational). They suggest we can do lookups. How would you suggest I look things up? 2. Outlook contacts (access data at work. I have only one license for FM mobile and want others to be able to look contacts in outlook). This is a flatfile. thanks Laura

I'm having problems importing data from an access database. There are many many fields that are different, so I have been exporting the data from access to excel, and re-arranging and or eliminating the data from the export. I am not, however, able to import the "narrative" and "casenote" fields from my database, apparently since they are OLE objects (I needed fields larger than text/memo fields). Does anyone have any ideas?

Hello, I want to SQL INSERT data into a field whose column name contains spaces. With FM5.0 ODBC, I can do this: INSERT INTO myTable.fp5 ("My Field") VALUES ('here is some text') With FM5.5 ODBC, this doesn't work. Is there another delimiter I should use like [My Field] or My+Field? Thank you, Paul Davis

I am using Filemaker 6.0 and need to export Order Data, Name, Address, City, State & Zip to create a fixed length flat file. The file I need to create must be 168 characters in length. I am importing orders from our website into filemaker and need to transfer them to our AS400 system. We have another system that reads order cards and creates an ALT.OUT file with the data. I need to duplicate this file to transfer the data. How do I format the file with fixed spaces? Shane

I have a database in ClarisWorks 4 for the Mac. Is there a version of FileMaker for the PC (e.g. 4, 4.1, 5, 6) into which I can easily bring over this database? Or do I have to export it to a tab- or comma-delimited file, then reimport and recreate all the fields, etc, etc? Thanks for any help.

Does anyone know of a way to pass data from a FilemakerPro v5 database to a web site using SQL without using Java applets. Thanks in advance Chris

Here's my problem, and in case anyone is wondering, yes I am a newbie, but any help would be very greatly appreciated. Ok, in the database, there are records containing address info. In each record a field "ST" contains which abbreviated state they are from. I need to export into html (the easy part) a sum of how many people are from each state (the hard part). I need to have a total of all records found exported and also be able to break it down into tables showing how many from each state. Thank you for any help!!! Ken

Hi, I am trying to Export records from Excel and Import them into my FMP solution. The trouble I am having is that I get about 620 new records when in reality there are only 40 or 50 records. In other words, I have no idea how to constrain those rows in Excel to only the ones with data. I have tried to set the print area etc. but I have no idea what the problem is. Has anyone figured this out? This is more of an Excel question than an FMP question, I am sure. Thank You. Chris

Hello, I am having this problem... It takes a long time (around 30 mins) to import records to my current FMP database. My database has around 70,000 records and I usually import 20-30,000 records from fmp/csv files. I doubt its the power of the computer since its fairly new: 2ghz P4 512 DDR RAM etc... Thanks!

I'm working on a solution that involves me doing a LOT of importing. I'm getting pretty frustrated moving the fields up and down in the "Import Field Mapping" dialog. Dragging the fields past the top or bottom yields insanely fast scrolling, and I always overshoot what I'm looking for. Is there a better way to do this, possibly with the keyboard?

I've searched through the archives and have found a number of discussions about EXPORTING zip codes with leading zeros from FM6, but none on importing. How do you import zip code data that is formatted in Excel 2001 as "Special-Zip" and retain the zero in FM? Thanks, Frank Lennon

When I export records, it only exports the data, not the field names. Is there any way to have FMP export the field names as well without creating a record with the field names as the data?

I am new to filemaker. I'm trying to export a recipe database and need some help. I need to find a way to add quark style tags prior to the data from each field, and then add a paragraph mark at the end of field. Like this: @styletag[fielddata][return] So that a typical recipe might look like this: @recipetitle[Cinnamon Muffins][return] @author[Mary Stiles][return] @ingredients[1 cup shortening][return] Does anyone know how to do this? Even if I could only export a single unique character in place of the style tags this would at least allow a successful find and replace in a word processor. Also, I need to find something similar that lets me i…

I have three remote users who all use a runtime version of the same database. The plan is to let these users edit records in their copy of the file and then export the changed records and e-mail them to me where I will combine them and keep a master copy. Periodically I will then issue back out a combined copy of the new data which has been obtained from the three users. In this way everyone will regularly get an up to date copy Therefore I need the ability to import all three datafiles (from the 3 users) to maintain one master database on my machine. Its this import bit that I am stuck on. How can I take data from three different sources relating to different fields…

Hi, Is it possible to import a column of information from an Excel document to a repeating field in Filemaker? In other words, I have an Excel document with a column of text (contains about 30 rows of text). I want to transfer this info into a field in a new Filemaker database I've made, and this field is a repeating field with about 30 repititions. As I expected, when I use the import command and select the Excel column I want to transfer, Filemaker creates 30 new records, whereas I wanted the 30 rows of information to appear in one record, in the repeating field's repititions. But is there perhaps an option that would allow what I want to occur when importing from…

All right, I've read a number of posts and it appears as if Dreamweaver and FMU might not be the best solution for hosting an on-line database, but they're what I've got so I'll ask anyway. I have a number of files I've adopted for a school of Ed website. All of the departments in the school have the same or similar templates. For a support sight, I need make some FMP databases accessessible within the template. I would like them to appear in list format (which is not an option in FMP's web publishing), if at all possible. I am working with FMP and dreamweaver on my Mac Jaguar machine but will upload the DB files to the school's Microsoft 2000 server with IIS t…

Hi there folks ... I'm using FMPro5 and have run into a bit of trouble now that my DB is growing quite large. My site is hosted on a remote server and when attempting to upload the full flat file ... the server will time out before completion. Therefore, I have resorted to "chunking" my exports into a few flat files ... The trick comes when I export to flat file ... I would like it to "grab the first 100 records" ... "create a flat file" ... the "grab the next 100" ... "create flat file" ... so on and so on. I have tried many different sorting options, but have been unable to get this to work out. Is there a way to do this through a script ... am I missing it ... any …

I made a program that makes selections and stores them on the local drive in a fp5 file and then when needed gets the information again. The reason why i do this is because several users should be able to make diffrend selections at the same time. But here comes the problem. In a Citrix enviroment users dont have access to their local c drive. All the users have diffrend drives. So i need to make my export to a variable location. I can export to a variable directory with the help of an plugin. But i cant import from that path because i need to make a relation between the 2 files wich isnt posible with a variable location. Has anyone a solution for this probl…

I wanted to share a very bad experience, hopefully to prevent someone else from ever doing something so stupid. I had two complete sets of dBs. Set #1 was being modified at the design level (calcs added, scripts, etc.). I was using Set #2 to continue data entry. My plan was to delete all records from Set #1 and import all updated data from Set #2 when ready to apply the new changes. I completed this switch of dBs and was quite proud of myself. Everything appeared fine. Over the course of this week, I have entered 50+ new Clients, Contracts, etc. This morning, I realised I have DUPLICATE PRIMARY ID's throughout all my dBs It seems that my one-time delet…

Looking for any idea to introduce data in my DB from paper forms. Some of the data spaces are variable hand text and some are "X" boxes. May be an OCR program? may be a wacom tablet to help me speed-up the process? If you have experience please help me. Thanks.

Hello everyone. Im hoping you can help me with a export question. I need to Export the data from these fields to .csv FirstLastName MemberStreet MemberCity MemberState MemberZip I also need to perfrom this action without dialog. Right now im using a button that starts the export action but the users that are using this have to choose the fields to export. I just want them to click the export button and have it export to a file on the desktop. Thanks for any help you an give me.

I need to import records from a file and I would like to choose a matching field to update matching records during the import. So that this happens I thought I should choose the Import action - Update matching records in current found set. But I've tested and the only imported records are the new ones. Nothing happens to the existing records that need to be updated. What should I do to make it work ?

Hello: I've spoken with FM tech support for several hours, and would like to notify the wider Filemaker community of a significant bug (Filemaker acknowledges it is a bug) in the program - and ask for your help in a work around and/or to apply pressure to Filemaker to release a patch. OVERVIEW As a developer, when I make changes to the structure of a client's database, I work on clones. I keep them free from corruption, and when I deploy them, I export my client's data from their working files to TAB or MERGE files, and import this data into my clean clones. PROBLEM In rare cases, NOT ALL RECORDS END UP IN THE NEW CLONES AFTER I IMPORT. Of course ther…

Hello FileMakers, I've been trolling through the posts and I haven't found exactly what I'm after. Although, I'm convinced this must be a pretty easy fix and I apologize if I've missed something that's already been covered. I work at a small art school in Greece. We receive prospective student applications via an e-mail form on our web site. I have made a database to help us keep track of these applications, but I haven't found a way to get all of the info into FileMaker (5.5v2 on a Mac) easily. We don't have access to an always-on Internet connection here on our little island, so the web companion is out. And I've had difficulty getting comma- or tab-delimited …

I have a field called

I have a bowling data base with a lot of bowler information in it. After a tournament for example I want to archive the data which I figured out. But what I want to do is import more records, but set my bowlerid field to 1 for the new tournament. I have tried some scripts myself but to no avail. Any help would be appreciated. P.S. I am kind of a newbie at filemaker.

Is it possible to import Excel files directly into a Runtime made with Developer 6? Thanks

Help: We receive hundreds of inquiries daily from our web sites via a form. The client e-mail address is in the BODY COPY of the e-mail in position 6, not in FROM TO. Is there a way to automatically import it into FM or do we have to cut and paste every e-mail. IT'S DRIVING US NUTS. THANK YOU

In the file selection dialog my desired file to use is dimmed out. All Available is selected on popup. The file is a tab separated file. It is called batch.xls afaik only so windows user can open easily Excel. In reality it is indeed just a text file with that extension attached. FM will not read whether the extension is removed by simply changing name or "get info" and changing name and extension field. FM cannot even do a File| Open either. BBEdit ok Text Edite ok MS Excel ok FM fails This files is born by a server side application on a non windows non mac non FM non Lasso server - how's that. It is then emailed to me. I use Mail.app OS X…

How do I import data from an appleworks database to a FM runtime. (The data is a list of names.)?

I have built a db that keeps up with leased printer information..the fields are as follows: <Printer>, <Copies>, <Supplies>, and <Supply Qty>. I also have a field <Entry Date> that auto-enters the creation date of each record. I take a monthly count of each printers' total copies, supplies and their quantities and to send that info to our vendor. I want to export this info from this db and email it instead of writing by hand. So, my question is: How do I export sorted records for any given month?

I have a text file that everyday has to be downloaded from an URL. I need to import the informations from this text file into filemaker, but the data on the text file aren't tab separated, they aren't separated by anything. How can I separate the informations and import them to filemaker automatically ?

Hi everybody. I been searching this forum for hours now, but still I miss a solution on my problem. I have and old FM4 production application and a finance system based on Access tables. My client want to have his customer info ONLY ONE PLACE and he don't want to pay for a conversion (FM 2 MSA). I've been testing the ODBC on the FM6 and it's - well let's say - not very flexible but it works. I'm able to get data from the MSA tables into FM - so far so good. But I'm missing a feature like in MSA, where I can "link" to a external data source, because even when I'm using the ODBC driver FM is making an IMPORT of the data. This means that my client have to make an …

How do you export into Dreamweaver where you create a table into which the data is put?

Dear All, IS Filemaker-Access compatible? ...CAn we import/export from Filemaker to Access database and from Access database to Filemaker? I am new to this kind of Access-Filemaker? CAn we open Access database with the same records from Filemaker files ... Thanks

Whenever I export to a text file the field names do not export. I just get data which is of very limited help when I want to export a large database to Excel. Ther must be something I am missing. Someone sugested merging the file but im not sure how to do this so any help would be very appreciated

I have two FM files, FileA sits on FMserver and FileB sits on multiple users machine. The user types several hundred records into FileB and when they are done they run a script that imports FileB into FileA using the import records. I am just using the import records script step. Is this the right way to do it? It seems that it will work for a couple of days and then it will just not import the FileB. Thanks, Brian

Hi all, I have been using a .csv-file import for a long time, and it has been working ok. It has been populating the auto-numbered fields like creation date and a unique ID. But when I started using ODBC-import for the same information, it stopped doing the auto-numbering. Is it a known issue, or have I just forgot to tick a box somewhere? Thanks, Martin

My database is designed to hold orders that customers place over our website. To get an order from the website into the DB, I have to download a specific web page and do a lot of text parsing to get it into the fields. I recently bought the Troi URL plugin to help me do this, and it lets me download the page, and from there I use the built in functions to do the parsing. However, I find that only orders with less than 14 line items will fit into the required 64,000 text limit, and since Troi downloads URLs to a text field, It too is limited by this. However we have had orders in the past with up to 30 line items (about 90k characters) The best solution I ca…

Hi, was wondering if you FM gurus would help me with something. I'm trying to parse an html form e-mail response. The html form has several fields like: 1a, 2a, 3a, 3a1, etc. I have all the fields setup in FM corresponding to all the form fields. The question is, can I paste the e-mail response into a text field in FM and then have FM go through each line and match up the text and fields? A typical e-mail response would be... 1a = Yes 2a = No 3a1 = Yes 4a = No My FM fields are... 1a, 2a, 3a, 3a1, 4a. As you can see, the html e-mail response might not return all the fields that are in my FM database. Thanks, Kermy

Hi, I'm having a problem importing an ascii comma file. When I try to import it, I am unable to specify by 'matching names'; It appears to be disabled. However, when I try importing an excel file, 'matching names' is enabled. I was originally using excel, but I have to import more than excel's column limit allows. What I need to do is be able to import a file with more than 256 columns and be able to at least map it correctly for the first run. Anyone know how I can do this?

Hi There Being a newbie to FM - I have a question - regarding importing records from a text file. I have a Time Sheet System that loads text files each day. I want to create a script that will use a calculated file name search for tat file in a designated folder and then proceed to upload that data automatically each day into FM. Can some one show me how this could be done. Thanks. Regards Michael

I have huge file, where various files will be imported, processed and then the records will be easy posted into company system. Problem is, that FileMaker is not working correctly. Matching names import is missing 50% of names. Field names import is absolute joke. FM 5.5v2, W2000, plenty of everything...

I have two related databases that I'm trying to import Excel data into. Database A is the main (parent?) database and holds basic client information. Database B is for the products that the clients in Database A have purchased (I suppose that's similar to an invoice file). The two databases are related by a serial number key field. Normally to enter a purchase I click a button in Database A which creates a new product record in database B. I enter the appropriate purchase data and then click a "Done" button which brings me back to database A. The new purchase record is then listed in a portal on the clients record. Here's the problem: I have to import a bunch of reco…

I currently export a calc (BillingLine) to a tab-delimited file for electronic billing. I am getting claims rejections because of carriage returns appearing throughout. What is the best method of stripping these returns? Billing calc is (and I'll bet the forum squeezes together the spaces, but you'll get the gist) Left(Provider & " ",20) & Left(SentTo & " ",12) & Case(IsEmpty(ConvDiag1), " ", Left(ConvDiag1 & " ",11) & Case(IsEmpty(ConvDiag2), " ", Left(ConvDiag2 & " " ,11) & Case(IsEmpty(ConvDiag3), " ", Left(ConvDiag3 & " ",11) & …

Seems like this should be an easy one, but I'm stumped. I'm trying to import only records that exist in fmp file A into fmp file B (records were lost in a crash some time ago, I need to take them from an old backup). There's no easy way to find the records in A so as to do it as a simple import into B. Is there a way that FM will examine the two fmp files and ONLY import into B those that are in A but don't exist in B (while also not touching all of the other records in ? Thx!

I have run into a few problems trying to import and export dates and time. Let me try to explain what the problem is and what I need and see if there are any solutions. 1- When exporting time to Eudora it shows up as military time but I would like to have an am/pm format. Can this be changed? The next few problems come from excel worksheets that contains statements we receive every quarter. 2- I have an excel worksheet that one of the fields contains three types of data: -it is blank -Date formated as December 3, 2002 -the Date plus a string of unnecessary words The problem is I need to extract just the date and have it formated as mm/dd/yyyy. …

I am trying to create a repeating script that will out put a text file per record with a unique name based on a field in each record. I am using FileMaker Pro 5 (MAC). This database is controlling the content for a large multimedia project for a CD-ROM. Each record is a set of fields describing a kitchen appliance. One of my layouts contains a single calculation field that concatenates the information from the other fields in a format that the Flash player can read via its loadVariables() function. I am basing that name on the unique SKU/model number for each product, as an example...uniquemodel#.txt. Right now I am forced into manually copying and pasting from …

When I export records as a text file the data exports ok but there are no field names. I want to import into Excel but with no field names it is difficult. I must be missing something but cant see where to change it. Any help please?

I've tried this post in another forum but got little response. Maybe I'll have more luck here. I have a Filemaker database set up to mimic a mySQL database. In order to initially populate the FM db, I did File > Import Records > ODBC Source and grabbed everything from the mySQL db without a hitch. Now I want to be able to use ScriptMaker to retrieve new records from the mySQL db from time to time (say, whenever the FM db is opened up). Executing the script when the file is opened is no problem.... importing the new records is! I've set up a script that runs Execute SQL to select the data from mySQL and it appears to run ok except that none of the reco…

FMP 5.5, Mac OS X.1.5 (I've also duplicated the following problem on FMP 5.0 and 6.0 on Mac OS 9.x and on FMP 5.0 on Windows 2000.) I am trying to import ~380 records, each of which has four text fields, into a FMP database (~600 records) that has the same text fields and quite a few others. One of the fields (ID) is a key field used to relate the database with three others. I have tried using a FMP file and a tab-delimited text file to import the ~380 records (they originated from an Excel for Windows file). The symptom is the same. All of the ~380 records import and all of their new records in the database display a value in the ID field. However, the ot…

I know how to import sheets of workbooks into Excel, but, is there a way to import a particular cell on a particular row into a field in FMP? I want to be able to import cells into fields. I can import the entire file and map thru relationships to those records and pull the data in, just wondering if there was a way without importing the entire worksheet. Thanks.

Hi everybody - I have the following problem: Have an RX scanner and want to buy the accompanying software to digitalise the images. the problem is that the software is for Win only. Guess I could use soft like Connectix - Virtual PC but that's the same as using a Win computer, while I'm a Mac addict. Is there another option, even if i'll probabely have to use such an interconnectivity programme to install the company's software and to get the images into my machine (am using a powerbook at the moment)? the connexion with the pc is USB120. The scans are turned into tiff images and stored in an access database. Is it imaginable that the images are imported instantly f…

Hi! I want to import several lines of text (an abstract of an article) into one field. After the text comes a delimiter of my choice, currently "

i need to create a text file from fm into a tab delimited text file format for quicken. the text file needs to have 3 tab delimited column lines at the start of the file which i am having trouble with. any ideas appreciated. sample: !TRNS TRNSTYPE DATE !SPL TRNSTYPE DATE AMOUNT !ENDTRNS TRNS INVOICE 15/12/02 SPL INVOICE 15/12/02 120.00 ENDTRNS

I've got a problem. The organization I am working for is trying to export 655 records. Doing them all at once causes FMP 5 to crash to the desktop. If I'm lucky, I don't have to recover my files. I can get it to work in smaller batches, but even then its not consistent and will crash sporadically. I'm running on Win2k with 128meg ram. The database is running stand alone. The procedure I'm using is to use the Export Records function to export to a tab delimited file. I am sorting on two related last-name, first-name fields. The export consists of fields from several related records as well as fields from the current db. The crash happens somewhere after the f…

Problem -- Over the course of a month I export 200-300 personalized emails from Filemaker to Eudora. I'm simply sending the contents of a calcuated field. I want some of the lines to be in BOLD or RED and right now I have to go through each email by hand. Is there a way to format this text in Filemaker so that I can avoid this tedious task? (HTML tags don't work.) ----Thanks in advance, The Scripting Novice

Not sure whether this belongs in ScriptMaker, Fields, Relationships, or here... I have an Import File into which I imported the raw data, processed it, and then have a script that injects it into my real files. And then it detects errors (due to duplicate info having inconsistent data). The data is being injected into two files: one the parent of the other. So, my script first fills in the fields for the parent through its own relationship to the parent file that allows creation of related records. That works great. Then it needs to create a child record. The relationship to the child file is based off a field that itself is computed from the chil…

Hi, I'm relatively new to FMPro, so pls. bear w/ me. And by-the-by, for all of you die-hard FMPro fans, it is Not My Decision to leave FMPro - that decision was made by our tech guy. I'm using Windows 2000 Professional I have this straight-up db in 5.0 - nothing fancy about it, and I'm looking to export the records and get them into Access 2000. I do have a trial copy of FMP 5.5 and our university may actually be buying 5.5 in the very near future. There are 58 fields and 4800 records in the db. When I export as .csv, the field names are eliminated (very irritating) and when I import the records into Access I wind up w/ the table and a table of errors. Whe…

Hi, I have FileMaker 5.5 Pro on mac. I can export records as Tab-delimited or WKS (but doesn't include fieldnames) How do I export field names as well to Microsoft Access? Thanks in advance, Paul

Hi there, Not sure if anyone can help with this one. It's a bit difficult. Where I work we have a database that I designed. We are a Commercial Production Company that produces radio adverts all day long. We are currently employed in the second largest contract in Europe. The problem is this. As we create radio ads we type in hundreds of scripts a day and they have to be in a special format, that being the voice directions go in a column on the left hand side of the page and then the script for each voice on the right. This would be easy to do in Filemaker in just one field by using the Alt Tab (Macintosh) key to produce the desired result. However our major probl…

I am wanting to export one record. How can this be done?

Hello to all, they promised it...but how does it works? (FM 6; Windows) I need to import images as tif-fomat into a database. As far as I understood it is merely possible when I do it manually as QuickTime... Isn't it possible to import a complete folder with tiffs like I can do with jpegs? Or is there a certain filter necessary? I would appeciate your help very much! Ludwig

To complete the first answer as I think the information I gave aren't sufficient. We are a ceramic retailer in France and we import from Italy. I started FM three years ago as a simple database. Today, I use Filemaker (Macintosh) for any purpose from accounting to sales, from ordering to statistics or list of articles. We import from at least 25 differents clients and none of them use FM Pro. For the moment, I generate all my orders via a specific (complex?) Relational Database, with an order form I edit and fax. This order form contains different fields, as N

I would like to generate all my orders via e-mail, instead of editing and faxing. My corrispondant ask for a excel document attached to an e-mail. I thought of a script to export the datas, but I doesn't know how to do it. The only solution I found so far is to export the data in a new excel document (but I need to reformat the datas sheet before sending it). Is there an other solution or already done script I could use. Thanks

I need to import some data from a text file and I have a date that on the text file it's format is year month day. In my filemaker file I want the date to have a day month year format. Does someone know how to import the date to a date field and format the date to day month year ?

Hello, I'm a fairly inadequate filemaker user who is trying to set up a mailing list/contact list database for a small company. We have numerous records in excel that I can export into Filemaker with no problems. However, I have a field in Filemaker that signifies these people as being on our mailing list, and not as a vendor. Here's my question: Is there a way to have Filemaker check off the check box indicating Mailing List as the records are being imported? I'm looking for any solution that prevents me from manually going through 40,000 records to check off a little box. This is the first import of any records whatsoever, so there are no other records in…

I try to perform a script withing a souce file: .... .... Perform Find Perform script(External..) :importing found set into file1.fp3 Perform script(External..) :importing found set into file2.fp3 ... there as no problem using FM Pro 3.0v5 but FM4 Pro closes source file right after first importing and the script interrupts. Is there any possibility prevent the source file from closing after importing from it?

Who helps me with this problem. A script in the FM source file is calling a script in the fm destination file. The script in the destination file imports the selected records form the source file. After importing the source file closes. But the script in the source file is not yet ended. So after each import, the source file has te be openend manually. What is the right solution for keeping open the source file will during and after executing importscript in destination file.

I've got an import script that seems to be screwing up. Here's the scenario: I've got Filemaker 5.5 installed on two different computers: Computer A and Computer B. I've got a database I've built on Computer A that has a script which imports order records from a text file in a folder on my desktop: Orders.txt. On Computer A, this script works perfectly fine. I've emailed both the database and Orders.txt to a hotmail account as attachments. I've downloaded both the database and Orders.txt from this account into a folder on the desktop of Computer B. When I open this database on Computer B and run the import script, the import fails - the right data …