Jump to content

Search the Community

Showing results for tags 'excel'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
    • FileMaker Server 17
    • FileMaker Pro Advanced 17
    • Command Line Data Migration Tool
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
    • GDPR
  • FileMaker Server Administration
    • FileMaker Cloud
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • FileMaker Pro 16
    • Legacy FileMaker Platform Discussions
  • 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
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

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

Product Groups

  • Site Donations
  • Site Advertising

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

Found 35 results

  1. 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. With kind regards Christian Chojnacki Click to choose files Mappe1.xlsx
  2. 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 to be less than and equal to. Did not know how to show it with the keyboard.
  3. 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 to do and this will take me days instead of hours
  4. 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 advance regards Pedro
  5. 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 Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value]) Thanks.
  6. 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 pointing different line production (usually there are 2 shifts day/night and we have to lines block line and trey line also there are something like work on empting trays ) Below the main part is dictionary to translate contraction ( OL/K is operator of blocking line, W/PUSTE is forklift on empty side etc. ) and some extra info about production. I will translate last sheudle and add hole excel here. Also I did some pivot table to calculate how often my worker work on each post. It is on GRAF ORDER SCHEDULE At this excel we have similar situation. (I need to delete sensitive data I only keep date from the last month MAY 2016). On the left side you have clients which are extra sorted by type of product they take (BLOCKS / BULK / TRAY ). At the upfront we have dates months, days, week number, total weekly production by product, total day production by product. Last row (IV) is total season order for each client. The main cell is fill with amount of product to do. I should be something like popup menu with order details ( amount of product, order specification, transport specification I will edit that later on ) Please help me build such SHEDULES, I can’t figure out how to start ? P.S. SORRY FOR MY ENGLISH ORDER SCHEUDLE.xls WORK SCHEUDLE.xlsx
  7. 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 as an example. Any suggestions? RelatedTablesExport.fmp12.zip
  8. 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 on the spreadsheet deliverable that they had given us at the beginning of the bidding process. There are several fields in this deliverable that have the same name, which in Excel is no problem, but we work with Filemaker lol, so there's that. Anyway, so I have about 5-6 different types of fields that share the same name in the spreadsheet that i cannot allow in filemaker, so I cannot just set up an export to create an excel document, or else the client would most likely be very unhappy with the deliverable that they receive. So i want to know if there is any way to throw all of my records into the spreadsheet that they gave us starting at a specific cell for each of the 8 (I think it was 8) worksheets in the file. haha the more I type and am reading what i type, the more impossible I feel like this would be. Thank you to anyone who can offer some help or insight, it is greatly appreciated!
  9. I want to save repeating fields to separate columns in an Excel file. When I use the script step Save as Excel, the repeating fields for each record are all concatenated together in one column. Is there any way to get them to save to different columns? Or do I have to create a layout, with a separate entry on the layout for each of the repeating fields? (A lot of work, but doable if I must!) Sorry, I could't find a category in FMForums for Excel Files, only PDFs.
  10. Is there any way to create an Excel download for an IWP connected user? I've thought about have a script that creates a flag and have a client on the server that run periodically and looks for the flag and emails the Excel file to the user. The problem is that the file needs to "Replace" the old file and that doesn't seem to function properly. I get an error message.
  11. datalink

    Formatted Excel Sheet

    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 very versed in Excel. Is that even an option? Other suggestions? Thank in advance.
  12. 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 no records match my search parameters: Loop Show all Records Go to Layout ["Checklist" (Checklist)] Enter Find Mode [Restore] <------ Specified find: Find Records, Checklist::MARK CP Info Unknown [= "Yes"] Perform Find [] <------ I have tried specifying the same find again here too, but no dice Sort Records [Restore] Export Records [No dialog; "PCP Info Missing 2"; Automatically Open; Unicode (UTF-16)] Enter Browse Mode [] End Loop I'm basically just flying by the seat of my pants here. Am I even on the right track? HALP!
  13. 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
  14. I'm trying out Scribe for a project that will involve writing to an Excel template. The template has a 'summary' sheet that will total values from other sheets etc. I need to be able to write formulas to this sheet in order to have it create the summaries, e.g "=SUM(Sheet1!M2:M125)" Scribe can write that text into a cell, but somehow it doesn't get recognised as a formula. I have to click into the cell, move the cursor to the left edge, and hit the backspace, at which point it is recognised. Any ideas on how to remove the need for that last step? Many thanks
  15. Clent needs to split a record so they can easily import it into their payroll system. What I have in a record: (employee ID, time worked, bonus, Job) what they need in two seperate records, lines, or two rows in excel is: (employee ID, time worked, job) and (employee ID, bonus, job) What's a good practice to get this done? either to excel or CSV, or to a different table that can be exported.
  16. 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
  17. hutchlad

    Exporting Report Issue

    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.
  18. fm8443

    Join & Export 4 Tables

    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 is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?) so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively. Any ideas? Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report. Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this? Thanks for any ideas about this?
  19. 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 same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc. I hope this makes sense and thanks in advance for any help.
  20. I am trying to export a found set in an Excel format (.xls). Sounds simple enough, but once I get through the dialogue boxes setting a destination file, I get an error that says, "This operation requires Rosetta, which is not available on this version of OSX." I am using Lion 10.7.3. Does 'export records' to excel really not work with Lion? It seems crazy. Has anyone had this problem, and does anyone know a workaround? Reinstalling the software did not fix the problem. Any thoughts are appreciated!
  21. Hi, Am trying to establish if it is possible to output from an FM DB for publishing in InDesign. The process for transferring into InDesign involves converting to a CSV. The DB has pics as refs and text with line breaks. Both of which are causing problems. The line breaks are interpretted as separations and as such they are seen as new fields and the pics aren't displayed, only the filename is recorded in the field. Also one of the text field, that has a large amount of text in it, is just displayed as ######. Any tips on parsing the text so its readable and keeps the line breaks but stays in the same field? Also can pics be embedded and retain their full path details in an Excel save as? Many thanks in advance. N
  22. I'm setting up an excel file for import to "update matching records in found set" records and selected the option to "add remaining data as new records." My match field is the sys_id. What I"m finding is filemaker won't add the remaining data as new records unless there's a value in the sys_id match field. Normally, that field is set to auto-enter a serial number in sequence. I would prefer not to create a sys_id value in the excel in case someone has created the same one from within filemaker. Any reason Filemaker is requiring data in the match field to create a new record with the remaining data? Thanks for any help and advice. -Mo
  23. 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
  24. 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 field with a name ('Bill') instead of a cellcode 'C14'. Interestingly, this returned no error, if the name was defined in EXCEL, but a null (empty) value! Next try. The Excel calculation =TEXT(C14,"standard") returns the real number in a beautiful text format. However, scribe returns ERROR: Scribe returns ERROR for a any Text calculations, e.g. for 'C15' = 'Jane'; 'C16'= '=C15', ScribeDocReadValue ('C16') = ERROR. Probably scribe just can NOT access the 'SharedStringTable', nor any other secondary source tables (– this has other bad effects. If you write any values to an Excel 'fill down' range with Scribe (that is, through the backdoor), Excel will never recognize and evaluate these values correctly, etc. etc.) What about the real numbers, then? I only found one solution: Defining an additional cell with a calculation like 'C16'= ROUND(('C14'+1000)*10000000000000,0), or (more generic) defining TWO additional fields calculating the INT and MOD part of the number. What an abonimably atrocious workaround! However, I really wonder WHERE the 'comma' position is stored in xlm-EXCEL, and, eventually, if you guys at 360works may plan to retrieve this information in a next version. That would be great! Thanks Markus @Excel for Mac 2011, v14.3.6, OS X 10.8.4, Java 7 25 (Build 1.7.0_25-b15), FM 12.0v4 Adv, 360Works Scribe v1.262
  25. 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 these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script. Does the above make sense, and could it be done via a script? Thanks for the help - really appreciate it!
×

Important Information

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