Importing & Exporting

I have tried to import a large text files into FM. The file has more than 1 million records. FM seems to import the file, but when you look at the total number of records and check to see if the data was imported properly, you find that many records are not being imported. The same text files were imported into MS Access and all of the records and data are found. The text file is being put into FM 7 on a new Macbook Pro Latop with 1gb of memory. Any thoughts as to why Access is managing the large text file but FM is not? :

I want to do a data merge in MS word using FM file (created with FM8) as the data source. Word is supposed to be able to bring in filemaker data under choose data source. The problem is that when I go to CHOOSE the filemaker file, all of them are greyed out as if word can't recognize them. I have tried this with Mac OS X Tiger using Word 2004 and Windows XP using MS Word 2002. Any ideas? Thanks, Cin

I'm using FileMaker Pro Ver 8 on a Macintosh, and importing files into a table. I am importing three different files, using the Update on Key ID on files 2 and 3. Each file has the date in a different format. Each date gets imported into a FM Pro Date field. So I end up with 3 different dates in each record. FM Pro recognizes all three formats just fine. THey are 6/1/2006 June 1, 2006 2006-06-01 I would like to push a button in FM Pro and convert the fields to a consistent format. Say 2006-06-01. Can anybody point me in the right direction. Thanks mark

I am wondering if anyone has experienced a situation similar to this. Any help or guidance would be appreciated. I have around 25,000 records in my current database. approximately 17,000 of these records have text in a field called "text4infor". I want to find, then export all 17,000 to their own *.txt or *.html file labeling each file as "record#.txt". I know this will take some pretty fancy scripting but it is necessary for an up coming project of mine. Can anyone please help me with this? Thank you all in advance for viewing this post and to those of you offering assistance. Jp.

I'm currently developing a system using filemaker to track our Laptop inventory. We send out laptops every week and we needed a way to track where they are and where they have been using asset tags. I've run into a problem though. I'm wondering if there is a way to import data from the repeating fields of table1 into the repeating fields of table2 without losing the data that was already in the repeating fields of table2. For example: Table1 has a repeating field (laptops) in which 30 of the 50 repeating fields are filled with asset tags. Table2 also has a repeating field (laptops) in which 10 of the repeating fields are filled with data. I want the …

Does anyone know if there is a way to do slide presentation in filemaker and have it look like a powerpoint presentation using the fade effect. In other words the transition would fade from the current record to the next using the pause resume script. Is there is a custom function, technique or plugin that would help achieve this effect? Thanks

Hi : Second post so I'll keep things simple, as my level of FM comprehension is quite low. Is it possible to import full related fields to a presentation through scripting? I don't need the data that they contain. I'm trying to create a customized search mode that automatically shows all fields in current presentation in a new window. I know there's an "Import Table" feature, but don't know if it's what I need. Also, and only if possible, is there any script function(I don't have Advanced, can't create my own) that allows import from current Table/Presentation? as opposed to having to define wich Table/fields to import in each presentation of the DB. Web C…

Can anybody tell me how do I import several tables at once from a database that has all its tables separated, not a multi-table file? I can't hook all the tables after the import step, as they can be marked only individually in the open file dialog box. The question is because the manual says that if you copy or import the tables one at a time, the references may be lost. Tks.

