Joe Germann

Most likely permission issue. I have some other work around thoughts on how to handle chase a solution, even a crazy work around. Not tonight. It's cold beer time.

Thanks so much for the reply. I'll watch carefully for that issue, but I am trying to read/write files on a Synology NAS from a C:FM Application. The NAS is mapped as drive W: on the PC. Is there a way I can specify file paths via filewin: and imagewin: so that FM will import or write a PDF or XLS file to the NAS? Thanks, Joe

My Filemaker 18 Pro application files (.fmp12) are physically located on a NAS mapped drive W:. The application itself is running on the drive C:, accessing the fmp12 files from the W: NAS. I would to execute the Script step "Save Records as PDF" and specify a "filewin:<output filename>". This works perfect if I'm saving files on the drive C:, with "filewin://SERVER_NAME/share_name/Users/Joe/Documents/test.pdf". I would love to specify a filewin: to a place on the Mapped NAS W: drive but can't get it to work. I've tried every possible combination I can think of but FM will not save the records there. Any suggested solution? Native or even with a plugin? Thanks, Joe

Thanks so much for he help. I did script that used BOTH Inventory and NonInventory. I'll rewrite it to do just the single itemQuery and pull all of the different items into a FM buffer. This is a real nice way for me to check if an Item needs to be added or not to QB. Joe .

YEA!!!! I got it figured out. My items are BOTH Inventory and non-Inventory items. I was just pulling the Inventory Items; I just need to pull the non-inventory items also. Thanks so much for your guidance. Joe

Something is still screwy. I wrote a Script to download ALL ItemInentoryQuery items BUT only 15 ItemInventory records appear to be opened that I can sequence through and they are not in the order I would expect. The script is very, very simple. What am I missing or doing wrong? # Start with as clean FM buffer Go to Layout [ “R3D_PCQB_Inventory” (R3D_PCQB_Inventory) ] Select Window [ Current Window ] Show All Records If [ Get (TotalRecordCount) > 0 ] Delete All Records # The QB Item Inventory data to Pull PCQB_RqNew [ Select: On; Results: $$PCQB_RESULTS; Request Type: "ItemInventoryQuery"; Optional Attributes: ] PCQB_RqExecute [ Select: On; Results: $$PCQB_RESULTS; Hide FM Window: Off; Optional Filter: ; Optional File Path: ] PCQB_RsOpenFirstRecord [ Select: On; Results: $$PCQB_RESULTS ] Loop Exit Loop If [ $$PCQB_RESULTS = "!!ERROR!!" or $$PCQB_RESULTS = "END" or $$PCQB_RESULTS = "?" or $Loop_Count > 100000 ] New Record/Request Set Variable [ $Loop_Count; Value:$Loop_Count + 1 ] Set Field [ R3D_PCQB_Inventory::Portal_ID; $Loop_Count ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_ListID; QB Field Name: "ListID" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_TimeCreated; QB Field Name: "TimeCreated" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_TimeModified; QB Field Name: "TimeModified" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_EditSequence; QB Field Name: "EditSequence" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_Name; QB Field Name: "Name" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_FullName; QB Field Name: "FullName" ] PCQB_RsGetFirstFieldValue [ Select: On; Results: R3D_PCQB_Inventory::QB_IsActive; QB Field Name: "IsActive" ] PCQB_RsOpenNextRecord [ Select: On; Results: $$PCQB_RESULTS ] End Loop

Thanks. I'll give that a try in the morning. Joe

I am so stumped. I am trying to test ItemInventoryQuery to see if a Part Number is already in QB; If not then I will add it. I've tried to do a simple query on ItemInventoryQuery using a multitude of options (all // out in the attached clip) and it always returns !!ERROR!!. What do I need to do to find out if an Item is already in Inventory? Many thanks, Joe Set Variable [ $QB_PART_NUMBER; Value:AWI_Line_Items to Invoice::Line Item Part Number & AWI_Line_Items to Invoice::Line Item Part Option ] # Check (Query) if this item already exists or is going to be an ADD PCQB_RqNew [ Select: On; Results: $$PCQB_RESULTS; Request Type: "ItemInventoryQuery"; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "ItemInventoryRet::FullName"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "Name"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "FullName"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "ItemInventoryRet::Name"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "EntityFilter::FullName"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] // PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "IncludeLineItems"; Field Value: "true"; Optional Attributes: ] PCQB_RqExecute [ Select: On; Results: $$PCQB_RESULTS; Hide FM Window: Off; Optional Filter: ; Optional File Path: ] If [ $$PCQB_RESULTS ≠ 0 ] #The item does not exists; ADD to QB PCQB_RqNew [ Select: On; Results: $$PCQB_RESULTS; Request Type: "ItemInventoryAdd"; Optional Attributes: ] PCQB_RqAddFieldWithValue [ Select: On; Results: $$PCQB_RESULTS; QB Field Name: "Name"; Field Value: $QB_PART_NUMBER; Optional Attributes: ] PCQB_RqAddFieldWithValue [ Select: On; Results: $$

Thanks John, I am testing a configuration that has N instances of the SQL shadow table files, all related to a FM file/table structure that in itself is a shadow buffer of the data we want to exchange. In effect I have an exchange buffer sitting between both sides, the main FM and the SQL. Since I only need one SQL table at time, and I do not need real time response, I am only allowing one SQL sided file to be open at a time. I can post the date to the exchange buffer, and then post from the exchange buffer to the SQL instance that is open. It is a two step interchange but that is perfectly fine in this application. Each of the N SQL shadow file/tables instances is mapped to the correct DB via ODBC DNS setup and also related to the exchange buffer. I am constructing the test environment to check out the key elements of the design and to learn a bit more about the proper approach. I am sure I will have more questions. Thanks, Joe

I have multiple SQL databases, all exactly the same format and structure, that I talk to using FM9 scripts, standard relationships, and ODBC drivers. I only need to talk to one SQL database at a time. At this time, each database has it's own ODBC DNS and it's own relationship hook through a shadow table. Is there a way I can dynamically allocate, connect to, and talk to any one of my external databases. I only need to communicate with one database at a time. I also do not want to impose any restriction at all on the number of SQL databases I can access. I don't mind having multiple instances of DB shadow files, each with a different ODBC DNS, that I open and close to access. I would not like to have multiple relationship instances. If I could tie in the relationship stuff dynamically that would be great. Any suggestions or recommendations how to approach this problem would be appreciated.