Thank you. I need to meet this Nemeses of importing head on. I must get a great understanding of it. I have so much to do that requires my mastery this import procedure. It is very important for me.
Along the same vein… My “master list” is in a microsoft excel format. There was a blog that seemed to infer that there is a limitation of “rows” for the Open Office. And the majority of blogs seemed to infer the same thing. Thus when I tried to copy and paste I was not able to do so in large quanties (or even small quantities for that matter) Another note, apparently copying out of the Excel.csv and pasting into “NOTEPad” removes the excess scripts? I am not sure about this because my upload did not work. I am still stuck.
So, I downloaded Libre and opened the Excel.csv in Libre. There were 273,000 rows. Open Office would NOT open.. and Libre would. Fun facts for anyone looking to process more than 63k of rows.
One last point. At one point I forgot to put in the Country Column data of “United States” and the interesting point is “I got an error message”. I inserted the United States into the Country Column and now I do not get anything. It just does not upload. More not so fun facts. I am stuck.
At this point I am willing to “pay” someone to do a screen share… my screen and show me how to get the data on Excel to “work and upload” to my site. I will want to record the process for reference.
Should I post this on the job board or should I wait to find out if someone can point out the problem I am having. So far… I am just not getting it.
Wait! Another thing. This will be the last thing. “Which” .csv file am I suppose to use to import? I would assume it the same one I use to “export” the way I have the Event form set up correct? Otherwise how would all the “custom” field information get uploaded. Or, am I suppose to use the sites pre-formed event.csv?
Kind regards,
Kiran 8 years, 8 months ago.
