Hide import field!

[tmas73]

Is it possible to hide a field in the import window? I would like for the user to see only specific fields when he imports a comma, tab, of filemaker file from a different solution!

TMAS

[Razumovsky]

I do not think this can be done. You could create a proxy table for this with only the fields you would like displayed, and then script a secondary import into the main table.

-Raz

[tmas73]

I just tried that! I made a new table connected the fields to the new table (Only the ones to import) But it wont show up in my main table! How do I connect the Imported data from the Import Table to the Main Table??

Thanks

TMAS

[Razumovsky]

You do not need to connect anything. Your import table would be a duplicate of your maintable, without the offending fields. Then you would script an IMPORT from the import table to the main table. No relationships involved.

[tmas73]

Nice

How would you script this! Sorry for all the questions but I'm still trying to work around my filemaker

[Razumovsky]

Look at the import script step in the help file.

How/when/why you use the step depends on your workflow.

You will want to make sure you delete all the records in the import table after you get them in the main table.

[tmas73]

I have a sript that imports into table2, but how to I get it into the main table and (like you suggested) delete the other info in table2?? Please take a look at following test! Thanks for your help!

ImportTest.zip

[Razumovsky]

The whole proxy table operation is redundant if you are going to have 'Perform without dialog' selected on the initial import, as the user will never see the import fields.

I attached a modified copy that assumes you want the user to manually set up the first import.

ImportTest.zip

[tmas73]

Cool works like a charm! What if the user changes the filename. Thanks for your help! I know I seem anoying! Sorry!

[Razumovsky]

Which filename?

Look at the import script step in the help file. It will tell you how to specify files to import from.

It is generally a bad idea to allow the user to rename Filemaker files, as it can break relationships and filepaths.

[tmas73]

OK was just curious! Does this work in a runtime solution? Because the filename and extension will change for the runtime, I should rename the filename in the script to the possible runtime name?

[Razumovsky]

If you use the developer utilities to change the filename, you should not have a problem.

[tmas73]

Ok Thanks for your help!

Thomas