Importing & Exporting

Is it possible to export a repeating field in a record to a text file with carriage returns separating each entry? I have tried all of the export options that come with Filemaker Pro 8.0, but none of them can generate this format. They are all based on other formats, and even the .txt export can essentially only do a comma or tab delimited format. What I have is a layout consisting of a field with a two line text header and a list and a repeating field of 96 samples. I need this exported to a text file in a format using carriage returns so that it looks like this: LX100IS Patient List [Accession#, Dilution Factor] 00000001 00000002 00000003 000000…

I am designing a new form and need a method to import a multi value field. For example, I have a field called "Products" that I want to import into. My data set has values such as Product1, Product2, Product3, etc. What is the best method to design the field to allow multiple value import? I want all the product data to be contained in the Product field.

Hello, I am fairly new to FileMaker. I work in the Prop Shop in the Theatre at school. We are using FIleMaker to catalog all of the props we have and put them into an eaiser to find system. One thing we would like to do is take a picture of each prop for its entry in the database. Is there a way I can hook my camera up to my computer, take a picture of the prop, and have the picture immediately upload in filemaker to add information and comments? Or do I have to take all of the pictures and then import all of them into the database and then go back through all of them and add their information. Thank you for any help David Mims

I'm having problems finding duplicates during import. Is there a way of setting up something without having to use a script to mark duplicates? I've tried self relationships and it never seems to do the actual lookup when I do the import even though I select the "Perform..." on import. Any ideas you have would help. Thanks.

Hi, I'm new to the forum and FM8 Adv, I'm sure this question has been answered but I can't find it.. I need to convert old (FM 5) repeating fields in an invoice file so they can be imported into a line items table. Any help would be greatly appreciated. roadrep

Hi Im looking for a way to export a single record in a format that can be attached to an email and I am also looking for a way to export a single record that i can fax. I am working at an electric motor shop. I am using FMP7 to inventory all our motors. People call up and want quotes on motors. I want a way to be able to take the information for that specific motor from my FMP7 database and then export it so i can either attach it to email or fax it to them. I really need to be able to do both. Ive been reading the help files but see nothing and i have been searching these forums and also coming up blank. Please help. Thank You, Jared

Hi is it possible to import customer database from Sage accounting into Filemaker?

Is there a way to put a value in a field such as "=A1+B1" and when it is exported the cell will hold the forumla and cell A1 to cell B1 in the exported Excel worksheet?

I need to export some text fields for use in other systems. Within the text there are words that are italicised or bold. When exporting this to a CSV file the style is lost. I tried the export with layout style option checked but it did not work. Although I have a feeling there is no way round this I am wondering if someone could prove me wrong.

I am importing sales data into my FM6 Invoices DB I have a .XSL stylesheet and I have one small problem I need to import "C12345" into each record Something like C12345 I need this line imported into each record but it is not present in my xml that I am importing. Here is my current .XSL <?xml version='1.0' encoding='UTF-8' ?> 0 Where or how can I add the info I need? Thanks, Craig

Hi. I'm trying to export data from one table to another. Basically i've created a Sold table and a Stock table. When a product has been sold i want the item to be moved into the sold table. Is there a script to do this? Kind Regards Elliot

Hello folks, due to a update of my application, I'm using an update script. Now there are different tables which must be imported into one. I wrote short scripts for each "one-table", which are called by the updatescript. These script do some easy steps: ... Import data ... loop ... set a new field to a key(type of data) value ... end loop ... import data from next table ... set a new field to a key(type of data) value ... end loop ... I expected that FM treats the newly imported data as a current found set and only works in the loop on the current found set. I tested these scipts and they worked fine. Then I tested the co…

I am creating a database that handles clips of acoustic recordings with related information (i.e. source, date, location, etc.). There is one sound file per record. I am working on a MacBook Pro but the database will need to be cross-platform compatable. I cannot find a way to insert the actual sound file into FileMaker. It will only link the sound and if/when the sound is moved, the record loses it. I need to "embed" the sound into the database (as oppose to linking) to ensure maximum movability of the complete database. The sounds are .wav, so Quicktime compatible, but the "insert Quicktime" function does not give me the option to insert the sound directly. He…

Hi - I currently have 2 filemaker pro databases set up. The first one a person manually imports from an ODBC location. The second one a script imports from the first. Recently I decided I wanted to join them together with one script so I could hand the file off to someone and they could get push button results. So the method I chose was to try to have the second file import directly from the ODBC location. When I did this the date that it imported seemed to change format resulting in junk. In the first file the field is set as date and the value will read in automatically in the 20040323 format. In the second file the field is also set as date but it will c…

Hello all, I am new and in dire need of some help. I have a database I made for the company that tracks job applicants and their information. I am trying to import records I work on at home into the main database at work. I will try to explain it the best that I can but I am a complete novice at this. I have multiple tables: Employee Personal Info, Education, References, and Work History. The Education and Reference tables are in portals in the layout. When I export the file into Excel it has all of the information but when I try to import it back the database does not allow me to import all of the fields. The other tables are greyed out... In ret…

I have a client that exports an mdb from Access and throws in on their server and there website reads it updating with new data. I'm wanting to complete my FM solution for them by exporting a file from 8.5 that will do the same... is this possible? mac

Hi, folks. I have a db that is a calendar of events. Events are sorted first by event date, then by category. I have those fields set as sub-summaries. In the export, when I choose to group by those fields, and remove those fields from the export list, the fields don't appear in the exported file. No surprise. When I group by those fields and include those fields in the export list, those fields appear before each record in the exported file. I am hoping the resulting exported file would resemble the print preview in FMP... with the event date field as a header above all event records occuring on that date... As an example, I am getting Thursday, Jan 18 Ente…

Im exporting a single calc field which has info needed for an .ics ical file. Unfortunately I cant work out how to keep the returns so the resulting file info is on its own line. as below BEGIN:VCALENDAR VERSION:2.0 METHOD:PUBLISH BEGIN:VEVENT DTSTART;VALUE=DATE:20070109 DTEND;VALUE=DATE:20070111 SUMMARY:event two2 END:VEVENT BEGIN:VEVENT DTSTART;VALUE=DATE:20070108 DTEND;VALUE=DATE:20070109 SUMMARY:event day END:VEVENT END:VCALENDAR I end up with the resulting lines running together. The calc export field has all the returns. thanks in advance

Hi Is it possible to copy a layout from one FM DB to another? I use FM Adv 8.5 on Win XP. Thanks

I have just recently a problem to export the contents of the fields in a record with the format that being in the layout. When the text is in UPPERCASE and I am sure that the option have been selected, shows in excell all the fields in lowercase. How can I fix this problem? Pascal

Call me silly but does anyone have a xslt to import the ddr into a new database? is this a proven method to recreate a db with corruption? my database has 200+ tables, hundreds of scripts, and many many scripts, I'd hate to start over.

I am having a hard time believing that FMP8 does not have a function to open a file requester on windows. I -must- be missing something. I need a way to open a file requester and drop the path into 1 field and the file name in another field, and to make matters worse, I really would like this functionality to work on PC & Mac Via web server. Come on. For real? Open Dialog box, browse to file, and select it, click ok. thats all I need. can someone please help. :)

