Importing & Exporting

I am trying to import from XML using the basic msdso_elem.xslt style sheet I came across. Things work well if all field names remain the same in the XML. I have a script that automatically imports from the URL using that stylesheet. The problem is in mapping fields: One record in the XML contains 20 fields, the last two, desciption1 and description2 my not be on the next record, but description3 and description4 are there instead. I have in my filemaker database, all four of these fields that need to be properly mapped to automatically. My question is what do I need to do change in the stylesheet to propely translate all field names in the xml to to …

Okay, it seems like a small thing. But I have pet peeve about not wanting to leave the Import Log around after we run an import. I think it looks trashy. Is there anything we can do to 1) specify sending it to a system temp folder or 2) suppressing it altogether?

When a PDF file is inserted into container field, using Insert File, the field will show a generic icon together with the name of the file. When a large thumbnail of the PDF file is required for a 'quick look' on the layout, then the PDF is inserted using Insert Picture. My normal approach, erring conservatively in the absence of information, has been to use 2 container fields, one for the Insert File, One Insert Picture for the thumbnail. This does double the data size however; as might be expected. Not an unacceptable issue, but is it avoidable? Curiously if the field content is exported from either the InsertFile or InsertPicture then the resul…

Wish everone a very happy New Year! I thought I could use the holiday break to import a large data file into a live database without a problem. Unfortunately I desperately need a quick help. Hope there are still people around and could tell me how to import 4 names from an Excel spreadsheet into a repeating field. Any help would be much appreciated. -Sal

FM 9 and you still cannot Export as tab with header row ! I see the only solution is to export as excel with header row. Open in excel. Save as tab delimited to get what I want. Merge was close but had to be cleaned of quotes and commas while risking corruption in case the data had a comma. Is there a plugin or something to add that basic feature?

