Importing & Exporting

I am importing Excel data into just a standard inventory database (via Import from a file). The import works just fine. But I'd like to run some sort of validation when I import so that I can check any errors committed while in Excel; for instance, I have a uniqueness requirement on asset tag numbers that doesn't seem to catch duplicates upon import. I don't know what the best way to do this would be. If there is a duplicate validation option in Excel that I could use instead, that would be fine. I would appreciate any suggestions. Thanks and have a good day! Bob Lehner Hemlock Public Schools Hemlock, MI

Hi, does anyone know if it is possible to export an appointment from a filemaker database field to MS Outlook? I read somewhere that it might be possible using DDE executes but I have no idea how to use this. I know that there are dedicated plugins out there, like Outlook Manipulator, but the problem is that this one is not a Filemaker 7 native plugin and only supports english fonts - I am Greek and I want the title and other information related to the appointment to be in Greek. I contacted Productive Computing and they say that I could pay them $150/hour to enter the Greek character set into the plugin or wait for a FM7 version whenever they decide to make o…

I try to find a solution to import vcf Files (plain text) into a simple FM7 address database. Anyone having experiences with the import of vcf files into Filemaker? I tried to write a little script doing that job for me. Does anyone have an idea how to split a single textfile that contains all the names and addresses into single records. Usually Tabs or commas are used to devide fields, in that case vcf records are marked by "BEGIN:CARD" and "END:CARD" within the textfile thanks for your help norbert

We are working on an export in FMPDSORESULT with XSL. In the database, we have some fields (ancestor, current element, child of the current element) which represents the tree of the XML file. With XSL and FMPDSORESULT, is it possible to rebuild the tree? We have already a similar script in Lingo, but in XSL, it's more easy to use. Thanks for help. Aub_Beb

Ok, say I have an old file with tabels, data, and everything else. I want to create a new blank database and then import a certain tabel out of the old file into the new database. How would I do this? (Just export and inmort ONLY a tabel, without the data?)

Importing a folder of image files or QuickTime movies fails when importing as a guest of a shared database. The images do not appear to the host or other guests of the database and after closing and reopening the file, they no longer appear even to the guest who added them. Can this be resolved??? Any Suggestions would be very welcome, Cheers Colleen

I'm creating a database in FP7 on my own machine (running Mac OS 10.3) for use on a client's computer (running Windows XP). My client isn't very computer savvy (nor am I, really), so I'd like to create a button on the database to automatically export all of the data to a Word file. I know that I can export the data in tabbed and comma separated formats, but I wish to create a very specifically formatted Word file. This is easy enough using Word X for my machine, but I have no idea how to do it in a Windows environment. The client is running Word 2002 for Windows...anyone have any ideas on how to do an automated export in a specific format for Word 2002? I am also open to …

I have converted a pdf file to RTF and I want to import it (3 fields) into a table. The fields consist of a part no., description, price. This where I get lost. Any help would be appreciated. I have attached a sample of the data file. sample.zip

Cross my heart .... I have done a search. So I must be missing something. I am trying to import data into Table2 in a file. No matter what I do, FMP wants to import the data into Table1. How on earth do I tell it where to put the data?

Not sure where to put this ... I need to move data from Act to FM7. Act records had no unique sn so I exported to FM, serialized and imported back to Act. I can pull the regular record Contact info no problem ... but I can't seem to export the Activities, Notes and History. Does anyone know 1) If there is an active Act forum (like we have here for FM) in which I can get answers or 2) Know how to capture this information? It appears to be a related file but I can't get it. I searched for Act and Symantec and find 100,000 hits but no active forums. Pete

Does anyone know how or if it is possible to download beb info from IMDB.com or amazon.com like movie info or so. If yes how? Is there some SQL/xml used?? Is there a simple way.. please help me i have no idea on how to do this. Thanks TMAS

Hi All, I was fairly sure I had done this before, but I can't seem to get it to work now. Basically I need to export text from my Filemaker solution in order to create a dos batch file. So, as an example I need a text calculation field to export something like: REM Example batch file :Start <tab>echo hello <tab>echo hope you can help! :End There's more to it obviously, but that should solve my drama.... Can this be done? So far everything I've tried converts the return and tab (well ctrl-tab) characters to something almost entirely useless.... Cheers... Sean!

Hi, I wanted to export some data into a report made with InDesign 2. I couldn't use any of the export type options so I finally used the desktop snapshot feature to make image files with the data I wanted to export. Unfortunately the printing quality of the image files wasn't very good. InDesign only recognizes the tab and comma-separated text types, but these don't retain the layout format of the original data, as displayed in Filemaker. Any suggestions? Thanks a lot Juan

