Importing & Exporting

I use import to capture invoice line items to the invoice line item file from the quote item file. I am beginning to experience import failures. No error just fails to import. Any ideas? My FM Developer works every time! Al clients are FM7.0V3

We are usine FM 8.5 as an Electronic Medical Record system (ComChart). We have had some corruption in several database files and these have caused the system to crash. We are updating to a new version of ComChart and when we export and reimport, important data is lost. We are told that if we go to a back up prior to the introduction of the corruption, we can reinstall from that date. But then we will have empty, important information that would have to be reinserted manually. The amount of date is very large. We suspect other files are also corrupted. Is there an application that can scan FM database files looking for corruptions and reporting and even fixing …

it seems FMP won't let me export sound recordings by script. Is that correct? Is there any way of storing a sound recording so it can be exported to a file?

Hi, Probably a very simple question for most of you, but, is there any way to import a table AND its contents from one file to another? I've tried copy and paste, but it does not retain the data. Importing the table doesn't retain the data. It seems I have to import the table and then import all the data. Any way to do this all in one step? Thanks!

Hi everyone. I'm trying to export a database from FileMaker with 8402 entries into a text file of some sort (csv, tab, mer, doesn't really matter) that can then be parsed by a php file and put into MySQL. I know how to do the second part already, but I'm having lots of trouble getting the data out of FileMaker. The problem is that in one specific text field in every entry, there is a chunk of bolded text. So, whenever I export the database this formatting in every entry is lost and the whole field becomes normal text. I've tried every export format besides FileMaker, and nothing preserves it (not that they should though, since they are all basic text formats). I…

Hi everyone! Here's my problem: I connect from FileMaker to an SQL database to retreive data and display it in FileMaker layout. I do an import data on the odbc connection. Everything works well, but when I need to retrieve only some data (WHERE clause), FileMaker only display table from the odbc connection. I need a select * from odbcTable where odbcTable.field1=fileMakerLayout.field (or =variable)...

Can you export a form into Excel? I searched the topics and didn't see a solution. Basically I have a form that we currently fax to multiple vendors. Well I want that form to be downloaded into Excel. Each record would have it's own file so that may make it easier. Thanks for any help. Patrick

We need to export invoice records from our FM8.5 database to Quickbooks. The invoices are always the same type (services only) with Qty, Desc, Unit Cost, Total. We don't need to do any other type of import/export with Quickbooks. I've read many good links in this forum about plugins such as FileBooks and FmBooksConnector. Would trying to export the data manually in Filemaker using XML (or any other format) without using a plug-in be a very time consuming job, considering we only want to export invoices ? Thanks for your input

I am a commercial real estate appraiser and want to use FM 7 to maintain a database of sale transactions. Each sale is written up as a one page record. Normally, I would need to import these records (typically 4-6 in a report) to a word processing document. I utilize Open Office word processor but could export to Word document and then import that file to Open Office. I need to be able to make the FM part of the word processing document as I have to ultimately convert it to a PDF file. Any general direction on how I can pull these records into a word processing file would be greatly appreciated. Byron [email protected]

Hello All. I'm sure this question is ridiculously easy for some of you, but I am stumped. I have a series of CSV files (enrollment information for multiple years). The tables have about 70 fields each, with each in the exact same format. I have imported one table, taking the time to define the fields before I did so. I would like to use these field names and types when I import the rest of my CSV files. I know that I could do so easily if I imported the rest of the files into the same table, but I want to create separate tables from each file, then relate these tables to one another when I'm finished. Because the files tend to have the same students, I re…

Hi there, I am exporting records from FMP8 on Mac (Tiger 10.4.8) using either .tab or .csv file formats. When I then use the command line eg. 'cat testfile.tab' - the data either doesn't appear at all or is read on to a single line - the return characters dont seem to be being read correctly. For example, I have a test file with 1 field and 3 records where data in each record is 'record1' 'record2' etc. The outputted text file contains the literal data: - Where as it should appear as:- I have tried exporting in various different file formats but always get the same problem. I dont have problems reading other text files an…

Hi, I'd like to import the contents of a .txt File into a container (retaining the carriage returns if possible) based upon the matching field criteria in Filemaker to a Filename in a specific folder on the desktop. Let's say the example is that a user enters an ISBN number into a field, then executes a script that will go to a folder on the desktop that contains files labeled with the ISBN, performs a match then imports the contents of the book into a text container in Filemaker. I figure it's an Applescript embedded in Filemaker but I can't seem to work the logic out. TIA

