Importing & Exporting

I am using Outlook Express 6 Windows 98, and Filemaker Pro 6 and want to import messages from Outlook Express into Filemaker. Can anyone suggest any scripts or programs that will enable me to do this? Nothing too technical please I'm fairly new to this. Version: v6.x Platform: Windows 95/98

Does anyone know of a way to export layouts from Filemaker 6 on MacOS 9. I dont mind if the export is a PDF, JPEG, or HTML/XML as long as it can be emailed and ready to view upon reciept without having Filemaker. ------ Alex L. Version: Developer v6 Platform: Mac OS 9

I think I have one problem related to several other problems... I started out making a db for this company, eventually someone else wanted to buy it, so now there are 3 different companies running this db. Now one of the companies wants get the latest version (I still have been developing the db at the original company). The problem is I have a bunch of value lists that are different for each company. Is there an easy way to import the value lists from the previous copy of the db? On a side note, has anyone had to deal with upgrading a client to the latest version? I assume I would need to import the data into the new db

I know you can import Images (eg. JPG Files) from a directory to a container field in your database.I want to know if it can be done vice versa.I have a FMpro application which stores the images of products along with the Product information.Sometimes it is required to copy the images from a found set to a CD and send to our clients.Please help if it is possible.Thanks a million.

Task: Parse HTML tables and put each row into a FM row (record). Details: I have been given about 2 dozen team rosters in html format and I need to parse the data and import into a FileMaker database (v5 or 6

Anyone know how to export to a EDI 322 file. Electronic Data Interchange (EDI) transmits paper-based instructions and documents electronically (computer-to-computer). EDI is becoming the standard in intercompany transactions, particularly in ordering, distribution, and payable and receivable transactions. EDI allows ASI to communicate with its customers. ASI has established a global information network based on a Sun Microsystems platform and actively communicates with its business partners through networks supported by third-party vendors.

Hello, I need to export data from filemaker to a pervaisive sql database. They need csv format. I ve expoted with filemaker 6 under windows selected csv and windows ansi Filemaker puts "" around every field and uses , instead of ; and doesnt use a , or ; after the last record. does anybody know how to export from fm to in standard csv ? thx Marco

Hi all, Everytime I try to export/import to filemaker it crashes. As soon as the screen where I should pick fields to export/import it crashes without telling me what's wrong. I am running FM server 5.5 and FM Pro 6. It crashes on all machines on the network while trying to do this. Anyone have a solution? Thanks,

I'm a rookie to FileMaker using version 4.1. I would like to add several images to a collection record. At present I can only add one. I've seen other collection programs using a scroll bar so one could import several images. Does anyone know how I can do this. Remember I'm new and need your response in English. Thanks Will54

Hi folks! Since parsing basic XML files in Flash has become an easy task for ignorant newbies like me I was wondering how to make this XML editing process a little bit more efficient when thinking about working with big amounts of data. So I have come to this idea of using FM as a comfortable way to produce non dynamic XML-databases for use in small Flash applications. The problem is that after importing an XML file into FM and adding some data to it I cannot get an "updated" version of my original file, I mean when exporting that FM file back to XML. The format is totally different! Nodes, attributes, everything is gone. Is there any kind of workaroun…

Hello. I am working with Filemaker 6 and I'm constantly exporting the same fields from different found sets. Is there way to save my export description so that I'm not always scrolling through 100 fields to select the 8 that I want to export? I'd ideally like to create a script that exports the desired fields from a particular found set with the click of a button. thanks for any help!

I kinda got in trouble today. Owner wanted summary of all products sold by Customer by product. I created report and put customer and product both in sub-part above. The report displayed right. But he wanted it as straight data, so I exported it. When importing into Excel, each sub part only listed once on the colume - rest blank until the next customer/product displayed. I worked on it for hours trying to export. I even added customer and product into the second subpart and only exported that subpart - nothing worked. and finally copy/pasted all through the spreadsheet to 'fill in' this information manually. It wasn't ready for his meeting and Im in deep [censored…

Hi, well i

I have a somewhat complex problem. I need to be able to synchronize the records in a database from the filemaker server file and the local machine file. The file is accessed and changed by 4 or 5 people. I tried to use import updates as a solution, unfortunately the importing function doesn't take into account when the record was most recently updated. Thus updating and replace either the server file or local file with old information. Can someone point me to a viable solution without the use of an expensive plug-in. Thank you for your help. BTW, putting the file online is not a ideal option since my boss wants to be able to work while offline as well. Some …

Hi List, I'm using 2 PC (1 laptop and other is Decktop), some time I use my laptop to work on FM (FM Pro 6 for both PCs with same user). I would like to know how transfer date to and from 2 PCs. Thanks for help.

Hi! I have a strange problem when executing a SQL query on SQL Server by running the Import Records function with ODBC. When running the "Import Records" function the sql query runs five times on the SQL server. Setup: FileMaker PRO versions: 6.0v4, 5.5v1 Database: SQL Server 2000 on Windows 2000 ODBC: SQL Driver, FileMaker SQL Server Driver Problem: This is a simple FMP-script that creates the problem: Import Records [Restore,"DSN: TestDSN", "select * from t_ISBNLog"] When the FMP script runs once the code "select * from t_ISBNLog" is executed five times on the SQL Server, data from the last of the five queries is returned to FMP. This oc…

Hi, I've 2 databases Organizations and Contacts which are linked by a relationship whereby each organization shows several contacts thru a portal. I want to export a file for Word mailmerge purposes so that I can write to all contacts within certain organizations. Producing the export file the fields from the organization database only appear once irrespective of the number of contacts. How can I get these fields to repeat for each contact in the portal, or do I need to start off with the Contacts database and have a portal thru to the Organization database? Thanks in anticipation. Dave C

Hi I need to import contents from a Word file into Filemaker, I've heard that it's possible with something called Parsing, but I have no clue how that works. I'm designing a solution for people who would have different questions on the Word file, so would need some kind of solution where there is possibly a chance of putting the question into a field of its own as well as putting the answer into a field... Is there a script that I could write so that it could be attached to a button so it is nice and easy for low-tech users? Thanks in advance, Charly

Hi folks! Here is my dilema, I have a database that I have to import records into. However, it was originally created with repeating fields (UGH!, I inherited it). There is not enough time to make the change at this time, (this db is scheduled for revamping at a later date.) The white papers in FM are clear as mud. Any suggestions????

Can someone tell me if this is even possible? Need to save a fmp 5 file for someone who only has version 3 and 4? Is this possible?

Hi there. I've just moved a fmp solution from an old PC to my new one - 95 to XP - and have a problem getting fmp to find an ODBC data source. Out IT guys have been and installed the Oracle 8 drivers for the database I'm to connect to, but when I go to fmp and try to import - ODBC doesn't even appear as a filetype in the combo box at the bottom of the import dialogue. The data source is configured correctly, and the oracle tester can connect to it. Why does fmp not show ODBC as an option for filetype??? Cheers, G.

Hello, Does FM correctly remember the sort order for exports? I have 2 saved exports activated by script, involving different fields and different sort orders. I have checked the relevant restore sort order/save sort order boxes in the process. I have done this many times using the import function, and am doing the same thing now with these exports, but FM won't rembember the sorts and fields properly. I've double checked the 'save sort order'. Do I need to manually do the sort first or what? Thanks.

Hi, first post ever be nice. I need to import an EDL file with TONS of time code names and various details. Is there a template that exsits ? Other wise I need help in creating a template that can import EDL data it it's own searchable fields and later do all sorts of other stuff with that edl file. I have it able to import but just a big huge chunks. And a found a plug in but it does not import data it just writes the time in proper timecode. Please help.

We are upgrading our weigh count system, and now have the opportunity to get data directly via the systems RS232 port. Can anyone point me to a plug in that will allow me to directly communicate to a RS232 port on a Windows based system via filemaker. Thanks Rod Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

I've redone some of the lay-outs on my databases to increase workflow. Since i didnt change any code i figured importing the data from the 'old' db would be a breeze, but it's not. When I export the whole DB and import it the fields are not ordered correctly. Not all field are populated all the time so its kinda hard to even start trying to get them in the correct order. The dabase has LOADS of fields and relationships so re-organizing would be a hassle : I don't import/export alot and therefore i think i might be overlooking something obvious here. The fieldnames are the same so i wonder why i will not match the original db. Any help? TIA JP Plat…

I hope this is not an inappropriate vehicle to post a notice for a software writer. I don't know where else to turn to find a gifted FM genius. I have spent 13 years writing a FileMaker program for my business which is accessed through the internet. It utilizes 25 databases. I need to hand this off to someone who can continue to enhance the program and continue as IT director. The job is in Columbus, OH, although I'd discuss remote administration. Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

Dear FM Peoples, G'day, My name is Dee and I have recently been introduced to the world of FM. I am currently trying to put together a little database and I am having some problems with scripting for copy as. What I want to do in the form of a script is to 'copy as' only the current found set of records from the database. Is there an uber script person out there that will take mercy on me and give me a few script hints to achieve this?? Thanks

I am running FM 6 on FM Server (10 seats, server is Win2000). I have a file from which I wish to export a comma-separated text file, and have the resulting exported file be placed in the same location on our company's NT Server. This export script will need to be invoked from any one of six machines. I do most of my developing on a Mac OS 9.2, but the user machines are all Winboxes. In testing, I found that when I run it from machine A, the file will go where I want it. Then when I try it on machine B, FM puts it into the local application folder. If I open the script in Scriptmaker, click "specify" and lead it to the correct spot, then close it, without clickin…

Hi all, Has anyone successfully done this? I have a database of properties to rent. My client would like these displayed on a screen in their shop window in a powerpoint presentation. I would like to add a flag in the DB - "Show in presentation". I would then like to script it so that these records are exported into a powerpoint presentation. I know it is easy to show them in kiosk mode and use the pause function to delay each record showing, but the client says that this is not enough and wants to use the animation facilities in powerpoint. So what I would have is a powerpoint presentation template with preset animations and spaces for text and pictures, …

What is the best way to make a new record in another database? I want to make a button, resulting in first checking if the record doesn't allready exist, if no: copying the contents of a field from database A into a field in Database B, creating a new (related) record.

I have a standard Invoice DB that relates to a LineItem DB. In the Invoice DB there is the name and address ect but there is a portal that contains several lines from the LineItem DB. I am trying to export to a merge doc and then mail merge the Invoices into Word Documents but WORD is having trouble with the several lines that come from the LineItem portal. Is there anyway to merge into WORD after data has been exproted from a multi line portal??? Word is taking each line of the portal as a new record.

Hi there. I have medical billing software that I'd like to make do electronic billing. This requires exporting data and creating a file in NSF (National Standard Format) or print-to-file, with all of the fields placed exactly in the correct place for the weird insurance billing form. The print-to-file has to be in some kind of *.txt format, not acrobat. Anyone have any ideas on how I might accomplish this?

I have a automatic importation task who executed all the nights. I import a file text in a shared database. For this, I execute a .FP5 file that do the importation script. All this works properly on Windows, but now my server is on Red Hat Linux. So, on Red Hat Linux can't execute my .FP5 file, because I don't have FileMaker Pro Linux distribution. Give me a solution please !

Hi, I'm trying to script the export of data to a text file. I don't want the user to see the dialog box. I want the data to be saved in c: of the local machine. But the data keeps getting exported to the c: of the host machine. How can I force the data to the local drive without user intervention? Dan

I have a database that is filled with records via a script that imports data from two separate databases, A and B. What I'd like to do is to be able to change a "yes/no" field on either of the databases depending on which record is being changed. The problem is that since the record could be from either database I'm not sure how to setup a related field, if this is even the rout e to take. Thanks for the help. Jim

With over 30 fields in my databse, it takes me a lot of time to arrange the order in wich fields have to be exported or imported. Everytime I add or remove a field, I have to do this again. Is it possible to put the order in a script so it can easely be changed? Thanks John

Hi all, Anyone have experience using FMConnector? I downloaded an eval version and can connect to a copy of the database using local host but cannot connect to the production server (FM Server unlimited). The connect string is listed below, any help will be greatly appreciated. Set req = cn.Connect(Search, "10.1.7.185", , "Repair Report.fp5", , "password")

My client would like to be able to use a scanned document to populate certain fields in a FMP database. I told him this is not possible because, first of all, scanned documents are images and secondly, there is no way to delimit a field on a scanned document so that FMP could import the field in to the database. Is there a plug-in that can read a scanned document, identify certain fields and plop them into a DB record? Thanks the Mad Jammer and then... there was nothing

I am trying to use a program called streets on a disk. This is a mapping software package that constantly looks for a file called st32.txt in it's program directory. This file containes two lines the first line @address and the second line the address to search for. Now here is my problem. I have added a field in my database called @address taking care of the first line, and the data in this field is going to be the address to search for. The trouble starts when I try to export this information. Now understand that the st32.txt file only needs two lines like I stated above, so If I export using s .mer extention I will have the field name of @address and the field data…

When I bring up the window to merge fields, I can't control the scroll speed. So, if I have many variables, lining up the fields to merge is a nightmare. I can't use my keyboard to scroll up and down one variable at a time. I can't use my mouse wheel to do this either. I can't enlarge the window. The only way I can line up the variables to click above and below the pointer on the scroll window until I get lucky and the field I'm looking for shows up in the window. This can take up to ten minutes, so when importing a dozen variables, it really gets frustrating and time-consuming....not to mention a very sore finger. Any suggestions?

This is probably a stupid question and I hope its in the right forum....but here goes. I am an amateur (and pretty crappy) FileMaker user and have designed some apps for my company that we have been using for the past five years. I recently upgraded from "shared" files on our network to using the Filemaker 5.5 Server software in order to allow additional users in remote locations. In the past I have archived yearly data but taking an "active" file and duplicating it by saving it as another name and then taking the "current" file and deleting the older records. I'm sure I could have designed it better, but this method is easy and fits my needs. My problem …

Hi everyone ! When e3xporting records, is there a way to set the field delimter as a pipe (|) rather than as a comma etc ? Is there a way to set the record delimiter to a carriage return ? Thanks for any help. ~ jack

This has probably been addressed many times, but my searches aren't bearing fruit. I think there are too many topics with similar key words for me to find what I'm looking for. Plus the Forum is running slowly (or slooooowly as many have put it lately) and I'm getting antsy. Anyway, I'm importing some xml, which is, if you aren't up on xml, just plain text. What character or code should I use in a plain text file so that it is interpreted as a line break once it is imported into FM? I tried '

After searching many post I still have not found a clear cut solution to my problem. My first choice: Is it possible to display an image in a container field by specifying a path (local drive only) and not actually inserting the image in the database? Say you have a folder called "C:images" that contains img0001.jpg, img0002.jpg, img0003.jpg ... (I've tried something like this but with no success) gPath = "C:images" imagename = "img0001.jpg calcImage = gPath & imagename I would like to avoid using a plugin if it isn't necessary. If that isn't possible how about a script that can import images by specifying a folder or path.

Does anyone know of a method (AppleScript, standalone app, or otherwise) for taking raw "forms" data which has been received via email (using OSX's Mail.app) from a web site (e.g., name and address data), and converting it to tab-delimited text -- so that it can be imported into a FileMaker database?

I have a runtime solution containing 4 related files (Patient, Procedure, Diagnosis and Complication), based around the master file (Episodes). I can import all the files into an updated version of my Runtime solution. I can also import a subset of Episodes by doing a Find for dates of admission. My problem is, how do I then import the data from the 4 related files just applicable to that subset of Episodes I imported into the updated file ? I was thinking of a looping script, which goes to the first Epidsode I wish to import, then finds the related files in the 4 other files, performs import (as only the found set is imported I think), then goes to the next record i…

i have imported FMP v5 records from PC to new FMP v 6 in mac OS X panther-but "field is not modifiable" how can i modify once in mac,and continue using that template?

Quick question... I have an address book database with a calculation field that computes a vCard for that individual. Pretty simple, really, except that I need the lines in the calculation field to export with carriage returns, not line feeds. I have tried using a global field with a return chacter pasted in, but that didn't work. Any other ideas? (By the way, I have tried the xml vCard export file... it works on the local machine, but I have not figured out how to use xml files on a remote machine with a served database. That's another issue, I suppose)

folks, we'd like to export xml the simple way from fm. we have a xml-template thats values should be filled with text. completed result xml code will be in one text-field, that will be exported as plain text. no problem, but: special characters have to be converted, otherwise the xml will not work. many of these characters start with "&" and end with ";". is there a conversion-table or routine available that does the replaceing automatically?...or am i on the wrong track?

I want create FM DB only import and compile three or more excel file , after output a report to analyst. Thanks Jackie Wong

Hello Forum - I am wanting to 'push' or transfer data to Access from FileMaker as seamlessly as possible, and was hoping to utilize ODBC drivers. I want the user to be able to push a button in FM, and have the data magically appear in Access. Does anyone know how to do this so that the user has no interaction with Access? Would this require some outside plug-in or app?

I frequently export data from FileMaker from many fields. However, when I opend the exported file in Excel, it is difficult to determine which data came from which field. Is there any way to EXPORT THE FIELD name along with the data? I am sure this is possible, but I am stuck as to how. Thank you.

I have a driver I need to reach a MySQL database. I can reach it from the Terminal. But I can't get FileMaker to recognize the driver. I've gotten rid of the built-in text driver, but how do I get FM Pro (v. 6 on Mac OS X) to recognize the new driver? Thanks.

Hello, I am creating a file storing records for each of the projects we work on. For each of these projects, we will be creating binary data files which are not displayable. They do not contain text, image or speadsheet data. I would like to be able to "attach" these files to records and have them stored somewhere on the database server for easy retreival at a later date. Is this possible? Cheers, Don.

I have a need to get the latest metal prices frequently from a web page, the data is posted daily in the same format at the site. After downloading the page in text format it will be easy to extract the daily prices and place into proper fields. My question is how can I have FMP 6 automatically go to this url and import a text file version of that page? Plug-ins?......? Thanks for any ideas. Rod

I'm hoping someone can help me with a solution to my problem. I would like to stop records being deleted irretrievably from a database by a basic level user, which I can do by password control, but I don't want them to remain indefinitely in the existing database as they will affect calculations. What I am hoping to do (as simply as possible) is to "delete" the records by first exporting the so-called deleted records, to be saved in another file somewhere before actually being deleted from the file. This way they can be inspected before being actually deleted from the storage file by someone with more access than the basic user. I would appreciate any advice …

I am working on a database that needs to be able to export data in "Fixed length Format". Is FileMaker capable of exporting data in this format? I could not find any mention of this in my filemaker books or websites.

Hey! I want to make a csv export, and then import it in oracle. My problem is that scandinavian becomes wrong. How can I take control? (I assume the file is in MacRoman an we need ISO8859-1?) Gisle

I have a solution built in FM5.5 to import excel docs. As I found out (should've known), the runtime version of the solution cannot import excel docs. Just wondering if FM6 runtime solutions can and/or can FM 6 on OS9 run even convert this solution to FM 6? Are there any other options? Sorry I have previously posted this question in an incorrect category.

When I export data from a Filemaker and the fields have names like _cName, _cAddress, _cTxNm. These field names are exported as they are and I haven

Hi, I have a web developer designing a program for our firm. I need to extract data from filemaker and upload it to the web program via ftp. I am exporting the data as a "mer" file. The process of uploading the database from filemaker into this new program will be automated and be done periodically. The problem is the developer now wants a "flag" at the end of my mer file to identify that the upload has been completed. e.g %%END OF FILE%% at the end of the merge records Obviously I want to automate this export into a script, Is there anyway of exporting to a file with the text %% END OF FILE%% appended to the end of the data? I honestly don't t…

Ok.. so here's the situation I have one databsae of products from which I want to generate my orders. The fields include company, category, sku, price, total, etc etc So I can sort for example, for everything I want from Company A, or I can sort for everything I need for a certain department.... makes sense? Now what I want to do is find all my Company A's that I want to order from and export that data to my purchase order database. But here's the catch - when I import them into the POs, it creates a new record for each product, but what I want it to do is place all the products in a list on the PO page, rather than create a new PO for each individual product.…

Seeking Simple quick solution: an org. currently has several excel spreadsheets (one per department) with contact names and address. This has to be imported into three related databases & de-duped contact name address (related to name) department category (related to name) how to approach this task - these excel lists are about 1000 people long and there are 8 of them. should i import them into a de-duping database with tick boxes & get a script to place data in different databases and delete the dupes, or is it quicker just to do it all manually in excel? or even better is there a fm tool to do this? thanks

Can I export to a file where the name is automaticly formed in a format with date/time as in MM-DD-YY-HH-MM and if so, how can I do this? John

Hi there, Had some great responses before so thought I'd try my luck again :-) See my attached file-sample of what we have. I'd like to know if there is a seperate field/script which could be used to export the records based on the first field. First set of records begin with B3RA,next set begin with B3RB,next set B3RC amd so on. Can something be done to export individual records, into seperate .csv files, based on their first 4 (or 5 or 6 or 7 etc) figures? Thanks in advance sample file.txt

Creating a smallish FMPro tool to do something Access can't (or not easily) I need to combine data from separate records into a repeating field. < Filemaker Techinfo article > ought to help but doesn't cos it refers to ScriptMaker functions in v2.x which are different in v5.0 (what I'm using). Specifically, "Reserialize", "Paste literal" (is this the same as "Insert text"? and the Lookup "DATABASENAME.FM=Copy contents of Index when Trigger matches a new entry in Trigger" (Index and Trigger being fields in the current database which is DATABASENAME.FM).

When my program runs properly, the size of an exported record is about 240KB. But sometimes I have problems where the exported data size jumps to 5.5 MGB as if it were duplicating the entire program. I am using FM 6 on Windows XP. Thanks for your ideas.

Has anyone figured out how to simulate the Define Import Dialog, since it isn't a Scriptmaker option. What I'd like to do is give a user the ability to import CSV or tab-separated values by mapping fields in the input file with the fields in an FM file. Steve

Hi there, just want to know how can i export the database to a file that user will not able to view the data insite the file. Just like if using notepad to open then it only will display out all the funny words (~!@#$%^&), like a binary text file. Regards, Henry

Is there any way to maintain formatting during the import/export process? I just spent two days trying to get the formatting right on a field (i.e., looking in Filemaker like I need it to look when I export it to a different program, likely a word processing program). But when I did a test export and opened it in a word processing program, all the formatting (mostly Carriage Returns) was gone. Suggestions?

I have a filemaker file with keywords and descriptions. I have an image in each file. Lets say it was a file about the zoo. I would like to find a way to automate the creation of web pages using filemaker. I would like the web page to contain the picture , the description and the keyword, I would also like the file to be named with an html tag after the name of the picture graphic. So if the picture said " elephant" the web page with the elephant would be elephant.html.. Is this doable with filemaker? Thanks

Hi, I want to import from a CSV-file, but one of the fields in the database is a multiple selection field. What is the seperating character for this (ascii code)? I can't seem to get it working... Thanks,

The situation: Let's say I have an empty FMP file, and I want to import records (by script) from another FMP file, which is the same, except for the fact that it contains 100 records. Each record in the file is identified by an ID field, incremented by 1 everytime a new record is created, because of the field: option/auto enter setting. ID number of the 100 records to be imported are between 1 and 150, because 50 records were deleted. My problem: How can I import these 100 records while keeping their ID numbers unchanged (unselecting "perform auto enter option while importing"), but at the same time having the ID for the next record to be created in the rec…

Hi, We recently purchased a biometric time clock EC205FP. The interface on this thing looks like it was made in 1950. So DOS looking it is sad. I'm considering setting up a filemaker database to put the info into instead of using the DOS looking thing they have. The information is downloaded off the time clock via our network as a ASCII file. Then imported into their DOS looking database. Question: Is it possible to import the ASCII file into a Filemaker database? This would be so much nicer then the current interface we are forced to use. I all ready have a Production time database that could be used for this if I can import the ASCII file into…

Hi all i am kinda new to FM andi looked trought the forums and coulnd find the solution to my problem. this is what i want to do: background: i want to wirte an invetory control program, for computer parts, ie have loads of RAM for example and when the items come into the office there have serial numbers, these sometimes are in batchs, ie batch of 50 with sequeential serial numbers. so this is what i wanna do, i want to be able to have an auto incermental script for serial numbers which will auto incerment serial numbers accordingly to the amout that is entered in the quantity field. qty: [] start serial number: [] [generate] <--butt…

Ijust got FM 6 and I'm a newbee, I tried to bring over a file into FM 6 from AW6 as ASCII file only to find that more than five or more entries where missing and some entries were duplicated? Without the original format that they were entered as? Help! Frank

I'm writing a script to export a found set from DB1 to DB2. Found set in DB1 will be deleted after the export. The delete is the problem. Many people use the database so a default password is used. Access privileges for the default password allow Browse, Print, Export, Create, and Edit. Only the administrator can delete records. DB1 and DB2 have the same access privileges. I need the capability to have the user click on a button to export/delete the records. I have scripted a buttom to generate the found set, export the records, and delete the records in DB1. The script will not delete the records because the default password doesn't allow deletion of recor…

Hi, I've got some raw faults ticket data (ext is.rep normally) which I'd like some views on if I can use in FM.I've attached a small dummy sample. I just want to do the normal stuff-find, sort etc but the way the data is presented is rather strange-each "complete" record is seperated from the next by a space.Look at the text file and I'd appreciate some views as it's something I've never seen before and excel cant import the whole file because it has too many lines Thanks in advance Sandy ITSD4_small.txt

I have a Quote Database; A user will create a new quote, entering in the customer # and then a support database will bring in the customer name and address. The user will then enter in a part number, description, qty and price. After this is entered, the user will click on a button to generate quote. Another file opens up a form, the information from the screen where they entered in the information, will send the information to the Quote form. It has worked fine for 6 months and all of a sudden, it is bringing in the information, but then brings in part numbers, descriptions, qty's and price of other items from other quotes. Help! do you have any ideas on what is goi…

I loss my images when i transfer my database from 1 computer to another. My images are linked to the database and even if I drag my whole folder over my network or save to cd and transfer that way the images go. Any idea's? I have over 9000 images so re-linking is not an easy option

How do I give the user in a script the choice wich file he wants to import. The script uses a pre defined set of fields to import. If you'd be so kind to give me the script steps I'll be most thankfull. Thanks, John

This question has probably been answered before, but I recently imported records into FM and the data for each record was preceded and followed by quotation marks. I don't know why or the easiest way to get rid of the quotes. Apparently, the original DB required these quotes

My system produces invoices, which have to be exported to Sage Line 100 accounts package. We do this by exporting from FM into a CSV spreadsheet. Sage requires that we have to add a header line with field names to the CSV file to allow importing of these records. My client wants the process to be more automated ( and therefore more secure). We run FM 6.0 / FM Server on a 10 user Windows 2000 network Any help much appreciated. Kind regards, Andrew Bruno

Hi, I have Filemaker 5.0 database application. I now want to migrate it onto SQL Server but keep Filemaker as the front end user interface. Is it possible? How is it done ? and what kind of time frames are we looking at ?

Hello, Is there someone who can tell me what's the best way to export records from DB1 to DB2 and after the data is export i will delete this data in DB1. Every hour i will do the same but the data in db2 must be in place. who can help me?

Hi, I have a FM6.4 client with FMServer 5.5, on intel 1.8ghz boxes, 100base network When setting up ODBC with WORD. 800 records take over 15min to import table. Any ideas? ta Rafal

My client bought FM 6 because he heard that we can export data to SQL. Anybody want to confirm or deny this? I went thru the book that came with it and it had nothing. I also went to the export function and I don't see anything about SQL. Maybe I can connect to SQL Server some other way? Don

Is it possible to Import A File With a pipe (|) character as a Field Seperator?

Hi Everyone! Situation: I have a database that contains a bunch of system fields that I use to calculate all kinds of stuff as well as to store many different types of information. Some of these fields the user MUST have edit access too (calcualtion & scripting purposes). I was asked to put a "Generic Export" button on each layout. Issue: I have a concern about these fields. Some do contain critical data. I would like to keep these users from "Exporting" these fields. Question: Does anyone know of a method where I can create a "Export Layout" that has fields listed that they can "Check" then click on an "Export" button and it only…

My DB are simple: film lists with text field only in English and Traditional Chinese. FMP (6.04) doesn't really cope too well with Traditional Chinese. To get a readable sentence, my field in 2Bytes encoding needs to be twice as long as the space occupied by the Chinese words. However this works, except for the "Find" mode as 2 Bites encoding uses chars out of the accepted program range. However I manage to type Chinese and read it. The problem is the export as I need to generate HTML pages. I use Jaguar and tested Panther. Neither of them returns me a tab delimited file I can successfully convert in Traditional Chinese. I used Word, and everything else with no su…

I have a database tracks the processing of laboratory samples for a specific genetic condition. The samples database includes the results from various lab tests. There is a related database that catalogs the physicians around the country who submitted the samples. We needed a monthly report that shows how may of each type of sample were submitted from which zip codes. Thanks to help in this forum, I made the report work by using a subsummary party and sorting by zip. It works great. Now the principal investigator wants to have this report exported so that she can work with it in Excel. I don't think that FMP can handle this and my plan is to export the raw da…

In a hosted environment, I am building a scripted export that will export records to a tab delimited file in a directory that another (new custom) application will check every 5 minutes or so. If it finds a file, it will open it (exclusively) and import the data, and then it will delete the file. In order to avoid a situation where Person B exports a file that overwrites one Person A just exported (and before it was read by the new application), every export will contain all records previously exported that day. My thinking was that if the exported file was open and couldn't be overwritten (because the data was being read), I could trap for that error, wait a specified am…

I wasn't sure where to post this, so I apologise if it is in the wrong forum, and if so, could a moderator please move it to the correct place. I have a very old database in Filemaker 1. I cannot find my copy of Filemaker 1. I now own a newer version of FileMaker, but cannot open the .fm files which were created with FileMaker 1. Does anyone know a way I can convert these files to a newer version? Is there a free solution to this problem? As far as I know it is only FileMaker 1 and 2 which will read Filemaker 1 files and convert them. I now only have the newer version of Filemaker, so I am stuck in converting the files. Is there any free conversion software availab…

I'm new to the board and have been using FileMaker Pro for a little bit. I'm looking for any suggestions on creating a database so that you can import orders from X-Cart. For those who do not know what X-Cart is, it's a internet shopping cart that exports the orders similiar to this: So in this example, there are 3 orders, John Smith ordered 4 items, Jan Doe ordered 1 and Chris Can ordered 2 items. Have 2 FM files, one that imports the raw orders (7 records), and the other would use a portal to get the information to create 1 record per customer. The problem that I have is, how would I have the orders imported once per customer? I hope t…

My company would like to be able to produce graphical timelines from a FileMaker database of information we've entered. Basically, we'd like to be able to input dates (the deadlines) for certain projects along with descriptions as to what's due each date and have some sort of timeline printed out. Currently we have to enter everything by and hand and then make the table in Word, but I'm looking for a solution that can show all the information "graphically" instead of just a boring [date - description] table from Word. We'd also like the timeline to be able to update itself automatically when the information in FileMaker is updated. Does that make sense? Right now, l…

I know very little (almost NIL) about FMP. I am developing a VB application for a customer which connects to their FMP 6 database to insert/update data from outside sources. I have used ADO with a Microsoft Generic OLE-DB Provider using an FMP ODBC DSN. My program works perfectly in testing against my copy of their database, although a little slow, and I acknowledge the posts I have read with regard to slow FMP ODBC access. We can accept the slowness. However, when I point my application at the production FMP database, which I am told is the same structure as the test database I was sent to work with (no data) I get the following error: "-21472179…

Hi there, I'm helping a friend create a filemaker database (well, it's done already) but he'd prefer to import his previous appleworks info into filemaker, but appleworks doesnt have an export function. Does anyone know if its possible to import appleworks info and if so how? Thanks

Hi all, I am trying to use SQL UPDATE command to update a field defined as Time field. What I noticed is if I do it after 10:00 AM then the code works fine. If I do it before 10 AM then I get a ODBC error - Invalid Date Value. I am inserting the code snippet here. The tstring is a string value that is being passed to the SQL string. I printed SQL string just before execution. Every thing looks fine. But when the statement is executed I get the ODBC error. For eg.; say I executed the SQL at 1:22:15 AM the value in tstring is 01:22:15 AM. Same as in SQL String, but when the SQL is executed the ODBC error I get say Invalid Date Value 1:22:15 PM. …

I'm having trouble appending new records to an existing database using the trial version of FMP. I've tried In Browse mode I select Add New Records from the File menu, and have tried using every Import Action (Add New Records, Replace Data in New Found Set, and Update Matching Records with/without Add Remaining Records checked). Every time, all the records in the existing database are replaced by the new ones, instead of being added to.

so there's this database that i've been working on since the beginning of summer for my internship.... basically, it's a large DB that combines invoicing, quoting, contact lists, billing, accounts payables, etc for the company. so anyway, my boss asked me if this badboy is compatible with quickbooks... i've never used QB before, and i don't have much of an idea as to what it is (except for some fancy program that people use to account for their company's invoicing/billing'n stuff...). is there a program that i can buy/use that will take data from my database(s) and import the stuff into QB? i looked online for some things and it looks like that all the programs…