Hi. I have a solution where I pick records from file A and via a button "send records to file B" I activate a script in file B - importing the selection from file A. This have been working fine developing on my computer only, and some testing on clients using the solution when its running on a FM server 5.5. But now the import order has been shuffled ! When I stop the server and check the script/import order on the files locally (with a FM client) everything is OK. When I start the server and try the script on a client on the network - the order is messed up again... Is the saved field mapping local - not server based? Like a global actually is a local gl…

My main file, Dealers, has a portal that shows the related records from Contacts. I need to be able to export the information from Dealers with only the first Contact from the portal which will probably change each time we export. My idea is to create fields in the Dealer file for first and last names, email, etc. then create an export script that when selected will take the information from the first row of the portal for contacts and insert it in to the fields in Dealers. That way we are just exporting 1 contact. Is there a better way?

I've been trying to write a script to pull information out of one field and put it into a plain text (Notepad or WordPad) file. I'm aware of the FMP7 (have ordered it for our network and expecting it any day) new "export field" script step, but I'm not sure exporting it will put it in a plain text format. Any suggestions?

OK, so I've got FMP 4.0v3 running on Mac OS 9, and I want to export the records into Mac Address Book 3.1.1 (v301) running on Mac OS X Panther. I downloaded AddressBook Importer 2, but I still can't get it to export successfully. Anyone have a fix for this? I don't care if it costs money at this point, because the only other solution (according to my boss) is for me to RETYPE all 3600 files into the Mac Address Book. I will quit my job before I do that.

I have an existing application which exports data to excel. I then take the data from excel to Filemaker where I append it to a database. In my Filemaker Database, I have comments and reviewer comments. I used to have both fields in my excel sheet, but now only the comments are in it. I am having a hard time making Filemaker NOT try and import these reviewer comments. It should be totally ignoring them so I can just enter them in my Filemaker app. I can get the import mapping screen to allow me to break these links and keep the links broken. The end result should be that I import all data except my reviewer comments, then enter the reviewer comments in the FM app. …

I have a database that I routinely have to export to sync with another application on a handheld unit. I've found that one field will consistently not export it's contents (text) in DBF or Comma Separated formats. The field ends up empty (i.e., as ""), save the occasional "0" inside it. The field exports correctly in Tab Separated and in MER formats. I have a work-around, but I'd like to find out why this is happening. This is a text field of two to five characters, and the field has a name of "Category," with a label of the same name. It occurs with both FM Pro 4.1 and 5.5 on Mac and Windows. Any suggestions would be appreciated. Thanks. Mike D.

Hi all, this is my first time in the forum, so please excuse me if I should be posting this in another area of the site. Basically, I am new to FileMaker Pro and am currently using version 7 here at work. I have been playing around with it and am just trying to run an SQL query **within** Filemaker Pro (I remember this sort of functionality being in MS Access). But so far, I keep on encountering an error message which I can't figure out. Thus far, I have been using the ScriptMaker feature of the tool experimenting with many different SQL formats (i.e. single quotes, double quotes, ; and no ;, etc.) My query is: SELECT 'Support_Equipment'.'EID' FROM 'Supp…

With help from kind people in this discussion site, I've managed to create a report that shows Running Totals within control groups (see P.S. below). My columnar report shows what I want, the way I want it. NOW, I want TO EXPORT the data, exactly as shown on the report. Everything exports fine EXCEPT the Running Total figures. The exported running total values are INCORRECT if there's more than one "row" in a control group. (Export seems to pick the first value in a running total set, rather than the resulting total as shown on the report). Advice anyone?______ P.S. In case you don't follow my Running Totals within control group idea, read on. In FM there is a fe…

Trying to get an ODBC connection between FileMaker 6 and data stored in a SAS data store, using the SAS ODBC driver. When attempting to import records into Filemaker, all seems to go well, I can connect to the tables, set up a query to import, but when I press the "execute" button, it fails with "[sAS][sAS ODBC Driver]Base Table Not Found (-1)". Any advice greatly appreciated

I have a FM6 database that I used to import large text files, 20,000 to 100,000 records into a text field. I then find and deleted the blank records and then looped through the remaining records looking for certain characters in specific locations that identified data I was looking for. Yesterday I converted this solution to FM7. When I attempted to import the text file I got the familiar import window telling me how many bytes are remaining to import. The progress bar shows about 2/3 complete when it stops for about 5 minutes and then continues on with the script. When I look at the record count I realized that 10000 or so of the 40000 records never got imported. …

