Importing & Exporting

Have an issue with importing a .CSV file to FM7. After the import, some of the fields have blank spaces at the beginning and/or end of the data. The spaces are causing a problem with lookups because a lookup for value "ABC" will not match "ABC ". I can remove the spaces after the fact with the TRIM function, but I would rather not have to introduce this additional step. This .CSV file is over 200,000 records and will be imported on a daily basis - so automation is critical. Any thoughts on how to stop the spaces from coming in, or automatically remove them, or have the lookups ignore them? I have attached a small sample of the data. Thanks!!! IngData.txt

Hi, Does anyone know if it is possible to export a file maker report without exporting all the related records of that report? Thanks in advance!

FM 6 would default to *.usr when using export script in runtime solution Now you are offered tab as the first option and have to scroll to the last selection before you are offered usr. potentially confusing for users. is there any way of forcing usr to be offered.also would be nice to create automatic backup on desktop unfortuantley filemaker does not let you specify desktop current user as option. I suppose vb scripting might do it but that is beyond me! there are some commercial solutions (like fm exporter, but these are expensive and my solution is free, users donate to charity any help would be great

I have a database that tracks customer support phone calls. This database has three fields: CALLER NAME TELEPHONE NUMBER MESSAGE Sometimes I receive messages from a caller just once. Other times I will receive several messages from the same caller. I would like to produce a phone directory of unique records. Is there a way of importing the records from the first database into a second database that will delete any duplicate (redundant) occurrences? I want have the customer's name and number just show up once, regardless of how many t…

Is there a way to export text with textstyle? What I need to do is the following: Export from FM to a MySQL. Then display content from there via PHP. I would be able to parse the text with all kind of 'textlike' marks as a b in brackets or so... but: How do I get these marks in my Export? Tried with calculated fields but to no avail (hopefully: yet). Since the 'instant web publishing' shows up these marks I'm not giving up. Any clue appreciated! TIA!

Is it possible to export tab seperated data seperated by a blank row? I want to export invoice data from item records and insert a row of empty data when the invoice number changes. Its easy enough to display a report with a blank line but I cant see how to do it with an export Thanks

Files exported in .dbf format using a Mac are not readable on a PC. If the file is exported on a PC, the dbf file is readable on a PC. Is there a way to correct the format of the Mac-exported dbf file? Is it a "data fork/resource fork" issue?

Hello, This may seem like an odd request and I'm not sure where to post it. I am a teacher and have been asked to pull data from my report cards ever term for the last 4 years. My report cards are based on a FMPro 5 database (Ontario Report Cards) The data is the marks in English and Math. Instead of manual writing down the data, I am hoping that I can pull the data out of the assess fmp file and save it as a tab file. I know the field information - like the English subject is subject_id 21 and the Mathematics subject is subject_23 also the information I need to move to a tab file is - gender, strand1_T1, strand2_T1 ...Strand3_T1 for both subjects.…

Hello OK, I converted my old FM6 multiple file solution to FM7 using one single file/multiple tables. Apart a few problems (a couple still pending) and plenty of time, everything is getting back to full functionality. One area where I would need advice is how a user will import the data from the various tables contained in the one file to future versions of my solution? Does it mean that I have to have a script that looks like this? Go to layout <1> Import (locate < old solution file>) Go to layout <2> Import (locate < old solution file> again!) and so on... OR Is there a better way for doing this? Tha…

This is an odd one... I haven't had much time to troubleshoot, so I hope someone will recognize the symptoms. I have several linked databases running under FileMaker Server 7... just moved them over from FM Pro Version 6 this week. While doing a quick checkout of the system (I'm new to both the Server and FM 7), I noticed a disturbing glitch. I have a script that exports a few fields from many records into a text file (about 200 K worth). There are several layers of calculations performed to generate the final export fields. OK... here is the problem. This worked fine when the database was on my local machine, but today, I noticed several characters have been dropped from…

How do i import multiple records from Table A into a single record but with repeating fields in Table B. The result will be one record on Table B with repeating fields, the same number with what was imported. The repeating fields of Table B is similar to the fields of Table A. Thanks in advance