I have a new version of my application that I need to distribute to my customers. In the past, I have successfully used these steps to migrate the data from the previous version: 1. Install new version into a temporary directory 2. Launch new version and execute re-login script step to login to new database with full access privileges. 3. Perform a script in the OLD version database that Finds All Records in all tables. The Perform Script step is the only way I know to open the old version database and it does it with full access privileges since that is how I re-logged into the new database. 4. Import records from each corresponding table in the old data…

Is it possible to merge multiple (4) database into one, daily with FMA 8.5 Advance? I know FM has peer to peer networking but I am having troubles with it more here So as an alternative, I am planning on merging the database at the end of the day everyday. Thanks

Hello, My first post, yipee. I would first like to say what a great community and its an honor to be here. I am a Newbie with File Maker, so please go easy on me. My question is: How do I retain formatted text copied from a word document or websites when pasting it into a text field of FileMaker. Thanks

I'm new to filemaker and need to make a script which sends records from one database to another (they are identical in format). Does anyone know how to do this?

Hi Everyone, I'm trying to find an easy/quick way to export a single contact from our FMP contacts database and then import it to our Entourage Address Book. So far, I can search for a single record and export it as a Tab-Delimited file. But when I import it to Entourage, it does not seem to appear in the address book. One thing I noticed is that the defining fields (i.e. work phone, main address, first name) which are usually in the first row, are not in the exported file. It just has the info itself(i.e. 123-123-1234, 123 Cherry St, etc). Any suggestions??? Thanks!

