Importing & Exporting

Hi, I am trying to import information from an excel file while maintaining the relationship. This excel file has 3 sheets, each corresponding to the 3 tables: People, Object, and Measurement. This is a one to many relationship with a person having multiple object and each object having multiple measurements. These objects are related by the primary key in the people table. Here is a simplified version of what the excel file would look like People (sheet 1) pk_personID LastName FirstName Object (sheet 2) fk_personID pk_ObjectID ObjectNumber ObjectName Measurement (sheet 3) fk_personID fk_ObjectID pk_MeasurementID MeasurementA Mea…

I need to export a set of records including all the related information into an XML file. For example, the primary record is a book and I have another table containing all the authors related to a particular book and another table containing all the related marketing descriptions - and so on. Is there any way to export an XML file and have it include all the related records - i.e for all four authors related to the book? Any help or pointing in the right direction very much appreciated.

Am I right in saying that I can not export using the "group by" options when the script is run from the server?

Dear friends, I am importing data from Excel, where I only need part of the data to make it match a look up. Since I am a newbie it is bit hard to explain, but here is an example: I have data saying; 'Yes, I hereby confirm that I will pay 9.000 $' 'Yes, I hereby confirm that I will pay 7.000 $' 'No, I will not pay 7.000 $' 'No, I will not pay 12.000 $' My problem I need it to be either 'Yes' or 'No' to match a look up later in the script. Can anybody help?

I have a problems with Export Field Content script step when I create a Runtime package. The script saves an image from a container to disk using the full version of Filemaker, However when I create the runtime engine it gives an error that the file cannot be written, disk is lock or damage? Any ideas? Thanks Otto

Hi, I'm designing the ability to update versions into a runtime solution by exporting the data and importing it into the new version, but I can't seem to figure out how to export and import global fields. I understand that in a normal Export Records command that global fields will be treated as non–globals and hence every record will have the same entries, but is there any other way to get the global fields into my new version? In addition, is there any way to export/import container fields, or will my customers have to go through and insert the items all over again? Thanks! --Myles

Hi, I have a few checkbox fields in my layout that I want to export to Excel. The problem is when I do this I get some very weird results and strange characters. Is there a secret overall to exporting check-box value fields into Excel, where they are actually usable? i.e, look correct, can do calculations etc etc. One thing I did in Filemaker to get rid of the actual checkbox logos themselves in tableview was do a substitute field. Substitute(Field1; "¶"; ",") This stores the checked values with a comma between them in FMP, but I still dont get the correct results when exporting to Excel. Basically, is it BAD to use checkbox fields if you want to export your data to Excel…

I have been given samples from others of how to do certain things in their layouts. Is it possible to just import the layout from another created DB and transferring over all of the fields, scripts, etc.?

Can someone point me as to why this import isn't working: Set Variable [ $importdir; Value:Moo_DialogFolder ] Send Event [ open document/application; "cmd /c cd " & $importdir & "&&" & "dir /b > filelist.txt" ] [ Bring application to foreground ] Pause/Resume Script [ Duration (seconds): 3 ] Import Records [ Source: “filewin:/$importdir & filelist.txt”; Target: “IMAGES”; Method: Add; Character Set: “Windows ANSI”; Field Mapping: Source field 1 import to IMAGES::IMAGE1 ] The first step opens a dialog box to select a folder, saves it as $importdir variable. Works fine Second step sends windows an event to open a cmd prompt and crea…

I'm not sure what the best way to do this is.... We have data that is created within an FMP based system. One department would like to be able to regularly export found sets into excel, however since the resulting excel documents are forwarded on to clients they are fairly heavily formatted. There are some breaks and color etc. On the formatted excel sheet the first 30 rows or so are taken up with header type information. I'm not aware of a way to apply substantial excel formatting within FMP. I'm looking for workflow suggestions. Perhaps once records are exported into an excel sheet they could be imported into a blank formatted excel document? I'm not ver…

I am importing and updating mutilple records based on "Matching" an UID. Was trying to stay away from creating an additional import table. Was wondering if there is a way to identify when a matching record is not found. Tried setting error code on, but get no error whether the matching record is found or not.

I'm trying to join my existing customer management database with the "resource scheduling" stock template that comes with FM7. I could implement a dispatch facet to my existing database with this. I know one can import scripts and records. Is it possible to import tables, relationships, and layous from another database file?

Hello all, I recently started learning filemaker pro 10.0v3 (2 hours!!) on Mac OS X 10.5.8. Here s my scenario I get mails every 4 hours from a remote measurement site with measurement values. The files are in *.csv format and the filenames are XX-2011-00001.csv and YY-2011-00001.csv. These are data of two instruments continuously running with different sampling intervals. The files are stored in local folders. I want to develop a script that would read a file (example: XX-2011-00001.csv) and uploads the data in the database and after updating the database the .csv file should be moved to another folder for backup purposes. After 4 hours the script sh…