Hey there, I need to import data from an older FM solution which was designed with very large tables into a new solution that uses many more tables and relationships. The Import function doesn't seem to let you import into more than one table, so I'm trying to figure out how to do it. As an example, I have a customer table. Customers have addresses and phone numbers. In the old DB the customer table had all the address fields (street, city, etc) duplicated 3 times over for up to 3 different addresses, and there were 5 phone number fields. The new DB has a many-to-many relationship set up for phone numbers, and 3 1-to-1 relationships for the addresses. …

I have data from a FM6 solution which I want to import into a FM7 solution. The FM7 solution was opened in FM7 from the version 6. A lot of data has been entered in the 7 version but I need to transfer it to the version 6 solution on another machine, I know it would be simpler to go over to FM 7 altogether, but my company wants to stick with FM 6.Help.....

hello everyone, i have a contact database with over a thousand addresses in it which i would like to export to apple's address book application. is this possible? i want to have everything in address book because it is integrated with many other applications such as mail and safari, but i don't like the limitations of address book. ideally i would work with my fm pro database and just export everything to address book every now and then to keep it up to date. any suggestions are highly appreciated many thanks alexandra

I have script which imports a tab delimited file into FM7. The problem is that if i choose to perform without a dialog, FM forgets to import as ANSI. If i deselect the perform without dialog, the script import works as desired. Is this another annoying bug or does someone have an answer? Thanks

Hi, I have a small FileMaker database with just 10 fields which is available on the web via CDML/php. The data for this database is coming of the Excel spreadsheets. At the moment I import the data from them into FileMaker directly. Is there any way to make it possible for people who can access it only from the web to import those records from Excel (or maybe csv, tab) files? Thanks a lot.

Our FM database records come from a CSV file. This CSV file will be updated everyday. How can I import only the new records in CSV file? Thanks!

I've never thought about this before, but if someone is modifying records in a FileMaker file from which you are importing, would those records currently in use be ignored, imported with changed data, or imported with data existing just prior to the last record entry? Any thoughts or previous experience to divulge?

They Gave my a 350 pages in a txt file (from Word) with repeating informations for about 1300 persons I copy 2 persons info to see the way they type them... ( Oh God) ___________________ First Name Jim Last Name Nestor Company Sony Position Product Manager Phone 210 7758029 First Name Anna Last Name Nikey Company Globe One Position General Manager Phone 210 5044874 etc How Can import the data in to correct fields ...:? As you can see there no tab ...only paragraphs _____________________ My Fm Fields First Name Last Name Company Position Phone

Am I missing something here, or has FM really dropped the ball? Can it be true that I can't import data from an .fp5 file into a .fp7 file without converting it first? I can get data from excel, dbase, and a host of text and xml formats. But not an earlier version of filemaker?!? The problem is that I have a distributed solution in FM 6. I want to be able to send out an update to users that will bring their data into my re-worked version 7 solution. During the reign of FM 6, I had a way of bringing data from one set of .fp5 files into an updated set of .fp5 files using batch programs to copy the old FM files and scripts to import data into the my new and improve…

After a couple hours of Internet searching, I have decided to post my delimma here. We publish a newspaper with 7 different editors across the country. We used to import Word files into Quark, but 1) production got sick of being bombarded with Word emails and 2) importing Word files brings in all sorts of extra styles and screw up our styles. I found and started using a nifty program called DiStyler from Abstrakt, which lets you export Quark tagged documents from FileMaker to individual text files and thus maintains your bolding, italization, etc, when imported into Quark. We use FileMaker Server for the editors to post their stories and then production outputs …

I am trying to export selected fields from a record that contains a portal. I want to export only the first line in the portal, and not all of the lines in the portal. How do I limit things to just the first line?

I have a tab-delimited file and the first record is the field name. I want to create an fp5 file with the same field names. Dragging the file to Dev. 6 creates a record out of the names. When I start by creating a new file, it wants the field names. And I can't import until I create a file! I searched forums ... I really did. But I admit I only looked for an hour, trying every keyword I could think of. Still, here I am ... Please tell me I won't have to manually create 205 field names for a migration file? Lie if you have to ...

The MySQL DB I'm attempting to import has many records with fields containing new line characters. FM treats these as record separators regardless of the various ways I try to delineate fields within records (eg, enclosing each field in quotes). Any tips on how to handle records like this? thanks!