I was wondering if anyone can tell me how to do the following. I have 6 .fm5 files that I want to merge into a single file. All files have the same fields and formatting structures etc. If any other info is needed, just let me know Thanks for any tips :D

I am a real estate appraiser using FM 7.0 to create a database of sales comparables. I have exported sales data from a third party source into an exel file. I check the excel file and all the data is there. However, I am having problem importing the data into my FM program. This is what i have tried and what happens. 1. I created the FM file for the data with the appropriate matching fields. When I try to import the excel file the dialogue box does not find any source fields. 2. If I simply try to open the excel file in FM it opens it but just creates an empty database with F1, F2, F3, etc across the top, even though I specified the first row field label option.…

Greetings & Happy New Year I have several Excel spreadsheets that I want to throw into Filemaker to do some reports and other tasks that would be easier in a database. Is there a way to import the field names or do I have to manually define the fields prior to import? Thanks in advance

I'm trying to import data from one database made with FM Pro 8.5 to another. I created the layouts in the new database and then created the tables. I went to layout mode and to field control setup & assigned the data to display in each field from the new tables. When I go to browse mode, each field still says . When I try to import the data from my earlier database to the new one, it only allows me to select as the target, not the table I created in the new database. Can anyone tell me what I am doing wrong and how to fix this problem? Thanks.

Hey there-- I do hope that I am posting in the appropriate section...I am in the process of developing a database for my company and I intend to include a contacts table. The problem is that we already maintain contacts using Microsoft Outlook. I can't imagine that users are going to be particularly willing to update contacts in two places. Does anyone have any suggestions as to how to sync the two programs? Thanks. -Rebecca

We are using OS X tiger/Postfix as our email sever using IMAP to the client. I would like for Postfix to sync with Filemaker for contacts and calender events on a per user basis. Is there a way to make this happen? or any idea where i would go to investigate such a solution? Scott

What is the best way to dymically build a spreadsheet in Excel based on data in FMP. For example, say I have 3 cells A1, B1, C1 and I want to populate A1 & B1 with values but I want to populate C1 with one of two different forumlas based on the relationship of other data in the database. I can't export the data because certain cells need to have formulas so the user can play with values and see other cells update. This can be done w/Office Automation in other languages, but I am not sure how to best accomplish this in FMP.

Hi, I have a script to import .xls files that previous I have exported from records into FM. The script is simple but it does not work. Go to Layout that.. Import records Go to Layout that I have noticed that when I am trying to specify the imported fields, the saurse fields do not appear. It executed the script once but then it stopped. What can be happened? Pascal Pascal

The project I am working on involves existing data with a serialized stock number that carries meaning. There are two varieties: A1234567 AA123456 The letter(s) refer to the vendor the item came from. I would like to capture just the letters away from numbers. How can this be accomplished? Thanks, Drew