I have a program that automatically imports details from a .txt file when it opens, Im looking to export a range of fields from a single record. When trying to export the file extentions do not include .txt have tried the other extentions and the host program does not recognise this format. The information must be laid out as follows. Everything upto and including the equals is the target programs fields, everything after needs to be generated automatically from fields. USERS_SIGN= Fred Brown LIFE1_TITL= Mr LIFE1_SURN= Case LIFE1_FORE= Test LIFE1_LONG= Mr Test Case LIFE1_DOBT= 19/05/1956 LIFE1_CAGE= …

Hope someone can steer me in the right direction. I have a solution where text is cut from a browser page and pasted in to a text field. Sometimes the text is in all caps, and I need to have it in Titlecase. I can use the TextStyleAdd function to get the text to display in title case in a calc field, but when I export the displayed calc text in to a plain text document - it is still in upper case. So obviously the ascii characters haven't been modified by the calc. My question is - is there a way to actually modify the ascii so the exported text really IS in title case? I have a feeling the answer is no. But maybe there are utilities or plug ins that mig…

Hi Folks, I'm setting up a lot of .mer export files which will then be sent to PDA's ! The problem is that I need to name each file uniquely - e.g. I had hoped to call the file - Jobfile HR 152793.mer with the "HR 152793" bit changing everytime as that is the unique job number in the file I'm exporting from. Basically I want to name the file as the job number I'm exporting - as I'll be exporting a single job (record)at a time - How can I do this?: Do I need a plugin ? I've no idea ! Any help would be great ! Thanks Folks Dermot

When I import records from an excel worksheet, FM creats a new record for each row of data (this is good), but also creates 8000+ blank records (this in not good). What do I need to do to make FM import only rows w/ data?

Hi, I've been away for a while so excuse me-I've attached an example of what I'm trying to import if this makes things easier. From the text, which comes from a router we use, I'd like to import the information into FMP ver 6 in the "normal" format-this is, 4 field columns named Sid, Good, Corrected & Uncorrected. From that, I can set up my relationships and export functions which I've got a handle on, due in no small part to these forums. Unfortunately, when I try to import now, I just end up with one long field column which I cant use Can it be done? Thanks Sandy cmfecexample.txt

The solution I design and maintain (in FMP7) is not like anything I seen or heard of. Rather than a single database for multiple projects, this DB is used as a template. It

Dear File Maker developpers, I read some posts in the forums but I couldn't find a solution for my problem, so here it is : I need to export some records to an XML file. I used the FMPDSOResult grammar, because it suits better to my needs, and also a XSLT file to perform an XSLTransformation on my data, and get a well structured XML file. This works fine, but not always Depending on the records I decide to export, I got the following dialog box "Invalid Character (Unicode 0xb)" So, I guess the problem comes from the records where there must be some strange characters, which are not accepted by the export process, but they are not visible. How could I skip …

Dear all, How could i switch from a path storage to an imbeded storage for my database picture without having to import them all again ? thx, Eric

Hi Folks - Having a bit of trouble ! I have the following script which works perfectly to remove comma's and full stops from a text field which I need to export:- Left(Substitute(Substitute(Item name, ",", ""), ".", "") & spaces,100) You will also notice that I'm setting the exported .mer file to a fixed length of 100 characters ! Thats all fine - works 100 % The problem is that some of these text field records have entries of " dipicting inches - e.g. 1 1/2" pipe .......... If I try to substitute " with a space it simply won't allow it ! I have no idea how to get round this but there is bound to be a way..... Hopefully ! Look forwar…

I am importing files from a pre-formatted Excel file. If only a couple of rows are filled in with info, and the rest of the fields are blank, but still formatted, Can I get FM to ignore the blank rows upon import?

I have a database that will be a multi user file. The majority of the information entered into it will be from importing excel files. Many users will need to import into it. Is there a way that I can save the import order so that it is the same for all users? We don't want to have to keep re-mapping. Thanks

Hello, I need a way for Filemaker to automatically create a "creation date" when I import records from a csv file. Does anyone know if this is possible? I tried to just create a field that was an auto-enter date, and I thought that when those records were imported, that they would be given a date. Looks like it's a little more complicated, Oh well Thanks, Karen

