Importing & Exporting

I am trying to open an Excel file in Filemaker 6 and it will not give me the option of using the header row as field names. I recently updated to Office 2008 version 12.2.27. I have always been able to do this in the past. Any ideas will be appreciated!

Hello Is there a way to upload a video stored in FM to youtube. Is there some type of plugin. Thanks

Hi, I have an old FM database that I inherited and I've built upon over the last 10 years. It's to keep track of club members and the programs they purchase. It's always been flat, that is 1 table. So each time they add an additional program I just copy the existing record - kinda messy I know, but it's always been manual entry and it works. I've added a lot of calculations and scripts so that it can send out itemized emails with everything from purchases to ID numbers for an on-line booking system that we have. This year the club is adding an on-line registration ecommerce solution (built by an ecommerce developer). What I'd like to do is revamp the da…

When importing new records into a db, Filemaker will usually write info to a file called "Import.log" located in the same folder as the db file. In the recent past, this would work for me. Now it is not working. Nothing is written to the file upon importing new records, no matter if there are import errors or not. I think I moved the file out of the folder, but I did move it back. I am using FM Pro Advanced 11.0v2 on Mac OSX 10.6.5. So: 1. How do you cause FM to start or stop writing to import.log (I can't find a preference for this)? 2. Can you change the name of import.log and have it still work? Thanks, Paul

Hello guys, I have a question, i am connected remotely to my database. The server is installed on a computer with FM 11 server advanced. When i want to import from MySQL i got this error ( i can read and see the information in MySQL) The file “?” could not be opened. (Not Found) The previous script step, “Import Records”, could not be completed because of an error. Do you wish to continue with this script? Privilege for the Admin user is FULL ACCESS And the script has also the function FULL ACCESS ODBC is enabled in the server. Does some one know how to let it work? Greetings, Serhat Dalgara

I'm trying to export a layout that has 2nd generation calculated fields on it and I'm having some issues. IE: My calculated field is two levels deep, the first field preforms a list() to get a string of related data, then the second (the display calculation) is a parse of that string. The calculation works fine in both standard view and preview modes, but when exporting to CVS, excel, tab, etc the calculations are all 0? What am I missing here?

I am exporting to XML and producing a Tab-Delimited file. Everything exports well except for text fields that have multiple lines in them. How do I make the stylesheet handle the multiple lines per field so they stay in the same field? Example of multiple lines: This tool is 18Volts. This tool has no charger. Also, how do I change the stylesheet to enclose each field with double-quotes? Thank you Fenton for your excellent help on this earlier. You provided a stylesheet that works very well. Here is the stylesheet that I have: <?xml version="1.0" encoding="utf-8"?> xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-pre…

Item table has a historical values table. There can be multiple historical values per item. The relationships is defined that historical values can be deleted/created/etc from the item. I have a script to update the historical values with current info from the item table. What is happening is that it seems to be overlaying the existing portal row rather than creating another one. Freeze window Go to layout [item layout with the history portal in it] show all records go to record/request/page [first] loop go to portal row [last] set field [historical::value; item::value] ..then several more set field lines.. end if go to record/request/page [nex…

I am trying to import over 10000 records from an excel sheet into a filemaker database. I am only trying to import one unique number field. The issue that I am having is that there are holes in my excel spreadsheet that will not match up with the filemaker database. He is what I am doing right now. I run the import and match all field names up and the only thing that is being imported is the constituent ID field if there is a positive match. So the first time I ran the import only 600 fields matched up and only 600 records out of 10000 were created. I then manipulated my excel data sheet and deleted all rows that were just imported so that all the records that I just impo…

This is similar to 3217167 Importing from old copies of the same database. I have database A developed several years ago. There is now database B with new tables and some similar fields but with different names. I need an automated way to import the old informtion into the new database. I I am now at the point of using the IMPORT command to import. Part of that is the mapping of the old fields to the new fields. But when I go the screen where I indicate the mapping, the source table/fields naturally are not there. 1. How do I specify the mapping if the screen doesn't know what the input database is? 2. Do I copy the old database structure into aa "dumm…

I want to import data from a csv file which has a series of dates in it. The only problem is the date is set up day, month, year and file maker reads things month, day, year. How can I import my data so they align?. It is quite a lot of dates from a variety of months. Can I fix it in excel? Is it possible to change the date configuration so the data actual changes it's structure? Nothing seems to work to date. Any help would be appreciated. Thanks in advance.

I have developed a database on a network made up of Windows clients. We just added a Mac to the mix and I need to adjust all my export scripts to make them cross platform. I started by adding an if statement that uses Get ( SystemPlatform ) to return a 1 if on a Mac and a -2 if on Windows. So now I just need to know how to structure an export path for the mac. For windows it's filewin: . Thanks in advance.

My goal is to Save As PDF to a new folder on the user's Desktop which I name(!) using a record ID, and this must work x-plat. I will be exporting additionally pdfs to this folder for a grand total of about 5 pdfs. I'm aware of JMO's export of a zipped folder, but that does not let me name the folder dynamically (and will in fact overwrite the folder if it exists). I need a MakeDir function in FM (if only FTPeek's plugin worked on local directories, Jesse!), and I was hoping for a technique rather than using Troi (unless that's run on the server, we're trying to push all plug-in dependencies to server scripts). Many thanks to any and all ideas or empathy.

I'm using fm pro to export a single record in xml format which is "merged" with an xsl file and opens in word: I have got all that to work. I want to be able to give the resultant file a name that will conform to a particular layout and so I want to pick up a value in the file and make that the file name: how do it do it? I think the answer lies in the $variable filename parameter but I cannot get the syntax right. thanks in advance for your help.

Hi, is there any way to import accounts from a FM file to another one???

I use the script step "insert picture" to automatically pull the most recent version of my document "Artwork.jpg." the script pulls the image from the same document each time after we overwrite the document. works great. imagemac:/MyComputer/Documents/Artwork.jpg Here is the problem: I need multiple people to be able to work on the database without importing each others document by accident. So I need to make this filepath dynamic for each machine that it runs on. Can you help?

I was wondering if someone could explain to me what the Group By option is and how to use it when exporting an excel file. Thanks

I've searched and searched but can't find much info on my query in the forums - hopefully someone can help me. I've been building a database to log the flights our helicopter company does. We have a current Access system but having been built closer to 2000, and ported use from another department it is time for something much better. We're making great progress developing what we want on Filemaker, which brings me to my question. We were hoping to have a cut down version of the database running on an iPad in the helicopter so that crews could log the exact times they go off and back on at jobs with the touch of a button, aircraft start up and shut down time…

Hello all - I have hit a wall on this one. I manage an inspection/property maintenance/permit database for the city I work in. Monthly, we receive an updated ownership file from the county. Past practice has been to wipe out the old ownership data, and import the new file. This worked fine untill I began to build in some relationships and added features to the system. Now, if we remove the file from the server, and then bring the new one back online - I seem to lose the relational tie and many of the functions I have built no longer operate correctly. My thought was to import and update the records using the match field, rather than starting ove…

Hi folks, I did not really know if I had to put this topic in the "Import/Export" or the "IWP" forum, so I put it here As you all know, the filemaker command "export" is not compatible with the IWP. So there is no direct way to export records in a excel file from there. I found a way (pretty complicated tho) but it SHOULD work. Could you please give me your opinion about it ? and IF BY LUCK, someone has the miracle solution, I will be glad to read it ;-) So, my solution : If a user wants to exports a bunch of records from the IWP, it will put a "command" in a spool (layout) with the desired parameters. In my case, this will put : command_id, use…

