Salesforce Identifying field widths from Data Type? Can widths be changed? Import limitations

RUA Volunteer2?
RUA Volunteer2? used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ValentinoVBI Consultant
Most Valuable Expert 2011
Commented:
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.
Remote Training and Programming
Top Expert 2015
Commented:
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
RUA Volunteer2?Tableau 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.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

RUA Volunteer2?Tableau 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.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015
Commented:
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
RUA Volunteer2?Tableau 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.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
you're welcome ~ happy to help
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial