Importing & Exporting

Hello ! I have a Filemaker database which is alimented by 2 different persons on 2 different computers. I would like to know if it is possible to "synchronize" these 2 different versions of the database (e.g. once per day or week) so that they update each other with the new entries and/or the changes written by each persons. If this is possible, please tell me how ! Thanks for your suggestions/help. Polopo

I have a file that everyday has to be downloaded from an URL and the records have to be imported into filemaker. Is there a way to automate this using a script ? I use windows and Filemaker 6.

I am documenting a procedure for generating electronic billing. The file will be exported. I want this process automated so the user doesn't need to know anything except clicking a 'bill all outstanding services' button. I don't know how much can be controlled internally. What I wish to accomplish is this -- When user clicks "bill all outstanding services", a script (or something) does the following in one continuous process: 1) Copy the previous 'billing.tab' file (in the FM Files directory) to a backup directory (preferably renaming it to it's system date. Can this be done? 2) Execute script to find, assign invoice numbers and export the billing file. I …

We have a multi-file database on a FM server (OS X) that we access using an IP address (or AppleTalk). We also use MS Office X on Jaguar. We want to be albe to use the database for mail merges in MS Word, even though Word has built-in FileMaker connectivity, it cannot access a remote host. Is there some way around this? I have been told that we cannot share the folder on the server with our database files in it and mount that locally to gain access to the data. We can, of course, export found sets and do that, but this extra step lowers productivity and acts as a barrier to serveral users.

First off all I'm a rookie FM user and this is my first post here. I created a nice little DB for a client of mine to handle their digital images. they have very specific needs and I was very pleased to see that I could fulfill their requests by using FileMaker. In an attempt to keep things simple for the end user, I created a script to begin the import process and enter other misc. info that can be activated just by clicking on a button. My problem is that I can't seem to figure out how to change the default folder where digital images are imported to. Ideally I would like to be prompted to create a new folder each time we run an import to avoid duplicate name issues. …

Hi. Anybody know how to get Filemaker to not add in the quotation marks when files are exported? For example, what should be 1,2,3 ends up being "1","2","3" This happens when I export as comma separated text. I can't use another option, however, since the program I want to use this text file in requires comma separated text. Thanks! -Emery

Hi. I need to import strings of text that contain commas. Each string of text is separated by a carriage return. Is there a way to have FMP ignore the commas, and import each string of text "as is" into the field I've chosen? Currently, it tries to break the text up each time it encounters a comma, so I can't get it to all go into a single field. Thanks for the help! -Emery

My database is designed to keep a local copy of orders that are placed via our ecommerce web site. A third party controls our site so we don't have much say about the data format, so basically what I do is this. I type the order number into a field in a new record, then start a script, which then launches an applescript. The applescript will use IE5 to load the webpage of that specific order, grab the source code, and save it to a file. Then it will have BBEdit open the file and parse it down into manageable chunks. The HTMl is not very pretty so it requires a lot of complicated regular expressions to break down. Then the script will throw the chunks that BBEdit pars…

Is there a way to import records, but only the remaining records ? I have a FM system that pulls out data from a SQL Server database, but as the data are updated on FM in case the record happens to be updated on SQL Server I wouldn't like to update that data on the next impoort. I've tried to use the update radio button on the import window, but if I have to choose a field to be imported. The SQL Server database table doesn't have a date field so I would like to know if there is a way to import only the new records from SQL Server.

Hi everyone, I'm confused as to wher to post this (relationships forum or here), but I think the issue has to do more with exporting. I have a file where one person can have as many as 10 different machines. There are 10 fileds named "M1" through "M10", and each person is one unique record. Now I want to export this data as One-to-Many relationship, where all machines will show up in just one field names "Computers". Kinda like portal view, where all machines belonging to one person appear in one column. I realize this is structurally insane, but has anyone ever had to do this? Thanks for the input!!

Is there a way to export just a record into ms-word? Someone writes a small script to help me out? thanks

Hi everybody I'm a new user of FileMaker so I don't know it very much... I work on WinXP Professional, with Access XP and Filemaker Pro 5.5 Trial with FileMaker ODBC drivers installed I have to build an ASP page that shows data from a FileMaker database connecting by system ODBC The ODBC seems to work, in fact I can import the FM Database in an Access database using a System ODBC, but it doesn't work in the ASP page!! I shared the FM Database with the Local Data Access Companion and the file is open and not protected by any password. The page returns me: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [FileMaker][ODBC FileMaker…

Is there a way to open or import a FileMaker database into Appleworks. I have a basic database that I want to use for a client that only has AppleWorks, and I don't want to have to re-create the layouts and fields from scratch.

Ok, here's the deal. I have a template database that I work with and when data comes in from my customer I have to duplicate the correct database, rename it to the name of the data supplied, import that data into the database and export a report with the same name, but different extension. Therefore, the constant here is the name of the file will be applied to the database, imported to the database and exported from the database. I have to do this hundreds of times until the entire folder is done. I have tried to write applescripts to do this, but it all requires user interaction. I would like to do this seamlessly. Oh to add to the drama, after I export…

Is there any way to export selected records, keeping the header and footer from appearing only where the should, at the first and end. The trick to all this is that I need the out put to be in something similar to .txt I am using FM 5.5 [ February 13, 2002, 05:17 PM: Message edited by: ben1777 ]

I am importing data from FM to MYOB and MYOB requires single user access for importing. Is there anyway around this? It is a waste of our accounting dept's time to have to exit MYOB just so another person can import data. Thanks

I would like to write an Applescript and attach it to a folder (I guess that would be called a "watched folder") such that the Applescript would trigger the running of a Filemaker script upon the arrival of a new file into the watched folder. Is there a way to do this? I am lost in the Applescript syntax.

Has anyone had any experience with using the ODBC driver from MYOB.. Does it work smoothly or are there problems with it? Can anyone shed any light on how it works? Thanks in advance

Hello ! I wanted to export my database on my girlfriend ibook. I have a database containing links to pictures which are stored in a folder next to the database. I just copied the folder containing the database and the picture folder to my girlfriend ibook. Problem is that the database cannot find the pictures anymore !! Is there a solution to that ? Thanks for helping Polopo P.S. I am using filemaker pro 6 on mac os X 10.2.1. The database is quite huge with about 40 pictures linked.

Please see my post in FM Pro thread: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB26&Number=47191&page=0&view=collapsed&sb=5&o=186&fpart=1 thank you!

I have two files related by a RefNo field. The main layout shows the second file in a 12 line portal. However I need to import records into the portal so that when they arrive they pick up the current RefNo and so show up in the portal. The issue I have is how to get the records to import into the file directly from the main layout. Help please.....

This is weird, I try to import the Excel spreadsheet as text, but the fields in FileMaker import as numbers. I know that formatting fields as text in excel doesn't really change their data type, but when I do a test just with one field, format it as text in excel, and then drag it into FileMaker icon, it imports as text! So one field does, but the spreadsheet with multiple fields does not? BB

I have a situation in which our filemaker files are hosted on a remote server. We maintain our own set of databases on our local machines, but need periodically to upload the updated databases to the remote server. The problem: The databases are about 500 mg, takes forever to send over (we are using Timbuktu). We would like to be able to make a smaller copy of our local database, containing only a subset of records. In this manner, we can upload a much smaller file to the remote server. The problem is, when we make a small subset and do "copy as" in fmp, the file only reduces in size a little bit. It is as though it is still copying most or all of the original data…

Greetings! I have a question; Has anyone tried working with FM 6 and it's ability to import folders of images? I was wondering how to tie images in with data (i.e. through part numbers) using relationships, but I'm wondering how to get around the image's file extension (like .tif or .jpg)... Anybody worked with this yet? I had considered a batch renamer to strip off the extensions, but if FileMaker had thought about this in it's design I figured somebody here would know... Thank You in advance

I'm at a school and our office has a family db. Our development office bout Razor's Edge years back, and now I need to get the two talking. Ideally, I'd just like to script a weekly export or something. Does anyone have any experience in this? thanks in advance dan

OK I've got 20 artist calendars in 20 separate excel files. What I'd like to do is pull them all into 1 Filemaker file, each calendar being a layout in the file. Any way this can be done without reinventing the wheel?

Hello everyone! I have been reading various topics on this forum but I can't seem to find the solution I'm looking for, so I'm hoping someone can help. I have a runtime solution the opens with a certain password that does not allow importing and exporting of records, lets call this db1. It has over 124,000 records in it. I would like to have the users download an update called db2 which may have only 1800 new records that need to be imported into db1. What I would like to happen is the user opens db2, clicks a button that runs a script that opens db1 (with a password that allows importing and exporting) then runs an external script within db1 to import the new…

Is it possible to import field definitions from another file? I have a bunch of fields that took a long time to set up in another database and want to get a copy of them into another database.

I am in the need to export files on a regular basis to be picked up by another application on a mac running FM 5.5 or 6.0. When I run a script to export at the moment it overwrites the previous file. Is there any way to automatically add a serial numbering system to the name of the export file, or a date, or something to distinguish it from the previous file so it doesn't delete the previous one? Thanks, Kieron

Hi folks. Just want to pick your collective brains about the possibilities here. I've tried to make this as short as possible, sorry it's so long! Please hang in there... I have a client master database, with company, name, office, e-mail address etc. fields and then a series of related databases (I'll call them sub-databases) linked by a unique identifier based on company and name. All this works ok. Part of what I'm doing requires the clients' input which involves responding to a questionnaire. I then need to get this information into one of my sub-databases. At the moment it's not feasible to do it directly via Web interface for various reasons, the most…

Is there a FileMaker program that will generate a Pie Chart from my data? I found an old program called ChartMaker but I don't believe the program is currently supported. Thanks, John

Hi there! I am using a subsummary export to a tab delimited text file and I get something that looks like this (sorted by B and summary field is C with the dashes substituting for tabs): A---B---C ---B---C ---B---C A---B---C ---B---C Is there any way to get: A---B---C A---B---C A---B---C i.e. the A value on every line? Any help appreciated as I currently end up reimporting the file back into FM, running a script and exporting again. Cheers, Chris W.

Could we export a record (data included) to Ms-Word automatically? Thanks

I have a repeating field used for 5 levels of pricing. Field is set for 12 repeating, so user admin can add column pricing as needed. They want to have an export of the data to work with in Excel. PROBLEM 1) When I export, all the repeats are into one cell (albeit seperated by a (?) bullet). PROBLEM 2) How to get the data back into its respective repeated cell in fm5.5 (win)? Thanks in advance.