Hello all, I am a terminal Newbie that is trying to pick up the pieces of a conceptual FM error I made. Sometime ago, I, with the very kind help of some you, managed to create an image db. Initially it was meant to a small affair and was designed to be a single file for practical reasons. What I mean in short is that I decided at its inception that I would copy the images into the image boxes. In the meantime, this little project has been used by others who turned it into this monster image DB that weighs in at 2gigs. Now I figure this not good & that I am looking for trouble. What I did do at the inception as well, was create an archive with all the orgi…

Hello Everyone, My current DB is used to import data from other sources regularly. The files that we import are tab-delimited text files. Nothing special about them, except that they usually hold 15,000 lines/records. The problem I'm having is that in a 15,000 line import, I don't always get 15,000 records. My most recent import was smaller (2319 records), but once imported, I only landed 2290 records. That is a loss of 1.3 percent of the records. Usually, I miss 1 or 2 in a 15K import. If I delete the found set after the import and cast my line for them again, I usually can land all 15K. However, this is quite unacceptable in terms of data loss. Every record t…

hi im trying to import a folder with .txt files. each file contains a number of emails that i need to sort, and structure to fit my system. when i import the files one-by-one everything works great, but when i try to import the folder the files are in, everything seems to work against me. the stand alone file take approximatly 3 sek to import (contains some 2000 entries), but when importing the folder it take 4-5 min and i only give me back some 45-50 entries. what am i doing wrong? have i missread the system?

Hi, If you import one filemaker file to another, filemaker ddr export stupidly display the imported field as it's FMP creation order. So it looses the name of the field which is imported and shows something like this Import Records [ Source: “file:Bible Articles.fp7”; Target: “products_to_ranges”; Method: Update matching; Add remaining; Character Set: “Windows ANSI”; Field Mapping: Source field 1 match with products_to_ranges::Ref absolue product Source field 4 import to products_to_ranges::import garbage Source field 734 match with products_to_ranges::id_gamme Source field 742 import to products_to_ranges::Gamme prioritaire ] of course the dest…

I'm working on a site for realator using MLS files. Basically, what I need to be able to is use the Events 4.0 plug-in to schedule a download from a password-protected FTP site, unstuff the files (.txt.gz and .tar formats), then upload the unstuffed files to my client's site, then import the data and munge it into the FMP database. I already have and am familiar with the Troi plug-ins. What I need is a plug-in to handle the unstuffing of the files and the password-protected FTP site. Can someone point me in the right direction(s)? Jim BTW - I'm on 8.5 Advanced, not Dev 7 as it says to the left (I don't know how to update that info)

Another db I've worked with (GoldMine) can save exports so users do not have to select the fields they want to export each time they run one. Does FMP have this?

I would like to have a unique file name per user when doing import or export. Short of doing a different export script line for each user... can the target filename and path be placed in a variable or field and then used during the import /export? Can this be done?

Hi I would really like to use 'Save records as PDF' with a 'Set Variable' script step that lets me specify the folder and file name. I am really struggling to make this work though, when I type the directory names it errors saying the folder is locked, even when it is exactly as the path selected using the options in this feature, which is the only way I can get it to output a PDF. I am using a Troi plug-in to 'GetPath' to the desktop folder which will then allow me to have a variable for either a mac or pc platform. Any inspiration would be much appreciated.

I can't seem to find a way to do a scripted Export that fixes the file type to Excel, without providing a Path. If I leave the Output File Path list blank, the FileType: setting won't stick, always re-setting itself back to text. I realize I could export to a known filename then rename the file, but I'd rather let the user choose the file location themselves (but not allow them to accidentally get a text instead of XLS export).

I've read that Filemaker does not support this file type and I should re-export my MDB file to something more FM friendly. However, I don't own a copy of MS-Access, so I can't re-export my file. Any ideas on how to convert a MDB file without owning a copy of MS-Access? thanx...

Good morning all. I've got an interesting one for you this morning. The System Profiler Utility in Mac OS X (I'm using 10.4.8, but it does the same under any version of 10.3 or 10.4) allows you to save a report as XML, whether you run the application, or if you use the command line version (in this way you could use cron to schedule a report every month, for example). I'd like to be able to import this XML report from each of the computers I have into a filemaker database, as it would allow me to see the specs of all the machines I have, plus, by keeping existing records when importing new reports I can see a "history" of any hardware changes on the machine. …

Hello Team, I'm having a formatting problem with exporting data. I've created a database that will allow me to track absences for the schools in my district. What I want to do is export the summary data for each school to a tabbed text file for use in Excel. I've created a layout that displays what I want to export. Note the "Preview" jpg attachment. However when I actually export the file it exports the same summary data for each school repeated for each absence. Note the "Export" jpg attachment. I have a separate table each for "Students", "Absences", and "Schools". Both the students and schools layouts have portals with fields from absences …