Hi, I have a number of fp7 files which all belong to a single application (it's an inventory and purchasing app). The developer has long since left and my customer wants to "dump" all fields and records (no filtering required) into Excel (.csv or similar format). What is the simplest way of getting the data from these fp7 files into Excel? I am a nube, so please can you help with the basic steps. I have the ODBC driver installed and tried to "pull" data from the fp7 files but the ODBC is asking for some server and port numbers. These are just files, no server is running... Also, if I try to open the fp7 files in filemaker pro, it says sha…

Hi, Is it possible to export a file as the (or with the name) of a field content? If the field content was: Hotwheels the file would be exported as Hotwheels.fp7...and if the field content was Matchbox the file exported would be Matchbox.fp7. I currently export the files to my desktop to be moved later but I can't figure out how to rename based on the field content. Thanks, Jim

I have a need to export the related data of a database. I want to create a "flat" file if you will. I have a Database with Vehicle Information, a connector database, and a parts database. I want to export the Vehicle information, with all the associated parts. What I get is a .tab file with the Vehicle info on the first line with the information for the first part, then all the other parts for the same vehicle have no vehicle info, only the part info. How do I get the vehicle info to export with all the part info. Here is a sample of what I get in the exported file: 2178 ATV Arctic Cat DVX 400 70-812 $352.00 70-822 $394.00 70-592…

Never mind..once again after posting, I went back and read the book, and looked at my script and apparently not following the instructions makes the script not work...then after applying the correct instructions it worked. Amazing how that works out. Hi, Playing around with some importing...I have a file saved to my desktop as a .fp7 file. I have written a scrip to import the data from that file. However when I import I always get a file with just the auto date field entered (no field data) then I get a file with the data from the fields but not the auto date entered field (it is blank). I don't know if the attached image will help? Jim

I have an 810 edi format file that I need to import into filemker pro 8. I have no idea how to do this. I have looked this up everywhere I can think of, but to no avail. Can anyone help. A sample is attached of the 810 file. The filemaker database im importing it into will be built from scratch for this once I know a bit more about the import. Any help would be grand! INVOICE.810.TXT

Hi, I am accessing an ODBC source (from a MySQL database) into my filemaker database. When I go to click through the records I am getting a dialog box with the following message "Find in Progress Processing query". It can last for several minutes before disappearing. Does anyone know how to prevent it? Thanks in advance!

I didn't find this answer in my search, but how do I import a CSV (My monthly user info) into an existing DB? All the fields except 1 are the same, but every 15 days I need to import my staff's work into an existing DB. Thanks!!

I need to export a csv file that needs to be delimited with * instead of """. This will be part of an automated work flow so it would be nice to be able to do this without needing to modify the file with a separate application. For example. A standard FM csv export would look something like this. "123" , "456" , "789" "abc" , "def" , "ghi" I need it to look like this. *123* , *456* , *789* *abc* , *def* , *ghi*

I have lets say 200 documents with hand written content. Every document has a bar code (6 digit number). I want to scan these documents and import them into filemaker. I want filemaker to decode the barcode so that I can match it to a certain record in filemaker. OCR software suggestions?

I'm confused...Have a box with Windows XP and FMP 9 client version with File Sharing turned off as server. There are approximately 4 users. I’ve been trying to set up a script for 1 of the users to import from an XLS. I have not been able to automate the script; as I think it should work. I simply want the user to import an XLS from the same folder on a desktop that has the same name. Works great in a non-server environment. It should work… When the database opens the “set path” script runs: Set variable [$$path;If( PatternCount ( Get ( SystemPlatform ) ; 1 ) ; "filemac:" ; "filewin:" )"] Set variable $$desktop; Get ( DesktopPath )] and then when t…

I have to export about 150.000 records in FM (for further calculations in Arcview and SPSS). I tried several export formats, but I wated for hours before cancelling the process. I guess it will take a few days! Any ideas how to speed up exporting? Do I really have to use another software (MS Access) ______ Some Inormation about the database: about 30 fields, 10 x num 10 x Calculation 1 x summary 10 calc using summary/Break options ________ FM PRO 9 on PC 2GHZ and PB 1,67 with 2GB RAM

I have to separate databases with matching fields. What I'm trying to do is move a record from one database to the other database. I've only figured out two ways to do this and i'm looking for something more efficient that can be incorporated into a script.. 1) Export from one database and import into the other and then delete the record from the original database 2) Export Field contents from one related database table to another. and delete the original record. This is more cumbersome because you have to export each field separately. ... If there a "move record" script step or function i'm missing somewhere? I can link up the tables through …

Hello Everyone, First, I would like to thank you for your time while helping me with this question. My situation is as follows: We currently have an Access database with a query that pulls multiple tables together resulting in the data I would like pulled into FileMaker. On the machines I have created ODBC connections and through FileMaker I am able to import this table into a table already created. I am importing matching fields from an MS Access query into the matching fields in a FileMaker table. This works perfectly on a PC, but when I try to run the script on a MAC I get an error telling me the connection cannot be found. The ODBC connection on t…

I've got a simple database with 6 meta-data fields and one photo field that is referencing photos on the hard drive via the import feature. I would love to be able to do two things. #1, auto-size the photo box based on the orientation of the picture (ie, if I have a 640x480 picture box and a given record contains a portrait oriented photo rather than a landscape one, it should size the box accordingly and move it flush left so that there isn't blank space on both sides. #2, (and maybe this isn't the best way to do this so I'm open to suggestions), Can I add a link to the photo so that it will open the photo in iphoto? Essentially the reason for this is to z…

I have to say I can't thank the users of this forum enough - as a noob, I wouldn't have gotten this far in the development of this database without the helpful feedback I've found here! Kudos aside, I've got an interesting one I'm trying to accomplish, and I don't even know if it's possible. I want to calculate the runtime of a video file and put it into a field. I imagine this would involve reading the metadata in the video file somehow, but I'm not even sure where to start! The only thing I can think of is using an applescript to get the metadata and pass it into a FM field. I've integrated applescript into FM before, so that part's easy. I'll look into a…

Dear All, I'm having a mental block and cannot figure out how to get the data into rows instead of columns. I have subjects that are weighed over time. I would like to export this so I can graph in excel. I would like the data to export like this. Subject 1 Weight (day 1) Weight (day 2) etc. Subject 2 Weight (day 1) Weight (day 2) etc. Any thoughts or advice? Thanks Mike

Is there a way to designate the excel template that the export function sends records to? I have a user that wants me to export data into his prebuilt shell that has specific formatting and formulas already inbedded in the cells. thanks

I have a form that I used in Microsoft Word, using it's "Form" feature. Is there any way I can suck that information into FM, using the Form field names linked to the FM field names?

Hi all, I am importing a lot of data from a csv file but cannot work out the best way to do this because of the format of the csv. The external program that creates this csv offers up 2 formats. Basically what I am importing is historic data against stock codes, the views below are how the csv shows in excel with the | being a column divider 1st format offered... Stockcode|01/01/08|02/01/08|03/01/08| 1234567|356|350|359| 7654321|971|950|800| 2nd format offered Stockcode|1234567 01/01/08|356 02/01/08|350 03/01/08|359 Stockcode|7654321 01/01/08|971 02/01/08|950 03/01/08|800 What I need to import is 1 record per s…

Trying to import an .xls file into a fp7 file created for the purpose. Doing what I've always done successfully before (though with different files), I get an error this time This happens as soon as I click Open. It's been a while since I did this, but I seem to recall that, in the past, it went to a screen where I had the option to create a new table to contain the imported data. Any idea what would keep that from happening now? Just upgraded to fp9 advanced, btw.

Hi, I'm trying to transform an XML to a kml. Everything goes well except when I'm trying to use a xpath function. EG: ... Filemaker says "Could not find function: empty()"... What's the problem?

I have an online database (not filemaker) that I can export changes from to excel to sync with my local filemaker database. The problem is that any field of a record that is changed goes to the same column. So there might be three lines in excel for the same person with each of the field changes in the same column. The column has a generic header. Each line has my primary key from my filemaker database so there is a way to link to the filemaker database. Is there a possibility of writing a script to import this data? My filemaker level is beginner. Thank You.

I was searching through the forum and I found information on importing images and manage them with sys path and such. I do wonder how easy it would be to create a browsable folder library that displays in one layout all the photos of the folder and being able to insert in a container field in a different layout or simply drag and drop. Similar to any iPhoto library. Thanks T

I imported a batch of photographs into a database with the file name (numbered @.****.jpg, where @ is a number between 1-5 and * are numbers between 0-9), as a second path. The column was origianlly formated as text, since I did not want filemaker to remove the end digits (rounding off zeros in the decimal places). However, now, filemaker seems to be randomly rounding those numbers up or down, meaning that, for example, the photo labled 5.0140 is now 5.013999999999999 and the photo labeled 5.0141 is now labeled 5.0141000000000002. What is going on here?

I have some very large data files that use a mix of delimiters - generally they look like this: Field1/tField2/tField3;Field4;Field5 Field1/tField2/tField3;Field4;Field5 where "/t"(aka tab) and ";" are the delimiters. with smaller files I could just import them into excel (which allows me to choose multiple delimiter) and export them out. But there are too many entries in these files. I'd be very grateful for any pointers on how to import such a file.

Hi, I'm new here but I hope to learn a lot of FMP 9.0. I'm a tech guy for a local company and we've just acquired a massive database of around 10 million records. The file size in raw data is around 10GB, so it's pretty huge. I'm very familiar with MS SQL and MS Access BUT Access can only hold up to 2GB file sizes, so I had no choice but to go for FMP 9.0 since there's no file size limit. I tested a database of around 31,000 records by simply creating a table, importing the CSV file into the table (matching the field names, etc). It imports correctly BUT I cannot see the actual data (information). On the left side of my table it states: Total 31625. I can click on th…

Relinking 1000s of pdfs. I'm setting the container field to the path (filename is recordID.) However, some files are missing. How will I know? I don't want to test by using Go to Field (Select), with a looping script, because that'll potentially open the all the valid pdfs. Is there a way to check whether a referenced path is valid without opening the file? Please, comment, tell me the obvious answer, lol.

Hello, I'm trying to create what is effectively an auto-update feature. Currently, the user has to click a button that then takes them to a website, download a file, then click another button and select the file. The file is then imported without a dialogue, as none of the fields will change etc. What I'd like to do is get Filemaker to import directly from the file hosted online. Is this possible? Thanks. B)

I have a file on a fm9 server. When I'm the only one using the file I'm trying to do a Copy file as and it's grayed out so I can't do it. Any idea why?

I have a single table database. I want to make it relational. To start I want to copy all the records from table A into table B. In the table tab I can copy and paste and end up with a second table identical to the first with all the same fileds but no data. I want to duplicate the data as well. I don't know how to do that. After that I'll massage each one to make it relational. Bottom line I want, at first, two identical tables within my one database. Ideas?

Hello all, whats the best way to have a smooth transition between different versions of solutions? I am closed to finished with one of my solutions, it should become a stand alone application with export and import function. I would expect a simple transition function for users, one file for simple import and export. My solution has lots of tables and portals connecting the whole thing. The optimum would be like on OSX a separate data file from the application so no matter what future updates will happen all the data stays compatible to the solution. What are the best solutions there or is something like on OSX possible with FM? Thanks

Hi one and all, I have a script which is set to save a set of records as a PDF. Second part of this script then hunts another table for all related records and appends the original PDF and then sends it as an email attachment. Problem:- if trying to use this feature via Citrix all users regardless of account/privelege set settings(all useres have read write access to the folder in question)get the following error. "Filename.pdf" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. Have tracked the problem to the append part of the script, in Citrix land it just does not want to allow y…

Anyone know how I can save to PDF in instant web publishing? Is there a plugin for this that I can utilize?

Is there any way to import just one record from one filemaker file (that contains multiple records) into another filemaker file? in the import records menu i don't see any option to not import every record from the other filemaker file. Or is there any way to import all records except duplicates? is there any way to get filemaker to skip any records that have the same data in, say, the first and last name fields, but only import the records that are unique in these fields? If anyone knew the answer to either question, my life would become much easier. Thanks.

Hello Has anyone set up either a Word or Excel document that links to a Filemaker database (through ODBC)to retrieve specific data for the document? I have the ODBC connection set up for this, but my issue lies with linking certain cells in Excel to the Filemaker database. I would like to create an Excel document with some hard-coded text and with certain cells pointing to Filemaker to retrieve data from the database. I know I can query data from Excel and dump it into a spreadsheet, but I don't want to do this. Any ideas? Joe

I have a script that sets a variable $Filename Value: Get(DesktopPath) & "xxxfilename" When I export data with the output file path as $Filename it works fine on a Mac but returns an error on a PC (XP Pro) saying: "xxxfilename" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk" When I export the file as normal it creates the file on the disk as expected. I am not hung up on using the desktop as the save location. Essentially I want to save a file with a variable filename and then attach it as an email that will work under any OS. Help would be greatly appreciated.

Is there a workaround for this problem? One of the things I like about scripted importing is the ability to ability to prepare my field matches. One of the things I don't like is that I apparently can't save the set and do the actual import later. I often find after I've spent 30 minutes preparing a complex match up there's some detail I need to check elsewhere. I'd dearly love to save the set, exit, find my detail, come back tomorrow or whatever. The only workaround I've found is to select only one record to import, allow the import so I can save the set in progress, delete the imported record, do my research and then come back to working the matchup scri…

Hi there! I have received an .fp5 database containing loads of images. Since I do not have a version below FM 8.5, it has now been converted to .fp7. The pictures need to be used in a book (the database was provided to me by the author). According to the author, he entered the images in high quality jpg-format. However, when I now try to export the images to work on (scripted), I am encountering some problems. - When I add no file extension to the pic name, the file type is not recognized. - When I add a .jpg-extension, the file can be opened in Preview but not in Adobe Photoshop (error: unknown or invalid JPEG marker is found). Similar errors with extens…

Hi all, Is there a way i can link a folder to a container field and not just a file? Thank you very much for your help Paul

Hello, One of my clients is having a very mysterious problem with only one their PC workstations. All other PC workstations work correctly and do not have the problem. All PC workstations, including the one that has the problem, use the same version of Windows XP and FileMaker 8.5v2. They all use the same access privileges and connect to the same FileMaker Server hosted files. The problem on the one PC: FileMaker is unable to create a PDF of a layout via a script attached to a button. The location where the PDF is supposed to be created is: "C:/Documents and Settings/All Users/Desktop/". After the PDF is created, it is supposed to be attached to an emai…

I am having a problem pasting pictures into a container file. It freezes up FM does it sometime either inserting picture or pasting picture. Have used FM 5 for 5 years and did not have this problem now on FM 9 and it is very erratic. Pictures are downsized to where they are not high amount of resolution.

Hi, I have a requirement to import data from a variable number of spreadsheets which follow a naming convention but the number of files vary from project to project. i.e. In one project there may be 6 files from one section of samples: BP1-TP1 to BP1-TP6, followed by five samples in the next set BP2-TP1 to BP2-TP5 and further ones from different borrow pits. Is there a way to automate the import for however many files there may be.

I have a very long list of field names to define in a new table. Is it possible to import a text file and have FMP9 define the fields automatically? At the moment there are returns separating the field names. Haven't found a way as yet.

Hi All, I am running FM 4. I have number field showing properly on the FM layouts, but when I export I get raw data. Example: The layout show $10.00, when I export to merge file, (merging to Word 2003)I see "10". Likewise I have a Interest Rate field shows 15% in FM layout, but exports as .15 I have a currency that show $ 15.12 in FM, but exports as 15.37158176875. Is there a way to format the data so when I merge to the word doc it is formatted properly. Thanks for any and all help. Dave

Hi everyone, I am trying to import records from an excel file. Initially I created a template file to import from. I matched up the fields and it imported the file and filled in the 48 fields. This process caused some problems because when a file came in, it needed to be renamed to the template and then the import script would find it. It then needed to be saved with it's original name into the proper folder. To make the process better I created a script where a variable is set to find the file in it's original name in the intended folder. The variable worked and it finds the folder, but instead of importing one record and filling in 48 fields, it imports …

My database contains a container field which is used to store images. How can I move these images to a newer version of the solution along with the rest of the data. The export and import functions only seem to work with text-based data.

I'm trying to export multpile credit card transactions into an XML. This is the preferred format of the credit card processing company I'm using. Here is the link to the Schema they want for each record: https://www.sagepayments.net/virtualterminal/vterm/bc_xml_schema.xml 1. The tech support tell ,me that filemaker MUST export in this exact format. 2. I asked the tech person about an XSLT style sheet and he had no idea what I was talking about. My queston is: does anyone know if I can get the above schema into an .XSL file so I can tell FMP how I want the data presented. Or can anyone tell me how to change the headers of the XML data exported fr…

Hi Please can anyone give me any advice on this. Firstly I am working in Windows. I have a field in my database called filetext This is a calculation. For ease of explanation I have cut this right down so imagine the calculation is filetext="Line1¶Line2" In FileMaker this shows fine as... Line1 Line2 I then export this to a .req file (basically a text file). I have tried all sorts of different combinations of exporting options such as exporting as a tab delimited file, exporting as a csv file etc I am outputting the character set as Windows(ANSI) and have tried it with applying current layouts data formatting tick box checked and unchecked.…

I am building a database of code snippets I use in ecommerce development. I copy them into a FMP text field for storage. When I need one I copy it from FMP and paste it into a file on an Apache server. UNIX formatted text is pasted into FMP but something else is coming out when it's copied. I'm using BBEdit for the copy-paste. I'd like to format the FMP endlines for UNIX in these text containers. Anyone know how to do that?

I want to create a routine that when pressing a button it automaticaly saves the layout as a PDF and automaticaly sends it to a especific adress. I cant find a automatic way to do it since or I use the Save as PDF thing and atach to a email but i cant edit the email, or i Use the Send Email but cant automaticaly save a layout and atach to it, the atachement needs to be done manualy.... Is there a way out?

I'm trying to export data to excel. Every time I do this, FileMaker freezes up and I have to force quit. It has never done this before. It lets me export and save as a mer file. It even freezes when I do the save as function. Does anyone have any ideas about why FM is stalling when I try to export to Excel? Thanks much! Michelle

Im trying to create a script that will import a certain file everyweek. My problem is that everyweek my file has a different Name Range. The namerange in an excel sheet is on the bottom left of the screen. So im trying to figure out a way to tell filemaker to disregard the name range when importing a certain file. is there a way to do this? what else can i do? Thanks

When scripting an import of a file is it possible to specify a file path in a global field? Same question for the file name. Thanks

Looking for some guidance on migrating data out of Maximizer, preparing it for import into FMP9. The tab-delimited text files the client supplied have data running all over the place. It has the appearance of repeating fields dumped into succeeding records. Actually much messier than that. Given the situation I will probably be visiting the client soon to see just what's going on and attempt to discover how Maximizer exports its data. I'm hoping I can gain some guidance in advance of that visit. Appreciated.

I've read a few threads on this site that talk about the difficulty of setting up import mapping. Well, it's more like ranting. Nobody, however, has addressed how to make it easier. When mapping fields, the target field you move up or down in the order swaps its position with the field that it is replacing. For instance, if I move a field in the 50th position in the target field list to the 2nd position, the field that was #2 is now #50. This is horrendously difficult especially in those cases where most of your fields are off by one or two positions but you have to move some lower down field up. I know I'm not explaining this very well but I expect everyone…

Hi all I have an export script and an import script setup. The database is hosted on FMServer 9 running on Windows Server 2008 At 2am I would like the export script to run At 3am I would like the import script to run Is it possible in FM to set a time for a script to run? It is unlikely that anyone will have the database open on a client at that time but not definite. Thanks

Any way to get Filemaker to tell me the size of an imported image? As in KB or MB? On a separate note, when images are imported into filemaker, where do they live? Thanks, Paul

Everymonth I import an excel file into my FMP 6 database. All of the sudden, this month, it doesn't want to import. Same database. Same excel file. When I click import and click on my file, FMP pauses for a moment and then completely ingnores my import request. Any ideas why? Please help!

Hi- I recently upgraded to FP9 from FP7. The way filemaker handles text formatting has changed. Now when I paste text from elsewhere Filemaker uses the text's format, rather than the default I've specified for the field. Is there a way I can make Filemaker override the text's own formatting by default, without having to remove formatting each time I paste text?

Heres the scenario... I want to have FM open an image file with a photoshop droplet.exe for processing. The Send Event Script seems to only allow opening of a file OR an application. I want both, open a specific file with a specific app. how do I set this up? More background... the container field with FM 8 creates only references to the file or adds the entire file. both options are extremely slow for an image archive. as referenced images take forever to load across a network. especially when I list multiple (5 or more) So I want to set up a Photoshop droplet to accept the file, resize it, copy to clipboard. and finally have FM paste into container,…

Hi all, The company I work for is purchasing FMPro9Advanced. We currently use FMPro6. Our intention is to start a fresh database with FM9 but use only the templates/structure from our existing FM6. We will create new user passwords and new users as needed with the FM9. Can this be done? If so, how? Thanks in advance, Heeter

I have imported data into my table and did not initially use Auto Enter Serial. Now I wish to generate these unique serials, but the records already exist. The PK (serial) field is currently null. Is there an easy way for me to easily generate a unique serial into the PK field? Thank you!

My goal is to clone a database that is currently on our server. What I did was close the database, clone it offline, and reuploaded it to the server. Before uploading it to the server though, I made sure everything was working, including ability to modify fields, change account privileges, etc. However, after uploading it to the server, I lost all of this functionality. Could someone please help me with this? Thx!!!

I am trying to automate using a script, the ability to select photos from an external source such as a digital camera, have the selected image automatically copied to a defined folder on my hard drive, and then show the image in a container as a reference to the file (ie not copying the whole image across to keep the database file size down. Filemaker doesn't seem to have any file management abilities that I can find.

Hi All. I'm just starting with FM and I have a questions regarding the maintenance of the application. When I would develop the next version of my application (a small CRM for a friend) I would take a copy of the running application and then do my development. When finished I have a problem: the running version has different data then the copy I took for developement... My plan: 1) Delete all records in the new version 2) Import all records from the running version into the new version 3) Make the new version the running version Problem: when activating the "import records" function I can select every table in my source database, but I can only select the …

Hi All, Once again I have a problem I need assistance with. I have imported approx 90,000 telephone numbers. Each number is an 8-digit number. Such as 123-4567. I need to add a 02 in front of all numbers. Can this be done without obviously editing each number individually. I need to then export this back out to upload to a thir party client. Regards, Joe

Hi, I know this would be very easy. I tried a bit but not working fine. I have word file stored in container field. What would be a script, to open that file, if I make that container field a button. I think I did that before some time, but how, not remembering now. Hoping for your quick response. Regards, Tusif

Hi All, Bit of a newbie here so apologies if this has been covered before. I would like to have a FM template that I can enter a Ebay item number into. It would then collect all the data of the Ebay auction along with the images and add it to my FM database. Has this been done before? Could some one point me in the right direction? I would be happy to find a coder and pay for this to be done if necessary. Thanks!

I'm importing a tab delimited file that has a mixture of new data, that will create a new new record, and old data, thats matched with existing records based on a unique field, that will update the existing records. But rather then update and more importantly, overwriting the updated data, I want to merge the updated data with the existing data. Is this possible, or am I going to have to create separate records??

I own a third party software program that is built on FM Pro 6.0 V4. FM Server 5.5 is installed on my server. FMP is installed on 11 computers in my office. When I import photographs into the program I can view them on 3 of the computers, but the other 8 say "cannot draw image file XXX.jpg" where XXX is the name of the file. I have done the following: 1) discussed this with the techs at the company which sold me the program 2) discussed this with my very capable IT guy 3) called FM support No one seems to know why three computers can draw the files, but 8 cannot. 1) The techs swear it is not their program's fault 2) the IT guy swears all 11 computers a…

Hi! As seen on the attachment, I've tried to make a value list to disappear after clicking on one of its values, but it stays there, blocking other buttons in the background. I have to click somewhere else in the screen to get rid of the value list. Any hint would be appreciated, as I tried "Set Tab Order..." and other ways with no results. Tnx. Value_List.bmp

Good morning all, I have been asked to move a database from an employee's computer to the server. Currently all of our returns are stored on this employee's computer instead of on the server, meaning that this employee must have his computer on for the rest of the company to access returns. What is the best way to transfer the database intact to our filemaker server? Thanks! -joshua

I have a database that consists of 5 tables. I want to design a script for my end users that will export all records to a specified folder. I tried to accomplish this task and tested out my export script. The first table exported the correct amount of records. The other tables contained the same amount of records as the first table, even though they contained additional records. I know I am missing something simple with this task, I tried the “show all records” at the beginning of the script and that did not work. Any help on this matter would be appreciated. Thank You, Steve

I need to import a certain number of orders every day. The order consists of order number, date, item sku, quantity, price and total. One order can have multiple items in it. What would be the best way to handle imports? Do I create an order table and items table then relate the two and import my data into each table and then display the orders in order table and add a portal to it show all the items or is there a better way? Import is always csv, looking like 1235478,1/1/08,item1,1,5,5 or like this for multiple items 1235478,1/1/08,item1,5,1,item2,10,2,25 Thank you.

I am exporting a tab delimited file from my Mac running FMPA 9.03 to a Windows 2003 server. When I open the file on my Mac I see: 100208 "13334","A" "13217","A" This is exactly what I need it to look like. When I open the same file on a PC with Notepad I see: 100208☐"13334","A"☐"13217","A"☐ (NOTE: I have substituted a different character to show the boxes that I see in the export. I think the actual box in the export is the escape character getting poorly translated.) I have tried changing the encoding of the tab-separated text to all of the options in the export window (Windows ANSI, ASCII DOS, Mac, Unicode 16 and Unicode 8.) Nothing …

My head is mush... I'm out of time and running on no sleep to speak of the last 2 days What I need to do is an import creating new records (50-100 at a time) of those not already in the database. Delema is I have several unique and non empty fields in the main database and the imports only have data in 1 field to start with which throws out all the new imports as "skipped with errors". I end up with only the old matching records left - if any - in the new found set... no new records. After import the records are run through a script to update and fill in all the blanks...

I would like to import a list of images. the suffix of the images decides which field the image should be imported to. if no file exists, leave the field blank and go to another records. thank you for your advice!

I need to be able to export two records from one. Using a calculation field I did the following: export = field1 & "¶" & field2. I then do an export of the field "export". When I attempt to load this file back into FM the return character is not recognized as a record delimiter. Does anyone know of a way to accomplish this? By the way, if I open this file using Wordpad and then save it, and then import it into FM, field1 and field2 are brought in as separate records. Problem is I cannot script the Wordpad part. Thanks everyone for your help!

Hi Everyone, I have a quick question about how to preserve carriage returns in FileMaker's XML Export. I have a XSLT sheet that converts the XML to a XLS file so I can natively open the file in Excel. The problem is that the carriage returns are not being well formed in the XML, so they are just being ignored. I have tries using calcs to export " " in the place of the CR, but that doesn't work either because the XSLT just reads it as data: It just reads it as DATA! Any help would be appreciated.

Hello, I need to scan in about 10,000 barcodes and would like to be able to do this without touching the keyboard. How can I have FileMaker create a new record, enter generic data in 2 fields, go to my target field, wait for input from the scan gun, then repeat the process? I can do the generic data fields entry and create records but can not figure out how to tell FMP to wait for data in a field, wait for the "RETURN" to be entered by the scanner, and then create a new record to continue. I have been using the scan gun in Excel for 4 years and programmed it to go to the next row after entering data so I am familiar with programming keystrokes in the scan gun. …

FileMaker's xDBC manual specifically lists Mail Merges in Microsoft Word as one of the uses for an ODBC link. Has anyone actually tried doing this? It takes an absolutely incredible amount of resources, specifically RAM, if you have any significant number of records. I have a test database with 20 fields and 40 records and it takes minutes to load the field names and even longer to actually import the data. If you double that to 80 records you just might as well forget about it. I am sharing the database using Server Advanced 8v4 on Windows Server 2003. I am trying to import into Word 2003. If I import into Excel it goes just fine. Has anyone actuall…

I use a basic template to document a massive DVD library. I've got about twenty categories in the collection. I add several new titles every day and I've enjoyed how the category field knows all my categories and fills them in automatically based on a few initial keystrokes. Now the auto-fill and the accompanying drop down menu has disappeared! All I get is the "edit..." choice, but the twenty or so categories I've created area all gone. In my list view, all the DVD categories are still there next to each title. I've begun entering the categories again manually with the newest DVDs, but FM is not picking up on my new additions, so even a dozen DVDs all i…

Do magnetic strip card readers simply import/input the data from the card into a selected field? Is it that simple? Any recommendations on a product?

Hi Everyone, The datafile that I was given to work with has returns in it that are showing up in filemaker as ~}crlf} I know I can do a find and replace and take that data out but is there a symbol in filemaker that I can use that will put a return in so the data in this text field will show up properly. This is what it looks like: choral groups 9-12~}crlf}drama productions 9-12~}crlf}stu gov 9-12 class rep~}crlf}NHS 11, 12 VP~}crlf}special olympics 11, 12 This is what it should look like: choral groups 9-12 drama productions 9-12 stu gov 9-12 class rep NHS 11, 12 VP special olympics 11, 12 Suggestions?

Hi out here. New in here. My question: I have over 10000 email addresses in word, they are listed one after another separated by semicolon. I want to import these addresses to a FM data base so each address becomes a record. Will appreciate any help

Hi, Strange this one. I have a file with 17000 records in. I am planning to export records to an identical file off site as a backup. Instead of exporting the whole file (because of size) I am now exporting all the records. This all works fine. The script exports all the fields after sorting them. The problem is importing them into a cloned copy of the same file. The import works but it didn't import the first field. All the other fields came in OK. I went back and manually imported the first field from the file as an update records. This worked fine and took in the info. Next I tried making two export files. Each one with around half the fields in each. Again the e…

I just purchased a zip code+4 database that I want to import into our FileMaker solution. The file has 50 million records, but unfortunately, the import bombs out at 2.9 million records. I am using this file as a lookup table, which will certainly have speed issues with this many records. Has anyone else seen some kind of import limitation? I think the file will be approaching 9 GB when fully imported. I am sure this won't work, but just curious from what others have to say.

Hi, I'm working on a database with student records. Each record has the student name and info-- address, phone #s, etc. The problem is that it was setup so that along with each student, it also has the student's mother, father, grandmother, grandfather, aunt, etc..,, each one of these 'relatives' has unique fields for address, name, etc.. so, DB Fields: student_name mom_name father_name student_address student_address2 student_city mom_address mom_address2 and so on.. What's the easiest way to split this up, while maintaining the relationship- automagically? -- without having to resort to making a script to copy fi…

This one has me scratching my head. In this case my data comes from the UK in the form of an Excel file. The files are most probably generated from a Windows machine. I process the files using FMPro9 on a Mac and then export them as tab separated .txt file with the data formatted as Windows (ANSI). The vendor I send the files to uses Windows machines and has found that this round of files contains a small percentage of records that contain a lower case a with an accent (or perhaps grave). I don't see that character in either the .txt file I exported or in my FMPro file or in the original Excel file. I do see that the afflicted records have what looks like a space characte…

Hello. Am trying to use a script to import an .xls spreadsheet of users (originally from Active Directory) into a 'users' table in a remote FM database. The .xls file is updated daily and sits on the same server as filemaker server advanced does, which is also where the filemaker database I'm importing into lives. The script works great if I run it locally and navigate to the file, but when its set to import from the fmnet:/hostname/filename, it can't locate the file. I then tried to manually import from the fmnet:/hostname/ path and it seems like it can only see filemaker databases, not other file formats. Does anyone know of a way round this, either within filemaker its…

Is it possible to specify a directory in the Import script step, without actually specifying the file? I want the user to run the import script and have the window open to a specific directory, then allow them to choose the file in the directory to import. Thanks for any help!

I have a database in FMPRO9v3 that I want to export to excel. I have shown all records and then exported them. However, when I view the exported list some records are missing. I can see the records in the FMPRO database but they don't show up in the exported excel sheet. I've been away from FMPRO for a while so it may be a senior moment but any thoughts would be greatly appreciated. Thanks

Hello, I have a multiple table FM database on a classified system where I work. I need to move the database, not the data, to the outside world. The database is not classified, but the security folks won't let me move it outside without a security check (an automated system that looks for keywords, etc.) The output needs to be ascii text. I can get ascii text for everything but the layouts. I have many hours invested in my layouts and do not have time to do them again. Is there a way to move the database? I am looking at the Database design report, but it isn't working for me.

Hello people, Im new to FM, however I have been working with PHP/MySQL for a long time building dynamic websites. I have this new job where I need to build a site that uses data stored in a FileMaker DB. After a lot of reading in the last few days, I got as far as buying a dreamweaver plugin called FMstudio, which seems to connect and fetch some data, however the "assistant-like" is slowing me down. So my question is: How can I run SQL queries from PHP against a FileMaker database? (the php and the FM will both be running on the same machine btw) If I could just run select/update/insert and the like queries into FileMaker I would be ru…

Hi all, I am trying FM9Pro. Currently we have FM6. I updated all the DB's from 6 through FM9. Now FM9 is asking for a username/password, whereas FM6 only asked for a password alone. I don't know what to put in as the username. Anything I try gives me a wrong password error. What can I do? Thanks Heeter