Hi I have a word document that is formated as such ARTIST - CD Title [return] Body of Text (lenght various per entry but always ends in a ")") [return] Record Company [return] website (not included on all entries) [return] The bold and italics are formated in the document. I would need to update these files to a database every two months. I know there is some information about scripting where you can extract rows but it confused me. Is there any way I can convert this text either to excel first. Thanks for any help. I hope i'm clear in my problem. p.s. this message board is very impressive in both knwoledge and design. Spell check is dope. sc…

can someone tell me how to limit your selections in the "specify field order"screen when exporting records. I have 33 fields but I only want to select from say 10 of them. thanks, dharkin

I have something of a huge problem here. My office has spent many weeks dragging photos into container fields of hundreds of records. It is only recently that I realized that FMP is slow at serving photos directly onto the web. The suggestion that I got was to enter the name of the photo into FMP and then display the photo having HTML search in a separate folder. So far so good. BUT, my office is going crazy trying to figure out the original names of the photos to enter them in FMP. Only the photo itself appears in the container. Is there any way to extract the name from he container? Any solutions given will save us from weeks of work. Thanks

Hi, Is there a way to only import information if it is newer than information in the existing records? The users of the database I'm making want to import a set of records from another office periodically - say every three months. They will be constantly be re-importing from the same set of records with whatever additions and updates have been entered since the last import. I understand how to create the match so existing records get updated, not reimported, but if the users of the new database have updated information, I don't want to reimport the old information. There is a modification date in each file, so I figure there must be some way to compare them, …

