Importing & Exporting

I need to Export data from a FMPro6 database to feed into a page-layout program. Tab-delimited works excellently for me, except for one thing! I have some currency fields (created as calculated numbers), and in the Exported data I need for them to appear with a currency symbol before and exactly 2 decimal places after the point, rounded to two places. FOR EXAMPLE: the value 2 should appear in the exported file as $2.00, and 2.5 as $2.50, and 2.5673 as $2.57. The correct technique in FMPro seems to be to do the Export from a layout in which the field has been appropriately formatted as a Number. Trouble is, the fields concerned cannot be formatted becau…

I need to output a report as a file that is readable by other Windows programs, e.g., Word. Choosing file on the Print menu doesn't cut it for some reason. I don't know how to format output that I export. Any ideas?

This isn't the regular Import/Export, but it involves getting data out of FM. Is there a way to copy the data from multiple fields on a single record to the clipboard *using returns* to separate the fields rather than tabs (as with "Copy record" script step)? I don't want to add another field, but want to be able to provide the ability to grab the data from a single record (all name and address fields) to paste into another application. This isn't a frequent need, but it would be helpful on a ad hoc basis. Better yet would be the ability to script a copy that would actually construct the clipboard with the right line breaks (firstName lastName // address // city…

Hi Everybody, here is my problem... I have a database with few fields and during the input I may change some font attributes mainly bold and font color. Then I need to export the whole thing to Excel but I would like to retain the changes on color and style. Is this possible in Filemaker 7?. I will appreciate any help I can get and thanks in advance to the wonderful people in this site. Claudio

I would like to have a template (FMP7) file where the user can select a record from this file to create a carbon copy as a new record in another (FMP7 working) file. Hopefully, all this would be accomplished by going to the template file and selecting the template record and returning control to the working file with the record populated with the template data ready to be saved. How would I go about this? Can or must the template file be a separate file? No relationship exists between the working file and the template file. TIA, Jim

Hello Everyone, I have a FM 6 Pro DB in which I would like to have two exports scripts tied to two buttons. I made the first button and export script fairly easily, however when I went to do the second export which uses different fields it exported the same fields as the first script. Can I set it so that I can have both export sets be able to run without dialogue or having to re-order/select the fields between exports? Thanks for all the great ideas I've found here, this the first time I was able to come up with a question that was not already answered. Luke

Hello everybody, I have a problem I want to export data from a FMP 6.0 file to a *.csv I lose special characters as i.e. the

I currently have a large FP database of book titles and a large number of picture files (of book covers) located outside my FP database that I want to be able to "connect" with the aim of passing the data (e.g. Record Number & File Path info) to a third-party website. My knowledge of dealing with container fields is limited and I want to set up some kind of relationship against the record so that I can create and store a Path Name together with an option which would open the picture. Because the files are large I want to do this as efficiently as possible. Any advice would be very much appreciated

We are in the midst of changing from 5.0 to 7. I want take advantage of the tables, is there a way to import a whole file (ie. Fields Defs, Data) Even Layouts if possible Or even a second hand program that would make this possible.

I have a Text file that I need to parse into fields. I would like to do it all in FMP7 and not go into Excel. (Mainly for bragging rights, but also for ease of use). The file I get is output from a web form, of people that visit our web site. The file has many people in one file. each data element in on a seperate line (with an identifier), there are also many extranious lines, but the whole thing is fairly structured. What I would like to do is import the file into a table with a single field. Making each line of the text document a new record in the table. Then walk down the fields and process each field (record) as nessisary. Sort of like this; C…

Hy every body, I'm looking for a database who compare 2 tables: I wanna made a database who import 2 tables A and B and compare them. thanks

Just to let you know. When importing records from a related hosted file in to another hosted file and you choose to split the records from your repeating fields, not all the data will be repeated and your import will go wrong.... This only happens in FMpro 7.0v3 A temporary workaround is to use a client running 7.0v2 however many other things don't work in v2....... The fault has been lodged with filemaker australia support. =)