I have a field that is imported with a title and a URL (ie The Alamo, http://www.thealamo.org) I have imported the records into a field then used two fields to calculate the necessary information. Title - MiddleWords(Substitute(impAtt;",";" ");1;2) URL - MiddleWords(Substitute(impAtt;",";" ");4;2) The problem is that the Title field has a variable amount of words. How do I separate between the comma no matter how many words on each side. Thanks.

I've developed a script that charges credit cards with Authorize.net that is activated from a button within Filemaker. When you click the button it opens a browser page and passes data as values in the URL to my script. Here is what the FM script does: "https://www.dealsdirectinc.com/authNet/authTest.asp?phoneNumber="&Invoices::BillingPhone& "&name=" &Leads Clients::BillingName& "&street=" & Leads Clients::BillingAddress1 & " " & Leads Clients::BillingAddress2 & "&city="& Leads Clients::BillingCity& "&state="& Leads Clients::BillingState& "&zip=" & Leads Clients::BillingZipCode& "&invo…

I have a layout with fields that are all formatted as Uppercase. Everytime I export records from this file from this layout some fields are exported formatted as uppercase and others as lowercase. I don

I have been using my current database for about year and have a page where I attach certain files. No problem before, but in the past two days I have had FMP 7 crash alot when adding attachments. Why? It just shuts off and then takes forever to debug. Help me. I don't have time for this. (please forward to correct forum if this forum is not correct)

I have a spreadsheet that has three values separated by commas. I want to import those into three separate fields in FMP. Is that possible? I am guessing it would take some sort of deliminating script. The format is like this: 23.00, 55.00, 150.00. Some fields only have 23.00 or 23.00, 55.00. So I need one field to eqaul the first value before the comma and the next field eqaul the second value before the next comma and the third field to equal the last value in the cell. Thanks.

Is there a way in FMP to reference form fields in a word doc (or PDF for that matter) and inport the data into an existing database. The issue here is not everyone in our team has (or needs) FMP and we have various soft forms for them to fill out. We would then like to import those forms into the database. Is this for FMP v10? Thank you!

I have a 20 fixed width ascii files with 20,000+ records each that I would like to import into filemaker. The files are text files with no deliminaters, 200+ variables, taking up 3200 "positions" or characters. I would like some advice as to how to best move these files into filemaker. Thank you for your advice Chris

I have attached 3 files - XML file, XSLT file and a FileMaker file of how the file should import IMO. Unfortunately I get only 4 child records instead of the 6 I am expecting. Can anyone explain to me how to import the XML file so the records are the same as the example FMP file I have provided with two tables (4 Parent and 6 child records)? P.S. I really don't know much about XML, someone provided the XSLT file for me but I'm about to give up and reinvent the wheel by parsing out the information manually : . Thanks in advance. MyXML.zip

Has anyone got any experience of salesforce.com? Can it integrate with Filemaker? I have seen it being introduced into copmanies and it is very painless compared to most systems that I have seen. They now have an add on called App exchange which is enabling the CRM function to move out to all areas within the company.

I am trying to preserve the hierarchical indenting of styles from a Word document into a filemaker text field. Currently it strips all indenting and left justifies everything. The only thing that comes close is to save the Word doc as an *.ans file which adds differing numbers of spaces for each level. Ideally, I would like to have tabs instead of spaces.

Here's what I'm trying to setup: When I go to import some records from an external file, it pops up a window asking me for a job number to be associated with that record. That value is then stored with each record in a "Job Number" field. What's happening to me is that it places that value either not at all, or in only the first record. Is there a way to pass along a variable from a custom window and have it stored with each and every record that is currently being imported?

Any help would be greatly appreciated. Ok. I am having some trouble with my script. This is what I am trying to accomplish. I receive an excel file that contains a list of UPCs. I will then import this list into the database, UPC.fp7. If the upc imported matches the upc in my image database, images.fp7, the "match field" will return a "1" if the upc is a match and "0" if there is no match. I then want to take all of the found "matches" and export the field contents to 1 folder. Any help would be greatly appreciated Database.zip

I would like to import EXIF data from existing digital photos (ie not straight off the camera). A utility called EXIF-O-Matic does a great job (see attached) but when I try to import the data I can only seem to get it into FMP as a new record for each delimited piece of information. I would like to have all this information in one record (i.e. separate fields) to store with the image of the same name. Is there a simple way to do this or will it require importing all the text into one field and then parse each line using the tabs and carriage returns to separate the elements? Any help appreciated. Cheers, Muzz EXIFtextfile.zip

I have a script which says: Import Records [No dialog; "patch.fp7", Update matching; Windows ANSI] This worked under FM7. Under FM8 it says 'Your access privileges do not allow you to perform this action'.... even when you are Admin with full access privileges. If you call it from another Script (with error capture turned on) it works if you have full access. With more limited access it seems to run but, ultimately, doesn't do the import. Anyone know what has changed between FM7 and FM8 with regard to all of this?

I have a machine that imports a set of number fields that for some reason pulls in decimal points and thousands seporators from an ODBC connection. The same data and program imports into another machine just fine. My question is, is there any way to remove the commas from a number field? the decimal point was easy to fix (truncate) but the commas are a bit difficult. Thanks.

There is a field in my database that always starts with a zero, used by the state for identification. On export to .csv the zero is dropped for whatever reason. I have the export using a layout to do formatting for me, so the 'format using current layout' is checked. The field is also a text field, so it should be exporting everything. This is screwing up my flat file generation, so if you have any insight it would be greatly appreciated!

When a found set is is established on a remote file and i import the records, i receive all the records from that file to my target file. How can i receive only the found set from the remote file and not all the records. Cheers in advance

If I have an item record that has multiple categories, I need it to export with the redundant data as follows: Sterling Silver Ring 19.99 all-rings Sterling Silver Ring 19.99 stoneless-rings Sterling Silver Ring 19.99 pave-rings etc.... for all my products. Is there a way to do this? right now it exports like this: Sterling Silver Ring 19.99 all-rings stoneless-rings pave-rings

I need to export to a tab delimited text file (excel would be an ok alternative if that works) to upload into a seperate server that I cannot control. In order for this to work, the data needs to have a specific header information and spacing that is easy to do manually in excel. I can write reports that look like I need but exporting them to excel it strips out all but field contents and the data and .txt strips out all but the field contents. Does anybody know a way to have the full report exported at tab delimited text or .xls?

I'm trying to import a text file that contains commas and double quotes. When I do the import Filemaker removes all of the double quotes and the chops off all of the data after a comma. I know what its doing it, because quotes are text qualifiers and commas are separators. I tried replacing the commas and quotes with escape characters " and ,. That didn't work either. What should I do?

Hey - probably being really dense - but can anyone tell me how to export data from Filemaker so that when opened in excel the field names become the column names... Help - it's driving me mental...

Hello all, I'm trying to put together an Export script that saves a file to your desktop. I need it to work for both a PC and a MAC. The operation needs to be seamless in that both the PC and MAC users have same script with the same filename on both OS's. On a PC you can define the file path as C:Documents and SettingsAll UsersDesktop it should show up for every user for that PC on thier desktop. However this will only work if they have write permissions to that folder. Since I'm not very good with Macs I have no clue what the relative path would be for the current users desktop. Can anyone help me with the what are the correct file path references …

Hi, How to make FM script to import data from two files (.tab)in FMP in same record in two fields? Thx VJ

Hi all, Was wondering what the best way is to import the last 2 weeks of data from one filemaker file to another Filemaker file with a scripted button? Both files have the same layout. Any help would be great

I've read most of the old posts and really could use help. I'm performing a Find, then within that set, I'm looping to omit any record where Exported = 'yes'. However, I've run into the problem where Omitting a record automatically goes to the next record! So I end up with half of what i need. I could just take out "Go to Record/Request/Page [ Next, Exit after last ]" but then how do I exit the loop? I tried Exit Loop If [status(CurrentFoundCount) = Status(CurrentRecordCount)] but it zeroes out the records and exits the script. Any help really appreciated, script below: Show All Records Perform Find [ Restore find requests, Replace Found Set ] Sort [ Re…

I'd like to build a script to import data from one database to another with multiple tables, but identical structures. I've got most of it written, but I need the script to ask the user for the file name and/or path by browsing for it, and then have the script remember that path so it can perform the import for each table. If the filename and path were certain I'd hardcode that info in the script, but the filename and path won't be the same for every enduser.

This might be a simple question and I am just tired/anmoyed. Is there a way to import data from a filemaker file with multiple tables to a table in another file with multiple tables? Note: Ignore the simple solution of exporting to an excel file(or any other file type), and then importing the excel file back in. This way works very well... but I need to know if it is possible. For further clarification: Assume I have file1.fp8, with tables table1, table2, table 3. I also have file2 with tables table4, table5, table6. I want table6 to import table1. I cant combine the files either.

I have a large number of records that I'm trying to update using FM8 Advanced "Update matching records in found set" with the add new records option. The matching field is a unique ID number in both the existing database and the records to be imported. However when I finish importing, many of the records have been updated with data from different records in different fields. In other words record A, field 1 will be updated from imported record A, field 1, but field 2 will be updated from Record C. As far as I can tell , it is a completely random shuffle. Happens whether I import directly from another Filemaker database, Excel file and happens on both XP and OS X. Com…

We received a text file with dates formatted mm/dd/yyyy and imported it into our hosted file but the dates got messed up. 5/8/06 became 8/5/06 with the month and day switching positions. It only seems to have switched dates with days under than 13 as the date 3/16/2006 imported fine. My thoughts are that it has to do with the File Options -> Text Settings. Here you have the option to use System Setting or File Saved Settings. I am not sure what the user settings were when the data was imported so this may have caused the switch. Is there some way to tell what the hosted files saved settings are to see if it is set to dd/mm/yyyy instead of mm/dd/yyy…

Hi everyone. I'm a FileMaker newbie, so please be gentle. I am attempting to import a .dbf (level III) file into an existing database in FMP 8. I was able to import these files easily in FileMaker 7, but now that we've upgraded, each time I try to import the file, I receive a message that says all of the records have been skipped due to errors. However, the exact same file comes into FileMaker 7 with no problem. The only workaround I've found is to open the .dbf file in MS Excel, save it as an .xls document, and then import that file into FMP 8. I do not manipulate the data in any way, just saving it with a different extension, and it works. I am just a…

Hi, I'm developing an automated batch export of a bunch of fields with SoftReturns between each line, so the info can be collected at the other end by InDesign and formatted on the run. All sounds cool huh. It almost all works, but... FileMaker always changes my SoftReturns (Linefeeds) back into FullReturns. The formatting of the text when it gets to it's InDesign location relies on the line breaks to be SoftReturns. Anyone know anything about FMPro's distinct dislike of SoftReturns? I'll Find/Replace in InDesign but would love a FMPro solution if it exists. Paul

OK i think this will only require a simple solution, but im not too good with filemaker so i don't know how to do this. Ok i have a table called member list with a field called Name. There is another table called points list with a field called name, this is the field the relationship is based on. I was wonderering how to script a button that will take me from the member list to the points list layout,then creates a new record and then copies the data that was in the Member Name field into the Points list Name field. Thanks for all help

I have 2 tables in my database and I realize I want just one. Do I have to export to Excel and the import from Excel? I am dealing with a festival and one table is for "approved" artists and the other is for "potential" artists. I am now using radio buttons to separate them and can combine the tables. What's the best (read easiest) to do this? tia

Hi, This question has been asked for FM8 but I don't see any post regarding FM6. I want to export to a file, using data from one of my fields as the filename. eg, create a PDF document of an invoice, using the invoice number as the filename. Is there a script step that an do this in FM6?? thanks

I searched this topic and the security and migration topics and didn't see an answer to my question. I took a snapshot of a database in production. Added tables, fields, layouts, etc to the snapshot. Now I want to replace the production database. I have import scripts that manage all of the data imports from production to snapshot -- including fixing some primary keys, deleting partial records, etc. -- but I can't figure out how to import the security tables. Users have been added in the interim, no changes to privilege sets, etc. I can determine which user accounts are new using DDR, but I can't get their passwords from the production database to the replacement sna…

I have a FileMaker 5/6 solution. When I create a new release I import the records from the old version into the new version of the program. I have done this sucessfully hundreds of times. Today, I ran into a problem I can't figure out. When I try to import the records from the previous version, the import process goes very slow (8-10 records/minute) and the file I'm importing into becomes very large and after about 50 records the Filemaker file size is exceded.I stopped the import process after importing 30 records and the file size icreased from about 20mb to 650mb. Can anyone help me with this problem?

Just wanted to let everyone know there's a new iCal Import Template available -- newly developed by Jonathan Stark and available on his website (see "Cross Platform iCal to FMP8") http://www.jonathanstark.com/pages/welcome.php I'm very impressed with the clarity of the implementation and it certainly meets my need for a basic capability that can be extended if needed. Thanks, Jonathan.

Hi I have exported records from FM to a XML document using a style sheet, and now need to email it. Is there a way that I can embed the xml file in the email so that it will view in the email like it does if I was to open it in a web browser. At the moment it just shows a attachment icon in the email. (Mail 2.0.7)

When trying to import data into File Maker 8 Advanced. I am getting the following Parsing error; "Type:NetAccessorException error Column:0 Line:0" If anyone has any suggestions on this, please let me know.

Hi, I am looking for a possibility to convert FileMaker 8 text formated fields (italic, bold, etc.) to HTML. I appreciate very much your feed-back on this. I need to get the internal FileMaker formatting converted to HTML tags before I import data. Thank you, Gavril

I'm having much difficulty interfacing with our companies MRP database. The MRP database was written in Visual FoxPro and therefore creates Visual FoxPro DBF files. These files are almost identical as dBase III DBF files with the exception of the header. Does anyone have information on how to get Visual FoxPro DBF files into FMP? I need to re-import often, so the process needs to be automated. We have FMP Server on OS X Server, so a command line DBF converted or something like it would work. Any suggestions or different approaches would be gladly appreciated. BTW, I have yet tried ODBC simply because of my lack of knowledge on the subject.

Hey All, I have a bunch of converted dbs from FMP5, now in FMP8. I am going through them all and fixing all my scripts and fields and such. When I'm done, I plan to reconvert our still used FMP5 files again to FMP8.. save my fixed FMP8 versions as clones, and import all the data from the fresh converts into the clones. I have about 35 heavily related databases with all kinds of calculation-based joins and such. I tested this casually, but I just want to make sure. Provided I make no real changes to fields (no new ones, no changes to field types) and import fieldname-fieldname, the import of the updated data *should* go pretty smoothly, right? Are there…

With good ol' FMP4 when exporting, the default filetype was FP3. Having converted my database to FMP8 it defaults to exporting to tab delimited format, which is really going to mess up my easily-confusable users. How can I specify a default export file format so my users only have to simply specify a filename when saving? Hope someone can assist. Mark

Hello every body, tx in advance to your help source .txt file with some field (#tape, number of gig, date of backup) filemaker file : filemaker database with some field (#tape, number of gig, date backup, expiration date) . The filemaker database countain many record with the same #tape, to see the "life of the tape", so when I perform a find on the #tape, I found many record, sort in descending order on expiration date, so the last record I see, tell me if the tape was recycle or not(if not recycle the expiration date is empty) i would like to be able to perfom this task selct a .txt file for import If not cancel read ONE record from the sou…

Hi, We have a semi-large solution - 20-25 files and we are in the process of converting this to Pro 8. Our clients are still running the 6 version, and we are about to roll out the 8 version. The process will be: 1. Convert the client's 6 version to 8 (we need to do this for the container data). 2. Import the converted files into our master 8 version. We have created import scripts in each of the files, so this is pretty automated. Here is the problem: When each import is called, we are prompted for the Username/Password for the file we are importing from... This is kind of a nuisance when we are doing it for 20-25 files, and for a dozen or so…

I hoping someone can give me a roadmap to do the following... I'd like to create a database that can export information to Word, where the final editing will be done. For example: In the database, the user would be asked to select via checkbox: "The color of the sky is (a) blue, (: green or © red." Say, the (a) checkbox is selected, the Word document would have a statement "The color of the sky is blue". If the user edits the Word document to, say, "The colour of the sky is magenta", I will NOT need the changes reflected in the database. Creating the series of statements with checkboxes is not a problem - my problem is how to export to Word. Any help …

I'm importing some data from a spreadsheet that includes a column of dates that were not formated as dates. It's a simple table containing some daily class attendance numbers for a single year. I've got a total of 365 records and they are sorted correctly so all I need to do is insert the dates into the date field. Is there some kind of simple calculation I can use to replace the contents of the date field with a sequence of dates starting January 1, 2005 and ending Decmber 31, 2005? TIA

I had a customer call me and I need help from Filemaker Gods (all of you). When she imports a certian single record it imports the wrong record. When she does the exact same thing on a different machine it worked fine. She tried it like 5 or 6 times and everytime it pulls the wrong record. What do you think?

Does anyone know a way to export records from a portal and the related record from the parent file WITHOUT creating breaks in the report? For example, I get this on output: record 1 portal field 1 portal field 2 portal field 3 record 2 portal field 1 portal field 2 and what I want is: record 1 portal field 1 record 1 portal field 2 record 1 portal field 3 record 2 portal field 1 record 2 portal field 2 The main related record is exported with every portal row occurance. Thanks!

Does anyone have any idea how to downloag data from online sites like amazon or imdb? I want to download movie info from their servder direct into filemaker?? Any hints are welcome!! Thanks

Hi guys, I m new to filemaker pro. I want to achieve connectivity between cocoa & filemaker pro. I searched about this. There are certain examples describing this using Applescript. But my requirement is to achieve this using Objective-C. How to do this? Please guide me. Thanks, Parag

sorry I have an important archive made with an old version of FM,probably 1.0 or 2.0 with a Macintosh very old...it does not have no extension..And when a try to open it with a FM 7 or 8,it doesn`t work..It shows me a message,inviting me to open it with a 2.0 viewer...could you help me?thanks a lot

hi, i am very new to filemaker, can you please hep guys. i am importing an excel file which has some comma seperated values in one cell that goes into a checkbox set in fm8. but i cannot manage it, the checkbox set does not understand commas. for example the cell contains: America, UK, Germany, Italy and the checkbox set has the same values as a custom list How can i import the data to checkbox set and display the values checked?

I have a FM database that I converted from FM 6 to 8. Part of the solution does an import of a text file. It worked fine in FM 6 but does not in FM 8. When I import the text file it says 3,075 records have been imported. If I import the same file into the old FM 6 database it imports 4,810 records. If I open the text file with Excel and ask it to treat the file as a comma delimited file it finds 4,810 rows. If I compare the Excel spread sheet (4,810 rows) with the FM 8 import the records are fine up to record 2,184. It has a single " at the end of a field. All the text in the file after that gets put into the next field for the following 102 records. That …

I scripted an Import step and selected the option to skip the first record (since it contains column headers). Then I deselected Specify Data Source so that I would be prompted at run time to locate the input file. However, doing so appears to cause the Import step to forget to skip the first record. Is this working as advertised?

Hi Can anyone help me. I have to export invoices from Filemaker as an ASCII file so that they will go in to another program. It is a banking piece of software. Many thanks

I have a field that's being exported to a .csv and it's dropping the leading zero in the field. On the layout the field is correct (081xxxxxxxxx), and the export is set to format using current layout. The field itself is a text field, not a number field. I'm a little confused why it's doing this. Any help would be appreciated.

I'm importing data (3 fields productID, productGroup and description) from an ODBC datasource. I want to autoenter a calucation into a new field which grabs data from productID and productGroup to make a primary key, but autoenter seems to do nothing upon import? Does anyone have any suggestions to why this is happening?

Hardware/Software Mac G5, OSX 10.4.6, FM7 Description: I have one table (APP) to hire/assign employees to a job via a pull-down value list. In another related table (JOBS) I have budget codes assigned to the specific jobs. (19 digit numeric. Example: 0172620330361409200). When I assign an applicant to a job, the 19 digit budget code is auto-entered into the budget code field in the APP table. When setting up this relationship I noticed that the APP auto entered the budget code into the field (as expected) but formatted like: 1.762e+17 …if I clicked into the field it would change to the expected 19 digit code. I solved this problem by changing the format…

I have 2 copies of a FileMaker 4 file. They are identical except they contain different records. Is there an easy way to combine the two AND eliminate any duplicate records? Thanks in advance!

How do I perform a "find" when I want to see records where a certain field is "not null"

I have adapted the FM7 Document Library template to store images (as references), however when I import using: Show all records Set error capture off import records, update existing records perform find to show imported records constrain found set the pictures imported replace existing records meaning i have to find the new pictures manually change the details and then re-enter the details for the misplaced records. Apologies if this is not particularly clear however i am not entirley sure how this can be happening. I have included a sample of the database to illustrate my problems. I am wondering if it is something to do with only importing a …

Is there a way to pre-set a value for one field before importing records, such that this new value would populate that field for each new record. I have a list of standard tasks in one table. I would like to be able to change the name of a particular WORKER on the fly, then import a list of tasks with his name entered into the WORKER field. The list of tasks would be imported as a list of constants, but the name field would be variable, before the import. I hope I explained this right. Any ideas? Jarvis

I am using FM8 pro and I have created a report layout that works perfectly. It is made by only showing the summary fields for each postal code to essential add up sales figures by postal codes. The report works fine and the pdf export is perfect, exactly whatever you see on screen. The probelm is that I want to export this data to excel, but when I use the export to excel feature, it exports all of the data each record and not just the summary fields as I have on the report, it infact exports every record with the same numbers as they are summary fields. Is there a way to do this or is there some sort of third party app that can have the report printed as…

I'm thinking of getting FileMaker to replace a program called RapidFile that runs on DOS (it's about time!). I'm just wondering if I will be able to transfer the data from DOS to Windows in order to import it into FileMaker or if I'll have to start over from scratch (transfering all that data manually)? Thanks for your help!

Hallo, Is there anyone who can tell me if there's a way to reset a project file. With reseting I mean especially these two points (the first one is more important as I could write a script for the second one if there's no built-in function) - reseting the incrementation back to the "original" value; e.g.: if I use a field with a serial number. At the beginning I set the "next value" to '1'. Than I made 5 new records. Is there a way to reset the value back to '1', without going through each table and changing the "next value" entry for each necessary field manualy? - is there a built-in function to delete all records (regardless how many tables I used) with …

I need to use vowels with macrons often and can't figure out how to input them.

Hello ! I have a Contacts table, and Product_Summary table which basically just contains contactID and ProductName, summarising all the products a contact has. I can export this information fine if I do it from the ProductName table, but it then excludes all contacts who DO NOT have any products to their name - which is a problem for me. I then tried to export this information from the Contacts table itself, and included the related product summary fields in. This solved the problem, but I now have another problem - the same one as Tewan in Topic#175387; ie I am getting Contact 1 Product 1 Product 2 Product 3 Contact 2 Product 1 in my …

We have both Quicken and QuickBooks and wanted to know if there is any problem importing into them from FileMaker? They are sending them from another office and thought I would ask you guys before I start stumbling around in the dark. Thanks, Bill

What do you consider to be better backup strategy of the two listed below and why? 1. Save a copy as 2. Exporting individual tables

Has anybody tried exporting to a CMX3600 format? It is a combination of headers, tabs and carriage returns, used for AVID editing software. Just thought I'd ask before I plough ahead and try to work it out myself.

Hi there; can anyone help me with a maybe simple question. I'd like to print a layout to a .pdf file and have the filename i.e. "customerID & date/time". Thanks Rick

My desired end result is to email one record having formatted HTML embeded in the body of the email. In DreamWeaver, I created my HTML template and where field data would go I added <> tags. In my database I have a global field that contains the HTML code I copied from DreamWeaver. I have a calculation field which uses Sustitute to convert the <> tags to the record fields. In the Send Mail step I specify in the message body the global that contains the formatted HTML. Instead of formatted HTML in the email I get the same HTML code from DreamWeaver. What did I do wrong?? Any help is much appreciated.

I've seen tons of posts about the poor ability of FMPro 7 to export anything really useful to Quark Xpress, but no answers to the dilemma. Here's one, an old-fashioned Filemaker hack: Strategy: Using GetAsCSS as a springboard, do a series of substitutes and manipulations to get usable Quark text. (Resulting field doesn't contain paragraph styles. It's just raw text with Xpress Tags-compliant local formatting.) In the process, we also end up with a Minimal CSS text field, which strips out all font declarations except for bold, italic, super- and subscript. Useful for fields where users paste data in from various sources. (You don't want the blue underlined text, …

In my application (it's pretty simple -- not many fields), I am importing ~ 50,000 records (about 8 fields). The import works, but it's very slow. takes 10+ minutes on a pretty fast XP workstation. After I work with the records, I have to delete them. Deleting is almost as slow. I would think that deleting 50,000 records should be done in less than 3 seconds. It takes upwards of 90 seconds. I'm deleting all records in the table, but given how slow this works, I'm wondering if each record is being deleted one at a time rather than deleting in bulk?? This concerns me because when I move this app to a server for multi-user, all I can see is a slow dog..... …

Hi all, i want to export my fm database to pdf. But i want the name of the file to be similier to the chosen record that's getting exported. Can this be done in Fm or can't the name be variable? thx in advance for ur help

Hello, I have received a FileMaker XML export file (from my customer). In this file each record is stated (something) like below: I do not have FileMaker installed to determine what the values for modid and recordid stand for, so can anybody explain this to me? I assume that one of these values is the primary key of the exported table, or am I wrong? Thx, Dennieku

I am trying to export a container field containing a PDF to the /tmp/ directory and activate Preview.app afterwards for the file. However, I cannot figure out how to specify the output file in the dialog you get when you create an "Export Field contents" script step. I've tried file:/tmp/filename.pdf, file:/private/tmp/filename.pdf , the combinations with filemac: and also created a symlink to the /tmp directory and try using the symlink to no avail. It is not a rights problem: I can export full records to the /tmp directory manually without any problem. Have any other forum members succesfully scripted an export to a temp directory on OS X to preview the file …

Hi This goes out to all the SQL people. I have a Filemaker Database and a MySQL Database on my computer (localhost). I have set up an ODBC connection with the actual odbc driver. I want to export data from my Filemaker table into my MySQL database with the same table. Therefor i have created a sript that connects successfully to the MySQL database. The only problem is that is inserts my SQL statement into the culumms instead of the Filemaker data. The script goes like this: INSERT INTO g2_user (g_id, g_userName, g_fullName, g_hashedPassword, g_email, g_language) VALUES ('" & g2_user::g_id & "', '" & g2_user::g_userName & "', '" & g2_user::g…

OK, it's been a thorn for forever. Smart quotes, tab characters, ellipses, emdashes...I can enter them using keystroke combos (good old Mac keyboard) but FMP exports them as garbage: TextWrangler Zaps them all to 0xFFFD, Unicode for "unknown character." And I'm talking about characters in text data in fields. Thi is not a situation where replacing by calc or global is feasible. Is there anything that can read FMP's garbage text? Do later versions of FMP do better? Thanks!

I need to be able to import the data from the currently used database into the new build that I have been working on. I intended to write an export/import script, but all but the main table on the new database are grayed out. FM 6 was simpler . . . I think . . . It also says I can't export container fields. My customer has a server with images, and we link several photos to the container fields. Won't it at least export a path to find them???

hi all, i have to take information per suite for a condo from a excel file and plug them in to my fm database. in the excel file i have 3 to 4 rows per suite that provide different information, but the first cell of the row is the suite number. ok here is my problem.... i have imported an excel file into my fm database. i have 3 to 4 records that belong to one suit number, and i have made scripts to cut and paste the infomation into their own fields. now i need make one record (suite) with all parts of information. thanks

I have 743 records that are match imported with another file which also has 743 records. I have selected: -Update matching records in found set -Add remaining data as new records The import performs with no problem but the "Import Summary" window that shows after the import states that 22718 records were updated or modified. Has anyone had this problem with FM8Adv_v2?

Hi, I need help - I want to create new record, then I want to export it to new excel file (I have to use a special excel template) and name the new file for example: 20060301.xls Can anybody give me a hint? Thanks for your help!

Hi All, I was wondering if it is possible to create a backup of the DB file and not overwrite the file. I want to be able keep of a log of the changes. Your help is much appriecated. Thank you, SO

There have been several posts on similar questions (Topic#173032 in particular) but I haven't found an answer to my situation. My script contains an Import step that includes the dialog asking the user to locate the file she wants to import. On Mac, it's the OSX Open File dialog; I imagine there's something similar for Windows XP. I want my script to be able to subsequently grab the file name or path that she selected. Can it be done for both OS's, without external scripting or tricks that depend on the file being in a certain folder?

I have a file of orders to import into the Invoices and LineItems tables of a FM database. Each record in the orders file contains both a line item and the customer's shipping information. Obviously, the shipping information belongs in Invoices and the line item belongs in LineItems. Right now I use two Import passes - one to add records to Invoices, and one to add records to LineItems - and finally I remove the duplicate Invoice records. Is there a better approach? One that eliminates the addition - and subsequent removal - of redundant Invoice records? (Better yet, a single-pass solution.) Thank you, Chap

I have two versions of the same file. One has had certain records updated and I want to import those back into the main file. Problem: When I import, it only imports the fields listed on the table, not information from related tables. When looking at the field mapping screen I can scroll through the other tables to get to the related table and select which fields to import, but I can't make those fields appear on the target side of the equation. How do I get my data to transfer?!

I'm not sure which forum this is appropriate to. I would like to have a web form that anyone could enter data and submit it to a Filemaker Database (which I have running on Filemaker Server Advanced 8.) I can get it so I have a form directly accessible by it's URL with a guest log-in and scripted buttons to add a new record and submit it through instant web publishing. However, when using the log-out script, they are taken to the iwp_home.html page. I would prefer them to be sent to a specified URL. If I direct the button to another URL, the log out script which follows doesn't execute. Is there anyway to get that log-out script to send them to spec…

I have a database that has several calulating fields. After importing several thousand records, I cannot get the new records to calculate. If I manually add a record, the calc fields work fine. Anybody have any answers for me?

Dear all, Hope someone can help me with this one. I have mistakenly deleted 200 records from my database. I have them on a USB as part of 1500 but when I try and add them to the remaining records (1300) all 1500 are added. I have lots of duplications now. How can I select only to add the missing 200? I can't simply replace all unfortunately as the backup was made a while ago and I have added a lot more since. Anyone want to be a hero?!

Hi guys I've been developing an intranet interface with FX.php for a client's filemaker system. Work is going well, and the system is looking great. This also greatly improves their external access to their database as no more remote desktop, whilst still having FileMaker Server for data storage. I was wondering what options there are for exporting FileMaker 5.5/6 to a remote MySQL table?? I've tried exporting a CSV, then messing around with the data and adding SQL INSERT instructions to each line - and it works. Sort of. Somehow managed to get about 2,000 extra records in my SQL table. Also had to split my CSV into several parts. There's a …