jp98

i need to import records into a portal in my database but i have come across a number of problems. i have a table that contains a list of all products with product category, product name, product description etc. etc. the data i need to import is a list of products that are included in a quote for a customer. however, this data only includes product name, product description and quantity. to use this data i need to run a script that also finds the product category for each product before it imports it into the quote. currently i have a portal where i can select product category from a dropdown, then a second dropdown beside that displays all products within that category which i can select and once selected it will also display the product description beside it and a price from the table mentioned earlier as well as setting the quantity to one. what i can't work out is how to import into this portal so that it does all the above things. my thoughts so far have been to import the data into a separate table and then run a few looping scripts from there to find the additional information and then import the records to where they are required and then a final script step to delete all records from this additional table - pretty much just a temporary storage table. sorry for the extremely long message and for how confusing it is but hopefully you can help me resolve my problem!!!

just thinking about it a little bit more - if you have a separate portal on each tab, just set the filter so that in the portal on the documents tab, filter is set to file_type::file_type = Documents and for the one on the images tab it is set to file_type::file_type = Files. however, this will only work if you have a separate portal on each tab (which is simple enough to do but if you change any styling you will have to do it to both tabs which can become a bit of a pain once you start getting more tabs.) and this will also only work for filtering the returned records - you will have to use the formula Get (ActiveLayoutObjectName) to set the file_type for new uploads - possibly in a script with the set field command or whatever it is.

i'm as knew as you and i don't have the 15 years in application development but i think i might be able to help you to a certain degree here. based on what i found out from toddgiest from stackoverflow (might pay to check out his answer to someone elses question here ) you can set a value/name for each tab by double clicking on the tab (should bring up black border around it) and then in the inspector under Position, enter the name of the tab in the name box at the top. then click the other tab and do the same. you can then use the Get (ActiveLayoutObjectName). i will have to let someone else help you more as i am quite busy right now, but if in the portal you go filter records and specify and then use Get (ActiveLayoutObjectName) = "Documents" or whatever there it should work i think.

this is what i want to do with the vbscript I want to be able to click an import button in filemaker which runs the VBscript to apply the macro to a specified excel sheet in a certain location (this will always be the same name but it will contain different data each time), then imports the data from the excel sheet into filemaker matching up the columns and then at the end of the script deletes the excel file from the folder we got it from. would this work? would the vbscript open the file, run the equivalent macro (process the data), close the file and delete the file and then all filemaker needs to do after calling it up is import the data - is that correct or would filemaker do some of this? and how does filemaker open vbscripts? would this whole process be able to happen blindly?

thanks very much.

what is the "equivalent VBscript code" to a macro?

I need to do a similar thing - execute a macro in excel then import the data in a single script - any suggestions?