Importing & Exporting

I would like to set up a development version of my Database so that I can use it to continue developing instead of working on the live file. I am hoping that someone will be willing to walk me through the process of setting this up. I know I need to save a sepearate copy of the file to do my development on. Then when I am ready to upgrade the live file I should delete all records in the dev file, import the current records from the live file and replace it with the dev file. My first question is how should I go about deleting all records from the dev file? Is there a way to do it all at once or does it have to be done table by table in which case how would I wri…

Maybe this is an easy one but I'm trying my darndest to pull in some source code from a website into my FileMaker database. I think I've found a way to get just the code I need but I'm running into a quoting issue. I want search the source code for this particular text: As you can imagine, Quote( ) just gives me a bunch of errors. I'm not exactly a pro at using the Quote function, and if there's a way around it that would be fine too. But I'm pulling my hair out. I need to find a way to use that code as my search criteria in a Position function, such as Position(getlayoutobjectattribute("HDSupplyViewer"; "content"); " "; 1; 1) Obviously the above example …

Hello, I have just started working with FileMaker, so forgive me if this is a dumb question. My problem is the following. I have got a massive excel-file with 5 worksheets. The columns are aligned as follows: - A unique ID number - A variable ID (such as ROI for return on investment) - A year - The value of the variable for that specific year and ID Now what I want is that for every unique ID, one record will be created in FileMaker. Problem is, that in excel there are up to 90 rows for every unique ID for a different variable/year. Can anybody help me with this problem?

If I have a table in File 1 and it is sorted by the key field (which is indexed) and I want to import that table into a similar table in File 2, ...is the import faster if both tables are sorted before hand? Christopher

Hi all, Will I be able to move the graphic images from my Excel file into the Filemaker container fields? Any help would be appreciated.

Hi, I am working with an old system which was built as a number of separate files which reference each other, rather than one file with multiple tables. I need some guidance here on good practice when changing layouts. When I have made a layout change, I backup the live version of the file, replace it with my new version, delete all records from my new version and then import all the data from the backup version. This works for most of the files but ... two of the files have lookup fields to each other. So the question is: which one should I import first? Or is there something I can run after importing to make sure ALL lookups get redone? Looking forward to your he…