I have a table with 20+ layouts, each of which can be used as a single report for the user. What I want to do is provide a dynamic selection [using the checkbox options] to identify which layouts are to be included in a single document. I then want to be able to consolidate the selected layouts into a single document that can then be printed with the appropriate page numbers and even be created in PDF format. I thought that perhaps the DDE scripting option would let me transfer this information into Microsoft Word. I don't really know anything about the DDE command and am not sure if this will even work. Any suggestions are most welcome Thnx Arny

I am really new to this so I hope someone can get me on the way. Several clients ask me to provide a XML using their naming convention. For instance I have a field: "clients", which name in the export to the XML should be substituted by "customers". My guess is that the easiest way would be by using a stylesheet to change the names automatically rather than using a XML editor each time an export is made. However I don

hey, im a comp. sci. grad student working on a project specification and ive hit a bit of a wall. the project im working on requires entering around 50 fields into a web form, running scripts on the inputted data to ensure integrity, then automatically entering the information into an existing FM database (all 50 fields should be 1 record). I have to use C++ in there somewhere (course requirement), and all data entry has to be automated (people maintaining the db have limited computer skills). Any ideas what the best way to do this is? I was considering generating XML or maybe an Excel file, but i cant seem to find a way to automate the import...any help is GREATLY ap…

Is there a way to import one file and have it write records to multiple files. I have an old flat file I'm converting that contains item information along with master information on the same record I.e. all of the costs and charges are the on the record along with customer info, shipping data etc...). I'm going to create relational data from this one import file. What I want to do os import the file and have it automatically create child records on the related files. For insatnce, I want to import the data and create the Master record and then have the import populate the cost file and the charges file at the same time. How would I set the value of the of the relate…

I figured out how to script a button to highlight a container field and import a PDF into it. But how do I export a PDF currently inside the container field?

I have a runtime file for my users. Is there a way to restrict the user to select exporting file types of csv or txt only?

hi i am making a database of magazine advertising. each advertiser has one to three 'index' names that appear on a page in the back with their page number. for instance, one client might be known by three names so will be indexed three times, each time referring to the same page number. i have a main file and a related file, basically the issue records and the contacts database. the contacts database tracks vitals on our clients -- including the ad index names. when i'm in the main file i start a new series of records for a particular issue. when i make a new record for a client all of the info from the contacts database pops into the record when i choo…

i am new to the forum, so let me know if this post should be in another area of the forum. wondering if filemaker data is compatible with outlook and palm software? also if anyone could direct me to a source of information on how these softwares might interact and exchange data? thanks in advance, mojobeaux

Hi, Is there a way to export data from Filemaker fields to xls document cells? Ideally this should work a bit like a lookup in Filemaker: - there is a "match field" both in Excel and Filemaker file - based on the "match cell" value in xls document, some xls cells should be filled with data from fields in a matching record in a Filemaker file If this can't be done, anything more advanced than manual copy/paste would be an improvement... Thanks in advance, JariV

Hi, I want to store the names of external files (not the files itself) that contain pictures in FileMaker field. I want to let the user browse for the file and select it. Is there a way from inside FileMaker's script to show "Open File dialog", then obtain the result of that dialog (the selected file name) and then store it in the filemaker field? I'm using FileMaker 6. This is not difficult when using MS Access, but I cannot figure it out in Filemaker? Thank you for the help!

I'm not very experienced with FM, so bear with me on this. I'd like to set up a button so that it automatically exports a picture from within a container field - but I want the filename is saves as to be defined by a field in the record. Is this even possible? I can't find any way to create variables of any kind when setting up a file path.

Hi all, I just finished reviewing many posts on that subject and I still need input from more experienced users than I am. I have a large database ( 200 mb, 6000 fields, 600 layouts, hundreed of scripts, 17 years in the making) that I do not want to rewrite. I know there is corruption in there somewhere but I have decided I could live with it ( back in the 1989 - 1993 period I was working with a Mac that had a ROM problem that took years to identify and caused many crashes). I am wondering if I could, without using the recover function which I understand after reading all these posts on recovery is a last resort solution, improve the integrity of my data. …

How on earth do I "make" an address book I have created stand alone (allow users WITHOUT filemaker to run it..) for example an .exe file... Please help me... Email me with answer...