Is there any way around importing to multiple tables within a sigle database ? I know in Filemaker 7 you can only import to one table in a database file; however, i was wondering if there is a way around this ? Thank for the help ! -Travis Ferreira

I have a flat database set up that requires information from 4 different excel files. I currently merge all the files into one excel spreadsheet with 5 worksheets but I'd like to use Filemaker instead for database management. So, is it possible to import my roster (main part of DB), then import the rest of the files and have them merge into the appropriate member's file?

Hi all, I am trying to export data to a Comma or Tab delimited file for use with a data merge feature in InDesign CS with the Pagemaker data merge feature. I have done this numerous times before from Excel and it has worked great. However, when I export my data from FM and then try to select the file as a data source InDesign does not recognize either of the formats as a text file. Any suggestions or input? jerry

How's it going? I'm trying to get my database to import FedEx tracking numbers. I have the import set to update matching records by invoice(reference) number and then import the tracking number accordingly. The files I'm importing is a CSV file containing just our tracking numbers and the corresponding invoice numbers. I have the tracking numbers going into a repeating field and I can import the data with no problems, except when I have multiple tracking numbers(sometimes as many as 70) for one invoice. The numbers will only import into the first field. Is there any way to get the tracking numbers to import into the repeating fields? Or will I need to make multiple tracki…

Hi all you that know how ! New to this forum. I usually work in other development environments and have not have experience with FMPro. I have a client with a FMPro 5.5 system and they need to regularly (weekly) import an Excel file into their existing database. The existing database has 67 fields. The data to import has 17 fields. My questions are: Does the data to be imported have to have the same field names as the FMPro database? Do I have to have 67 fields in the Excel file (with all Field Names the same as I found in "Field Definitions"), and only have 17 of those fields holding the data I need to import? Should I be looking at writing …

I have a table which I'm trying to insert into a MSAccess table. The call is the following: INSERT INTO MSAccessTableName ( Field1, Field2, Field3, Field4 ) IN ODBCName SELECT FMTable.FIELD1, FMTable.FIELD2, FMTable.FIELD3, FMTable.FIELD4 FROM FMtable; What is happening is that the Select part of this command is attempting to run at the MSACCESS DB. In other words if I was to have a table at the Acess DB that was named FMTABLE. The Query would work, it would just work from one Access table to another not from the FM db. Any thoughts? Thanks, Jim

Folks This is more an Excel problem... Ms Excel 2000 SR-1 on Windows 2000 SP4. The clients want to export to Excel, delete unwanted rows and columns, maybe change a few cells, then save the file. It's got to be in csv format. It's not working because Excel mangles the application number. The "application number" field has the format YY-XXXX eg., 04-0122, or 05-2356. The problem is that whenever the data is exported as csv and opened in Excel, Excel *without prompting* converts the application numbers into dates. Not all application numbers are converted, but most are. Changing the cell format to general, number or text does not change the data back to its o…

Hallo, I've a problem with filemaker -> mysql. I export my record with ScriptMaker in text file, then with php I import data in mysql. I use LOAD INFILE. But I've problem with special characters. What can I do??? Thanks

Hi, I have tried to export data using mer format but instead of comma-separated text, i encountered semi-colon separated text. Any clue what causes it to be this way? Thanks and regards.

I am having some odd importing problems after upgrading to filemaker 7. I have tried using tab and cvs files as well as a few others that filemaker supports, and the only one I can get to work is an actual .fp7 file. My problem is that while importing records the first value (order number) gets ignored. I can't get the order number to import into any field, but I CAN get other stuff to import into the order number field, so I don't think its the fields fault. I have tried different line endings and encoding, but that didn't do a thing. The current work around would be to add the order number to the end of the file and use that one instead, but we still need to f…

I have two problems. The first problem is that I have a set of Numeric Filemaker fields that, when I export records to a DBF format, zeros are entered into any field that is empty. I need them to stay blank. Is there some setting that prevents zeros from being entered when using a DBF? My second problem is that I am trying to export a DBF file from which Visual FoxPro can read a logical field from. I tried filling with ".F." and ".T." but the FoxPro app sees it as a Char(3) field, not as a logical. Is there any way to flag a Filemaker field to be exported as a "true" logical ?

