Go Back   MarcomCentral (PTI) and FusionPro User Communities > Off Topic > Reviews, Rants, and General Musings

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 23rd, 2012, 10:43 AM
rpaterick rpaterick is offline
Senior Contributor
 
Join Date: Mar 2009
Posts: 427
Default Multiple Data files from customer and combining into one

Anyone get in like 10 or more data files for a single job that has no "version," or "tier" column in each data file but the data file is labeled to what "level" of play they should get?

Basically, you have to open each data file, put in the column header and their level of play throughout each record in that database. You can either combine all 10 or so data files together in Excel or during your automated scripting in your postal software. Depends on if you want to just have one data file importing into your postal software or all 10.

This gets pretty tedious.

Now, does anyone know how to automate this step? I'd like to be able to take the names of the data file, have a column header generate, insert their level of play and merge into one data file. Some sort of .bat file to create or scripting perhaps out of excel?

Anyone had this done for them or time/$ it would take?

Thanks!
__________________
Windows 7 64BIT
Intel - I7 chip - 3.33Ghz - 6GB ram
8.0 Creator/8.0 Producer/CS5.5
Reply With Quote
  #2  
Old January 23rd, 2012, 11:43 AM
Dan Korn's Avatar
Dan Korn Dan Korn is offline
FusionPro Senior Engineer / Forum Moderator
 
Join Date: Aug 2008
Location: Chicago, IL
Posts: 4,462
Default Re: Multiple Data files from customer and combining into one

Sounds like a job for ExternalDataFileEx to me. You should be able to access all the data files directly in FusionPro, without having to do any pre-merging in Excel. The Frodo Travel tutorial shows an example of accessing secondary data files, as does this thread:
http://forums.printable.com/showthread.php?t=392

I don't know the details of the job (such as the data file names or the field names) to be able to make specific suggestions, but I would think you could simply select which data file to open based on the "level", which presumably comes from the main input data file for the job. Something like this:
Code:
var levelDataFile = new ExternalDataFileEx(Field("Level") + ".txt", "\t");
Then you can access the ExternalDataFileEx object with its GetFieldValue function to extract the data you need, as in the other examples.
__________________
Dan Korn
FusionPro Developer / JavaScript Guru / Forum Moderator
PTI Marketing Technologies | Printable | MarcomCentral
LinkedIn

I am a not a Support engineer, and this forum is not a substitute for Support. My participation on this forum is primarily as a fellow user (and a forum moderator). I am happy to provide help and answers to questions when I can; however, there is no guarantee that I, or anyone else on this forum, will be able to answer all questions or fix any problems. If I ask for files to clarify an issue, I might not be able to look at them personally. I am not able to answer private messages, emails, or phone calls unless they go through proper Support channels. Please direct any sales or pricing questions to your salesperson or inquiries@marcom.com.

Complex template-building questions, as well as all installation and font questions or problems, should be directed to FusionProSupport@marcom.com. Paid consulting work may be required to fulfill your template-building needs.

This is a publicly viewable forum. Please DO NOT post fonts, or other proprietary content, to this forum. Also, please DO NOT post any "live" data with real names, addresses, or any other personal, private, or confidential data.

Please include the specific versions of FusionPro, Acrobat, and your operating system in any problem reports or help requests. I recommend putting this information in your forum signature. Please also check your composition log (.msg) file for relevant error or warning messages.

Please post questions specific to the MarcomCentral Enterprise and Web-to-Print applications in the MarcomCentral forum. Click here to request access. Or contact your Business Relationship Manager (BRM/CPM) for assistance.

Please direct any questions specific to EFI's Digital StoreFront (DSF) to EFI support.

How To Ask Questions The Smart Way

The correct spellings are JavaScript, FusionPro, and MarcomCentral (each with two capital letters and no spaces). Acceptable abbreviations are JS, FP, and MC (or MCC). There is no "S" at the end of "Expression" or "Printable"! The name of the product is FusionPro, not "Fusion". "Java" is not is not the same as JavaScript.

Check out the JavaScript Guide and JavaScript Reference! FusionPro 8.0 and newer use JavaScript 1.7. Older versions use JavaScript 1.5.

return "KbwbTdsjqu!spdlt\"".replace(/./g,function(w){return String.fromCharCode(w.charCodeAt()-1)});
Reply With Quote
  #3  
Old January 23rd, 2012, 03:27 PM
rpaterick rpaterick is offline
Senior Contributor
 