I'm trying to meet an upload spec that says: 'The basic structure is a group of comma delimited ascii text variables, that will be HTML "Posted"'. Say there are 4 such lines of data, each line being a single field of the comma-delimited ascii text variables, to be 'uploaded' via http://(url stuff)/get_data_xml.asp. I tried to do an 'Export, XML, grammar=XMLFMPRESULT, HTTP Request=the above, field order=the single field, Export' and get the error: 'XSLT Warning: Fatal Error at (file http://(url stuff)/get_data_xms.asp, line 1, column55): Expected whitespace (http://(url stuff)...' Can anyone offer me some insight as to what's needed? TI…

Does anyone know if there's a way to communcate with a Garmin GPS 18 USB device using Filemaker? I would like to request the device send simple text output of current position to a field and use calculation fields to extract the needed data. Would DDE be able to do this? Any help on communicating to a USB device via Filemaker would be a big help. Thanks.

can anyone explain me (step-by-step, in full detail) how can i export repeating field data? the FM7 help says: To export all repeating field values: 1 Find the records you want to export. 2 Make a clone of the file you want to export. 3 Open the clone, then import the data from the original file. 4 In the Import Options dialog box, select Splitting them into separate records, then click OK. 5 Export from this clone file to SYLK, WKS, and DBF formats. but i have absolutely no idea where to start! im just a beginner here, so any help is really appreciated. thanks guys!

I have a database that has one date field that is a repeating field. It is storing program info for those dates. I import this information into another database and use the option to split repeating fields into separate records. FMP 7 does not appear to be doing this correctly. According to the help file "When you split repeating field data into separate records any non-repeating fields that you import are duplicated in each separate record. For example, if a record in the source file has values in three repetitions, splitting them into separate records imports three records, each identical except for the values in the repeating fields." What it is doing f…

I have a simple database which I use to import a job log from our print server, and then assign charges for prints based on this import. In order to do this, I've set up some auto-enter fields in the table that the job log goes into that do some calculations to generate prices and determine if the job is a "free rider" that shouldn't be billed. I also have some auto-enters that create a proper date field (it has a lengthy date & time stamp field in the log, which is useless for sorting) and another that adds an ImportID index so that we can run reports on just the latest import, or on a historical import. The problem is that of all of these auto-enters, the …

I am trying to import a document from Excel that has lots of data in it. It should all pertain to one record in Filemaker. Instead, it is making itself into hundreds of records in Filemaker. I need all the information from each excel spreadsheet to load into one record in Filemaker. Please help if you have any ideas or solutions. Thanks!

I found a way to import vcards into Filemaker that I wanted to share with everyone on the forum. Assuming the user has Microsoft Office, you can easily drag and drop vcards from Apple's Address Book into the Contacts section of Microsoft's Entourage. (Note that you can select and drag more than one vCard at once!) Then Entourage can export those contacts as a tab-delimited file, which can readily be imported into Filemaker. I mention this because I've spent the past four hours trolling the web looking for a solution - and in the process it became clear to me that lots of others were also looking for a solution. Best, Chuck Henebry

I am atempting to export records to MS Word XP via the .mer file feature in FM7. The problem is that when I attempt to create the export file, I receive this message: "adenosine.mer" (the name of the export file) cannot be created on this disk. Use a different name, make more room on the disk, unlock it, or use a different disk." I have attempted to find the solution in the help files in FM, with no success. I am hoping that someone out there can point me in the right direction to a solution. TIA Dave

I use the image choice script of "http://www.briandunning.com/filemaker-pro/" credit card validation solution. It works perfect in my solution but when I import data from a older version of my solution the stored credit card logos dont display anymore. I changed the import option so so it dosent import anything related to those fields but they still disapear. Anyone?? Thanks TMAS

I have an invoicing database at a showroom that employees enter orders into. There is a customer and invoices and orders tables. I want to take a copy of the database with me on my laptop but I want to modify the records on the laptop. The copy on the laptop would then become the master copy of the database, but I want to be able to import new customer records and new invoice records into the copy of the database on my laptop. The problem is I also want to import changes to records onto my laptop, but I don't necessarily want to overwrite all of my changes. Can anyone think of a way to accomplish this?

Two issues: 1) I want to retain text formatting (underlining) on individual words and phrases applied in a text field when that field is concatenated with others in a calculated text field. Is there a way to do it in FM6? 2) I want to retain that word-level text formatting when I export the calculated text field. The exported text will be opened in MSWord. I picked up in another thread, "Output report as a file??" that it's possible to insert RTF formatting codes to format each record. I haven't tried it yet, but the example looked pretty straight-forward. But I don't know that the RTF code technique will help with the word-level formatting. In cas…

