Beginning from 2nd row you should put the following from leftmost to right, each in separate data cell:
1.Mobile Number: string of digits less than 15 digits long (E.164 format without the '+' sign.)
2.Purchasing Power: number between 0 and 100
3.Gender: either m (male), f (female), or u (unknown)
4.Date Of Birth: a date in yyyy-mm-dd format
5.Keywords: 1 or more keywords represented hierarchically seperated by commas(,). In each keyword use the arrow (->) as a separator between the different levels in the hierarchy.
6.Location: location represented hierarchically. Use the arrow (->) as a separator between the different levels in the hierarchy.
7.Device Type: Device Type represented hierarchically. Use the arrow (->) as a separator between the different levels in the hierarchy.
Note that all the values should
1. be in String format (Text)
2. either '-' or empty cell for unknown values.
3. without any extra spaces
If you want to see an example, export the profiles from the Import/Export tab.
Are there plans to expand the import and export functions of this application, I'm have a database of users and profiles which I can run a query against to provide the results for the excel but I would also be a good feature to do a field mapping from the UPserver to say Drupal, Joomla and Wordpress for example.
What if I would like to do an import directly to the UPserver database, would that break anything in terms of the data's integrity?
No, It won't break anything in terms of the data's integrity. You can do that functionality and we will help you as much as we can in explaining our module and database schemas. One suggestion from my colleague is to use apatar (http://www.apatar.com/) to map between databases. By the way, we opened a new IRC channel (server: "irc.freenode.net" ,channel: "#adhere") if you want to contact us anytime by chatting. Our local time is (GMT + 2).
I am having some challenge with the import from a excel. I have exported and using that excel to do my import, so I have done a test record, however I have to leave the last three (3) columns empty as I was not able to satisfy the format of the record.
Could you assist by completing what I have here with a sample record including that which uses the heirachy feature with ->.
Mobile - 1235555555
Purchasing Power - 100
Gender - m
Date of Birth - 08/08/1978
Keywords -
Location -
Device Type -
To import keywords ,location and device type. you should define them first to the system.
To do this, you select the "manage keywords", "manage locations" and "manage devicetypes" tabs in the leftmost menu and add children to the root node by right clicking on them and choose "add child node".
After you save them in the system, you can import user profiles having those values separated by an arrow (->) between the different levels in the hierarchy. and for Keywords you can add multiple values separated by commas(,).
For example:
you want to add two categories "cars" and "movies" under "keywords". you right click on the "keywords" and add both children by putting their values.
then you want to add some genre or types for each. So you right click on the "cars" node and add children "suv","racing"...& so on.
and in the same manner you add "action", "thriller" under "movies" node.
after adding those nodes suppose you want to import a user that has interest in both "suv" cars and "action" movies. so you put them in the excel corresponding cell in the following format = "cars->suv,movies->action"
Location and devicetypes are imported in the same manner.
Note that all the values are in lower case and that you can not add more than one location and one devicetype for a single user.
My guess is that you are having the javascript on your browser turned off. We are using Yahoo UI Library for the tree model so it won`t work if the javascript is turned off. Please turn it on if it is not, and report us the bug if it is still not working after you turn it on.
That was not the case at all, I was trying to add the Keyword in the wrong section of the app, after Terrrminator pointed that out in IRC we had a good laugh.
How to import Excel files in reporting tool? I used to make report with Excel. As a result, I have had a lot of Excel files. So I wonder how can I import the report styles and data of these Excel files into report with my reporting tool?
I suggest that you configure a few user records manually into the UP Server then export these records to Excel. Observe the format of the Excel file then use the exact same format for all Excel data that you'd like to import to the UP Server.
Re: what is the exact format for excel import?
By rdBeginning from 2nd row you should put the following from leftmost to right, each in separate data cell:
1.Mobile Number: string of digits less than 15 digits long (E.164 format without the '+' sign.)
2.Purchasing Power: number between 0 and 100
3.Gender: either m (male), f (female), or u (unknown)
4.Date Of Birth: a date in yyyy-mm-dd format
5.Keywords: 1 or more keywords represented hierarchically seperated by commas(,). In each keyword use the arrow (->) as a separator between the different levels in the hierarchy.
6.Location: location represented hierarchically. Use the arrow (->) as a separator between the different levels in the hierarchy.
7.Device Type: Device Type represented hierarchically. Use the arrow (->) as a separator between the different levels in the hierarchy.
Note that all the values should
1. be in String format (Text)
2. either '-' or empty cell for unknown values.
3. without any extra spaces
If you want to see an example, export the profiles from the Import/Export tab.
Are there plans to expand the
By dalekurtAre there plans to expand the import and export functions of this application, I'm have a database of users and profiles which I can run a query against to provide the results for the excel but I would also be a good feature to do a field mapping from the UPserver to say Drupal, Joomla and Wordpress for example.
What if I would like to do an import directly to the UPserver database, would that break anything in terms of the data's integrity?
Re: Are there plans to expand the
By rdNo, It won't break anything in terms of the data's integrity. You can do that functionality and we will help you as much as we can in explaining our module and database schemas. One suggestion from my colleague is to use apatar (http://www.apatar.com/) to map between databases. By the way, we opened a new IRC channel (server: "irc.freenode.net" ,channel: "#adhere") if you want to contact us anytime by chatting. Our local time is (GMT + 2).
I am having some challenge
By dalekurtI am having some challenge with the import from a excel. I have exported and using that excel to do my import, so I have done a test record, however I have to leave the last three (3) columns empty as I was not able to satisfy the format of the record.
Could you assist by completing what I have here with a sample record including that which uses the heirachy feature with ->.
Mobile - 1235555555
Purchasing Power - 100
Gender - m
Date of Birth - 08/08/1978
Keywords -
Location -
Device Type -
Re: I am having some challenge
By rdTo import keywords ,location and device type. you should define them first to the system.
To do this, you select the "manage keywords", "manage locations" and "manage devicetypes" tabs in the leftmost menu and add children to the root node by right clicking on them and choose "add child node".
After you save them in the system, you can import user profiles having those values separated by an arrow (->) between the different levels in the hierarchy. and for Keywords you can add multiple values separated by commas(,).
For example:
you want to add two categories "cars" and "movies" under "keywords". you right click on the "keywords" and add both children by putting their values.
then you want to add some genre or types for each. So you right click on the "cars" node and add children "suv","racing"...& so on.
and in the same manner you add "action", "thriller" under "movies" node.
after adding those nodes suppose you want to import a user that has interest in both "suv" cars and "action" movies. so you put them in the excel corresponding cell in the following format = "cars->suv,movies->action"
Location and devicetypes are imported in the same manner.
Note that all the values are in lower case and that you can not add more than one location and one devicetype for a single user.
We just attempt to do that on
By dalekurtWe just attempt to do that on a Linux and Windows System using MSIE and Firefox but we were not able to bring up the right click menu.
Re: We just attempt to do that on
By rdMy guess is that you are having the javascript on your browser turned off. We are using Yahoo UI Library for the tree model so it won`t work if the javascript is turned off. Please turn it on if it is not, and report us the bug if it is still not working after you turn it on.
That was not the case at
By dalekurtThat was not the case at all, I was trying to add the Keyword in the wrong section of the app, after Terrrminator pointed that out in IRC we had a good laugh.
How to import Excel files in
By maryleenHow to import Excel files in reporting tool? I used to make report with Excel. As a result, I have had a lot of Excel files. So I wonder how can I import the report styles and data of these Excel files into report with my reporting tool?
How to import Excel files
By hsalamaHi Maryleen,
I suggest that you configure a few user records manually into the UP Server then export these records to Excel. Observe the format of the Excel file then use the exact same format for all Excel data that you'd like to import to the UP Server.
Regards
Hussein