Salesman0Gil

To close this out. I found an excel function (Index) that could accomplish this task.

Thanks. The only issue is that there are ~12 data sets, each with eight zones, so 96 imports is a bit much.

Weight z1 z1 z3 z4 1lb $1 $2 $3 $4 2lb $2 $4 $6 $8 Quick example....

Ah. There is the catch. There is a field for each zone. So there is one weight and 6 zones. You need to cross reference the weight to the correct zone for the cost.

There is an exact weight for each.

Interesting problem that I haven't run into in a while, and I can't remember how to do it. I have a reference table that contains the fields weight and zone. For each weight there is a different cost for the corresponding zone I have a table that list the zone and weight of multiple items. I need to lookup the package cost for the items based on the weight and zone. A little help?

Ok. Lets see if I can clear this up: Importing: The source data arrives in csv form, this is brought into Filemaker to add additional data such as user data. This will grow into multiple different data sets, for instance monthly file for vendor 1 and a separate table for vendor 2. My original plan was to have separate tables for each vendor to modify the data into a uniform set then import into a shared table. Ideally, a script would import data from each set into a standard table designed for exporting. This would carry the load of formatting for the export. I can handle 99% of this, but I can not see a nice way of having a record that is essentially a header record with customer info, followed by product data records related to header record, then do this across 500 lines of data. The export needs to be a csv. Thanks for the help!

Wow! It's been a while since I posted here... Since FM 11 was new... Any way. Working on automated process to bring info together, then export for another process. A new snag I don't know if I have ever solved before. I am exporting sales data. So the import file needs a line with customer data followed by multiple lines of product data. Line 1: Customer 1 Data Line 2: Customer 1 Product 1 Data Line 3: Customer 1 Product 2 Data Line 4: Customer 2 Data Line 5: Customer 2 Product 1 Data etc... I have all the data, but am unfamiliar with a method to script this..

Hello All Not sure if this is the correct forum for this, because it is combination of calcs and scripts, but I'll start here. I have a sensitive database, that I am currently tracking who modifies which record and when. I have a layout script trigger that move the simple auto enter modified time stamp and account to one of six fields. It builds, if field 1 is full, it puts the data in field 2, etc. I need one more piece of data: Which field was modified. There are ~200 fields, and any of them can be changed. Has anyone ever been successful in logging which filed was modified on the fly? Gil

Tried the server sample and it failed. I grabbed a file from the server and hosted it with pro, no problem. I also tested the web server, by going to the default home page, and it is working. Also, forgiveness, forgot it is Win Server 2008 R2 It looks like it is time to reinstall FM Server and IIS

No worries... You never make it to the authentication for any database. You click a database from the home page, and you receive the error "Database Not Available" no issues installing FM Server. I completed the deployment. Is there a way to uninstall/reinstall the IWP aspect alone, and not the entire FM Server?

Thanks for the ideas. I do have FM Server Advanced, and IWP is turned on.

Also. even though we do not use them. PHP and XSLT receive the error "the php connection to the fmserver_sample database failed" when tried. They are enabled.

I recently did a re install of the FM Server to a new machine. I can navigate to the fmiiwp default page, and when I click a database I receive "Database Not Available" I have checked permission and and ensured IWP was enabled. Any ideas?

Thanks. I can't install on a different network, making the new one on a VM. Tried the static IP, and still failed. Any other ideas?