By Anuj Kumar
In My DB- Table ( Product) have a Container field.
i want Export Container Field. & save in The create folder.
i have write these script:-
In this script Folder Create successfully. & also Image Export Sucessfully On Desktop.
But I want export Image in The newly created folder. .
can any one help me to release this.
thanks in advance
I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers. Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values.
Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown. Everything is automated through scripts. In the main table (web database), the proposed quantities, pricing, leadtime, variations, etc. all use unstored calculated fields to determine the new value. I then have a separate field which is used to flag items that need updating. The major bottleneck of the entire process is the searching of this field. It can take sometimes over an hour to search this field. Other steps like exporting the changes can take a while, too.
I have done some things to optimize the database but it still seems that these unstored calc fields are what is dragging everything down. I have tried replacing some of those calc fields with text/num fields with "replace field contents" script steps (or auto entry) but it does not seem to make a difference because of the indexing. The database is not hosted or shared and my computer has decent specs with an SSD HD. I've got a simplified design chart attached for reference.
I am not sure that this is what comes with a large complex database file or if my design is flawed. The only two things I can think to try to reduce the processing time is:
1) Rewrite the scripts to update the supplier/inventory table records instead of replacing the records fresh each time.
2) Use a looped set field script to set the "change flag" field and/or the other updated price/qty/etc fields
Any thoughts or advice is much appreciated.
I'm surte this is quite a simple task ... for someone expert
I see I can export Record content using a Variable as the new filename for the exported file.
I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename.
The path for my db is as follows
file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12
Thanks a lot
I have a small issue with an export on a network path. Generally the path is alive, but very rarely it can happen that is not reachable. When not reachable, you'll get the error message from FileMaker that file can not be created .... (error code = 800). Since this dialog box can not be suppressed by Error Capture =On, the script will stop there until someone goes and clicks on the OK button of the message.
Was wondering, is there a way to check if the path is reachable, and if it is not reachable then to exit script?
Thank you, Toni
Suppose I have a column of numbers in a text field and I wish to export that field. What happens is that only the last number of the column gets exported. If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works: all numbers are exported. The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers. So: is there any way to export a column of numbers (contained within one text field) to the disk?