|
| | | Forum Newbie
Group: Forum Members
Last Login: 11/30/2005 10:30:21 PM
Posts: 3, Visits: 5 |
| I have a custom website that stores the application info inputed by customers in a .txt file. Can I possibly import this into Point? I tried but no luck... I set up a template in point and put in the field id's to the corresponding items on my .txt file but when i go to import i get a message that says the column(i.e name is not found in the file being imported. The text file looks something like.. name: zach (tried putting a comma in between to designate a new item) city: san diego etc.... Maybe it can't be done from a .txt file, I also tried a .csv file. Are they not ASCII compatible maybe? thanks for any help.. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/30/2005 10:30:21 PM
Posts: 3, Visits: 5 |
| | Actually I just saw this solution pasted below in the "Error Messages" heading next to tech tips above. I guess I just need to figure out now if my text file is not a ASCII text file, the format in an ASCII must be setup in columns and rows condusive to importing because my text file is just all one space no columns that i can see.... | Error: The template specified a column (first name) which does not exist in the input data file. Cause: Point will give this error message when attempting to import an ASCII text file which has headers that do not match the import template headers. Resolution: The column in file sections will have to match the import ASCII text file exactly. If you are unable to resolve the message, try the following: - Remove the headers from the ASCII text file. Headers are the first row of information in the text file describing each column of data.
- Use numbers (1,2,3,4,etc.) for the column in file sections of the import template
|
|
|
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 11:36:26 AM
Posts: 1,183, Visits: 9,256 |
| Its actually ASCII delimited. You should be able to use the csv file you have every comma in it should represent a column, but the csv file may or may not have column headers.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/30/2005 10:30:21 PM
Posts: 3, Visits: 5 |
| | Ya i did get that to work using the csv file and using the comma to seperate columns but still having a silly minor issue... I put a comma in each line of the code for example name=state,> which automatically makes seperate columns. But then the excel file has state in one column and : california in the next column. The silly colon symbol is residing in the column with the inputed info. I cant get rid of it!? So when I import the info into calyx point its bringing that colon symbol in which I could go and erase for each but how tedious. Any workaround or way to get rid of the colon symbol? thanks for any help... |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| | Two fairly simple options: Write a VBA routine in Excel that strips the ":" before the CSV is written. The guts of the routine would use the Replace function ( Replace(cellref, ":","") ). Create a new column to the right of the one with the ":" and put a formula in it to strip the colon. Then use that field for input in the Import template in Point. The formula would be something like this: =REPLACE(A2,1,1,"") A2 is the input column, 1 is the start position, 1 is the number of characters, and "" is what you replace the ":" with.
- Mike
mike@mtig.biz |
| |
|
|