I have an invoice layout (it's a Form) in my database that I need to export to Excel. Fields are sometimes stacked on top of one another, side by side, etc. When I export as Excel, or Save as Excel, it just lays out all the fields as columns side by side in a table. I need to export this data to excel so it looks like it does on the Form layout. What's the best way to do this? Thanks, Mike

Hi, is there a way of exporting data from a layout to excel and having a row with fieldnames on top? Specifically, can these fieldnames be custom defined? Most of the time fieldnames include programming conventions and abbreviations that don't look nice...

Hi Forum! I want to export to Excel, but, trouble is, I have about 100 cells horizontally to fill per line. It would be a real pain to haveto create 100 fields and then populate them for each record, so Im looking for a simpler way. How about, if I can "build" a string in just one field that contains all the values and then only export that one field? Like so: Exportfield = "test1" & Char ( 9 ) & "test12" & "test13" & "test14" & "¶" & "test15" What I need to know for this is: 1. How would i specify a TAB (Char (9) didnt work) so that it delimits the field and Excel hops to the next field. 2. How do I specify "End of a…

I have a pile of images all called main.jpg. I want to import them into a product catalogue that already has the items as pricelist/manufacturing specs. I would like to rename the jpgs via a dropdown list so I don't have to manually rename every file. They will then be available to customers for downloading for use in their own websites. Any clues? I thought there might be a way via applescript. Cheers Roger

Hi everyone, I would like to import info from an Excel file (may or maynot be in the PC which has FM 10). Is that possible? The idea is to have information imported directly from an iPad by which we will have all the data inputted on the road.. Let me know. Thank you!

FM9 has a 65000 record limit for XLS exports (on Mac OS X). Has this restriction been lifted in FM 11 ? If not, what's a good alternative export format for very large #s of records. Tab-delimited text is fast, but you lose field names.

Hello! I´m working with a solution very well at the moment, but my client wants me to do some update to his data, so the logical thing for me was to only import the data but suddenly when I try to import and select the filemaker file the application tells me "your access privileges do not allow you to perform this action" I´ve been doing this task a lot and never had happen again, I´m loggin this file with the admin account, the one that allows you everything, I try a lot of things: change the name of the other solution file, loggin with different accounts and nothing works! Anyone could help me?: Sincerely BluiSh

I have a situation where i wish to use a call to the system sounds in the Media folder ... now this is in this case done by exporting this from a field - as mentioned in this post: http://fmforums.com/forum/showpost.php?post/359692/ ...it works, but action changes the focus to the OS for a short while. What I would wish for is the omission of the ...is it called "handshake" - if I do something similar under OS X will it continue in the background ... just as if performing an applescript not is expected to be completed when the next scriptmaker step is executed. Could this, what my wife call's a typical "male" way of multi tasking be avoided with Vbscript? …

I want to do something very basic, namely to host a database remotely while being able to safely change the UI on a local version, which I would "upload" periodically (i.e., when I am relatively sure there are no bugs) to the host. I have experimented with the separate-data model but am concerned that it is too complicated to deal with the calculations, which I'd have to include in both UI and data file. So I'm considering moving back to one integrated file and scripting imports for each of my tables. These scripts would delete all records in the local table before importing the host data (i.e., local data would be entirely replaced by host data). I would then replac…

Hi All~ I am trying to export a .csv or .tab file from FMP for import into Bento. When I do this everything works perfectly except for a group of fields arranged in a table. Think Line Item Invoice: Date | QTY | Item Descrip | Unit Price | Total 7/9/10| 1 | Widget | $1 | $1 7/9/10| 2 | medals | $3 | $6 When FMP exports the .csv for this part it will export something like this. 7/9/10 7/9/10 1 2 Widget Medals 1 3 1 6 Basically it's combining the data vertically instead of horizontally. Does anyone have an any idea on how to arrange the data by specific date and item rather than all the dates…

Greetings, I am wondering if it is possible to write a script that can export from Filemaker and Merge into an existing Spreadsheet template. Basically, there is a certain spreadsheet some of our users have always manually filled in. They don't want the raw data format that our FMP exports. Is there a way to make it populate the spreadsheet template for them?

This is driving me nuts. I've used it in so many solutions before... Set Variable [$FilePath; Get(DesktopPath) & GetAsText(Container)] Export Field Contents [Container; $FilePath] I checked the variable, and here's what it contains: /Macintosh HD/Users/michael/Desktop/About Stacks.pdf, yet the script returns "Container Fields cannot be exported." Does anyone have experience with this? Previous posts I found on the subject were not helpful...

I have been working on a using Filemaker Pro to act as a filter application. There are four text files generated when we run AP reports. We have some Access data applications that use the filtered data. The main one imports a CSV file that represents all of the invoices that were entered to the AP system. It is prior to posting. We are checking for dupes. Dupes within the imported data, and dupes against the historic data (back to 2008). The output is the matching data (if found). We are primarily looking for invoices posted once to a wrong vendor, then a second time to the correct vendor. My calculations parsed out the data, and created a CSV fil…

It seems like what I'm trying to do should be easy and common, but I can't figure out a 'clean' method of doing it and I can't find any other posts where someone has tried something similar. We publish newsletters. I have two databases that contain addresses (among other things). One contains our advertisers and the other contains residents. Currently, I have the addresses export into two separate files (per area) with a single script. Then they are both imported separately into the USPS software. I'm always trying to find a way to make things faster and it would save a lot of time if I could find a way to have addresses from both databases exported into a single fil…

Does Filemaker Pro not have a way to "undo" the accidental deletion of a record? For example, when trying to delete a child record within a portal but the entire parent record gets deleted, is there no way to get that data back?

Is there a quick and easy way to move a database, which has container fields that are linked to image files, without breaking the links to those files?

I am having a little problem with importing and exporting. The real-time setting will have data files on J: (in the root of J). Files are named in a format incorporating the date to the name. The output will go to C:Lilly (long story and a dumb one). Output will be to a file that is rewritten daily, because they are interfacing to a program that is hardcoded for the input name. My FMPro runtime will be a datafilter. I am reading spooled accounting reports, cleaning the data to produce csv files. When opening the runtime the user will be presented with a menu of which filter to run. I then want the IMPORT command to open to the J: and pause for the…

According to the FM Knowledge Base Import/Export script on FM Server: FileMaker Server can only import from and Export to the following locations: * When using the Import Records script step or Export Records script step in a FileMaker Server scheduled script, keep the following in mind: * o Any specified file must be in the Documents folder, the temporary folder, or a child folder of either the Documents folder or the temporary folder. For example, the following are all valid paths for file.csv: /file.csv /file.csv /Folder1/file.csv /Folder1/Folder2/Folder3/Folder4/file.csv S…

I have FileMaker Pro 10. It has a music database. I am able to import using Excel the artist name, the album cover and so forth. But how can I import all the tracks of an album without having to type it all in the FileMaker Pro program. The program header is tracks. You type in the track name and it automatically numbers it as number 1 so on, then you put in the time of the track. Is there a better way. Becuase this is very tedious. Thank you.

I'm struggling with importing data where there are related fields to be linked. I have an excel file which I want to import. Each row of the file contains information which relates to an event i.e. Date, place, etc and also information on a related person i.e first name, last name etc. The tables Event & Person are related tables. It seems I can only import into 1 table at a time so how do I go about populating both tables from my Excel file and linking them so the fields appear correctly in my layout.

Hi Everyone, I'm trying to connect via jdbc to a filemaker database that is opened, hosted and shared by a FileMaker Pro client machine. I was able to connect to the file locally on the same machine that the client runs on but I am unable to make the same connection over the network by using the IP address of the computer. Any ideas or pointers? Thank you.

Hi, I am pretty new to Filemaker so please be patient with me:) My problem - I have a layout which shows multiple records in form view, where each record consists of multiple related tables (Events & Persons). I can obviously type an entry directly into the layout and it populates both tables. So, how do I do this as an import since the import only allows me to import to one table at a time. I am currenlty able to do this but it takes a lot of manipulation since I have to create the data first in the "persons" table in order to get their "key" and then add that key to a new import file to populate the "event" table with. What techniques can be use…

