Distribution, Manufacturing, and Internet Modules

[SRYork]

I have 2 thoughts on a major rework of this file that may make the effort more efficient.

1. You probably do not want to unilaterally delete using BOI.  Otherwise, you will remove the required STD record (see Jim Petrie's post above).
2. I assume you do not want to delete all of your existing records. Therefore, instead of trying to conditionalize your BOI to only delete certain records.  I would recommend trying:
• Export your entire IM Price table into an Excel spreadsheet (It is just easier for me to see the "whole picture" when using a spread sheet.  You could use a CSV text file or any other export file that you are comfortable with.  Then in the Excel spreadsheet
• Remove the records you wish to delete
• Edit any remaining records
• Add any new records
• Reinitialize your IM Price table
• Use the BOI to add all of the records remaining in your Excel spreadsheet.

You could script this so the first thing your script does is remove all of the records in the price table then add all of the records in your Excel spreadsheet. That would replace reinitializing your IM Price table as noted above. If you do this, going forward all you should have to do is maintain your spreadsheet and re-run your script. If you do not use your script to maintain the price table going forward, you will have to again export your price table to insure you are working with the latest and greatest to before re-running your script.

[robbybob]

Has anyone seen MAS create a second data file when the first one gets too big? My clients has both an IM_PRICECODE and an IM_PRICECODE_1 file. What is strange also is that I cannot see the _1 file in Windows Explorer. Help!

[khmackall]

I hope that what you are seeing is that the file is segmenting and the segment has a .001 extension.

We added support for Multi-Segmented Data files as of MAS 90/200 Version 4.40.  This allows us to support file sizes greater that 2 Gig.  When the file approaches 2 gig, a segment is created with a .001 extension.  We support up to 16 segments per file.  As each new segment is added, the extension will increment .002,.003, etc.  Each segment can be approximately 1.8 Gig allowing for a file to grow to about 30 gig in size.

As for not seeing the segmented file in Windows Explorer, that may be a Windows setting.  Check the view settings under Folder options to see if you are Hiding files.

Thank you,

Kent