Hi guys, I have a sort of tricky situation with data flow in this particular DB. I have a master DB that resides on a FMP Server at work. I have a "mobile version" of that Database that resides on the Desktop/iPad for data collection. We can not access the Network on our iPad hence the need for the multiple copies. There are a couple things I am wondering about, mainly if there is a safer way to do it....Currently the DB has one table with "Look-Up" fields. This data is pre-loaded into the DB and serves as a visual reference for a certain layout. That said, the process we have now is the following... -Load look-up field data into Mobile DB via Excel on De…

Hi again, I have an Excel file that I import data from into my DB. One of the fields, called "SIID" has been set up in the data-base as a unique value field, with a custom message appearing if a value is entered that is not unique. It works fine if the SIID is entered right into FMP, the warning pops up "You have already entered....". An import from Excel however does not catch this. I was able to import the same SIID 3-4 times. Any way around this? Thanks

Hi guys -- I've a large excel file that I need to import into a DB in FM 5.5, some of the excel data is in Hebrew and when I do the importing all Hebrew data is imported into FM as totally blank fields. How can I make the Hebrew characters import correctly? Best!

Sorry if this has already been asked, but I wasn't able to find an answer. I'm trying to set up a link from within my Filemaker database that would open a specified folder (in this case, the file path would be based on a calculation). I'm currently using Container fields to display images stored in a folder. Essentially, all I'm trying to do is include a link on that screen that would open that folder up. The caveat, potentially, is that the container fields aren't permanent. They're just global fields that pull in the appropriate image when someone wants to view it. Since all the actual image files are saved on a server, the need was only to be able to view t…

I am confused again. If I create a new file and export, it shows character set 'windows ANSI' and allows me to change it if I wish. Right now I am afraid to because I figure the default must be best. Here is my issue when I script import I am not given option for character set but after I leave the script it shows windows ANSI. My problem is that scripted import of excel sheet breaks on mac and I wonder if this is why. Does Mac understand Windows ANSI? If the import is going to happen on both OS' do I need to branch my script with two different imports? Ok. Why UTF-16 and UTF-16 for Mac? See why I am confused? BTW I read UTF-8 is the 'new rich' and s…

Hi, am using a FMPro 5.5 legacy base. It has existing records and new records are added fortnightly. Some of the existing record entries are of particular interest and have already been manually tagged with a check box field. When new records are added that match the client name AND account number of an old record with the check box crossed, (done manually at a previous date)....I want to have FMaker automatically enter a cross in the check box on the new record. The end result is that as the database is updated with new records I will be able to search for the check box and located all the records of interest, both old and recent, without having t…

I've created a scripted process by which a snapshot link (SNL) is created manually using a series of custom functions. I'm doing this because the creation of the SNL needs to happen server-side, but the resulting SNL is sent to remote users. A native SNL created server side stores a local path to the file which then breaks for those not on the same network. The process works great and I do get a resulting SNL file, but here is the problem.. I need to use a line break to separate the record ID's. I've tried to use the pilcrow character, Char (13) and Char (10), but the resulting SNL file does not respect these characters. If you open the resulting file with a t…

We have a family business (bicycle shop) and we maintain a Filemaker database that contains an entry for every bike purchased. There is a table of customers with contact information, and a related table of bicycles with the bike details. (Filemaker solution is something I rolled myself). We need to be careful of duplicates because we use the customer information table to send our postcards twice a year with in-store sales information. Old system: Customer would fill out a paper form with everything upon purchase, and once a month or so an employee would take a stack of forms and enter the data into Filemaker. They would try to be mindful of duplicates, and the…

I have a customer that is requiring a daily export of a configuration file. I have a dated output file that works great tied into the a script that looks at modification date and exports the record that have changed for the customer. The issue is that they want a blank file (Headers Only) to be exported in the event that there were no changes in the records for that day. Any Thoughts James

Hello, I am trying to match a dat file that one of our main suppliers is requiring us to export The last line in this img is what I have now from filemaker the rest are what I am trying to mimic, I uploaded an screenshot here http://db.tt/Mq4Fc9f This is my field definition for every record: Let( [ m = Month( date ); m = If( Length( m ) = 1; "0"; "" ) & m; d = Day( date ); d = If( Length( d ) = 1; "0"; "" ) & d; y = Year( date ); y = If( Length( y ) = 4; Right( y; 2 ); y); rid = "*" & rollID & "*"; r = rollID & space( 20 - Length( rollID ) ); po = m & d & y & space( 20 - Length( m & d & y ) );…

I have been reading and think I am clear on creating paths for export. Been practicing imports also. I can use a variable to say the file name but... I will have files for import where they are identical but first three characters of the file. How can I write generic import if it insists on my specifying the name? I wish I could say to import ALL files in a directory. I will know all but first three characters (ID of part number) of the file name. I wish I could say, "tell me all the file names that are in that directory" and the script like a loop or something and grab them all and import them. And how can I get the file name that I am importing into th…