On the road, far from any IT support! Import folder>Specify location - unable to browse to a location. All we see is "Desktop" and "Username" Does this ring a bell with anyone? I reckon it is a simple setting somewhere.... thanks in advance for any help offered.

My apologies if this topic has previously been discussed but I wasn't able to find a thread on this specific issue. I'm trying to script the import of a found set of records from one table to another within the same file. Unlike importing between tables of different files, the current import copies over all records in the table despite there being a window for that table with a found set. I've scripted this numerous times between files without a hitch (and in various versions). Is there an additional step that needs to be taken when the import takes place within a single file? ...or is importing a found set only supported between different files? Thanks for y…

Anyone know of a plug-in that's still available to export as a CSV file that includes field names in FMP6? Or any ideas for a work around? I've thought about creating a temp record and populating the fields with the field names but prefer something more straight forward. Thanks much.

Hi guys, I wrote an AppleScript that calls a FileMaker script that imports data records from an xml file, with lots of help from this forum! (Thanks!) Now I discover that the xml data (provided by another program) does not always have the same fields. Specifically, some of the fields may be missing (depending on options in the generating program). For example a record may contain: Field1 Field2 Field3 Field6 Field7 with fields 4 and 5 missing from this record. FileMaker simply imports the data from fields 6 and 7 into the slots that were supposed to be for the missing fields 4 and 5. This is perfectly understandable for a {comma,separated,list,…

I have two databases. A Product database: This is very large, housing thousands of manufacturers and hundreds of thousands of products in two related tables: "manufacturers" and "products", linked by the field "company". An analysis database: This runs analyses on product information that was stored in the "product" database above. My goal is to make a script that uploads or imports "product" records to the analysis database, and in the process creates new product records that I can analyze independently of the larger database, after the upload or record transfer is complete. I would like to select a "company" name and upload or transfer all the rela…

Hi all, I have an inspection system. It produces a report of an inspection of an item and all its parts. The item will be inspected multiple times during the year and I would like to be able to show the most recent inspection beside the current inspection so the user can compare the last one to the one he is doing now. Typically a few months will pass between inspections so there are likely to be changes to the item and its parts. I have fields: item1, item1_part1, item1_comment1. There are multiples of these. The inspection system joins the above into Item1_joined1, so I'm thinking that by exporting just this joined fields into an archived databa…

I have a database where I import pdf files into container fields as objects. The database user should be able to turn the pdf document pages. I see that this is possible in FMP 11 but I am not sure if it can be done with my FMP version 9. Any idea? thank you in advance.

I need to convert and import relational data to flat data for use in a statistical program I'm using relational DB with portals. I'm Following patient lab data over time. In master DB patients have a medical record number (MRN). In related DB patients have a date of labs and a value of the lab on that date. MRN DATE SODIUM 11943958 02/22/2010 139 11943958 07/20/2010 137 11943958 09/11/2010 133 11000000 02/22/2010 140 11000000 07/20/2010 135 11000000 09/11/2010 139 I NEED MRN 02/22/2010 07/20/2010 09/11/2010 11943958 139 …

Hello all, I have a FileMaker solution I am planning on rolling out to several small companies. I know that over time, I'll be enhancing the database to include new tables and data that are not present in older copies. When creating a data migration script to take customer data from an older version to a newer version, I've found that FileMaker has trouble when you script an import and suddenly the import source doesn't have the table you expected to be found. FM will default to the next available table and just carry on happily. Of course, if you set "Matching Field Names" as the import arrange by method no fields will match (normally) BUT, FileMaker will cr…

Here is my scenario: My business gets it its orders from our online shopping cart website. The orders get stored in the control panel of our shopping cart solution. These orders have to then be taken out and put into filemaker where we process the orders. When there are a lot of orders this becomes a very tedious process, but I noticed that the shopping cart solution allows you to export all the orders. The only issue is that in my filemaker invoice solution all the items for the order are stored in a portal field. Whenever I export the records as a csv file from the website, and a order has more than 1 item the second item is made into a completely new rec…

I have a scripted import that imports between two tables in the same solution but we found that the import mapping changes for different privilege sets due to field access restrictions. We are finding that the data is going into the wrong fields because a user does not have access to certain fields in the source table even though those fields are not being imported. This makes a huge mess and inaccurate results. I would have thought that setting the import order in the script and using last order would keep the fields aligned correctly but that does not work even when running the script with full access privileges. I hope there is something simple that I h…

I'm receiving excel documents from a coworker that are vertical in format rather than horizontal. In other words, each column in excel is a record, with the first column (A) being the field names. FileMaker seems to insist on assuming that each row in a spreadsheet is a record. Can someone suggest a way of getting that data into FileMaker correctly without altering the excel document? It's a data template that's been in use forever, so I need to find a way to work with it as is.

I have a script to import a .csv file. Once the file is selected a number of other processes run on the imported records. When a user cancels the file selection dialog the script continues without the imported file. Is there a way I can capture for this cancel and exit the script? Thanks

Hi all forgive me if this not the area to post this in. I have reached very far and wide only to become more and more exceedingly frustrated with my issue, hopefully some kind should here will be able to shed some light on what i must do. But enough preamble. What i seek is a method by which to provide a link within a database to a folder which contains multiple photos pertinent to the record. should the folder not exist i would like to be able to manually define a link to a relevant folder or at least to be able to browse a list of folders available. I was hoping that this would be an easy task and was half expecting i could drag the folder into my database and that …

I have a database that works without issue. In it, I have a one to many relationship (Personnel - The One/PDFs - The Many). In the Personnel table, the ID consists of Left (LastName;3 ) & Left ( :FirstName ;2) & 0 & 0 & 0 ) or ACASA000. The PDF container files I want to integrate with this personnel table have the same Left (LastName;3 ) & Left ( FirstName ;2) & 0 & 0 & 0 plus extender i. e. -09242010 or ACASA000-09242010 Question: How do I import the container files (the Many) to properly connect to personnel (the One)? I have the PDF ID and PDF name files ready to go into the system but don't know how to do the import witho…

