# New Customer Doesnt Import Into Sandbox **URL:** \ **Category:** Integrator.io\ **Tags:** ftp, integration-app, import, netsuite\ **Created:** [April 9, 2025, 2:19pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204 "2025-04-09T14:19:01Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![baltazarrocha](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@baltazarrocha](https://connective.celigo.com/u/baltazarrocha)\ **Post date:** [April 16, 2025, 2:02pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/21 "2025-04-16T14:02:27Z")
I was mirroring the screenshot you sent me. This one. ![The image shows the "Edit mapping" interface of Celigo with highlighted fields for selecting internal IDs and employee records settings. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2762f82ef19cea08b2cb6c1c1d7d5f12743ba514.png) But now the filter should look at sales rep id? ---
**Author:** ![baltazarrocha](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@baltazarrocha](https://connective.celigo.com/u/baltazarrocha)\ **Post date:** [April 16, 2025, 2:19pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/22 "2025-04-16T14:19:00Z")
I changed the filter to sales rep ID ![The image shows a configuration interface for setting up a dynamic NetSuite search with filters for employee records. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4240654ca9ef900a52e0c94a3a0aaf989cefd839.png) But it still errors out ![The image shows a JSON error message indicating a mapping failure for a specific employee record, alongside a data structure containing customer identification and sales information. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/d3653d9e17cb3bb087142c7b938961ae31452e1f.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 16, 2025, 2:22pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/23 "2025-04-16T14:22:00Z")
Why are you saying `Sales Rep ID` is `Name`? ---
**Author:** ![baltazarrocha](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@baltazarrocha](https://connective.celigo.com/u/baltazarrocha)\ **Post date:** [April 16, 2025, 2:30pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/24 "2025-04-16T14:30:09Z")
Im trying to translate the sales rep id on the employee record, to the sales rep name, so it appears on the newly imported customer. Here is the employee sales rep id ![The image shows an employee information page, highlighting details such as job title, supervisor, and a sales rep ID. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/1c9c5f2ea4ea5d36391b087da6e5229985059a92.png) And here is the customer record with a sales rep field for the sales rep name. Clearly im missing something?? ![The image shows a customer information interface with details like customer ID, status, contact information, and classification, along with navigation tabs for further details and interactions. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/762c33d100cdde8f6878f1a026d374f1dd7f7893.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 16, 2025, 2:42pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/25 "2025-04-16T14:42:50Z")
Change it back to this and keep `Internal ID` as the returned value and keep it as a mapping to `Sales Rep (Internal ID)`. ![The image shows a software settings page with configurations for a NetSuite search, including options for dynamic or static search, a record type set to "Employee," and filters for Sales Rep ID. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/cd326997a45a2dc0e934e73063730ae8c5a2d001.png) ---
**Author:** ![baltazarrocha](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@baltazarrocha](https://connective.celigo.com/u/baltazarrocha)\ **Post date:** [April 16, 2025, 3:15pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/26 "2025-04-16T15:15:57Z")
Whoa, i think you nailed it Tyler. I just imported two new test customers with different sales rep id and they correctly mapped to the sales rep names. Im going to test a couple more scenarios, but so far so good! ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/54fdc22c5d2af112d76f808c5e109cfdab424a8b.png) ---
**Author:** ![baltazarrocha](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@baltazarrocha](https://connective.celigo.com/u/baltazarrocha)\ **Post date:** [April 16, 2025, 5:02pm UTC](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204/27 "2025-04-16T17:02:54Z")
Yeah, we imported a couple more new customers and the logic is working! I think we can close this ticket for now. We now have to do something similar with a new Item FTP file that will contain new Items. So i may start a new thread for that one if needed. I truly appreciate everyone's help and patience! [Previous page](https://connective.celigo.com/t/new-customer-doesnt-import-into-sandbox/4204.md?page=1)