I have several hundred photos that were placed in a container field in a FMP database. How do I find out the name of the photos that are in each container? There does not seem to be any way to get the file name.

Hi, I have a field, that I am exporting via a calculation that inserts Quark XTags. The calculation sets up fine, and I get the desired text. However, when I export I run into a problem - it cannot export a carriage return! In other words, if I have two paragraphs in the original text, it exports as one paragraph with, weirdly enough, a column break ascii character in the middle of it. Hrmm.... Has anyone run into this problem? If so, how did you get around it? The only solution I have now is to applescript a substitution in a seperate text editor, and I hate to involve yet another program in te whole thing...

I

This is not the right forum but I couldn't find the one for "Networking". Is there any special trick on opening files as a guest in a LAN ?? This is what I am doing: -- In application preferences enable TCP/IP protocol on both PCs: host and guest. -- Open the master file and the related one as "Multiuser" on the host PC. -- On guest's PC "open remote" file and in the Hosts dialog specify the host's IP address, click Ok... FMPro stars a TCP/IP connection and comes up with an empty window of files to open.! Am I missing any step??? Thanks for any help on this... Yorch USING: - FilelMaker Pro 5.5 trial version on both PC

Our company uses FMPro 4.x on both Win2K and Mac OS 9 platforms. I am currently trying to put together a database of Freelance Developers that is searchable/usable for both platforms. In general, all seems to be working smoothly except for one glaring hole. I want to be able to attach (either embed the doc or link to it) resumes and performance reviews (Word docs or PDFs) to the records in the database. Is there a way i can do this that works on both platforms? I'm pretty sure i've used a Container field to hold docs on the PCs but that option (as I understand it, anyway) isn't available on the Mac version.

