Forums › Cached › CSV Import

This topic contains 5 replies, has 0 voices, and was last updated by ~angela 13 years, 9 months ago.

  • Author
    Posts
  • January 25, 2011 at 11:49 am #9531

    ~angela

    Had a bit of success with the entities, now attacking Matrix items. They are giving me a headache!

    Sure knocked me off my high horse and brought me some humility after these results last night.

    01/25/2011 2:49 am Customers Only – GeneralCustomerUploadPart1.csv – Complete 100% 24999 of 24999 records imported successfully CSV Response

    01/25/2011 2:52 am Customers Only – GeneralCustomerUploadPart2.csv – Complete 100% 15485 of 15485 records imported successfully CSV Response

    01/25/2011 3:51 am Customers Only – GeneralCustomerFromIDUpload.csv – Complete 100% 1899 of 1899 records imported successfully CSV Response

    Anyone up for tossing me a bone with the Matrix items? I can format, man can I format, but the help is sketchy, and I can use any help I can get.
    This is a cached copy. Click here to see the original post.

  • January 25, 2011 at 4:35 pm #9532

    ~angela

    RE: Need some Guidance on Matrix imports..

    Invalid Parent reference error…

    WTH??

  • January 25, 2011 at 6:00 pm #9533

    ~angela

    RE: Need some Guidance on Matrix imports..

    Originally posted by ~angela

    Invalid Parent reference error…

    WTH??

    Wow, I love talking to myself.

    The help file states to reference the parent item as shown in the example table in help under import matrix items clearly lists that the parent item name should be used… even shows it in the example….

    Then, hidden deeply within another section of help under troubleshooting FAQ for csv imports, invalid parent error it states that using names (instead of internal ID’s)under column ‘subitem’ of is NOT RECOMMENDED.

    I win!!! HA!!!

  • January 31, 2011 at 2:04 pm #9534

    sterlingr

    RE: Need some Guidance on Matrix imports..

    I have been having a lot of trouble too. So if I just reference the internalID all is perfect?

    Thank you!!

  • January 31, 2011 at 5:45 pm #9535

    ~angela

    RE: Need some Guidance on Matrix imports..

    Here is what I did.

    Imported the parent items in it’s own file.

    Child item file column ‘subitem of’ I used the parent internal id

    on the upload AFTER YOU MAP the fields, click on the little pencil icon in that mapped area.

    change the item drop down from ‘names’ to ‘internal id’.

    voila.

    (I say voila, don’t ask me how many hours #4 took me to figure out, cause I’m not tellin)

  • January 31, 2011 at 5:50 pm #9536

    ~angela

    RE: Need some Guidance on Matrix imports..

    and, here is a great big FYI!!!

    Once again, I learned the hard way……..hence my thread on hth do you mass delete…..

    when importing records there is a choice on the file type of ‘windows’ or ‘Mac Roman’. I was ripping through customers when I first noticed this. It defaults to ‘Windows’.

    I happen to run Macs.

    I had already imported some big files without changing the default. I wondered about it, scratched my head, then shrugged and figured, if it ain’t broke…..

    What I didn’t think of is the file types I had imported all being entities.

    Then came the import of transactions.

    In the csv conversion from Mac to Windows, complicated further with the upload into Netsuite, it seems the scientific notation decided that instead of 2010 as a year in date fields, 2014 would be a good choice.

    Lesson? Read the damn directions, angela.

  • Author
    Posts

You must be logged in to reply to this topic.