I have a CD containing information that from inspecting the contents has the information stored in a .DB file. The only thing that I was able to sort of open the file with was Word. From that file the only thing that was readable was that it was done with Sybase. I found shareware for trying an ODBC connection ( http://www.actualtechnologies.com/product_sqlserver.php ) but could not get it to work since the files are local and not actually on a server. I tried to use 127.0.0.1 but that did not work. I have no experience (yet) with ODBC. So the question here is what can I do to access the information in this .db file. The solution does not have to involve the us…

Hi, I'm having trouble importing related record. Is there a way to import the record and it's related records in one step? Here's a simple example: A tables named "Houses" can have one or more pictures which are stored in the "housePhotos" table. It is easy to export the house and its photos, but how do I import the house and photos in one step? If it not possible, what is the simpliest way since the person who will import the data is not a computer freak? Thank you

I'm trying to import an excel file(contains product info) into my FM database. I've got 2 tables. Product and Customer. I have already setup the customer table with username_old and username_new fields. So when I'm importing the product info from excel into the product table, I have an auto-enter calc field which will calc the new username based on the old username from the excel file. My problem comes when the calc is not working. Is FM not able to do an auto-calc the same time it is importing the data? I don't know what I'm doing wrong. I have attached a sample file in case my explanation is confusing. import.zip

Hello. I hit upon a snag that I didn't expect when I consolidated a multi file solution into one file. Apparently, Filemaker 8.5 (and prob. 7 and 8) will always import all records regardless of the found set when the source file has more than one window open (or is closed). As this is a single file solution, there will always be at least 2 windows open when I perform an import from another table with a found set. This in effect imports all the records. I am trying to accomplish what used to be a simple thing: Import all line items from the order_lineitems to the invoice_lineitems table. I suppose I can script around it, but I have the feeling that…

I have created a field in my database which designates the name I would like this file saved under. Can I make a script to save a copy of my file with the name I have created in a field? I know I can do a save and specify a specific name, however each day I do the save I want to have a different file name so my previous save is not overwritten. My "name field" is based on current date and a file desognator (IE: Reg12202006)

I need to convert a large number of databases from v6 to v8, and was hoping there was a way to batch convert them, for obvious reasons. I seem to recall v7 shipping with such a tool, but we skipped 7 and have recently upgraded to 8, which appears not to have anything like that. I've searched extensively but can't find anything useful - does anybody know of an approach or tool I could use to help here? Thanks in advance, Kevin

I've got a multi file runtime solution created with FileMaker Pro 8.5 Advanced on Windows XP. It has a fairly simple scripted export routine that opens all files, shows all records in each file and then exports all records to a filepath set with a variable in the .fp7 format. At the moment the runtime application is crashing, at different points, in the export routine. I've tried this on 4 different PC's now and it keeps crashing on all of them at different files (e.g after file 1, after file 3, etc). If I open the files in FM Pro 8.5 Windows and run the same script using the same account it works perfectly with no crashes so far. Anyone experienced similar p…

You all seem nice and definitely know what you're doing, so maybe you can point me to the right path. I haven't really used FM since around version 4 and just picked it up again on a hobby level. Now let me tell you exactly what I'm trying to do. I have around 200 sewing patterns and am attempting to use FM to organize them. Everything is working exactly as I had hoped, except for one thing I'd like to do that I just can't get my hands on. There is a main image container for each pattern record. For each pattern, there will be at least one image, but in some cases there may be 3 or 4. Right now I haven't accommodated for more than the one main image, but it woul…

Okay, here's the skinny. I have some Cafepress shops. I'm trying to build a database to better track my sales and do reports on which designs are doing well and which, well, aren't. I want to have the image of each purchase automatically added to my imported order reports. I can build the URL from the product ID easily enough. I can also use GetURL in a script to go to that image in my browser. I'd rather not have to manually copy/paste each item in, though. Any advice would be greatly appreciated.

I imported notes from a Microsoft Excel .xls spreadsheet, but the date 02/26/04 was imported as the integer 38043 in records 14805...20516 (in other words, thousands of consecutive records). How do I fix it easily? I am using FileMaker Pro 6.0 and the application is ebase 1.03 (a donor database).

I need to stop a User from importing the same file name twice. This file name is defined by the transaction company and is unique. Is there a way to 1) Capture the file name in a table (as a record) during an import and 2) check against this table and refuse to allow an import of that file name (into another table) if it already exists?

Hi, I want to import some text from either Word or Excel and maintain basic formatting in the target FM text field. How can I do this? I'd love to get bold, underline, and indents or tabs. Anything additional wwould be icing on the cake. TIA, Bob

Hello, I was wondering what the best way would be to save a mapping scheme when importing into filemaker. I import data weekly and the format is always the same, but mapping out the data to match the filemaker file to the takes time. At this time I cannot change the format of the file being imported, so I cannot change the column names to match. As of now, I do it once for the week, and change the "arrange by" to last order (once I do it once) but when I shut down the computer, I lose that order. Is there a better way to do this, or am I stuck. Thanks.

I've searched and come up empty....but it seems like it should be easy. I need to export to an xml file, but only the current record. The export (no dialog) script I have now is exporting the first of 54 records no matter which record I am on.

Can anyone help me please? I am trying to import folders of graphics into a FM6 database, and keep getting 'JPEG error #69' error messages. I've tried changing file formats from tif to gif to jpeg to bmp, and keep getting the same error message. It won't let me import tif images at all, but had previously been fine with jpegs.

I'm stumped by this import challenge: I have set up a relational database for students at my university. Things are working well so far--I have several different tables, all keyed by student ID, containing fields such as GPA, credits by term, etc. The last step in creating this database is importing degree information. Here's the problem: My text file containing information on degrees lists each degree as a separate record, keyed by student ID. If students received just one degree, this would be no problem. However, many students receive more than one degree, and I need to track all of them. The maximum number of degrees for any student is five. …