I'm wondering how pro developers roll out an updated solution to existing users? I have a large and complicated solution that involves multiple files with dozens of tables. It is extremely tedious and error prone to manually import data from users files into updated templates. I would therefore like to script this, but the import script step is somewhat limited. Fistly the import path must be hard coded. Also the import table name can not be set by a variable so I can not figure out a way of looping over all of the existing tables in the solution. Is there no easy way to roll out new versions of a solution?

I noticed if I use the File>Export Records command, the exported text is inclosed by quotes, so any commas in the text are imported ok when a .CSV is used. But if I export in a script using a variable, then the exported text is not inclosed in quotes, so any commas in the text causes the full text not to be imported. So how can I correct this as I need to import as a .CSV file. Thanks in anticipation.

An explainable but unexpected behavior surprised me today: Table with 2 fields: ID ( auto-enter serial number, increment by 1) ... sitting now on 1 text field set to validate always, disable user override and as Unique Import 1000 records using ADD only - (knowing there are duplicate text records and I will get 10 unique new records as a result). Enable 'Perform Auto-Enter' (because I want the serials entered during the import and to also increment in field definition when done). Result, 10 records are imported - just what I hoped. But two things ... 1) If I look in my auto-enter serial, it has jumped, not to 11 but to 1001. 2) If I import same…

I need a scrip that will export selected fields of the current record to a .csv or tab-limited txt file to import into Moneyworks Express. I have little knowledge of scripting and tried using "Export Field Contents" but this wanted to overwrite the destination file each time a field was exported.

Hi, All i am beginner in FileMaker. i started my database which is imported from access database by excel cheet. the original data base contains alot of checkboxes. when i import the data from checkbox, the checkbox get me 2 checkboxes value in filemaker, one is "0", which mean false and the seconed is "1" which mean True i need to remove the checkbox which named "0" or false, and keep only one checkbox as in the original databse, and change the other checkbox title "1" to another Tiltle. Thanks

Hello, Is there a possibility to batch import xml files in IWP or CWP (i.e. without using the filemaker client)? Thanks! frier

Hello I am creating an image database, but whenever I try to do a File > Import Records > Folder, even if I specify 'Include all enclosed folders', Filemaker only imports a seemingly random selection of files. I am importing references, not entire files. I have various file types in the main 'clip art' folder - JPEGs, QuickTimes, Illustrator, Photoshop, other folders, etc. Filemaker only imports 138 items, yet there are 2503 folders and files in the 'clip art' folder, totalling about 5GB. After import, I get the message from Filemaker: 4 file(s) in “Clip Art” cannot be imported because they are not the specified file type. ...but presumably f…

I have 2 runtime solutions. Solution B has a script to import data from Solution A. Since I do not know where users place their respective runtimes, I end up with my script always asking to locate runtime A. It would be easier to instruct users to place both runtime inside the same folder. But If I do so, opening runtime A works fine, however opening runtime B will still open runtime A. I can't access runtime B. I also ended with the opposite result, where only runtime B will open. Both solutions have their .USR and their .exe There are also countless small files created with each runtime. They all have the same name and size, so I hav…

Hi all. I'm a relative newbie to FileMaker and I'm struggling with a script that, if I pull it off, would make me look REALLY good to my boss. Anyone able to help? I'm trying to perform a find based on a single field ("MARK PCP Info Unknown") for all records with a response of "Yes" I then want to sort those records alphabetically by last name and export the fields I want to an Excel spreadsheet. I am ultimately repeating this process with several other fields and would ideally like to put them all on different sheets of the same Excel file. Not sure if that's possible, but just putting it out there. Here is the Script I have so far, but it keeps saying that…

Hey guys hi, Actually I am preparing a facility management program for my customers with using fmp advanced 11. My project ıs almost done but my customer wanted me to do import export functionality to retrieve all older customer's ınfo to this current project by usıng ımport export. I mean that there ıs another software. There are tons of people are usıng the other system. We are preparing dıfferent project but our database is almost same wıth eachother. He said that To sell this product, We need to get theır data wıth export ımport functıonalty on web publishing. At that poınt, Is there anyway that you can suggest me to make this functionaltiy usı…

Hello, I would like to take advantage of Mapquest's fancy Route Planner feature (http://www.mapquestapi.com/link-to-route-planner/). I want to have a list of addresses in FileMaker 11 and have the user click a "Plan Route" button that would open the Mapquest Route Planner page in a web browser, where the user would be able to print the route from. It seems like XML is the way to go, but I only say that because I know FileMaker can handle XML exports. We have the Troi URL plugin, which has the ability to send data to a server using the POST method (TURL_Post function), but I really have no idea what I'm doing. The returned data looks like a blank form from M…

