Importing CSV Manually
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2011 11:44 AM
I am attempting to import CSV manually and am having trouble. I will eventually want to do a scheduled import but I figured for the time being I will create a transform map and test it out manually. I have used the import set application a lot importing and transforming excel files.
I am importing the data via the Load Data module in the Import Set application. I am creating a new new import set and I upload the CSV file from here. After this I attempt to create a transform map but see the wrong information from my source table. I have attached a screen shot with the fields I see available. Please let me know what you think... thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2011 12:26 PM
When an import set table is created, you will get about 15 system created fields with your table that are auto generated. These fields include sys_id, created, updated, etc fields.
You will find that your other fields should be there as well.
Therefore if your excel file had 3 fields, your import set table would be generated with 15 system fields + 3 fields from spreadsheet = 18 fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2011 12:53 PM
Do you see in my screen shot where the bottom of the source field choice list are my fields listed as 1 field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2011 01:04 PM
I saw your screen shot, but didn't realize your fields were all showing up in one. I just tried this on the demo instance with an XLS file (see attached file). It worked just fine. Maybe your header is messed up in the file you are using as your source?
Feel free to try my file and see if you get the same results as you did before. If you are able to repeat the problem with my file, you may need to contact support.
Let me know how this file works for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2011 01:13 PM
Maybe I have a misunderstanding about importing CSV files. I have a CSV file and when I open it in excel it has a bunch of data separated by comma's only in column A. I thought if you upload it as a CSV the commas let the system know they are separate fields. For example here is my header which is only in column A:
dimUser_EmpFullDetail,dimUser_EmpCntryDetail,dimUser_PrimaryOrgNameDetail,dimUser_MgrEmpFullName1Detail,dimActivity_ActivityNameDetail,dimRegistrationStatus_NameDetail,dimActivity_StartDtDetail,dimSuccess_NameDetail
I see your field works because they are in separate columns. I do have experience importing regular xls files, I was thinking CSV worked a little different?