Importing & Exporting

I have a script to export a found set of records as a .csv file, but I would like the file to be named dynamically. As it is now, the file is named untitled.csv Is it possible to have the filename also include the date of the export. ie export-oct-01-04 ? Thanks

I am trying to import data as a .csv and it is coming in with extra spaces in some of the fields. Is there a way int he import script or another script or calculation to have it delete unnecessary spaces in all the records? Thanks

I need to import a .dbf file into FileMaker 6. (?) Can't. I can't even see it. So I tried opening the file in excel. It came in all funny. The info was all there but it was "staggered". Any ideas would be helpful.

I'm exporting from FMP 5.5 differents reports to Excel 2003 (Clients reports, solds items, statistics, etc)

Exporting text field data to a .slk file truncates text at 253 characters. Is this the limit? What do I need to do to export more text for use in an Excel file?

I am exporting a file to excel. A single field in FM appears as follows (there are reasons why this cannot be separated). When importing to Excel a small box appears after each line, I assume this is a symbol for paragraph mark. Any way to remove these? 226 Seismology LDEO PO Box 1000 61 Route 9W

I would like to export records by date to a csv file. It needs to run without to much user intervention, ie; it knows what has been exported in the past so it only exports the "new" files. TIA-Mark

From Troi File, I can managed an automatic exporting of a some records from a 40 files solution into a text-tab file in a diskette. But I don't know how can I split these 40 Tab-files (aprox 100 Kb. each) in different diskettes of 1,3 megas, because there is no enough room for all of them in just 1 diskette. How can I script these process? Any ideas, please?

Are there any way in Filemaker via scriptmaker to have automatized an importing, but, in one case, made it from Folder A; in other case (per exemple, branch number 2> go to folder n

I have a Win2K SQL database that I would like to export to a file and then import it into FMP7. I have tried to export MDF, LDF, and SQL formats to a single file however FMP7 can not import them. The manual says that I need to connect to the database via ODBC to import, however I would prefer to import from a static file. The SQL db is complex therefore I would like to convert it all over at one time as opposed to rebuilding the db using Excel exports. Is there an alternative to connecting via ODBC? Best Rob Nokes Sounddogs.com

Does FMpro 6 have the ability to import live or streaming data on a continuous basis from another program that offers an http server or xml api? Both programs run locally. Any links or additional info appreciated.

Hi everyone, I need to export data from filemaker on to SQl server 2000. I was hoping on using SQl's DTS tool, is that possible? Has anyone ever created a DTS using filemaker db as a source? if so please HELP! thanks Zeina

OK, I'm a newbie to FMP. I have a "database" in Excel I need to import to FMP and convert to numbers. For example, if the field in Excel is "Unemployed" I want that to be a "1" in FMP, if "Employed" in Excel, then "2" in FMP. No clue how to do that. Sorry for the total newbiness, and thanks for the help.

This one is pretty specific. But basically I use a series of filemaker fields to build an html calculation field which I then export in a tab separated text file. The tab separated file is renamed .html, then attached to an e-mail to form an html e-mail newsletter using a program called GroupMail Pro. However there is a problem. This is all done on PCs and the e-mails display fine on PCs. However when we come to view them on Macs then for every line break there is a square character. This happens in Entourage X, Mail.app, and Thunderbird When viewing the source of the message it seems many of the line breaks and quotation marks in the code hav…

Well, I searched ... found similar but not this. And I've been trying to figure it out but everything I've tried still takes a LOT of manual work. I will be presented with 250+ Excel worksheets. These worksheets have a Synch number (which I can use as a match field) and then the column labels are stock codes. The data will be text in 125 of the worksheets and a date in the other 125. I am attempting to automate this process of importing these as individual records. I can achieve importing the labels as fields - but not data. I may have to do this and then split them into records? Oh, I hope I can automatic this a bit more. Worksheets look like: I want…

I need to make a copy of a table's structure within the same file. I am making archive tables to cut down on the number of records normally seen by a user in day to day use. I don't want to have to totally redefine the tables if I don't have to. I am assuming that I will have to make an odbc connection to the file and use SQL to copy the table somehow, but since there isn't a supported Copy function in the documentation, that makes it hard. Has anyone solved this type of problem that could give me a point in the right direction and save me some all too precious hours?

I'm recently coming to FM6 from MS Access and am stumped about how to extract information from the database via a cross tab query or its equivalent. Thanks in advance. Owen

At the moment, we are sending out emails with text only however we are wishing to shift to html formatted emails. All the content is stored in the FileMaker Pro DB (Mac FMP 6) and I'm not too sure what we need to create HTML formatted emails. The email client that we use is Entourage of OS X. At this point things work fine if we are sending text only emails. Any ideas of what we need or tool and where I might find some how to into this would be appreciated. Thanks Dave

I have a major problem and need some help quickly. The situation is we have gathered a lot of onformation for a community website and have all this info stored in a Filemaker 7 Database. The website that is being developed for us is running on the Mambo open source solution which calls on a MySQL database. I need to be able to eprot all out Filemaker database to SQL but sadly this feature is not included in FM7. When I use the other export options the resluting data gets messed up with weird characters. Does anyone know of a way to export Filemaker to SQL or convert from Filemaker to SQL? Any help will be very much appreciated.

Post deleted by PaulCruice

Can anyone offer suggestions as to how I might be able to get the text with its formatting out of FMP7v2? At the moment, all style is lost if it is copied and pasted into the likes of Word. Would appreciate any help. Thanks. Paul

Does anyone know how to convert a FM database to an EndNote library? The people I work for want to convert their old FM dbs to EndNote. I tried exporting the data as a tab-deliminated text file to EndNote, but the EndNote wants the fields (references) defined before it will import the file. After that didn't work, I imported the tab-deliminated file into Excel & then set up the fields in there, & then exported the whole thing as another tab-delim file. Then I tried to import that into EndNote, seems it wasn't a compatible format. Anyone have any other suggestions?

We just switch our Student Information System from SASIxp and MacSchool to Infinite Campus, which uses Microsoft's SQL Server. I know very little about ODBC, but I have purchased Actual Technologies, ODBC driver, and I can do ODBC imports with no problem. The Campus developer has even done some Stored Procedures for me to get information into FileMaker Pro. BUT, after I get the information into FileMaker, I don't see how I can keep it updated, other than continually deleting all records and re-importing. Try to use the Match field to Update takes forever. The Campus developer told me I should be able to "Link" Filemaker to Campus, but I don't see any inform…

We recently purchased filemaker Donations with Pro 6. I'm trying to do a simple import into the contacts tab in Donations and I can't find matching file names or types for my data. Even names that seem like they would match I am unable to select! (they are gray). I've managed to get one data group into the new database but I have at least 10 more from F6 that I can't seem to match to their fields in Donations. Has this happened to anyone else? Am I missing something?

I have a customer who wants to be able to determine before a new recorded is created, if a existing record exist. What I am conceptualizing, is a script that will display a message if the user is creating a new entry and inputs a field entry(in this case, a patient ID number), and when they hit enter, it will check for duplicates and if a match is found, it will display the message "duplicate record already exists, otherwise it will continue on with creating the new record. What I have though about so far is this. I am not sure what commands to apply to the code so if any of you FM scripting experts could list what entry or method to better perform this type of…

Hi, I have used customer postcodes and field that required a 'Unique' postcode field value during data entry to avoid creating duplicate customer records on my database. This worked well with FileMaker versions 3 and 4.1 but with FileMaker 7 the onscreen warning of a duplicate does not trigger until I have finished keying-in all the address and customer data. Earlier versions of FileMaker picked up the duplicate as soon as I tabbed out of the postcode field. I'd appreciate advice if anyone knows how to get round this?

I have a list view which includes simple calcs that I can first sort by manufacturer (with up to 25 products, for example) and then limit that sort by further criterion -- I want to take the data from that last found set of records and create a new and permanant record in a new layout (in a new file, if necessary).

What I am tring to do is to take an order database and export it in csv or tab format and then attach it to an email and send it. This process has to be automated. I have everything working except I need to have each item ordered on its own line. The database is attached to this post. Each record is a persons order. Each record has 40 fields 20 quanty ordered and 20 sku. Some people have ordered one item some 20 items. I have built a merge field to bring quantity and sku together, but I need some way to export each single order as follows: "1 097360809848,, " "1 043396016125,, " "1 012236115816,, " "1 794043465727,, " "1 717951002105,, " "1 03…

I have a database that has one field that has many different numbers, all separated by commas, such as: 6565, 6723, 6892 What I am trying to do is export these fields from a found set, and create a new list of these numbers individually as separate records. Example: 6565 6723 6892 I can export the contents of the field with no problem, but getting them to import as separate records has been impossible! I

I have a soccer league file containing all the players and teams in a town league. There is a relationship built between the team file and the player file. When the file was developed in fmp 5.5, I could set up an export within the team file and export the team name and the (child) players into an html format. The result was a line with the parent (team) name and the first child (player) name. Following lines contained the remaining (child) player names. I have not converted to FMP 7. Running this same export provides only a single record per team listing the (parent) team name and the first (child) player name. Has anyone experienced this? Is there a sett…

I exported all of my records into a backup file. When I import the records back into the original file, two fields do not import correctly. The fields in question are 1) "Registration date" (date field) and 2) "Total Days" (calculation field)='s Status(CurrentDate)-registration date with storage options selected as unstored calculation. My problem comes when the records are imported, the "Total Days" (calculation field is blank. I am currently using FileMaker Pro 4. I would greatly appreciate any help that you could give me. Steve