Does anybody know why line feed characters display in a text field as return characters when I use FMP 11 Advanced, but are not recognised when I use FMP 8.5 on another Mac to view the same data? In the past I have had to fiddle about to change line feeds characters in imported text into carriage return characters. Seems I won't need to do this if I can just work out why FMP 11 is behaving so well and why FMP 8.5 is not.

Hi all, Can anyone teach/help me how to create batch import script? I have multiple .xls files (100+) in 1 folder that I would like to import to 1 table. Appreciate your help. Thanks

I'm having a problem importing xml data in FileMaker 11. This problem does not exist in FileMaker 10. Here's the scenario. I have a table of 2000 records. Each record has a corresponding xml file that is stored on a network share. I have a script that iterates through each record in the table. The script imports data from the records corresponding xml file and continues on to the next record. I am specifying the the file name and location based on a calculation. For example: "filewin://server/sharename/folder/" & table::field & ".xml". In FileMaker 10, this works just fine. In FileMaker 11, the path to the xml file gets mangled. It's adding the l…

I need to export a repeated field into Excel. The export will only pass the first value when 'Excel' is chosen as the file format. CSV or tab delimited would be ok too as they can be opened in Excel. The repeated field will export, but when opened in Excel, it opens with all values in a single cell. Is there any way to export a repeated field so that each value in the repeated field has its own cell when the file is opened in Excel?

