Submitted by lbw2112 on 2020/04/28 11:09
 Hello,
 
Something I just noticed and bothers me.  When I import text files, it fills out the FileRef, FileFullName,FileName,FilePath fields.   
 
It looks the same as if I link to an external file, without the hyperlink of course so it causes a little confusion to me especially when I have thousands of them.
 
I thought just the regular fields would be populated, i.e. - Item Name, Document Pane, Grid imported into name and others like Itemhashtml, etc.  
 
I'd understand if it was just for reference, but I usually delete the original import files after importing them so they don't point to anything.
 
My question would be is there a way to have it import without those file references in the fields?
 
If not, is there a script I could use to go through items I have in a grid and clear those references?  I could just create an Import grid and import whatever into that and run the script.
 
Thanks,
Larry

Comments

Hi Larry,
 
Good point !
 
In v115c:
  • New: File Import: Dialog is now shown to set import options
For the previously imported files, you can show them in a grid (either Journal or Scratch), and use one of:
  1. Select all items and delete the values using the Properties pane
  2. Select the cell values and hit Delete. For the FileRef field, you'll need to use method (1) above however
 
Pierre_Admin
IQ Designer
 

lbw2112

2020/04/28 12:37

In reply to by Pierre_Admin

 Thanks Pierre,
 
I didn't even think about that solution.  Easy done.
 
Also thanks for the v115c fix.
 
Larry