즐겨찾기Laura Gil (Privat) 님이 Data Architects에 글을 올렸습니다 (최초 질문자: Laura Gil)2021년 9월 12일 오후 7:00Laura GilHow to prepare CSV files replacing Ids from Production in a CSV from Sandbox with Access?Hi all,Unfortunately I could not find a blog or documentation how to work with MS Access and Salesforce in cases where you want to prepare CSV files to load from a Sandbox to Production.Say, you have Price Book Entries and you would like to prepare the template in order to replace the ID of the price book and product in a CSV containing data of the Sandbox and you want to replace those IDs with the ones in the Production environment. I have been working with Excel and I know there is the function VLOOKUp there but to be honest, I don't like to work CSVs with Excel. It is pretty cumbersome. I would appreciate if someone could give some guidance how to do it with MS Access. #Sales Cloud #Service Cloud #Nonprofit #Trailhead #Automation #Integration더 보기댓글 추가댓글을 작성하세요...굵은 글꼴기울인 글꼴밑줄취소선불릿 기호 목록번호가 지정된 목록링크 추가코드 블록이미지 삽입파일 첨부링크 URL취소저장0/9000답글 쓰기
Laura GilHow to prepare CSV files replacing Ids from Production in a CSV from Sandbox with Access?Hi all,Unfortunately I could not find a blog or documentation how to work with MS Access and Salesforce in cases where you want to prepare CSV files to load from a Sandbox to Production.Say, you have Price Book Entries and you would like to prepare the template in order to replace the ID of the price book and product in a CSV containing data of the Sandbox and you want to replace those IDs with the ones in the Production environment. I have been working with Excel and I know there is the function VLOOKUp there but to be honest, I don't like to work CSVs with Excel. It is pretty cumbersome. I would appreciate if someone could give some guidance how to do it with MS Access. #Sales Cloud #Service Cloud #Nonprofit #Trailhead #Automation #Integration더 보기