Dear all, I am new to this and busy for a school project. Recently i started my last internship by a company, i have to do an assessment to pass my last year of school. The assessment is depending on the project i am working for. The company wants a filemakerpro application that gets user information (and rights/groups) that stores into the Filemaker Database. I already made an database for what properties i want, made tables for users, groups, citrixrights and normal rights. Another table to save the current and an history table what the user had before there where changes. I already know which query's i have to use. But my only problem for now, …

Hi I am trying to export some records to a CSV format to upload some bulk payments to my bank. They however dont seem to allow quotes in the CSV format. Is there any easy way to get rid of these without going through each record and deleting individually. I am using filemaker 11 Thanks for any help

Hi, I'm wondering if I can change the grammar of Filemaker's XML output to something other than the options available. By either changing a standard DTD or maybe creating a third. I should rework the whole system as it is barely functional, but I'm currently in a situation where I won't possibly have the time to start on something like this.

Hi, I'm a newbie with FMP, and a newbie with AppleScript. I want to automate the importation of a bunch of XML data files already in format, with an AppleScript script (unless someone has a better idea?) I have 5 databases (tables) and each of my customers have 5 XML files, containing a record for each of the 5 database tables. I'd like to prompt for a customer name, then go to a folder that contains that customer's data, and extract the 5 XML file under that customer's folder and import them into the databases. Can I do this with an AppleScript script? Maybe something like this? tell application "FileMaker Pro" tell database "dbase1" …

I have a nice report that shows revenue broken out by revenue code: Meals $1,289.00 TV $42.00 Internet $80.00 etc. The totals are calculated using a Summary field which adds up all the revenue for each revenue code. What I want to do is grab the total for each of the different lines and move it into a variable. I am using the GetSummary(Revenue;RevenueCode) calculation. It works fine for the first line but it does not appear possible to go to the next line to extract the $42.00 amount. I just keep on getting the first value. I suspect that even though I do not have the details showing, just the summaries, that behind the scen…

Dear All, I am working on file in which for "export field contents"Script step i have given hardcoded path in Path which is stored in variable. Problem is come when i export the field contents and its save data in Filemaker folder where filemaker is installed . Is there anyway to find out location of your export field content data .means where your export content is save? For example i use 1 variable name $Path and give my hardcoded path into that variable and in "Export field content" Script step i have given that $Path variable in Path of Export filed content script step..Now is there anyway of finding out where that Export field content is…

I've got a Filemaker Client robot running that automatically maintains a number of files consolidated from several disparate systems on different servers. The files contain a number of tables, and some of these have a hundred or more fields - they are updated on a nightly basis. I'm looking for an efficient way of being able to create shadow copies of these files into an identical data structure on another Filemaker client. The shadow copies will have identical table structures and relationships, so the user on the local client can do 'what if' scenarios without jeopardising the original data. I can't use import/export as there is no common shared volume availa…

Oh how I love migrations (not). I have a field with several repetitions which holds a number in many of the reps which signifies the account. So Rep 1 might hold $25 indicating Acct 100, rep 3 might hold $50 indicating Acct 300 and so forth. I want to import these reps and split them into records. But, as you will see by the simple attached file, the logic of how FM chooses whether to create a record or not is worthless. I want each repetition to create a record even if it is empty. It appears that FM always creates a record from the first rep (seeing it as the field) and then only creates records from the remaining if they have a value. This doesn't help me at…

Hi, If anyone knows how i can extract the entire content (not source code) of a web viewer, using a script. I have tried, >>select object (this being the webviewer with an object name 'browser') >>select all >>copy >>past into field. For some reason the 'select all' command doesn't work. Please help Thanks

So I have an FM database of products. I export this database to an SQL file and import it into my backend via phpMyAdmin at my web host. At a certain number of records, I started running into problems. phpMyAdmin was timing out when I tried to import my file. Eventually I solved this issue by splitting the file into 2 files. So now I am looking for a quick and easy way to export a found set in 2 groups, to 2 separate files. I can think of a bunch of ways to do this but they all involve flagging groups of records, doing separate finds, etc... isn't there instead some way to simply manipulate the found set to get this to work? Teach me, gurus! :

Hi I am designing a database which weill export a list of companies to be exported via XML as a web page. I have the following code at the top of the xsl sheet for my record export: xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> method="html" encoding="UTF-8" version="1.0" omit-xml-declaration="no" media-type="text/html" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" indent="yes"/> The annoying thing is I get the fol…

I have a custom date field that formats dates to 'Month Year'. When I export records to other colleagues that have an identical runtime of my database and they import the records, that date field displays a'?'. I think the issue is that when I export records the date field exports the custom format 'Month Year' and not DD/MM/YYYY which is what is actually entered into the date field in the first place. I would like to keep the date field within my database and the runtimes as the same format. I could get round the problem by changing the date field to a text field but don't think this to be good practice. Are there any other options? I don't know why FM exports the custom…

