Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Deleting information from a table with the MIF
September 8, 2010
11:17 am
Avatar
jimdavis@live.com
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello,

Maximo 7.1.1.6

After using a flat file and the MIF to import some new craft codes I needed to go back in and remove the old craft codes. I changed the command from AddChange to DELETE and then ran the Data Import in Exchange Services. I did this thinking that the DELETE would remove all of the lines I had listed in the flat file. I did NOT get an error message and everything seemed to run just fine.

The problem is that the old entries are still in the Craft application.

Any ideas?

 

-Jim

September 8, 2010
12:25 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 1, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

September 8, 2010
12:36 pm
Avatar
jimdavis@live.com
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

I am currently loading:

CRAFT|DESCRIPTION|ORGID|STANDARDRATE|

SKILLLEVEL|DESCRIPTION|SKILLLEVELRANK|SKILLLEVELRATE

 

Is CraftID a different field from Craft? If so, the CraftID field is not visable. How do I look up the values?

-Jim

September 8, 2010
1:05 pm
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 1, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

September 13, 2010
10:28 am
Avatar
jimdavis@live.com
Member
Members
Forum Posts: 3
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Chon,

Thanks for the help. It turned out to be a rookie mistake. I was trying to delete records that were still being used. The old craft codes were still listed on Job Plans. The error was masked in an overflowing queue. On top of that,  because I kept trying to run it I jammed up the middle ware. Once I flushed out all of the queues I was able to see the error. Rookie error. Don't try to delete something that is still being used.

 

-Jim

September 13, 2010
10:40 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 1, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14325

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1578

Posts: 4293

Newest Members:

Felipe Warlison Bill, Arlene Rydge, Anwar Indris, R B, Ray Hernandez, Divyani Kulkarni

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0