Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some Googling and get back to you if I find an good answer. You should email the people at iPage as they probably could help you..
Thanks for the advise.... I will definatly try that.......
I just did a 'Google' newsgroup search on groups "microsoft.public.excel.*" and looked for 'macro' , and it looks like the one to try is:.
And if no replies there try:.
If you can hang on a couple of days (well, ok, maybe 3 or 4), I might have something that will help..
I'm just finishing off a set of scripts that will let you do all sorts of stuff with easypopulate files like manually split them, split them by category, merge them back again, auto-generate image filename paths from the category (or anything else you like), 'un-auto-generate' filename paths, generate a diff between two files (lists products added, deleted or changed, and generates a list of image files that need to be added/deleted), check for duplicate / blank product numbers, product names, product descriptions, etc etc..
I've tried to make it very flexible so you can just about do what you like with the data. What you describe would be quite easy to do..
There is a drawback ! - If you want to write a new script to do something special, you will need to know some PHP. If you're ok with that, then it might be ok for your needs..
Kewl, PHP I can handle...... Let me know when you have it ready to go!!!.
Fisrt off, please pardon my ignorance on Easy Populate. Now, I'm assuming that EP helps you export from the db, then with maybe some interim 'tricks' to repopulate the data, then EP will allow you to import back into the db..
Considering what Brian said:.
There is a CSV file, and it is not in the EP format, in fact I think Brian said something about having to split the files also. What 'CMOTD' is working on, is to use EP files, isn't it, whereas Brian needs to.
The EP files from the supplier provided CSV ??.
Just trying to understand Brian needs a bit more, that's all..
Also, using Perl is _so_ easy to create and manipulate excel/csv files, if you want to go down that path. See:.
Many ways to do it, eh..
Sorry, I don't think I explained what I was working on well enough..
I see that the problem here is that the field data needs to be moved about to convert it from the supplied csv format into the easypopulate format..
The stuff I'm working on will let you do this too. You can read a csv file, pick out any fields you like by name, jiggle them about to put them in whatever order you want, and write them back to another file..
I just mentioned the file splitting/merging in passing because it was mentioned that such functionality would also be required..
Oh, and yes you're right - this sort of thing is very simple in Perl. In fact, I started writing this in Perl but then thought PHP would be better (for obvious reasons). It's just as easy to do this stuff in PHP too (and besides, I don't like Perl)..
Well, if you are still interested then try "Easypopulate Data File Tools" from the contributions..
Read the README file - the thing you are probably interested in most is the 'import_data' command.
Hope this helps..
Hello everyone.... Okay, here's my problem... I'm using "EasyPopulate" to add/update products in my database... Now, my supplier provides me with a really nice CSV file with all the info required, BUT it's not in the correct format for EasyPopulate.... Now I've basically figured out that I need to create Macro(s) in excel to get everything into the correct format... My problem is that I know absolutly NOTHING about making macros....
Now, my question to you people is this, would someone be willing to make me the macro(s) required to do this for me?.
If you can do it, please let me know what you need, and if you'll charge me for it..... Thanks!!!.
I can only do simple formulaes and lookups, functions in Excel, no experience with macros. However, a macro is simply running functions, scripts,etc, from my understanding..
I have always gone to the 'excel' newsgroups for stuff like this, you will have the solution in no time at all. If the specifications' for the macro are not confidential, post them here and I will add a post on the Excel newsgroups for you..