First off... I'm pretty much a noob at FileMaker. I have actually tried searching for this answer, however my search queries are giving me anything but what I'm looking for. I have a layout setup. It contains 3 fields and then a portal with another 10 fields. The only reason for this layout is to export to Excel the specific fields which need to be exported. This is done 100's of times a day in our office. Right now I have everything exporting. Data is fine. All I'm doing is hitting Save as Excel. Because the rest of the people in the office aren't computer savvy, I would like to make this as simple-stupid as possible for them as well and just have them…

Does anyone know a good way to open a REFERENCED PICTURE? A referenced FILE can be opened with a double click, but i prefer to use a referenced PICTURE so as to have a preview of the first page of the pdf file. Note, the field will always contain a pdf document. Perhaps there is a script step to open a referenced document whether it be a file, a picture or even a quicktime. Thanks!

Hi, We need to extract data from FileMaker version 6 system used by one of our customers. I am completely new to FileMaker, and the customer doesn't have immediate resource to help with this legacy system. Can someone tell me how to set up a connection to it? where can I get an odbc driver for windows? We are using SQL Server/Windows platform. Thanks a lot

I want to export a csv file for use in another program - Prestashop. The best format is a csv file with semicolon ( ; ) field separators and no quotes around the fields. After perusing previous discussions I think the best solution would be an XML export. I have downloaded the Plain_PC.xls to use with xml export but this produces comma delimited fields. This would be okay except I need commas as multiple value separators Hoping someone will know how to modify this file so that it produces an export file with ; delimiters

HI currently I am working on FM6 project I need to respecify some of the field mappings in the FM6. But I dont know how to get the field mapping dialog in FM6, where I can just specify the new field mapping and it should get saved. I tired to run the import script in debugger (Perform without dialog checkbox off, for an import script)....It did gave me the mapping dialog, I changed the field mapping there in the debug mode but it didnt saved the mapping the next time I run

Hi, I'm a newbie whose been using File Maker Pro 11 for about two or three months. Overall, everything has been going really well, except for this one rather large problem. I would really appreciate anyone’s help on the subject and thank you in advance for your time. Also, I apologize if this post is rather long. I’ve just started using FMP as a means of organizing a private photography collection and, as all of my work from the past 6 months is in excel, I'm beginning to move it over to the new database. The numerical system the collection uses to differentiate one photograph from another is year.number of pieces bought that year. So, 2010.0001 is the first …

Hello, I have a database which is consist of about 10.000 records. I want to export all data of a text field which will be indexed alphabetically. For example: First record of x field contains "The bog turtle is a semiaquatic turtle" And secord record "It is the smallest North American turtle" Now i want to export this data like: a American bog is It North semiaquatic smallest the turtle Thank you for your help Paco

Hi there, I want to export an excel file to an FTP site in a script, but I want to be able to login automatically. what is the best way to do this? Also I know I can use the open Url script step or set Web Viewer to open a URL site, how can I log in automatically without having to prompt users for username and password each time? can I paste the username and password in the fields automatically and automatically login? Thanks

Hi, I have files with the following naming conventions publication_image2_2691_1282649039.jpg where 2691 matches a field in the database. Is there a way to match these on import, so that they are associated with the right record? Or do I have to import into another table and create a relationship over a truncated calulation field? Thank you for your help... Cheers Lars

I am developing a database that involves a lot of photography. In order to keep the file size manageable these photographs will be referenced images as opposed to imbedded images. My general protocol for photography is to back up images on three different hard drives that are stored in different locations. I would like to do the same with this database. I am confused about how to maintain the filepath link between database and referenced images. If I were to create a folder that contained the database and referenced images, then copied that folder from hard drive to hard drive, would the the filepath links stay connected? I don't know much about …

Hello, I'm developing on Windows but my boss and a few users are using a Mac. I can't find clear information. In FM scripts in the Export Records function. Is it possible to write a path to a network location that will work for a Mac exporting ans XLS file ? On Windows it works with: filewin://computerName/shareName/directoryName/fileName But on a Mac ?

Hello, I am a novice user of Filemaker Pro 11. I am using Filemaker as a database which is shared by some people. We are now planning to move everything (records) to a new Siebel database. I was wondering, is there an API or some way by which we can still keep working on Filemaker and just add an option to upload or transfer contents to the new Siebel database regularly. The reason I am asking this is because everyone of us is very comfortable with Filemaker and it has a lot of records from until last 4 years. It will be great if there is a way we can retain our old database and records and also move to the new Siebel database, making the move transpa…

I have my invoice_order information all set and now i have decided to incorporate a quote that is setup like my invoices that i give to customers. My invoice items i would like to duplicate it and turn it into a quote system with in the same fields and link it to my customer_info. When i open define database and click on tables it doesnt allow me to duplicate a table. Is there a way to do this? or any other suggestions would be great. Thanks Jay. I am using fm pro 8.5

Desired result - Greatly speed up import of records in XML format from a url. Currently - Importing records 10 @ a time from each XML response.... slow Concept - import XML instead into a text field with continual rewriting and importing records at the end all at 1 time. Problem is I'm not coming up with a solution on how to do this........ Any ideas?: PS - headed to bed but will check in first thing. THANKS !!