i'm back with more importing weirdness... i've exported a merge file from a .fp5 file, containing about 1800 records. i'm only exporting 5 fields from this file, because the rest contains irrelevant stuff. i verified that this file imports ok into the .fp5 file itself. now i want to import that same .txt file file into a converted .fp7 file and something very bizarre happens: i receive my 1800 records, but only fields 3, 4, 5 import correctly. field 1 doesn't import at all and field 2 imports for 77 out of 1800 records only. on closer examination, i found that only those 77 records contain data in the field 1. it is blank field for the rest of the records. …

Hi there, am new to Filemaker and these forums. I've moved from working in MS Access and am loving FM so far. Problem: I am using FM as ODBC data-source for MS Word mail merge. I would like the merge source to have data from multiple related tables. In Access this would have just required using a query as the data source. However, FM as ODBC only appears to allow use of tables and not layouts. Is there a way to setup a layout as an ODBC or do I have to create a behemoth table which has all the data I need? Alternatively, am open to any other suggestions. I don't think using Form letters inside FM is suitable as I need to be able to edit…

Hello We are working with databases at work. My boss would like to keep working from home so I need a solution. We can work remotely but the server connection is so slow it's hard to generate any script, it just take way too long to interact with the server and it drives us nuts on the long run. Can you offer your ideas on the best way to do it? Do I simply use a backup or a clone and make a script to import all the datas? Thank you.

Hello guys,I am working on the balance ,i got a Kern balance,the thing is I have to press the "print" twice to get the output of the balance a Kern balance and the baud = 9600. I tried to increase the baud but look like the balance doesnt support it ,because when i increased I cannot get any output. Is it a hardware problem or software problem

hi all, i'm trying to come up with a way to update .fp5 files to .fp7 and some of those old repeating fields are coming back to haunt me. i have written scripts in the old .fp5 files that export all data to merge files. the new .fp7 file will hopefully read all data in automatically. now i can't figure out what is happening to data that was in repeating fields. i need to have these fields again in the new file. after import is done, i'll eventually massage that data so the repeaters are gone forever. one file has two repeating fields with three repetitions each and those came over fine. however, another file has 7 repeating fields with 14 repetitions a…

Hi, I have inherited an older FM database fp7 that was created locally by a previous staff member who was self taught in FM. She awkwardly (for our purposes) created 4 external databases (tables). I need to import these tables back into the master db along with the associated data. I have Filemaker Pro Advanced 11. I have an inkling of how to do the tables, i.e. by creating blank internal tables and layouts identical to the old external tables with the same relationships. But how do I import the data back into those specific tables while retaining the established connections? In other words, one external table is a list of groups and which individuals belong to that gr…

dbf opens fine in FMPA8 but not in 10. Has support been dropped for dbf?

Hello, This one is a bit tricky: I have a database with people where the email is the primary key. These people can have one or more values from a value list. The value list are different check box categories that the person belongs to, like what type of movie they prefer: Action, Comedy, Cartoon etc. Is there a script or function that will check for duplicates on import and retain the existing values, and just append the new category? Or in other words: [email protected] already exists in the database and he likes "Drama" and "Detective movies" In an external text file, with several people, there's also an entry for [email protected] "Romantic c…

Hello, I'm not sure if this belongs in the forum or not, but I'll give it a shot. I'm looking for a free downloadable file that lists all cities in the US and associated territories with ZIP Codes, time zone, Lat and Long. Unfortunately the only thing I can find online is either ZIP Codes only, or payware databases. If anybody has an up-to-date source for this I'd be grateful. If I need to move this topic just let me know!

I currently have a server the houses a db, and often have to import data from an external source. Often, this external source provides me an excel file, while another provides me another fm db. In both chases, I need to take the target db offline in order to import a file. Is there anyway I can import new data into a file that is live on a FM Server? Thanks, Bob

Is there an easy way to import a summed fields data into another db. For example, I have a summed field that totals the cost of several shipments. I have another db that uses that summed field, and I would like to pull the summed field from the shipping db into my overall db. Thanks, Bob

Am trying to export multiple records to a .txt file to look like this: 40 Mile Men 1 Howard J 0:45.59 2 Kilpela A 0:48.09 3 Kilpela T 0:50.38 40 Mile Women 1 Davis A 0:58.56 2 Brand K 1:00.18 3 Leukuma W 1:00.43 Where the 40 Mile Men & 40 Mile Women are Subsummary fields (Race Name) and the names listing is a calculated individual record (place last first initial time). I have the individual field calc setup OK, but can not figure out how to bring the subsummary header along with the individual records. Any assist is greatly appreciated. Thank you.

Hi there. I've searched the forums but couldn't find anything related to my question but im pretty sure someone must have asked it before. Is there a way to create an export template for saving to excel so that i wont have to recreate or respecify the fields everytime. The system does various different exports, but i want templates for each of these. Is this possible?

Hello to all - i was wondering if there is any way to export data in IWP? Any plug-ins or workarounds? Does anyone know why this functionality is not included in FM? Thanks!

