This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any.
There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets.
Application import is very cool and simple once you get it working.
Thanks, Tim
Maximo 7.5 TR, RM, WAS, MS SQL 2008
Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one.
Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet.
Import
Pat Morrow
pmorrow8@yahoo.com
On Wednesday, November 27, 2013 8:43 AM, "bratch@gmail.com" <bratch@gmail.com> wrote:
I
enabled application import on Item Master and Inventory and set up the
integration objects to allow the import and export. Using CSV files, I
have updated existing items and added new items. I’ve been able to update
cost and quantity information in inventory, but I cannot get it to take new
inventory items. I’ve made sure the item exists, and even tested it using
an export/import of all fields, to make sure I was not missing any.
There is one field, INVENTORYID, that is required by the inventory
object. Since new inventory does not have an ID yet, I tried with a blank
field and received a “Mandatory keys are missing” message. If this field
is required, I’m not sure how to get the inventory imported. I’ve been
searching a lot, but all the examples for using the application import are for
simple items or assets.
Application import is very cool and simple once you get it working.
Thanks, Tim
Maximo 7.5 TR, RM, WAS, MS SQL 2008
I looked up the next maxsequence value + 1 and tested it by importing one record and it worked. I was thinking that the system would auto-assign a next number, as it did for items.
Now I have the inventory information and the costs, but the balances are all zero, even though I populated AVBLBALANCE and CURBALTOTAL in the CSV. I noticed that there is an object structure for inventory balances, so I made a copy of MXINVBAL and enabled it for import/export on the Inventory application, the same as I did for MXINVENTORY (which includes INVCOST). When I go to inventory and try an import or export, in the Data Import window, the object structure for MXINVENTORY is available, but the one for MXINVBAL is not. Updating the balances is the last thing to figure out.
Thanks.
---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote:
Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one.
Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet.
Import
Pat Morrow
pmorrow8@...
On Wednesday, November 27, 2013 8:43 AM, "bratch@..." <bratch@...> wrote:
I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any.
There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets.
Application import is very cool and simple once you get it working.
Thanks, Tim
Maximo 7.5 TR, RM, WAS, MS SQL 2008
Apparently they each have their own security – you might need to look at that. Also: if you’re using the maxsequence #, check to make sure it gets updated – otherwise you may have problems adding stuff through the GUI.
I’m glad to hear your feedback regarding that functionality, since I’m just starting to look at that myself for my users. Have you rolled it out to the users yet? If so, what is their feedback? One of the big complaints my inventory users have is that they currently spend all their time doing data input.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of bratch@gmail.com
Sent: November-27-13 10:46 AM
To: MAXIMO@yahoogroups.com
Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID
I looked up the next maxsequence value + 1 and tested it by importing one record and it worked. I was thinking that the system would auto-assign a next number, as it did for items.
Now I have the inventory information and the costs, but the balances are all zero, even though I populated AVBLBALANCE and CURBALTOTAL in the CSV. I noticed that there is an object structure for inventory balances, so I made a copy of MXINVBAL and enabled it for import/export on the Inventory application, the same as I did for MXINVENTORY (which includes INVCOST). When I go to inventory and try an import or export, in the Data Import window, the object structure for MXINVENTORY is available, but the one for MXINVBAL is not. Updating the balances is the last thing to figure out.
Thanks.
---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote:
Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one.
Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet.
Import
Pat Morrow
pmorrow8@...
On Wednesday, November 27, 2013 8:43 AM, "bratch@..." <bratch@...> wrote:
I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any.
There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets.
Application import is very cool and simple once you get it working.
Thanks, Tim
Maximo 7.5 TR, RM, WAS, MS SQL 2008
Try overriding the I'd field on the object structure, in inbound setting restrictions check BOTH boxes then see if it auto assigns. If you an to so this for selective data loading then manipulating the ID isn't too much of an issue, if you plant to us application import it could quickly become a problem. Chris.
On November 29, 2013 at 11:18:35 AM EST, Incomm Solutions Inc. wrote: Apparently they each have their own security – you might need to look at that. Also: if you’re using the maxsequence #, check to make sure it gets updated – otherwise you may have problems adding stuff through the GUI. I’m glad to hear your feedback regarding that functionality, since I’m just starting to look at that myself for my users. Have you rolled it out to the users yet? If so, what is their feedback? One of the big complaints my inventory users have is that they currently spend all their time doing data input. Shannon Rotz From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of bratch@gmail.com Sent: November-27-13 10:46 AM To: MAXIMO@yahoogroups.com Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID I looked up the next maxsequence value + 1 and tested it by importing one record and it worked. I was thinking that the system would auto-assign a next number, as it did for items. Now I have the inventory information and the costs, but the balances are all zero, even though I populated AVBLBALANCE and CURBALTOTAL in the CSV. I noticed that there is an object structure for inventory balances, so I made a copy of MXINVBAL and enabled it for import/export on the Inventory application, the same as I did for MXINVENTORY (which includes INVCOST). When I go to inventory and try an import or export, in the Data Import window, the object structure for MXINVENTORY is available, but the one for MXINVBAL is not. Updating the balances is the last thing to figure out. Thanks. ---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote: Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one. Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet. Import Pat Morrow pmorrow8@... On Wednesday, November 27, 2013 8:43 AM, "bratch@..." <bratch@...> wrote: I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any. There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets. Application import is very cool and simple once you get it working. Thanks, Tim Maximo 7.5 TR, RM, WAS, MS SQL 2008
Well, duh! Chris: thanks for adding that. I obviously wasn’t thinking … good idea, if it works.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: November-29-13 8:23 AM
To: MAXIMO
Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID
Try overriding the I'd field on the object structure, in inbound setting restrictions check BOTH boxes then see if it auto assigns.
If you an to so this for selective data loading then manipulating the ID isn't too much of an issue, if you plant to us application import it could quickly become a problem.
Chris.
On November 29, 2013 at 11:18:35 AM EST, Incomm Solutions Inc. wrote:
Apparently they each have their own security – you might need to look at that. Also: if you’re using the maxsequence #, check to make sure it gets updated – otherwise you may have problems adding stuff through the GUI.
I’m glad to hear your feedback regarding that functionality, since I’m just starting to look at that myself for my users. Have you rolled it out to the users yet? If so, what is their feedback? One of the big complaints my inventory users have is that they currently spend all their time doing data input.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of bratch@gmail.com
Sent: November-27-13 10:46 AM
To: MAXIMO@yahoogroups.com
Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID
I looked up the next maxsequence value + 1 and tested it by importing one record and it worked. I was thinking that the system would auto-assign a next number, as it did for items.
Now I have the inventory information and the costs, but the balances are all zero, even though I populated AVBLBALANCE and CURBALTOTAL in the CSV. I noticed that there is an object structure for inventory balances, so I made a copy of MXINVBAL and enabled it for import/export on the Inventory application, the same as I did for MXINVENTORY (which includes INVCOST). When I go to inventory and try an import or export, in the Data Import window, the object structure for MXINVENTORY is available, but the one for MXINVBAL is not. Updating the balances is the last thing to figure out.
Thanks.
---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote:
Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one.
Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet.
Import
Pat Morrow
pmorrow8@...
On Wednesday, November 27, 2013 8:43 AM, "bratch@..." <bratch@...> wrote:
I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any.
There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets.
Application import is very cool and simple once you get it working.
Thanks, Tim
Maximo 7.5 TR, RM, WAS, MS SQL 2008
:-) The override/restrict is like a mystical option that inexplicably seems to solve all sorts if MIF challenges, that and it's partner in crime the alternate index field...!
On November 29, 2013 at 11:27:59 AM EST, Incomm Solutions Inc. wrote: Well, duh! Chris: thanks for adding that. I obviously wasn’t thinking … good idea, if it works. Shannon From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless Sent: November-29-13 8:23 AM To: MAXIMO Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID Try overriding the I'd field on the object structure, in inbound setting restrictions check BOTH boxes then see if it auto assigns. If you an to so this for selective data loading then manipulating the ID isn't too much of an issue, if you plant to us application import it could quickly become a problem. Chris. On November 29, 2013 at 11:18:35 AM EST, Incomm Solutions Inc. wrote: Apparently they each have their own security – you might need to look at that. Also: if you’re using the maxsequence #, check to make sure it gets updated – otherwise you may have problems adding stuff through the GUI. I’m glad to hear your feedback regarding that functionality, since I’m just starting to look at that myself for my users. Have you rolled it out to the users yet? If so, what is their feedback? One of the big complaints my inventory users have is that they currently spend all their time doing data input. Shannon Rotz From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of bratch@gmail.com Sent: November-27-13 10:46 AM To: MAXIMO@yahoogroups.com Subject: RE: Re: [MAXIMO List] Inventory Application Import - InventoryID I looked up the next maxsequence value + 1 and tested it by importing one record and it worked. I was thinking that the system would auto-assign a next number, as it did for items. Now I have the inventory information and the costs, but the balances are all zero, even though I populated AVBLBALANCE and CURBALTOTAL in the CSV. I noticed that there is an object structure for inventory balances, so I made a copy of MXINVBAL and enabled it for import/export on the Inventory application, the same as I did for MXINVENTORY (which includes INVCOST). When I go to inventory and try an import or export, in the Data Import window, the object structure for MXINVENTORY is available, but the one for MXINVBAL is not. Updating the balances is the last thing to figure out. Thanks. ---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote: Add the id field to your excel (csv) spreadsheet and populate it. (You can determine the first value by searching the table in the database for max value for that field.) Start the first row with 10 or so higher than the max. Increment each row by one. Go To Organizations and set the seed for the sequence to be higher than the highest number on your spreadsheet. Import Pat Morrow pmorrow8@... On Wednesday, November 27, 2013 8:43 AM, "bratch@..." <bratch@...> wrote: I enabled application import on Item Master and Inventory and set up the integration objects to allow the import and export. Using CSV files, I have updated existing items and added new items. I’ve been able to update cost and quantity information in inventory, but I cannot get it to take new inventory items. I’ve made sure the item exists, and even tested it using an export/import of all fields, to make sure I was not missing any. There is one field, INVENTORYID, that is required by the inventory object. Since new inventory does not have an ID yet, I tried with a blank field and received a “Mandatory keys are missing” message. If this field is required, I’m not sure how to get the inventory imported. I’ve been searching a lot, but all the examples for using the application import are for simple items or assets. Application import is very cool and simple once you get it working. Thanks, Tim Maximo 7.5 TR, RM, WAS, MS SQL 2008