|
| | | Supreme Being
Group: Forum Members
Last Login: 10/8/2008 8:13:28 PM
Posts: 126, Visits: 152 |
| | Is there a way to delete data in specific fields from all files in a particular folder? Thanks, |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| | There is a commercial program that can do that. Drop me an email if you want info. There isn't another method that I'm aware of.
- Mike
mike@mtig.biz |
| |
| | | 
Supreme Being
Group: Moderators
Last Login: 11/15/2008 10:00:24 PM
Posts: 835, Visits: 1,899 |
| | It's not too hard. Create a report template with the fields you want to batch delete. Make sure in the first field of the report template you have field ID 7. Generate that report and export it to an Excel file. Open Excel and blank out the fields in the files you want to delete. You may want to also delete the rows for the files which you don't want to touch. Once you're done, save the Excel xls to a CSV, then setup a data import template with the fields you want to update (you can just copy and paste the columns from you report template). Click the Advanced button in the template and set comma for delimiter and quote for text qualifier, click OK, then click Batch Import, select the location of your text file and click OK. The above might sound like a lot of steps, but when you've done it once or twice it's pretty quick.
Bryan
Point Product Manager |
| |
| | |
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| I stand corrected. That actually should work fine.
- Mike
mike@mtig.biz |
| |
|
|