Does Filemaker not support dragging and dropping images into container fields? Seems like this would be a basic capability, especially when working with a Mac. I have a database of many individuals and each individual has a variety of photos associated with it (child records). I would like to just drag and drop the appropriate images into a container that I have in a portal for each individual. Possible?

Our AP master file is huge and data has been around forever. We just upgraded from the DOS_version to the Win_version (I want my DOS_version back). Back when the AP adminstrator only followed one rule, CAPS only. Commas were used: Horton, Horton, and Smith, Inc. as an example. I need to develop new tools to parse the data from the spooled report files. The reports have no delimiters. Just pure text. The commas in some names are skewing import. I am importing as ALL FILES. Not csv or tab when I select file type. At end of day, every day, I spool a report of the AP Batch Edit Listing. For each invoice keyed there is only one line of important info.…

I am trying to export a field that is a return separated list. It is a list of all chimpanzees who are together in a group at a given time. One particular record might look like this in Filemaker: BAR JOL LIL BT BS When I export it to Excel it looks like this: BARJOLLILBTBS But I need it to look like this when it gets to Excel: BAR JOL LIL BT BS Is there a way to do this?

Hello, I must preface this post with a warning that I am brand new to the world of filemaker. I work for a company doing bail bonds and am trying to find a simple way to create layouts for our bond forms. The bonds are usually provided to us in word format from the city or county. I'm wondering if there is a way to import the content from the word document into a new layout and preserve the formatting so I can simply add editable fields wherever they are necessary. I poked around a bit on the forums and can't find a topic related to this. I may not be searching for the correct terminology as I'm very new to this.

I've just discovered BruceR's technique of using export/import from folder to build a multi-key global. Wow. Huge speed gain over looping. I'd love to treat this as a subscript, but Export script step is table dependent. I suppose I could use a scriptparameter and conditionals to determine from which table I'm exporting, and then have multiple Exports, but I want the ultimate, modular export. Any suggestions?

Can someone help me? I have a flat data base that has about 20,000 records in FM 8.5 advance. The problem is that it was not set up right so one client maybe in the database multiple times. I am designing a new database in FM 11 Pro to have a one to many relationship. One Client to Many animals . I need to transfer the information into the new database and assign each client an ID number. For example: Sue Smith has 25 records in the 1st database. I want to import Sue Smith into the new database (client table) and give her an ID number and only have one record for her in the client table. Then I also need to assign an ID number to each animal that Sue Smith owns and add …

In terms of table fields, I was wondering if it could be possible to create an import template, which I could later use once I decide to work on my final Filemaker file. The idea is be able to study and remove unnecessarily fields from a current .dbf file during import mode, once I have already deciphered which will be the last version to use in production, when everything runs on Filemaker. What I want to avoid is to start depending on my testing Filemaker file, to be used as the final working file. I prefer to have several things being tested in one place, and then if it will work as desired, then I import them into my final Filemaker file which will work in produc…

I have a local server based version of a filemaker database that all of our inside sales and support people run, but out sales people also take a copy of this database with them on the road as a runtime solution. There are 4 main tables in this database get updated by our people on the road. Meanwhile the people back at HQ are also modifying the data. So the question is twofold - what is the best way to merge these two databases together or 2) is there a better way to build the database with a minimal amount of tables to make the merging process streamlined. RIght now I do it by script based on record ID number and modification date, but sometimes one record is being …

Hello! I get a CSV file from our main frame every night containing prices. They cant see what has changed and only send that, so they send all each night. I need to be up to date and import all to our Filemaker 10 Server Advanced table every night. I need to find a quick way of doing it. So far the best I have found is to first delete all records in the table and then import the total file. But still it takes many ours ... Any ideas of how to do it is very appreciated! /Henrik

Hi every time I move a db to a back up drive I need to create again all the references. At times this is very time consuming. Is there a way to keep the various DB so all layout and data will stay linked even in a different machine? Thanks a lot.

I have deleted some records from a large DB file by mistake. I have a backup of the file and the records but I don't know which records were deleted. However, the backup DB does not contain some modifications which I made to the current DB and which I would like to keep e.g. relationships and scripts. What is the best for me to import the data from the old file (e.g. do I match fields? and reimport all the data) without messing up my existing database? Many thanks.