I have a comma seperated file with over 64,000 lines in it. When I open this file in Filemaker Pro 8 I only have a little more then 32,000 records. To prove that my text file has over 64,000 lines I open the file in Excel and it works like a dream I have all my records in Excel. (By the way that's how I get the records into FM. I import it from Excel) Any ideas.

Hello, i imported all my clients from a excell file each was given an automatic customer ID there was 350 of them, i have now culled around 300 of them but obviously they now have ID 127, ID348, ID32 ... etc i would like to change all these to 1,2,3,4,5,6, etc how would i go about doing this. thankyou

Halloo.. A client of ours has an FM5 database, and we have recently constructed a php/mysql order collection set up on another box. Now of course, they want to have the 2 db's synced together daily.. I have been investigating using XML import/export with FM8.5, but then learned that the client has only fm5, and I do not currently have access to that system.. So, I was just wondering about which topics I need to learn to allow me to build an import/export syncing system.. I intend to run php scripts to dump the day's orders/processing into a ? csv/xml/?? file, which I will then either remotely point the FM to, or upload/import somehow.. whilst... …

Hello. I've got what I hope is a quick question. I am importing records from a comma-delimited file. The file contains dates in two formats. The first format, which is like this: 01/05/04 imports just fine, as: 01/05/2004. However, the second format, which is like this: 01/05 (for January 2005) imports in a screwy way, as FM reads it as May 1, which is definitely not correct. I can import this date as text, but I will need to be able to sort these fields as dates. What can I do? THANKS!

I have two databases for classified ads. One database has the current ads (anywhere from 20-50) and the other one has past ads (about 150). I would like to take one of the ads in the current database and move it to the deleted database? Is that possible, or should I just merge them into one and have a field that says "deleted"? THANKS!

I have an 'Items' table which contains a script to 'export' all of the fields contained in the table [no containers] as a 'Filemaker' table. I do this so I can later import using the 'Matching fields' option in Filemaker and populate a different table that has the same field names but is used for analysis and general manipulation that saves my initial table data from corruption. When the 'Item' table is opened I use a startup script to format the screen and other initialization stuff. Within this startup script is the command to perform the export script that I described above. Now . . when the 'Item' table is opened and the startup script executed, the Filemaker ap…

Can anyone tell me how to do the following: I have an .csv file that I would like to import into an existing table. The problem I have is each of the records from the .csv file contains a and a field. If there is more than 1 in the .csv file I only want to enter the one and take the duplicate records and add into a repeating field. What is the best way? How can i merge some records into 1 with repeating fields?

I need HTTP POST url instead of HTTP GET as used in Web Viewer. This is for sending SMS from FMP. Any leads please. Thanx!

I want to be able to export selected fields from the existing displayed record in one FM database to fields in a new record in another FM database. Everything I have tried exports the selected fields of all the records. Is it possible to do this with a FM script and/or AppleScript? Can anybody point me in the right direction?

Making a daily list export script, and want to have the actual field names be a header at the top of each column (this is an order that gets e-mailed as an Excel spreadsheet every day). How do I get the field names to output as the first record? Thought it would be obvious but I think I'm missing it...

Hey all, I'm curious as how to import an excel sheet saved as CSV into the FM DB that I have, and have the data go into line items. They don't show up in the box where you point where the data goes. Thanks!

I've got a problem. I just performed an update for a client and out of 947 customer records, 37 will not import because of errors. Additionally, Filemaker will not generate an import log file so I can't find out what the problem is (the one time I need it to ) Here's what I've tried so far: I've tried recovering both files. I've tried FileMaker Pro 8 Advanced and 8.5 Advanced. I've restarted everything. I've tried exporte to and importing from .tab , .xml, etc. and get the same errors. I've reviewed the data to look for commonalities and found nothing obvious. Does anyone know how to get FileMaker Pro to generate import logs? Before I r…

I'm trying to import PDF files in a container field AND display a preview image of that file. This is in a cross-platform FM8 database stored on a server. The users are 1/3 Mac, 1/3 Windows 2000 and 1/3 Windows XP. I could get the file preview to display in Windows 2000 and Mac by using a Windows 2000 PC to drag the file from it's folder on the network into the container field. The first page of the file then displays as a preview on the Mac and Windows 2000 PCs. BUT on Windows XP the preview doesn't show unless you click on the container field. Then the file hangs up for about 3 minutes until the preview displays. Way too slow to be functional. This happens wh…

I converted from 6.0 to 8.5 a solution that contaned several container fields. The container fields were storing files like word and Excel. When I did a direct conversion of the file to FMP 8.5 the container fields sometimes ended up with unknown objects. I know QuickTime is needed for the image but the problem here was the whole file was missing. I found for some of the smaller files I had with container fields I was able to export records to a FM 6.0 file and then import to FMP 8.5 and they were fine. However with the larger files I found only the following to work: 1. Export the records in small groups 2. Then convert the records to FileMAker 8.0 3. Im…

I have made a button to export records and some specified fields to an excel file on my desktop - the button and associated script works fine for me ( with administrator privileges) but it doesn't work for other users - they get the error message 'file is locked or in use' - can anyone tell me if I have made an error in the way the script works or is it a feature of Filemaker that you cannot make a button to export records? My script is very simple -> Export Records [Restore, "issue selection report.csv"] Other users can use File > Export records OK, but aren't successful using my button. Grateful for any help Carol

I have a list of all my customers in a SQL 2000 Database. I am creating a Filemaker Database for order information. Rather than re-type all Customer info, I'd like to simply add acustomer number field to Filemaker and have it lookup the name, address, etc. in the SQL Database based on that customer number field (Select SQL.name from SQL where Filamaker.Cust_No = SQL.Cust_No). Can this be done? If not, can anyone suggest a way to make this work without double entry of information? Thanks

I'm developing an application in Filemaker 8.5, currently for Windows but ultimately cross platform. When using the Export function under script control, it is possible to set the file path where the file is to be stored. I'd like to be able to drop the file (for example) onto a user's desktop or into their My Documents folder, but the path will vary from user to user. Is there any way of including system variables like the Windows login name so that you can get to the correct user desktop or my Documents location? The alternative is to use Troi's File Plug-in which can return the path to certain system files, but I'd prefer not to introduce this complication un…

How can I import data from excel to filemaker 5.5, which is supposed to fit into repeating fields? The excell column has cells with data to be imported into repeating fields of one f.m. record. Thanks.

I have a table named "meds" that has a medication list. I would like to import these records into another table named "scheduler" on a daily basis. Is it possible to import files from one table to another in the same database?

:) Question When exporting a record is it possible to customize the name of the exported file according to the contents of a field? Can anyone please point me toward some sort of generic .bat script or just a windows scripting overview for basic fm tasks in general? Bonus question, does fm7 / fm7 server cater for the creation of thumbnails? Cheers in advance for any help, [color:blue] genx.