I'm about to deploy a solution and I'm at a lost for how to continue upgrading it (which may not be necessary, but I'd like to be able to fix bugs). The issue is as time goes by people will be adding data to their (single user systems..no networking involved) local data bases. I'd like to be able to export all of the data from their solutions, and then import all the record into updated versions (with bug fixes) of the solution. The question is: is there a brainless way to export all the records and then reimport them into another identical solution (with perhaps minor changes to scripts). thanks...Sandy

Hi, Many thanks to those who can help wit this: I am exporting values which are later read into a MySQL database. I am using a checkbox field to enter different values to a field. THe import script needs to be able to distinguish seperate values by a comma but when I export the values are just seperated by a blank. Since some of the values are two workds, the import script would misinterpret these values even if it seperated values by these blanks. Is there a way to export this field and the corresponding values and seperate them by commas? Thanks a lot, Stephan

Hi, Have imported in database of FileMakerDeveloper7 a file with the records which look like: 12.32.22.199 - - [26/Aug/2004:05:08:00 -0400] "GET /amason.txt HTTP/1.0 404 346" "Googlebot/2.1 (+http://www.google.com/bot.html)" 99.15.255.284 - - [28/Aug/2004:06:04:50 -0400] "GET /Folder/picutre.gif HTTP/1.1 200 47418" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Opera 7.50 [en]" 1.0 All records are stored in one field(Imported_Array), because that's the only way how to manage fild mapping while Import. 2.0 Now and somehow, I have to brake each record and store to the fields in database to look like: First_Separator = 12.32.22.199 Second_…

I am having a hard time trying to get a file to attach in MS Word format "automatically". I need for the user to select "Send Mail" and have the form already attached in .doc format. Is this even possible?

Hi all, did anyone face this problem? when I export to Excel(.tab) file and I try to import from my MYOB accounting software and face some error. I have 100 invoice when I import into MYOB, MYOB just import 100 decription in one invoice and for me? Any idea????

{original question - Export from Exel table to a FMPro 6 I've changed subject in case somebody also would need an answer... } Is this possible?

Does anyone know a way of making filemaker export a CSV file with windows file endings (CRLF)? Surely there must be a way of doing this!

I'm trying to export one field, and it's not performing exactly as I would like. I've got one large text field, and each line is separated by the carriage return "

I'm trying to import an XML file into file maker pro but I always get a parse error (Unknown element "...." at line .......). The file I'm trying to export is an XML file generated from the Address Book using this script http://www.macosxhints.com/dlfiles/addressbook_to_xml.txt (I found it on this page http://www.macosxhints.com/article.php?story=20040906085533325). I've read that the XML file that I want to import must conform to the FileMaker FMPXMLRESULT document type definition and that if not it could be solved by applying an XSLT style sheet but the problem is that I don't know XML. Could anyone help me with that problem ? If someone knows a another way …

When exporting records to a CSV file from Filemaker 6, it places quotes "" around each field. This is a problem for me, because I'm moving the data to MySQL and a decimal field interprets a rounded value. ie. In filemaker, the record is 3.32. When exported to CSV, it becomes "3.32" - a string. Imported into a decimal(6,2) field in MySQL, the string is converted to a decimal, but rounded to 3.00. Very annoying. Any ideas on how to export or extract unquoted records from Filemaker into a CSV file? Thanks in advance for assistance. Best, Brenden B.

Hi, i'm migrating a 52 database FM6 system to FM 7. All files converted without any major problems but i had to do some cleanup, which took about a week, so then i cleard all the records and did another conversion and imported the newly converted file's records into the older but cleaned up shells. 51 of the databases imported OK but one of them, which only had about 2000 records in it is taking hours. Other files imported much faster and had more records. Does anyone know of a reason for this. There's nothing in this database that isn't in others as far as i know. Any help would be appreciated. Heckate

Hi, does sb know a way to calculate the name of an export file out of field contents? Thanks Berny

Hi all experts, I am having trouble with this: - I want to import a text file - Then, display the text (in the text file) in a field I want. Is there a work-around way on this? Thanks for every reply. Remi

I have an Invoices db with each line item represented by a group of repeating fields, and I want to convert this to Invoices db + LineItems db -- a simple one-to-many relationship (FM6 all the way). From reading an earlier thread in this forum, it appears that you import directly from the original Invoices file: once for the scalar values that belong in the new Invoices file, and once for the repeating field groups that belong in separate records in the new LineItems file. If this is the best way to go, I have a few questions: -- There is currently no "Invoice_ID" field to serve as the key for the relationship. Should I add this to the original Invoices file b…

Hello, after searching the forums for this specific problem, I couldn't find any reference to it. My apologies if I missed a post. In exporting/importing data from one FMP datafile to another FMP datafile using FMPXMLRESULT, critical return characters are being removed from a field. Is this fixable through an export setting? Or is the only way to go is XSLT? Thank you in advance for any comments or suggestions.

I am finishing up a solution that needs to work with both PC and Mac. When I export from FileMaker (tab delimited) it inserts squares wherever there is a paragraph return. Do I need to substitute this with something? How can I export without this happening? Thanks for your help!

Im trying to import records from one table to another within the same file. You'd think there'd be an easy way to do this within a file, but I can't find it if there is. The file is being served on the network by FM7SA. To import from one table to another requires me to look for files being served on the network, and then import from itself. I had this working ok on one machine, but when I set it up on my work machine it tells me that the file cannot be found, and then crashes. It works ok if I import the data manually, but crashes if I script the import. (It works if I script the import but don't specify a file path in the script, and then manually locate the…

When 'Update Matching records in current found set' is selected on import is there anyway to prevent empty fields, in the record being imported, from clearing out already populated fields in the record being updated? I only need the additional data to populate its respective fields in the existing record. Or is there a way to merge two records into one where only the data in the fields that are populated in the second record, that are NOT populated on the first, gets transferred? A solution to either would be a huge win for a perplexing situation.

i have a script that is supposed to import a reference to a sound file into a container field like this: Go to Field [ContainerField] Insert Movie [] it's a bit more elaborate that that, but that's the important stuff. doing this on windows XP exits the program just like that. i've done this on a mac and assumed it would work on windows also - what am i missing?

I'm entering data into a FMP7 file via a Palm PDA. When I synch the data to the main file, fields are supposed to be "auto-entered" via lookups with other subfiles (eg. Last name entered in PDA - first name is supposed to be looked up and autoentered with the synch). This all worked fine with the earlier versions of FMP/mobile but not now with v7. Any thoughts????

I am new with FM 7. I have developed 2 Databases 1 with 2 tables and 1 with 1 table. I would like to export the 1 table with its field definitions into the DB with the 2 tables. I have been able to export data but short of redefining the entire table have not been able to figure out out to get the field definitions imported. any help here? Thanks, [email protected]

In FP7

Filemaker Pro7 seems (or proclaims) to be much more flexable when you want to work with different filetypes. What I want to know is the following: We have several composers supplying a musicfile in different sound formats on our ftp server. They use specific codes so that it

I have a filemaker pro 5 file with 100,000 line items in it. What im trying to do is create a simple static website with these hundered thousand items. Now 100,000 items on one page is too much, dont you agree? so what i need to do is find the first 1000(one thousand) records and export it to html, then find the next 1000 and export that. Idealy it would name the exported pages 1,2,3,4 etc.. but even prompting me for a name is easier than manually finding 1000 records, exporting, finding the next and so on. Is this possible? and can someone help me figure this out it would be much appreciated.

Greetings, I've managed to figure out how to export my data records out to an Excel spread sheet, but what I can't seem to figure is how to export the labels at the top of the columns. Any Suggestions?

I'm trying to export a file from our FileMaker-based POS to send to the University's PeopleSoft finance system. One of the requirements is "a sequential number starting with 1 for the first line and incremented by 1 for each subsequent line" -- i.e. a line number. This wouldn't be a serial number stored within the record (each record already has one) but would be within the found set (the first found record is 1, the second in the found set is 2, etc). Is there a way to do this? I looked at the status functions and couldn't see anything that looked like it would work. I could write a script that would loop through each record, setting a numeric field to the value…

I am working on exporting data out of a custom-created FileMaker 5.5 database to import into eBase. One of the fields is a series of check boxes for a value list called "Groups." When I export data into .CSV, all of the data from that field is placed into a single field, separated by "boxes." I originally assumed that these "boxes" were line breaks. But, I do not believe that they are now. My problem is that I cannot do much of anything with the data while it is all concentrated into one field. And, since I cannot figure out what the data separator character is, I'm really quite stuck. I've attached a sample of the data. If anyone can provide assistance, I would g…

I am importing a date field to FMP7 from excel with the format 19950401 (for April 1, 1995). Is there a calculation that can convert this format to, say, 01-Apr-1995, or any other of the pre-set date formats? Thank you in adavnce, Justin

Filemaker 7 is not allowing me to include a photo when exporting a list of membership names to a static page. I'd like to include, in the exported static page, a link to view a photo. I tried including a field that included a URL such as http://www.website.com/photo/membername.htm but when I do this it does not act as a link-- only as text. Can someone help me figure out how to add such a link, or suggest another way to do this? I am constrained to use only static pages for this project.

I have just imported 1200 records into my database from excel. The strange thing is. Some of the phone numbers are not adhering to the calculation for the field. If I erase the number and typr it back in, it seems to work fine. I am using Let( P = Filter( Home Phone; "1234567890" ); "(" & Left( P; 3 ) & ") " & Middle( P; 4; 3 ) & "-" & Middle( P; 7; 4 ) ) And I don't have the box checked "Do not evaluate if field is empty" So it's not that Is there some glitch when importing numbers due to some problem with the font it imported? Has anyone else had this happen? Thanks Dave

I have a solution that uses romam and Chinese formated fields, when exporting roman shows ok but the Chinese doesn't! Has anyone experience this? What could be causing this?

Hi, In FMP6 if I imported from another file, it would import the current found set. How can I do that in FMP7?. What I really need to do is this: I have a job table and a line item table consisting of what we call Descriptors. Each descriptor has line items also. So the descriptors are pulled from a descriptor table which also has a line item table. I need to create a Bill of Materials for the Job that consist of the line items in the Descriptor line item table. I want to store these in its own table called BOM. Does any of this make sense. I was going to pull up the line items from the descriptors one at a time and import them into the BOM table …

Hello, I'm totally new to filemaker (I'm used to perl and php) and I have a task which needs to be performed to an export from filemaker and ideally without having to take the results of the export and writing a new script to parse the data. Ideally, I'd like the report to come directly from filemaker as specified below... say for example the database has records like... 1 | John Doe | 237 2 | Jane May | 479 3 | Jack Lee | 589 and I want to do an export from filemaker, while performing actions on the return, so that it's export looks like... 1 | John Doe | 237 2 | John Doe | -237 3 | Text | 4 | Jane May | 479 5 | Jane May | -479 …

As follows: I have a repeated field in one table. I want to: see all the informations when i export that field together with the other field, is that possible? Thanks,

I'm new to this and want to know if it's possible to import dates and details from iCal into a FMP invoicing database. I know there's a tonne of calendar solutions but I specifically need to use iCal because it communicates with the diary in my phone via iSync. As of yet no-ones had a clue although I think I read that a recent update of FMP added export to iCal and thats as close as I've got. Any help gratefully received. Ta. bb.

I have a pair of databases. The first one is a list of people and the second is a list of transactions. I create a report layout generated from the transactions database which shows a list of people who had transactions during the selected period, and the number of transactions that each had. To generate the number of transactions, I have a summary field and break on the individuals last name. It works fine, but I also need to be able to export the same data. Everything works fine on the export, except that the summary field is only included in the first record and it shows the total for all the people in the report. I know that this must be simple but I've tried e…

Hoe can i make the export of the fields more quickly? It's too slow now, Sould i index all the fields? Thanks,

I haven't been able to find the answer to this yet, so does anyone know how I can import a picture that I've posted on a webpage directly into a filemaker 7 db? I want to eventually create a script to do so, but using the import feature in FM7 doesn't seem to work. Help!

Age old struggle...I'm constantly getting files which I want to import the data into Filemaker that have been supplied to me with names and addresses that have been set up in excel in a vertical manner (meaning the data is stacked in rows in one column rather than entered across the columns with each piece of information next to each other left to right. Does anyone know how to extract the data that has been stacked to get it into to a form so that it can be imported into a database? I keep explaining to people that they should enter info into one single row across the columns so that it can be used in other ways, but can't seem to get people on board. They'd r…

Hello everybody, I wanna know how to export to pdf-file, can somebody explain it to me.

I have a FM7 db import records from a txt file. in the DB file, there is an auto-enter calculation field (field_B)defined as: Case(not IsEmpty(field_A); "postive"; "negative") where "field_A" is a simple imported text field but even if field_A is not empty, field_B still show "negative". Anybody know why is that? Thanks in advance!

I am importing folders full of images into my db. Some fields related to the photos will have the same value for all photos in the folder. Is there a way to specify a value that will be set for all records in that import? If not, how do I set a value across multiple records in one action?

ok, please no eye-rolling: lets say I have plain text that looks something like this: Contact Information ------------------------- Name: BOBBY BOBSMAN Address: 200 ANY STREET City: SHOOTEM State: TX Zip: 75147 Hm. Phone: (555)555-5555 Wk. Phone: (555)555-5555 Ext.:555 Email: BOBBY(at)BOBHEAD.COM Married?: No Age:42 Shoe Size: AM More Information --------------------- DOB: 03/15/1962 Gender: M Height: 5ft 3in Weight: 579 How can I import this into FMP7 ? Do I have to specify what is to the left of the first colon somehow? (on my wishlist: automate these if they were emailed to me) which reminds me, do…

I realize that this may be a stupid question as a rank novice but I cannot find this answer anywhere. I have created a database from an Excel sheet where there were 456 rows(or more). I used transpose in xcel to make rows into columns, because xcel cant handle more then 254 columns? on a sheet, and I couldnt create a sheet with 456 columns (or I dont know how to as it stops at IV)> So I now have two sheets with <255 columns with the sum data between the two sheets. FM7 could handle >456 columns no problem but now I want to or have to create two tables in one database comprising the two sheets. However when I open each xls sheet, FM7 wants to create a new datab…

I have an inherited FM db running on 5.5. We have a script that imports from a SQL database capturing web data. A new piece of data will be in mult-choice checkbox format. I can do this the easy way, I think, which is to just grab all choices into one text field in FM from the single SQL field. But is there a way I can map it into a checkbox-formatted Filemaker field for display for my users?

I have a bunch of customer data that is currently in an excel format that I need to enter into my database. When I try to open it with FM7 the fields don't match up. Is this because the first column is being registered as a table? Any suggestions how to speed up process so I don't have to spend weeks cutting and pasting? Thanks...

I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising. The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc. Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially. Thanks

I'm using Troi file to move a package of 16 files (txt) to be import from FMP in a "dedicate folder". I've script my importing (matching, etc)

Thought I had this solution all wrapped up with all the new features of FMP7--and now I discover that one apparently can't import data into more than one table at a time. (Hope I'm wrong!) I've designed this with a separate table for contact numbers (phone, email, etc.). The data is now in an Excel sheet (flat file). How does one move such data into a multiple-table FM solution? RDecker