I am not sure if I am going about this the right way or not. have a main table, then two associated tables that are made up of uniqe parts of the main table... For exampel I have Shipping Table, Boxs Table, and Items Table. My import is of Shipping Table. Box, Item, Other Data I also have Box Table and Item Table. I want to imporot my Shipping Table then check to make sure Box number is in the Box table and Item is in the item table. All in one import script. Or should I even have the Box and Item Table? and try and pull one instance of each 'box', 'Item' out of the import? As they are there anyway?

Hello gang! I've searched for a solution to my question and am unable to come up with anything. Maybe I'm not wording it correct. When I export to Excel it generates column headers based on what I have labeled my fields. Is there anyway to make Filemaker export those "headers" to the rows (the left) in Excel rather than the columns? For my project it makes more sense for the spreadsheet to scroll down than across. I hope that makes sense. Thanks in advance for the help.

I am using the simple_table XSLT stylesheet to generate a report. Here is the problem This is a sample of the XML: <?xml version="1.0" encoding="UTF-8" ?>0 And, here is a sample of the XSLT: ?xml version="1.0" encoding="UTF-8"?> xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> ******** etc***************************** Then***************** Staff Report (by Allocations of QI Funds) I am expecting this as my title - Staff Report (by Allocations of QI Funds) 10/17/2006, instead I get Staff Report (by Allocations of QI Funds) 'M/d/yyyy' Any i…

Say you have a database with 100 schools..... Currently for each one of these schools we have 4 reports (in excel)... how can i somehow put this into file maker?... i would like to make calculations later if possible.

Hello, i'm a newbie and i'm trying to figure out some of the scripts with scriptmaker. the one i'm interested in right now is export records. I have a button that when pressed, export records. my question is this. Is there a way to automatically export the fields you want? for instance I want them to be able to export a email.csv file so they can upload it into email management system. the only fields needed for the export are email. Is there a way to customize this without the user having to delete or add fields with the "specify field order for export" dialog box? I couldn't find a previous thread on this issue. If I've missed it please f…

Hi I am facing the following problem and don't know if there is a solution, so, any help is good. I need to grab some images from a streaming video file that comes from a video source and to put theese images into Filemaker container fields. The operation now is performed with a windows XP PC and a Pinnacle TV box that digitises the video signal. The images are captured with the Pinnacle's software and after the end of the stream, are imported in the filemaker database . The operation must be updated, so that the capture and the import of the images to take place during the streaming of the video. If needed is possible to change platform or the Pinnacl…

Hello, I'm quite new to filemaker, so please bare with me. I'm working on a project that is integrating a website, filemaker app, and quickbooks. The Filemaker app displays and allows basic changes to be made to customer informaton pulled out of quick books. It also allows you to browse thru each job associated with that customer. The jobs are of a sort that requires the customer to proof a version before the actual work begins. I've got file maker loading the images, and the website also offers a method for uploading the images so they are viewable online. How can I have filemaker upload the images I've specified to the webserver? Ultimately, I'd li…

I don't see any built-in button functions that would allow me to setup a button and have FM8.5 open the scanner dialog, scan the image and import it directly into the dB. I know I can scan the image ahead of time and simply import the 'picture,' 'pdf,' etc. What I'm trying to setup is a database that one can enter home utility bill receipts and scan the bill itself to store in the dB. The idea is to create and save the image of the bills, but shred the actual paper bill. Keep everything electronically. Any suggestions greatly appreciated. ~Steve

Just moved up from calculation. It slow learning, but I am getting better each day. Anyway, I am stumped on this one. {attached coutniesexample.fp8) The details>> Two tables 1st Table>[color:red]counties([color:green]id_state,county,statecode) 2nd Table>[color:red]States([color:green]id_state,state_short) The 1st Table [color:red]counties has no info in [color:green]id_state. What I want to do is put the [color:green]id_statedata number from the [color:red]States table base on [color:green]state_short=statecode I tried an import and it just put the data at the end. I was thinking, I could do a find and replace,but that would mean I…

Hello, I see there are several topics that are similar but still different. I am looking at the possibility of converting our Mac Filemaker 3 files to PC Filemaker Pro 8.5. The records are basically names, addresses and account numbers. Not sure if this is possible from v3 to 8.5 or even from Mac to PC. Thank you for your help. Dustin

Hi wonder if someone can help? I have two tables one called "Quotes" one Called "jobs" I fill in all the fields in Quotes, when the Quote is accpeted i want to click a button to the export all the fields in that record to a new record in Jobs How can i do this :qwery:

is it possible to insert an image from a URL?

Hi - this is a real SOS as it's giving me a real headache to work out! Here is what I am trying to do: Using the import folder action within Filemaker Pro 7.0v3 (Mac OSX) to import brochure adverts that have been exported (from Quark XPress) as individual hi-res pdfs (each has its own unique reference number which can be identified by it's filename - also imported). I am then required to position those pdfs as graphics in an exact area of a printed pre-designed booking form for each customer. PROBLEM: I am having no problem importing the folder of pdfs into the container field or (obviously) positioning them where required on the page, however, when I …