Does anyone know how to import data from a RM Management Integris Database to FIleMaker. If I am to export files from Integris first, it only gives me the option to export as .XML or ,CSV. Is this a easy procedure?

I have an XLL that I use in excel but I would like to enter all the data to go in to the excel model in filemaker - that way all the data is neat etc What I want to do then is to export the data from filemaker in to an excel sheet which contains all the data. Is this feasible? Does anyone have any knowlesge/experience of this? I have tried exporting to Tab/CSV and then importing but this is a bit clunky Thanks

Hello, I am working with the import/export feature in a script. I can easily setup the script to send to what most people would think as a common place to save any backup, excel, or HTML and that is drive 'C'. What I am finding is that there are a few people out there that don't have their main hard drive as drive 'C'. Questions: 1. How can you setup an import or export to save in a persons 'my documents' folder? I know I could select the folder, but everyones 'my documents' folder has their name associated with it. Is there a way in FM to get around this. As far as I can tell you can send to a specific folder or the parent FM folder. I would like to send the info …

I'm having trouble getting data into QuickBooks. So far I haven't even used FileMaker yet, I'm just creating a IIF file by hand, but I'm hoping someone here can help out since Intuit has no interest in supporting IIF anymore, the documntation is sparse, and I can't find a QuickBooks community as helpfull as fmforums is. My initial problem is that QuickBooks says a customer is required for an Invoice. The problem is that there is no field for customer, there's only NAME which is the customer name. To make this post slightly on topic, I will eventually create a FMXML->IIF stylesheet and post it here if anyon'es interested.

I've been a longtime developer, but have never utilized XML until now (or rather, I need to use XML now). Here's my dilemma:: I have a contacts table that I want to export to the web via XML. I then want to later import those records back into my contacts table from web using a script. What's the best way to go about this? I've been able to export the records to an XML data source on my local drive. Do I need to utilize a style sheet at this point or should I simply post it to the web? I have a personal website and yahoo site builder tool that my webhosting service provided. Do I need to save the XML source in the same folder as my web pages?…

I am attempting to write a script to export pictures in FM7 and have not had luck. Would anyone be willing to write the script steps that would export x number of pictures (found set) to a file and include the data from the additional fields? The help section on Export field contents script is very limited. Thanks, Dave O'Connell [email protected]

Is there any way to do these in FMP 6? I know 7 has some built in features for graphs. Is there any way to do 'em in 6...maybe a plugin?

I'm writing a script to import records. Some of the target fields are lookups or calculations. I have set up the Import Order and saved it with the script, along with the "Perform auto-enter options while importing" option checked. This option setting doesn't appear to be remembered! Currently I have to allow FM to show the Import dialog, and select the auto-enter option manually each time. Is this working as advertised? Is there a way to do this automatically? Thanks for your consideration, Chap

I have two problems with the project I am currently working on. First, I have some databases that will not import, I do a import procedure to import the records from a backup copy of the database stored in a different location. The databases have not changed in structure at all, but it will read the database but will not import them, I have one that will and one that will not. Secondly, there are some databases that are used as notes fields on the main layout, it is not a portal, and I cannot figure out how the programmer was able to do that. When you go to that database and view the layout it is just has a gray screen, with not data visible, but it is visible on the …

