Hello all, I am trying to import data into my tables from an excel spreadsheet. I am new with Filemaker, but am loving it already and will be purchasing the full version soon for 2 different organizations.
Here is my predicament. The spreadsheet is from S&S Activewear and it is their catalog in XLS format. It is set up like this...
|SNS Code||Wovens||Catalog Page #||Color Category||Size |
|Pieces per Case||Case Price||Dozen Price||Piece Price|
|46289||Calvin Klein Non-Iron Dobby Pindot Shirt - 13CK029||8||Colors||S - XL||24||$25.74||$29.60||$33.46|
|46389||Calvin Klein Ladies' Non-Iron Dobby Pindot Shirt - 13CK030||8||Colors||S - XL||24||$24.31||$27.96||$31.60|
This is 2 products of the over 8000 products. The line that says Woven is actually the category Woven. There are others as well. There are multiple sizes for each item and muliple prices for each size.
Does anyone have any ideas on how this could be imported or scripted?
I have attached the excel file to this post for example. I am wanting to have a method to just import this and update all information so I can tie into this with the prcing and quoting modules I am building in Filemaker.