Any workaround for MNI limit of 1000? Need to process 10,000+ records from

Jess over 9 years ago

Any workaround for MNI limit of 1000?
Need to process 10,000+ records from CSV file and save it to database,but beforehand,it needs to process complex task ex. Generate/plot planned completion date based on milestones (7) and received date.. I don't think looping functions can be used here since there are lots of Database and Query rule interaction as part of the process. The records from CSV will be saved as the parent record and the generated data from each record as the child (1:M). Please advise. TIA.

Discussion posts and replies are publicly visible

Parents

0 ronp over 9 years ago

thanks for the reply Christine! I already thought of it as well, however,it will only work for the first upload...but for second upload of status updates per record, it would be the same 10000+ records with 3-9 fields that that needs to be updated, there are 7 milestones,meaning 7x that the data will be updated from those batch files..any suggestion?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ronp over 9 years ago

thanks for the reply Christine! I already thought of it as well, however,it will only work for the first upload...but for second upload of status updates per record, it would be the same 10000+ records with 3-9 fields that that needs to be updated, there are 7 milestones,meaning 7x that the data will be updated from those batch files..any suggestion?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data