I was looking at this product to tie in our database to a publication. Promises sound good, but anybody here ever used it?

This is my first post and I dont know if this is the right place to ask this : Can I make a stand-alone file with Filemaker ? So I dont need the filemaker to run my app ... Thanks..

I recently updated two related databases and created clones of them to import current data.I did have to re-establish the relationships. After importing data into the two files(i.e. clones), the master file which has a portal set up on the main layout looked okay until I tried to create a new record. The portal should come up blank for data to be entered but it seems to already have data (it seems existing data as the key is an existing one) in the top half of the portal which is where master data is input. The lower half which will normally display data from the related file still stays blank as it is supposed to. Can anyone please help? Have I completely missed the plot…

Hello, I'm new to XML and even newer to File Maker, so this question may be foolish, but here it goes: I have a field called Pictures in my database that is of type Container. I insert pictures into this field (i.e. I do not check the "Store Only a Refernce to the File" box). When I issue a CGI command to FileMaker to return all the records, my Picture elements contain not a binary representation of the pictures, but a FileMaker reference to each picture. I'd like to receive the binary information representing the jpeg images. 1) can someone direct me to an example of a simple style sheet that I would include on the server to convert the references into actua…

HI all I am trying to import a .csv file into FM5. The fields are mapped to import into global fields, which is all working well but for one thing. I simply cannot get the first entry in the file to import. It is an 8 digit number mapped to import to a global number field. If I import it on its own to a normal number field, that works fine, but not if I try it to the global number field. Does anyone have any ideas? Many thanks Roger E

This should be simple, but I just don't find the way to do it!! I want to import records to a file via a script that performs the import without dialog but that it does apply the import option "Perform auto-enter options while importing". Is there a way to include in the import script that you want to activate the "Perform auto-enter options" option, but you do not want any dialog to open ?? Any idea on this?? Yorch

When importing data from another FileMakerPro file, the fields from the source file appearing in the import field mapping dialogue on the left side are in creation order. Is it possible to force these to appear in alphabetical order. Changing the order in the source file does not seem to have any affect. Your help would be appreciated. Chris

..From the manual I get that idea. I avoid formatting of field-information, but the MailMerge part of my project uses global userdefined fields that are intended to format them in browse mode.(style font etc.). I did not try it out yet, but do we loose the textformat information on import, ie for an update? Harryk

I have a parent file and 2 child files. The user selects a found set in the parent file to export. How do I export the related child records into their own files? Will FM make the records in the child files the found set automatically when it creates the found set in the parent file?

I have two files: one large master file with names and addresses (112,000 records) and a smaller file (450 records of a special interest subgroup created some time ago) with some of the names from the master file but out of date addresses. How do I get the new addresses into the smaller database? Basically I want to update my smaller data base with new addresses. The FMP manual is driving me crazy. Anybody willing to help a newbie?