Hello. I would like to export Field labels, along with the Field contents (data). How do I do this? Thanks in advance, Gwen

I have built a database for storing airlfare contracts... individual fares, the rules, seasons, penalties , and various conditions that apply to them. Individual fares can amount to millions within the database spread amongst several hundered contracts and seasons routings etc. The purpose of the database is to allow human entry of data and produce the correct data strings for use in an internet booking engine. Data output is from a final table of 187 fields, with individual records possibly being in millions. The database is built of various tables which must be combined into one flat database for the export process. My question is about the mos…

Hi all, I have a problem where I dont have even a idea how to get a solution. I have to import certain data out off a rtf file. A medical machine is puting out its report formated as RTF file. Now I need to put the shown data to a filemaker database. the data are text and pictures. is something like that possible? Thanks for your input. Greeting from switzerland. Stephan

Hello Genious PPL, Please review attached PDF file to get an idea to find out what I'm trying to accomplish here. What functions I should use or someone can send me example file. God bless You all!!! [color:"blue"] [color:"blue"] fmexample.pdf

Hi. I'm new to filemaker and to this forum. My question is how can I email a record to someone?

hi, i need to do something seemingly simple but can't get it to work: I need to add text to a value and display it in a new field. The value is "123" and and sits in field A, and I want to add "-wh". So i created a text field B and added a calculation to it: B=A+"-wh". That's not working. Well, how is this done? Thanks, St.

Hi, I'm hoping someone can point me in the right direction. I use entourage to receive client data via a web form that is sent to me from someone else. I receive it in the body of a message, through Entourage. The data looks along the lines of this: It was submitted by Email on: Friday, January, 7, 2005 at 16:23:16 --------------------------------------------------------------------------- Agree: GuestCheckedFirstBox Name: Mr Tom Jones Name2: Ms Sally Sue Name5: Jolly John Age5: 7 It all dumps to a specific folder within Entourage. I'm trying to extract that information, and take the data from all the fie…

I am redesigning one of my old databases. What was 2 fields on the old database I have now set up as 1 field in the new one. Each record in the old database only has information in 1 of the 2 fields. When I import the old data, I want it to bring in information from both the fields into one. Is there a way I can do this?

I have a large database that I need to make. I have it all designed. 3 of the fields will export through a merge field that will add the necessary html code. My only problem is how to add (not manually) a <br> to the end of each line. I know that if I "export as HTML table" it will add the <br> to the end of each line. (oh, each field has between 3 and 10 lines of text) but I need it to NOT be in a table format. Is there any way to do this either in the field or in the merge fields? (or anywhere else) Please help if you can. [email protected]

A solution I'm working on has 6 seperate files/modules. I need to have links between them and it does work perfect when I do that in Filemaker. The question I have is what happens if the server changes IP#s, or if my solution is moved to a new pc entirely and possibly a new directory, do these links become broken and can they be easily re-established? Basically what I'm asking is that can I set it up so that as long as all the files are in the same directory it will be fine?

So this might be a really basic thing, but my brain just won't move past it, and I could not find anyhting in the forums... I am doing a .csv export of a set of records for uploading to a state access db. Everything is fine, but on one of my fields the date is formatted as xx/xx/xxxx, when I upload it it shows as xx/xx/xx or worse xx/x/xxx. I have a calculated set of fields that I run my script through to get the .csv file, and I was curious if there is a way to write a calculation that will take out the first 2 digits of a year (ex: 1/1/04 instead of 1/1/2004) Any help would be appreciated, Thank You Jesse

Hi, I'm trying to export records out of a FileMaker 7 file but the export command is grayed out. I've been given a project to place data from an old FileMaker 4 file into Excel (which I know how to do). I was able to open the old file in FileMaker 7 but no export option is available. Any ideas? Thanks in advance.