Can anyone show me how to export data to excel, but using a set format/layout. Really just layout... I have to give reports in excel to a company each week and they want it in there layout, how can I do this in excel? Joseph

I am exporting a date field and need to keep the # of characters in the date field. Scenario: I am parsing a date to three separate fields using the Year(Date) Month(Date) Day(Date) functions(Calc result is text). Problem: I need to keep the leading zeros in the month and date fields for the export. Current Result: Date Field = 2006/01/01 returns 2006 1 1 I need: 2006 01 01, and when exporting into Excel I need to maintain the same # of characters (i.e. 2006 01 01). Any feedback would be greatly appreciated. I have been hitting this from every angle and can't find the solution. Thanks in advance...

I have 2 runtime solutions that include a seperate database file with 400,000 records that is updated weekly. The database size is currently around 100mb. I'm looking for a solution that will let my clients using my runtime solutions simply click on a button and update the data. Currently, I have the data available as a download on my website, and the user must manually download the file, then open up the runtime, click on a button to update, and choose the downloaded file. Apparently, this isn't easy enough for some of my users. I've looked at a couple FM plugins that use FTP to transfer files, and I'd prefer not to use FTP because of its security concer…

I have a partially completed solution that the client has been testing and now wants to begin entering real data into. Since I am still in the process of refining both the user interface and the data structure, however, I will eventually have to get the updated data (about 12 tables) out of the older version and into the newer. We will probably go through this process several times, and I'd appreciate suggestions on how to make it as smooth as possible. I can certainly import records into each table in the updated version, but should I try to import all records (after deleting existing records) or just import and update records? Will I need a script in the "old" file…

