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.
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi,

> "1. Identify default widths of all DATA TYPES?"

do you mean, what is defined for each field? Picklist, Checkbox, Phone, etc are not really data types, as Valentino also said; they are control types.

Can you create an Access database and link to your tables?  If so, you can run the free Analyzer on the database with linked tables:

free Analyzer runs in Microsoft Access and documents databases
https://github.com/strive4peace/Analyzer

The Deep Analysis report (one of the 5 basic reports) will give you information on data types that are being used, and how long the values are.

have an awesome day,
crystal
0
 
ValentinoVBI ConsultantCommented:
In the case of LOOKUP you need to look at the field that it's actually looking up.  Your first LOOKUP retrieves OwnerId, that's the field you need to look at.  LOOKUP itself is not a data type but Salesforce functionality to retrieve a field based on matching conditions.

This might prove interesting to read: Data Types.  There's a link leading to the primitive data types, which seems like what you're after. There are also some more complex types such as collections, objects, ... Which in the end probably also contain primitive data types.  As for retrieving data I'd try to stick to the primitive data types.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi,

in Excel, Column Width applies to display width as Excel is not a database application -- nor is CSV.  That is why I suggested linking from Access.  From there, you will be able to see the data structure that is defined -- and if entry is done from there, extra characters will not be allowed.  If you want to change the data structure, it needs to be done where the data is actually stored -- if you are allowed to do that.

have an awesome day,
crystal
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
 
ValentinoVBI ConsultantCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.