Hello, I have an Excel document that has 30 rows. However, every time I import it into Filemaker, the database shows 218 records. Every record after 30 is empty, because on the Excel spreadsheet, every row after 30 is blank. How do I tell Filemaker to import *ONLY* rows in Excel that have data? -Alisun

I have a calculated text field with text styles added ie. customer name with title format. I am exporting to a text file that is loosely set up as xml format to be taken into another external program. However when exporting the title format is lost, is there a way around this?

Friends, hello I am the paulo here of Brazil, I won a MAC Performa Pro, and with him installed it is the program FILEMAKER 4.0 for MAC, I have some files that I created in him, I have a PC and I installed FILEMAKER PRO 6 for PC with windows 98 and when I tried to open a files of the filemaker of the mac appears the following message: ================================================== : This is FileMaker Pro Resease 6.0. "ARQUIVOMORTO" was created by version 4.01 of FileMaker and cannot be opened by this version. PLease use Filemaker 4.01 to view this file. ================================================== friends as I can solve this.? help me pl…

Here to fore I had a scanner that used photoshop so that each scanned document was a TIFF file that I manipulated with a script "insert picture" to get the document into a containor field in FM5. Now with FM7/8* I just bought a ScanSnap scanner that uses Acrobat 7.0 and the scanned document is now a PDF file. If I try to get the document into the container field, I see the icon for the document rather than the document itself. Is there a way to view the document as it is rather than the PDF icon. Or do I need to convert the PDF file to a picture and insert that into the FM7 container field? * FM7/8 is listed above such as I got my brand spanken' new FM8 disc from…

Hi, I need export about 70 tables in a file as dbf files for each table. Is there a lazier way of doing it at one shot without exporting 70 times? YC

Hi I wanted to post this in the sandbox but there is no New Topic Button. I want to sync my filemaker contacts with my mobile and figured the best way is to exchange information with OS X AddressBook then isync them. Comments?, Suggestions?, any thoughts or ideas? What are my options?

When importing records from a similar file with same related tables, is there a difference whether the linked serial number field is generated on creation or on commit? Seems if the linked field is generated on creation, it does not keep the relationship between tables when new files are imported. I am not sure if I understand when to use on creation or on commit for generating serial numbered fields as the related field. Frank

I wonder if I can export the same record several times with different information? For exampel: I have a customer namned: John Doe Adress: The street City: New York and he wants to order one thing called K1 and three of one thing called K2. All this information are in seperate fields. I then would like to export this record to a xls or text file that are seperated and with 2 different rows (or more if they want other products as well) like this: Name..........Adress......City...Quant.....Descrip John Doe......The street..NY......1........K1 John Doe......The street..NY......3........K2 Of course this has to work if I lookup many records also. It …

Hi, I'm a filemaker newbie and love it. One thing: I would have presumed FM is powerful enough to be able to export calendar events to iCal but I cannot seem to find a way at all. Is it possible? Or do I have too much faith in FM?

I have a folder full of email files. I have an applescript that changes all the extensions to .txt so I can import them into my FMP file. I have two fields in my FMP file, the filename and the email text. Everything works perfectly except the carriage returns that are in the email text seem to evaporate, making all the text run together. I had done this same thing using email files from Entourage and all the carriage returns came over in the import. I am now trying to do the samething with email files from Mail and though I can see that they are there in the email files, they are not there when imported. Any ideas? I am frustrated that it worked befor…

Hi, Here is my project: 1000 contacts (10 fields each) The contacts are in Excel sheet on Windows OS. I need to import those contacts into a FM version 7.1 on a MAC OS. So what I need to know: How many contact should I import in one shot? I don't know very well MAC.. is there gonna be a problem or some setting to do to make it import properly? also, is a file Contact Management.fp7 created under Windows will work under FM 7.1 MAC OS? Is there another way to do it? Any suggestions are welcome! I have already tested it under Windows and it's ok. Thanks

I'm working on a project in collaboration with another person who is likely (and with good reason) to park renamed copies & clones of the configurations I develop all over any of multiple Macs, and to assign work to various assistants. Several processes we use require importing data from one table into another table within the same file, something I'd hope would be fully scriptable. Say my file is named Alpha, and data needs to move from the Source table to the Destination table: I still want it to move between those tables even if the file is renamed Omega, without user intervention beyond launching a single script. After reading several of the threads…

