お気に入りLaura Gil (Privat) が「Data Architects」で投稿 (元の質問者: Laura Gil)2021年9月12日 19: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表示件数を増やす