Here's my situation. I've got two databases dealing with audios. #1 has a list of every recording in the catalog with each recording in an individual record. #2 is a list of songs and authors. What I'm needing to do is import the list of available recordings of a specific song (found records in the #1 database) into a single record's repeating fields in database #2. The resulting record will be a unique song with the various recordings imported into repeating fields. Also another fly in the ointment is that each song title in #1 isn't going to be identical since there may be other info appended to the song title, such as track or album info. So doi…

How can I paste RTF formatted text as I have in Text-edit? If I simply paste it it keeps the font type but everything else is lost .... tabs spacing and so on. I need to keep it as it is. However it seems impossible Any Hints from this great community?

Does FileMaker Pro require an XML data file to always end in ".xml" in an import? I have an XML file that was generated from another program. This program is an in-house company program. It's a real XML data file with all the proper XML formatting, but this file does not end in ".xml", it always ends in ".hfg". That's the only hang up. Platform is both Win and Mac, and there are thousands of files in our archive that we have in this format. We also create new ones. I don't want to use a Third Party plug-in, and changing the file names just isn't practical. Is there a way to get FileMaker to import these XML files that do not actually end in ".xml" in the fi…

I am hoping someone can point me in the right direction. There are two versions of this database. One is the master list which a manager has. The other is a satellite database which is used by other employees. They all add new records then export 2 tables to then be merged to the master list. The master list exports 5 tables for the satellite users to then import once updated. I need to find a way to combine all the info into one table or one file that can be emailed back and forth. Dealing with multiple files is a bit too much to ask. Do you have any ideas about how I can combine multiple tables? I am using Filemaker Pro Advanced, all copies will be s…

Hello Everone: I made a script for importing data into the database from ZenCart. I am using "Update matching records in Found Set" checked and with "Add remaining data as new records" checked in the Import Field Mapping. I am using using the customerID (=) as the match. When I import I receive new data in no problem but on the first match (previous customer) it duplicates the customers data within the database but if there is a second customer previous customer in the import it doesn't duplicate the data. Any ideas what I am doing wrong? Sincerely, Bryan www.bgsales.com

Well I thought I'd seen about everyway to incorrectly use a database program,but this latest one really threw me. Customers been using FM5 for years, says he's doing all his invoicing on it, so should not be a problem for us to get him started and maintain his costing history. I was looking forward to a conversion without having to piece together info from 75 different Excel sheets. But then I get the data. I noticed it was one fp5 file in the folder, and an accounts folder, but during the initial copy it stated 17,000 files being copied. Started getting nervous. Seems that their Invoice data base had only two records in it, no line items, just repeating field…

I'm exporting a file maker record into a csv file and then reading the data in my php code. The problem: it exports records' fields data without any delimiter so my array from the csv will just be an appended string. how can I export my file maker records with a proper delimiter? Please help is totally appreciated as I'm running on a deadline. Thank you all!

I have a csv file that could have any number of columns (fields) 300 or more, but it will always have just three records. this is an export of a survey. the first record is the first line of the question the 2nd record is the 2nd line of the question and the 3rd record is the answer. I want to import this csv file and turn each of the columns into one record in my DB that is three fields. Is there anything that will rotate the csv file and allow me to import it or do I have to have a temp table with hundreds of fields and this script it from there? I think the term for this is transpose? I see that I can do it in excel but is there a way to script this for multiple f…

Hi all ... I would like to import some Safari Pages into Filemaker Is there a way to do so? I set field as Contaners but I am unable to import anything and If I print as PDF the same result ... nothing. Is there a plug-in or some other way to get the page as it appears in saferi Thanks

Hi, is there any way to update imported data? i migrated a bunch data to my new database and started adding new records, but just found out that there are mismatched repeating fields during the migration, so i need to update the imported data.. i chose to split the repeating fields into individual fields.. and now i just need to update some of the fields in the repeating fields. i tried the two options "update existing records in found set" and "update matching records in found set" but neither of it worked.. Instead of migrating the whole thing again, is there any other way to just update the imported data? thank you!

I am trying to import some stock quotes from a webservice into a table using XML. I've created a table with the same structure as the data being imported and created an XSL stylesheet (that does not give any errors), but when I import it, I get no data imported and no errors? Here is the URL that I am using to import the XML data from. http://www.webservicex.net/stockquote.asmx/GetQuote?symbol=MSFT This should return the Microsoft stock quote data in XML format. If you need to see the XSL stylesheet, I'll be happy to post.

Hello there, I've just registered for the site and looked around a bit to see if I could find anything pertaining to my circumstance, but haven't located an answer yet, so I wanted to make this post. We have an oooold iMac (G3) which is running OS 8.6 and FileMaker Pro 4.1v1 (the rest of our office is entirely a Microsoft shop) We have some years' worth of old records still stored in FileMaker on that box, though it is not in active use. The machine now exists as an archive, essentially, and is only accessed once in a while, to look up and print out some old records (though it is always on). For the past 7 years or so, we've used an in-ho…

