PDM_load on Service_desc table

[Lucas Mesquita]

Is it possible to load data into Service_Desc table (the one with service types)?. i already tried, but the "code" field is required and i don't know which data i need to use for it.

[Jon_Israel]

Hi Lucas,

If you go to create a new service type in service desk through the GUI, you will see that you would need to fill in the "code" field.   The "code" field is typically an abbreviation of the name of the service type, which is used as a reference in some cases.  So for example if you had a service type called "Lucas Service Type" you could make the code  "lcssvctyp" or something similar.  This value needs to be unique for each record. You just need to add that to your load file and it should work without a problem.

Hope this helps.

Jon

[Lucas Mesquita]

Actually through the GUI there is no "code" field. for Service Type ( Service_Desc table)

[Lucas Mesquita]

i tried to input a random code and got the following result:

[Chi Chen]

Lucas, this is very tricky...code is dynamic generated when you create one record in Service_Desc table...my gut feeling is(not tested yet lol), you would need to have "code" as one of the entry in the input file and have its value as ""(that is, blank for the moment and let SDM fill it in later)...give it a try. Thanks _Chi

[Lucas Mesquita]

already tried that :/ 

[Jon_Israel]

Did you try to run "pdm_load -i" against your load file while leaving the id, and code fields blank?

When you attempted the last load and it failed iwth the conflicting row error - did you check to see if you already have a row with the same ID number?

Can you share the load file you are using so I can do some quick tests here?

Jon

[Lucas Mesquita]

the load file i'm using 

 

TABLE Service_Desc
sym tenant schedule
{"SLA de 48 horas","","wrkshft:4600"}

[Lucas Mesquita]

I got it ! i just created a big number (30 characters) and it passed

[Jon_Israel]

Hi Lucas, 

thanks for sharing. I just attempted the same, and unfortunately it appears to be a limitation of the product at this point.  I dont see any way to do this at the moment.

Your best bet will be to create them through the GUI

Jon

[David Ng]

Hello,

 

Can you describe why you need to load content into this table?  What is it you are trying to do here?  How does the loading of content to the given Service_Desc table help you here?

[Lucas Mesquita]

To create multiple service types