Hi has anyone any recommendations for how to get handwritten audit sheets into filemaker. The data would be a single letter and a small number but in a matrix of times and spaces. thanks

I would like all my users upon log-in to verify that they have updated local files. For example, my solution relies on some local Autoit exe scripts. What would be the best way to check if those files are there, and then script the files to be exported from a utility container field. more specifically, does anyone create a master zip file. or check for these individually. (I have about 20 of these necessary files) thanks in advance!

Hi @all, i would be happy if somebody could help me out with information, sample script or what ever ;-) This is the issue : I have a folder with pictures and textfiles, i want to import all of those into one record(lets say customer1) Thanx for any idea, lookup or help, Paul

I have an export script that exports a "Merge" file of data for use in a Word merge document. The script exports using Windows (ASCI) method, and outputs a comma delimited text file with the field values in quotations. On the Mac clients, Word will use this file to create the merge document with no issues. On the Windows machines, however, the file is not useable for merges because it contains two record delimiters. I suspect that FMP is using a LFCR delimiter to end the record, instead of just a CR. However, I cannot figure out how to solve the problem on either end. I cannot how to get FMP 11 to export with just a CR instead of the LFCR it uses - or how to tell Word for…

I'm having trouble with exporting data from FMPv11 into a .mer file and then using the exported data in an MS Word v2007 merge form. Word recognizes the .mer as a data source, but has problems with characters like ' and " that are located with in the text fields that are being exported. I've tried using different Text Encoding options while in Word, all have their own flavor of not reading the ' and " characters and either ignore them completely or give me those goofy little box symbols. Anyone else trying to use FMP and MS Word together and can help me with the export and merge process?

I'd like to have a field that displays the file name of a container image programmatically. How can I get the file name and insert it into a given field? The images are currently being imported into the file. Later I'll setup an external data file just for the images. I appreciate any pointers.

This is a weird one I've never seen before. I've got one user who is running FMP 11 on a Windows 7 computer. My FM solution is hosted with FileMaker Server 11 Advanced. I was showing the user how to export data from FileMaker into Excel. The first set of exports were all scripted, and the legacy procedure from back in the day was that I set it to export to the C:/FileMaker folder (this was before you could GetDesktopPath and I never changed the code because it is working). I then showed her creating custom reports and walked her through exporting to her desktop. I watched her select file type .xls, but while the export was running it said it was exportin…

Hi, We have built a solution for a client that tracks expenses within their business. They have now requested we extend the solution so that we can easily export the expenses as a list of transactions and import them into Quickbooks as this will save them a significant amount of time. We expected this to be a relatively simple case of exporting CSV/Excel from FileMaker and importing a each record/row as an individual transaction into quickbooks. Turns out this is not the case! Quickbooks will only import *.iif files - which I've had a look at and it doesn't look like it's going to be easy to produce those from FileMaker! Has anybody had any success doing…

I'm trying to clone some DBs that I inherited, but there is no 'Save a Copy As...' option for some of the DBs. The File menu is attached. How can I make an empty copy of these?

I have a student database that I used last year to track student tardies. I went in and deleted all records. I then took a new registration file and imported into the database. I also brought all their pictures back in. When I imported the students information the old data showed back up. So for instance John Boy moved from 11th grade to 12th grade. All that data is fine. But it carries his 11th grade tardies with him. I checked the portal setup and I have "Allow Portal records to be deleted." So how can I get rid of the old data permanently so we can start new? Thank you.

Hi there, I have a huge file with a single table that is only for files and photos. The file size is 27 Gb (200k+ images)! We need these photos for our reports. I am considering the supercontainer plugin, but I would like to know how others manage this many image files without the plugin. I can't store the reference since most workers are work from their home. The FP7 is used by our main database as an external data source. Thanks

Hi, I recently moved to OSX Lion. When I open the FileMaker file I have been using before, the export scripts do not work anymore. I get the message that PowerPC applications are not supported on Lion. Is there a way around it to be able to export my records in xls? Many thanks.

About a year ago I was putting together the program for a conference and tried to generate the section with paper abstracts directly from FM. As has often been noted here, FM isn't a word processor, and the results were not pretty and were rejected by my fellow conference organisers as unsuitable. What to do? My work-around involved going back into the bowels of RTF, but the solution is a general one which can be adapted to export formatable text to MS Word. Step 1 was to modify the variables I was exporting to have RTF prefixes and suffixes and to put them into a new layout: rtf~fullname "\s1 {\b " & Full Name & "} \par" rtf~Institution "\s2 "…

Hi All, I have an XML I'm trying to transform via XSLT for import into FMP and running into an issue. The XML has several "Events" and "Comments" listed. The Comments always follow the Events that they comment on. I'm trying to write an XSL that will put both the Event info and the following Comment into on the same record Row in the resulting FMP XML that I'm creating. The problem is I can't get the XSL to pull the correct value for each event. Does anyone know if this is possible? Here's a snippet of the XML code: <Event Num="2" Type="Cut" Length="252" SourceCount="1" > <Master><Reel></Reel> <Start> <Tim…

