Client Management Suite

 View Only
  • 1.  How do I pre-process import data for importing computers

    Posted May 04, 2017 04:05 PM

    I am importing order information from another system just using csv files.  For some reason for Mac computers the spreadsheet has an extra character at the beginning of the serial numbers, which causes a problem since once we image these up and they report they are not the same machine and do not get merged together.

     

    For example here is a row of data  and the mac computer serial number actually starts with the C so it is adding an S to all of them from our vendor

    Serial Number Model (Manufacturer) Manufacturer (Manufacturer)
    SC02xxxxxx MACBOOK PRO 15IN 2.6GHZ I7 256GB SILVER W/TOUCH BAR APPLE - SYSTEMS  

     

    I do see that I can pre-process the data using a funciton of sorts in the console, but I am not familiar with how the function has to be created.  Basically I would like if the manufacture is like apple then strip the first character of the serial number

     

    Any help is appreciated



  • 2.  RE: How do I pre-process import data for importing computers
    Best Answer

    Posted May 08, 2017 04:02 AM

    How is your C#?

    Altiris 7.6 Connector: How to pre-process import data
    https://www.symantec.com/connect/forums/altiris-76-connector-how-pre-process-import-data

    Connector: How to pre-process import data
    https://www.symantec.com/connect/forums/connector-how-pre-process-import-data

    Connector Solution Pre-Processing in Asset 6.5
    https://www.symantec.com/connect/articles/connector-solution-pre-processing-asset-65

    ---

    Alternative: It might be easier to create an Excel Macro to do it and run that if you're better there.



  • 3.  RE: How do I pre-process import data for importing computers

    Posted May 08, 2017 09:48 AM

    Thanks, yeah didn't realize you had to know C# to do this, which I do not.  We are using sharepoint auotmation to copy an email to a share, so I may work with our sharepoint team to see if they can modify the excel file during that process if that would be easier then learning C#, lol