Jump to content

Search the Community

Showing results for tags 'export'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting

Categories

  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

  1. I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child. For Instance: Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com When I do an Excel Export from FM I get Column 1 . Column 2 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I need: Column 1 .
  2. Updated file management plug-in is compatible with FileMaker 18 and sets movie metadata. Alphen aan den Rijn, the Netherlands, May 22, 2019–Troi today announced the immediate availability of Troi File Plug-in 11.0 for FileMaker 18. What is Troi File Plug-in? Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker database. Any files or folders stored on the computer can be accessed through the functions of the plug-in. All from within FileMaker you can: get data from files that are on the disk of the comp
  3. eyepro

    XML export

    I'm very very very newbie on xml. What I need to understand is if it's possibile export in this way. I use a xsl stylesheet to export from FM. I was able to use the <xsl:for-each to export details in the way I want: <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <Details> <Code><xsl:value-of select="fmp:COL[2]/fmp:DATA"/></Code> <WTN><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></WTN> <Date><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></
  4. When I "Save Records as Excel" all the found set records are saved out of the system. However, when I "Export Records," only about two-thirds are exported. What would explain not all records being exported? Thanks.
  5. Hi, I am running version 17.0.2 - in demo mode for not but we will a buy a licence today. In the bottom pane I have a list of fields for a table and would like to get that list inside a FileMaker file. When I right-click on the list - all items are selected - I get a choice Calle Copy for FIleMaker. What do I get when picking this menu choice, and how can I paste in FileMaler ? Thanks
  6. Dear all, I've just create a script to export my records in multiple xml file (one xml for each record) applying also an XSL stylesheet. So, if I use the style.xsl taking from my computer ("source" button when filemaker ask me to select the file) it works. If I put the same file online, it doesn't work giving me a SAXParseException error: internal error in NetAccess (occurred in an unknown entity, at line 0, column 0). In the same folder where I have the style.xsl there are other xsl files that works, but they are used to "import" process (from XML to FILEMAKER, while in this case I'
  7. Dear 360 Works Team In our FileMaker Solution we want to create an Excel report including text, numbers (dates) and images via Scribe. The FileMaker export of text and numbers works fine. But we have a problem with the export of images in the xlsx. After the Creation of the Excel reports all text- and number elements are in the .xlsx but the image not. When we open the generated .xlsx, Excel shows the attached error massage: For the export of the pictures, we test following script commands: ScribeDocValue[Name:“F5“;Value: ta
  8. HI, In My DB- Table ( Product) have a Container field. i want Export Container Field. & save in The create folder. i have write these script:- In this script Folder Create successfully. & also Image Export Sucessfully On Desktop. But I want export Image in The newly created folder. . can any one help me to release this. thanks in advance Austi
  9. I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers. Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values. Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown. Everything is automated through scripts.
  10. I'm surte this is quite a simple task ... for someone expert I see I can export Record content using a Variable as the new filename for the exported file. I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename. The path for my db is as follows file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12 Thanks a lot
  11. Hello forumers I have a small issue with an export on a network path. Generally the path is alive, but very rarely it can happen that is not reachable. When not reachable, you'll get the error message from FileMaker that file can not be created .... (error code = 800). Since this dialog box can not be suppressed by Error Capture =On, the script will stop there until someone goes and clicks on the OK button of the message. Was wondering, is there a way to check if the path is reachable, and if it is not reachable then to exit script? Thank you, Toni
  12. Suppose I have a column of numbers in a text field and I wish to export that field. What happens is that only the last number of the column gets exported. If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works: all numbers are exported. The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers. So: is there any way to export a column of numbers (contained within one text field) to the disk?
  13. Hello, I have a table with changing fields created by sql. So i could have 2 or 50 different fields on the same table. Il would like to export all of this so 2 when there is only 2 , etc to Excel without manging export function from my script. I would like to export all not depending numbers of fields. Is it possible ? (sorry for my english) Thanks Tom
  14. I’ve got a FM16 system that converts raw data (dimensions, etc.) into a SVG floor plan and elevations in the Web Viewer. However, my boss now needs me to use this same data to generate a DXF for integration with another system. Has anyone had experience doing this? I’ve been reviewing the DXF specifications, and it seems unfortunately nontrivial to me. Any guidance would be appreciated. Thanks so much!
  15. Using the script step export field contents, I can not export the contents of a container field. Error message reads ...could not be created on this disk. use a different name, make more room on the disk or use a different disk. I know I have had this in years past, but I can not remember the fix for this. I found something about setting the fonts to .ttf, but I am on a mac running fmpa16. Any help would be much appreciated. David
  16. Hello everyone, I'm developing a little FMP database on Mac to help creating reports with MS Words. These reports will contain : - non changing elements : logo and address, first level hierarchy titles… - some specific datas from FMP : number and name of the affair, name and adress of the client… - the text of the report directly typed in Word by the user. So my need is : - when all the fields are completed, user clics on "Create report" then : - it creates a new folder with number and name of the affair, - creates the report file by duplicating from the report template
  17. I'm doing an export of a table with 5 fields to an Excel file with an XSL stylesheet to control the formatting of the Excel data. So far it's working well - I just need to add some additional formatting for a few of the cells. I'm looking for help with examples/syntax for setting the following attributes: - making a cell bold - changing the font size of a cell - making all columns set to auto resize so they fit the contents of each column (same as double clicking the divider between 2 columns) All fields I'm exporting are text fields. Thanks, Steve
  18. Hi Guys I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards. I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other. I am thinking, that I need a new table to combine t
  19. Hello, I've done quite a bit with FileMaker in the past, but have never jumped into the XML arena. Now I have a need to do so, and I'm really needing some help with something I'm sure is quite basic...but still foreign to me. I have an external data source which export XML in a very specific format (see attached). I need to import that into FileMaker so I can manipulate the data, do some various lookups, etc. Once I've made my changes in the data, I need to export in the exact format it was when imported so the external data source can properly import. Not sure if it makes sense to i
  20. Good morning everyone I created a database runtime solution with FileMaker Pro 15 advanced. The program must export the contents of a form in PDF format. In a solution that runs under FileMaker I could use the command "Save as PDF" but this command does not work in a runtime solution. Could someone tell me how I could make this function? thank you so much.
  21. Hi, Has anyone else found that you are unable to export .fmp12 records from FM 16? I use this step in many scripts and the first machine I upgraded ( out of 48 ) I get the "unable to save file" error every time. FM 15 works, FM 16 fails on the same DB, same table, same record set. I can't even export manually. I made a screen movie here: https://www.youtube.com/watch?v=iOGcm4bt86o
  22. When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute? Usually it looks like <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Yet sometimes it looks like this <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Then again when querying the XML RPC it always look like this <datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" t
  23. I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores). Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records The fields in the 4 Tables have different names and contain similar “core” content. Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel). Unfortunately the same Products are named slightly differently in each of the 4 tables. Each store / table has a (text) Product-ID but (for the same product) it
  24. I have come across this technique severally on this forum, but I can't figure out how this really works. Right now I am faced with a situation that requires similar technique and I can't seem to get it work. I have Table A and Table B. 1. I want to script an import Process that will first export all records in Table A into Table B (kinda A Clone Copy of Table A) Thats just my basic objective 2. Then from there, I would want to be able to do similar Process but this time, I will only update the records in Table B with that of Table A using a match field. 3. I will also love
  25. I'm using Filemaker Pro 11 in Windows 7, trying to automate the exporting of files from container fields. I've written a script that goes through all the records to export the files in the container fields while skipping empty container fields. The code works well, except that there are a number of records with container fields where I get the "Container fields cannot be exported." error. When I try go to these records and try manually exporting the container field contents by right clicking, the "Export Field Contents..." option is grayed out, though I am able to open the document and then
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.