Now this is really driving me batty. I have a script to import a table. Simple enough. I clear out the table, import all the records with no updating from a standalone. After the import, I need to reset the auto serial number for the record ID. Import Records[no dialog, add, roman] Next Serial Value [transactions::transaction ID,Max(transactions::transaction ID) + 1] Bring in the records, look for the biggest ID, add one and there you go. I see the table populate, but still I get 2 as the serial value. Looking at the data it should be 5. I even tried adding a "commit Records[]" step between the two and that didn't help either. Hints? Help? …

Im looking for a file format that does not truncate, saves the fieldname so that i can use the matchname on import and can be used with mulitple scripted imports to seperate tables. Suggestions .... To make matters worse the user will choose which file to import and this info set to a variable via an insert into a container and then a get as text calc to set the file location/name. This is then used in the import scripts.

Lets say that we have a field with imported names Rich, Tony, Project, The Zinman, David, / James Jodd Vaughan, Stevie Ray, And Double Trouble Mercier, Jaques, & Orchestre National D' the maximum comma values is 5 I want to extract the words so the "Rich, Tony, Project, The" Extract to Fieald A: Rich Fieald B: Tony Fieald C: Project Fieald D: The Fieald E: and the "Mercier, Jaques, & Orchestre National D'" Extract to Fieald A: Mercier Fieald B: Jaque Fieald C: & Orchestre National D Fieald D: Fieald E: Please help I have to extract 8500 names of artists and bands George Toubalis …

Hi! How can I prevent opening file in FileMaker after export? When I export data into new FileMaker file using "Export Records" script step an Admin account is automaticly created. Thanks in advance Dejan

I have a database with records regarding some houses. Apart from the details on a house there's 4 fields that contain 4 pictures. I want to export all the records (the house information i easy to export) but when it comes to pictures... can i have filemaker generate filenames for the pictures? (most records were created in 5.5 and 5.5 didn't retain filenames for the imported pictures so now if i do an export it exports to Untitled) Can i have a script that creates a folder with the record number and put in that folder the 4 pictures, and generate a name for those pictures depending on one field or another?

I'm having troubles importing from a standalone database into an updated database running under 8.5 advanced. I need to be able to pass out a new version that can update itself from an older standalone version of itself. But even doing an "import records" manually, I'm getting no records and no errors. Select "import from file", choose the old standalone, select the correct table.. Everything lines up but It looks like there is no data to import. Odd, there -is- data there.. No records are imported either. No errors reported. Any hints at all? Thanks! -jim lee

Is there a way to manipulate a file using a script? I would like to have the file loaded to the screen and have FM parse the lines and put them into fields, then make it so I can edit fields then edit or overwrite the file. Like if I needed to change value 12 to 14 on line 12 is there a way to replace a line in a txt file??

I'm brand new to Filemaker, and only slightly newer to Quickbooks. I've got a client who is wanting, what I think is, a simple FM front end that can pull Customer Names, and invoice numbers out of quick books and allow him to associate either 1 or multiple image files with a specific invoice number. Then this information needs to be published to thier website so that once the appropriate image files are published to the webserver, the client can view the images associated with said invoice number. As I'm painfully new to Filemaker and quick books, I haven't the slightest idea about how to apporach this. I've looked into FileBooks, but don't think it's really what I n…

The simple question is - when I export data out of FMP as a csv file - the carriage returns, i.e. hence all paragraph breaks, disappear. New to me, I assume the more complex question is in the character set encoding and how data is read in the target application. In fmp Help it states that in "csv export, carriage returns export as vertical tabs" - I don't understand what that means. The data is eventually being uploaded to a PHP database, but, at this stage, I'm trying to read the csv data in TextEdit, in order to isolate what I am exporting out of fmp. Any comments, helpful hints, explanations, or advice will be appreciated. Mona

Hello, I have one maybe simple but to me very annoying problem. When I import a folder of files(txt) in to some field they appear there in the order of their file names ( in my files they are automatically generated serial and datenumbers). How the heck can I import folder of files the same order they appear in my folder???I mean the oldest first and the newest last for example... FM 7 seems to like to allways import them in "numerical " order. Pleeaase help the novice!!!

Hi all, I am writing a program which retrieves the following items, 1) Bitmapped image of the entire layout. 2) XML description information, which describes all of the layout objects which were copied to the clipboard. As far XML is considered,i am getting an error.The file format of XML in clipboard is XMLO. Can anyone help in this.

Database is served of FM Server 8, the problem I'm having is when I use Import Records script to simply copy data from one table into another table (some 500 records) within the same FM file it takes soooo long! It takes longer than original import from an excel sheet into the table, but excel sheet comes from the client machine so it has to upload it to the server where both tables mentioned before reside on the server within the same file and it still takes much longer...why is this so slow? How can I make this faster? Would it be faster if I used FM Server 8 Advanced over HTTP (perhaps then all the processing will be done on the server side?)