Hi, I have many banking transactions and various scanned receipts (not every transaction has a receipt). I am trying to find a way to use the feature of "import file" and import all scanned receipts. The problem is that I want those receipts to correspond to the appropriate transaction. Is there any way to do this in a way that makes sense? Thanks, jimmy

I have been working on my babies' records database and am now matching siblings based on the HouseholdID I set before. Here is the script I wrote for the siblings' matching case, but it is not working - it stopped after the first baby record. Could anybody take a look at it and enlighten me? ps I have two tables Household and Babies, and each baby is assigned a babyID and a householdID. Siblings should have the same householdID. I suspect that the double loops don't work because of the layout and actions I set for each loop, but no idea what is wrong. Thanks a lot!

In a record having a name field and a repeating field (say 5 repetitions), is there a way to create five records having the (same) name and one of each of the 5 repetitions.

Does anyone know how to export data from FMPro7 into a csv (excel) file and include the field names? I can move the field content with no problems, but I have to type in the field names manually into excel. The field names do export successfully if I export as an html file - so I'm looking for info. on how to do the same into an excel file.

Can anyone help? Filemaker adds a single space before the field contents when I export text data. I'm exporting six fields for use in an Excel spreadsheet - running Filemaker Pro Advanced on a Mac running Mac OS X v 10.5.8 Each time I export, whether it's a Tab sep or a Comma sep file, Filemaker adds a single space before the field data. Strangely it doesn't do this for the fields from the first record, or for number fields, but all other text fields get a space added before them. Any suggestions as to how I can stop this gratefully received!

Hi, I have an error appearing only on one Mac at present, whenever I run an export script that states "Some of the files that are needed are either damaged or have not been installed. Please run the installer to correct this problem. I found a knowledgebase article referring to this message when launching v9, but I'm only seeing it when trying to run an export script in v10. If I export using the File Menu, it works fine. I deleted the file mentioned in the article and the Filemaker app folder anyway, and reinstalled. I'm not the developer of the database, so can't access the script to tell you what steps are involved. Does anyone have any ideas? I'm t…

Hi, I have a field called Sources_and_Dates which basically includes the sources information (text field) with the dates info (date field). Now I would like to separate this big text field into two separate fields with the corresponding field types. And later on I would like to export them into two different fields in another table. Can I do that? Also, ideally in the future I would like to have the Source field be a drop-down menu and the Date field be a calendar type. Can I change that after I export the existing data? Please advice. Thank you so much! ???

Hi I have 10 fields in my DB (pic1 .... pic10) plus other info for each record. I would like to export them to a folder using another field as a name for each .jpg I know filemaker does not allow to export containers but using the "export field command" asks for the folder and the new name and this is really time consuming for me as I have several hundred Image Fields. Can anyone give me a hint? Thanks a lot

06-01-10 04:41 PM - Post#40777 First of all, my apologies for being dense about this, but I am just not getting it right. I’m pretty sure the answer is easy and obvious (just not to me). I have a layout with: 1. A container field with a picture of a school (School address::School Picture) 2. A text field with the name of the school (School address::School Name) I want to export the picture into a folder on my desktop and name it with the corresponding name. I have a Set Variable script to create a variable called “$schoolName” Set Variable: [$schoolName; Value: School address::School Name & “.jpg”] (I created a test field an…

Hi there, I have a script exporting some .csv files to a shared location / server. I run this script manually from a local machine. But despite the fact that the directory/folder where these files are exported is read/write, the files have 'read only' permissions and can thus not be 'overwritten' by the other users. How can I ensure that the exported files are being read & write ? Thank you in advance for your help.

Hi FM users, I'm pulling my hair out and hoping you can help me... I've created a database for a research project I'm running at the moment and want to be able to use the send mail function. I want to be able to use information that I have inputed into fields and use this information in emails that are personalised based upon the record. My DB is set up like this... I have a 3 or 4 tables in my scenario, like: counsellors, clients, phonelog, and emaillog etc. The counsellors table stores all my contacts information and details. The clients, phonelog and emaillog are all related via a counsellor ID and store information pertaining to one counsello…

Hi, I am somewhat new to filemaker and have started to create a financial db of all my transactions for my personal use. Other than the table i created called "Transactions" i have a related table called "receipts". When in a transaction, i click on a button to create a related record in receipts. My problem is the container field. Instead of for each transaction the requires a receipt (not all transactions have receipts) I am inserting the proper receipt. This is tedious and lengthy. What i wish to do is to create a script that will import all my receipts. I would like to name each receipt (manually is my only choice) with the name of the "serial_id" of th…

Hello, My users need to import similar data into filemaker9 via a excel spreadsheet. They always use the same template, but they are not very computer savy and don't want to use the import utility. I would like to automate the process for them --- put a button on a form and the import happens automatically without prompting. Sounds like something like this is available in v11, "recurring import", but we are using v9. Any ideas? Regards, Zenon

