Problem importing currency from .CVS
Posted: Sat Mar 28, 2009 7:45 pm
I am a very new user, so I may have missed something obvious but . . .
I am trying to import from a .CSV file, created in another application - I am running MyInfo Pro v4.23 under Windows XP. All of the following issues occur during this.
1. My import .CSV file inclues a currency field: Cover Price. In MyInfo I created an attribute named, Cover Price, with Type of number and Format of currency. I mapped Cover Price in my import file to the attribure Cover Price - who saw that coming? Importing from my .CSV went fine except no data came into the Cover Price (MyInfo) attribute on any of my records (documents). Changing the "type" to text worked with the "$". Changing the "type" to number and "format" to fractional worked, but only if all the "$" were removed from the import file (e.g., $14.95 changed into 14.95 before importing). Why?
2. Since I was importing a number, I wanted the "Alignment" to be on the right ("View/Attributes.../Attributes/Format"), but this didn't seem to work with either "text" or "number".
3. I did not have time to nail down the following problem, but this process flow seems to duplicate it most times. Select "View/Attributes..." from the main menu. The "Attributes" dialog is displayed. Select an attribute that you have created and click on the "Format" button. The "Format Attribute" dialog is displayed over the "Attributes" box. Change something in this dialog (here is where I suspect the exact change matters). Click on OK and both dialogs disappear (this is essential to the problem). The "Attributes" dialog has slipped (I don't know if it actually "slips" or what.) behind the main screen. If you don't know what has happened, it seems as if MyInfo has frozen solid. You just need to bring the dialog to the foreground and click OK. (I found this problem while trying to find the boundaries of problem #1. Maybe just importing or dealing with a new attribute or whatever had some effect.)
4. Also trying to change the location of a new attribute in the list, this relates to #3, caused some random, peculiar problems. Sometimes a MyInfo attribute would appear twice in the "Attributes" dialog, sometimes the format of the attribute would be change to text. I know that this isn't much to go on, but perhaps someone else has seen this?
5. After importing from a .CSV file, some of the titles of the new documents appear in bold and some don't. This appears harmless but, "what is going on?".
Hope that this is clear.
Thanks for any comments,
Philip
I am trying to import from a .CSV file, created in another application - I am running MyInfo Pro v4.23 under Windows XP. All of the following issues occur during this.
1. My import .CSV file inclues a currency field: Cover Price. In MyInfo I created an attribute named, Cover Price, with Type of number and Format of currency. I mapped Cover Price in my import file to the attribure Cover Price - who saw that coming? Importing from my .CSV went fine except no data came into the Cover Price (MyInfo) attribute on any of my records (documents). Changing the "type" to text worked with the "$". Changing the "type" to number and "format" to fractional worked, but only if all the "$" were removed from the import file (e.g., $14.95 changed into 14.95 before importing). Why?
2. Since I was importing a number, I wanted the "Alignment" to be on the right ("View/Attributes.../Attributes/Format"), but this didn't seem to work with either "text" or "number".
3. I did not have time to nail down the following problem, but this process flow seems to duplicate it most times. Select "View/Attributes..." from the main menu. The "Attributes" dialog is displayed. Select an attribute that you have created and click on the "Format" button. The "Format Attribute" dialog is displayed over the "Attributes" box. Change something in this dialog (here is where I suspect the exact change matters). Click on OK and both dialogs disappear (this is essential to the problem). The "Attributes" dialog has slipped (I don't know if it actually "slips" or what.) behind the main screen. If you don't know what has happened, it seems as if MyInfo has frozen solid. You just need to bring the dialog to the foreground and click OK. (I found this problem while trying to find the boundaries of problem #1. Maybe just importing or dealing with a new attribute or whatever had some effect.)
4. Also trying to change the location of a new attribute in the list, this relates to #3, caused some random, peculiar problems. Sometimes a MyInfo attribute would appear twice in the "Attributes" dialog, sometimes the format of the attribute would be change to text. I know that this isn't much to go on, but perhaps someone else has seen this?
5. After importing from a .CSV file, some of the titles of the new documents appear in bold and some don't. This appears harmless but, "what is going on?".
Hope that this is clear.
Thanks for any comments,
Philip