7 posts in this topic
Export Records to Existing Excel Spreadsheets, Is it Even Possible?!
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!
Percentage chart Y axis scale
I'm trying to put together a couple of A4 landscape layouts which would show a total of 4 line charts on each, therefore each chart needs to be the same size.
The data being presented in each chart is percentage data which is pre-calculated, so it's easy to plot onto the chart, the problem is with the crazy spacing that FM assigns to the Y-axis.]#
I initially created the chart with min and max values of 0 and 100 respectively, but when I resized the chart, it shows (useless) values on the scale such as 16%, 26%, 42% etc.
Whatever size I choose, I want it to show 0,10,20,30 etc.
Can FM manage this?
Secondly, some data series lines look very flat when viewed on a 0-100 scale, so instead I can narrow the scale to say, 40-60 (which I know is where the majority of the data points for that series lay). Once again I'm faced with the same problem when the highest value on the chart is like, 58%.
Instead, I'd like it to perhaps go 40,45, 50, 55, 60 or whatever suits.
Can FM manage this?
I'm aware the charting function is limited, but surely you must be able to manually set a scale?
Work and Order Schedule form excel file HELP PLEASE
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
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
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
HELP! Auto Import Many Excel Docs
By Jeff M
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: Trigger import process in which one at a time, the excel documents are imported into my database and a few additional scripts are run internally. The excel documents come to me as .xlsm files, which FileMaker doesn't like. To overcome this, I change the name to .xls before importing.
Here's what I currently have:
An applescript app called "Auto-Import" I startup when I'm ready to import a batch. It looks at an IN folder. One by one, it moves the files to a WORKING folder, changes the name, then calls on FileMaker to do a script. FileMaker is set to look for a static file named "importme.xls" in the WORKING folder. It imports, then runs a couple of parsing scripts. After a short delay, the Applescript app changes the filename back to its original name, then moves it to the DONE folder, after which it moves to the next item in the list from the IN folder.
I found this applescript somewhere and changed the paths and delay amounts until I got it to work...sort of. As you can imagine, I get lots of errors from FileMaker or Applescript trying to move on a do something before the other has finished. Boo.
Seems like the better way would be to have applescript code within the FileMaker scripts, so everything is controlled by FileMaker. I'm open to any and all suggestions. Or if you know of something similar, point me to it. Please help!
Pie Chart from Yes/No data in one field
By Jason H
I'm trying to create a Pie chart that shows how many "Yes" and how many "No" responses I have in my data.
The value of Yes or No is in ONE field across 72 records
When I make the chart I get 72 slices (there are 72 records).
I appears that I need to summarize the data to have two totals: Yes's and No's.
I tried to make a Summary field to do this but how do I express 2 different values?
I wrote a script that totals the Yes and the No values into two global variable but I can't assign two values to the Pie chart.
I'm missing something easy here....Help !