I am pursuing on building an educational database and I need to export students' names with grades in different courses from each class to .xls file. Then I will write the grades in the .xls file and import again the file.xls into filemaker.Then I can print out a list with grades of each student for each couse and give their parents. The problem is that the layout of .xls is awfull and as I realized filemaker does not relate with MsExcell very well. The fields from portals export like xxxx:xxxx.They do not have a unique name. Does anybody know what can be done to succeed a better layout in .xls and adjust the fields in the way I want before open the .xls file? Pasca…

Got a real pickle here... They were using FM5 before I came in and had test information (scores, dates, etc.) in repeating fields (score, date issued, date rcvd, etc. each was an individual repeating field). We've since went to FM7 and I made this type of record keeping to a related portal (where each test is an individual record). I'm having a hard time importing them. I tried splitting the records but that doesn't work and also tried creating fields in the main FM7 layout but that only imports the first repeating row. Please any help would be appreciated!!!!

Hi, we have about 20 clients using our FM solution and the list is growing, all clients connect remotely to our dedicated server. Depending on fixes or new aditions, we do updates about 3 times a month. But the process is so tedious. We have two files, the interface file (layouts and scripts) and the data file, so at least minor fixes are easily updated by just replacing the interface file, but when there is a change in the data file a full update is inevitable. So far we don't have an automated data import into a new version of our solution, but as we speak I'm working on a system where a current solution would have a script that would export all data into a temporary da…

Hi, I'm trying to import an excel sheet into a FM table without spawning the mapping window i.e. I don't want users to manually map the field names. I make sure that excel sheet column names match those of FM field names and when run locally it works great. The problem is that when trying to execute the script remotely (over FM server) the field names won't map. Even if I let the mapping window show up I still can not select Arrange by Matching Names, it is grayed out while if I run the script locally it is not. Is this a bug, and is there a way to have this work remotely? I really don't want users to manully map the fields names. Any suggestions would be apprecia…

Hi, I've one file with 26 tables in it. I have a developer version of this file where i had functionality, and my client has a working file. Upon upgrade, I want to import all the data from my client in my developer version to ship the upgraded version back to my client. So I made a loop that goes on a special layout of each table, and then trigger an import with a varaible filename (to avoid browsing or the file each time). The import trigerred will only have its filename specified with a $variable. What's annoying is that I would have to choose carefully the source table. I want a way to specyfy the source table with a variable. I don't wan…

How can a text field's content be exported to a .txt file with proper line feeds/carriage returns? I am getting the square box in place of new line.

I'm not sure if this is a bug, but I've come across a troubling issue with the import mapping being different from what I set for accounts with limited (no access) field access. I don't believe this was an issue in FM6, but it seems to be consistent in FM7, FM8, and FM8.5. In the attached example, with access to the Salary and Hourly Rate field restricted for the "User" privilege set, if that user tries to run an Import of that file, the stored field mapping is lost for the Name field with was created after the Salary and Hourly rate. It is understandable why this would be. Since those two fields aren't visible, they shouldn't be selectable in the Import dialo…

Hi, here is my problem. I have database with few houndreds employees with many functions. I would like to add new function now. We are distributing to our employees few printed documents, which are tip secret. So usually, we are printing their names on it also, because of security. What I would like to do: Add .pdf files to containter? field and then print it somehow with the script in fm, and maybe with some batch script in Adobe Acrobat Professional. We are doing this now: Open file in Adobe Acrobat, add watermark with employee name, print. But I would like to automate this process and also be able to check when and how we sent (gave) this document to employee. …

MS Access has this function of creating "fixed field sizes" and exporting with "fixed width",can this be done in FileMaker? (Using FM6.0v4 but could upgrade if needed) Problem: I need to create a fixed field size to Export into a COBOL system. Why: The COBOL system will not accept the import unless the fields are, say 10 characters long. If there are less than 10 characters the remaining characters need to be filled with spaces. Hence, if I have 10 fields the resulting export will be 100 characters in total. Any feedback would be greatly appreciated, this is a critical element in the final process of my Purchase Order system. Thank you kindly...

I'm using Filemaker 8.5v1 and I import records updated records from a ftp site weekly. My script goes to the url and the text file appears. I can then manually open the text file and then have a script import the records. I want this to work in one smooth motion, I'd like to import directly from the ftp but can't seem to figure out how to do that. Any help or suggestions would be greatly appreciated.

