asked on Salesforce Identifying field widths from Data Type? Can widths be changed? Import limitations
I have looked all over and wondered if there was a page either on the Salesforce community or other that had the following questions answered above. I have the following problem. I have a TASK table created from another program where the data was exported cleanly to Excel and saved as CSV. I am trying desperately to import it into salesforce from the CSV attached. I am aware I can use the ACTIVITY table and I can use it I assume if this is not possible. I would think that the TASK table which is so close to what I need would accomodate this without having to create all new fields and having to go with the Table Name Change (from TASK to ACTIVITY Table)
I can see that there are DATA TYPES that designate the width of the field and others that do not. Is there a default width for a:
1. Picklist
2. Email
3. Lookup (User) "What is the difference between number 3 & 4 ?"![Is there a place I can find all of the answers. I have looked and must not be using the right search terms?]()
4. Lookup (User,Calendar)
5. Phone
6. Reference
If there is a default width. Where do I find it.
I am desperate to find out if I can do the following:
1. Identify default widths of all DATA TYPES?
2. Can the widths be changed?
3. Can all DATA TYPES be imported to or is it just some of them?
My biggest problem is getting the right search terms in place to search so maybe the answers are out there. I have not been successful finding them. I have spent days searching....no exaggerations here either. Your help is appreciated.
I can see that there are DATA TYPES that designate the width of the field and others that do not. Is there a default width for a:
1. Picklist
2. Email
3. Lookup (User) "What is the difference between number 3 & 4 ?"
4. Lookup (User,Calendar)5. Phone
6. Reference
If there is a default width. Where do I find it.
I am desperate to find out if I can do the following:
1. Identify default widths of all DATA TYPES?
2. Can the widths be changed?
3. Can all DATA TYPES be imported to or is it just some of them?
My biggest problem is getting the right search terms in place to search so maybe the answers are out there. I have not been successful finding them. I have spent days searching....no exaggerations here either. Your help is appreciated.
SalesforceDatabases
Last Comment
ValentinoV
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
What I mean is what is the Length and or width in number of characters long the field is. One of the errors I get out of the Salesforce Data Loader is that the width of the field is different from the field the data is being imported from to the data width of the field it is going into. SO if the CSV data field width is 15 and the field I am importing into is 12 then it will not fit therefore will not import to.
ASKER
I guess what I was looking for was if there was a defined default width of any field in Excel that when created in Excel it was set at. For instance if a General format for a field type was set to 12 or 18 characters or maybe even 255. I just could not find anything anywhere that said what was the default width value set at. Your help was appreciated but the question was not answered. If I open an excel file and I click on Column width it changes with the movement of my cursor. between columns. There does not seem to be a limit to the characters in the column. That I can see. When I opened it in Access I see a field type defined not a set number for the limit of characters.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
All responses were very helpful. The First one from Valentino was as much the best solution as the Crystal's was. Both had merit and had useful information. I understand the limits of Excel and know now that the width is not set by default but adjusted inside of Excel. The only way to see the defined width is in a tool like Access. Thank you both for your efforts.
you're welcome ~ happy to help
As a bonus: the Data Loader has a setting that allows string truncation when if exceeds the target length. I would try to avoid having the issue in the first place but if really needed and applicable you might consider using it. See Configure Data Loader for the options.