I have a database developed in FM Advanced v8 Mac. Works great for all the clients on Mac. We have imported images into a container field for various records (only as references). Everyone has access to the same server (where the originals are stored/referenced from). However, the clients on Windows boxes cannot see any of the reference-imported images. How can I resolve this so everyone can see the images without importing them directly into the DB? On a related note - I've worked out several fields to get the file name and path - but it's specific to whichever platform imported the file (we do some files and some images - all as references). So I get a "T:/.…

I'm working on a project which involves maintaining an ever-changing list of addresses in a FM database, along with the latitude & longitude corresponding to the addresses. I want to be able to export the list and display the addresses' geo-coordinates on a Google Maps map. The problem I'm facing is that if I export the database as XML, it has all the column and row tags still in it. I need to be able to export the data in a way that Google Maps can recognize. Here is how it's supposed to look: http://www.myavenues.com/rackmap/test4.html But of course the trick is getting the data from FM. Is there any way to edit the XML tags FM uses, perhaps ditc…

How do you prevent a runtime solution database file from being imported back into Filemaker?

Is it possible to transfer FM 7 records to mac address book? Thanks

My company runs trade shows and my database keeps track of the trade show exhibitor's individual orders plus details about each show. While most of the data entry occurs at the office, we still have some show site orders and data entry that occurs on site during the event. While we have a VPN setup so that the on site people could theoretically connect into Filemaker Server to access the files, we often are working out of sites without internet access : In the past it has only been me using the database in the office and on show site so I would simply download the entire database to my laptop and upload when I got back to the office. Now we are expanding and I n…

Hi all, I have a script that does an Update Matching Records import from another FM file. After the import I need to have a found set that shows records that have been added and records that have had changes made in any of the fields designated in the import. The only found sets I can easily come up with are: Newly created records, by basing the found set on a Timestamp, or Every record that was newly created in addition to every record that was keyed to the imported records. I hope that I'm overlooking a simple solution. Thanks in advance for any help offered!

Hallo folks, I would like to synchronize a couple of files at night. The script is no problem, but how do I trigger it at night when nobody is working? I've taken a look at events plug-ins but then I have to set up a dedicated machine. Is there a way to do it without a plug in?

Help getting .csv files into fmp Hi everyone I am trying to get some PC .csv files into FMP 5.5 on a MAC OS X. when I try import or open "all available" the file is dimmed out. I am guessing I need to upgrade my FMP. I was wondering should I go just to FMP 6 or should I jump to 7 or 8. I do not really have the need to have the latest and greatest and I will still have to use 5.5 because this is what we use at work on OS 9 PPC machines. I really did not want to go to a file conversion program or open in excel because I wanted to use apple script to get this info in, and this would be a daily import so less steps would be best. Your tips or sugges…

At one time I was a decent FM guy, but that was a long time ago and my technical skills are novice level today. Here is my frustration: I am trying to bulk import text files; each file contains hundreds of what I would like to be records; each text file line is delimited by a tab or cr; each string of text I am trying to save as a records ALWAYS starts with "Starting Hand #" and ends with WINS ### I simply cannot get started with this in FM. Yes I can go to Excel, massage the text and work it that way, but it is very time consuming. My hope is to use a parsing routine to grab each "record", store it (container?) and use that as a staging tool to perform other …

When exporting a pdf file from a container field is there a way to name the file with the contents of a text field in the same record - adding the .pdf extension? Many thanks for any help.

I routinely run an import with update on matching fields and add new records a couple of times a day. Only one field is specified as a match. Typically I import about 3000 records from an ODBC source. Problem is... after a couple of imports, it begins to slow down from several hundred records per second to one record per second. At that point it is taking 50 minutes to import all the records. This is just unacceptable. I don't understand why this is happening. When I recover the file the performance picks up but then after one or two updates it back to a crawl. HELP!

I'd like to archive all my email messages in a FileMaker database. Outlook's export function doesn't really work: Exported as tab-delimited text, ONE message became 34 FileMaker records; Exported as an Excel file, each message (of several) was limited to the first 250 or so characters. Is there some sort of little program that would extract the important info (From, To, When, Subject, Message, etc.) from the Outlook database? Even to tab-delimited text. Thanks!

Hi, I'm not sure this is the right area or forum. I have a program that, upon opening, should run a batch file that connects to a server and downloads a new file via FTP. The FTP batch file works beautifully on its own, opening in a dos window, verifying, and then downloading. But when I run the batch file from Filemaker (v7),it tries to connect to the server through a Windows-type window, an hence stops working. The batch file is @echo on cls Title "Getting News Items" ftp -s:get.txt quit which then calls upon the get file, which is binary prompt n mget *.mer quit As I say, it works a treat on its own, but I …