Hello Can someone quickly help me on this : Running Filemaker 8.5 advanced on XP I set up the import script - import from file - filewin:/C:/Documents and Settings/Desktop/test/$FileToOpen - Set variable : - name = $FileToOpen But now I'm stuck for the value ? I want the value to be either what is in the copy/paste memory or a value from a field. And in either case I want that that value is completed with the extention .txt Can you help me ? Kind regards

Hello - Is there a plug-in or some way to get a layout and record to export as a named HTML document. Can the name also be saved from a field? thanks Dave

Is it possible to import FMP 8.5 data into an excel spreadsheet on OS X? I can see and option to open an FMP 5 database but not fmp 8.5. Can this be done using odbc? If so, does someone have an example of how to set this up? I currently have a formatted excel spreadsheet and I would like to fill in parts of the spreadsheet with FMP data. Thanks

Hi everyone, One of the processes I have to manually do prior to importing data into one of our solutions is to clean all the commas out of a tab-delimited file. Currently, I have to open the file in a text editor and replace all commas with a space, and save the file. Then, FMP can be used to import all of the data properly. I'm trying to automate as much as I can in this process. I'd like to be able to "pre-import" the text file and then use FMP to search for the commas and replace with a space and then use the resulting data as the source of the import into the actual data table. Might this be possible? Thanks for your help! Mac Hammer

Hello Everyone! I've seen some questions here that address similar concerns, but I can't quite find the answer to this problem: I have a table listing demographic information about students. Each student has a unique ID, which I am using as a key. This table has several hundred fields. So far, so good. In addition, I have a series of about 20 additional csv files that include credit enrollment information for each student. These are keyed by student ID also. There are about 150 fields in these files. The first six fields contain data unique to that table (student program and type as of the date that table was created, etc.). The final 140 or so field…

Hi all, I have three diffent sales, Van Sale/Whole Sales and Retail Sales. Now I need to create the report by three sales together, I was think the only way to go is import, it's? So, I create the file name(all sales report)this file is for my import all of the three files together. The problem is how I every month the update the report file? and I still need to keep the old record together? At the import option I need to Add new or Update Exiting? Hope you all undestand my question, and thank for you'll to reply me! : Sales_Report.zip

Hello everyone, this is a little philosophical in nature. In my company, we currently have about eight files that were created to do different things (print reports, current order status, shipping tags, envelopes, etc). I just joined the company and after looking at the files there is a ton of duplication between the information and re-entry of the same data. I feel that it would be possible to use the most comprehensive file that has most of the information and just create different layouts and scripts to get all of our business functions done with the least amount of duplication, thus eliminating the need for all of the other files. What would be your …

I am trying to export the pictures out of a FM 8.5 file, but I do not know how to determine if it is a .jpg or .pct file. If I manually export the container, FM defaults to Untitled.xxx with the correct extension supplied. However, I cannot seem to get the default in my script. Any suggestions would be appreciated.

I have a Vendor Table and another table that has inventory related to that vendor. How can I import the Vendor Data and associated inventory data at the same time? This can be done, right? Thanks

What can I do to the file safely while the database is actually in use, i.e., people are adding/editing records in the database? 1 - Can I ADD/import new scripts? 2 - Can I create new layouts? 3 - Can I modify an existing layout if it's not being used? 4 - Can I modify a script if it's not being used? Obviously I'm new at this... Is there anything else I should be asking? Thanks for your input.

This is a very strange issue. At work, we create quotes in peachtree accounting software. PDF copies are stored in a folder on our network. I created a field in our quote tracking database in fmp called "external filename" when the user types in the external filename and clicks "import" it performs a script that does an "insert object" into a container field. For anyone, it simply inserts the image and creates a graphic with the filename in the container field. But on one user's machine. they press that button and it inserts the file into the container, but it displays a full size thumbnail of the item. This is handy for web users who can right click o…

Hello, This is a basic question, but I've forgotten the answer! I have a database that is one table, with a large number of defined fields. I want to add the table into another Filemaker database. How do I import a table? Alisun

my solution performs a scripted imported from one table to another (scratch) table within the same file (copying the found records). This works fine with the file.fp7 version, BUT DOES NOT WORK WITH THE stand-alone file.USR version!! Specifically, it does not recognize the found set of files, but instead imports ALL files from the source table! Any idea why there is this crucial difference between the .fp7 file and the .usr file?

Don't know if this is simple or not, but I was wondering if there was a way to open existing PDF documents from inside Filemaker? Thanks...