Does Filemaker have a limit to the quantity of records it can handle, seems to import them all from ODBC but strange things are now happening 155K records, or does this depend more on my system memory etc?

Hello, Is there a way to bridge a FMP7 database to Access and not use SQL or MYSQL? My thought was to link tables from FMP7 to Access. My application will only import and export via access, so what I was looking for was an ODBC driver for FMP7 that would allow me to create an Access bridge. My FMP 7 has no ODBC drivers installed and my FMP 6 ODBC drivers do not work on FMP 7 files. Not to mention the problems with indexed tables in 6. Anyones wisdom on this subject would be great Thanks for your time

I want to make my own bible database in Filemaker 7. Where would I get the bible text in a data format that I can import into filemaker?

Using FP5 I am importing text data from Excel. I am having a problem with 2 pieces of data. The 16 digit credit card number is being rounded at the 15th digit. i.e. 6011222233334444 from Excel comes out as 6011222233334440. Also the expiration data (mm/yy) gets messed up. i.e. 06/06 (June 2006) becomes 6/6/2004. Data on both ends is specified as text. :?

Hello, Years ago I created a Filemaker database for my address book. It now has 900 contacts. I think its time I switch to Apple Address Book. How can I export my filemaker database and import it into Address book? Thanks for any input!

Hi, I have a multiple-file database solution originally developed in FMP3 and recently migrated to v7. I import tab-separated text files to get the data updated. The text files have variable numbers of records and originate on a Windows machine, which I download the data into and then save them to a ZIP file and then transfer them to the Mac for import into FMP7. I was excited that the "import from a folder" option would allow me to put several text files which were to be imported into a single directory and allow a script to import all the records in all the files in that directory. After modifying my script to import a folder and specifying the import as …

