Inventory Module Imports Inefficient

Good afternoon,

We post Inventory Imports through the inventory module (Tools -> Import Issues), and its getting to the point where daily import postings will take 4+ hours a day just to post through. At this rate, we wont be able to post daily anymore. The .txt file we are importing is about 12,000 to 15,000  rows with 11 columns of data, being aroung 1mb in size for the import. Are we doing something wrong where the module won't make this process any quicker? Should we be posting a CSV file instead? We can't test something like this due to the timing. We can only work after hours too since posting through the inventory module will halt our purchasing department from doing anything within the system.

Thank you for any feedback.

Parents
  • 0

    We import .txt files that are much smaller.  (We import one job's issues at a time.)  So a couple of ideas:  Is your system up to the requirements?  Can you import smaller batches?  Can you purchase a second license for PO/IV? 

  • 0 in reply to Rhonda V

    How can I check to see if the system is up to the requirements? We are not able to post smaller batches, we are doing costs for dozens of jobs. We used to be at around 8,000 rows of data but even then it would take 3 hours to import. The other thing I forgot to mention is we are importing directly from the server so that it would go faster. Licensing isnt an issue, when we are posting then it causes others to not be able to post anything in that module in the mean time.

Reply
  • 0 in reply to Rhonda V

    How can I check to see if the system is up to the requirements? We are not able to post smaller batches, we are doing costs for dozens of jobs. We used to be at around 8,000 rows of data but even then it would take 3 hours to import. The other thing I forgot to mention is we are importing directly from the server so that it would go faster. Licensing isnt an issue, when we are posting then it causes others to not be able to post anything in that module in the mean time.

Children