Hi, I'm relatively new to scripting - and desperately trying to create a script in my main database that would import records (in the background) into 5 separate related databases from 5 different files. The problem is that when in the main database, the "Import Records"- script command only allows to import records into the main database. Among other ideas, I've tried an "Open" (related database)-command before "Import Records"-step, but despite that the script is stubbornly trying to import the records only into the main DB. I'm probably trying to do this in a fundamentally wrong way - I'd really appreciate if someone could point me into right direction.…

What are people doing to save historical information about Found Record Sets? Every week I hand out a list of records based on a found set and would like to reference these records later down the road. Any ideas you may have to share would be greatly appreciated. Cheers!

I

Hey! I am trying to export records from my database with defined blank areas in each line. Currently I am using text export with tab delimiters. For example; 1234 name number anothernumber I know that I can limit an field to a set size using left(1234,4) that sets the first field to 4 characters. How do I set the spaces between the fields? Say I want 2 spaces from the "1234" and the "name" fields then I want 4 spaces from the "name" field to the "number" field. Thanks for the help, RAD DAD

Hi, Please help me! In my database I have one field which I am exporting to an html file, and another field which I would like to use as the filename - does anyone know how I can do this? All help is very much appreciated! FileMaker Version: 7 Platform: Windows XP

Hi Folks, I am currently merging FM Pro with my x-cart e-commerce website and I have a couple questions. The x-cart system uses the MySql database and imports ONLY using CSV. I have several tables in my FM database including a thumbmnails table I have successfully exported data in several fields into the CSV format and then imported into my website, but I cant seem to do it with the images. Am I right in saying that CSV will NOT support images (thumbnails, etc..)?? Or am I not exporting properly? Thanks, Collie www.germansupply.com

hello everyone, i would like to import the records from this database website: http://improvdb.fr.st/ into my own fm pro database. can someone please point me in the right direction on how to do this? in the help files i've seen only html exporting mentioned. ideally the records of the website would be directly imported into my existing contact database. many thanks in advance alexandra

How do I import one field in multiple records into another file with one repeating field. I thought you concanate with "^21"? Help appreciated.

I'm having trouble exporting when I access a database over the web. The way I'm exporting is through a button. I want to be able to run a searchand then export only the found records from other computers via instant web publishing. However when I click the export button it spins then stops, although works when I'm working directly with the database. Any ideas? Much appreciated.

Hello FM folks. Am I the only person so far to have need of HTML exports from FM7 that use special characters (euro symbols, accents, that kind of thing)? It seems that while FM6 was quite happy to encode such characters as proper HTML entities, FM7 just doesn't bother, which is a real problem if you want to turn exported data into web pages... Does anyone know of a useful workaround for this? A plugin, even? FileMaker themselves are characteristically unhelpful - not sure it had even occurred to them that this feature might be worth including. Thanks for your help.

Hi, This is probably really simple. When I import records to a table (Current_Table) that may or may not update certain fields, I want to have a copy of any records with those fields updated copied to another table (Archive_Table) before the record is changed. There are seven fields in the table; one key field, two that change on every update (Date and Time), don't want to archive those. When an update changes any of the four other fields I want to write the whole record to the Archive_Table, then update the record. I've thought of some very kluge ways to do this that involve archiving everything, but there must be an elegant technique out there. Thank…

I

hello everyone, i often copy all fields from my contact database records onto the clipboard to paste the data into emails etc., using the "copy record" script. because usually not all fields are filled out (home phone, work phone, home fax, work fax, etc.) the data appears with gaps once it's pasted into something else. is there a way to select all data from a record and have all fields appear on separate lines when pasted, preferably so that empty fields are ignored? so that someone with only name, email and home phone would appear like this: name email home phone instead of something like this: name email home phone…

Hi people, My goal here is have a record with three fields. Name; Address; City State Zip format. What would be the best or easiest way to import a MS Word file that is formated in a three line label. The problem I get is when exporting from Word I get each line as a new record. So my txt file comes out as: Name Address City State Zip and not as one record with three fields per record. Name Address City State Zip Thanks in advance

I am a relative newcomer to Filemaker, using Version 5.5, and either I've missed something or I am trying to achieve something that is not possible. How can I, when importing completely new data using the FileImport Records function, establish a relationship to another file for the new data? Scenario: File A (e.g. Book Titles) includes a field called ID Number with the Auto Enter option File B (e.g. Barcode Numbers) includes a field called ID Number as a regular Text field. This would be the match field. I now want to import completely new data from either a FP file or an other file (e.g. Excel) that contains data for both files Having create…