I am wondering what the easiest way to do the following is via a script, or combination of commands... I have 1 database that will keep all records, and there will be multiple copies of the database on different laptops. I would like to take the records on the mobile dbs and add them to the main db. Unfortunately, the mobile laptops may not have access to a network so multiple users will not work. Essentially, I am looking for a merge function to combine all the files. There are several related tables and portals in the file and all fields/layouts are identical. Thanks.

Currently I use filemaker developer 7. I am importing from 30 different databases, labeled database1.fp7, database2.fp7. I want to be able to select from a drop down list a number, and then be able to click import without typing in 30 slightly different file paths (I wouldnt mind doing it once, but at the moment I'm doing it a lot for different networks and different filepaths...) If you can do this in 8.5 please tell me and i'll upgrade... Tom

When I want to retain and replicate a set of exported fields, I have always created a new script after doing the export, with the "EXPORT RECORDS" command in the script, and name script accordingly. But for some reason or other, recently my exported files tend to be in the format of the immmediately previous export and not the the fields of the script I thought I had saved Any suggestions thanks

Hey guys. So I have some data in an Excel spreadsheet I plan to import into my Filemaker file. The challenge is that the spreadsheet has the fields ADDRESS1 and ADDRESS2, which I'd like to concatenate into my Filemaker field ADDRESS. I can't see a way to do this. Can anyone help me out?

Hi I'm new to FMPRO, but have been working on a Contact Management Database, the Contact Table has 64 records in it...spouse name/DOB and such...What would be the best way to make an easy import where I could just have the First name, last name, company, and a few other fields for people to map while importing e.g. EZ Import feature. I think i can create a unrelated table and then set up a script that will set variables the go to the Contact table and create a new record then set the fields and commit/records. Is this feasible? Or just prove I'm a novice? If I did this though FM import cannot scan for duplicates. Any ideas? sean

Hello all! First of all I'm not a FM user nor intend to be one. I work with video, dvd etc.... Anyway the clinic where I work has this integrated FM system covering everything they need. Problem is the developer no longer develops, she is working on something else and now we have a problem concerning database file sizes. Our photo database reached 2gb in size so we cannot keep on using it due to FM 5 limitations. We'd like, for now, to be able to edit all the pictures inside this database to make them smaller. Most pictures are oversized since we only store the pacient's face. Is there any "easy" way to convert all these pictures without having to learn FM or hiri…

I know the answer is somewhere in the archives, but I've searched and searched. I'm building an import script for the update of a runtime. The user backs up the old version, creating a .mer file for each of the tables into a Backup Files folder. This is working fine. Then, in version2, I want to have a button that imports all the files from the Backup Files folder. However, there may exist the possibility that of the 12 files that are possible to export, bcs of no data in some tables, only 10 get exported. This causes my import script to stop at the first file not found and ask me to find it (with error capture off). With error on, which is necessary in th…

I am importing a series of records into a table with Update matching records in the found set turned on and add remaining data as new records also turned on. All of the records from the source have the same match field id, so in theory it will create the first record because it does not match anything existing, but every subsequent record will match this newly created record in the target and thus overwrite it. I have tried tests and they all work yet in my working project they generate multiple records. Any help would be appreciated.

I have found lots of info regarding sending email from filemaker, but I want filemaker to automatically take emails and turn them into records. How would I go about working that solution into my system? Thanks for any guidance.

Hi, everyone! Anytime I send an email from FM through MS Outlook I get a message asking me if I really want to do it, because it could be a virus trying to send info of my computer. ¿Is there any way to get rid of it, so the users don't realize what's going on behind the scenes? Tks.

Hi, Does anyone have any experience of using ADO with FileMaker? The idea is to create a button in an Excel spreadsheet which a user will click to update the database with information in that spreadsheet. I know FileMaker accepts ADO commands through the ODBC Driver but have no experience of this. Does anyone have any pointers or any links to tutorials etc Many thanks for any help. Ed

I would like to create a script to import records into an archive file (a duplicate of a source file). The source file has 3 or 4 tables of related records. I can create a source file script that sets up the records to be exported, but I'm not sure how to write the destination file script. I don't know, for example, how to get back to the source file and switch to the layouts that have the related records. Any help would be appreciated.

Hi! Does anyone know best way to update runtime solution? I would like to make update process as simple as I can for user with installer. I have to know more about structure of runtime databases. For example (on windows) if user installed first solution in c:Program FilesSolution. In solution folder are all .dll solution.exe and .usr files. Is there a way for user to run script from old solution, which exports all data, execute installer, opens new solution and import data into updated solution? Or just with clicking install.exe ( on end of installation runs new_solution.exe ), but here is problem: If updated solution installs on c:Program File…

I have a large database of thousands of books and have now been given hundreds of image files (that I've been able to relate to my book database by creating a separate "image path" table which stores my book ID number and the file path where the related image is stored. The images, however, have been named by the supplier so they do not instantly relate to my database) and I want to somehow, by using the book ID relationship, store the path references in my new container field in the book database so that I can view the image. As I'm relatively new to FP8 and container fields I am hoping someone may be able to help. I hope so!

Hi, I'm trying to solve a problem in one of my solutions. I need to import records daily form a .txt file. The file will always reside in the same folder, but since a new file is added each day, the name of today's file differs from that of yesterday's file. So far, I've been unable to create a script that will import the without looking for the file imported the first time I set up the script. I've considered having the user drag the .txt file into a container field and then import the contained data file, but that hasn't worked either. (I've posted a similar question in the Containers forum). What is my best way to accomplish this? Thank you for your help…

After reviewing the level of discussion here I realized I am closer to a beginner than a novice. I hope I have posted this question to the correct section. I have two databases. I want to combine them and at the same time eliminate the duplicate records. I want to be able to select three separate fields that are the same in each database, and if all three are the same, the duplicate record being imported will be deleted. I am using Filemaker Pro 8.5. Is there an easy way to do this? Steve

I'm an experienced hobby-level user of FM, and I've developed a complex relational database to keep track of D&D 3.5 character information (equipment, spells, etc.). One part of the database system (three tables and a number of scripts) would be a LOT simpler if I used a single repeating field in each of them rather than (as at present) 10 separate fields in each table. But here's the trick: one of these tables presently has 358 records, so I need a means to populate the new repeating field from the 10 standard fields—whether by exporting and then importing or with a script. Past experience has shown me that, often, the simplest way to do big data conversion…

I am not sure if it is the right place on this forum to place my question. I am importing records into FileMaker db hosted on FMSA8. The imports are done via ODBC connection every 15 minutes. I need to trigger some events each time the import is done. OR each time new record is created. Basically thru ODBC I can import the data only into a table with a certain name and into certain fields. After that I need to re-import the data into my regular tables that all users can access. I cannot use calc fields in those tables so the reimport is the only way left. Any ideas are very appreciated. Thank you!

Hi, i am running FM 8.5 client on a Mac in my office. i am trying a little test to see if I can import records from a remote Mac server into my FM DB. The remote server does not have any version of FM installed. I have placed a .tab in the Public Folder on the remote server, and on my FM desktop client I have tried to access/import the file on the remote server by: 1) Turned FM network sharing on a selecting file in prefs 2) Using the script import step ....and navigating to the file using the FM steps.....and having FM insert the file path... and doing it manually 3) Trying a variety of alternative file paths...for the hell of it...using the actual server a…