Hi, I am totally ignorant regarding XML/XSL/XSD, and I am trying to import (create a new table from) XML into FileMaker for the first time. I have an XML file (containing data), and an XSD file (apparently containing the potential fields for the XML data file). I do not have an XSL file. When I try to import the XML file by itself, I get the error, "XML/XSL information is not enough to proceed with import/export." FMP11 gives an option to work from an associated XSL file, but I do not have one. What can I do? Is there a way to use the XSD file to create a blank table in FileMaker? Is there a way for someone as ignorant as myself to use t…

I need to pull data from my FMServer to a FMSolution. Since FileMaker cripples importing from any FileMaker sources I figured I could use XML via HTTP. I have a local file and table and a clone of the same file and table on the server. All security is set. I can use safari to browse to the url of... "http://192.168.1.1/fmi/xml/FMPXMLRESULT.xml?-db=timeattend.fp7&-lay=xml&-findall" The result all looks XMLish to me. However..... I made a script with the step of: Import Records [http://192.168.1.1/fmi/xml/FMPXMLRESULT.xml?-db=timeattend.fp7&-lay=xml&-findall] But when I go to specify import order, I get XML parsin…

Hi! I imported a Excel spreadsheet into FileMaker, without setting it up automatically, and now, to make life more easier for people who will enter data into the database when I will be gone, I would like to set it up automatically with that same Excel spreadsheet. I've been trying to figure it out the entire day, but I can't find how. Does any one know or have a tip about how to do it? Because I don't really want to have to re-import the Excel spreadsheet into FM, otherwise I would have to start all over again my reports, charts, and layout, which will be quite long, considering that I only have 2 days left.

I don't have the actual database file so i want to import using the http request function. I don't know where I'd find that address on my site. any help please?

I found a script that reminds me to backup our database every two days. One of the script steps is Save a Copy as It works great, my question, is there a way to have the current date automatically appended to the copy to be saved, so we do not have to type it in each time? Thank you M. Logan

Hello all, I am currently trying to save records with a naming system. I am able to achieve this on my desktop (having already set the $filename variable) using Set Variable [$fullpath; Value: Get(DesktopPath) & $filename] however I need to save this file on a remote volume. In the Set Variable script's Value field, I've tried substituting the Get function for filemac:/Volume/Folder But I am told that is not a table and cannot proceed. I have also tried substituting Volume for the Server's IP address and surrounding this part of the function with apostrophies. I am sure that the answer is shockingly simple, however my scripting/programming…

Hi, I have an excel sheet with a column containing hyperlinks. How can I import it into FM that it creates a field where the links are working ? Now when I import the file, it only imports the text (name of the link) and not the http//.... Thanks!

Hi I am a relative newcomer to FileMaker so I would greatly appreciate any advice with regard to my problem. Basically, I have a layout which includes details for machines in my inventory, such as make, model, age, etc. One such detail is Purchase Price. I deal with customers across the world so the Purchase Price may be in USD, CAD, EUR, GBP, or JPY (I have a Purchase Price Currency field from which I can select the appropriate currency from a value list.) I also have a Purchase Price in USD field, which converts the Purchase Price to USD, depending on the Purchase Price Currency I select (the field references fields where I input the exchange rate manual…

What would it take to be able to export a single record or a group of records (today's date) to a new .xls file. If there is a way can you use a specific field to name the file? Script- Find Records/Export/....?

I'm in advertising and I wrote a database to track what products fell on which pages of a book. I have my employees generate an XML report that contains the Job Number, the Page Number and the SKU's. I import that into FileMaker and now I can see where specific SKU's end up. Later, my customer makes changes and moves SKU's around. I have my employees generate a new XML report, which I import. As you can imagine, I'm creating a lot of dupes, not to mention disrupting my data integrity. I need a way of importing the XML and having FileMaker keep only the newest set of records for any given page. I'm thinking of a few ways to do it, but they feel a bit clunky...I w…

Hi, when I import records from one table to another one, I got a summary dialog with information like "xxx records skipped due to errors" I just wonder what kind of errors would that be? I'm migrating data about babies and households from an old database to the new design that I'm working on. When I was migrating data from tblBabies to tblHouseholds in order to match babies with households, I got this msg with the number of errors. I think my algorithm works fine for the matching. Basically I'm taking a single copy of the household info from the siblings' records and match that with all the siblings' records. Maybe anybody can tell me what the general errors wou…

Hi, I have a script that calls for a FileMaker Pro data file to be imported. This file can be located anywhere and the file name changes. Thus, I can't have my script look for a specific path or file name. I simply have a box pop-up where the user (many different people) can select the exact file to import. However, I noticed that in FileMaker Pro advanced 11.0v2, when the dialog box opens to ask for the file, the default file type under the "Show" will always be "Tab-Separated Text Files". The file type I'm importing is a FileMaker Pro file, and thus, this has to be changed each time from "Tab-Separated Text Files" to "FileMaker Pro Files" next to the "Sho…

I am very new to FM and have what may seem like an easy problem. I have 2 databases one local the other remote, exactly the same fields. The remote is based in the UK the local in Australia. I wish to incorporate the UK database onto the Australian server, what is the easiest way to do this? I have tried incorporating the UK and Australian databases into the one, with the UK database distinguished, eg clients and clients UK but I cannot see the UK client. Will I need to write a new script to open these fields or would it be easier to just import the remote into the local field with no distingushing.

I have the middle steps of my script worked out in doing sub-scripts. Where my problem is: I want to start the script with opening Import in a specific directory where the USER can select the file to be import. It is the mapped network drive J: When the file is selected I want it to immediately do all the steps I have worked out. The last step is giving me a headache, but I do feel it is a little easier to do. The results derived by the intermediate script steps is to create an export file that needs to have a specific name and save to a different directory. I can create the file name with a calculation: pospayMMDDYY.txt (tab-separated) and saved in …

FM11Adv Mac 10.6.4 I have calc(s) that returns data suitably html encoded , and saves a page as a .html file. Basically it is a page generator. Export a single field contents is used to create a text file with a .html extension All works except for some weirdness seemingly buried and invisible in the doc declaration. A simple standard skeletal XHTML 1.1 page code, copied straight out of SEEdit, and pasted into a global, then using export field contents, mutates the code such that validator thinks it might be 1.0 and at times (in testing variations) that it needs a title It is something to do with the first line of the doc dec, the string is 38 charact…

Hi, I have an email script to email an image of a vehicle. Everything works fine, but it stores a copy of the file in the folder the DB is located in, which could fill up quickly. Is there a way to have a global container that can store the image each time one is mailed and be overwritten each time? Below is what I currently use The name of the variable is:$_document_temp Let( [ file_name =Vehicles::Image_1; full_path = $$_document_path & file_name ]; full_path ) Thanks, Jim

Hopefully this is the correct place for this question: I'm working on a database, and need to find a locktight way to manage audio files while making them playable in filemaker. My core problem is this: The end database user isn't capable of file management, making referenced container fields meaningless, since the references will arbitrarily be changed on a whim. Filepath integrity is basically not possible. I want a container field that can hold an audio file (yeah, within the database: I will take the performance hit to prevent endless end-user problems), and play it too. Filemaker doesn't allow for this to the best of my knowledge. Is there a way? Perha…

I just started working with FileMaker 11, so I'm still trying to figure out the proper technique for many things... The DB: I'm working on a application/interview database. The main table contains applicant info and the other table contains interview data. Problem 1: Interview data will be populated into an excel template. Having these users direct input into FileMaker is not an option. When I import an interview, the foreign key to tie the interview to an applicant does not populate. I set up the field as lookup based on an auto-entry serial number field in the applicant table. Problem 2: To work around the issue above, I thought I could export data from …

Ok...here we go... 1) I apologize in advance for my ignorance. 2) I have excel row data with multiple rows but one key "emp_id". (I've attached an example "sample.xls" under "source" tab) 3) I want my source data to look like my data in my "sample.xls" under the "desired" tab when I import into FM. 4) I'm using FM PRO 10 Advanced 5) I'm on a PC 6) I'm pretty decent with DB's and FM. I'm not a walking DB brain but I get what's going on with DB's & FM most of the time. 7) I feel stupid because I can't understand how to get my data to import the way that I want it. 8) Somebody please help. 9) Please be kind; and if there is a post that already exists…

