dmp Posted January 23, 2015 Share Posted January 23, 2015 I have a simple xls (tried csv too) file with a number value in it that has two decimal points (dollar value with cents) and when I import the file into fusion pro, it drops the decimal point and decimals. I've tried formatting the text as general/text/currency and none of those work. If I go to edit the fields it shows there the same way. Also in the same documents, I had some fields show up truncated after a certain amount of words with the copyfit turned on. I thought there might be a limit, but I have other fields with a lot more words that work fine. so I'm lost there too. Anyone have issues like these before and solved them? Cheers, dmp. Quote Link to comment Share on other sites More sharing options...
jwhittaker Posted January 23, 2015 Share Posted January 23, 2015 dmp Excel likes to "preformat" field types. Try putting text in the first record of every field. That way excel will think it's a text field and not a number field. Quote Link to comment Share on other sites More sharing options...
dmp Posted January 23, 2015 Author Share Posted January 23, 2015 Ok I'll try that. I think I figured out the truncating part too, there were soft carriage returns in there. sigh. dirty data is so mean. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted January 23, 2015 Share Posted January 23, 2015 In FusionPro 9.3, you can use an Excel file directly as the data source, without having to dump it to a flat file such as CSV. Quote Link to comment Share on other sites More sharing options...
dmp Posted January 23, 2015 Author Share Posted January 23, 2015 I was using 9.3+ and the excel file. I still can't figure out why it would disregard the decimals. even with those cells formatted as either general/text/currency etc.. I got it to work by making a csv and using the wizard to replace the file instead of "change input file" in the menu. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted January 26, 2015 Share Posted January 26, 2015 I was using 9.3+ and the excel file. Please forward the Excel file, along with the collected job, to FusionProSupport@PTI.com. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.