Join Date: Mar 2009
Posts: 427
Default Re: Multiple Data files from customer and combining into one

Code:
var levelDataFile = new ExternalDataFileEx(Field("Level") + ".txt", "\t");
Then you can access the ExternalDataFileEx object with its GetFieldValue function to extract the data you need, as in the other examples.[/QUOTE]

Thanks for the suggestion Dan.

The problem with this campaign is the data files have to get merged into one file to import into the Postal Software program to run it and then kick-out one data file.

2 screen shots attached. One shows the many data files that customer submits of all it's Tier levels. The other shows a snippet of what the data looks like. I deleted the Account # and their names. But as you can see, there is no column that has the actual tier level in the data file. So I have to open all the data files up, place in a column called version, input the level based on what the data file is called. We could potentially have different artwork for each Tier level also.

Not sure if mail houses have a way to deal with this easily(automating/scripting with) or if this is just the way it is..
Attached Images
File Type: jpg data.jpg (100.0 KB, 18 views)
File Type: jpg data-records.jpg (29.0 KB, 19 views)
__________________
Windows 7 64BIT
Intel - I7 chip - 3.33Ghz - 6GB ram
8.0 Creator/8.0 Producer/CS5.5
Reply With Quote
  #4  
Old January 24th, 2012, 12:00 PM
Dan Korn's Avatar
Dan Korn Dan Korn is offline
FusionPro Senior Engineer / Forum Moderator
 
Join Date: Aug 2008
Location: Chicago, IL
Posts: 4,462
Default Re: Multiple Data files from customer and combining into one

Quote:
Originally Posted by rpaterick View Post
The problem with this campaign is the data files have to get merged into one file to import into the Postal Software program to run it and then kick-out one data file.
Well, that's not really an issue related to the FusionPro composition itself, so I'm not sure it's exactly on-topic for the FP Desktop sub-forum. It might be more appropriate for the Reviews, Rants, and General Musings sub-forum, like your post from last year about Postal One Reports. (Actually, I just went ahead and moved this thread.)

That said, I think you could do something like this in Excel with a VBA macro, and it's fine if someone here on the forum wants to help with that. But there's a point at which you probably want to think about a solution with a real database instead of dealing with text files and Excel.
__________________
Dan Korn
FusionPro Developer / JavaScript Guru / Forum Moderator
PTI Marketing Technologies | Printable | MarcomCentral
LinkedIn

I am a not a Support engineer, and this forum is not a substitute for Support. My participation on this forum is primarily as a fellow user (and a forum moderator). I am happy to provide help and answers to questions when I can; however, there is no guarantee that I, or anyone else on this forum, will be able to answer all questions or fix any problems. If I ask for files to clarify an issue, I might not be able to look at them personally. I am not able to answer private messages, emails, or phone calls unless they go through proper Support channels. Please direct any sales or pricing questions to your salesperson or inquiries@marcom.com.

Complex template-building questions, as well as all installation and font questions or problems, should be directed to FusionProSupport@marcom.com. Paid consulting work may be required to fulfill your template-building needs.

This is a publicly viewable forum. Please DO NOT post fonts, or other proprietary content, to this forum. Also, please DO NOT post any "live" data with real names, addresses, or any other personal, private, or confidential data.

Please include the specific versions of FusionPro, Acrobat, and your operating system in any problem reports or help requests. I recommend putting this information in your forum signature. Please also check your composition log (.msg) file for relevant error or warning messages.

Please post questions specific to the MarcomCentral Enterprise and Web-to-Print applications in the MarcomCentral forum. Click here to request access. Or contact your Business Relationship Manager (BRM/CPM) for assistance.

Please direct any questions specific to EFI's Digital StoreFront (DSF) to EFI support.

How To Ask Questions The Smart Way

The correct spellings are JavaScript, FusionPro, and MarcomCentral (each with two capital letters and no spaces). Acceptable abbreviations are JS, FP, and MC (or MCC). There is no "S" at the end of "Expression" or "Printable"! The name of the product is FusionPro, not "Fusion". "Java" is not is not the same as JavaScript.

Check out the JavaScript Guide and JavaScript Reference! FusionPro 8.0 and newer use JavaScript 1.7. Older versions use JavaScript 1.5.

return "KbwbTdsjqu!spdlt\"".replace(/./g,function(w){return String.fromCharCode(w.charCodeAt()-1)});

Last edited by Dan Korn; January 24th, 2012 at 12:03 PM..
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 04:35 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.