Hi, I'm sure this has been asked already, but I can't find it. I'm not even sure this is the right place to ask this or what the exact way to call this is. I have a FM Telephone directory with 3 tables: - telephone number - person As the two tables are in a many-to-many relationship, i have a third telephone_person table which links the two. As I have 2 categories of users, I have a second table, telephone_person2 to link the phones to the 2nd category of user. I now need to export this database as a csv and need all records with all possible combinations in a single sheet. A multi-dimensional report, so to speak For example Telepho…

I've never use scripts or anything beyond the pretty basic functions in FM. I found an old thread (which I will paste at the bottom) in which I'm pretty sure I found the answer to my question, but can someone walk me through and explain how to execute the directions? Again, my question is: how do I import from excel into portal fields? In FM, I have a "Research Notes" table with a portal field to "People Names", and I have a join table "Research Notes_People Names" with "People ID" and "Research Notes ID" fields. In excel, I have some old "Research Notes" that I want to import to FM, and all my excel fields (columns) correspond with "regular" fields in my main fi…

I'm getting sucked into XML World. I've written XML Parsers before, in Java & C#, but I've never encountered XML in FileMaker. I'm still trying to get my mind around what I can & can't do. We are using FileMaker 11, both client & server, in a Windows environment. I need to build a process, on the client, which sends XML requests to a web service and gets the XML reponse back. I'm just starting to write the Stylesheet, to translate the FileMaker Field Names into the necessary XML Tag Names. This part should be easy. From what I can tell, the FileMaker client can export an EML file to disk, just like any export. The import can bring back the …

I'm having some trouble with importing from within the same file. In one instance it works and another instance it does not. The scenario: two related tables - 1. Log table and 2. a Returns table. A script finds particular records in the Log table and imports them into an empty Returns table where the user can manipulate the data. Then, I'd like them to import those records back into the Log table with the updated information. (The Returns table then deletes all records; it is just a temporary storage place for the user to do some things). Importing from the Log to the Returns table works fine. This adds new records. Importing from the Returns table ba…