Hi I have problems exporting all the rows in a portal. Only the first record is exported. Any hints on how to solve this? (It worked before we upgraded from FM5.5 to FM7) Thanks Thomas

How do I export to CSV (for use in excel) with the headers? Thanks

I'm having a couple of problems in scripting an XML (with XSLT) import, any help would be much appreciated. The 1st problem is not a big deal but annoying: If I use a Calculated path for the XML file (e.g. "filemac:/Public/"&id_number&"/result.xml") FileMaker errors with 'could not open file', a direct pointer to the file works fine though. With 'perform without dialog' off the correct file path appears in the 'HTTP request' box, rather than in the 'File' select. Very odd. The other problem is that the XML files I am importing only have a subset of all the possible tags at any one time. The database I have set up has fields for all the available inputs. …

howdy all, some excel files are giving me a bit of a headache. when i import zipcodes (into fm7) on some files the first zero will drop out. i tried opening the excel file and making sure that the zero's were there and then tried switching the column format around a couple times but that didn't seem to work. anybody have this problem? i was able to make a script to put them back but i figure i'm missing somethin'. thanks! big dan

Hello everyone - I'm working on importing a very large XML file into a FM p6 document. The problem is I don't have an xslt file and the fields change thorughout the XML file. although astehtics is not important. This is my first project working with xml, so I'm not quite sure as to what else to do. any suggestions will be greatly appreciated. thanks.