I am trying to move records between two FM files. The source is a file called Recipe Ingredients which has fields Recipe ID# and Ingredient ID#. The Target is a Shopping List file which also contains these same 2 fields Recipe ID# and Ingredient ID#. The two files are related through the Recipe ID# fields (I have tried the Ingredient ID# a the relating field as well but the same problem occurs) I do a find in the Recipe Ingredient file for all Ingredients for a specific Recipe, then an Import in the Shopping List file. I have tested this and it works fine. The Import definition has the Source and Target specified as previously mentioned. I have matched up the 2 …

Hi, I am trying to export several images from several databases into a folder in a different Backup disk. I tried several scripts I found but none seems to work. Example: Go to Record/Request/Page [ First ] Loop Set Variable [ $filePath; Value:"filemac:" & Get ( DesktopPath ) & "/ExportedFolder/" & Table::SerialID & ".jpg" ] Export Field Contents [ Table::ImageField; “$filePath” ] Go to Record/Request/Page [ Next; Exit after last ] End Loop My problems: Unfortunately the various images are jpg. bmp. and so on so I need filemaker to recognize the image extension. I need to change the pictures name as in the db I…

Here's what I need to get FM to do through a web site: 1) Client creates an account on the web that is verified through email 2) Once every 24 hrs, client may log in. 2a) FM accesses Acrobat file (Using PDF Manipulator plug-in) to put a serial number into 15 different PDFs and creates 15 new PDFs that are locked down and then pushed to the client either directly, or emailed to the client. 3) 24 hours later the customized PDFs are deleted from the server. OK, so my main hosting service (MacHighway) would handle the html files with Lasso calls and the base versions of the PDFs. The FM hosting service (Digital Forest) would handle the FM 10 db a…

Hi all, For my business, I need to print some pages of a large PDF files. Each multi-page PDF has its own record and is stored in a container field (other solutions are possible). I've stored, also, the exact number page to print. I'm looking for any automatic solution (Script? Multiple field? Applescript?...) Help me! I'm sure that exists a solution useful for all! My background MAC X 10.6.3 FMP 11 ADV Example PDF FILE (i.e. “Annual report 2008.pdf” - 1000+ pages) imported with ->insert->quicktime (or, in alternative, ->insert->image) PAGES TO PRINT: 34,35,77,78,79,301.

Hello all, I have used Filemaker for many years, but only in fairly rudimentary ways. As one of a group of people doing audio preservation work, I recently downloaded the listserv archives for Studer open-reel tape recorders and found that they are extremely difficult to use as huge, continuous blocks of text. Last night I spent a few hours massaging and cleaning up the text a bit in TextWrangler, and have now imported the seven archived text files into Filemaker in the most basic mode, where Filemaker supplies simple numbered fields. The basic structure of the listserve is intact, and there are nearly 11,000 records. I would now like to make this database reas…

Without using SuperContainer, are there some best practices listed somewhere that ensure the best performance when loading up a solution with images etc. In my case I was considering capturing a scanned version of a doc to keep as a reference against the key'd in version. One thought was to create a separate file and externally reference them. Also to make sure they are scanned in at screen resolution and in black & white. Am I on track?

I'm wondering if anybody has experience these issues when using FMP to export data into an excel workbook for Mac? Our main issues seem to be with dates. For example, if a user chooses to export by Excel and then they copy a date field into a new excel document, it will change the date from 4/2/2010 to 4/3/2014. The date fields being exported are actual date fields, and they are being copied into an excel file that utilizes date fields. We have many more issues with excel, but lets see if we can't tackle this one first.

hi, If someone has asked me to supply them with a .txt file, is that basically the same as a .tab or .csv file?

Hi I am very basic user of FMP and I am now trying to "break" one field with text into different field for each information extracted from that field. I hope to use this process to create a record for each student. This is a sample page my students send me and I imported in a FMP database in a field called letter. In the DB I also have date and other fields. Name: John Surname: XXX Birth: 27/03/1984 Class: Nationality: Greek City: Salonicco Gender: M Option A : WRITIER Option B: Whatever Option C: Suggestion A: Joyce Suggestion B: Previous Classes: Student Id: AZ56345 Telephone: 1234567890 As the questions where optional I cann…

I need to generate a Tab-Separated file from FileMaker Pro. The file is to be imported by Avid Media Composer, which is a video editing program. The program expects the tabbed file to be in a very specific format, specifically to have a mix of Header rows followed by a straightforward set of columns and rows (see screenshot below) The tricky thing is, the last word in each header row is followed by a carriage return. So, if you use your arrow keys on your keyboard to move through the text to find the tabs, after the word "Heading" you're brought down to the beginning of the next row. In a standard Tab-Separated file, you would have tabs after the word "H…

I have spent a number of hours defining fields in a table. I now need to recreate an exact copy of that table in the same file so that I don't have to spend hours defining all of those fields again and redoing all of the options for each field when they only need minor adjustments. I have found a solution whereby you can export the fields of that table as an FM file and then import back into the file creating a new table from the imported file. Only problem with this solution is that the workings/options for these fields do not import - only the field tags/defintions themselves. Does anybody have any solution without resorting to having to purchase FM advanced …