Now I really hope I can explain myself well enough to not confuse anyone. We're needing to export some data of shifts worked by staff as a text file for a payroll software. There are two formats it can be: 1. staffID, rate1, rate2....,rate6, allowance, units, allowance, units etc. 2. A "style" code, staffID, ref, units The first format will have 1 line per staff with all their ordinary hours, public holiday hours, mileage expense etc but needs to have blank fields if there is nothing for the rate fields (e.g. BOB1, 32,,1,,,,) The 2nd may have several lines per staff, 1 each for ordinary hours, public holiday etc I'm thinking the first format …

Hi. I'm developing a database for a collection of algae samples. My issue of the moment involves exporting a join table as an excel spreadsheet. The join table has the following fields: Join Key Sample ID (foreign key from site description) Species name (and foreign key from species list) number of cells/sample I'm trying to export all of the records in the join table into an excel spreadsheet such that each unique sample ID heads a column and each unique species heads a row, with the count value occurring at the site-species intersection. Any help would be really appreciated, N.

I have a script (from FM Starting Point) that will create a backup of my fp7 file. That works as it should. My question is - what is a good way to approach restoration? I am assuming I need to script this where it pulls each table in one by one and matches up the fields... or is there an easier way? Does anyone have an example file of a backup and restore function? I always enjoy seeing others approaches and learning from it.

I have three tables STORES, STORE DATA and SQUARE FOOTAGE. I have a 1:Many relationship between kP_Stores (STORES) and kF_Stores (SQUARE FOOTAGE). I need to import 2000 text files that contain only the store number, store name, department and square footage. What's the easiest/fastest/best way to import those records seeing how they don't contain any foreign keys? I want a portal on a department tab in the STORE DATA layout showing only the square footage of the areas in the department. My thinking thus far has been to import the text files individually via script and ask the user to select the store to fill in the foreign key. Is there a better way?…