I am trying to place scanned documents into containers. I scan them, save as pict files and the import them into FMP. The problem I am running into is when scanning at higher resolution, the 8 1/2 by 11 inch document images are much larger than that size (when the container graphic is set to crop) within FMP. Then if I try to reduce the size by selecting reduce image size, the image looks horrible, even if I try I click the Maintain Original Proportions. If I reduce the dpi scanning resolution, I can get the image of the correct size but again quality suffers. What am I missing here? TIA

Does anyone know how to import a FoxPro 2.6 Memo Field into FileMaker? We have FM 5, 6 and 7 as possible import platforms available. Thanks in advance.

I am trying to set up an ODBC connection to a Visual FoxPro database residing on a Windows Server 2004, following the instructions in the FileMaker help file. The ODBC driver on the Win server is set up accordingly, but when it comes to setting up my Mac to connect to the server, I just don't get it. Do I have to set up a driver on this machine too? Help anybody?

From File Maker I connect to the oracle databse and try to select a value from a table and store it in a field in Filemaker. For eg. SELECT name from EMP where empno = 25. How do I store the 'name' received from Oracle to a field in Filemaker?

Hi, I've got a database with three tables. When I try to import records from a Tab delimited text file using the File|Import menu, it always goes to a certain table and doesn't give me the chioce to choose a different table. Oddly, when I set up a script to import, it lets me choose any of the three tables. This happens no matter what layout is selected. I must be doing something stupid, what do you think it is? Thanks, Jerry

Is there a way to set character set for ODBC import? The option box which is available when importing a file is grayed out when importing from ODBC source. I'm having difficulties when trying to import data from MySQL which contains scandinavian letters. If i switch character set to windows (ANSI) the scandinavian letters come right, but this can't be done with ODBC import. Any advice? Thanks Using OS X 10.3.3 and FileMaker 7

I hope this is the right place for this. I have a client who runs server 5.5 and version 6 desktop clients, 14 clients. Their business involves multiple databases, with one database being a collection of pictures. This pictures database reachs the 2GB limit of the server roughly every 2 months. They have a procedure for catching it before the limit hits and backing up the older records to cd's using date ranges that are made available if those pictures are needed for further reference. the cd's are just copys of the pictures database with records removed based on dates as a primary key. The problem is the process they go through to do this is time consuming and the…

I'm trying to access the API on a web site that takes XML commands via HTTPS. I have troi URL which seems like it could do the trick. Unfortunatly, i'm getting stuck. I have to send headers along with the data. Anyone have any idea how to send headers and XML data via HTTPS in FM 5? I don't mind using a plug-in if i have to. Like i said, i have troi URL if that helps. Thanks -ja

I'm creating a new database and need to import some mixed (english and Japanese) data from a .txt file. Some fields (name, address, company) can contain both roman and japanese character sets. How do I prepare the field in the database to receive the data? I tried the usual setup, but I get gibberish in the fields. NOTE - in the Import Field Mapping dialog box, I can see the Japanese characters, but upon hittinng "import" the data is corrupted. Thanks in advance! FileMaker Version: 7 Platform: Mac OS X Panther

Hi, I have been unsuccessfully trying to upload a FM export to a departmental web site. It would only upload the first line. I found that opening the export on an XP machine and re-saving with Line Feed character fixed the problem. Can I get FM to insert this character into the export, or perhaps triger an Apple script that will do it? It doesn't take long to do it manually but I am trying to make it a 1 buton process in FM because I don't always run the export. David

Please confirm that in FMP6 if you were importing from another FMP6 file it would only import the found set from the source file. But now with FMP7 it ignores the found set and import all records. is the a bug, or a new way of doing things

Hi All, Anyone have or know of a HL7 Engine for importing and exporting FMP? Thanks in advance, flowe

I am very new to FileMaker. I have an Excel file that I need to import into two tables in FileMaker. The Excel file has columns like StudentFirstName, StudentLastName, Classroom, GradeLevel, etc. Two of the FileMaker tables are Students and Academics. The two tables are related. The FileMaker Students table has fields like StuID, StuFirstName, StuLastName. The Academics table has fields like StuID (foreign key from Students table), ClassroomNum (from a Classrooms table), GradeLevel (from a GradeLevels table), and Teacher (a calculated field from a Teachers table). I want data from the "student columns" in my Excel file to go into the Students table and d…