I have a database called Directory that I have to update weekly. I also have a database set up for each of our clients. We add new records to those db's daily. In order for me to include those new records in the Directory, I have to delete all records and then re-import. Is there a way to enter a new record into any of my db's and that record will show up in the Directory as well? Thanks in advance!! Chris

Hello I lied. I do not yet have FM7, 6 or any othet FM. I may find myself in faced with receiving Access files, having to modify them (make entries), and then having to return them. This will all have to happen in a totally transparent manner to the guy on the other end in the world of MS. I will be a beginner to FM7 if it will do what I require. Can someone confirm that FM7 will do what I require without plugins, add-ons, etc. If these accessories are required who can supply them and are they flexible and simple to use? One possibility is using a Windows simulator on the MAC. If I can avoid this it would be nice. Please excuse the simple nature of my question.…

I'm a real beginner at this...I am trying to import a csv file into an Orders database. I have a csv file (in a format which I cannot change) from an online shop. The file contains Name, Address etc on 1 line and then a new line for each item ordered (containing item, quantity, option, price etc.). The number of lines in the csv file is variable and depends on how many items have been ordered. I would like the Order no, Name, Address etc and line 1 of the order on the first record, Order no, Name, Address etc and line 2 on the 2nd record and so on... How do i script the import to keep going until there are no more order lines? How do i alter the import map…

Hi All Does anybody know if filemaker can read html code directly from a web page into a text field? Thanks

I am having a major problem here. I have two files set up: I run a script on the host file (Sales Order) that sets up some parameters first, then runs a script from the second file (Work Order) to import information from the sales order. My problem is: Right after the import script step has completed, the host file (Sales Order) closes. I cant figure out why this happens!! Any help would be appreciated. -John

Hello. I've been searching for a good Filemaker forum to answer my question. So here I am. Im trying to import from a .csv. I created a filemaker project whose fields names exactly match some of the fields in the .csv to be imported, unfortunately the 'view by: matching names' is greyed out. The other options are not greyed. Why are they greyed out and how do i rectify? repeat: the names in the project exactly match some of the names within the .csv. Not all of them (around 20% are matched up exactly). The Filemaker version that im using is 6. I also tried it in developer 5.5, but still no dice. The platform that Im using is Windows 2000. thanks.