I am still finding my feet with FM7 - and probably will be for a while. I have a database with an account that has 'Full Access'. When I open the file locally, I am able to import data from a text file. When I host the file using FM Server, and log in using the account that has 'Full Access', the 'import records' menu option is greyed out. Why is that?? Cheers Halbj

Need some FM to Access wisdom!!! A client wants to convert all of his FM5 files to Access 2002. (Not my choice, but the bills need paid). The FM5 files are very basic, none of them have any relationships defined or heavy calculations, etc. Basic flat file syndrome. However... I am having a hard time trying to figure out how to resolve a couple of "key" field issues in from FM to Access. [color:"red"] (I've already inquired the same question in some Access forums and no one knows anything about FM) Anyway - the problems are: (1) Several text fields are defined as "repeating" and contain up to 8 in many of the 20,000 + records. Access does not have a rep…

I'd like to export selected data to Excel for further processing (to do things that FM7 cannot do). In FM7, I've created a report that selects certain data (from multiple tables), does some calculations and summarization and presents it in columnar format. So far, so good. Now I'd like to get this data into Excel so I can apply other formulas to it. Problem is, when I try to export the data, FM7 asks me to select fields from one of the tables! I want it to take only what's on the report (above). If you're familiar with MS Access, when you produce a report, you can export it directly to Excel, "as is". This is what I'm trying to achieve in FM7. How can I do that?_____…

I am trying to export data from FM7 to excel but it does not seem to export the column headings. Any tips would be gratefully received.

Hi, 2 utilities that may help you Mac folks... ADRESS BOOK EXPORTER : freeware - Export Adress Book to Tab text --- http://www.gwenhiver.net for Jaquar to Panther. There's an old version for OSX.10.1 too. VCard Creator for FileMaker 5.5 to 7 10$ minimum donation - Attached above FilemakervCardCreatorv.zip

very newbie here. i have an existing sales program someone wrote using "filemaker runtime". it operates on its own, meaning filemaker pro is not needed on the machine. i needed to make the program usable by multiple users on a lan, so i installed fmp on all machines and extracted the data files from the original program. it all works fine, but the data files have the extension ".leg" (??). i have to select "all files" when trying to open them with fmp. can i convert these few data files to a proper fmp extension? if so, how? just changing the extension did not work. thanks a million!

I have a Customer List that is stored on my accounting software program. The Customer List is then exported to a .PRN file (basically a text file). Then I import the data into Filemaker. I use Field Mappings to make sure that the fields all match up. Each of the Customers in this list have a UNIQUE Customer Code. So I set up the Database with a field "Customer Code" and then map the 2 fields together. It is supposed to import the data according to the customer code then update the record. If it does not find the Customer code, then it adds it to the list. I also put a script to automatically do this importing. Accounting will be doing this so I needed to make …

Hey all, I'm trying to import data from Excel via ODBC on Win XP. As soon as I select Excel as the ODBC source, FM asks me for the user name and password. (This also happens if I choose Access or any other of my ODBC sources.) I've never set up a password for any of my ODBC sources, and I don't see a place to do so in the ODBC manager. I'm transfering data via these driver in other applications, and passwords are never required. What's going on? Thanks for any help, Dan

Ive been using an import feature, however it mal functioned and has been importaint records without checking if the record exists. therefore I have about 1000 records that are duplicate of duplicates. Is there a "find" that will find all the duplicates and then I can delete them? thanks.

I'm going to be in a situation where the shop's main database is in FM6 and probably will be for the next year. We are about to put up a web page with some database features, and we'd like to drive the web database with FM7 Server or Server Advanced (once it is released) with the thought that the whole shop will be running on FM7 in 12 to 18 months. There is some data that needs to come out of the FM6 system and into the FM7 system for web publication. I'm just messing around in the expirimental stage now using FM 6 Dev and FM 7 Dev. I'm trying to get data into an FM7 table from an FM6 file via an ODBC link. However, the ODBC driver is ungodly, terribly, awfully …

I have a FileMaker Pro 7 solution. One of the scripts I wrote imports records from one table to another in the same file. When I run the script on the "Host" computer everything works GREAT! When I try to run the script on a "Guest" computer the import doesn't happen. On the guest machine, I then look at the script that has the import step in it and I click on the Specify Data Source pop-up and select File. The reference to the correct file is there. When I close this dialog box, I get an error that the file can't be found. So, I click on Add File, then Remote... and select the file from the list then try to close the dialog box again and get the same error.…

Howdy from Texas! I have a new project where I must automate the retrieval and import of XML files (Purchase Orders and XML translated EDI data) "dropped" in a specific directory on a dedicated Filemaker workstation. The target solution is already a mature multi-user system, where users are able to manually import XML generated by the customer's database over the web. The data will be sent to me via AS1 or AS2 protocol. A fact that I mention, only to paint a clearer picture of how the files end up on the Filemaker workstation. If you don't know anything about AS1/AS2, then suffice it to say that files sent to my system will magically appear in c:incoming…

We want to export our FileMaker database into a pipe-separated text file to serve a purpose for an online database extraction system we propose to use on our website. Are there any export options that allow us to control how the database fields are saved in order to easily create a web-compatible format? The closest export option that seems to be available in the FileMaker application is *.csv files, but we require the pipe separator rather than the comma, and no quotes around the field items.

Hello everyone, I'm working with a 3rd party software that is sending query over ODBC in what I think is some sort of ANSI mode example: SELECT "Age","Last Name","First Name","DOB","Sex","MI","Height","Weight","ID1","ID2" FROM Demographics I was wondering if there is anyway for FMP to accept this type of query? I know in MySQL you can switch it to a ansi mode. Thank you

From the command prompt, I'd like to be able to import a text file into an exisitng record. i.e., to automatically update a record, from command line (preferrably without even opening filemaker). Any ideas? So far all I can do is open a database from command line. Ideally, I'd like to be able to run a Filemaker script externally. Any help is greatly appreiciated to this newcomer!

Hello everybody, I have a big problem. I want to be able to export all of the rijs of the portal!!! Now i can export only the first rij! HELP ME PLEASE..What can i do? Thanks,

Hi, Our company uses SQL-Server to store product related data. For creating offline-versions of the product-database we want to use FileMaker, so we have to export the data from SQL-Server onto our FM6-Server, where some further data editing is done by the team. FileMaker imports via ODBC or XML both work well, but now my problem: The original texts are formatted in HTML, and I want to keep the formatting when it is imported into FM. (Only reduced HTML-Set like bold, italic, subscript, superscript, underlined). After importing into FM6 I have plain text with HTML-Tags between... I tried to import the data into FM7, then run there scripts …

I tried to search for this prior to the post, but I was unsuccessful, so a quick question: I have an Excel table with a column labeled name. Unfortunately, the format of this column is "Last, First". Is there a way I can import this column into two fields, "Last Name" and "First Name". Basically, I need a way to split a column with a comma into two columns to import. Any thoughts? Shane

I have some layouts that I currenly will print to PDF and then email to users manually. I can autoscript a basic send email function but how can I send all users a report based on the layout? It would need to show totals or summaries of various fields. I can't script a print to PDF function, and I can script an export to DBF and then send, but am concerned about getting the format acceptable at user end. I'm really looking to do one of the following: Send an excel attachment with field totals Send a PDF attachment of layout Send a an email with calcuated body field containing portal rows Any suggestions, starting points?

Hi everybody, I have a column in excel. Taht is in paper table. I want to import it to filemaker and to the same paper that they belongs to. What can i do? Anybody a suggestion? Thanks,

I'm importing data from another db which occasionally has quotation marks in some fields. These cause problems when I export out of FileMaker using AppleScript. I've tried Find & Replace, PatternCount and AppleScript to remove the quotation marks with very inconsistent results. Is there a reliable way of removing quotation marks from fields? Thanks, Peter.

What I am trying to do is import data from a csv file into FMP6 file using a unique sku number. The problem is that the import csv file has multiple items with the same sku, also the FMP6 file has multiple items with the same sku. Here is an example of the problem the csv file has 6 items with sku 2056 but in the fmp6 file there are 12 items with sku 2056. I need for the csv file to match sku on only 6 of the items and then map over the data only to 6 of the items in the FMP6 file not all 12. It does not matter which six items of the 12 it maps over. I just cant wrap my mind around the answer. Please help? Thanks for reading

I have decided that data previously appearing in a layout as a portal now needs to be in the master file. This means exporting a record to a series of fields in the master file. I'm sure this has been done often, so I won't bore experienced importers with the peculiarities of this database. However, it is significant to note that some master-file records will be filling up 40 fields from the related (ex-portal) database, whereas other master-file records will be importing as few as 3. So a simple loop will not do the trick. Steve

Until recently we have used Filemaker clients to peer-to-peer share a database over our network. The client doing the sharing also used oAzium events to regularly run an export script. So, we have a regularly updated text file export on the 'server'. cron is used to call various perl scripts that move this data on. Due to a change in requirements, we now really need to use Server 7 to share the databases. So, how do we go about setting up automated export from this server now? Server 7 itself has no facility to regularly export data from the files it shares. Can we do this? 1/ Launch a client automatically via applescript, connect to the remote DB (can App…

I have database that has a many to many relationship and a non related table. I export each table to a seperate file. When I try to import each file I can match the names on the main table, but I can't on the related and non-related tables. Why? The only thing I can select is add as new for the other table fields. This is a big problem, especially with duplication. I would love to only have to export to one file, but FM can't seperate the other tables. It wants to import only to one table. Thanks for your help. If this has been discussed already please let me know.

I am using FM 7, and trying to import records from another database system. There are about 50 fields / record I need to import. When I try importing all these fields, I import 481 records. I figured there might be some limitation on how much you can import, so I just imported two fields, and got about 2,500 records imported. Since there are almost 5,000 records in the other system, I tried just importing 1 field, which contains just 2 characters/record. I still only got about 2,500 records imported in. Does filemaker have a limit on importing (either # of records or size of all data imported?) and if so does anyone have experience with this/any useful tips…

Here's a problem I can't figure out: Certain layouts won't print, not to the printer, preview or PDF. I get this message: Sorry, Filemaker unable to continue printing, error - 9705." This is one eMac out of three working with a database on the server. The other machines are fine. I reinstalled FM6 and then reinstalled system software. Still no resolution. Other programs print OK, and some FM documents are OK too. Any help would be appreciated.

I don

Hi, Was wanting to know if anyone knows of any softwares,plug-ins, etc that could allow a FileMaker Pro 7 Database to export data into HL-7 format to be sent to a concurrent HL-7 capable database system? Anyone have expierence with this type of criteria? Thanks for your help! Chris

So I'm using ODBC to import a table of accounts from SQL Server. I want my FM table to be a mirror of the SQL Sever system. The obvious choice is to use the acct_id primary key field as the match for updating records. Also, there is a preference for creating new records when non-matching (new) records are created in the SQL system. The problem comes up when records are deleted from the SQL server table. This doesn't cause records in my local table to be deleted. Importing doesn't seem to trigger record modification timestamps to change either. So how can I easily delete only records that are deleted from the remote table? Any input on this is greatly app…

Hello, I have a database that has a relationship to sales data. Basically you have a product layout with a portal to all the sales to that product such as sale_date, Sale_QTY, and Sale_Amount. There could be more than one sale for each item. When I do an export it will only list the most recent sales data from the portal. How do you export to excel the item an then fill in the cells for all the sold data from the portal. Thanks for your help.

I want to update a database by importing data from a tab delimited file on a daily bases. The database is hosted by FMP server 5 on a Win 2000 server. Is there a way to automate the process. I've looked through the scripts, but how do you automatically trigger the scripts?

Trying to wrangle some flexibility out of the the IMPORT FOLDER option of FMPv7 with image imports. It has some nice features (creating a thumbnail, and just a reference to the file), but has some inflexibilities also (why can't I import 1 image with thumbnail generated -without having to alter my folder structure?). Anyhow, loading in 1000 or so images in various formats (TIFF, JPG, PSD) using IMPORT FOLDER option, and am finding that every now and then that the import will terminate with a Filemaker error message Sorry, there is not enough memory to complete this operation. Doesn't say what file, but I can work it out through elimination. Here are the facts: …

i have a client that needs to export files on both mac and pc. how do i set up my export script steps to export to the Desktop on both platforms? thanks! chris

Not sure if this is the right place for this? Basically at the moment I have a number of templates documents setup. Where by if something is sent to someone in the database a button is click and the result is pasted in to a word file. What I basically want to do is to be able to create word documents from filemaker and insert text from fields? is this possible? would mail merging need to be used? XML etc?? and can the same be done with excel? Thanks

i am having the same problem in import on the Server. I have developed a new big procedure completly tested on a local machine and now i cannot distribute for this problem. FileMaker cannot recognize itself and cannot perform the operation. Is possible to advice FileMaker Inc. of this ?

I am not a filemaker user or developer, however we have a client who wishes to receive data in Filemaker format so I have to find out which product I need to purchase. All I need to do is take a csv file and convert it. Nothing else really. I am doing this in C#. The main question is - do i need to purchase Developer 7, or can i get by with the runtime available with FP7? I downloaded the trial version of FP7 to try and work with the runtime, fumbled my way thru attempting some scripts, but to no success. Someone's advice on the right product will enable me to get a purchase order written out. The next question, time permitting, is - what would be the best m…

Am I missing something? Can I still export the field names when exporting to a SYLK file?

i posted this on friday at an excel user forum, but no takers. hope some use excel here. using office 2000 w/ excel. mac OS9 and filemaker 4.0 i'm a newbie. i have been trying to import from excel. my database is filemaker 4. i have 3000+ records. i only need to import a select set into excel. a couple of times i isolated in filemaker, say, 400 records. (one time 19 records). when i go to "import from filemaker database" excel defaults to import all 3000+ records. is there a way to import just the selected set from filemaker? (example being the 19 records in this case.) Please help. my head hurts from banging my head against the de…

Hello everyone, I

Importing seems to be a simple matter yet, the 700+ imported records just keep disappearing. The target file indicates that it received the records, however, when the file is reopened after being closed the counter reads 0. Also, the source file is 29megs and after the records have disappeared, the target file is 450Kb. If this is a corrupt file, is there a way to confirm? TIA

I simply want to get a list of e-mail addresses exported so I can repeatedly send e-mail to members of that list. Ii am currently trying to export to a tab-deliminted file and then opening this in Excel. The addresses are contained in different fields. So, when I export the data I need, I end up with multiple columns in the spreadsheet. This makes it difficult to check for duplicates. I am open to a varienty of approaches. I have been working on figuring this out for days, and I am sure there is a simple solution. Thanks! Karla

Hello, I am new to the forum, and pretty new to FileMaker. I need to send text and numerical data in XML to this guy that uses Visual Basic, and requests that I export the data out of my FileMaker databases in an XML format such that it has a CRLF (carriage return/line feed). Form what I have been reading, I might need the appropriate XSL sheet, since the XML format generated by FileMaker without the use of an XSL sheet I guess does not create a CRLF I guess. Designing an XSL sheet is well beyond my current knowledge. Is there an existing XSL sheet that I could have access to that would fit my needs? I did some searching on the web but did not find an xsl sheet that refer…

Are there any way to change the "source folder" from a multi-file importing? Through Troi File, I'm moving in FM a set of files (always the same 18 files) from a cd to the main system. All this process has to be automatic

Hello, I'v made a script for importing records from Excel. Is it possible to use it in Webcompanion? If it is, how do I do this? Ed Boon

Hello! Here is my thing to solve. I do export records from a txt file, where fields are divided by commas. The database is build for a production factory. They divide the product in "Order, pack, and cott.". Cott is the smallest unit of product which navigates through the lines of production. I do get the number of Order and cott. from the txt file, but the number of pack is inserted manually. I want this to get done automatically. The concept is that the Order can be composed by one or more packs. The Pack in it's self is distinguished by the article used for the product. Packs are serial numbers (1, 2, 3, ...) inside the same Order. And it restarts 1,2,3,..., when Ord…

Hi all, I have created a detailed database for calculating bids for my video company... I would like to create a questionnaire that I fill out, placing a check mark next to each item that applies to the bid, then I want ONLY those items that I checked to appear when printing the bid for the client.... Any thoughts about how to do this? Thanks in advance. Matt

Hi everybody, As follows: I have a table which has a bad database design. I want to have the layout and informations of that table in two seperated tables. So i want to export the existing one to two another table and there i want to import all the existing information and some fields.So anyone a suggeston how should i do that? Thankx, Sima

Is that possible to export a layout completely (with all field definitions to another table? Thankx, Sima,

We are converting from Act to FM7. They have 85 .adt templates of which 40 are used regularly. Upon review, they open in Word but contain merge fields which look like: DatabaseID=[[DatabaseID]] etc. I've used merge fields in Word before with other db programs. I assume I can just respecify the table that Word uses in the merge section. Does this sound correct? But I would prefer converting them in one batch. Does anyone know if this is possible? I suppose I could convert each one into FM; in fact, I think I will plan for that anyway. But, in the meantime, is there a quick way to relink these adt files to save me opening every single one? LaRet…

Ok, I'm doing a conversion of a pretty large and complex database I built in V6. Uses a number of files. Well, thanks to the Multiple Tables per file feature in v7, I can cut the number of files used in my solution significantly. So my question is.. Can I import the fields and layouts of one file, into another file as a new table?

Hi! I want to export a table as text with fixed positions. Field_1 from position 1 to 32 and with blank space filled with zeros. Field_2 from position 33 to 39 and with blank space filled with underscore...and so on. Record line ends with carriage return. All in all there are 32 fields and 8000 records. The data in every field can vary in length. My first thought was to create a calculation field collecting all 32 fields with a lot of text functions, but I hope there is a better way. Thank's in advance!

I am amking a database for a user to replace an older non filemaker database. One table has about 60 fields, and when i import data from the old DB, it comes in with extra spaces at the end of each field (for example: the first name field in the old db contains 15 characters, so John would import as JohnXXXXXXXXXXXXX - where X are spaces). This is not good, especially in cases where letters and other layouts are created using merge fields. I know I can set up a second field and use the trim function to remove the spaces, but with 60 + fields, I was wondering if there was some way you can trim while importing so i dont end up having to create a secoind, trimmed fiel…

I'm trying to figure out how to import specific records into one table only if a matching ID exists in another related table? (e.g, firstname/lastname links both tables, but the tables contain different into). The table is initially blank. The other table is loaded already. The data I have is a superset of the data I want to import, but I want to import only data that has matching first/lastnames in the table that is loaded. The only other thing I could think of was to populate the keys into the new table from the old table, but I can't figure out how to get script to do this -P If the keys are loaded into the new table, I can do an import and check off the se…

Hi there. This is quite a specific problem so I hope I can explain it clearly and you guys can help me out! Ok, I have 3 FM files (CLIENTS, INTERESTS and RELATED) i.e. a many-to-many relationship. I have a portal in CLIENTS which allows the user to select various interests for a particular client from a drop down menu. This works fine when adding and removing interests of current CLIENTS records. My problem is when I am importing records. I can import the client details fine (from a .csv file) but I want the user to be able to set the same interest for each record they import (either using a dialog or the drop down list). It should then be added to the next f…

I'm using FM 6 to pull together images and text and other info for a catalog. I can't get the images to import into my container field as CMYK, I get a JPEG Error 25. But when I convert them to RGB and import, they pop right in. I'd like to keep them as CMYK as opposed to having to save two copies of each file...I think it's a filter issue, but I am not exactly a brain surgeon here. Can anyone help?

Hi everybody, I have a question for exporting records to Excel. I want to Export the name of the field also to Excel sothat can see what is the meaning of this coloumn. ex. Name age Jack 12 Anna 52 ..... Have anybody an idea how can i do that? Thankx, Sima

Is there a way to use Microsoft Word's mail merge function with the server version of Filemaker (5.5)? (I'm on a Mac.) I can't figure out how to choose the served files from Word.

I am looking to import a dat file that has been given to me into filemaker. I have a few fields that have a valuelist. I want to check off mulitiple values in a valuelist. The only way to do that is to have a data field that looks like this: 04 Fall 05 Spring My Data file looks like this: 04 Fall, 05 Spring How do I replace my comma's within that field either before I import without it messing up the import. I would do it after I imported but I cant seem to do a find on a comma in that field because it is not a member of the value list Suggestions? Thanks Janet

I want to attach an image file name along with an image when I import it into a container. I have developed a DB for my microscope images. I need the file name attached to the image because the file name contains all of the information about what the tissue type is, what stain was done etc. I want to be able to import the image and also the image's file name at the same time into the DB layout. Another option would be to import the entire image into one container and concurrently import the file of that image into another container. This would work because when the file itself is imported into a container, the file name is visible. I would want this to be done concurren…