Not sure if this is in the right topic group, so apologies if incorrectly positioned. Is there a way to save/export an FM record as a pdf to include fields that are editable, ie the user can type into the field space provided. If this is not possible, does anyone know of a way to merge multiple records from a data source with a pre-designed editable PDF form? I know there is an Acrobat plug-in for Windows users that performs this task, however I am unsure if anything does this for Mac. Any help appreciated.

My target is to allocate specific numbers to my 963 existing records. The number needs to increase by 1 every 5 records. So records 1 - 5 are all allocated number 1, 6-10 2, 10-15 : 3 and so on. I have created a new field for this new number to be displayed in but I can't work out how to auto-enter the data I require. Any help would be gratefully received - thanks!

Hello, my client used an old version filemaker, export the data to excel doc. I saved the excel doc to csv and then covert the csv to xml. Here is my problem. 1) the filmaker generated excel has some weird character, one looks like the female sign. These weird characters cause the parse xml parse error. What are these weird characters? How to get rid off them? 2) in the filemaker generated excel sheet. there are some invisible characters (usually it is in the end of the data in a cell. This cell may have the data merged from different cell of the fileMaker database.), causing the xml parsing error, when I covert this excel to xml. The xml parsing e…

I'm guessing to post here... I'm trying to see if there's something I can add to my script to keep it moving faster by keeping the connection active (??) In short: I'm downloading/importing XML thru the web I'm using a looped script - input info in a custom dialog window (by barcode scanner which then activates the 'enter' button to continue the script) - download - pause and wait for next request. The first request usually takes 5-6 secs to come back. A 2nd, 3rd, 4th, etc. request if done within a very short period of time in between comes back in maybe 1-2 sec.'s If I wait say 10 sec's or so to input and continue the script with a request th…

I'm wondering if any of you fine folks have used www.batchgeo.com to make maps of customers. It's looks great, but I'm trying to cut out the manual steps on cutting and pasting it to the website. Any suggestion?

I've got a simple spreadsheet that I want to import. The problem is that I've got a date column that I didn't format as a date. It's actually two columns of text data, one showing the day of week and one showing the day of the month. I've attached an image to illustrate. The only solution I can think of is to import the data without those two columns and add an empty date field. Then my query becomes: how do I enter a sequence of dates? Could I use Replace Field Contents with a series of numbers that could be then converted to dates? Or is there a way to do this with a calculation?

I am new at the company where I work. It is a publishing company. I know very little about FileMaker. Here is the situation. The company has an old FileMaker database that was set up during the 1990s. The editorial staff loves the FileMaker database. Or, rather, they are used to it. They interview people, and somehow input the text of the interviews into FileMaker. Elsewhere in the company, there is an art/design staff that pulls data from FileMaker, and they turn this into the monthly magazine. I am working with the tech team that enables the web site. The website works with a MySql database, and runs using PHP. Here is how things are handled: …

I was wondering if there was an automated (commercial) way of capturing a signature for the mac on Filemaker 9. I've looked but I have only seen a plugin for the PC.

I want to delete the last three words when I import records into a DB - this is how the whole string looks: Mr John Doe 2009 Size: 12-13 This is what I want: Mr John Doe It needs to be worked around deleting the right hand words because the number on the left vary (e.g. there could be Mr John Henry Doe) What is the expression for deletion of RightWords - e.g. deleting rather than returning the found text? Thx for any help.

U heeft deelgenomen aan de . We verzoeken u vriendelijk onderstaande vragen te beantwoorden ter evaluatie etc. Deze vraag heeft betrekking op docent - -

Hello - Currently I am running FM8.5 Advanced on a Windows 7 PC. I have cataloged all my products based on part numbers with almost all the information I need. I have MSWord Instructions for all these parts that are istting in a folder. I would like to make it so I can paste/or access the corresponding instructions so that I can print them as a report from FM. Several of these instructions have images associated in the word document, and we would like to keep them as closely formated as possible. I have made a text field in my database for instructions, and I have attempted to "paste special" but it is not giving me an option for MS Word formatt…

OK this is a very odd request (clients eh?!) A system manager requires an export to native XLS Excel file (ready for a very inflexible accounting system) from multi line item records to be shown on one long line for each master record. Example for simplicity: [color:blue]Master Record, Orders OrderCode, OrderDate, OrderInfo etc [color:blue]Related Lines OrderLines(1 or more): Item, Cost, Tax Now they want an export file from this data which will show the following: OrderCode, OrderDate, OrderInfo, Item(line1), Cost(line1), Tax(line1), Item(line2), Cost(line2), Tax(line2), Item(lineN), Cost(lineN), Tax(lineN) Added for clarity - Each field n…