I'm using an XML source to create an FM file for the first time and followed with interest the discussion started by Jerry Parlee last week. I was able to use the 'patches' download provided by Fenton (thank you - more useful than any FM documentation I found) to create a style sheet that creates an FM file when doing an open/xml source. BUT - The style sheet creates the correct number of records and the right fields in the FM file, but it does not fill the fields with the data in the xml file. I've tried various ways to get to the data (as you'll see in the .xsl file) but none work. I've run out of ideas. I've enclosed a snippet of the xml file below and attach…

I have imported a few files (data bases) into my layout using FILE/IMPORT RECORDS, and I notice that the size of the original might be 1.5 Mb, while the new file is only 300 Kb. Does this mean that if I delete the original I will lose the data? Is there a way to move the entire record (data base) into the new layout so it is independent of the original?

Any help will be very much appreciated! I need to export FM database from Mac into Microsoft Access. Not bothered about how it looks in access, such as formatting etc, just want to get all the data across. Cheers.

I posted discussions on this topic last June. Six months later, I'm still having problems with it. (I went off onto other projects, but have now come back to this one). In FMP7, I'm maintaining an investments database (stocks, mutual funds etc.) and I have a report that summarizes transactions for each investment, by year. The report works fine and is correct. However, when I export it to an external file (I've tried various formats, for further processing by Excel) some of the figures are not exported correctly. Most are OK, but some are simply dropped or ignored, while other figures are incomplete (e.g. 5000 instead of 25000). This is very disconcerting because it r…

I need to get name address phonee data out fo FMP to inport into Apple's Address book. How can I export the data to vCard or LDIF formats? Thanks, Ken

Hi, I'm trying to import an XML file, snippet attached. It appears I need to create a XSLT file. I haven't messed with XML, so its not clear what I need to do. Here's the error I get on import: XML parsing error: Attribute 'EXPIRED' is not declared for element 'PATCH' Line Number: 2 Column Number: 405463 I assume that the fact that EXPIRED is not "declared" is due needing a style sheet. The table I'm trying to import into has fields for each attribute in the XML file. I've read some about XSLT files and it appears I need to include some formating info; file type etc. What do I need? I expected there might be some info in FM help - virtually n…

I've been diligently searching and searching the forum and cannot find an answer to this. I have a script step that looks something like: Export Records [Restore, No dialog, "Filename.fp5(000.000.0.000)"] where the strong of zeros and dots is an IP address. I have noticed that sometimes the script step will have the IP address, other times it will have an asterisk. I need to check the "specify" option to make sure the filename is applied to the export. The working version of this file is being served. I need the export to park its file on a hard disk. I will pull a copy of the file off the server, make a runtime, and install this on a machine n…

My error says: ""Customer Temp.fp7" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." I was running a script to export the contents of a found set to a file called "Customer Temp.fp7". The file is in the same folder as my main file "Customer.fp7". If I go to File, Define, and then File References I see the name as "Customer Temp" and the file path as "file:Customer Temp.fp7". Do I have to relate the Customer Temp TO to get this to work? I'd prefer not to if possible. Greg

I have two FM databases. I'd like to combine them into one by copying the entire structure (layouts, tables, fields, everything) of database 1 into database 2. is there an easy way to do this?

Hi dear fellow FM-ers, I have a problem with exporting grouped records. After performing a find I want to do an export based on the found set using the group records option. The records should be grouped by the field "code". In order to do so I do a sort records with the field "code". After that I select the group by checkbox (in the export window) and do an export to XML. The records with the same "code" should be grouped nicely in the xml, however it only shows the first record per code (and not the complete set of found records that have the same code). Does anyone know how to solve this? Greetings, Kip!

Just wondering if anyone knows a way to export just the contents of one record within a found set using a script.

I am trying import data from three tables into a filemaker database. The first and second tables are linked using fieldA and the second and third table ares linked using fieldB. With Access 2000, I created the query and pulled data from it without a problem. However, with Filemaker, I am not sure how to perform the same task. I believe I have to use the Inner Joins command in filemaker, but haven't figure out a way to use it. Can anybody help me out? Thanks.

HI Does anyone know of any addin or work arounds for synchronising phone numbers from a filemaker 6 or 7 database to a mobile phone? Any help would be useful - I have used the filmaker mobile which is fine for pocket pc but what about mobiles? Thanks

hi, Is it possiable to import data from Access into a FM Pro 7 database? with the same structure?. MnR

I am getting word docs. from a friend and want to put the info Filemaker in order to help him. How might I solve this? I am a beginner in Filemaker. I have uploaded the filemaker database here: http://www.sushiking.no/filemaker/ The file is: "Spirituell_Film_test.fp3" The report of the file Spirituell_Film_test.fp3, is best viewed in the layout: UK_ Report I did also upload the word doc , which I need to import into the Filemaker doc. That file is "members.doc". Located at the same url. All the info is of course changed so no personal info is being published. There are also a couple of questions embedded in the word doc which some o…

I have finally found the Import via ODBC function - having been exporting from the MySql as text, then importing to FMPro! But: timestamp, which MySQL puts in the record as its creation date time in the format yyyymmddhhmmss, (which comes across to me fine if I use the export as text mentioned above) arrives in Filemaker as '0:00:00' no matter how I try. Am I doing something really stupid here?

I'm generating an HTML page by exporting a single text field. The HTML page contains numbers. I want them to be all formatted the same (thousands separator, 2 decimal points) So I want this 50.00 250.55 4,500.00 and right now I get this 50. 250.55 4500. Help!

Hi, I just switched over to Mac FMP7 from PC FMP5. I am accustomed to being able to see the file creation/modification date and time in the Open File dialog box on the PC. On the Mac (G4 Powerbook with OS X) I only see "Today". If I want to see the actual date and time I have to go to the finder and check the file. Does anyone know if there is a way to see the file date and time while selecting a file to import or open? Is this considered a bug or is it something most peopl don't seem to need? Any help on this would be very much appreciated. Thank you, Scot

Hi, There are times when I want to make a few minor adjustments to a filemaker layout I'm about to print, but it's going to be a one time thing and I don't want to go in and change the layout. I have an instinct to click and drag to select the whole page and copy/paste it into word. Of course, you can't do that... Is there a way to do this? The only thing I can think to do is print it as a pdf and then use text recognition software to generate an rtf file from the pdf, but that is tedious at best. Seems like this would be a useful functionality, what do you say? Andrew

Hello, I have a set of accounts in my database and I am cloning that database. If one of the people who login to that database change their account, then when I make a clone and import their data - i don't get the accounts. How do I do that? apologies if this is a FAQ thanks in advance, sincerely, J__

We're evaluating FileMaker Pro 7 for possible purchase as a replacement for Lotus Approach. I'm attempting to open multiple DBF files and have them placed in one container, but FileMaker is creating an .FP7 file for each DBF. Without having to create a data layout for each table in FileMaker and importing the data individually to each table, is there a way around this?

Hi! I have a *.fp5 file and I can't export any records, and I need to. Is there any way possible? Thanks

I am attempting to combine two identical databases. I was trying to import database 1 into database 2 however for some reason when I want to match field on matching names this option is no available...why would this be the case? Kirsty

i know this may had been asked about 1000 times, but i searched...and searched.....and searched and no luck... please helpt me!!! the thing is, that i'm using Miva Merchant, and this software creates for itself a database .DBF well, the database i need to access is an ORDER database in which there are fields for products...the thing is that it creates lines for each product...beuing something like this Order#|name|product|price|shipping 12345|alex|chicken|9.99|ups ground 12345|alex|puree|5.99|ups ground 12345|alex|peppers|2.99|ups ground 12345|alex|book|29.99|ups ground and so on...the thing is that all of that is just one order and …

when trying to import matching fields you have to set the symbol between the source field and target field to an arrow. Is there an easy way to set all of these to an arrow at present i am having to go through each field and maually click on the symbol to change it to an arrow..any suggestions? Kirsty

Hi FM community, I'm a brand new user of FMP and I have switched from Windows to OS 10.3 Now I need to convert my research db from Access into FMP 6. I have no idea how to do it. Or is there anybody around, who could give me a template, where I can tackle all my research papers, speeches, essays etc as well as quotations, books etc.? And I have a power rechereche to browse in all categories at the same time? I have also in my access db functions, where I can view all my given speeches according the location hold at or view all topics given a a certain place so far. So are there such ready made templates ("resources research") as freeware available? Lookin…

I have a database of 35,000 customers. I am tiring to get a single field (customer name) of 250 customers/records to export into a csv or tab file. so that the file looks like: joe blogs sam smith jon johns bill south joe wiggin ect I want to take the first 250 names then the next 250 then the next 250, ect for the whole 35000. So instead of doing: omiting 250 records show omited export field name delete found records omiting 250 records show omited export field name delete found records omiting 250 records show omited export field name delete found records omiting 250 records show omited export field name delete foun…

I am attempting to import a text file. Sometimes the import works and sometimes not, ie, it will skip a record that actually matches. Match fields: Left: TransNo (text). It contains one of two numbers (InvoiceNumber or PONumber). Right: TransNo (text). Auto-Enter (Replace) by calculation of: InvoiceNo &

Hi All, I want to export the data from FileMaker Pro and get the field names as the column headings. It can be done in .mer file but I want to know if it can be done in any file other than the .mer file. If yes how can we do it. Thanks. Yogesh.

Hi All, Is there a way to "test" that records were imported?? I have an import script that is done WITH dialog so that the users can select the proper things to import. I want to be able to test that they do not decide to press "cancel" during the process. Something like a Get function that says how many records were updated or added. (a lot like the info that is displayed at the end of the import process) Thanks Dan

We are in the process of converting a Filemaker Pro database to Microsoft SQL Server 2000. Does anyone perhaps have any documentation or articles on how to do this? Thx Mark

how can i convert a fp7 file to fp5 file. FileMaker Version: 7 Platform: Windows XP

I have been trying to export a mailing list from an fmp database for three days now. I have exported as every file type of which I can conceive, but all of my mail programs seem to think that my .csv and .tab files are not actually comma-delimited text...what am I doing wrong??? Please help!

Hi and sorry if this has been covered but I have looked and cant find it.. I am running FMP5 Client, Standalone and server. I am wanting to get all my data from Filemaker into a "Tab or "Comma Delimited format. Basically in a text file so I can try and use this info in another software. Is there complete instructions somewhere on how to do this? Thank you, Darin

I have a large text file that is downloaded every day and resides on a server. I need to have FM7 automatically import this file every night after hours. The imported file is a pricebook with over 200,000 records. Since the first searches performed on the imported file trigger time-consuming indexing on each field, I would like to have several of the main search fields indexed after the import so that the users do not have to wait. So in a nutshell, I am looking to design a script that will automatically import the file in the middle of the night and index the fields so that each morning we have a newly updated pricebook that is already indexed. If it matters, since t…

This is kind of a tough one to explain... I want to export sales data from my company website and then use filemaker to arrange the data for import into my accounting software. The accounting software has fields that look like this Customer Name Order Number Purchase Date Product Name Product Price Product Quantity And if the customer orders more than one product, multiple records are assigned the same customer name, order number and purchase date. The exported file from the website is kind of like two databases in one... like this Name Order Number Purchase Date John 67832 05/23/04 Product Price …

How do I force FM6 to export some files to a specioal folder (eg a networked folder on s:folder xfolder yfolder z). Can I use the send message script step in order to set a windows shell command in order to change the current working direktoory (from now c: to then s:) before the export starts? Harald

Is there a way to take a import a record via xml and have FileMaker put it into multiple tables. For example, a customer order might look like this (I'm just typing this in and the code itslef isn't perfect, but I hope it get's my problem across): <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orderID" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="customer_ID" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="FirstName" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LastName" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="10" NAME="Items::ItemID" TYPE="NUMBER"/> </METADATA> <RESUL…

I recently converted to FMP7. I am having this strange problem with an import script that was originally created in FMP5.5. On certain computers, the import script would have the problem finding the FM file to perform the import. It does not happen all the time. i have been trying to remove and add the file but no luck. If anyone has any suggestions, please advice. many thanks..

I have been looking for a way to export data and pictures into a format that can be uploaded to a website. I am experimenting with ExportFM, which looks like it will do what I want. Does anyone have experience with ExportFM? I would appreciate comments and also if there are any other plug-ins that will do the same. My appl is FM6 runtime and cross-platform. Thanks and Happy New Year!

I am exporting a Emergency Dispatch Database (filemaker) to an Excel workbook in order to do response time calculations, graphs, etc.. Here is my problem: I can export the fields to a csv file and open them in Excel without a problem. My problem is the small squares that show up in the csv file. They are separators for multiple time entries. I can not "Replace" them in Excel (can paste them in to the replace menu). I have tried cloning the FM databse and importing the data into the clone and removing multiple entries. Still no help. Any help would be appreciated. I work for a small non-profit Ambulance and need to get this response data.

I'm having a problem with the data text format. I have this database in which the raw data has all been entered in lower-case type. In filemaker I have set the field to display the type in "title-case". However, my mailing service is requireing an excel file. When I export the data as a comma or tab delimeted file i select the option to format the text according to the layout format. However, when I bring the data into excell, it is all lower-case. Does anyone have any suggestions?

can i convert a file created in version 5 to a version 4??? And if no anyone know where i can find a free biblioteque of files in version 4? TIA

I have a number of records, one for each student - each has a number of records related to it in another table, the six or seven courses they take. In version six, when I exported from the student table, and included fields from the related table of courses, the export pulled all the records from the related record. Now, in seven, I'm getting only the first of the related records. How can I tell the export that for each record I want to pull all the related records from the other table? Many thanks,

I am trying to get info from my online mySQL database into FMP7. I have exported the data as an XML file. A snippet looks like this: <?xml version="1.0" encoding="iso-8859-1"?> <virtualantietam_com>

I'm importing from an OBDC data source (MySQL), and I'm sure that the data in many fields is longer than 312 characters on the server, but for some reason, when I import FM7 is only grabbing a maximum of 310-312 characters and then cutting off with every field. I've checked the field definitions in FM7 (text) and validations (none). I don't know very much about the server I'm pulling from (it's our website hosting company, and I'm trying to pull back the data I posted there using a browser). Is this most likely an FM7 problem, or could it be restricted from the other end? Ian

can i take a list of my records and put it into MS Excel? i need to email a coworker our current customers, but i need it in a form for beginners that dont have FM Pro. any suggestions of file type other than Excel that most any computer could open would be appreciated.

I would like to generate a report and have it sent as an email attachment on a weekly basis. Is there any way to do this in Filemaker? Not sure if this is the correct conference for this topic but it looked the most likely. All help greatfully received. Regards

I am new to Version 7 and need some suggestions on importing records which might change weekly. I have a .csv file that is created each week of employees. I want to be able to import the file initially, and then each week import the new file again, and have it mark any missing records from the previous week as employees who have been released, and add any new records from new hires. I would appreciate any suggestions on how to best handle this? Thanks Elliot

A script on a served file imports records from a local FMP6 file. One day the import order changed with apparently no reason. As a result, some fields were imported on the wrong fields. Now I fixed the import order and the badly-performed import. But still I can't understand why this happened and how to prevent it from happening in the future. No changes were made on the served file. Minor changes have been made sometimes in the local file but without deleting or modifying existing fields. Both files never crashed. Any idea? Thank you, Paolo

Hello all I have a problem with a multiple import. Using ODBC I am importing data from multiple tables with a related ID to a single table in filemaker. The problem is that the import will not recognize the match field (=) data if the imports are scripted to perform one after the other. But if I manually import them one table at a time they will recognize the match field. I have tried putting a "commit records" script step after each scripted import but to no avail. Any help would be greatly appreciated Cheers Ben

i have a folder with 100 *.fm7 file in 1 folder try to import all data to single FM database , i don't want to do the manule import one by one. is any scripts that will do auto import with all the file at once ? i try the script in filemaker pro 7 and click each file. but once run the script. it only import the first file. any idea please. maybe a example script will do. example for my question. my folder is locate in C:fm001.fm7, 002.fm7, 003.fm7 so on etc.... what is a script will auto import without manule select one by one ? thanks