Here is my problem: I run an Excel macro to pull data off a website every 5 minutes, etc. I want a specific field in the spreadsheet to link with a corresponding field in a filemaker database, i.e. every five minutes the macro will run and the data in this field will change; I want the change to be reflected in the filemaker database through a link and not a manual script/import. Ideally, the macro will run in the background and the Filemaker database will be the only thing I use. Any suggestions? Thanks.

I have several projects (in a project database) and each project has an image folder: Project 1 > image 1.jpg > image 2.jpg > image 3.jpg Project 2 > image a.jpg > image b.jpg > image c.jpg I import the images for each project - great 1 week later I add images to project 1 do i have to reimport all of the images in the Project 1 folder or is there a way to only import the new images in the folder. The images are stored as a reference so they need to stay in this folder ... my project image folders run into hundereds so this could get very longwinded. best Stuart

how can i import a picture from scanner directly in my container fields same as "Insert Picture..." menu item?

Is there a way to export records that contain images in container fields to any format that can be viewed with plain text editor and image viewer? I simply need to load contents of a filemaker database to another data management system, written in PHP and mysql. Thanks.

I am converting a database from v6 to v8. Within the database, there is an import script. In v6, self-join lookups in the destination file were triggered. In v8, these lookups are not working - those fields are just coming up empty. I have tried changing lookups to auto-enter calcs, but no luck. In v8, are records not committed until the import is completed, rendering self-join lookups useless? Thanks in advance for any advice...

I'm trying to figure out if it is possible to link two filemaker pro 8 databases. What I would like is to be able to search one database as a read-only user, and have a button to import desired entries into the current database. The reason I want to do this is that my lab has its own private databases, but students in a course will have their own database completely unrelated to our lab, except they will need to read-only access. I was hoping there was a way to create a one stop type thing for the students so they could search ours and their databases from a single database file without having to make a duplicate of our database. We currently have our databases s…

I need to export a file as a “.tab” for import into accounting program that will only recognise it if it has a “.lst” extension. How can I do this