Encore Forums Knowledgebase  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums  Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Printable Version

All Forums >> [Product Forums] >> [Productivity Software] >> [PrintMaster 18.1 and older] >> PM Export/Import >> Incorrectly formatted field name information

Page: [1]

Login Message << Older Topic   Newer Topic >>

Incorrectly formatted field name information - 8/6/2015 6:10:52 PM    suetoo   Posts: 5 Joined: 8/6/2015 Status: offline I am using PrintMaster Platinum 18 on a Windows 7 machine with OpenOffice Calc 4.0.0 as my spreadsheet. I just updated OpenOffice this morning in the hopes it would fix the error I'm getting. It didn't. Same error. I'm trying to import an addressbook into PrintMaster. I get the error... "The field name information in the file you have specified is missing or not correctly formatted. The first line of the file must contain the database field names. Make sure the "Export Field Names" (or similar) option is selected in the program from which you are exporting data." Obviously, PM thinks it isn't. This isn't my first rodeo. I've been saving my spreadsheet to a .csv file and importing to PM for years. I have no idea what changed. I can tell you what I've tried to fix it. Made sure "Automatically find column and row labels" was selected in Tools > Options > Calc > Calculate:. With and without that box selected I've tried various versions of Insert > Names > Define and defining labels for each column. The latest version of OpenOffice only exports to pdf and certainly doesn't give me any options remotely like "Export Field Names". Does anyone have a clue if this is an OpenOffice issue or a PrintMaster issue and, better yet, how to solve it? Thank you, Sue < Message edited by suetoo -- 8/6/2015 6:37:26 PM > Post #: 1

RE: Incorrectly formatted field name information - 8/7/2015 12:22:49 PM    JasonC   Posts: 1692 Joined: 12/14/2005 From: Hayward, CA Status: offline Newer versions of Open Office has changed the way MS Office formatting occurs in the program and as a result when saving the file, it may not save anymore if you try to save it as a Excel document format due to the way the formatting is now handled. You may wish to try going back a few versions and see if this solves the issue. _____________________________ Jason Carver Encore Sales Department and Customer Service www.encore.com For Tech Support, visit http://support.encore.com (in reply to suetoo) Post #: 2

RE: Incorrectly formatted field name information - 8/7/2015 1:42:31 PM    suetoo   Posts: 5 Joined: 8/6/2015 Status: offline Thank you. I've gone back and installed ever earlier versions of OpenOffice until I had gotten to 3.2. It still fails and I don't have any earlier versions stashed on my machine. Can you suggest a spreadsheet program (cheap or free works best for me, right now) that does export with the correct formatting? _____________________________ Sue (in reply to JasonC) Post #: 3

RE: Incorrectly formatted field name information - 8/7/2015 2:47:51 PM    ellengard Posts: 3253 Joined: 10/2/2006 Status: offline Since the csv file is giving you problems, what about trying another format, such as txt? Re: your csv file (sorry if this is an obvious question), have you verified that the field names in the first line EXACTLY match the PrintMaster field names? (in reply to suetoo) Post #: 4

RE: Incorrectly formatted field name information - 8/7/2015 4:31:01 PM    suetoo   Posts: 5 Joined: 8/6/2015 Status: offline Thank you. Yes, the headers appear to match exactly - at least for the visible characters. Do any of you know what the latest version of OpenOffice that does save properly is? Current versions seem to think .csv are the only text options anyone could possibly want. On the other hand, it almost seems like Printmaster is stuck. Is there a way to make sure the error is cleared between trials? Do you know where and how it stores its error conditions? Really. This used to work just fine for me and not all that long ago. _____________________________ Sue (in reply to ellengard) Post #: 5

RE: Incorrectly formatted field name information - 8/7/2015 5:59:47 PM    suetoo   Posts: 5 Joined: 8/6/2015 Status: offline I've read online about free file converters and have tried one. Still get the error message. Can someone tell me what the addressbook import file *SHOULD* look like and I'll write my own? If it works, I'll share. _____________________________ Sue (in reply to suetoo) Post #: 6

RE: Incorrectly formatted field name information - 8/7/2015 6:36:44 PM    suetoo   Posts: 5 Joined: 8/6/2015 Status: offline Got it!!! Of course the issue had nothing to do with the header! The work around isn't even all that odious. Okay. In OpenOffice, save to .csv, like normal. Do not choose to add quotes. Do choose for numbers to be as they appear. Once you have a .csv file, open it in notepad. Choose edit > Replace. In the Replace dialog box fill in the "Find what:" box with four commas (,,,,). Leave the "Replace with:" box blank and select Replace All. This will strip the four trailing commas from each line which is what has caused the issue. The resulting .csv file imports just like it should. Thank you for your help and suggestions. _____________________________ Sue (in reply to suetoo) Post #: 7

RE: Incorrectly formatted field name information - 8/7/2015 11:04:50 PM    ellengard Posts: 3253 Joined: 10/2/2006 Status: offline quote: ORIGINAL: suetoo ... the headers appear to match exactly - at least for the visible characters... strip the four trailing commas from each line which is what has caused the issue... Thanks for sharing your solution. Extra characters that aren't part of the headers or data would certainly mess up the import. < Message edited by ellengard -- 8/7/2015 11:10:02 PM > (in reply to suetoo) Post #: 8

All Forums >> [Product Forums] >> [Productivity Software] >> [PrintMaster 18.1 and older] >> PM Export/Import >> Incorrectly formatted field name information

Page: [1]

New Messages No New Messages Hot Topic w/ New Messages Hot Topic w/o New Messages Locked w/ New Messages Locked w/o New Messages

Post New Thread  Reply to Message  Post New Poll  Submit Vote  Delete My Own Post  Delete My Own Thread  Rate Posts

Please Note: In order to post a message on the forums, you will need to become an Encore Forum Member. Click on the Register link on the top of this page and follow the instructions to become an Encore Forum Member.

If you are a new member and need help using these forums, please click on the FAQ link at the top of this page.