I would like to import a folder of files into a database (all files of the same format and using the same field mapping). I was obviously happy to see the new 'Folder" import for text files, but then I discovered that the import puts the File name, location and entire file into 3 fields respectively...not really that useful. I could live with this IF I could put the entire contents into a field since I could then parse the file contents into the proper fields, but my files are larger then 100K characters (thus over the text field size limit). Does anyone have a solution that would allow a user (Mac and PC) to select a fold of files for import and then import each file (as…

We have tried exporting from FileMaker (V5) to Excel in several different formats (tab separated, dbf, dif, sylk and merge) and in all formats the information you get when you open in excel has a box everywhere there was a return used in the sending field from filemaker??? Please does anyone have any suggestions??? Thank you in advance for your help

Hi, I am trying to open a friends Microsoft Access database file but keep getting this message: You do not have the neccessary permissions to use the C:/ blankity/blank object. Have your system administrator or the person who created this object establish the appropriate permissions for you. There is no system admin as this is my friends laptop, nor did he create the database file. Here's the deal: the file was created by a client database management system which I assume is the culprit for setting the permissions. My friend no longer wants to use the database as is. He asked me to build him a Filemaker Pro data base and import all his data into that. I have…

when I import 15 megabytes of photos into a file that has an ID filed and a container field, the resulting file size is 1.6 gigabytes??? There are about 750 pictures, each in a separate record.

Good Morning! As I mentioned in my previous tread, I've been having problems importing images (just the references) into a container field and then viewing them in Filemaker on other computers on the network, via a mounted/shared folder. Well, I got it working fine, using the simple Insert Picture function, but for some reason the Batch Folder Import of images still doesn't work. Simply put, I can Insert a single picture into a container field and successfully view it through filemaker with a mounted shared folder on other computers, but when I import a folder of images, using the new folder import, and I correctly match fields, the images only show up on the comp…

I have been trying in vain for days, to find an explanation for the following, can aynone help please!!!! I go to the ODBC Data Sources (either WindowsXP or WindowsME), add the Filemaker Oracle8 Driver and under the general tab add the Datasource name etc. When I click 'Test Connection', or go into Filemaker and Import using ODBC, I get the message 'specified driver could not be loaded due to system error (126 on XP, 1157 on ME). I have contacted FM, but they don't have a clue. I thought that easy access to other data sources using FM was supposed to be a breaze! I am using FMv6, I have also tried it using FMv5.5, but with same results. Any help would…

Is it possible to export data from a file in a fixed Position Format? I dont believe I can do this in an export. Maybe I can do it in a script, putting all the data into one field and just exporting that one field. What I want to do is take a tab deliminated file that I get import it into filemaker and take it out in a fixed position format. So that the Gender is Position 1-2 First Name is Positions 3-10 Last Name is in Position 11-15 and so on. Any Ideas as to how to do this? Thanks, Janet

Hello! I'm using Filemaker 6 in a Mac OS 9.x environment and I have been having trouble sharing images in a container field over a local network. Using Filemaker's Folder import fuction, I've been successfully importing images (just as a reference) into the database. They are all in a static shared folder, that everyone using the database has access to. However, when I mount the shared folder on another computer and then try to view the images in the respective records, I either get the "Cannot Draw Picture" error or just a black field. Yet I know the information is there, as I have a calculation field that tells me whether the field is empty... I'm kind of lost... a…

How can I parse the following data format that

Dear all, Does anyone know if there's an easy way to merge 2 files? Without recreating the fields from 1 file in 2 file, and importing data. There are two related files that need to be merged into one big file. Some fields are redundant (same in both) while others are unique. I can recreate unique fields in 1 of the files, and import data into it, but I'm wondering if there's a better way Thanks

I am using filemaker pro 5 and I need to export a filemaker report to excel using DBF format. When I do so , the field names don't appear as they are on the files. When the fields are from a related file after exported to excel they have the relationship name. How can I garantee that the name in excel will be the fields name like in filemaker or how can I change the name and choose what name I want to be written in excel ? Luiza