I'm a bit new to databases but I'm very confused about this. I can make simple reports but I need to export lists of names (formlists; I'm a teacher) to an indesign document. I can't seem to just 'select' text across cells in a table or report like one does in excel (why not, it seems so fundamental?). The export text feature is longwinded if I want to quickly access 10 different classes and if I do the whole lot at once (grouped by class) there's no way to tell where one class ends and another starts. The only solution I've got is to export a report as a .pdf file (via Mac OS X) then select classes from there. Any help for a database newby would be appreciated!…

Hi guys... is there anyway create 2 import templates in a file and permanently saving it. My project has 2 kind of import.. One is importing a csv file from excel and the other is importing back a previous record of filemaker. Importing back the previous filemaker record is easy and doesn't needs much remapping but after doin so my import order for importing the csv files gets affected as well and i will have to remap the whole import order again. Is there anything i can do to get out of this recursive mapping of import order? Please help! Thanks

In the 'learn it when you need it philosphy,' I've just tried importing from a repeating field (10 reps) to create new records into a another file. However, I see that new records (10 records) were created for every repeating field, whether or not there were any data in each repetition. Is there any way to create records for only those repetitions with data? Thanks!

I'm running 5.5v1 (the 5.5v2 updater can't find filemaker pro to update) and am trying to test moving to OSX (panther) from 9.2.2. I was waiting for the EPS printing problem to get fixed before updating. The problem is that I'm trying to import some files. They are text files (tab-separated) and they come from a PC. The 9.2.2 process is to run CTC to change the end-of-line character to x0A and then File/Import Records and they show up in the openfile dialog and I select the one I want and select tab-separated text and click Open and it works. When I'm in OS X.3.3, and select File/Import Records, I get the openfiles dialog box, but the files that I just imported…

I have a FileMaker 7 database with two tables. I'm attempting to do an import, but FM isn't letting me choose which table is my target. It defaults to the first table created in the database. Is there a way around this? Thank you for your help. - Enzo

I am making an application for people with very low computer literacy. They will have some attachments to include as part of the data they will be entering. If I only want to allow PDFs, graphics and plain text files, I can use import folder and just have them keep the files in folders and write a script to import it. When I do this, I get the file name in one field and a thumbnail in the other. this is perfect, and exactly what I want, but I also need to include .rtf and .doc files as potential file types, and this import feature does not import them. I can have them import the .rtf and .doc files into a container by right clicking the container field and the…

Hello! I have an Access database that I have created a System ODBC Datasource for. Within FileMaker 6, I import a table from Access. This process works correctly when done through the menues. I am trying to script this procedure. When I save the script and test it, it continually opens the File Open dialog box. Even though I am importing from ODBC rather than from a file. If I press cancel, the script fails. I would be very appreciative if anyone knows how to script an import using ODBC and can help me out. Thanks! Daniel Burge FileMaker Version: 6 Platform: Windows XP

is there a way, on OSX, to connect Filemaker to a MySQL database? I wanna pass data back and forth... but mostly from Filemaker to MySQL. Thanks -Stephen Cox

Hi guys.. is it possible for the export function to export records individually and also ensure tht importing back of records is done as easily? I've tried exporting my records in CSV format and it looks pretty messy when i open it up using wordpad. When i try to import back into my application the fields got all mixed up. Any suggestions on how i can improve on the exporting? Thanks FileMaker Version: 6 Platform: Windows 95/98

Hello, I need to rename a file currently used to import records (via import script). The import order involves alot of fields which would be a pain having to do it all again. Will the import order stay intact if I change the file name in the script. The file itself will be the same. I need to change from 'all.xls' to 'all.csv'. When viewing both these files in Excel they appear the same. FileMaker Version: 6 Platform: Windows XP