Hey there, I have one database on the server that I would like to grab data from and display in another database on the same server. I am wondering if this is possible to do rather than just exporting data from one and importing it into another. Thanks!

Hi all - Please forgive my ignorance but I want to import to one table in a master file from the same table in a copy of that file - and I am having problems. I go File > Import... and double click on the file I want to import from. This brings up the Import Field Mapping dialogue. In the Source I select the table I want to import from. However, in the Target I find that the table I want to import to is "grayed out" and cannot be selected. I can of course select "New Table" and that creates a new table (with the data I want to import in it)... but then I cannot get the data across from the new table to the old (master) table... (same problem as abo…

Once again, cerebral density has raised its ugly head (that's why I don't post a picture of myself) I have a runtime that I want to be able to import records with from the desktop. The problem is, the runtime doesn't "know" how to map the Source fields to the Target fields for import in the Import Field Mapping windoid. (The Source side is blank.) How do I code the Import Records script step so it'll pre-match the field names ("arrange by: matching names")so the import can take place? TIA for your help, Rich

Has anyone had any experience in integrating a Filemaker database with osCommerce? I would like to use Filemaker to update my products within osCommerce and also osCommerce to update my stock levels within Filemaker. Has anyone got any suggestions on any other cart software that may be useful? Thanks in advance Lee

After several hours reading my FMP 8 book and searching these forums, I am still stuck. I'm sure this has been covered and if so, please point me to the thread. I am importing a single line of .csv and want to import it into my FMP database. I know how to import and select the fields to match. What I am having difficulty with is how to handle the field that looks like this: Pick n Click:1:$29.99:$29.99|Pick n Click Extended:1:$25.00:$25.00|Choose Theme:Winter Fun::|Add Extra DVD(s):2:$10.00:$20.00|Project Name:You re in Utah::|Mail Files:1:: I tried to split it into separate columns in Excel by the | and then the :. The problem is that I have multiple p…

In a kind of CRM fashion, I would like to keep track of certain emails that I send to potential clients, (usually from Craigslist ads) how many times I've written, and when to write again. This information would be visible in my dashboard of my existing system. Now, in Bento, one can insert a mail document and it looks pretty nice. Is anything like this possible in FileMaker? In FileMaker I can create a container field and import the file, but it really is not nearly as nice as Bento. For one thing, the file looks like this: 8223.emlx rather than this: [email protected]. Also, in Bento, I can do a Quick Look and read the email. However, I am in my Fil…

Hi there I have a simple question. I have a client data base that I'm reorganizing. Simply.. I have files ( tables? entries? ) that I want to copy to a duplicate filemaker file ( with same title fields exactly ) In excel I could just highlight each entry and copy it over no problems. I have no idea how to do this with Filemaker. If anyone could help I would greatly appreciate it ! : ) Troubled in Toronto

Hi all, first post here due to a mystery. I recently exported a bunch of images from a legacy FileMaker Pro database, using FM Pro Migrator. But I'm not convinced I've got everything, because the file sizes don't add up: The exported database text is 218 Kilobytes The exported images are 109 Megabytes The original database file is 1.7 Gigabytes I seem to have images for every record, but most of them are tiny (7 KB files with dimensions of 320 x 256). Others are larger (e.g. 2.2 MB file with 2592 x 1944 dimensions), but these are a minority. And there's that huge difference between the size of the database file and the size of the exported …

I need to convert data in FileMaker databases to another database program, using Excel as the intermediary. But only the first entry in repeating fields is exported to Excel. Is there any way to solve this?

Hello everyone, I am new to FileMaker and I am trying the FileMaker Pro 11, running windows Vista. The thing is, I have a database and need to export some .txt files in a centain layout to a third party database. I have the following fields on a table called Results: Protocol Password Name E-mail Results I need it to export just like this for each record set a different file. Protocol Value Password Value Name Value E-mail Value Results Value The thing is, when I use the export field content and use as path the same path as the previous field, it overwrittes the text instead of adding it to a second line. And when I try to make a ca…

I have attached this jpg... it shows a field called 'text_fax' When emailed is left justify,,, Not like what on layout, printed or faxed In Layout text right justified.. When emailing just sending out the field.... its left justifing as per display.. After lots of thought...I stumped trying to figure how, i went wrong or able to even email in the same format with what i got? TIA

I know there is a good explanation for this but to me it just seems glitchy. I created a container field and a button used to “store as a reference only” a pdf file. I also created a calculation field to show the path for troubleshooting. Sometimes it stores the path differently and I don’t understand why. Example - file:../Incoming/Drawings/FB/Area/Lines/12540_00.pdf filewin:/Z:/RFT/ Incoming/Drawings/FB/Area/Lines/12540_00.pdf in other records it will show the same file as file:12540_00.pdf filewin:/Z:/RFT/ Incoming/Drawings/FB/Area/Lines/12540_00.pdf This database is going to be used by Mac and PC users. I would like to figure…

Hi - not sure if this is the appropriate forum - if not please redirect me! Is it possible to manipulate directory structures and files via Filemaker? I'm creating an image database for a volunteer organization which will be used for storing and organizing photographs donated by many people. I've set up a directory into which new images can be copied, then a scripted process is run that imports the image as a record with a file reference and an embedded thumbnail. So far so good. What I'd like to have happen next is for the original image to be renamed to a database provided running number (eg 1234.jpg) and moved to an archive directory (the "web" directo…

Hi all, I have a table that contains the following fields: Part Number, Code, Qty and Total and have created a summary report based on Part Number and Code. The report displays fine, but I’m trying to get my exported data to look like my report and my export is putting a blank Part Number field until the next break field and I need the code field to always reflect its part number. Stumped Please help :-( Anthony Test_Export.zip

Hi everybody, I have a field "member type" that contain multiple information such as MLS, or Primary or secondary. SOme field even have MLS and Primary on the same field. My problem is that im trying to import them to a checkbox field that contain all variations, but the fields that have multiple fields for example MLS and Primary don't show up on my checkbox at all. I need to find a way for the checkbox to show both fields checked. hope this makes sense.

I need to create an excel BOM for our overseas plant. I created a script that performs 4 other scripts that gen an excel file depending on a layout. 17 : Import & Export Scripts: 17-0001 BOM Excel Export Main Allow User Abort [ On ] Set Error Capture [ On ] Freeze Window Move/Resize Window [ Current Window; Height: 5; Width: 5; Top: 5; Left: 5 ] #1 Export Fabrics Perform Script [ “17-0050 BOM Excel Export Fabrics”; Parameter: " " ] #2 Export Trims & Notions Perform Script [ “17-0055 BOM Excel Export Trims & Notions”; Parameter: " " ] #3 Export Car & Content Perform Script [ “17-0060 BOM Excel Export Care & Content”; Parame…

I would like to import a text file that is just over 6000 characters in length and needs to be imported into 526 columns. I can export to Excel 2007 and then import, but I was hoping to use FM directly. This file size is a standard record file from the government and their reference file tells us where the columns are in fixed length within this file. FM does not handle fixed length as an import option and the government will not change to a CSV or delimited file format. Any suggestions are welcomed.

Hi everyone, I'm new to filemaker and have been doing fairly well to this point. I have a question relating to exporting a record into a specific XML format. I have a database with customer/product records. I would like to be able to export these as XML so that I can import them into Acrobat Pro 10 to "fill in" a form. I know I can export XML from FM10 but I am unsure how to specific the field names, etc to make the file properly formatted for the form. I'm not overly familiar with XSL Sheets but think it would come into play here. If there as an easier way to pump this data into Acrobat I'm open to suggestions. Thanks for your help and patience. Marc

Suppose an excel file is created by my shopping cart every day,the file contains order details on that day The excel file contain 3 field, namely: 1: order number 2: first name 3: last name when the file is imported to filemaker: 1: if the order number in the excel files exists in one of the filemaker record, filemaker will UPDATE that record 2: if the order number in the excel files dont exist in any filemaker record , a new record is CREATED May I know how I can do this? Thank you

Hi everyone, This is a quick and probably simple question to answer but i haven't been able to find anything on Google, so here goes... How can i copy an active record from one table to another table within the same database? The other table is a shadow table via ODBC, but to all intensive purposes is just another table for this question. I'm thinking it has to do with executing a find set using the current record ID, changing to the shadow table layout and then importing, but it's the first time i've tried something like this. Can someone guide me through this please? By the way, the functionality will go in a script run by a button on the current act…

I have 37 records on a layout. When I export to an Excel file only 5 show up. Any thoughts on what I'm doing wrong?

I am not an Excel user I have a FM table of 25 records already.. ..and wand to import from my test .xls file.. of 3 records. ..but when I import I am getting 53 records.. my 3 but and then its filling in about 25 blanks too? Thanks

I have a script that imports any number of records & there related records into a solution. Lets say Contact Table Records & Related Address Table Records & Tel Numbers stored in separate tables. The data file being populated is hosted on fm server & shared by a large number of users all capable of creating records. Any user can import data & add records. Anyone got any thoughts on the best way to do deal with attributing the correct serial numbers that the records will receive when they are added to the main data file and how i should pass that to the new related records before they are imported as this new serial will be there ID field…

Short and sweet: How do I script an export of records to a folder residing on a flash drive (using a runtime solution which will reside on the flash drive)? I just can't figure out how to set the path in the Export script step since the flash drive's drive letter will be different for every user. Me thinks I may need a plug-in, but I'm not sure. I'd also like to code it so the script will work on a Mac and PC. TIA in advance for your help!

Is there a way to store email addresses so that an email client and FileMaker both use the same data. For example, store data in Apple's Address Book and have FileMaker use this data. The ability to change data from either the email client or FileMaker would be an added bonus.