Good morning all, I have had little / no luck finding an answer on this one, maybe my google fu is weak. I have a database that I need to output in a particular order / structure to import into another program (quickbooks) I have created a layout that is visually what is needed, but I am having no luck getting the data out in that format / ordering. Is there a way to output fields in an order that matches the layout to a text file? (either csv or tab would work. Thank you in advance. Jeff

I have a solution that I am integrating to a customers existing case management system (Law Office). There are about 6 tables of information that I need to have access to which is using Sybase SQL Anywhere for the backend, so ESS is out. I have written a script that will perform an ODBC import on a recurring schedule. The Tables I need have modified timestamp fields, so my SQL statement searches WHERE the modified_timestamp is since the last import. In the import options I have it set to update records based on the key field and add remaining records as new. I have tested the script THOUROGHLY using the script debugger and everything seems to work perfect. Everytime…

I am approaching the end of a project and have run accross a (to me) barrier. FM 10 ADV... Couple hundred thousand records. There is a field that identifies the particular store. There are hundreds of stores each with thousands of records.. I have exports working as needed. What I need to do is: Select from all of the records STORE 1 Export its records to a file Loop through the entire database and select records by EACH store number and export ITS data... I will never know which stores are in the current group of data...... Any ideas? I appreciate any help or direction anyone can point me in....

Hi I am trying to export pdf files from a container field. I can add and export any other file format other than pdf. I can open and edit the pdf files. I have to manually click on each and save them. But when i try export then i cannot. When i right click on the container field in Brows mode ? The option of "Export field contents" is grayed Please let me know if here is any problem? Thanks

Hi Guys, I have severals RFID readers connected by USB and I want to run a script which will get the device serial number, can someone help how I should proceed!!!! Is it possible to get the USB port number? Thanks.

Not sure the Topic title/description explains so here I go. 1. Distributed database 2. User imports file matching the fields the first time he uses. (Each user will have their own field order which may not match mine) 3. I export that and re-import as I need 2 different times back into the file So the actual question is: Can the import field order from the user be saved BEFORE I do my imports so that the next time they import they don't have to match the fields again?

Is there a way to send a command to Terminal in OSX without using applescript? I am trying to get a list of SubFolders in a MainFolder, as well as lists of all files in those SudFolders. I will use this list to be able to view PDF files in those folders using a webviewer. Thank you, Fed

I'm still looking for the best way for users to change the file extension on a file to be imported from "xxx" to "csv". Someone suggested this would be possible using a VB script. I did a google search for one and came up with this: oFS.GetFile( sFSpec ).Name = sName & ".csv" oTS.Close Are there any VB script experts out there who can confirm that this will work in a Filemaker Pro 11 Adv runtime or suggest how it might need to be changed to accomplish the goal. Also, what would be the Appelscript equivalent for my Mac runtime users? Thanks. Dave

Hello, It has been a long while since I posted on this forum. Must have been when was playing with filmmaker 5 or something. But now I have upgraded my filemaker 5 to version 11 advanced and fully busy creating a nice database. Yesterday I tried to creat a script that would automatically create several PDF files from my database. To do this I created a field 'pdffilename' and a script with a loop (that starts at the first record and exits the loop after the last record) and in between the script command 'export as PDF' And in the PDF script I set a file value as '$pdffilename' so it would create a PDF file wih the filename of the contence of the the 'pdf…

Hi Guys, I have not been using the forum in quite some time, it is great to be back in Filemaker frame. I have to implement an import of data in a non standard CSV format. It is special because the field separators are semicolons, rather than commas. When I go to import though, FIlemaker doesnt see the separator. As a result it is like I am importing only one field. How do I work around this, I need to work only in Filemaker. Many thanks

Hello all.. I swear I have done this before, but, am filed with Brainfade at the moment. Filemaker 10 Adv. Working on a solution to produce data for shelf talkers for a client. Data import issues have been resolved and would definitely like to add a very important field to each file that is imported. Hundreds of files to import each time with filenames like "Signs_00001_725351.txt". These are pipe delimited and have done all of the calculations to import the data into the correct field. Each file may contain 100 - 200 records and there are proposed to be 700 or so files each time. What I would LOVE to have happen is during import, could I grab a portion of …

Good afternoon, I have developed the functionailty for a department to import a dataset which contains data that already exists within FM. I have given them the functionality to compare the record that aleady exists in FM against the record they are looking to import from an Excel spreadsheet so they can pick and choose which fields they would like to accept and then save only those changes to the record. The problem they have now flagged up to me is that if they are required to navigate away from the layout where they are going through this process they lose their position in list of records in the Excel Spreadsheet. So my question is, is there away that Filema…

Hi. I in-elegantly posted a week ago without attaching my files. This time the files are attached. It's basically an XML order with buyer info and items ordered. I've also attached an XSL file that doesn't quite work. I've perused this forum for examples, but none are structured similar to my xml. I'm importing an XML response containing one record (buyer data), and varying number of child records (order items). The child records ('vendor bookid') is located in a portal within the db layout. So far, the first field ('email') imports successfully, but the rest doesn't. In addition, filemaker creates a new record whereas I want to import into the record op…

I am exporting files from a website in Drupal to Filemaker. Every file has a unique number. Is there a way to avoid files being imported into Filemaker more than once, if I don’t want to delete the files from the website that I’ve already imported?

Hi, I hope someone can help. We are trying to integrate our Filemaker database with our online Magento store. Magento provide and API and Beezwax have a handy API plug-in for query the API directly from Filemaker functions. Teh problem we are having is in formatting data in such a way as to get the desired result. For instance, using the command: Magento_catalogInventoryStockItemList( sessionId; products_* ) as an example, I can use this with a single product id in the following fashion: Magento_catalogInventoryStockItemList( $$_SessionID; "9998" ) And this will return valid data However, the products_* is capable of storing an array of pro…

I have an xml file that is available from a url. If I go to the URL, save the page as filename.xml, then import via the Import Records script step (specifying the xml file as a file, and an xsl file as a file), the records are imported fine. However, in the Import Records script step, if I try to specify the xml file as a HTTP Request, I get the error "XML/XSL information is not enough to proceed with import/export". In addition, I have successfully added the URL of the xml file to a web viewer window, so I know FileMaker can read the URL ok. Does anyone know if there is any other step I have to do in order to be able to import directly from a HTTP request rather th…

Hi! I am getting an XML parse error when attempting to use Import Records. Problem occurs only on one computer (Windows Vista, FileMaker Pro 11v3). It works normally on other computers (Macs and PCs). ---------- XML parsing error: invalid document structure Line Number: 1 Column Number : 1 ---------- XML data: ---------- <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="03-05-2010" NAME="FileMaker" VERSION="ProAdvanced 11.0v1"/> <DATABASE DATEFORMAT="D.m.yyyy" LAYOUT="" NAME="" RECORDS="1" TIMEFORMAT="k:mm:ss "/> <METADATA> <FIELD EMPT…

Hi Forum, I'm relatively new to FmP. When I import an excel spreadsheet into my database, FmP is importing every single row of the excel file, that's some 65,000 rows when I only have maybe 34 rows of data to import. How can I stop it from doing this? Thanks.

Does anyone know if there is a solution for importing ACT files, and is there a really good Contact management database that approaches ACT's level of information management? Thanks Wade

Any one know the best way to keep inventory quantities synced bewtween ChannelAdvisor (CA) and Filemaker? I am currently exporting data from CA and then importing to FM. This process is somewhat time consuming (70,000+ records to update). Looking for ideas more than exact solutions. I'll take the exact solutions, but I would imagine that they could be very complicated. Thanks, in advance!

Hi guys, how are you all? I've been working with filemaker pro for several years now, and i'm currently on version 11. I should really know this by now, but how do I go about de duping an excel sheet to put on filemaker? Basically, I have an excel sheet of about 2000 contacts, with name, job title, company, email ect, and I want to import it into filemaker, but I know that a lot of the contacts will already be on my filemaker database. How can I seperate the contacts I already have, so when I import the file I don't end up with dupicates on filemaker? Many thanks, Chris

If I drag and copy let say 7 rows 6 columns of data from an Excel or Numbers spreadsheet I essentially have an array. How would I go about creating a script that takes that data and then puts it into 7 different records with 6 fields. I just read where: But I would like to do this without creating that text file. I'm thinking I would paste the text into a variable and then parse each line but how do you identify the delimiter in the array? What is the delimiters in an array when you copy data from an Excel or Numbers spreadsheet onto the clipboard? It's a Tab right?

Hi All, Just starting on the road of barcode input for internal stock and I wonder if anyone could give me some pointers. The requirement is for someone to walk the warehouse (Small) with a wireless barcode reader, read the codes AND input quantity, return to the system and download the data recorded creating a new record for each entry. It must work on both Mac OS X and Windows using FMPA 11. Does anyone have experience with readers that are accurate and reliable that they could share.

So we recently moved from Server 8.5 to Server 11. I have a bit of an odd import process that I would like to schedule but can't quite figure out how to do it. At the first of each month we run a bunch of queries on our iSeries and need to import that into offline FileMaker files. So I have an offline FileMaker file that is a template. On the first of each month I need to run the import script in the template and then copy that template out to another directory. From what I can tell, you cannot run a script in an offline file using the FileMaker Server scheduler. The schedule wizard only shows hosted databases and if I try running a script which in turn tries to run…

I have a script that uses an Import step to import a .csv file. The Import step's options are (a) do not specify data source, (: perform without dialog, © specify import order. It appears that, because of option (a), option © cannot be set to ignore the first record which contains column headers. But I specifically don't want to pre-specify a data source, in order for the user to be prompted to locate the file. How does one use this set of Import options and skip the first record in the .csv file? And, since I'm about to upgrade, is there a better way in FMP9adv? Thanks, Chap

I assume this isn't possible without a custom plug-in, but... I have a table which stores images (and other data files) in a container with fields for various indexing and flagging. Occasionally the user wants to facility to export all the images stored to a folder on their PC. When exporting one embedded file, I use a simple script with the "Export Field Contents", then the user specifies the target field. All nice and easy. But the batch export, I'm stumped... If I set a loop to run through multiple for export, obviously the user doesn't want to select the destination for every file, but instead just once. Could I export one (displaying the target file de…

I have to upload a word file and then i want to import the records in seperate fields without entry...... Eg:uploading one resume from online and then want to import in the fields as given below Name : XXX Date of Birth : dd/mm/yyyy Address : 123,abcd,cbe-122120 Qualification : Bsc Experience : 2 yrs

If I save as a PDF (via print menu on a mac) I always get an old legacy file name as the default name and title. I don't seem to be able change this. Is this right? thanks

Hi guys, I have achieved my task of auto-importing text files from the server on the fly, and having the database process them as they come in... but the one issue I can't seem to get around is that even though I choose IMPORT FOLDER - NO DIALOG in my script, it still pauses every time it checks and forces the users to press enter before the import occurs. Anyone have an idea how to get it to actually show no dialog when importing? I am working on Macintosh FMP v11 Advanced, and pulling encrypted txt files off a PC shared folder. Thanks

I'm in the process of updating an old Filemaker database of some 267000+ records where some of the fields are set as unstored calculations referencing external files and we need to change these into stored data fields. To make this change, I decided to import the fields which were unstored calculations into a temporary database to get a stored value, then reimport them back into the original database using a update match process after the corresponding fields in the original database had been turned into data fields. (The database does have one text field that is a unique key for each record, and there are no duplications as far as I can see.) For various reasons, I …

When I use the "save as pdf" command the document produced has @ characters littered through when printed. On windows machines it appears blank. Any thoughts or suggestions?

I have created 2 runtime solutions. None of them have admin rights. However, they both are accessed individually with the same user/password combination. I have a script that gets runtime TWO to import data from 7 or 8 different tables located in runtime ONE. Is it possible to enter user/password only once when the script runs? Actually, it asks user/password for every single table accessed by the script. This is very unelegant.

I get spreadsheets sent from various departments like "accounts" or "personnel" and others. I have no problem importing them into filemaker. I would like import them knowing where they had come from. If I got a sheet of 5000 names from "personnel" when i import them into filemaker i need to have some way of knowing that 5000 was from "personnel" The same with the other spreadsheets as well. can this be done?