I need to import a text file that includes, among other things, one field that contains a small table. In this text file, the table if formatted using blanks and line breaks (^l). As usual, records are separated by carriage returns (^p in Word), and fields are separated by a tab (^t). Now, if I save this document as a text file, Word turns ALL line breaks into carriage returns. I know for a fact that FileMaker does recognize line breaks in a text field, but how do I represent them in Word text document? (I have already tried the "save as text with line breaks" option - it doesn't work) FileMaker Version: 5 Platform: Mac OS X Panther

We are using FileMaker 5.5. I have never used FileMaker before, but I am quite familiar with databases like Access and Excel (and I know VBA within these applciations). I have been asked to create a program to import new clients into a FileMaker database. I found some instructions on-line for importing, and it looks pretty straightforward. However, we are going to be using this process a lot, and I would like to know if it is possible to create and save an Import template, so we are not cosntantly having to map all the import fields every time we do an import. If so, can someone point me in the right direction for accomplishing this? Thanks. F…

Hello all from a newbie, I am attempting to construct a database from multiple excel spreadsheets. Each sheet contains titles of electronic journals with the usage statistics each journal has had per month. Because of the way users access e-journals I have usage stats for the same title but through different portals. I have discovered how to match by journal title when importing from the different sheets, but I want to add each total onto the same title. I can match by title but cannot figure how to add each seperate figure together for the complete usage total. Does anyone have an idea how to do this? Any help would be much appreciated! FileMaker Vers…

Hello all, I have an Excel spreadsheet that has a field with multiple values from a survey (ie - a,b,d,f,g,j). I need to import those values into a checkbox field in FMP. When I do the import, only those records with a single entry (ie - : show up checked properly, although if I change the field type to standard data entry, all the information shows up. Is there some way I need to separate out the information prior to (or after) the import? Thanks for your help!

I am building a soultion which tracks individual images inside of a larger job. Right now, I enter the image thumbnail into the portal which creates a new record in the "Images" file. This is helpfull to me because all of the overall job info is automatically built into the image record in the "Images" file. I was hoping to use import to bring in an entire folder of images into the portal so that I don't have to insert them one at a time. I would like to use a script to import a folder full of images, and I would like to specify which folder to use each time I run the script. When I use "Import Records" in a script though, I am not allowed to specify a folder - inst…

Is there a way to have FM import new records only if the record does not exist in the target file? (my source file is a .csv) Platform: Windows XP

hi. hope i am right here for my question. i have a problem with importing imagefiles stored within the web. e.g. http://www.test.com/test.jpg. i tried successfully the url plugin of troi.com but this works only with raw ascii data i think. in the url plugin faq i read that the mime type of the http protocol isn

I'm getting married in July. I have a FileMaker database with the guest list, whether they are comign or not, etc. I also have their address info. However, I would rather have that address info in the OS X Address book and just pull it into FileMaker when I want to print guest list reports, etc. Is there any way to synchronize between the OS X Address book and Filemaker? I've seen FM2AB but I would like something that would let me relate 1 record in the db to 1 record in the Address Book for the synching. Thanks Chirs

I am looking for a solution which enables the Mac OSX Address Book data to be used in place of an address book created in FileMaker. Something like a fully integrated FileMaker/Address Book with flows of information from at least the Address Book into FileMaker if not both directions. I would like to be able to call up information held in Address Book for use in a FileMaker database with out having to resort to copy/paste or some sort of vCard exchange.

Here is my question: Is there anyway possible to Auto Export using a field name as the file name. For instance I have a Field called "File Name" In that I have a set of numbers 1234. Then I have a separate field that auto -enters letters ABCD. I want to export chosen field(No Dialog) but I want the file name to be 1234ABCD. Any Chance?? FileMaker Version: 5 Platform: Windows XP

I'd some symbols(alpha, beta,..Greek) fonts in a text field of FM4 data base. When I import/export it in the script into another FM4, the symbols changed into regular english (alpha -> a, beta-> b..) fonts before import/export. I'd read one of posted message "how to retain the export text format in Upper/lower case, but not symbols. Is there any way to retain/keep the text format (including upper, lower, symbols, bold, underline..., whatever the format was in) before/after import/export ? Thanx. G. Hsu FileMaker Version: 4 Platform: Windows XP

howdy howdy. i am attempting to create a layout that i can export into an emailable text format attachment so that the recipient would be able to open it as a, say, word document. The layout has text fields, but also number, and calculation. So, i'm trying to figure two things. the first is most important, and a bit urgent. 1. How to export the layout to a Word format (if possible). 2. How to enter a script that would enable me to export the file into emailable format, and then email it thru Eudora, too. Any assitance with either aspect would be much obliged. Aloha! Version: v6.x Platform: Windows XP

Is it possible to import a table into another file? I'm interested in replicating the structure of multiple tables in one file, and dread the thought of recreating all the fields over and over again. Once I set up the tables, I know I can import all the data -- I'd just love to find a way to import the table structures into one file. Any advice? Thanks. FileMaker Version: 7 Platform: Windows XP

I'm looking for a way to parse out data from one field into single records. The current field lists values with a carriage return . So, for instance, the field "date" may have 5 lines: 1/10/04 2/1/04 3/1/04 4/15/04 5/20/04 I want to parse out each line into a separate record, so that my "new date field" will have 1 date only in the field. If there are 5 dates listed, I would end up with 5 records. The number of line entries in the field varies by record. Animal record 1 may have 3 lines of dates, animal 2 may have 5 lines, etc. I think I came across a formula for doing this, but I can't find it now. Can someone please point me in the right…

Is it possible for FileMaker to access an Exchange Server, import email and populate fields? hope hope . . . . Version: v7.x Platform: Mac OS X Jaguar

Hi, I have five .fm databases that I am importing into another database as part of my application. Currently, I have them set up nicely to import without duplication, yadda yadda... However, one of the four databases presents a slightly different import order. i.e. In the four that import correctly, field order in the import dialogue is: ... Display (imported) -> Display ID (not imported) IDX (imported) -> IDX Type (imported) -> Type In the misbehaving database, import order is, so what happens is: ... Display (imported) -> Display Type (should be imported) ID (shouldn't be imported) -> IDX IDX (import…

I'm trying to export a friend's fm database for conversion into html. When my friend entered data into fm, he ignored his caps/caps lock key and let fm take over the function of putting a cap at the beginning of each entry and display the rest in lower case. When I export to a text file, I end up with entries that are all caps or all lower case, rendering the data useless. I am relatively new to fm and although I'm sure the fix is simple, I can't find the answer anywhere. How do I do this? And can anyone recommend a good and comprehensive book on using fm - this is not a user friendly program once one gets past the basics. Thanks! Version: v6.x …

whenever anyone sends me an order off my site i get this email: --------- FORM DATA STARTS HERE --------- <First Name> Potato <Last Name> Head <Email> [email protected] <Email Confirmed> [email protected] <Address> Potato House Highland Road Northburog Shiringhamshire IG7 4FX Twoodeland <Refered By> friend <Friend's Email> [email protected] <DVD> Saving Private Ryan <Gift> portabledvd <Comments> make it snappy! <Terms> on <Mobile/Phone Number> 07548 531468 ---------- FORM DATA ENDS HERE ---------- Now t…

Situation: FMU under W2K Pro imports ODBC data from MySQL db over TCP/IP via a script in ScriptMaker at five-minute intervals (with Events plug-in). This works great, until I restart FMU. After restart, FMU imports duplicate records, despite the following: 1) The Import Records script step was setup to Update records and Add remaining records, with three fields to match. 2) One of the fields it has to match is defined in FM has having to be Unique (field is a date/time stamp accurate to the second, and there are no two records with exactly the same date/time stamp in the MySQL db). Once I restart FMU the script imports, but duplicates records instead of u…

Hello People! I could sware I saw some posts about date issues and now are nowhere to be found on the forums....but perhaps I dream about it. In any case, I get an odd FM result when importing data from CSV file. In CSV file mu "date field" is in format of mm/dd/yyyy and "date field" in FM accepts it fine but the "2yk -like" issue appears where FM field is defined as DATE 1/22/2001 is imported as 1/22/1901 if I define the field (in FM) as TEXT or NUMBER it imports year in 2 digit 1/22/2001 is imported as 1/22/01 FM is updated and auto-entry into date fields is in correct format...it is only the import that troubles me. Any advice is appr…

I'm having difficulty getting information from a report I've constructed to display appropriately in a word doc. The report lists all of the vendors used for a client, along with contact info, etc. The same vendor is often used multiple times for different items, and the report shows the vendor information only one time (as it should!) because I've displayed all the pertinent information in just a subsummary section. The problem: when I export the info to a tab separated text file and then pull up the information in word, the vendors show up multiple times again, even though they displayed on the report correctly. The FM book says I can export just one record for …

anybody have a trick on how to export a header with the tab files?

I would like to enter a line return

Can someone tell me how to copy a filemaker report to a Microsoft word file so that I can do some editing? For example, I need to mark some record red for the report but I can't do that directly on the report on filemaker pro. Can I ? The other reason is that I need to send the report to those who don't have filemaker pro on their computer but only microsoft office. Thanks. Jie

Hi I am new to FM (I used to used Datapower on my trusty Acorns, RiscOS is good but now old!) on the Mac I need to drag Title,Surname and address and postcode files out of FM and into my DTP package, to write letters and create other files for clients, these will be using different records at different times but always the selected (currentn) record. This was a cinch on Datapower, but I can't even get FM to add all the above fields into one, and then I need to export all. I tried creating a container field with select all text on entry and you can copy and paste that, but how do I get all my fields into one field ?? Hope you can help - I might add that FM on t…

I'm wondering if there is an easy way to export field titles to a CSV? You know, the first line are the fields titles. I have 103 fields I need to export, I know I could set up a record number 1 and run a 103 line set field script that would set all 103 fields to the title (some of my exported fields are globals so that causes a problem I'll have to work out later). My guess is that there is an easier way to do this. This DB will be run on a weekly basis, therefore I need some sort of script for the user. Any thoughts? Thanks. Version: Developer v6 Platform: Windows XP