Jump to content

Search the Community

Showing results for tags 'excel'.

  • 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. Gents, there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved? Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option. price.xlsx
  2. New Major Version Release: Scribe 4! We are excited to announce a new major version of a popular 360Works plug-in, introducing Scribe 4! 360Works Scribe is the ultimate document automation plug-in for FileMaker; it allows integration with Word, Excel, and PDF documents. In this release, we are taking it to the next level by adding in the ability to read your scanned documents, such as receipts, forms, or contract PDF files, with OCR (Optical Character Recognition) functionality. Additionally, we added features to allow you to merge PDFs and get meta-data from them, plus multiple
  3. 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 .
  4. I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker. Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked! And would like to do everything for his business in FileMaker. His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients... Well, now I've been asked to see i
  5. Unfortunately, the EXCEL data storage within xml-files is very complex, and as noted by others, it is virtually impossible to handle complex (and even very simple) data without the program EXCEL itself. I just discovered a new CAVEAT relating to the scribe plugin. Reading an EXCEL document with ScribeDocReadValue(), real numbers are always returned as 'integer string' without comma, and it seems impossible to get a meaningful value out of this. '29.84' -> 2984, '2984' -> 2984 (nothing to say about '2.3' -> 22999999999999998, etc.). Although not documented, I tryed to address the f
  6. 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
  7. Hello, we use your plugin Scribe for editing Excel files in our Filemaker solution. Since a few days we get an error message when calling the method "ScribeDocLoad" (see appendix) for newer Excel files. Older Excel files from the beginning of 2018 are not affected. So we wanted to ask if there might be a problem with the error in Scribe. We are currently using: Filemaker Pro Advance version 16.0.3.302 Microsoft Excel 2016 Ver. 16.0.9029.2253 64-bit Scribe version 3.08 In the appendix you will find an Excel file that throws an error message when opening with Scribe.
  8. Hi, I am going to be doing a mini project with FileMaker where an excel sheet is going to be distributed to bidders for some work. My plan is to then import the data from completed spreadsheets into FileMaker using Scribe. The Excel sheets aren't going to be the most complex Excel ever but there are some special things. So, we feel we need an experienced Excel person to take care of that. So, we are looking for recommendations for an Excel consultant who might be able to help us out. Ideal person is: -Based, like us, in the UK. US is OK though. -Able to stick aro
  9. 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
  10. Hey Guys, Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue) My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
  11. Hi there, I am making cutom import and export from/to excel documents. Is there any way to merge excel cells in scribe? I can easly find out which fields are merged when importing. two nested loops and if second col or row is empty while reading i consider it merged. Problem is while exporting. I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical). Thanks in advance for any help. Have a nice day.
  12. Good afternoon everyone. I need to open a .xlsx file by pressing a button I have tried with a script, where I establish a variable $ filename = e: \ Works \ Josram \ Presup \ AAVSA \ slopes 345 7 Apr 14.xlsx And using the command "Send DDE Execute" The service name = "c: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe" But when you run it, it just does nothing Can someone tell me that I'm doing wrong? I don't need to import o export a file. I only need, when i click a button Excel runs and open the .xlsx file Thanks in adv
  13. Hi There, First of all many thanks to creators for amaizng plugin. What is the syntax for inserting images to excel? ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) Do not work for xlsx with error about invalid cell name (first parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image. Any suggestions? Thanks in advance. Bart
  14. I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample: Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on. I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax: Select work FROM "Student Time I
  15. I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script: Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded: Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose t
  16. 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
  17. I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK. However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours. I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout? Please can someone provide assistance because I have another 20 similar reports t
  18. I recently imported records from an excel sheet into my filemaker solution. I just noticed that the dates in the excel sheet were entered in this format 1996-04-19 and as a result, all my date calculations are not working. For example, the Age and other functions. Manually changing the date to 4-19-1996 resolves it. Is there a way i can do this without manually going to each record? because there are a lot of records to deal with.. Thanks for your anticipated response
  19. Hello, I have a small problem before importing an Excel file in Filemaker As I run a macro on Windows all goes well the work is done corectement to use the file to import into Filemaker But on Mac that does not work I tried with several Excel and of course Windows Excel for Mac I think this is the path for the error message, this is the way: sPath = "C: \ input \" Thank you
  20. Hi All, Sorry if the title is a bit confusing, I wasn't sure how to explain it. Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters) the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002. I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the
  21. So the company I am working for just picked up a huge contract with a cruise line, where we are going to be surveying some of their hardware and other equipment, guess who has two thumbs and is the lucky son of a gun to make the database for this project? This guy! Anyways, I can't really go into detail for legal reasons, but I can explain what I am looking for. I'm wondering if there is a way to export the records from the database in filemaker to an existing Excel spreadsheet, and the biggest reason this is the route I'm trying to go is, I based the solution that I've build thus far
  22. Hi I’m new in Filemaker, but I see lot of advantages using this solution. I have two similar excel one is work schedule and next one is order schedule. I would like to have them in FM. My problem Is to build database which keep the visual and functionality of excels WORK SCHEDULE: The main part of this excel (SCHEUDLE) is connecting dates, workers and type of work to do. I would like to keep the visual form of this excel but it should work as a database. Work to do is editable list of work type. At the upfront you can see date, week day and time start of each shift, colors are po
  23. I could really use some help! I'm in a crunch and need a solution fast. Any Applescript FileMaker gurus out there? My client sends me (usually weekly) batches of excel documents... hundreds of them. I've created import scripts and parsing scripts to get the data from the excel document into FileMaker, but I need a solid way of batching the import process. Below I'll explain what I currently have, but it's very clunky and errors out quite often, so I could really use some guidance. I can look at applescripts and for the most part understand what they are doing, but I'm no scripter. Basic need
  24. I’ve used Filemaker as a simple database for years, but now I want to create a simple report. My data is currently in Excel. Attached is a pdf depicting an example of what I hope to accomplish. Can anyone please tell me if Filemaker can accomplish my goals, and if so, how should I proceed? Thanks so much, Anna Concatenations.pdf
  25. Is there a way to export related records such that you can get all records for each table (let's say 4 related tables - parent to great grand child table) so that each record for each table is shown in the exported excel file. In other words, parent fields will get repeated in one to many child records and parent records with no child will show blanks under the child variables. This seems to work properly only with direct parent and child records but once you get more than one table away, it doesn't seem to hold its hierarchy. Seems there should be an easy way to do this. I've attached a file
×
×
  • Create New...

Important Information

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