I have two related files: a Students file and a Scores file. The Students file has a portal to the Scores file which shows different test scores for different years for different categories of tests (i.e., Reading, Math, Writing). From within Students, I want to be able to filter the Scores portal to show, say, only Reading scores over several past years. Then I want to export only these filtered records to an excel file so I can graph the trend in Reading scores over time. Can anyone give me some guidance how to do this? TIA

There are 4 divisions of my company and all 4 have different "Job Management" applications. I am pitching the use of Filemaker because of it's flexibility and ease of adaptation. The division that I work for currently uses Filemaker 5 for all of our Job Management, time keeping for payroll and billing and a bunch of other things. The payroll and billing information gets manually re-entered into the final payroll generating and invoicing software (Solomon). The common factor between all of the divisions is Solomon. They all bill and generate payroll from Solomon. If I can get the Filemaker and Solomon to shake hands, all of the divisions will easily convert to Filemaker. S…

Does anyone know how to perform an update of records in Filemaker so that it would match records from one database (update database) to another database (master database)? Example: Database 'A' has First Name, Last Name, and Email. Database 'B' just has the Email. Can I tell Database 'B' to import or update First Name and Last Name from Database 'A' based on Email? Thanks in advance, Kip

Anyone know of any tools for Migrating a FileMaker database (5.5) to an Oracle one. Thanks.

Hello, Does any one know how to connect via ODBC to the FM Server 5.5 from Windows (Excel, Access, etc.)? I'm getting a message "An error has occured while trying to gather a list of available tables". I appriciate any help. Thanks

Is there any way to export records from Filemaker Pro to Exel with column heading. My another question is can I export selected records to Exel ? If yes then can you please tell me how can we do above two things. Thanks, kakali

For those of us unfortunate souls that build kiosks... There is a show stopper bug with the export / import functions when imbedded in scripts AND you use the Developer Tool to rename the file extension. The tool should replace all occurences of .fp5 with whatever I choose. Well, it does most of the time, but not with either of these script steps, nor does it with Design Functions that refer to other files. I get an error message that still refers to .fp5, which kills the script. I tried using .dbf files, but this creates another problem: seems like I have a field that FM claims is longer that the .dbf specification, but doesn't tell me which of 500 or so it is.…

I am about to buy the Filemaker Developer, but I would appreciate 2 short answers from a Developer. 1) From within a runtime solution, so not with the help of Filemaker but just using the solution, lay-out mode is out of the question. Am I correct? I know already that you can edit a runtime-solution with Filemaker (or Developer) under certain conditions, but that's not the issue, I want to know what the user can and cannot with only that runtime solution. (Question asked because mail-merge implementation, and the way it is done, will be very tight bound without lay-out mode. No lay-out mode means for me to set this up more simple and straightforward) 2) And …

Each of our records has 1 to 4 pictures stored centrally on a server. Each of the 4 fields has a corresponding number to the image. Is there a way in FM to have it show those images w/out having to import and store them (mainly to concerve space). So for example. Click button that points # 1234 that will open file pictureserver1234.jpg and it either displays in FM or opens an in exporer, popup window etc. My main thing is that i don't want the pictures in FM, otherwise my Db will be like 2 gb's. Thanks.

I recently upgraded from Developer 5.0v3 to 5.5. Here's a problem that was fixed in 5.0v3: "Fixed a problem where importing data from a file with repeating fields, and splitting the repetitions into separate records, FileMaker Pro created new (blank) records for blank repetitions." I'm having the same problem in FileMaker Developer 5.5. Pardon my ignorance, but wouldn't it make sense that if they found and fixed the problem in 5.0v3 that it would be fixed in 5.5 before it was released? Here's what the FileMaker website says, in part, re: Developer updaters: "FileMaker plans an update to FileMaker Developer 5.5 to bring the product into synch with fixes made…

I have been trying to get MYOB to import data which exports from my FM solution. It seems that a CR is requried at the end of each line exported. and i can't seem to figure out how I can achieve this. If i manually edit the text file afterwards i can get the system to work, however with over 1000 exported entries this is not good. Any tips or tricks please. Thanks

Working for someone, they use filemaker pro 4.1, while i use 5.5 pro. I need to get the database info i have updated in 5.5 fp5 format back onto their machine into 4.1 in fp3 format, and they cannot upgrade to 5.5 pro. what sort of solutions are available to me? thanks in advance for any help k

Is it possible to export a report to either Excel or Word? Cheers Nick

A client running FMP4.0v1 on Windows98 has a lot of linked .jpg files. The problem is that with many of them, apparently at random, the links get broken. There is no apparent reason. It doesn't matter whether they're using their network, or all the files are on one non-networked computer. We're talking 5-10% of the links breaking. How could this be happening, and how can they fix it? They can't just import the pics but must link them, since with over 6,000 records and 4x5" pics (even at 72dpi) it would result in a file size larger than 2GB.

Hi folks, Does anyone know of a good way to export directly into excel, whithout going thorough an intermediary app like .dbf or .tab file? Maybe a plug-in or something? That'd be great not to have the headings butchered. I wonder when (or if) FM will convince Microsoft to honor FM export directly...

Hello all, I don't know if this is the right place to post this question, but I hope someone can help. I want to make a FM db that holds a list of contacts for my small business. These would be prospects/clients/vendors. I want to be able to check for each prospect/client "include in mailings: yes or no", and I want to designate whether they are a prospect, or a client, or vendor. I want to be able to use this list mostly for postal mailings and email mailings of newsletters etc. I want to keep track of who got what, and when. And, I want to be able to print labels from it. However, if it had a few other neat features, like keeping notes about each cl…

I have a ten file solution. The Export function is grayed out from the File Menu in only one file. I've checked 'Access Priveleges': the file has 2 passwords, both of which have Export enabled. I'm opening the file with the master password (all layout and scripts are available). The file does not appear to be corrupted, but could it be? Does anybody have any other ideas?

Hi Everyone, I'm having trouble importing dates into my database. I'm importing from a tab separated text file into a date field. The problem is that the date in the text file is a different format from my system. i.e. the text file is month/day/year and my system is day/month/year Once the data is imported, I can't seem to work with it like a normal date because it's been imported wrong. Does anybody have any suggestions? Christian Toronto, Canada

Looking for a solution to password protect an fp5 export, regardless of the user doing the export. Reason is that the export is to only be opened by one special person to prevent transfer to competitive interests. Any solution will do... This message is also posted in the security forum. Thanks.

How can I do this ?! Or ... is there a way to write a script that imports a textfile ... but not tab-delimited but with like this: "street1";"zipcode1";"place1";"description1" "street2";"zipcode2";"place2";"description2" "street3";"zipcode3";"place3";"description3" The reason: sometimes the description field contais carriage returns or tabs, which leads to errors during importing Patrick

Is there a way to link FM fields to Acrobat fields on a fillable form? I want to be able to push a button on my layout and have the data inserted into an acrobat fillable form. Any ideas or suggestions? Thanks, Joe

I have a database with 3 different tabbed layouts.....I want each layout to be its own record with its own fields in it. How do I set this up. I can't figure it out.........Thanks for your help and suggestions in advance.

Every monday Apple Resellers have to submit an inventory to Apple. We currently enter it manually into a web form, but you can submit as a file for convenience. The format of the file must be: Part Number, Sold Quantity, Returned Quantity, Available for sale quantity (all separated by tabs). I was thinking of making a report in my line items database (lines from invoices) in which I would find for the date range of the report, then sort by product, and have subsummaries for each product that could tell me the quantity sold and returned for each item... then I can get the "quantity available for sale" through a relationship to the products databse. Now …

Is it possible to export data to a textfile and include the fieldname? I want to send data to a collegue and have the fieldnames as headers but can't find a way to do that with FM's exportfunction. TIA //Henrik

DICOM Worklist is a standard for data exchange used in the medical industry. I am just starting to research it but it appears to be a standard format for different databases and other medical systems to negotiate a connection and share data and images over a TCP/IP connection. At this point it's looking like a plug-in would best handle this connection and exchange, allowing FileMaker to process the data internally. Does anyone have any experience or tips on intergrating a FM-based solution into a DICOM facility? Jodin Ravia VP of Development, Medovation Inc. [email protected] 216-472-8888 x105

I use Filemaker 4.1 / Windows for my service customer database. I just bought a new computer but have a problem transfering the database. The only writable drive that the old and new computers have in common is the floppy. The problem is that the database is a little over double the capacity of a floppy disk, even when the files are compressed. How can I transfer the files to the new computer? When copying a large file to a floppy, Filemaker won't let you simply put in another disk when one is full. Either everything fits on one disk or it won't copy any of it. I tried an elaborate scheme of breaking the database into three parts with the use of the zip drive on the …

Hello, I have created a simple database for restaurant listings. The fields are Name, Address, Town/City, State, Zip Code, and Phone Number. My listings are currently in .doc format from MS Word 2000. They are in single line form with the name with a dash(-) then the street address with a comma, then the town/city with a comma, then the state with space then the zip code with a comma, and then the phone number. Here is an example of what all my listings look like: Elkhorn Bar & Grille - 38750 Highway 82, Aspen, CO 81611, 970-925-1500 All my listings are categorized by state, so I have 50 different .doc files. There are over 11,000 listings, so…

I need for ASP pages to connect to FileMaker using ODBC. Here is the code I have: Set fmConn = Server.CreateObject("ADODB.Connection") Set fmRS = Server.CreateObject("ADODB.RecordSet") fmConn.Open "Driver={FileMaker Pro}" fmRS.Open "SELECT * FROM mainTableName", fmConn Calling Open on fmConn does not cause an error but calling Open on fmRS does. Here is the error: -2147467259, [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed I have enabled LDAC, sharing, and created a group "ALL" under Access Privileges. I am also keeping the file open. Just for testing, I have successfully linked the file into Access and I am able t…

I'm using a plug-in from Dacons called launch-it to relate specific documents to individual FM records. The plug-in relies on FileMaker's File:Open module which, by default, looks for files of type "FileMaker Pro". How can I change this to "all files"? Thanks for the help...

I have a runtime solution using 16 related files. When I update some of the data files, I want the user to update the data by themselves after downloading the required files from my site. I'm having some problems getting the scripted update to work properly. Here is the sequence of steps 1. User backs up data to one ( different folder) and exports all useful data fields into another database, into another folder. 2. User downloads a new version of the file, overwriting the old version. 3. User opens the new version of the file, and activates a script which imports all the records from the exported data. The existing records are updated, and new one…

After realizing that it would be way too tedious to import using a tab-delimited file (too many fields), I tried exporting as a DIF file and using "Matching names" as an import option. My problem is, this only imports 265 records out of 6489... no error message, it simply stops importing as if the process was done. Any hints as to what might be wrong? Is there no simpler way of exporting/importing... In concept it's pretty simple... take the records out, put them back in... why is it so complicated in practice?!

Hi do have some Files in Fmaker2 format and they are not relational, want to use them know in Fm5, which would be the best approach to do that; if I just open the files in FM5, some funktions don't work correct anymore. thanks for help

Here is my problem: I've made some changes on a file and I now need to update it at a different site, so I open the file at the other site and export all data to a fileold.fp5 I copy in the new file and when I try to import the data the fields don't match up! I need to mention I have not added any new fields, just new scripts. I then need to spend a great deal of time matching up field to field relationships before importing the data. What gives? Thanks, Jim

I have a client that has corrupted their files by constantly force quiting out of them. I am now going to import their data from the bad files into clean clones. I was planning on importing directly from the old files. Someone told me that I should first export the data into text files and then import the text files into the new clones. The reason - exporting the data into text files removes any corrupt data by removing the RTF formmating that (when corrupt data is present) removes the corruption from the data. Is that true?

I want to start faxing parts of my FM5 (Mac OS9.1) data and need suggestions/recomendation from users for faxing software compatible with FM5. Infor about advantages/disadvantages would be appreciated. Many thanks, Greg.

I am importing fields from database #1, which adds those fields to a new record in database #2. In my import script, after the fields are imported and before it closes database #1, I would like it to copy/paste the new record number (autocreated) in database #2 to a field in the original database (#1). Is this confusing enough? I have tried adding cut and paste in the script, using the relationship, but it doesn't work for some reason. Any ideas? Thanks, Dave